Re: AuthMySQL_Encryption_Types SHA1Sum not working

[Rajeev Prasad <rp.neuli@xxxxxxxxx>]

Thank you Bjorn, that fixed my issue.

---

From: Björn Zettergren <Bjorn.Zettergren@xxxxxxxxxxx>
To: "<users@xxxxxxxxxxxxxxxx>" <users@xxxxxxxxxxxxxxxx>; Rajeev Prasad <rp.neuli@xxxxxxxxx>
Cc: "users@xxxxxxxxxxxxxxxx" <users@xxxxxxxxxxxxxxxx>
Sent: Wednesday, August 10, 2011 11:15 AM
Subject: Re: AuthMySQL_Encryption_Types SHA1Sum not working

Echo appends a linebreak, try using "echo -n" instead.

/Björn 

10 aug 2011 kl. 17:37 skrev "Rajeev Prasad" <rp.neuli@xxxxxxxxx>:

Hi,

I am not able to figure why SH1Sum authentication type is not working....

in sql table:
userid: test2
sh1sum password stored:  9054fbe0b622c638224d50d20824d2ff6782e308

I computed sha2sum password as below:
$ echo test2|sha1sum
9054fbe0b622c638224d50d20824d2ff6782e308  -

in apache config:
AuthMySQL_Encryption_Types SHA1Sum

• Apache/2.2.16 (Ubuntu)
• MySQL client version: 5.1.49

and it does not authenticate, i get NO error in apache error or access logs.

for the user test who ha splain text password stored " AuthMySQL_Encryption_Types PlainText "  works. so when it is working for plaintext why not for sha1sum encrypted???