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