<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=Arial size=2><STRONG>SQL Schema and usage</STRONG></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>1 - Search the radcheck table for any check
attributes specific to the user <BR>2 - If check attributes are found, and
there's a match, pull the reply items from the radreply table for this user and
add them to the reply <BR>3 - Group processing then begins if any of the
following conditions are met: <BR>The user IS NOT found in radcheck <BR>The user
IS found in radcheck, but the check items don't match <BR>The user IS found in
radcheck, the check items DO match AND Fall-Through is set in the radreply table
<BR>The user IS found in radcheck, the check items DO match AND the read_groups
directive is set to 'yes' <BR>4 - If groups are to be processed for this user,
the first thing that is done is the list of groups this user is a member of is
pulled from the usergroup table ordered by the priority field. The priority
field of the usergroup table allows us to control the order in which groups are
processed, so that we can emulate the ordering in the users file. This can be
important in many cases. <BR>5 - For each group this user is a member of, the
corresponding check items are pulled from radgroupcheck table and compared with
the request. If there is a match, the reply items for this group are pulled from
the radgroupreply table and applied. <BR>6 - Processing continues to the next
group IF: <BR>There was not a match for the last group's check items OR
<BR>Fall-Through was set in the last group's reply items (The above is exactly
the same as in the users file) <BR>7 - Finally, if the user has a User-Profile
attribute set or the Default Profile option is set in the sql.conf, then steps
4-6 are repeated for the groups that the profile is a member of. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>radcheck table and radreply table are in freeradius
or sql server ??? check (poin 1) is to sql server and reply (point 2) from sql
server ? </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>..so I got that error after point 2 right ?
hmmmm..</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<DIV><FONT face=Arial size=2>radius_xlat: <A
href="">'122@domain.com'</A><BR>rlm_sql (sql): sql_set_user escaped user -->
<A href="">'122@domain.com'</A><BR>radius_xlat: 'VoIP_Radius '<A
href="">122@domain.com''</A><BR>rlm_sql (sql): Reserving sql socket id:
16<BR>radius_xlat: ''<BR>radius_xlat: 'VoIP_Radius <A
href="">'122@domain.com',''</A>,
'','192.168.1.1','''<BR>rlm_sql: Failed to create the pair: Unknown value VOIP
for attribute Service-Type<BR>rlm_sql (sql): Error getting data from
database<BR>radius_xlat: ''<BR></DIV></FONT>
<DIV><FONT face=Arial size=2>in mssql.conf file i have</FONT></DIV></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>mssql.conf:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>authorize_check_query = "VoIP_Radius
'%{User-Name}'"<BR>authorize_reply_query = "VoIP_Radius
'%{User-Name}','%{Calling-Station-Id}',
\<BR>
'%{Called-Station-Id}','%{NAS-IP-Address}','%{h323-conf-id}','VOIP'"<BR></FONT></DIV></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>can anyone help me to focuse on the
problem?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>----- Original Message ----- </FONT>
<DIV><FONT face=Arial size=2>From: "Giuseppe Parlato" <</FONT><A
href="mailto:gparlato@tnet.it"><FONT face=Arial
size=2>gparlato@tnet.it</FONT></A><FONT face=Arial size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>To: "FreeRadius users mailing list" <</FONT><A
href="mailto:freeradius-users@lists.freeradius.org"><FONT face=Arial
size=2>freeradius-users@lists.freeradius.org</FONT></A><FONT face=Arial
size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>Cc: <</FONT><A
href="mailto:aland@nitros9.org"><FONT face=Arial
size=2>aland@nitros9.org</FONT></A><FONT face=Arial size=2>></FONT></DIV>
<DIV><FONT face=Arial size=2>Sent: Sunday, May 28, 2006 6:39 PM</FONT></DIV>
<DIV><FONT face=Arial size=2>Subject: Re: failed to create the pair
</FONT></DIV></DIV>
<DIV><FONT face=Arial><BR><FONT size=2></FONT></FONT></DIV><FONT face=Arial
size=2>>I tried to remove VOIP but problem is still the same..<BR>>
default queries? can you give me an example or a specific guide for that? I
<BR>> haven't found much </FONT><A
href="http://wiki.freeradius.org/index.php/Rlm_sql"><FONT face=Arial
size=2>http://wiki.freeradius.org/index.php/Rlm_sql</FONT></A><BR><FONT
face=Arial size=2>> <BR>> <BR>> <BR>> ----- Original Message -----
<BR>> From: "Alan DeKok" <><BR>> To: "FreeRadius users mailing list"
<</FONT><A href="mailto:freeradius-users@lists.freeradius.org"><FONT
face=Arial size=2>freeradius-users@lists.freeradius.org</FONT></A><FONT
face=Arial size=2>><BR>> Sent: Sunday, May 28, 2006 4:36 PM<BR>>
Subject: Re: failed to create the pair<BR>> <BR>> <BR>>> "Giuseppe
Parlato" <</FONT><A href="mailto:gparlato@tnet.it"><FONT face=Arial
size=2>gparlato@tnet.it</FONT></A><FONT face=Arial size=2>>
wrote:<BR>>>> in mssql.conf file i have<BR>>>><BR>>>>
authorize_check_query =3D "VoIP_Radius '%{User-Name}'"<BR>>>>
authorize_reply_query =3D "VoIP_Radius =<BR>>>>
'%{User-Name}','%{Calling-Station-Id}',
\<BR>>>>
=<BR>>>>
'%{Called-Station-Id}','%{NAS-IP-Address}','%{h323-conf-id}','VOIP'"<BR>>><BR>>>
The VOIP text is breaking things. Use the default queries until
you<BR>>> understand what they do, and how they
work.<BR>>><BR>>>> I don't know sql server really much and I'm
starting learning<BR>>>> freeradius, so can some one explain me how
"authorize_check_query" and<BR>>>> "authorize_reply_query" dialogue
with ms sql server?<BR>>><BR>>> The documentation explains
what the queries do.<BR>>><BR>>> Alan DeKok.<BR>>>
-<BR>>> List info/subscribe/unsubscribe? See <BR>>> </FONT><A
href="http://www.freeradius.org/list/users.html"><FONT face=Arial
size=2>http://www.freeradius.org/list/users.html</FONT></A><BR><FONT face=Arial
size=2>>><BR>>><BR>>> -- <BR>>> No virus found in this
incoming message.<BR>>> Checked by AVG Free Edition.<BR>>> Version:
7.1.394 / Virus Database: 268.7.2/349 - Release Date:
26/05/2006<BR>>><BR>>> <BR>> <BR>> - <BR>> List
info/subscribe/unsubscribe? See </FONT><A
href="http://www.freeradius.org/list/users.html"><FONT face=Arial
size=2>http://www.freeradius.org/list/users.html</FONT></A><BR><FONT face=Arial
size=2>> <BR>> <BR>> -- <BR>> No virus found in this incoming
message.<BR>> Checked by AVG Free Edition.<BR>> Version: 7.1.394 / Virus
Database: 268.7.2/349 - Release Date: 26/05/2006<BR>>
<BR>></FONT></BODY></HTML>