<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"><<a href="mailto:291490117@qq.com" target="_blank">291490117@qq.com</a>></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 = "Jul 3 2013 08:55:14 CST"<br> Sip-From-Tag = "202199366"<br> Sip-To-Tag = "3c11a175"<br> Acct-Session-Id = "<a href="mailto:261192415021484-264973041726312@10.49.2.236" target="_blank">261192415021484-264973041726312@10.49.2.236</a>"<br>
User-Name = "<a href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>"<br> Billing-Party = "<a href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>"<br>
Calling-Station-Id = "<a href="mailto:66687113@10.1.17.71" target="_blank">66687113@10.1.17.71</a>"<br>
Called-Station-Id = "<a href="http://sip:66687114@c.corp.esocc.com:5060" target="_blank">sip:66687114@c.corp.esocc.com:5060</a>"<br> Sip-Translated-Request-URI = "sip:66687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9"<br>
Source-IP = "221.228.228.14"<br> Source-Port = "32670"<br> SIP-Proxy-IP = "10.1.17.71"<br> Canonical-URI = "sip:008666687114@221.228.228.14:58709;rinstance=e3a8a78bae83cfb9"<br>
User-Agent = "Voip Phone 1.0"<br> Contact = "<<a href="http://sip:66687113@221.228.228.14:32670" target="_blank">sip:66687113@221.228.228.14:32670</a>>"<br> From-Header = "66687113 <<a href="http://sip:66687113@c.corp.esocc.com:5060" target="_blank">sip:66687113@c.corp.esocc.com:5060</a>>;tag=202199366"<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 -> /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 -> 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'm sure there's a configuration step I'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>