<DIV>Thanks Jan for your feedback.</DIV>
<DIV> </DIV>
<DIV>I may confirm that serctl is generating the follow values:<BR>i) Plain text in the "password" column.</DIV>
<DIV>ii) Enrcrypted text in the "ha1" column.</DIV>
<DIV>iii) Encrypted text in the "ha1b" column.</DIV>
<DIV> </DIV>
<DIV>However, I refer back to my original objective, namely that while I still require users to be authenticated against user credentials (username, password, realm), on the other hand I want to avoid storing passwords in clear text in mysql "subscriber" table, when creating new user accounts using the serctl add command.</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV> </DIV>
<DIV>Karl<BR><B><I>Jan Janak <jan@iptel.org></I></B> wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Make sure that you have proper values in ha1 column (generated<BR>automatically by serctl, if not then you can use gen_ha1 utility to<BR>generate the hashes from plaintext password) and set:<BR><BR>modparam("auth_db", "calculate_ha1", no)<BR>modparam("auth_db", "password_column", ha1)<BR><BR>Jan.<BR><BR>On 12-10 00:12, karl wrote:<BR>> Hi guys,<BR>> <BR>> I would appreciate if someone may help me on the subject. While still requiring users to be authenticated against user credentials (username, password, realm), on the other hand I want to avoid storing passwords in clear text in mysql "subscriber" table. Any ideas?<BR>> <BR>> Thank you in advanced.<BR>> <BR>> Best regards,<BR>> <BR>> Karl<BR>> <BR>> <BR>> <BR>> <BR>> ---------------------------------<BR>> Do you Yahoo!?<BR>> vote.yahoo.com - Register online to vote today!<BR>>
_______________________________________________<BR>> Serusers mailing list<BR>> serusers@lists.iptel.org<BR>> http://lists.iptel.org/mailman/listinfo/serusers<BR><BR></BLOCKQUOTE><p>
                <hr size=1>Do you Yahoo!?<br><a
href="http://vote.yahoo.com">vote.yahoo.com</a> - Register online to vote today!