mysql.sock

[VIB-host]

Where is mysql.sock located on a PSA 8.1 and FreeBSD6

 

[webadmin]

MySQL sock

in /tmp as stated at

http://www.google.com/search?q=mysq...s=org.mozilla:en-US:official&client=firefox-a

 

[VIB-host]

Re: MySQL sock

Originally posted by webadmin
in /tmp as stated at

http://www.google.com/search?q=mysq...s=org.mozilla:en-US:official&client=firefox-a

The right answer:
socket=/var/lib/mysql/mysql.sock

Sorry, but this might be the reason why a lot of modules don't work with plesk and FreeBSD

 

[DCoats]

all you do is symlink them
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
freebsd's mysql will use /tmp/mysql.sock but plesk wants
/var/lib/mysql/mysql.sock


# locate mysql.sock
/var/lib/mysql/mysql.sock
# ls -al /var/lib/mysql/mysql.sock
lrwxr-xr-x 1 root mysql 15 Dec 9 09:26 /var/lib/mysql/mysql.sock -> /tmp/mysql.sock

 

[VIB-host]

well... when i add this line to my /etc/my.cnf:

socket=/tmp/mysql.sock

the psa won't start

Plesk authorization failed: malformed response (no 'response=' field).
Error: Plesk Software not running

 

[Whistler]

Originally posted by VIB-host
well... when i add this line to my /etc/my.cnf:

socket=/tmp/mysql.sock

the psa won't start

As DCoats writes - just symlink the file - this will make everything work as expected.

 

[VIB-host]

ls -allh mysql.sock
srwxrwxrwx 1 mysql wheel 0B Dec 16 14:01 mysql.sock

Key file: /usr/local/drweb/drweb32.key - Key file not found!
A path to a valid license key file was not specified.
Plesk authorization failed: malformed response (no 'response=' field).
Error: Plesk Software not running.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

even when i have written socket=/tmp/mysql.sock in the /etc/my.cnf

drwxrwxrwt 9 root wheel 12800 Dec 16 14:07 tmp

 

[DCoats]

all you have to do is create a symlink so that psa will find mysql.sock, why do I have to say this twice?
if you have /tmp/mysql.sock and psa complains it cant find /var/lib/mysql/mysql.sock then

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

or the reverse of that If you need to symlink the other way.