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 Mon, 11 Aug 2008 13:24:58 GMT
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
>
> ---------------------------------------------------------------------
> 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