httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Simpson>
Subject Re: [users@httpd] Problem with MySQL authn_dbd and virtual hosts
Date Mon, 05 Mar 2007 15:58:01 GMT

Zach Moazeni wrote:
> I'm working with Apache 2.2.3, MySQL 4.1.12 on CentOS. I have compiled
> mod_dbd, authn_dbd (along with the apr_dbd_mysql.c from
>  and I've successfully configured
> authn_dbd on the base config.

Apache 2.2.4, MySQL 4.1.21, Linux, dbd same.

> DBDriver mysql
[snip: no vhost]

> However there's two different ways I've tried pushing it into a
> virtual host.
> Option a)
[snip: everything in vhost]
> Results in the only error message being:
> [Fri Feb 23 11:11:53 2007] [error] [client __client_ip__] Error
> looking up test_user in database
> Option b)
[snip: DBD* directives outside vhost]
> Results in an error message being:
> [Fri Feb 23 11:13:10 2007] [error] [client __client_ip__] No DBD Authn
> configured!

I've had similar results with 2.2.4, but with 2.2.3, option b did
partially work, IIRC (perhaps with DBDPersist Off?).

Even when it works, I've found it unreliable.  I have three
subdirectories which require the same authentication (the authn config
is "Include"d from the same file), and I keep being asked for new
credentials as I moved between them, and sometimes the creds are
rejected several times.  There is no such problem with the parallel
2.0.52 installation (using mod_auth_mysql) which I'm trying to migrate from.

If it's any help to anyone, I think I managed to trace the "No DBD..."
error some way, though I can't be sure of the precise circumstances.  In
one case (perhaps with DBDPersist Off), in the file
"modules/aaa/mod_authn_dbd.c", the function "authn_dbd_password" calls
"apr_hash_get", which returns NULL.

In another case (DBDPersist On?):

    * authn_dbd_password calls...
    * authn_dbd_acquire_fn, which appears to be indirectly a call to...
    * ap_dbd_acquire, which calls...
    * ap_dbd_open, ...
    * dbd_setup_lock...
    * apr_thread_mutex_lock, which fails.



ss at comp dot lancs dot ac dot uk |

The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:> for more info.
To unsubscribe, e-mail:
   "   from the digest:
For additional commands, e-mail:

View raw message