pam_mysql怎么用_pam_mysql连接mysql数据库问题

/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就没问题了

展开