求救. 关于VSFTP用mysql作PAM验证。

bubu-kp

vsftp及mysql已成功安装。 匿名用户及本地用户在本机及远程计算机皆能登陆及操作。现在问题是虚拟用户不能登陆。我的配置文件内容如下，望各位大虾帮下小弟看下哪出问题了。先谢了

/etc/pam.d/ftp 文件
#%PAM-1.0
auth required /lib/security/pam_listfile.so item=user sense=deny file=/etc/ftpusers onerr=succeed
auth required /lib/security/pam_pwdb.so shadow nullok
auth required /lib/security/pam_shells.so
account required /lib/security/pam_pwdb.so
session required /lib/security/pam_pwdb.so
auth optional pam_mysql.so user=vsftpdguest passwd=i52serial0 host=localhost db=vsftpdvu table=users usercolumn=name passwdcolumn=passwd crypt=2
account required pam_mysql.so user=vsftpdguest passwd=i52serial0 host=localhost db=vsftpdvu table=users usercolumn=name passwdcolumn=passwd crypt=2


/var/log/messages 文件
Dec 11 17:39:34 RedHat9 PAM_pwdb[3416]: check pass; user unknown
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_sm_authenticate called.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: dbuser changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: dbpasswd changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: host changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: database changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: table changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: usercolumn changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: passwdcolumn changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: crypt changed.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: db_connect called.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: returning 0 .
Dec 11 17:39:34 RedHat9 vsftpd[3416]: db_checkpasswd called.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: where clause =
Dec 11 17:39:34 RedHat9 vsftpd[3416]: SELECT passwd FROM users WHERE name='xiaowang'
Dec 11 17:39:34 RedHat9 vsftpd[3416]: sqlLog called.
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logtable not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logmsgcolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logusercolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but loghostcolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logtimecolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: returning 0 .
Dec 11 17:39:34 RedHat9 vsftpd[3416]: returning 0.

/etc/vsftpd.conf 文件
guest_enable=YES
guest_username=vsftpdguest
listen=YES
anonymous_enable=YES
local_enable=YES
write_enable=YES
local_umask=022
anon_upload_enable=YES
anon_other_write_enable=YES
xferlog_enable=YES
connect_from_port_20=YES
ftpd_banner=Welcome to Test FTP service.
chroot_local_user=YES

麻烦各位了。

bubu-kp

我照文章所写。 一步步安装好了。
vsftpdguest也能列出mysql中的数据库的信息。
又会不会是这个版本mysql-devel-3.23.54a-11.i386.rpm 与我所安装的mysql4.0.16版本不同的原因.

是不是/var/log/messages文件中下面这些的错误啊.

Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logtable not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logmsgcolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logusercolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but loghostcolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: pam_mysql: error: sqllog set but logtimecolumn not set
Dec 11 17:39:34 RedHat9 vsftpd[3416]: returning 0 .
Dec 11 17:39:34 RedHat9 vsftpd[3416]: returning 0.

bubu-kp

问题已解决了. 谢谢