My goal is to have a directory password protected, and have the usernames and passwords stored in mysql.
After a little reading mod_authn_dbd sounded like what I needed.
I enabled the module and other associated with it.
I configured my .htaccess as follows.. and put it into the directory I'm trying to protect...
# mod_dbd configuration
DBDParams "host=10.0.1.211 port=3306 dbname=test user=root password=my_password"
# core authentication and mod_auth_basic configuration
# for mod_authn_dbd
# core authorization configuration
# mod_authn_dbd SQL query to authenticate a user
"SELECT password FROM password WHERE user = %s"
when I go to that directory in a web browser I get a Server error 500. My Apache error logs give me this error ".htaccess: DBDriver not allowed here"
According to http://httpd.apache.org/docs/2.2/mod/mod_dbd.html#dbdriver
I need the driver "apr_dbd_mysql.so.".
I'm assuming all the necessary APR's came with Apache??
I'm running an Xserve OS 10.6.3 server, Apache 2.2.14, mysql 5.0.88
Any ideas? Thank you.