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

[IT Admin]

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

jira1.PNG

[Nic Brough -Adaptavist- · Accepted solution]

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.

[Jobin Kuruvilla [Adaptavist]]

Is it owned by the same user (jiraadmin)?

[IT Admin]

jiradmin is the root account

[Nic Brough -Adaptavist-]

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)

[IT Admin]

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

[Khuong Vu]

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.

[Jobin Kuruvilla [Adaptavist]]

@Khuong Vu Glad it helped!