MySQL Access in Jailkit [Debian 9 + ISPconfig3]

zendo_vysn

I having some issues enabling mysql support for jailkit environment. I need to allow my clients to run some PHP commands to make changes to their wesbites.

This is the error I get when running from the jailed user:

$mysqladmin ping         
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

I have tested it in several ways:
$ nano /etc/jailkit/jk_init.ini

[mysql_client]
comment = mysql client
executables = /usr/bin/mysql, /usr/bin/mysqladmin, /usr/bin/mysqlcheck, /usr/bin/mysqldump, /usr/bin/mysqlhotcopy, /usr/bin/mysql$
paths = /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18.0.0, /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18, /usr/lib/x86_64-linux$
regularfiles = /etc/mysql/my.cnf

$ jk_init -c /etc/jailkit/jk_init.ini -f -k -j /var/www/clients/client1/web1 mysql_client

and

$ jk_cp  -f -v -j /var/www/clients/client1/web1/ /var/run/mysqld

/var/run/mysql/mysqld.sock Had to copy this manually to the jailed user as otherwise the environment just doesn't find it. Permission are set to 777 and mysql:mysql

zendo_vysn

Changed my config to use 127.0.0.1 instead of localhost and MySQL works well now.