<div dir="ltr"><div><div>Did you compile freeradius from source? If so, you will need to patch it and then recompile freeradius.<br></div>The patch can be found here: <a href="http://download.dns-hosting.info/CDRTool/contrib/freeradius-brandinger/">http://download.dns-hosting.info/CDRTool/contrib/freeradius-brandinger/</a><br>

<br><br></div><div>These are quite old patches, if the most recent patch isn&#39;t working for you, then you will need to go through the patching logic manually. It will involve editing the following files:<br><br></div>
<div>
- freeradius/src/include/radius.h<br></div><div>- freeradius/src/modules/rlm_sql/conf.h<br></div><div>- freeradius/src/modules/rlm_sql/rlm_sql.c<br></div><div>- the config file under freeradius&#39;s /etc directory<br><br>

</div><div>Look at the lines with the &quot;+&quot; lines in the patch file.<br><br><br></div><div>-Laszlo<br></div><div><div><div><br></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/7/3 ㄨ冷se灬 <span dir="ltr">&lt;<a href="mailto:291490117@qq.com" target="_blank">291490117@qq.com</a>&gt;</span><br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">dear all:<br>         I update my freeradius from v1.1.8 to v2.2.0.<br>         when I use v2.2.0 ,I can’t see unsuccessfully calls(like cancel,etc)<br>

<br>         and radius got this log:<br>rad_recv: Accounting-Request packet from host 10.1.17.71 port 47962, id=165, length=510<br>    Acct-Status-Type = Failed<br>    Service-Type = IAPP-Register<br>    Sip-Response-Code = 487<br>

    Sip-Method = Invite<br>    Event-Timestamp = &quot;Jul  3 2013 08:55:14 CST&quot;<br>    Sip-From-Tag = &quot;202199366&quot;<br>    Sip-To-Tag = &quot;3c11a175&quot;<br>    Acct-Session-Id = &quot;<a href="mailto:261192415021484-264973041726312@10.49.2.236" target="_blank">261192415021484-264973041726312@10.49.2.236</a>&quot;<br>

    User-Name = &quot;<a href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>&quot;<br>    Billing-Party = &quot;<a href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>&quot;<br>
    Calling-Station-Id = &quot;<a href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>&quot;<br>
    Called-Station-Id = &quot;<a href="http://sip:66687114@c.corp.esocc.com:5060" target="_blank">sip:66687114@c.corp.esocc.com:5060</a>&quot;<br>    Sip-Translated-Request-URI = &quot;sip:66687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9&quot;<br>

    Source-IP = &quot;221.228.228.14&quot;<br>    Source-Port = &quot;32670&quot;<br>    SIP-Proxy-IP = &quot;10.1.17.71&quot;<br>    Canonical-URI = &quot;sip:008666687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9&quot;<br>

    User-Agent = &quot;Voip Phone 1.0&quot;<br>    Contact = &quot;&lt;<a href="http://sip:66687113@221.228.228.14:32670" target="_blank">sip:66687113@221.228.228.14:32670</a>&gt;&quot;<br>    From-Header = &quot;66687113 &lt;<a href="http://sip:66687113@c.corp.esocc.com:5060" target="_blank">sip:66687113@c.corp.esocc.com:5060</a>&gt;;tag=202199366&quot;<br>

    NAS-Port = 5060<br>    Acct-Delay-Time = 0<br>    NAS-IP-Address = 10.1.17.71<br># Executing section preacct from file /usr/local/freeradius/etc/raddb/radiusd.conf<br>+- entering group preacct {...}<br>++[preprocess] returns ok<br>

# Executing section accounting from file /usr/local/freeradius/etc/raddb/radiusd.conf<br>+- entering group accounting {...}<br>[detail]     expand: /usr/local/freeradius/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d -&gt; /usr/local/freeradius/var/log/radius/radacct/<a href="http://10.1.17.71/detail-20130703" target="_blank">10.1.17.71/detail-20130703</a><br>

[detail] /usr/local/freeradius/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /usr/local/freeradius/var/log/radius/radacct/<a href="http://10.1.17.71/detail-20130703" target="_blank">10.1.17.71/detail-20130703</a><br>

[detail]     expand: %t -&gt; Wed Jul  3 08:55:14 2013<br>++[detail] returns ok<br>[sql] Unsupported Acct-Status-Type = 15<br>++[sql] returns noop<br>Sending Accounting-Response of id 165 to 10.1.17.71 port 47962<br>Finished request 1.<br>

Cleaning up request 1 ID 165 with timestamp +9<br>Going to the next request<br>Waking up in 3.4 seconds.<br>Cleaning up request 0 ID 164 with timestamp +7<br>Ready to process requests.<br><br><br>      It seem Unsupported Acct-Status-Type = 15,and I check my dictionary <br>

      VALUE Acct-Status-Type     Failed           15         # RFC2866, acc<br><br><br><span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;word-spacing:0px">      I&#39;m sure there&#39;s a configuration step I&#39;ve missed. Could anyone suggest some<span> </span></span><br style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;word-spacing:0px">

<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;word-spacing:0px">      other things to check?<span> </span></span><br style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;word-spacing:0px">

<br><br><br><br style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;word-spacing:0px">

<span style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:start;font-style:normal;display:inline!important;font-weight:normal;float:none;line-height:normal;text-transform:none;font-size:13px;white-space:normal;font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;word-spacing:0px">Thanks<span> </span></span><br>

vic.xiang<br><br><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr"><div><div><div><br>--<br></div>Kind regards,<br></div>Laszlo Bekesi<br></div><a href="http://voipfreak.net" target="_blank">http://voipfreak.net</a><br>

</div>
</div>