我的vsftpd的虚拟用户怎么也登陆不上?请大家教我,谢谢!

hfqaz

Sep 15 10:48:45 FILE network: Bringing up loopback interface:  succeeded
Sep 15 10:48:47 FILE network: Bringing up interface eth0:  succeeded
Sep 15 10:50:26 FILE sshd(pam_unix)[2452]: session opened for user ffff by (uid=0)
Sep 15 10:50:30 FILE su(pam_unix)[2479]: session opened for user root by ffff(uid=500)
Sep 15 10:52:59 FILE sshd(pam_unix)[2535]: session opened for user ffff by (uid=0)
Sep 15 10:53:04 FILE su(pam_unix)[2562]: session opened for user root by ffff(uid=500)
Sep 15 10:53:57 FILE vsftpd: pam_sm_authenticate called.
Sep 15 10:53:57 FILE vsftpd: dbuser changed.
Sep 15 10:53:57 FILE vsftpd: dbpasswd changed.
Sep 15 10:53:57 FILE vsftpd: host changed.
Sep 15 10:53:57 FILE vsftpd: database changed.
Sep 15 10:53:57 FILE vsftpd: table changed.
Sep 15 10:53:57 FILE vsftpd: usercolumn changed.
Sep 15 10:53:57 FILE vsftpd: passwdcolumn changed.
Sep 15 10:53:57 FILE vsftpd: crypt changed.
Sep 15 10:53:57 FILE vsftpd: db_connect  called.
Sep 15 10:53:57 FILE vsftpd: returning 0 .
Sep 15 10:53:57 FILE vsftpd: db_checkpasswd called.
Sep 15 10:53:57 FILE vsftpd: pam_mysql: where clause =
Sep 15 10:53:57 FILE vsftpd: SELECT passwd FROM users WHERE name='hfcy'
Sep 15 10:53:57 FILE vsftpd: pam_mysql: select returned more than one result
Sep 15 10:53:57 FILE vsftpd: returning 7 after db_checkpasswd.
Sep 15 10:54:15 FILE vsftpd: pam_sm_authenticate called.
Sep 15 10:54:15 FILE vsftpd: dbuser changed.
Sep 15 10:54:15 FILE vsftpd: dbpasswd changed.
Sep 15 10:54:15 FILE vsftpd: host changed.
Sep 15 10:54:15 FILE vsftpd: database changed.
Sep 15 10:54:15 FILE vsftpd: table changed.
Sep 15 10:54:15 FILE vsftpd: usercolumn changed.
Sep 15 10:54:15 FILE vsftpd: passwdcolumn changed.
Sep 15 10:54:15 FILE vsftpd: crypt changed.
Sep 15 10:54:15 FILE vsftpd: db_connect  called.
Sep 15 10:54:15 FILE vsftpd: returning 0 .
Sep 15 10:54:15 FILE vsftpd: db_checkpasswd called.
Sep 15 10:54:15 FILE vsftpd: pam_mysql: where clause =
Sep 15 10:54:15 FILE vsftpd: SELECT passwd FROM users WHERE name='xxx'
Sep 15 10:54:15 FILE vsftpd: returning 7 .
Sep 15 10:54:15 FILE vsftpd: returning 7 after db_checkpasswd.

hfqaz

最后解决了.问题是用户密码的加密格式问题:
/etc/pam.d/vsftpd内容:

auth required /lib/security/pam_mysql.so user=ftpd passwd=123456 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0
account required /lib/security/pam_mysql.so user=ftpd passwd=123456 host=localhost db=ftpd table=user usercolumn=name passwdcolumn=passwd crypt=0

可以查询mysql数据库类的明码用户:
insert into users (name,passwd) values ('xiaotong','qqmywife');


但是/etc/pam.d/vsftpd中的 crypt=2 ,
和insert into users (name,passwd) values ('xiaotong',password('qqmywife')); 建立的用户就无法登陆

这是为什么???