[users@httpd] apache 2.2.0 + password protection using mysql

[Prepaid <pr...@gmail.com>]

So I have apache 2.2.0 and am trying to password protect certain directories
using mysql to store the user/password/group information.

I see that there are two options:
1) mod_auth_mysql
2) mod_authn_dbd

So I naturally tried both of them and couldn't get either to work.

When I try to use mod_authn_dbd with mysql, I get:
# /usr/local/apache2/bin/apachectl restart
Syntax error on line 52 of /usr/local/apache2/conf/httpd.conf:
DBD: No driver for pgsql
httpd not running, trying to start
#

I'm having troubles with getting mod_auth_mysql to compile as a module, I'm
getting the following error when trying to compile with apxs:
/usr/local/apache2/build/libtool --silent --mode=compile gcc -prefer-pic
-D_PO
SIX_THREADS -g -O2 -pthread -I/usr/local/apache2/include
-I/usr/local/apache2/i
nclude   -I/usr/local/apache2/include  -I/usr/include/mysql  -c -o
mod_auth_mysq
l.lo mod_auth_mysql.c && touch mod_auth_mysql.slo
mod_auth_mysql.c:269:19: mysql.h: No such file or directory
mod_auth_mysql.c:379: error: syntax error before "MYSQL"
mod_auth_mysql.c:386: warning: initialization makes integer from pointer
without
 a cast
mod_auth_mysql.c:386: error: initializer element is not computable at load
time
mod_auth_mysql.c:386: error: (near initialization for `connection.host[1]')
mod_auth_mysql.c:386: warning: initialization makes integer from pointer
without
 a cast
mod_auth_mysql.c:386: error: initializer element is not computable at load
time
mod_auth_mysql.c:386: error: (near initialization for `connection.host[2]')
mod_auth_mysql.c:386: warning: initialization makes integer from pointer
without
 a cast
mod_auth_mysql.c:386: error: initializer element is not computable at load
time
mod_auth_mysql.c:386: error: (near initialization for `connection.host[3]')
mod_auth_mysql.c:386: error: initializer element is not constant
mod_auth_mysql.c:386: error: (near initialization for `connection.host')
mod_auth_mysql.c: In function `close_connection':
mod_auth_mysql.c:396: error: structure has no member named `handle'
mod_auth_mysql.c:397: error: structure has no member named `handle'
....................



So it seems either way I go, I'm not getting anywhere, does anyone have any
ideas or insights?

I'm using OpenBSD 3.8 and apache 2.2.0, and mysql 4.0.24, with perl and
appropriate perl DBD/DBI modules for mysql already installed.

Thanks in advance!