I have spent some time searching for this and it seems I'm the only one having problem with PAM not authenticating through mysql due to current updates so I thought I will post my problem here and if I find solution I will post here as well for others to follow.
In short - I'm running postfix with saslauthd and dovecot. Both are authenticating through pam employing mysql as credentials source.
Everything was working fine until today update - I can't connect to mail server any more and here is what I see in logs:
PAM unable to dlopen(/usr/lib/security/pam_mysql.so): /usr/lib/security/pam_mysql.so: undefined symbol: make_scrambled_password PAM adding faulty module: /usr/lib/security/pam_mysql.so DEBUG: auth_pam: pam_authenticate failed: Module is unknown do_auth : auth failure: [user=xxxx] [service=smtp] [realm=xxxx] [mech=pam] [reason=PAM auth error]
So I may be wrong but to my understanding pam_mysql.so is using deprecated make_scrambled_password that is not supported by mysql any more.
I don't know what the solution would be and will appreciate if anybody can advice.
I checked source code on project page and can see deprecated function is being used. So this seems to be a bug in pam_mysql and update will be needed ([bug reported on pam_mysql sourceforge page] as well as on arch community bug tracker (https://bugs.archlinux.org/task/39083?project=5&pagenum=1))
I have seen some workaround patches around internet (https://lists.fedoraproject.org/pipermail/scm-commits/2011-June/613231.html) however I'm not sure if that's suitable for production environment. It seems I will have to patch it myself. I will post patch here for others to use.
Many thanks, Greg