[Pam-mysql-general] 0.6.0/0.7.0(pre) not working - tried md5/plain

[Terry <td...@gm...>]

My goal is to use md5. Here are some details:

Linux hostname 2.6.8-1um #1 Tue Jun 21 20:41:51 CDT 2005 i686 i686 i386=20
GNU/Linux
mysql-4.1.10a-1.RHEL4.1
mysql-server-4.1.10a-1.RHEL4.1
pam-0.77-65.1

auth required pam_nologin.so
auth sufficient pam_stack.so service=3Dsystem-auth
auth sufficient pam_mysql.so user=3Duser passwd=3Dpass db=3Ddb table=3Dtabk=
e=20
usercolumn=3Dusername passwdcolumn=3Dpassword crypt=3D0 verbose=3D1
account sufficient pam_stack.so service=3Dsystem-auth
account sufficient pam_mysql.so user=3Duser passwd=3Dpass db=3Ddb table=3Dt=
abke=20
usercolumn=3Dusername passwdcolumn=3Dpassword crypt=3D0 verbose=3D1
session required pam_stack.so service=3Dsystem-auth

I have tested this with both vsftpd and sshd. With vsftpd and 0.6.0, I get=
=20
the following weird error with md5:
Jun 22 18:41:22 hostname vsftpd[17656]: pam_mysql - non-crypt()ish MD5 hash=
=20
is not supported in this build.

Here is a secure log snippet:
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - option verbose is set t=
o=20
"1"
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_close_db()=20
called.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_sm_authenticate()=
=20
called.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_open_db()=20
called.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_open_db()=20
returning 0.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_check_passwd(=
)=20
called.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql -=20
pam_mysql_format_string() called
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_quick_escape(=
)=20
called.
Jun 22 20:01:43 hostname last message repeated 3 times
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - SELECT password FROM=20
table WHERE username =3D 'jomama'
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_sql_log()=20
called.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_sql_log()=20
returning 0.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_mysql_check_passwd(=
)=20
returning 0.
Jun 22 20:01:43 hostname vsftpd[22789]: pam_mysql - pam_sm_authenticate()=
=20
returning 0.


Also, this is what I get from the client end of things:
220 (vsFTPd 2.0.1)
530 Please login with USER and PASS.
530 Please login with USER and PASS.
KERBEROS_V4 rejected as an authentication type
Name (192.168.1.35:jomama): jomama
331 Please specify the password.
Password:
500 OOPS: priv_sock_get_result
Login failed.
421 Service not available, remote server has closed connection
ftp>


Any ideas?