Wednesday, 7 August 2013

diagnosing errors with mod_auth_mysql

diagnosing errors with mod_auth_mysql

So I installed mod_auth_mysql via the following:
sudo apt-get install libapache2-mod-auth-mysql
sudo a2enmod auth_mysql
sudo /etc/init.d/apache2 restart
I updated my .htaccess file to make it connect to the DB as well but it's
not working. Here's what I'm getting in the error logs:
[Wed Aug 07 16:35:23 2013] [error] [client xxx.xxx.xxx.xxx] user username
not found: /admin/, referer: https://www.domain.tld/
The username very definitely does exist. If I do SELECT * FROM userTable
WHERE userName = 'username' it comes up. So I'm at a bit of a loss.
Is there a way I could see the SQL mod_auth_mysql is generating?
From my .htaccess file...
AuthBasicAuthoritative Off
AuthUserFile /dev/null
Auth_MYSQL On
Auth_MySQL_Host localhost
Auth_MySQL_User username
Auth_MySQL_Password password
Auth_MySQL_Authoritative On
Auth_MySQL_DB "dbname"
Auth_MySQL_Password_Table "apache_auth"
Auth_MySQL_Username_Field username
Auth_MySQL_Password_Field password
Auth_MySQL_Group_Field group
Auth_MySQL_Encryption_Types Plaintext
Any ideas?
Thanks!

No comments:

Post a Comment