Jira seems oblivious to the mysql driver jar placed in the <jira_home>/lib directory

[M_V]

Hi everyone, I scrubbed the net for similar issues and did not find anyone in my situation, so i am taking a chance here. Environment: -ubuntu 18.something server (latest to date) -jira installed on it (latest to date) I tried to connect jira to mysql, following the complaints from jira itself (h2 is just for devel/test etc). Unfortunately, when i run the config.sh script as per official documentation, it fails to test-connect to the mysql database, telling me that it can't find the driver. I wget-ed mysql-connector-java-8.0.12.tar.gz and took out the contents to the appropriate place. The driver (.jar file) is in place as far as i know (/var/atlassian/application-data/jira/lib) with exec rights for everyone. Actually all the .jar files from the driver package are there as a result of my trials, but i don't think that would be an issue. I found it odd that the lib folder did not already exist though. Anybody had any issue like this? I tried restarting the jira service. No dice. All the related issues i found were about the jar not in the correct place but those fixes do not work for me. I'd love your input on this. Thank you in advance!

[Steven F Behnke · Accepted solution]

The driver was placed in the wrong folder. There is two main directories -- 

• Installation Directory (default `/opt/atlassian/jira/`)
• Home Directory (default `/var/atlassian/application-data/jira/`)

You must place this in the installation directory. NOT the home directory.

[M_V]

Thank you very much for that one. The missing "lib" folder should have been a good hint...

That fixed my issue.

I owe you a few virtual beers!

Now I get the    " Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. [...] "

Just my luck...

[Steven F Behnke]

The instructions on this page: https://confluence.atlassian.com/adminjiraserver073/connecting-jira-applications-to-mysql-861253043.html Should guide you to the specifically right driver download. 

[Steven F Behnke]

If you are ever in Los Angeles, I'll take you up on some real beers. :) 🍻

[M_V]

I already found what i think is the solution here, but I was  following your suggestion. Thank you for the help!

Regarding the beers, be sure I will! 🍻

[Steven F Behnke]

👍