Missing mysqld.sock
#1
Missing mysqld.sock
I was working on a site yesterday and suddenly I was not able to bring anything up. The command to open the database returned this error message:
Connection failed: No such file or directory

service mysql status gives me this line:
Active: activating (start) since Thu 2025-06-26 15:57:15 EDT; 271ms ago
Not indicating Mysql is running

service mysql start and service mysql restart don't work.

mysql command returns this error message:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

ls -l /var/run/mysqld/mysqld.sock tells me this:
ls: cannot access '/var/run/mysqld/mysqld.sock': No such file or directory

Evidently /var/run/mysqld/mysqld.sock has suddenly disappeared, and I can't find it anywhere on the server!

find / -name mysqld.sock
find: â/proc/385863â: No such file or directory
find: â/proc/385869â: No such file or directory
find: â/proc/385870â: No such file or directory

I run another Sentora server that has the file but it won't let me copy it to my computer in order to transfer to the dead server.
srwxrwxrwx 1 mysql mysql 0 May 6 06:48 mysqld.sock

What a mess!! Any ideas on how to get it back?
Reply
#2
RE: Missing mysqld.sock
(06-27-2025, 06:15 AM)rsthomas Wrote: I was working on a site yesterday and suddenly I was not able to bring anything up.  The command to open the database returned this error message:
    Connection failed: No such file or directory

service mysql status gives me this line:
      Active: activating (start) since Thu 2025-06-26 15:57:15 EDT; 271ms ago
          Not indicating Mysql is running

service mysql start and service mysql restart don't work.

mysql command returns this error message:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'

ls -l /var/run/mysqld/mysqld.sock tells me this:
    ls: cannot access '/var/run/mysqld/mysqld.sock': No such file or directory

Evidently /var/run/mysqld/mysqld.sock has suddenly disappeared, and I can't find it anywhere on the server!

find / -name mysqld.sock
    find: â/proc/385863â: No such file or directory
    find: â/proc/385869â: No such file or directory
    find: â/proc/385870â: No such file or directory

I run another Sentora server that has the file but it won't let me copy it to my computer in order to transfer to the dead server.
    srwxrwxrwx 1 mysql mysql 0 May  6 06:48 mysqld.sock

What a mess!!  Any ideas on how to get it back?

Basic question, but have you completely restarted the server?
This should re-create the missing file on startup.
If after a restart it doesn't work, try service mysql start and immediately check /var/log/syslog and /var/log/mysql/error.log for any mysql startup errors.

Info about the /var/run folder and files:
The files in /var/run (sym-linked to /run folder) are created at startup and holds operating system information and are technically 'not accessable' because they are used and run by the system.
Here is info on the /run and /var/run folders:
Quote:/run
This directory contains information which describes the system since it was booted. Once this purpose was served by /var/run and programs may continue to use it.
Quote:/var/run
Run-time variable files, like files holding process identifiers (PIDs) and logged user information (utmp). Files in this directory are usually cleared when the system boots.
-TGates - Project Council

SEARCH the Forums or read the DOCUMENTATION before posting!
Support Sentora and Donate: HERE

Find my support or modules useful? Donate to TGates HERE
Developers and code testers needed!
Contact TGates for more information
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)