<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 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:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
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.EmailStyle19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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]-->
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Ops sorry i thought you were sending avpairs not receiving. Sorry.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<FONT face=Arial size=2><STRONG><FONT color=#ff8000><BR>Andrew Paternoster</FONT></STRONG><BR><FONT color=#a0a0a4>Senior System Engineer</FONT></FONT><br><BR>
<TABLE style="WIDTH: 475px" cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD style="WIDTH: 120px"><FONT color=#818a8f size=2 face=Arial><A title=""
href="http://www.gpk.net.au/"><IMG style="WIDTH: 125px; HEIGHT: 50px"
border=0 hspace=0 alt="" src="cid:logo3b97.jpg"></A></FONT></TD>
<TD style="WIDTH: 11px"><FONT color=#818a8f size=2 face=Arial><A title=""
href="http://www.gpk.net.au"><IMG style="WIDTH: 11px; HEIGHT: 60px"
border=0 hspace=0 alt="" src="cid:spacer4027.jpg" width=11
height=60></A></FONT></TD>
<TD><SPAN class=style1><FONT color=#818a8f size=2 face=Arial>2/94 Abbott
Road, Hallam, VIC 3083</FONT></SPAN><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #818a8f; FONT-SIZE: 9pt; mso-ansi-language: EN-AU; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-fareast-language: EN-AU; mso-bidi-language: AR-SA"><BR><STRONG><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'">Phone:</SPAN></STRONG> <SPAN
style="FONT-FAMILY: 'Arial','sans-serif'">1300 854 223<STRONG>
Fax:</STRONG></SPAN> 1300 854 228<BR></SPAN><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: #aa272f; FONT-SIZE: 9pt; mso-ansi-language: EN-AU; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-fareast-language: EN-AU; mso-bidi-language: AR-SA"><STRONG><A
title=""
href="http://www.gpk.net.au/">www.gpk.net.au</A></STRONG></SPAN></TD></TR></TBODY></TABLE>
<P style="MARGIN: 0cm 0cm 0pt" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: black; mso-ansi-language: EN-US"
lang=EN-US></SPAN> <BR><FONT style="BACKGROUND-COLOR: #ffffff" size=2
face=Arial><EM>Did you know that you can now log faults by just sending an
email to </EM></FONT><A href="mailto:support@gpk.net.au"><FONT
style="BACKGROUND-COLOR: #ffffff" color=#808080 size=2
face=Arial><EM><STRONG>support@gpk.net.au</STRONG></EM></FONT></A></P><br><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>
freeradius-users-bounces+andrew=gpk.net.au@lists.freeradius.org
[mailto:freeradius-users-bounces+andrew=gpk.net.au@lists.freeradius.org] <b>On
Behalf Of </b>Robert White<br>
<b>Sent:</b> Tuesday, 17 November 2009 6:33 PM<br>
<b>To:</b> FreeRadius users mailing list<br>
<b>Subject:</b> Re: Accessing a second AV Pair<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>My full SQL statement is:<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>accounting_stop_query =
"EXEC ${stopacnt_sp} @username = '%{SQL-User-Name}', @av_pair =
'%{h323-incoming-conf-id}', @gw_session_id_out = '%{Quintum-h323-conf-id}',
@call_origin = '%{Quintum-h323-call-origin}', @dialstring_from =
'%{Calling-Station-Id}', @dialstring_to = '%{Called-Station-Id}',
@disconnect_code_hex = '%{Quintum-h323-disconnect-cause}', @session_time = '%{Acct-Session-Time}',
@gw_ip = '%{NAS-IP-Address}', @gw_name = '' "<o:p></o:p></p>
<div>
<p class=MsoNormal>2009/11/17 Andrew Paternoster <<a
href="mailto:andrew@gpk.net.au">andrew@gpk.net.au</a>><o:p></o:p></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'>What operator are you using? I have
multi AVPairs and i have := on the first one and += on the others working for
me.</span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Arial","sans-serif";color:#FF8000'><br>
<strong><span style='font-family:"Arial","sans-serif"'>Andrew Paternoster</span></strong></span></b><span
style='font-size:10.0pt;font-family:"Arial","sans-serif"'><br>
<span style='color:#A0A0A4'>Senior System Engineer</span></span><o:p></o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=475
style='width:356.25pt'>
<tr>
<td width=120 style='width:90.0pt;padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#818A8F'><a href="http://www.gpk.net.au/" target="_blank" title=""><b><span
lang=EN-US style='text-decoration:none'>Error! Filename not specified.</span></b></a></span><o:p></o:p></p>
</td>
<td width=11 style='width:8.25pt;padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#818A8F'><a href="http://www.gpk.net.au" target="_blank" title=""><b><span
lang=EN-US style='text-decoration:none'>Error! Filename not specified.</span></b></a></span><o:p></o:p></p>
</td>
<td style='padding:0cm 0cm 0cm 0cm'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#818A8F'>2/94 Abbott Road, Hallam, VIC 3083</span><span
style='font-size:9.0pt;color:#818A8F'><br>
<strong>Phone:</strong> 1300 854 223<strong> Fax:</strong> 1300 854 228<br>
</span><strong><span style='font-size:9.0pt;color:#AA272F'><a
href="http://www.gpk.net.au/" target="_blank" title="">www.gpk.net.au</a></span></strong><o:p></o:p></p>
</td>
</tr>
</table>
<p class=MsoNormal> <br>
<em><span style='font-size:10.0pt;font-family:"Arial","sans-serif";background:
white'>Did you know that you can now log faults by just sending an email
to </span></em><a href="mailto:support@gpk.net.au" target="_blank"><strong><i><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:gray;background:
white'>support@gpk.net.au</span></i></strong></a><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span style='font-size:7.5pt;color:black'>The information
contained in or accompanying this e-mail is intended only for the use of the
stated recipient and may contain information that is confidential and/or
privileged. If the reader is not the intended recipient or the agent thereof,
you are hereby notified that any dissemination, distribution or copying of this
e-mail is strictly prohibited and may constitute a breach of confidence and/or
privilege. If you have received this e-mail in error, please notify us
immediately. Any views or opinions presented are those solely of the author and
do not necessarily represent those of GPK Computers Pty Ltd..</span><o:p></o:p></p>
<p class=MsoNormal><span style='color:black'> </span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:7.5pt;color:black'>Warning: Although
the company has taken reasonable precautions to ensure no viruses are present
in this e-mail, the company cannot accept responsibility for any loss or damage
arising from the use of this e-mail or attachments</span><o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><b><span
lang=EN-US style='font-size:10.0pt'>From:</span></b><span lang=EN-US
style='font-size:10.0pt'> freeradius-users-bounces+andrew=<a
href="http://gpk.net.au" target="_blank">gpk.net.au</a>@<a
href="http://lists.freeradius.org" target="_blank">lists.freeradius.org</a>
[mailto:<a href="mailto:freeradius-users-bounces%2Bandrew" target="_blank">freeradius-users-bounces+andrew</a>=<a
href="http://gpk.net.au" target="_blank">gpk.net.au</a>@<a
href="http://lists.freeradius.org" target="_blank">lists.freeradius.org</a>] <b>On
Behalf Of </b>Robert White<br>
<b>Sent:</b> Tuesday, 17 November 2009 1:05 PM<br>
<b>To:</b> FreeRadius users mailing list<br>
<b>Subject:</b> Accessing a second AV Pair</span><o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Hi,<o:p></o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I
have a Radius message which has two AV Pairs and I want to insert them both in
to a database. However, I'm unable to access the second AVPair. <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Here
is the Radius packet....<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>rad_recv:
Accounting-Request packet from host 10.152.0.7 port 20001, id=87, length=662<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
NAS-IP-Address = 10.152.0.7<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-NAS-Port = "0 7/7/24"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
NAS-Port-Type = Async<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
User-Name = "99999999"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Called-Station-Id = "990006"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Calling-Station-Id = "1002"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Status-Type = Stop<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Delay-Time = 0<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Input-Octets = 0<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Output-Octets = 0<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Session-Id = "000000AA00000039"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Session-Time = 75<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Input-Packets = 0<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Acct-Output-Packets = 0<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Service-Type = Login-User<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='background:#FFFF66'> Quintum-AVPair =
"h323-ivr-out=ACCESSCODE:990006"</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-conf-id = "h323-conf-id=34623032 38616662
32630030 37333300"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='background:#FFFF66'> Quintum-AVPair =
"h323-incoming-conf-id=34623032 38616662 32630030 37333300"</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-gw-id = "h323-gw-id=au-syd-test1"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-call-origin =
"h323-call-origin=answer"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-call-type =
"h323-call-type=Telephony"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-setup-time = "h323-setup-time=01:37:31.685
UTC Tue Nov 17 2009"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-connect-time =
"h323-connect-time=01:37:31.885 UTC Tue Nov 17 2009"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-disconnect-time =
"h323-disconnect-time=01:38:46.495 UTC Tue Nov 17 2009"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-disconnect-cause =
"h323-disconnect-cause=10"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-h323-voice-quality =
"h323-voice-quality=0"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-Trunkid-In = "0 7/7/24"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>
Quintum-Trunkid-Out = "10.0.20.36"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>When
using the standard dictionary.quintum %{Quintum-AVPair}
= h323-ivr-out=ACCESSCODE:990006. I couldn't read the second AVPair.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I
did some Googling and read <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"<span
style='font-size:10.0pt'>if it [the preprocess module] founds Cisco-AVPair
attribute like</span><o:p></o:p></p>
</div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt'>Cisco-AVPair =
"gw-rxd-cdn=ton:0,npi:1,#:XXXXXXXX"<br>
and there's dictionary attribute gw-rxd-cdn, then it adds new attribute<br>
"gw-rxd-cdn" with value "ton:0,npi:1,#:XXXXXXXX".<br>
So if you have Cisco-AVPair attributes which you would like to insert<br>
into SQL, you need to create them in cisco dictionary."</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>As
Quintum and Cisco are very similar I tried the same thing and edited the
dictionary.quintum file adding in the following lines:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>ATTRIBUTE
h323-ivr-out
3000 string<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>ATTRIBUTE
h323-incoming-conf-id
3001 string<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I
noted that there is already a very similar attribute for h323-incoming-conf-id
- it just has the word 'Quintum' prepended to it.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>However,
after the dictionary edit, Radius failed to load. I got the following error:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>"Errors
reading dictionary: dict_init: /usr/local/share/freeradius/dictionary.quintum[53]:
dict_init: /usr/local/share/freeradius/dictionary.quintum[53]:"<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Am
I on the right track here?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Any
help appreciated.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Thanks,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Rob<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'> <o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class=MsoNormal><br>
-<br>
List info/subscribe/unsubscribe? See <a
href="http://www.freeradius.org/list/users.html" target="_blank">http://www.freeradius.org/list/users.html</a><o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br clear=all>
<br>
-- <br>
Rob White<br>
Assistant IT Manager<br>
Core Infrastructure & System Development<br>
Global Gossip Group<br>
Address: 14 Wentworth Avenue, Sydney NSW 2010<br>
Telephone: +61 292 630 460<br>
Fax: +61 292 630 404<br>
Mobile: +61 410 700 733<br>
Email: <a href="mailto:rwhite@globalgossip.net">rwhite@globalgossip.net</a><br>
Skype: robwhite83<o:p></o:p></p>
</div>
</div>
</body>
</html>