ProFTPD MySQL problem

[vanneto]

Hello everyone,

I have just configured proftpd to work with mysql for a backend. There is only one problem, whenever ProFTPD tries to connect to the MySQL server, this error is returned:

May 31 13:16:55 mod_sql/4.2.2[9246]: unrecoverable backend error
May 31 13:16:55 mod_sql/4.2.2[9246]: error: '2002'
May 31 13:16:55 mod_sql/4.2.2[9246]: message: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

But the weird thing is, phpMyAdmin and my CMS can connect to the database just fine. But proftpd gets this error. I also get this error when trying to connect via mysql client and ssh:

$ mysql -u root -p

Does anyone have an idea what could be wrong?

Thank you

 

[scsi]

Does the socket exist in that location?

ls -la /var/run/mysqld/mysqld.sock

Sometimes the socket file is in a different location like /tmp/mysqld.sock