Tom Brown
2008-Mar-21 22:07 UTC
[CentOS] CentOS 5.1 - MySQL 5.0.22 - Courier auth lib problem
Hi I am finishing my mail server config and just trying to get the mysql login working - it fails to connect and thorws the following error Mar 21 21:58:21 mail0 authdaemond: failed to connect to mysql server (server=localhost, userid=courier): Can't connect to local MySQL server through socket '/tmp/mysql.sock.' (2) Mar 21 21:58:21 mail0 couriertcpd: LOGIN FAILED, user=tom at xxx.xxx, ip=[::ffff:192.168.10.200] Mar 21 21:58:21 mail0 couriertcpd: authentication error: Input/output error The socket exists # ll /tmp/mysql.sock srwxrwxrwx 1 mysql mysql 0 Mar 21 21:53 /tmp/mysql.sock and mysql seems to be working fine using the same credentials # mysql -S /tmp/mysql.sock -u courier -pxxxxxx Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 to server version: 5.0.22 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> some bits from the my.cnf [client] port = 3306 socket = /tmp/mysql.sock [mysqld] port = 3306 datadir = /var/lib/mysql socket = /tmp/mysql.sock any ideas as i am a bit stumped thanks
Tom Brown
2008-Mar-21 23:43 UTC
[CentOS] CentOS 5.1 - MySQL 5.0.22 - Courier auth lib problem
> > > I am finishing my mail server config and just trying to get the mysql > login working - it fails to connect and thorws the following error > > Mar 21 21:58:21 mail0 authdaemond: failed to connect to mysql server > (server=localhost, userid=courier): Can't connect to local MySQL > server through socket '/tmp/mysql.sock.' (2) > Mar 21 21:58:21 mail0 couriertcpd: LOGIN FAILED, user=tom at xxx.xxx, > ip=[::ffff:192.168.10.200] > Mar 21 21:58:21 mail0 couriertcpd: authentication error: Input/output > error > > The socket exists > > # ll /tmp/mysql.sock > srwxrwxrwx 1 mysql mysql 0 Mar 21 21:53 /tmp/mysql.sock > > and mysql seems to be working fine using the same credentials > > # mysql -S /tmp/mysql.sock -u courier -pxxxxxx > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 7 to server version: 5.0.22 > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> > > some bits from the my.cnf > > [client] > port = 3306 > socket = /tmp/mysql.sock > > [mysqld] > port = 3306 > datadir = /var/lib/mysql > socket = /tmp/mysql.sock > > any ideas as i am a bit stumpedin the end i resolved this by removing the use of sockets from authdaemond and used tcp connections instead
Maybe Matching Threads
- I need some help with my Dovecot and Postfix configs - I'm unable to log in on my mail server
- Server resources consumption prevention
- centos + kswapd0 error
- I need some help with my Dovecot and Postfix configs - I'm unable to log in on my mail server
- Bug#446310: setting package to logcheck-database logtail logcheck, tagging 452879, tagging 450660, tagging 450697 ...