Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
From: "Luca Meneghesso" <meneghesso_news@mtsspa.it>
To: <users@httpd.apache.org>
Date: Thu, 24 Aug 2006 14:59:44 +0200
Message-ID: <002101c6c77d$2be11ad0$46c86464@mtsgroup.org>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
In-Reply-To: <004901c6c6d9$3f5202e0$46c86464@mtsgroup.org>
Importance: Normal
Subject: RE: [users@httpd] Digest authentication with mod_authn_dbd + MySQL
 driver

Ok.=20

After some research I found that htdigest calculates the password digest
based on the string username:realm:password, now I know how to
programmatically populate the password field in the users table with =
MySQL's
md5() function.

Luca


-----Original Message-----
From: Luca Meneghesso [mailto:meneghesso_news@mtsspa.it]=20
Sent: mercoled=EC 23 agosto 2006 19.26
To: users@httpd.apache.org
Subject: RE: [users@httpd] Digest authentication with mod_authn_dbd + =
MySQL
driver

Nick,

> You're trying to do Digest authentication with a Basic authn =
configuration
> by just switching AuthType.  You need an AuthDBDUserRealmQuery, and
> you'll need to populate your database with md5 digests.  See the =
digest
> authn documentation.

It works now. I didn't realize that my query must include also the =
realm.

I populated the password field on my database by copying the md5 digests
generated with the htdigest tool. Is there any other way to do it?
I tried with that the MD5() function in MySQL but it does is not =
generate
the same digests as htdigest.

> (one advantage of DBD is you can use the same table for both types
> of authn.  Just use different columns for Basic and Digest entries).

That's a feature I will certainly use!

>> --=20
>> Nick Kew

Thank you for your help.

Luca Meneghesso


---------------------------------------------------------------------
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


---------------------------------------------------------------------
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