----- Original Message -----
From: "Steve Whitson" <[EMAIL PROTECTED]>
To: <users@httpd.apache.org>
Sent: Thursday, August 07, 2008 3:53 PM
Subject: [EMAIL PROTECTED] mod_dbd & mod_dbd_authn - mysql user authentication
problems - apache 2.2.9
I�m trying to use mod_dbd and mod_authn_dbd and replacements for
mod_auth_mysql within an apache 2.2.9 server I built on solaris.
I configure up the database info as such:
DBDriver mysql
DBDParams "host=somehostname dbname=somedatabasename user=someuser
pass=somepass"
DBDMin 4
DBDKeep 8
DBDMax 20
DBDExptime 300
I have the typical root directory configuration for the htdocs folder:
Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
Allow from all
AuthType Basic
AuthName "Website Mysql Userdb Verification"
AuthBasicProvider dbd
AuthDBDUserPWQuery "select password from users where name = %s"
...
When I start the server I get the following error:
[notice] Apache/2.2.9 (Unix) DAV/2 PHP/5.2.6 SVN/1.5.1 configured --
resuming normal operations
[info] Server built: Aug 7 2008 11:06:05
[debug] prefork.c(1001): AcceptMutex: fcntl (default: fcntl)
[error] (20014)Internal error: DBD: failed to prepare SQL statements:
Unknown command
[error] (20014)Internal error: DBD: failed to initialise
If I comment out the AuthDBDUserPWQuery entry, the DBD errors don�t occur.
I also tried the entry
DBDPrepareSQL "select password from users where name = %s" prepQuery
I was thinking I could use the prepared query with AuthDBUserPWQuery. But,
when only the DBDPrepareSQL is present (and not AuthDBuserPWQuery) apache
still gives the same errors.
Ideas? Is there something I�m dong wrong here?
Thanks much,
-Steve
I have been using mod_dbd for authentication fine for over a year. You
syntax looks the same as mine so I guess you might be missing some modules.
the whole setup is a bunch of modules/libraries stacked together
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]