Package: libpam-mysql
Version: 0.6.2-1
After upgrading to the latest libpam-mysql package in unstable, it
stopped working. Replacing the pam_mysql.so file in /lib/security with
a version from stable (0.5.0-6) makes it work again.
Logging in as a previously configured user still works, but when issuing
the passwd command as root, the following is returned:
# passwd testuser
passwd: Failed preliminary check by password service
passwd: password unchanged
The auth.log, shows:
---
May 23 21:19:52 testserver passwd[30830]: pam_mysql - MySQL error (You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near 'FROM WHERE
user.user_name = 'testuser'' at line 1)
---
and the mysql.log shows:
---
Connect [EMAIL PROTECTED] on nss_mysql
Init DB nss_mysql
Query SELECT 0, FROM WHERE user.user_name = 'testuser'
---
^ which is clearly an erroneous mysql query. I have no idea what causes
this, and as I say, reverting to the stable library fixes the problem.
Will gladly supply any further information required.
Thanks,
Rob.
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
