Thanks Chris. Is it exactly that MD5 function? My SQL version is 5.1.41, SELECT MD5 ('123456') returns another string, not that one. Is there anything else I've to do?<br><br><div class="gmail_quote">On Sat, Nov 20, 2010 at 6:01 PM, Chris Nighswonger <span dir="ltr"><<a href="mailto:cnighswonger@foundations.edu">cnighswonger@foundations.edu</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="gmail_quote">2010/11/20 Altaf Mahmud <span dir="ltr"><<a href="mailto:altaf.mahmud@gmail.com" target="_blank">altaf.mahmud@gmail.com</a>></span><div class="im"><br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi,<br><br>I want to know how Koha saves its borrowers' password in database? Is it one-way conversion? For example, if a password is saved as '4QrcOUm6Wau+VuBX8g+IPg', can I decode it back to its original text which was '123456'?<br>
</blockquote></div></div><br>They are stored as MD5 hashes and you cannot "decode" them as such. IIRCC, what you must do is make an MD5 hash of the password and then compare the two hashes. They should be the same.<br>
<br>Kind Regards,<br><font color="#888888">Chris<br>
</font></blockquote></div><br><br clear="all"><br>-- <br>Altaf Mahmud<br>System Programmer<br>Ayesha Abed Library<br>BRAC University<br>Bangladesh.<br><br>