----- Original Message ----- From: "Steve Whitson" <steven.whitson@xxxxxxxxx>
To: <users@xxxxxxxxxxxxxxxx> Sent: Monday, August 11, 2008 9:24 AMSubject: Re: 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@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.9I? 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, -SteveI 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@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|