mysql.sock and jailshell

[sparek-3]

When trying to access MySQL databases through the shell, using jailshell, we get the error message

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

There is a mysql.sock file in the /tmp directory and in /home/virtfs/user/tmp .

The server is running FreeBSD 4.9.

[jsteel]

When trying to access MySQL databases through the shell, using jailshell, we get the error message

ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61)

There is a mysql.sock file in the /tmp directory and in /home/virtfs/user/tmp .

The server is running FreeBSD 4.9.

We're having this same issue on RHEL 3.

[dezignguy]

you should probably recreate the mysql.sock file in the tmp directories... you can search the forums her eto find out how to do that... basically you make a symbolic link with

ln -s

[jsteel]

you should probably recreate the mysql.sock file in the tmp directories... you can search the forums her eto find out how to do that... basically you make a symbolic link with

ln -s

Simply doing 'ln -s /var/lib/mysql/mysql.sock /var/tmp/mysql.sock' will not fix the jailshell from properly having the /var/tmp directory.

[jsteel]

It appears the only way to patch it (since the internals of jailshell do not recognize the /var/tmp directory) is to actually:

1) Force the creation of the necessary directory (for every jailshell user):

mkdir /home/virtfs/username/var/tmp

2) Adjust permissions by:

chown root:username /home/virtfs/username/var/tmp

3) Create a symbolic link via:

ln -s /var/lib/mysql/mysql.sock /home/virtfs/username/var/tmp/mysql.sock

This of course is a bit of a hack job but does seem to patch the problem. cPanel though should of course fix the jailshell internals to automatically recognize the /var/tmp directory and the subsequent mysql.sock file under it.

[dezignguy]

Sorry, I missed the jail shell specific part...