[users@httpd] AuthDBDUserRealmQuery direcrive looking for AuthDBDUserPWQuery

[Emanuele Bastianelli]

Hi,

I'm using Apache 2.4.7 on Ubuntu 14.04 and I need to use the mode
mod_auth_dbd with the AuthDBDUserRealmQuery. I have mysql installed and
working. I followed the documentation, activated all the needed apache
modules (hopefully), and configured the 000-default.conf file, under the
VirtualHost field (I'll need this authentication in a reverse proxy mode).
First, I tested the simple AuthDBDUserPWQuery directive, that works without
problems.

The issue occurs when I activate the AuthDBDUserRealmQuery directive,
removing the AuthDBDUserPWQuery. The resulting VirtualHost file is

<VirtualHost *:80>
        ServerAdmin webmaster@localhost
        DocumentRoot /var/www/html

        ErrorLog ${APACHE_LOG_DIR}/error.log
        CustomLog ${APACHE_LOG_DIR}/access.log combined

        DBDriver mysql
        DBDParams "host=localhost port=3306 user=my_user pass=my_password
dbname=apacheauth"
        DBDMin  2
        DBDKeep 4
        DBDMax  10
        DBDExptime 300

        <Directory /var/www/html>
          AuthName "You Must Login"
          AuthType Basic
          AuthBasicProvider dbd
          Require valid-user
          AuthDBDUserRealmQuery "SELECT ENCRYPT(password) FROM password
WHERE username = %s AND realm = %s"
        </Directory>
</VirtualHost>

When I try to access with user and password through basic authentication,
what happens is that the error.log file of apache is reporting this error:

[authn_dbd:error] [pid 40782:tid 140490237867776] [client
some_ip:some_port] AH01654: No AuthDBDUserPWQuery has been specified

I searched a lot on the Web, but I didn't find anything.

Thank you,
Best,

EB

PS: I already tried the query both with ENCRYPT and without it.