Danie Qian wrote: > > ----- Original Message ----- From: "Steve Whitson" > <steven.whitson@xxxxxxxxx> > To: <users@xxxxxxxxxxxxxxxx> > Sent: Monday, August 11, 2008 11:17 AM > Subject: Re: mod_dbd & mod_dbd_authn - mysql user > authentication problems - apache 2.2.9 > > >> 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. >> > > I am on httpd-2.2.6 where I had to download the mysql driver manually. > you are on httpd-2.2.9 so I believe you have it already built under > srclib/apr-util/dbd folder. But I read from some where on the apache > website that, when you build httpd-2.2.9 itself you need to add option > --with-mysql > > Yes! Exactly... and oddly enough the flag isn't recognized by the top-level configure script. I first built with this flag in the apr-util folder (following some instructions I found). Later I cleaned the httpd build and rebuild with that flag, and it did rebuild the mysql driver (which I verified apr_dbd_mysql file dates in install folders). The flag was properly passed on to the apr-util configuration. --------------------------------------------------------------------- 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
|