JP van Oosten

authn_dbd error "User not found"

05 Nov 2009

If you use apache and the DBD module for authentication, you need to be very careful with using quotes in your password query.

I had the following configuration:

AuthBasicProvider dbd
AuthDBDUserPWQuery "SELECT password FROM users WHERE name='%s'"

but this yielded the very verbose message: “user user not found”. After a while a friend commented he used the same query, minus the quotes around %s.

So, apparently, the authn_dbd module does the correct quoting for you. Use the following query if you encounter this behaviour:

AuthBasicProvider dbd
AuthDBDUserPWQuery "SELECT password FROM users WHERE name=%s"