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?
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