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

*** Connection failed: Could not connect to the DB: Communications link failure

Paulo Tovo

Hi friends.

I installed the Jira version: atlassian-jira-6.1-x32.bin on my server. I have installed de driver mysql version mysql-connector-java-5.1.26, Mysql 5.5.29. I created in the mysql database jiradb, user: jirauser and password. I set the privileges for this user with all flags. When i open the jira web site, i do the configuration for connect with my db mysql but is not work.

When i try to connect directly ion mysql with jirauser on jiradb, its works.

i try to open the ports access in my firewall too but no works.

When i try to config using ./Config.sh (JIRA HOME), when i test the connection, the following error occurs:

Database Selection [M]>

MySql Database Configuration.

Hostname (192.168.0.200)>

Port (3306)>

Database (jiradb)>

Username (jirauser)>

Password (*****)>

Test Connection ([Y]/N)? >

Attempting to connect to 192.168.0.200:3306/jiradb

*** Connection failed: Could not connect to the DB: 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.

Please, help me.

Thanks

Best Regards.

Paulo

Accepted answers

All comments

Chung Park Chan

Did you put the driver into <JIRA installation directory>/lib ?

Paulo Tovo

Hi chung. Yes, i put. I see the atlassian-jira.log and find this:

2013-10-21 08:28:38,013 http-bio-8081-exec-10 ERROR anonymous 508x6x1 xr0n5m 192.168.0.117 /secure/SetupDatabase.jspa [atlassian.co$

com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Its could be driver problem?

Thanks

Chung Park Chan

Looking at the version of the driver, it should be fine

Karim BENHDECH1

I do an upgrade and I have the same problem. No issue for now

Paulo Tovo

Hi, my driver version is mysql-connector-java-5.1.26. is that correct?

Thanks

Paulo Tovo

Hi.

On my JIRA START:

Server startup logs are located in /opt/atlassian/jira/logs/catalina.out

Using CATALINA_BASE: /opt/atlassian/jira

Using CATALINA_HOME: /opt/atlassian/jira

Using CATALINA_TMPDIR: /opt/atlassian/jira/temp

Using JRE_HOME: /opt/atlassian/jira/jre/

Using CLASSPATH: /opt/atlassian/jira/bin/bootstrap.jar:/opt/atlassian/jira/bin/tomcat-juli.jar

Using CATALINA_PID: /opt/atlassian/jira/work/catalina.pid

paulo@highlander:/opt/atlassian/jira/bin$

CLASSPATH is correct? Or i should set the path from the driver mysql?

Thanks

richie_gee

Paulo Tovo,

From the error it seems to be a connection issue rather than a driver issue. I presume that your database server is located at other machine which JIRA tried to reach but unable to get any response from the server.

So items to check is:

Are you able to ping to the machine? Or you can even try telnet to your database with port number see if you are able to connect.
If you have firewall, make sure the port and ip is being whitelist on both machines so that they can communicate with each other.

Raja Putti

Hi guys .... getting error while connecting to JIRA to mysql

please help me out ..... i have installed mysql and JIRA and copy the jdbc connector to <jirahome>/lib folder

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

Raja Putti

getting error while installing mysql

please help on this .....thanks in advance

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-administration