MySQL DB error while configuring on jira setup

Question

Hi,

I am trying to configure MySQL on Jira setup but I am getting the below error, I have installed JDBC driver on JSD and restarted and everything looks good but still getting the error, please find the 
logs as well.

at java.lang.Thread.run(Thread.java:748)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:299)
... 176 more

Murugan Mittapalli · Answer

Thanks, for your replies, we found the issue, i.e in one of the files configuration in DB so our DB team is able to resolve it.

Thank you once again.

Jason Galea · Answer

Did you telnet the database server using the correct port?

if it doesn't, that might be the issue.

if not, make sure you set the jdbc driver in the correct directory and also check the permissions and ownership to match the other files from that same directory

cheers,
jason

Nic Brough -Adaptavist- · Answer

That really is what it says - the server tries to connect to the database server and gets back "no".  Could be a network issue, could be that the database server is configured to not listen to the server.  You'll need to debug those two problems.