[问题求助]mysql vsftp pam认证无日志 [复制链接]

mysql vsftp pam认证时数据库.里面建的用户无法登陆ftp但是可以使用.本地的用户登陆，并且使用本地用户登录时数据库里面有日志产生，但是使用数据库里面的用户登录时没有任何日志，whyw.hywhy？？？？[成人用品]
1.GIF (44.21 KB.)
下载次数:1
2009-04-28 1.5:16    健康

http://upload.bbs.csuboy.com/Mon_1004/126_6825_25c8086eb3a6d40.gif[/img]健康
2..GIF (34.91 KB)
下载次数:3
2009-04-2.8 15:16.

http://upload.bbs.csuboy.com/Mon_1004/126_6825_ee45692cd0bf42b.gif[/img]            杀毒

您要设置pam_mysql 的log模式

怎么设置？

QUOTE:原帖由 26105957 于 2009-4-28 16:34 发表
怎么设置？

http://bbs.chinaunix.net/viewthread.php?tid=676713

Apr 28 17:06:03 localhost vsftpd: pam_unix(vsftpd:auth): check pass; user unknown
Apr 28 17:06:03 localhost vsftpd: pam_unix(vsftpd:auth): authentication failure; logname= uid=0 euid=0 tty=ftp ruser=redhat rhost=localhost.localdomain
Apr 28 17:06:03 localhost vsftpd: pam_succeed_if(vsftpd:auth): error retrieving information about user redhat

登陆不成功

http://linux.chinaunix.net/bbs/viewthread.php?tid=1097231

这些都看过了

连接数据库的密码和用户对，我使用本地账户登录时tail日志，密码我故意输错的。。会产生下面的日志。
Apr 28 17:16:44 localhost vsftpd: pam_unix(vsftpd:auth): authentication failure; logname= uid=0 euid=0 tty=ftp ruser=admin rhost=193.168.0.204  user=admin
Apr 28 17:16:44 localhost vsftpd: pam_mysql - option verbose is set to "true"
Apr 28 17:16:44 localhost vsftpd: pam_mysql - pam_mysql_close_db() called.
Apr 28 17:16:44 localhost vsftpd: pam_mysql - pam_sm_authenticate() called.
Apr 28 17:16:44 localhost vsftpd: pam_mysql - pam_mysql_open_db() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_open_db() returning 0.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_check_passwd() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_format_string() called
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - SELECT passwd FROM user WHERE name = 'admin'
Apr 28 17:16:45 localhost vsftpd: pam_mysql - SELECT returned no result.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_check_passwd() returning 1.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_sql_log() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_format_string() called
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - pam_mysql_quick_escape() called.
Apr 28 17:16:45 localhost vsftpd: pam_mysql - INSERT INTO log (msg, user, host, rhost, pid, time) VALUES ('AUTHENTICATION FALURE (FIRST_PASS)', 'admin', '127.0.0.1', '193.168.0.204', '5679', NOW())
但是我使用数据库里面的用户也就是redhat时就没有这个日志而是下面的日志
Apr 28 17:06:03 localhost vsftpd: pam_unix(vsftpd:auth): check pass; user unknown
Apr 28 17:06:03 localhost vsftpd: pam_unix(vsftpd:auth): authentication failure; logname= uid=0 euid=0 tty=ftp ruser=redhat rhost=localhost.localdomain
Apr 28 17:06:03 localhost vsftpd: pam_succeed_if(vsftpd:auth): error retrieving information about user redhat
登陆成功没有日志