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

IT Admin July 30, 2015

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

2 votes
Answer accepted
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 30, 2015

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
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 30, 2015

Is it owned by the same user (jiraadmin)?

IT Admin July 30, 2015

jiradmin is the root account

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 30, 2015

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 July 30, 2015

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 February 22, 2017

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.

Like fimlm likes this
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2017

@Khuong Vu Glad it helped!

Suggest an answer

Log in or Sign up to answer