i am trying to use pam mysql to authenticate vsftpd user. basically when i try to authenticate against the table with password encrypted with PASSWORD() built in mysql. it work!
auth required pam_mysql.so user=root passwd=**** host=localhost db=dbtest table=user usercolumn=user_name passwdcolumn=user_password crypt=2 account required pam_mysql.so user=root passwd=**** host=localhost db=dbtest table=user usercolum=user_name passwdcolumn=user_password crypt=2 now the password is encrypted with mysql MD5() function auth required pam_mysql.so user=root passwd=**** host=localhost db=dbtest table=user usercolumn=user_name passwdcolumn=user_password crypt=3 account required pam_mysql.so user=root passwd=**** host=localhost db=dbtest table=user usercolum=user_name passwdcolumn=user_password crypt=3 but it doesn't work. digging into /var/log/auth.log vsftpd: pam_mysql - non-crypt()ish MD5 hash is not supported in this build. anyone know how to fix this? i am using debian etch.