httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Whitson <steven.whit...@gmail.com>
Subject [users@httpd] mod_dbd & mod_dbd_authn - mysql user authentication problems - apache 2.2.9
Date Thu, 07 Aug 2008 19:53:14 GMT
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

---------------------------------------------------------------------
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