Jira Server startup: Database: Missing Database Driver

[Youkang Shon]

I do not have MySQL driver, and I have created a Jira server with a setup that they create for me instead of custom set up. Now I cannot open my server with an error saying "We couldn't find a driver for your MySQL database. You'll need to download and install the correct driver to allow JIRA to start and connect to your database.
Review our documentation for more information on installing database drivers." So I did download the drivers and put it in the lib folder and it is still giving me the same error. How do I fix this? If there isn't any way, how can I restart? I am using the server in Mac OS (Java installed).

[Thomas Deiler]

Dear @Youkang Shon,

it depends also on the right driver version. Have a look at my article and follow my instructions there.

So long

Thomas

[Youkang Shon]

Thank you, but I'm using Mac OS version so I can't seem to follow your instructions directly.

[Thomas Deiler]

Just download the version from the Maven Repo and place the driver in the folder 'lib' of your Jira directory (not the Jira Home folder).

[Youkang Shon]

I just downloaded the version and placed it in the folder, but it still doesn't work :(

[Thomas Deiler]

Have you removed the other version? Only one JAR of type mysql driver should be inside. Otherwise the Java class loader takes the first it can find. 

[Youkang Shon]

Yes I did. I also restarted the instance and still has not fixed the problem.

[Thomas Deiler]

Can you paste parts of your catalina.out - lines with ERROR or WARN are most interesting.

[Youkang Shon]

2018-05-24 16:50:06,488 JIRA-Bootstrap ERROR [c.a.plugin.loaders.ScanningPluginLoader] Unable to deploy plugin 'com.atlassian.plugins.jquery' from 'Unit: /Users/youkangshon/Desktop/atlassian-jira-software-7.9.2-standalone/atlassian-jira/WEB-INF/atlassian-bundled-plugins/jquery-1.7.2.1.jar (1525856964000)'.
2018-05-24 16:50:06,489 JIRA-Bootstrap ERROR [c.a.plugin.loaders.ScanningPluginLoader] Because of the following exception:
java.lang.IllegalStateException: Unable to create a tracker when osgi is not running

I see this error message a lot

[Youkang Shon]

I'm also getting these error messages:

2018-05-24 16:59:39,215 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] We haven't been able to start all the required system plugins
2018-05-24 16:59:39,216 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] We couldn't start the following plugins:
- com.atlassian.plugin.jslibs (com.atlassian.plugin.jslibs)

2018-05-24 16:59:39,368 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from /Users/youkangshon/Desktop/JiraHome/dbconfig.xml
2018-05-24 16:59:39,389 JIRA-Bootstrap INFO [c.a.j.instrumentation.external.DatabaseExternalGauges] Installing DBCP monitoring instruments: DatabaseExternalGauges.JiraDbcpInstruments[instruments=[DBCP_MAX, DBCP_ACTIVE, DBCP_IDLE],objectName=com.atlassian.jira:name=BasicDataSource]
2018-05-24 16:59:39,425 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] Running JIRA startup checks.
2018-05-24 16:59:39,426 JIRA-Bootstrap FATAL [c.a.jira.startup.JiraStartupLogger] Startup check failed. JIRA will be locked.
2018-05-24 16:59:39,520 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 162 MiB. Committed: 483 MiB. Max: 741 MiB
Non-heap memory : Used: 62 MiB. Committed: 64 MiB. Max: 1264 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 224 MiB. Committed: 547 MiB. Max: 2005 MiB
---------------------------------------------------------------------------------
2018-05-24 16:59:39,520 localhost-startStop-1 INFO [c.a.jira.startup.DefaultJiraLauncher] Stopping launchers
2018-05-24 16:59:39,524 localhost-startStop-1 ERROR [o.a.c.c.C.[Catalina].[localhost].[/]] Exception sending context destroyed event to listener instance of class com.atlassian.jira.startup.LauncherContextListener
java.lang.NullPointerException
at com.atlassian.jira.startup.ClusteringLauncher.stop(ClusteringLauncher.java:46)
at com.atlassian.jira.startup.DefaultJiraLauncher.stop(DefaultJiraLauncher.java:197)
at com.atlassian.jira.startup.LauncherContextListener.contextDestroyed(LauncherContextListener.java:211)
at org.apache.catalina.core.StandardContext.listenerStop(StandardContext.java:4774)
at org.apache.catalina.core.StandardContext.stopInternal(StandardContext.java:5411)
... 3 filtered
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
24-May-2018 16:59:39.552 INFO [main] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["http-nio-8080"]
24-May-2018 16:59:39.552 INFO [main] org.apache.coyote.AbstractProtocol.destroy Destroying ProtocolHandler ["http-nio-8080"]

[Youkang Shon]

 I got it to work! I just had to shut down my computer and restart.

[Thomas Deiler]

Dear @Youkang Shon,

fine! Seems that this issue is related to Mac OS and/or Java. Have you used any installer? Probably some environment variables were set when rebooting and not before.

So long

Thomas

[Aleksandr Zuevich]

Hi,

Have you restarted your Jira instance after putting driver to the lib folder?

[Youkang Shon]

Yes, I have. When I shutdown Jira, i no longer get a message of Tomcat has ended. I get a message of: 

PID file found but no matching process was found. Stop aborted.