Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

MySQL DB error while configuring on jira setup

Murugan Mittapalli September 21, 2020

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 DB-2.PNG 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

 

 

 

 

 

3 answers

0 votes
Murugan Mittapalli September 27, 2020

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.

0 votes
Jason Galea
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 21, 2020 edited

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

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 21, 2020

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.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira cloud certification, managing jira projects, jira project administration, jira cloud exam, atlassian certification, agile project management, jira workflows, jira permissions, jira training, jira cloud skills, atlassian learning

Become a Certified Jira Service Project Expert 🦸🏻‍♂️

Validate your expertise in managing Jira Service Projects for Cloud. Master configuration, optimize workflows, and manage users seamlessly. Earn global 🗺️ recognition and advance your career as a trusted Jira Service management expert.

Get Certified! ✍️
AUG Leaders

Atlassian Community Events