<pre>readme.txt show me:<br>Patch for 
- Added support for acct type Failed (15)
- Added MySQL stored procedures support
- Removed Cisco hack that causes errors in radius.log if acctsessiontime= 0

but the patch isn't working.
</pre><div><div>&nbsp;<br></div><div><br></div><div style="font-size: 12px;font-family: Arial Narrow;padding:2px 0 2px 0;">------------------&nbsp;原始邮件&nbsp;------------------</div><div style="font-size: 12px;background:#efefef;padding:8px;"><div><b>发件人:</b>&nbsp;"Laszlo"&lt;laszlo@voipfreak.net&gt;;</div><div><b>发送时间:</b>&nbsp;2013年7月3日(星期三) 下午3:30</div><div><b>收件人:</b>&nbsp;"OpenSIPS users mailling list"&lt;users@lists.opensips.org&gt;; <wbr></div><div></div><div><b>主题:</b>&nbsp;Re: [OpenSIPS-Users] freeradiusd-2.2.0 Unsupported Acct-Status-Type= 15</div></div><div><br></div><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'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's /etc directory<br><br>

</div><div>Look at the lines with the "+" 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>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; I update my freeradius from v1.1.8 to v2.2.0.<br>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; when I use v2.2.0 ,I can’t see unsuccessfully calls(like cancel,etc)<br>

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

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

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

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

&nbsp; &nbsp; User-Agent = "Voip Phone 1.0"<br>&nbsp; &nbsp; Contact = "&lt;<a href="http://sip:66687113@221.228.228.14:32670" target="_blank">sip:66687113@221.228.228.14:32670</a>&gt;"<br>&nbsp; &nbsp; From-Header = "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"<br>

&nbsp; &nbsp; NAS-Port = 5060<br>&nbsp; &nbsp; Acct-Delay-Time = 0<br>&nbsp; &nbsp; 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] &nbsp; &nbsp; 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] &nbsp; &nbsp; expand: %t -&gt; Wed Jul&nbsp; 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>&nbsp;&nbsp;&nbsp; &nbsp; It seem Unsupported Acct-Status-Type = 15,and I check my dictionary <br>

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; VALUE Acct-Status-Type&nbsp;&nbsp;&nbsp;&nbsp; Failed&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; # 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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I'm sure there's a configuration step I've missed. Could anyone suggest some<span>&nbsp;</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">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; other things to check?<span>&nbsp;</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></div>