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 Mon, 11 Aug 2008 14:34:54 GMT

----- Original Message ----- 
From: "Steve Whitson" <steven.whitson@gmail.com>
To: <users@httpd.apache.org>
Sent: Monday, August 11, 2008 9:24 AM
Subject: Re: [users@httpd] mod_dbd & mod_dbd_authn - mysql user 
authentication problems - apache 2.2.9


> I've loaded all modules built when using -enable-mods-shared=most and
> still no luck (same error). Here's the list:
>
> ./httpd -t -D DUMP_MODULES
> Loaded Modules:
> core_module (static)
> mpm_prefork_module (static)
> http_module (static)
> so_module (static)
> authn_file_module (shared)
> authn_dbm_module (shared)
> authn_anon_module (shared)
> authn_dbd_module (shared)
> authn_default_module (shared)
> authz_host_module (shared)
> authz_groupfile_module (shared)
> authz_user_module (shared)
> authz_dbm_module (shared)
> authz_owner_module (shared)
> authz_default_module (shared)
> auth_basic_module (shared)
> auth_digest_module (shared)
> dbd_module (shared)
> dumpio_module (shared)
> ext_filter_module (shared)
> include_module (shared)
> filter_module (shared)
> substitute_module (shared)
> deflate_module (shared)
> log_config_module (shared)
> logio_module (shared)
> env_module (shared)
> expires_module (shared)
> headers_module (shared)
> ident_module (shared)
> setenvif_module (shared)
> mime_module (shared)
> dav_module (shared)
> status_module (shared)
> autoindex_module (shared)
> asis_module (shared)
> info_module (shared)
> cgi_module (shared)
> dav_fs_module (shared)
> vhost_alias_module (shared)
> negotiation_module (shared)
> dir_module (shared)
> imagemap_module (shared)
> actions_module (shared)
> speling_module (shared)
> userdir_module (shared)
> alias_module (shared)
> rewrite_module (shared)
> php5_module (shared)
> Syntax OK
>
>
> 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
>>


was mysql library installed when you built the httpd? 


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