httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Kellogg <>
Subject RE: [users@httpd] Auth via SQL
Date Tue, 23 Jan 2007 18:41:07 GMT

>There is also mod_auth_mysql which I got to work on 2.2.3 for both user
>and group (at the time I tried 2.2.3, only user auth was available).
>There is a patch available for mod_auth_mysql-3.0.0 to make it compile
>with Apache 2.2.3.

We installed the compiled version of mod_auth_mysql for Apache 2.2.3 but 
when attempting to
access the protected are Apache crashes with:

[Tue Jan 23 10:35:40 2007] [error] [mod_authn_mysql.c] MySQL Connection to 
mysql://root@localhost/dolauth Failed: Client does not support 
authentication protocol requested by server; consider upgrading MySQL client

Any ideas?

Here is the relevant conf:

<Directory "c:/dol/pub/">
    # Options FollowSymLinks
     AllowOverride None
     Order allow,deny
     Allow from all

   AuthName "MySQL Secured Place"
    AuthType Digest
    AuthDigestProvider mysql
    AuthnMySQLServerConfig SRV1
    require valid-user

LoadModule authn_mysql_module modules/
AuthnMySQLDBHost SRV1 localhost
AuthnMySQLDBHost SRV1 localhost
AuthnMySQLDBUsername SRV1 root
AuthnMySQLDBPassword SRV1 1234
AuthnMySQLDB SRV1 dolauth
AuthnMySQLTable SRV1 auth
AuthnMySQLUsernameField SRV1 user
AuthnMySQLPasswordField SRV1 password
AuthnMySQLIsActiveField SRV1 active
AuthnMySQLConnMin SRV1 3
AuthnMySQLConnSoftMax SRV1 12
AuthnMySQLConnHardMax SRV1 20
AuthnMySQLConnTTL SRV1 600

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