nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Cannot connect to MySQL with JIRA Confi tool

Zachary Thomas

Hi, my team has been using JIRA server for about a year now, and we are trying to switch from HSQLDB to mysql (we're still on v 6.4, but are trying to make this database change prior to upgrading to 7.0). I've followed the instructions online, but when I try to use the jira configuration tool to test my connection, I also get an error that says the following :

Attempting to connect to the MySQL database server...
Could not connect to the DB: Unknown database 'localhost:3306/jiradb'

I also used MySQL workbench to make sure that all of my database information was set up correctly.

Can someone please help me?

We really want to make this switch so that we can upgrade to one of the more recent versions of JIRA.

Thanks

Zach Thomas

Accepted answers

All comments

Brant Schroeder

Zachary,
I am assuming that you are running JIRA and the DB on the same server. Try using the IP of the DB server and not localhost. Depending on the OS you are running your server on you might have local firewall rules to change. You could have network firewall rules as well. Best of luck.

Suhas P

Use FQDN or IP instead of localhost.

Zachary Thomas

I tried using my IP address instead of localhost and I got a new error.

Attempting to connect to the MySQL database server...
Could not connect to the DB: Access denied for user 'pljiraadmin'@'localhost' (using password: YES)

I also noticed that the jira configuration tool wrote a message on the command prompt when my connection failed which says:

WARN: Establing SLL connection without server's identity verification is not recommended. According to MySql 5.5.45+, 5.6.26+ AND 5.7.6+ requirements SLL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SLL the verifyServerCertficate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

I also tried disabling the firewall to see if that made any difference and it did not.

I checked the firewall rules as well when it is on, and there are no rules prohibiting connection.

Thanks

Zach Thomas

Brant Schroeder

The error that you provided gives you two solutions. I would try disabling SSL first by adding useSSL=false to you connection string. If you are able to connect and everything is working then you know that your have to add the server cert to you truststore. Let me know the outcome of disabling SSL.

Zachary Thomas

Hi Brant,

I switched the ssl to off in the workbench. I don't have access to a connection string to add the useSSL command. I've attached screen shots to show my entries into the Jira Configuration tool and data from the workbench.

Thanks

Zach Thomas jira config tool screenshot.jpg mysql advanced info.jpg mysql connection info.png mysql ssl info.jpg mysql workbench.jpg

Brant Schroeder

What was the outcome of not using SSL?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software