pam_mysql - non-crypt()ish MD5 hash is not supported in this build

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.

Relevant Pages

  • RE: [dbi] Segmentation fault on RHEL4
    ... You are probably getting this because you have mixed Perl, unixODBC, MySQL ... where some were built with -pthread and some were not. ... > ima41c pid#9488) at ...
    (perl.dbi.users)
  • Common causes for Apache exiting with SIGSEGV?
    ... I have a website that's built with PHP and MySQL and it works just ... when the load gets higher (say 3 ...
    (comp.lang.php)
  • Re: Mysql Client and Freebsd 5.2-RELEASE
    ... > connect to a remote mysql server, ... > to MySQL server". ... On my Freebsd 4.8 machine built ... > with the same verion/port the connection works fine. ...
    (freebsd-questions)
  • Re: [dbi] Segmentation fault on RHEL4
    ... > You are probably getting this because you have mixed Perl, unixODBC, MySQL ... > where some were built with -pthread and some were not. ... > Try rebuilding unixODBC and MySQL with -pthread to make them all the same.. ...
    (perl.dbi.users)
  • Mysql Client and Freebsd 5.2-RELEASE
    ... I've been trying without success to get the mysql ... connect to a remote mysql server, ... On my Freebsd 4.8 machine built ... Lost connection to MySQL server ...
    (freebsd-questions)