Importing from Bugzilla gives JDBC driver name error

Bugzilla verson 2.00 on MySQL, JIRA 6.0.6, MySQL-connector-java-gpl-5.1.26

Importing the data into SQL 2008 R2. This worked in earlier versions of JIRA (6.0.3).

You must specify a valid JDBC driver name for the connection to the database.

Error connecting to the database: JDBC driver class not found: com.mysql.jdbc.Driver

Any ideas on how I can get past this? Where can I correct the JDBC driver name since JIRA evidentally has specified it incorrectly by default? Or is this a bug in 6.0.6?

Thanks!

2 answers

Hi Michael,

You'll need to download the MySQL JDBC driver here:

- http://dev.mysql.com/downloads/connector/j

Drop it on the $JIRA_INST/lib directory, and then, restart JIRA after that. Probably the driver has been removed during the upgrade from 6.0.3 -> 6.0.6.

Best regards,
Lucas Timm

I'd be interested to know if _anyone_ has had success importing from Bugzilla into JIRA 6.0.6 using the latest recommended MySQL driver 5.1.26. We're even using an old version of Bugzilla, 2.0.

MySQL Workbench installed on the same server as JIRA connects to the Bugzilla MySQL instance and database without a problem, so it's not host/database/port/user/pw/remote access issues.

Thanks Lucas, however I did that to no avail before posting (note: MySQL version 5.1.26, which is the target of your link). And yes the MySQL driver is not included anymore due to Oracle engulfing MySQL and no longer providing license. Even tried the platform independent verson.

Previously the Bugzilla import worked with JIRA 6.0.3 and 6.0.5, using MySQL JDBC 5.1.25. I've uninstalled 6.0.6 and I'm trying to backpeddle back to that combination.

Hello Michael,

I tested Jira 6.0.6 with Bugzilla 2.22 running on MySQL and I couldn't find any errors - all data was imported successfully. In your case I still think that JIRA cannot find a proper MySQL driver. Please check if you have installed driver correctly. You can find some helpful information in our documentation (Section 2):

- https://confluence.atlassian.com/display/JIRA060/Connecting+JIRA+to+MySQL

Best Regards,

Przemysław Borkowski

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Jira

5 ways you can make the most of Jira Software and Bitbucket Cloud

As part of the Bitbucket product team I'm always interested in better understanding what kind of impact the use of our tools have on the way you work. In a recent study we conducted of software devel...

32 views 0 4
Read article

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