Thank you Bjorn, that fixed my issue.
________________________________ From: Björn Zettergren <[email protected]> To: "<[email protected]>" <[email protected]>; Rajeev Prasad <[email protected]> Cc: "[email protected]" <[email protected]> Sent: Wednesday, August 10, 2011 11:15 AM Subject: Re: [users@httpd] 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" <[email protected]>: 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??? >
