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

JIRA can't connect to mySQL under CentOS

Daniel Broz

Dear All,

After restarting the Machine, JIRA wouldn't connect to mySQL Database anymore. If i try to connect manually, the output says the following:

ERROR 2002 (HY000): Can't connect to local MySQL Server through Socket '/var/lib/mysql/mysql.sock' (111)

I haven't changed anything. Only shutdown, then making an Image of the Machine and after that booting up.

Can anyone help me?

Best Regards,

Daniel Broz

Accepted answers

All comments

Nic Brough -Adaptavist-

Usually means mysql isn't running.

Try logging into the database using the mysql client tools to verify that.

codelab expert

Please post your dbconfig.xml. Perhaps there is a configuration error.

Daniel Broz

@Nic Brough:

I have tried the connection manually over the mysql Client:

mysql -h localhost -u user -p

But it fails with the output above. Could it be something with localhost and the address 127.0.0.1?

@Mathias Liefke:

This is my config.xml:

codelab expert

Please check the basedir in /etc/my.cnf. Try to comment out the basedir setting and restart your mysql service.

Nic Brough -Adaptavist-

Oops. I forgot. Can you check that MySQL is actually running? You get that error a lot when it's not running. Try "ps -ef | grep -i my"

Possibly, but I'm not sure. Could you also try

mysql -h 127.0.0.1 -u user -p

And

mysql -h ::1 -u user -p

And check the error messages carefully.

(Your Jira config looks absolutely fine, this is a problem with mysql connecting locally. It's a lot easier to debug with the mysql client than Jira)

Daniel Broz

I have resolved the Issue.

Others with the same Problem, should do the followinig:

1. Rename "mysql.sock" to "mysql.sock.bak" (/var/lib/mysql)

2. Start the Service again: "service mysqld start"

3. Try to connect: mysql -h localhost -u user -p

4. Be happy! :-)

But one Thing you have to do additional. If you get the Message, that Jira is locked, you have to delete the File ".jira-home.lock" at the Jira Home Folder. Finally you have to restart the Server and all is fine again.

Bruna Griebeler

Hi Daniel,

Although they are important, indeed this sock and lock files are a nightmare sometimes.

Thanks for sharing your resolution with us!

Cheers!

Welcome!

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

Quick Links

Find more posts tagged with

jira

mysql

centos

database-connection