/var/log/secure中提示错误如下:wwwvsftpd:pam_mysql-MySQLerror(Can'tconnecttolocalMySQLserverthroughsocket'/var/lib/mysql/mysql.sock'(13))其他方式连接正常,PHP程序和jsp程序...
/var/log/secure中提示错误如下:
www vsftpd: pam_mysql - MySQL error (Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13))
其他方式连接正常,PHP程序和jsp程序访问数据库没问题,'/var/lib/mysql/mysql.sock' 应该是可用的
pam_mysql版本:pam_mysql-0.7RC1
mysql版本:mysql-5.0.22-2.1
帐户我给了select权限的
+-----------------------------------------------------------------------------+
| Grants for sgftp@% |
+-----------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'sgftp'@'%' IDENTIFIED BY PASSWORD '4b8d125815913755' |
| GRANT SELECT ON `vsftpd`.`users` TO 'sgftp'@'%' |
+-----------------------------------------------------------------------------+
问题已经解决,发现只要套接字连接不成功就报错,pam.d/vsftpd 中的host=localhost 我改为本机的hostname就没问题了
展开