After looking at the perl script suggested by Joshua, I see that I can use crypt(), so I tested and it works. Of course postgres doesn't have a crypt() function :( I really want to be able to just insert in the database like crypt('plaintext') and have postgres handle the hashing. Is there a way in the config to change the auth module to expect a md5 hash instead of a crypt, or even plaintext? -- Chris Liles > -----Original Message----- > From: Nick Kew [mailto:nick@xxxxxxxxxxxx] > Sent: Tuesday, June 27, 2006 3:48 PM > To: users@xxxxxxxxxxxxxxxx > Subject: Re: [users@httpd] mod_authn_dbd encrypted password?! > > > On 27 Jun 2006, at 14:28, Chris Liles wrote: > > > Hello list! > > > > When setting up mod_authn_dbd to hit a postgresql data base the > > documentation says that the AuthDBDUserPWQuery must return an > > encrypted password. > > Would someone please tell me how I am suppose to crypt the password > > when storing it in the database. I can get the module to work fine > > with a null password, and I have tried md5('password'), but no love :( > > There isn't a utility for it, but the encryption is exactly the same > as reading it > from any other source. So you can, for example, use htpassword (for > basic > authentication) or htdigest (for digest) to generate the passwords, > and then > just read the values into your SQL. > > -- > Nick Kew > > --------------------------------------------------------------------- > 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@xxxxxxxxxxxxxxxx > " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx > For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx --------------------------------------------------------------------- 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@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx