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.
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.
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
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
CLASSPATH is correct? Or i should set the path from the driver mysql?
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:
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.
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot