[Case 105565] recreate /tmp/mysql.sock on mysql restart

[simonas]

Hello everybody,

With the latest update (Cpanel version: 11.44.0 (build 17)) one of my server's began having problem - system could not connect to the mysql.

Cron <[email protected]> /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache

Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 140

Also MODSEC:

/etc/cron.hourly/modsecparse.pl:

DBI connect('modsec:localhost','modsec',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /etc/cron.hourly/modsecparse.pl line 20
Unable to connect to mysql database at /etc/cron.hourly/modsecparse.pl line 20.

After investigating with the help of Cpanel, we found that

MySQL no longer automatically re-creates symlink if it's not present.

And openened inquiry (#105565).

Quick solution would be add to you /etc/my.cnf:

[client]
socket=/var/lib/mysql/mysql.sock

Or create symlink. Mods, please update this thread. Thanks.

 

[cPanelMichael]

Hello

Internal case number 105565 is open to inquire if /tmp/mysql.sock should be recreated after MySQL restarts. I will update this thread with more information as it becomes available. In the meantime, manually creating the symbolic link is a valid workaround if it does not exist:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

Thank you.

 

[jayrex]

Hello

Internal case number 105565 is open to inquire if /tmp/mysql.sock should be recreated after MySQL restarts. I will update this thread with more information as it becomes available. In the meantime, manually creating the symbolic link is a valid workaround if it does not exist:

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

Thank you.

I believe I have the same type of problem:

Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 140 Error while connecting to MySQL: Cpanel::DBI::Mysql connect('','root',...) failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) at /usr/local/cpanel/Cpanel/Mysql.pm line 140 ...caught

Could someone let me know if this can be fixed?

I won't be able to fix this myself as I'm not technical, but it looks like an automatic update created this error, will cPanel bring out another update to fix this error?

 

[cPanelMichael]

Did you try running the command referenced in my previous post?

Thank you.