Re: mod_dbd & mod_dbd_authn - mysql user authentication problems - apache 2.2.9

["Danie Qian" <daniel@xxxxxxxxxxxxxxxx>]

----- Original Message ----- 
From: "Steve Whitson" <steven.whitson@xxxxxxxxx>
To: <users@xxxxxxxxxxxxxxxx>
Sent: Thursday, August 07, 2008 3:53 PM
Subject:  mod_dbd & mod_dbd_authn - mysql user authentication 
problems - apache 2.2.9


> I? 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? 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? 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: users-unsubscribe@xxxxxxxxxxxxxxxx
  "   from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx
For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx