<div dir="ltr">I got freeradius working with OpenSIPs, but I think that my OpenSIPs isnt sending accounting_start_query, because I can only see in freeradius log some "update" queries, and it wont work, since there is no row to update.<div>
<br></div><div>When I place a call, my freeradius isnt receiving anything, but when I hangup i got this:</div><div><br></div><div>(...)</div><div><div>Ready to process requests.</div><div>rad_recv: Accounting-Request packet from host 127.0.0.1 port 52448, id=10, length=443</div>
<div> Acct-Status-Type = Stop</div><div> Service-Type = SIP-Session</div><div> Sip-Response-Code = 200</div><div> Sip-Method = Bye</div><div> Event-Timestamp = "Oct 8 2013 09:09:03 BRT"</div>
<div> Sip-From-Tag = "683688623"</div><div> Sip-To-Tag = "3f149b29"</div><div> Acct-Session-Id = "1917414787-5062-2@BJC.BGI.BAA.BBJ"</div><div> User-Name = "<a href="mailto:3436642001@201.62.48.28">3436642001@201.62.48.28</a>"</div>
<div> Calling-Station-Id = "<a href="mailto:sip%3A3436642001@201.62.48.28">sip:3436642001@201.62.48.28</a>"</div><div> Called-Station-Id = "<a href="mailto:sip%3A3436642000@201.62.48.28">sip:3436642000@201.62.48.28</a>"</div>
<div> Sip-Translated-Request-URI = "sip:3436642000@201.62.48.152:5060;rinstance=a84194dad5d7f3e4;transport=UDP"</div><div> Canonical-URI = "sip:3436642000@201.62.48.152:5060;rinstance=a84194dad5d7f3e4;transport=UDP"</div>
<div> User-Agent = "Grandstream HT-502 V1.2A 1.0.6.13 chip V2.2"</div><div> Contact = "<<a href="http://sip:3436642001@201.62.48.152:5062">sip:3436642001@201.62.48.152:5062</a>>"</div>
<div> NAS-Port = 5060</div><div> Acct-Delay-Time = 0</div><div> NAS-IP-Address = 127.0.0.1</div><div><br></div><div>(...)</div><div><br></div><div><div>++[radutmp] returns ok</div><div>[sql] expand: CALL update_radacct_record( 'radius', '%S', '%{Acct-Delay-Time}', '%{Connect-Info}', '%{X-RTP-Stat}', '%{Acct-Session-Id}', '%{Sip-To-Tag}', '%{Sip-From-Tag}' ) -> CALL update_radacct_record( 'radius', '2013-10-08 09:09:03', '0', '', '', '1917414787-5062-2@BJC.BGI.BAA.BBJ', '3f149b29', '683688623' )</div>
<div>[sql] expand: /var/log/freeradius/sqltrace-%Y%m%d.log -> /var/log/freeradius/sqltrace-20131008.log</div></div><div><br></div><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div>(...)</div><div><br>
</div>Atenciosamente.<div>Eng.° Rodrigo Ferreira</div><div>ITIL v3 Certified</div><div><br></div><div><a href="http://br.linkedin.com/pub/rodrigo-ferreira/31/757/901" target="_blank"><img src="http://www.tharringtonsmith.com/files/linkedin-icon.jpg" width="96" height="19"></a><br>
</div></div></div>
<br><br><div class="gmail_quote">2013/10/7 Rodrigo Ferreira <span dir="ltr"><<a href="mailto:rsferreira08@gmail.com" target="_blank">rsferreira08@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Its INCLUDE i double check</div><div class=""><div class="h5"><div class="gmail_extra"><br clear="all"><div><div dir="ltr"><div><br></div><div><br></div>Atenciosamente.<div>Eng.° Rodrigo Ferreira</div><div>
ITIL v3 Certified</div><div><br>
</div><div><a href="http://br.linkedin.com/pub/rodrigo-ferreira/31/757/901" target="_blank"><img src="http://www.tharringtonsmith.com/files/linkedin-icon.jpg" width="96" height="19"></a><br></div></div></div>
<br><br><div class="gmail_quote">2013/10/7 Mike Tesliuk <span dir="ltr"><<a href="mailto:mike@ultra.net.br" target="_blank">mike@ultra.net.br</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">on the client i think that should be $INCLUDE not INCLUDE <br></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/10/7 Rodrigo Ferreira <span dir="ltr"><<a href="mailto:rsferreira08@gmail.com" target="_blank">rsferreira08@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr">I did Mike.<div><br></div><div>### radiusclient dictionary</div>
<div><br></div><div><div>root@opensips:/etc# cat radiusclient-ng/dictionary | grep opensips</div>
<div>INCLUDE dictionary.opensips</div><div>root@opensips:/etc# ls radiusclient-ng/dictionary.opensips</div>
<div>radiusclient-ng/dictionary.opensips</div></div><div><br></div><div><br></div><div>### freeradius dictionary</div><div><div>root@opensips:/etc# cat freeradius/dictionary | grep opensips</div><div>$INCLUDE /etc/freeradius/dictionary.opensips</div>
<div>root@opensips:/etc# ls /etc/freeradius/dictionary.opensips</div><div>/etc/freeradius/dictionary.opensips</div></div><div><br></div></div><div class="gmail_extra"><div><br clear="all"><div><div dir="ltr"><div>
<br></div><div>
<br></div>Atenciosamente.<div>Eng.° Rodrigo Ferreira</div><div>ITIL v3 Certified</div><div><br></div><div><a href="http://br.linkedin.com/pub/rodrigo-ferreira/31/757/901" target="_blank"><img height="19" width="96"></a><br>
</div></div></div>
<br><br></div><div><div><div class="gmail_quote">2013/10/7 Mike Tesliuk <span dir="ltr"><<a href="mailto:mike@ultra.net.br" target="_blank">mike@ultra.net.br</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div dir="ltr">Rodrigo, <br><br>did you check if this file is being included by your main dictionary file ? ( /etc/radiusclient-ng/dictionary ) (on client and on the server)<br></div><div class="gmail_extra"><br><br><div class="gmail_quote">
2013/10/7 Rodrigo Ferreira <span dir="ltr"><<a href="mailto:rsferreira08@gmail.com" target="_blank">rsferreira08@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<div><div>
<div dir="ltr">Hi guys,<div><br></div><div>I'm stucked trying to get my freeradius working with my OpenSIPs. I'm getting this error from my OpenSIPs.</div><div><br></div><div><div>Oct 7 12:00:00 opensips /sbin/opensips[11265]: rc_avpair_new: unknown attribute 0</div>
<div>Oct 7 12:00:00 opensips /sbin/opensips[11265]: ERROR:aaa_radius:rad_avp_add: failure</div><div>Oct 7 12:00:00 opensips /sbin/opensips[11265]: ERROR:acc:acc_aaa_request: failed to add Sip-Response-Code, 2</div><div>
<br></div><div><div dir="ltr"><div>I saw a few topics that tells me to check my radiusclient dictionary, but I did that several times, and its ok, both freeradius and radiusclient use the same dictionary.</div><div><br></div>
<div><div>root@opensips:/etc/radiusclient-ng# cat /etc/freeradius/dictionary.opensips</div><div>#</div><div># SIP RADIUS attributes</div><div>#</div><div># Schulzrinne indicates attributes according to</div><div># draft-schulzrinne-sipping-radius-accounting-00</div>
<div>#</div><div># Proprietary indicates an attribute that hasn't</div><div># been standardized</div><div>#</div><div>#</div><div># NOTE: All standard (IANA registered) attributes are</div><div># defined in the default dictionary of the</div>
<div># radiusclient-ng library.</div><div>#</div><div><br></div><div>### Take standard attributes from the radiusclient-ng dictionaries ###</div><div><br></div><div>#$INCLUDE /etc/radiusclient-ng/dictionary</div>
<div><br></div><div>### SIP Attributes ###</div><div>ATTRIBUTE Sip-Method 101 integer # Schulzrinne, acc</div><div>ATTRIBUTE Sip-Response-Code 102 integer # Schulzrinne, acc</div><div>
ATTRIBUTE Sip-Cseq 103 string # Schulzrinne, acc</div><div>ATTRIBUTE Sip-To-Tag 104 string # Schulzrinne, acc</div><div>ATTRIBUTE Sip-From-Tag 105 string # Schulzrinne, acc</div>
<div>ATTRIBUTE Sip-Branch-ID 106 string</div><div>ATTRIBUTE Sip-Translated-Request-URI 107 string # Proprietary, acc</div><div>ATTRIBUTE Sip-Uri-User 208 string # Proprietary, auth_radius</div>
<div>ATTRIBUTE Sip-Group 211 string # Proprietary, group_radius</div><div>ATTRIBUTE Sip-Rpid 213 string # Proprietary, auth_radius</div><div>ATTRIBUTE Billing-Party 218 string</div>
<div>ATTRIBUTE SIP-AVP 225 string # Proprietary, avp_radius</div><div><br></div><div>### Sip-Method Values ###</div><div>VALUE Sip-Method Undefined 0</div><div>VALUE Sip-Method Invite 1</div>
<div>VALUE Sip-Method Cancel 2</div><div>VALUE Sip-Method Ack 4</div><div>VALUE Sip-Method Bye 8</div><div>VALUE Sip-Method Info 16</div><div>VALUE Sip-Method Options 32</div>
<div>VALUE Sip-Method Update 64</div><div>VALUE Sip-Method Register 128</div><div>VALUE Sip-Method Message 256</div><div>VALUE Sip-Method Subscribe 512</div><div>
VALUE Sip-Method Notify 1024</div>
<div>VALUE Sip-Method Prack 2048</div><div>VALUE Sip-Method Refer 4096</div><div>VALUE Sip-Method Publish 8192</div><div>VALUE Sip-Method Other 16384</div>
<div><br></div><div>### Sip-Response-Code Values ###</div><div>VALUE Sip-Response-Code Undefined 0</div><div>VALUE Sip-Response-Code Invite 1</div><div>VALUE Sip-Response-Code Cancel 2</div><div>VALUE Sip-Response-Code Ack 4</div>
<div>VALUE Sip-Response-Code Bye 8</div><div>VALUE Sip-Response-Code Info 16</div><div>VALUE Sip-Response-Code Options 32</div><div>VALUE Sip-Response-Code Update 64</div><div>VALUE Sip-Response-Code Register 128</div>
<div>VALUE Sip-Response-Code Message 256</div><div>VALUE Sip-Response-Code Subscribe 512</div><div>VALUE Sip-Response-Code Notify 1024</div><div>VALUE Sip-Response-Code Prack 2048</div><div>
VALUE Sip-Response-Code Refer 4096</div><div>VALUE Sip-Response-Code Publish 8192</div><div>VALUE Sip-Response-Code Other 16384</div><div><br></div><div>### Acct-Status-Type Values ###</div><div>
VALUE Acct-Status-Type Start 1 # RFC2866, acc</div><div>VALUE Acct-Status-Type Stop 2 # RFC2866, acc</div><div>VALUE Acct-Status-Type Failed 15 # RFC2866, acc</div>
<div><br></div><div>### Service-Type Values ###</div><div>VALUE Service-Type Call-Check 10 # RFC2865, uri_radius</div><div>VALUE Service-Type Group-Check 12 # Proprietary, group_radius</div>
<div>VALUE Service-Type Sip-Session 15 # Schulzrinne, acc, auth_radius</div><div>VALUE Service-Type SIP-Caller-AVPs 30 # Proprietary, avp_radius</div><div>VALUE Service-Type SIP-Callee-AVPs 31 # Proprietary, avp_radius</div>
<div><br></div><div>### Attributes added by AG Projects ###</div><div>ATTRIBUTE Source-IP 214 string</div><div>ATTRIBUTE Source-Port 215 string</div><div>ATTRIBUTE Canonical-URI 216 string</div>
<div>ATTRIBUTE Delay-Time 217 string</div><div>ATTRIBUTE Divert-Reason 219 string</div><div>ATTRIBUTE X-RTP-Stat 220 string</div><div>ATTRIBUTE From-Header 221 string</div>
<div>ATTRIBUTE User-Agent 222 string</div><div>ATTRIBUTE Contact 223 string</div><div>ATTRIBUTE Event 224 string</div><div>#ATTRIBUTE Event-Timestamp 230 string</div>
<div>ATTRIBUTE SIP-Proxy-IP 231 string</div><div>ATTRIBUTE ENUM-TLD 232 string</div></div><div><br></div><div><br></div><div>Any ideas?</div><div><br></div>Atenciosamente.<div>
Eng.° Rodrigo Ferreira</div>
<div>ITIL v3 Certified</div><div><br></div><div><a href="http://br.linkedin.com/pub/rodrigo-ferreira/31/757/901" target="_blank"><img height="19" width="96"></a><br>
</div></div></div>
</div></div>
<br></div></div>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">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></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">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></div></div></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">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></div>
</div></div><br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org" target="_blank">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></div>
</div></div></blockquote></div><br></div></div></div>