<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
You can use ha1.<br>
<br>
modparam("auth_db", "calculate_ha1", 0)<br>
modparam("auth_db", "user_column", "username")<br>
modparam("auth_db", "password_column", "ha1")<br>
<br>
<br>
Dave Bath wrote:<br>
<blockquote type="cite"
cite="midEAB82DD488A9E743A7C0D6B1AD298D26061EF3@hermes.intranet.fuuz.com">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City">
<o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName">
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.SHAPE
{behavior:url(#default#VML);}
/* Font Definitions */
@font-face
{font-family:"Trebuchet MS";
panose-1:2 11 6 3 2 2 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0pt;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
p.MsoFootnoteText, li.MsoFootnoteText, div.MsoFootnoteText
{margin:0pt;
margin-bottom:.0001pt;
font-size:9.0pt;
font-family:"Trebuchet MS";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0pt;
mso-margin-bottom-alt:auto;
margin-left:0pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle19
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:42.55pt 42.55pt 42.55pt 42.55pt;}
div.Section1
{page:Section1;}
-->
</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</o:SmartTagType></o:SmartTagType></o:SmartTagType>
<div class="Section1">
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Hey Karl,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><br>
It might be possible to use encrypted mysql passwords – someone else on
the list seems to have mentioned that it might be possible, but I
haven’t
used this before. Otherwise, use radius authentication and it’s up to
you how you get radius to store the passwords (which could be in a
mysql database…)
hope that helps slightly?!<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Dave<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<div>
<div class="MsoNormal" align="center" style="text-align: center;"><font
size="3" face="Times New Roman"><span style="font-size: 12pt;">
<hr size="2" width="100%" align="center" tabindex="-1"></span></font></div>
<p class="MsoNormal"><b><font size="2" face="Tahoma"><span
style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font
size="2" face="Tahoma"><span
style="font-size: 10pt; font-family: Tahoma;"> karl
[<a class="moz-txt-link-freetext" href="mailto:ser_newbie@yahoo.com">mailto:ser_newbie@yahoo.com</a>] <br>
<b><span style="font-weight: bold;">Sent:</span></b> 13 October 2004
16:28<br>
<b><span style="font-weight: bold;">To:</span></b> <st1:PersonName
w:st="on">Dave Bath</st1:PersonName>; <a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> RE:
[Serusers] Avoiding
storing passwords in mysql "subscriber" tablein clear-text</span></font><o:p></o:p></p>
</div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Hi Dave,<o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Thanks for your response. Does this mean
that it is not
possible to achieve this mysql authentication. I happen to be using
mysql.<o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Thanks once again.<o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Karl <br>
<br>
<st1:PersonName w:st="on"><b><i><span
style="font-weight: bold; font-style: italic;">Dave <st1:City
w:st="on"><st1:place w:st="on">Bath</st1:place></st1:City></span></i></b></st1:PersonName><b><i><span
style="font-weight: bold; font-style: italic;"> <a class="moz-txt-link-rfc2396E" href="mailto:dave@fuuz.com"><dave@fuuz.com></a></span></i></b>
wrote:<o:p></o:p></span></font></p>
</div>
<blockquote
style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color rgb(16, 16, 255); border-width: medium medium medium 1.5pt; padding: 0pt 0pt 0pt 4pt; margin-left: 3.75pt; margin-top: 5pt; margin-bottom: 5pt;">
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Karl,<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">You could
try using radius
authentication. Just google the archives for some docs on how to use
it.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;">Dave<o:p></o:p></span></font></p>
<p class="MsoNormal"><font size="2" color="navy" face="Arial"><span
style="font-size: 10pt; font-family: Arial; color: navy;"><o:p> </o:p></span></font></p>
<div>
<div class="MsoNormal" align="center" style="text-align: center;"><font
size="3" face="Times New Roman"><span style="font-size: 12pt;">
<hr size="2" width="100%" align="center" tabindex="-1"></span></font></div>
<p class="MsoNormal"><b><font size="2" face="Tahoma"><span
style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font
size="2" face="Tahoma"><span
style="font-size: 10pt; font-family: Tahoma;">
<a class="moz-txt-link-abbreviated" href="mailto:serusers-bounces@iptel.org">serusers-bounces@iptel.org</a> [<a class="moz-txt-link-freetext" href="mailto:serusers-bounces@iptel.org">mailto:serusers-bounces@lists.iptel.org</a>] <b><span
style="font-weight: bold;">On Behalf Of </span></b>karl<br>
<b><span style="font-weight: bold;">Sent:</span></b> 12 October
2004 08:13<br>
<b><span style="font-weight: bold;">To:</span></b>
<a class="moz-txt-link-abbreviated" href="mailto:serusers@lists.iptel.org">serusers@lists.iptel.org</a><br>
<b><span style="font-weight: bold;">Subject:</span></b> [Serusers]
Avoiding
storing passwords in mysql "subscriber" tablein clear-text</span></font><o:p></o:p></p>
</div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<div>
<div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Hi guys,<o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">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?<o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Thank you in advanced.<o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Best regards,<o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font size="3" face="Times New Roman"><span
style="font-size: 12pt;">Karl</span></font></p>
</div>
</div>
</div>
</blockquote>
</div>
</blockquote>
</body>
</html>