<html><head><meta http-equiv="Content-Type" content="text/html; charset=us-ascii"><meta name="Generator" content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1166744054;
mso-list-type:hybrid;
mso-list-template-ids:1733355994 134807553 134807555 134807557 134807553 134807555 134807557 134807553 134807555 134807557;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style></head><body lang="EN-GB" link="blue" vlink="purple"><div class="WordSection1"><p class="MsoNormal">Hi</p><p class="MsoNormal">I am running version 2.1.12.</p><p class="MsoNormal"> </p><p class="MsoNormal">I want to use FreeRadius in the following way:</p>
<ul style="margin-top:0cm" type="disc"><li class="MsoNormal" style>Use Digest Authentication</li><li class="MsoNormal" style>The password is stored in an external database (it has a complicated schema) that I am connecting to via sql.conf.</li>
<li class="MsoNormal" style>I want to extract the password from this database so that it can be used in Digest Authentication (SIP – using RFC 4590)</li></ul><p class="MsoNormal"> </p><p class="MsoNormal">Now I have tested FreeRadius with the radclient using digest authentication by placing the Cleartext-Password in the users file – this worked.</p>
<p class="MsoNormal"> </p><p class="MsoNormal">Is it possible to get the Cleartext-Password (or is it the User-Password) from my external database through authorize_check_query ?</p><p class="MsoNormal">If so, how do I assign this attribute to the value returned in my query? I can’t store any information in my external database as I am not allowed to create any tables</p>
<p class="MsoNormal"> </p><p class="MsoNormal">The following query would return the password – can I use it in authorize_check_query?</p><p class="MsoNormal">authorize_check_query="SELECT password FROM fusion.cdm_credentials WHERE person_id=(SELECT person_id FROM fusion.cdm_person WHERE user_name='%{User-Name}');"</p>
<p class="MsoNormal"> </p><p class="MsoNormal">As you can see in the query I have to use password as it is a column entry in my database </p><p class="MsoNormal"> </p><p class="MsoNormal">There is a similar mechanism for LDAP where you can use the passsword_attribute</p>
<p class="MsoNormal"> </p><p class="MsoNormal"> </p><p class="MsoNormal">Or am I totally off track?</p><p class="MsoNormal"> </p><p class="MsoNormal">Thx</p><p class="MsoNormal">Mike</p><p class="MsoNormal"> </p></div></body></html>
<pre>
--------------------
Note: The information contained in this message may be privileged and confidential
and protected from disclosure. If the reader of this message is not the intended
recipient, or an employee or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited. If you have received this
communication in error, please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Thrupoint, Inc.
nXaR2cC3