httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Scott Lucas <scott.lu...@firstclasswatches.co.uk>
Subject Re: [users@httpd] AuthDBDUserRealmQuery direcrive looking for AuthDBDUserPWQuery
Date Thu, 18 Aug 2016 11:26:02 GMT
I think you want AuthType Digest if you are using AuthDBDUserRealmQuery.

If you want to do Basic auth you want AuthDBDUserPWQuery.

https://httpd.apache.org/docs/2.4/mod/mod_authn_dbd.html

Kind Regards,

Scott

First Class Watches
9 Warwick Road
Kenilworth
CV8 1HD
Warwickshire
United Kingdom

On 18 August 2016 at 11:35, Emanuele Bastianelli <manu.reeko@gmail.com>
wrote:

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

-- 


This message and any of its attachments are confidential and may be 
privileged or otherwise protected from disclosure.
If you are not the intended recipient, please contact the author/sender and 
delete this message and any attachment.
If you are not the intended recipient you must not copy this message or 
attachment or disclose the contents to any other person.

First Class Watches Ltd. 
Registered Office: 9 Warwick Road, Kenilworth, Warwickshire, CV8 1HD

Mime
View raw message