Can't connect .... socket '/tmp/mysql.sock': Any Ideas

[vincent]

Hi Folks,
Any ideas as to what could be causing these errors found in the zmdc.log log file:

Server starting at 03/11/25 00:48:45
'zmc -d 0' starting at 03/11/25 00:48:48, pid = 8483
'zmc -d 0' started at 03/11/25 00:48:48
Can't connect to server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
'zmc -d 0' crashed at 03/11/25 00:48:48, exit status 210
'zmc -d 0' starting at 03/11/25 00:48:48, pid = 8484
'zmc -d 0' started at 03/11/25 00:48:48
Can't connect to server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
'zmc -d 0' crashed at 03/11/25 00:48:48, exit status 210
'zmfilter.pl -m 1 -e -1' starting at 03/11/25 00:48:48, pid = 8488
'zmfilter.pl -m 1 -e -1' started at 03/11/25 00:48:48
'zmaudit.pl -d 900 -y' starting at 03/11/25 00:48:49, pid = 8493
'zmaudit.pl -d 900 -y' started at 03/11/25 00:48:49
'zmwatch.pl' starting at 03/11/25 00:48:50, pid = 8499
'zmwatch.pl' started at 03/11/25 00:48:50
Starting pending process, zmc -d 0
'zmc -d 0' starting at 03/11/25 00:48:53, pid = 8505
'zmc -d 0' started at 03/11/25 00:48:53
Can't connect to server: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
'zmc -d 0' crashed at 03/11/25 00:48:53, exit status 210
'zmfilter.pl -m 1 -e -1' crashed at 03/11/25 00:48:55, exit status 2
'zmfilter.pl -m 1 -e -1' starting at 03/11/25 00:48:55, pid = 8508
'zmfilter.pl -m 1 -e -1' started at 03/11/25 00:48:55
'zmfilter.pl -m 1 -e -1' crashed at 03/11/25 00:49:01, exit status 2
'zmfilter.pl -m 1 -e -1' starting at 03/11/25 00:49:01, pid = 8519
'zmfilter.pl -m 1 -e -1' started at 03/11/25 00:49:01
Starting pending process, zmc -d 0
'zmc -d 0' starting at 03/11/25 00:49:03, pid = 8522


I am able to log into the zone manager portal and add a new camera (but cant get camera to render images). I can modify the cameras properties via the portal also... I am using the latest version of zone manager (zm-0.9.16) and red hat 8.0. Any ideas would be well received.

-Vincent

PS the file /tmp/mysql.sock does not exist but a file /tmp/zmdc.sock does! I have tried creating a soft link from /tmp/mysql.sock to /tmp/zmdc.sock but this did not solve the problem.

[zoneminder]

Hi Vincent,

Is /tmp/mysql.sock is not there then it is possible that mysql is not running. Can you do a ps and see if it is. If not then try doing 'service mysqld start' (it might be mysql and not mysqld). It is also possible that the mysql.sock file is elsewhere as this happens occasionally. Do a 'locate mysql.sock' and if it appears elsewhere either reconfigure the mysql libraries to look elsewhere or (easier) do a soft link of it to /tmp.

Phil,

[vincent]

Thanks Philip,
Yes, the mysql.sock was located in another directory. Thanks for the help.
-Vincent