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; } } }

Not able to get mysql work with Jira

Srijiv Dimri

Hi Experts,

I am in the process of install JIRA and integrating mysql with it. I have installed mysql and have configured a user and a database for it that will be used by Jira for communicating with it. I have also installed the mysql-connector-java-5.1.31.tar.gz driver under :-

tar -xvf /home/srjiv/Downloads/mysql-connector-java-5.1.31.tar.gz

cd mysql-connector-java-5.1.31

cp mysql-connector-java-5.1.31-bin.jar /opt/atlassian/jira/lib/

But somehow I am not able to connect and get the below error message

Error connecting to database

Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

Connection refused

Please let me know if I am missing something here.

Appreciate all your help in advance.

Accepted answers

All comments

Nic Brough -Adaptavist-

Connection refused usually means you've not given Jira the right connection details, and/or you haven't granted the Jira user the right to use the database you've created for it.

Tiago Comasseto

Hi Srijiv, the message "Communications link failure" makes me think that there may be an issue with the access to the database. Are JIRA and MySQL installed on the same server or different servers? You may test the connection with the Telnet command (telnet mysql_server_name 3306)

Additionally, you may check if you're able to connect to this database using another software as dbvisualizer to check whether the connection is working.

I hope it helps.

Cheers

Srijiv Dimri

Hi Nic and Tiago , appreciate your quick response, thankyou very much.

Nic , to answer your question, I am absolutely new to mysql. I tried to give user -jiradbuser complete permission for database mysql, but it is throwing an error with incorrect syntax.

Tiago, yes Jira and mysql are running on the same server. When I try to telnet to the mysql server, it is not able to connect

C:\Users\Srijiv>telnet 10.214.10.51 3306

Connecting To 10.214.10.51...Could not open connection to the host, on port 3306

: Connect failed

But if I try to make a connection to the same server on port 8080 (Jira Default Port), it is able to connect.

C:\Users\Srijiv>telnet 10.214.10.51 8080

Connection open

Under /etc/mysql/my.cfg, I have configured the password, port as 3306 for mysql, so I should be able to connect.

Guys, please help me with the mysql commands to give user-jiradbuser complete permission to access the database-mysql.

Appreciate all your help

Nic Brough -Adaptavist-

Definitely the database settings then.

Telnet to the database server on port 3306 failing really does mean it's not listening at all, so it's no surprise that you can't get Jira to connect.

The usual trick for debugging mysql is to use the mysql client to attempt to debug it, if you have that installed as well. However, in this case, mysql simply isn't listening yet, so it's more fundamental than the connection settings.

How are you running mysql server on the box? Are you sure it's running and are you sure it's configured for port 3306?

(As an aside, connecting to 8080 is actually proving that Jira is running there, which I think we already know, it's nothing to do with mysql yet)

Welcome!

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

Quick Links

Find more posts tagged with

jira

sharepoint