httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Whitson <steven.whit...@gmail.com>
Subject Re: [users@httpd] mod_dbd & mod_dbd_authn - mysql user authentication problems - apache 2.2.9
Date Fri, 08 Aug 2008 18:23:46 GMT
Thanks for sharing that things are working for you! I'll try enabling
more (or all built) modules since I built most of them.

Danie Qian wrote:
>
> ----- 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
>



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