Hi all, I'm experiencing troubles with the configuration of using pam_mysql for vsftpd. I've created a database called 'ftp' containing a 'user' table consisting of two columns: 'username' and 'password'. The latter contains encrypted passwords using the mysql password() function. The user table contains a single record with username 'test' and password 'test' (though encoded). Doing the following: *** # ftp 127.0.0.1 http://127.0.0.1 Connected to localhost. 220 (vsFTPd 1.2.0) Name: test 331 Please specify the password. Password: 530 Login incorrect. ftp: Login failed. ftp> ^D 221 Goodbye. *** As you can see it fails. However... the mysql select statement worked fine. The problem is as follows (considering /var/log/messages): *** Sep 18 14:40:22 Srv vsftpd: pam_mysql - SELECT password FROM user WHERE username = 'test' Sep 18 14:40:22 Srv vsftpd: pam_mysql - pam_mysql_sql_log() called. Sep 18 14:40:22 Srv vsftpd: pam_mysql - pam_mysql_sql_log() returning 0. Sep 18 14:40:22 Srv vsftpd: pam_mysql - pam_mysql_check_passwd() returning 0. Sep 18 14:40:22 Srv vsftpd: pam_mysql - pam_sm_authenticate() returning 0. Sep 18 14:40:22 Srv PAM-warn[11642]: function=[pam_sm_acct_mgmt] service=[vsftpd] terminal=[] user=[test] ruser=[] rhost=[127.0.0.1http://127.0.0.1 ] Sep 18 14:40:22 Srv vsftpd[11642]: pam_mysql - pam_mysql_release_ctx() called. Sep 18 14:40:22 Srv vsftpd[11642]: pam_mysql - pam_mysql_destroy_ctx() called. Sep 18 14:40:22 Srv vsftpd[11642]: pam_mysql - pam_mysql_close_db() called. *** The PAM-warn statement is what bugs me. When I add a new user using 'useradd test' (without password) I can make use of the ftp login providing my test/test account from the db. I cannot login passing an other password. I would like to decouple the pam_mysql stuff completely from the linux account management. PAM should just stop at the succesful mysql authentication. I want to be able to insert ftp users in my database, not adding actual linux accounts. My /etc/pam.d/vsftpd contains the following: *** #%PAM-1.0 auth required pam_mysql.so \ verbose=1 user=xxx passwd=xxx db=ftp table=user \ usercolumn=username passwdcolumn=password \ crypt=2 *** Hope anyone has any ideas. Cheers, Sander