httpd-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nathan Kellogg <apa...@nwlocation.com>
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
</Directory>


LoadModule authn_mysql_module modules/mod_authn_mysql.so
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: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