Could not find driver with class name: com.mysql.jdbc.Driver

I'm unable to get past the step to test the connection to the mysql database I have configured.  I'm using Ubuntu 14.04

I have the mysql connector .jar file saved in my install directory of /opt/atlassian/jira/lib/ as below in my screen capture in PuTTY

I've tried using both the unzip and jar commands in case the file was still compressed.  

jira1.PNG

2 answers

1 accepted

1 vote

Ah, hang on, sorry, I really should have spotted this earlier.

You have listed the content of /lib.  Not <JIRA install>/lib.  The driver needs to be in there, not the operating system /lib directory.

1 vote

Is it owned by the same user (jiraadmin)?

jiradmin is the root account

That's not what Jobin asked, he was asking you to check file ownership and permissions. An "ls -l" in that directory will tell us what we need (and capture it plain text, there's no need for screenshots) (p.s. No, it's not, root is the root account)

jiradmin@jira:/lib$ ls -l total 1244 drwxr-xr-x 2 root root 4096 Jul 30 09:54 apparmor drwxr-xr-x 3 root root 4096 Jun 19 21:25 com lrwxrwxrwx 1 root root 21 Jul 30 13:31 cpp -> /etc/alternatives/cpp drwxr-xr-x 3 root root 4096 Jul 30 09:51 crda drwxr-xr-x 60 root root 12288 Jul 30 09:51 firmware drwxr-xr-x 2 root root 4096 Jul 30 09:54 hdparm drwxr-xr-x 2 root root 4096 Jul 30 09:51 ifupdown drwxr-xr-x 2 root root 4096 Jul 30 09:51 init -rwxr-xr-x 1 root root 71512 Dec 23 2013 klibc-P2s_k-gf23VtrGgO2_4pGkQgwMY.so lrwxrwxrwx 1 root root 17 Jan 8 2014 libip4tc.so.0 -> libip4tc.so.0.1.0 -rw-r--r-- 1 root root 27392 Jan 8 2014 libip4tc.so.0.1.0 lrwxrwxrwx 1 root root 17 Jan 8 2014 libip6tc.so.0 -> libip6tc.so.0.1.0 -rw-r--r-- 1 root root 31520 Jan 8 2014 libip6tc.so.0.1.0 lrwxrwxrwx 1 root root 16 Jan 8 2014 libiptc.so.0 -> libiptc.so.0.0.0 -rw-r--r-- 1 root root 5816 Jan 8 2014 libiptc.so.0.0.0 lrwxrwxrwx 1 root root 20 Jan 8 2014 libxtables.so.10 -> libxtables.so.10.0.0 -rw-r--r-- 1 root root 47712 Jan 8 2014 libxtables.so.10.0.0 drwxr-xr-x 3 root root 4096 Jul 30 09:51 lsb drwxr-xr-x 3 root root 4096 Jul 30 13:41 META-INF drwxr-xr-x 2 root root 4096 Apr 10 2014 modprobe.d drwxr-xr-x 3 root root 4096 Jul 30 09:51 modules drwxr-xr-x 2 root root 4096 Jul 30 09:54 modules-load.d -rw-r--r-- 1 root root 972009 Jul 30 13:16 mysql-connector-java-5.1.36-bin.jar drwxr-xr-x 3 root root 4096 Jun 19 21:25 org drwxr-xr-x 3 root root 4096 Jul 30 09:51 plymouth drwxr-xr-x 3 root root 4096 Jul 30 09:54 recovery-mode drwxr-xr-x 2 root root 4096 Jul 30 09:51 resolvconf drwxr-xr-x 3 root root 4096 Jul 30 09:54 systemd drwxr-xr-x 15 root root 4096 Jul 30 09:51 terminfo drwxr-xr-x 4 root root 4096 Jul 30 13:31 udev drwxr-xr-x 2 root root 4096 Jul 30 09:54 ufw drwxr-xr-x 4 root root 12288 Jul 30 13:30 x86_64-linux-gnu drwxr-xr-x 2 root root 4096 Jul 30 09:54 xtables

Hi Jobin,

Your suggestion leads me to a solution to the problem, as stated in the title of this topic of discussion.  Everything under my /opt/atlassian/jira/lib folder is owned by root.  So, I stop JIRA and start it up again with sudo:

sudo /opt/atlassian/jira/bin/stop-jira.sh 
sudo /opt/atlassian/jira/bin/start-jira.sh

Thank you Jobin.

@Khuong Vu Glad it helped!

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,338 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot