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

Filed under:
|

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

Related posts about apache2

Related posts about mysql