Auth succeeded No requires line available
Posted
by
user286223
on Ask Ubuntu
See other posts from Ask Ubuntu
or by user286223
Published on 2014-05-28T17:50:41Z
Indexed on
2014/08/19
22:33 UTC
Read the original article
Hit count: 167
Upgrading to Ubuntu 14.04 (and Apache2 2.4) server I can't use MySQL as htaccess;
Before upgrading I was using MySQL as htaccess in the virtual host - worked nicely:
<Directory /var/www/html/tilmelding/login>
AuthBasicAuthoritative Off
AuthUserFile /dev/null
# begin auth_mysql configuration
AuthMySQL On
AuthMySQL_Host localhost
AuthMySQL_User **********
AuthMySQL_Password *********
AuthMySQL_DB **********
AuthMySQL_Password_Table user_info
AuthMySQL_Username_Field user_name
AuthMySQL_Password_Field user_passwd
AuthMySQL_Empty_Passwords Off
AuthMySQL_Encryption_Types PHP_MD5
AuthMySQL_Authoritative
AuthType Basic
AuthName "auth_mysql test"
Require valid-user
After upgrade it didn’t work.
In the logfile I got:
[:debug] [pid 31333] mod_auth_mysql.c(1578): Constructing password collection query with passfield=[user_passwd], table=[user_info], userfield=[helgoland], where_clause=[]
[:debug] [pid 31333] mod_auth_mysql.c(1410): sec->dbh in /var/www/html/tilmelding/login/ is
[:debug] [pid 31333] mod_auth_mysql.c(1417): Ordinary query
[:debug] [pid 31333] mod_auth_mysql.c(1434): Running query: [SELECT user_passwd FROM user_info WHERE user_name='helgoland']
[:debug] [pid 31333] mod_auth_mysql.c(1522): Checking with PHP_MD5
[:debug] [pid 31333] mod_auth_mysql.c(1524): Auth succeeded
[:error] [pid 31333] No requires line available
I am able to do the query from CLI and get an MD5 back.
What have I missed ?
© Ask Ubuntu or respective owner