httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Danie Qian" <dan...@bestningning.com>
Subject Re: [users@httpd] mod_dbd & mod_dbd_authn - mysql user authentication problems - apache 2.2.9
Date Thu, 07 Aug 2008 23:29:39 GMT

----- Original Message ----- 
From: "Steve Whitson" <steven.whitson@gmail.com>
To: <users@httpd.apache.org>
Sent: Thursday, August 07, 2008 3:53 PM
Subject: [users@httpd] 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: 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