httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Travis Veazey <travis.vea...@rogerspos.com>
Subject Re: [users@httpd] Issue with mod_dbd
Date Fri, 26 Mar 2010 19:46:36 GMT
On Fri, Mar 26, 2010 at 11:31, Nick Kew <nick@webthing.com> wrote:
>
> On 26 Mar 2010, at 19:21, Travis Veazey wrote:
>
>> Forgive me if this is the wrong forum to ask this question, but I am
>> having a problem using mod_dbd under Apache 2.2.12.
>
> What's in your Apache error log?  And your MySQL logs?
>
> --
> Nick Kew

In the Apache error log, we see errors such as the following when
trying to authenticate against host2:
[Fri Mar 26 10:12:24 2010] [error] [client 24.237.223.102] user
travis.veazey not found: /trac/wiki
[Fri Mar 26 10:12:25 2010] [error] [client 24.237.223.102] user
travis.veazey not found: /trac/wiki
[Fri Mar 26 10:12:26 2010] [error] [client 24.237.223.102] user
travis.veazey not found: /trac/wiki

In MySQL, when query logging is engaged (we keep it off generally
because it is a high-traffic production system):
                     82 Connect     authuser@192.168.10.7 on accounts
                     82 Query       SET NAMES latin1
                     82 Quit
                     83 Connect     authuser@192.168.10.7 on accounts
                     83 Prepare     [1] select password from users
where username = ?
                     83 Prepare     [2] select password from users
where username = ?
                     83 Prepare     [3] select password from users
where username = ?
                     83 Prepare     [4] select password from users
where username = ?
                     83 Execute     [3] select password from users
where username = ''

The Apache error does not show up when pointing to host1, where the
MySQL query log shows the correct username being substituted in place
of the placeholder when the statement is executed. MySQL error logging
does not pick up anything in either case.

-Travis

---------------------------------------------------------------------
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@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org


Mime
View raw message