httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zach Moazeni <zach.throwa...@gmail.com>
Subject [users@httpd] Problem with MySQL authn_dbd and virtual hosts
Date Fri, 23 Feb 2007 17:18:01 GMT
Hello,

I'm working with Apache 2.2.3, MySQL 4.1.12 on CentOS. I have  
compiled mod_dbd, authn_dbd (along with the apr_dbd_mysql.c from  
http://apache.webthing.com/database)  and I've successfully  
configured authn_dbd on the base config. (httpd.conf)

This is the sample httpd.conf blurb that works

DBDriver mysql

DBDParams "host=127.0.0.1 port=3306 user=daemon pass=daemon  
dbname=htusers"

DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60

<Directory />
     AuthType Basic
     AuthName "My Server"
     AuthBasicProvider dbd
     AuthDBDUserPWQuery "select password from users where username = %s"
     Require user test_user

     Options FollowSymLinks
     AllowOverride None
     Order deny,allow
     Deny from all
</Directory>

However there's two different ways I've tried pushing it into a  
virtual host.

Option a)


<VirtualHost __my_ip__:80>

DBDriver mysql
DBDParams "host=127.0.0.1 port=3306 user=daemon pass=daemon  
dbname=htusers"
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60

   ServerName __my_server_name__
   DocumentRoot /tmp/test_dbd_auth

   <Directory /tmp/test_dbd_auth>
     AuthType Basic
     AuthName "My Server"
     AuthBasicProvider dbd
     AuthDBDUserPWQuery "select password from users where username = %s"
     Require user test_user


     Options +Indexes
     Require valid-user
     Allow from all
   </Directory>
</VirtualHost>

Results in the only error message being:

[Fri Feb 23 11:11:53 2007] [error] [client __client_ip__] Error  
looking up test_user in database

Option b)

DBDriver mysql
DBDParams "host=127.0.0.1 port=3306 user=daemon pass=daemon  
dbname=htusers"
DBDMin  1
DBDKeep 2
DBDMax  10
DBDExptime 60

<VirtualHost __my_ip__:80>


   ServerName __my_server_name__
   DocumentRoot /tmp/test_dbd_auth

   <Directory /tmp/test_dbd_auth>
     AuthType Basic
     AuthName "My Server"
     AuthBasicProvider dbd
     AuthDBDUserPWQuery "select password from users where username = %s"
     Require user test_user


     Options +Indexes
     Require valid-user
     Allow from all
   </Directory>
</VirtualHost>

Results in an error message being:
[Fri Feb 23 11:13:10 2007] [error] [client __client_ip__] No DBD  
Authn configured!

Is something really basic I'm doing wrong to get this working with  
virtual hosts?

Thanks in advance to any help I may get.

-Zach

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message