----- Original Message ----- From: "Norman Khine" <norman@xxxxxxxxx>
To: <users@xxxxxxxxxxxxxxxx> Sent: Monday, October 29, 2007 4:42 PMSubject: mod_auth_mysql for apache 2.2.6 - error on restart: DBD: No driver for mysql
Hello,
Following an upgrade to 2.2.6 from 2.0 I find myself that I can no
longer authenticate against MySQL database.
Following some docs and forums, I have done this so far in my conf file:
#########
....
#Database Management
#Use the MySQL driver
DBDriver mysql
#
##Connection string: database name and login credentials
DBDParams "dbname=authdbm user=user@domain password=xxx"
#
##Parameters for Connection Pool Management
DBDMin 1
DBDKeep 2
DBDMax 10
DBDExptime 60
#
#Authentication Section
<Directory /var/www/www.domain.com/cgi-bin/>
#
#mod_auth configuration for authn_dbd
AuthType Basic
AuthName "My Server"
AuthBasicProvider dbd
#authz configuration
Require valid-user
#SQL query to verify a user
#(note: DBD drivers recognise both stdio-like %s and native syntax)
AuthDBDUserPWQuery "select password from users where username = %s"
</Directory>
#########
Then when I load the protected page I get an error when I try to restart
the server.
DBD: No driver for mysql
I have emerged mod_auth_mysql-3.0.0-r2 on gentoo
What am I doing wrong?
You need to compile the driver at the bottom of this page into the apr-util library to use mod_dbd and various authentication modules:
http://apache.webthing.com/database/mod_auth_mysql-3.0.0-r2 is something totally differently from what is described in apache documentation.
--------------------------------------------------------------------- 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@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|