Danie Qian wrote: > > ----- Original Message ----- From: "Steve Whitson" > <steven.whitson@xxxxxxxxx> > To: <users@xxxxxxxxxxxxxxxx> > Sent: Monday, August 11, 2008 9:24 AM > Subject: 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.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 >>> > > > was mysql library installed when you built the httpd? > I got the error that the mysql library was missing a few days before. So (to fix that error) I found instructions, which informed me to go to the srclib/apr-util folder, where I built and installed while including the mysql driver. apr version 1.3.0 is what is included in httpd 2.2.9. After getting the noted error (my current problem), I tried building in apr & apr-util v1.3.2, no change. --------------------------------------------------------------------- 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
|