mysql & pam problem - was "vsftpd and mysql (pam problem?)"

[Luca Ferrari]

On Friday 26 October 2007 Luca Ferrari's cat, walking on the keyboard, wrote:
> Hi all,
> I've followed line by line the instruction to configure vsftpd for using
> accounts coming up from a mysql database here:
> http://www.howtoforge.com/vsftpd_mysql_debian_etch_p2
>


After enabling the verbose mode of the pam I found in the logs the following:
Oct 29 15:20:05 ftp vsftpd: pam_mysql - SELECT pass FROM accounts WHERE 
username = 'test'
Oct 29 15:20:05 ftp vsftpd: pam_mysql - pam_mysql_sql_log() called.
Oct 29 15:20:05 ftp vsftpd: pam_mysql - pam_mysql_sql_log() returning 0.
Oct 29 15:20:05 ftp vsftpd: pam_mysql - pam_mysql_check_passwd() returning 6.
Oct 29 15:20:05 ftp vsftpd: pam_mysql - pam_sm_authenticate() returning 7.
Oct 29 15:20:05 ftp vsftpd: pam_mysql - pam_mysql_release_ctx() called.
Oct 29 15:20:05 ftp vsftpd: pam_mysql - pam_mysql_destroy_ctx() called.
Oct 29 15:20:05 ftp vsftpd: pam_mysql - pam_mysql_close_db() called.


now, since the ftp server is still responding with 530 error, I think the 
problem is in the fact that pam_mysql_check_passwrd returns 6 and 
authenticate returns 7, but I'm not sure. Anyone has an idea?

Thanks,
Luca