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.9 > > >> I? 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, >> >> -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@xxxxxxxxxxxxxxxx > " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx > For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx > --------------------------------------------------------------------- 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
|