----- Original Message -----
From: "Steve Whitson" <[EMAIL PROTECTED]>
To: <users@httpd.apache.org>
Sent: Monday, August 11, 2008 11:17 AM
Subject: Re: [EMAIL PROTECTED] mod_dbd & mod_dbd_authn - mysql user
authentication problems - apache 2.2.9
Danie Qian wrote:
----- Original Message ----- From: "Steve Whitson"
<[EMAIL PROTECTED]>
To: <users@httpd.apache.org>
Sent: Monday, August 11, 2008 9:24 AM
Subject: Re: [EMAIL PROTECTED] 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"
<[EMAIL PROTECTED]>
To: <users@httpd.apache.org>
Sent: Thursday, August 07, 2008 3:53 PM
Subject: [EMAIL PROTECTED] 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
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
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
" from the digest: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]