And just to add to what I already stated this is what I have in the sql.conf in case someone asks<div><br></div><div><div> accounting_stop_query = "\</div><div> CALL update_radacct_record( \</div><div>
'radius', \</div><div> '%S', \</div><div> '%{Acct-Delay-Time}', \</div><div> '%{Connect-Info}', \</div><div> '%{X-RTP-Stat}', \</div>
<div> '%{Acct-Session-Id}', \</div><div> '%{Sip-To-Tag}', \</div><div> '%{Sip-From-Tag}' \</div><div> )"</div><div><br></div><div><br>
</div><div><br></div><br><div class="gmail_quote">On Fri, Nov 9, 2012 at 8:33 PM, Duane Larson <span dir="ltr"><<a href="mailto:duane.larson@gmail.com" target="_blank">duane.larson@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
I am trying to get a new CDRTool server up and running and I am seeing the following issue with Freeradius after a call is completed (I installed the ag-projects freeradius packages)<div><br></div><div><div>rad_recv: Accounting-Request packet from host 10.182.236.97 port 54401, id=41, length=324</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 = 1352513799</div><div> Sip-From-Tag = "ppkc6hfcm6"</div>
<div> Sip-To-Tag = "as70add6af"</div><div> Acct-Session-Id = "00b99d506047-zch6q5chlhq1"</div><div> User-Name = "<a href="mailto:9012014561@duanelarson.com" target="_blank">9012014561@duanelarson.com</a>"</div>
<div> Sip-Translated-Request-URI = "<a href="http://sip:9012014563@108.166.97.17:5060" target="_blank">sip:9012014563@108.166.97.17:5060</a>"</div><div> User-Agent = "snom821/<a href="http://8.7.3.10" target="_blank">8.7.3.10</a>"</div>
<div> Contact = "<sip:<a href="tel:9012014561" value="+19012014561" target="_blank">9012014561</a>@192.168.88.13:3073;line=ci5jnp3t>;reg-id=1"</div><div> From-Header = "\"Duane Larson\" <<a href="mailto:sip%3A9012014561@duanelarson.com" target="_blank">sip:9012014561@duanelarson.com</a>>;tag=ppkc6hfcm6"</div>
<div> NAS-Port = 5060</div><div> Acct-Delay-Time = 0</div><div> NAS-IP-Address = 10.182.236.97</div><div># Executing section preacct from file /etc/freeradius/radiusd.conf</div><div>+- entering group preacct {...}</div>
<div>++[preprocess] returns ok</div><div>[acct_unique] Hashing 'Sip-To-Tag = "as70add6af",Sip-From-Tag = "ppkc6hfcm6",Client-IP-Address = 10.182.236.97,Acct-Session-Id = "00b99d506047-zch6q5chlhq1"'</div>
<div>[acct_unique] Acct-Unique-Session-ID = "3508a1820be8a06a".</div><div>++[acct_unique] returns ok</div><div>[suffix] Looking up realm "<a href="http://duanelarson.com" target="_blank">duanelarson.com</a>" for User-Name = "<a href="mailto:9012014561@duanelarson.com" target="_blank">9012014561@duanelarson.com</a>"</div>
<div>[suffix] No such realm "<a href="http://duanelarson.com" target="_blank">duanelarson.com</a>"</div><div>++[suffix] returns noop</div><div># Executing section accounting from file /etc/freeradius/radiusd.conf</div>
<div>+- entering group accounting {...}</div>
<div>[detail] expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/freeradius/radacct/<a href="http://10.182.236.97/detail-20121109" target="_blank">10.182.236.97/detail-20121109</a></div>
<div>[detail] /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/freeradius/radacct/<a href="http://10.182.236.97/detail-20121109" target="_blank">10.182.236.97/detail-20121109</a></div>
<div>[detail] expand: %t -> Fri Nov 9 20:16:39 2012</div><div>++[detail] returns ok</div><div>[sql] WARNING: <b>Unknown module "Connect-Info"</b> in string expansion "%', '%{X-RTP-Stat}', '%{Acct-Session-Id}', '%{Sip-To-Tag}', '%{Sip-From-Tag}' )"</div>
<div>rlm_sql (sql): Reserving sql socket id: 23</div><div>rlm_sql_mysql: MYSQL check_error: 1064 received</div><div>[sql] Couldn't update SQL accounting STOP record - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1</div>
<div>rlm_sql_mysql: MYSQL check_error: 1064 received</div><div>rlm_sql_mysql: Cannot store result</div><div>rlm_sql_mysql: MySQL error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' at line 1'</div>
<div>rlm_sql (sql): Released sql socket id: 23</div><div>++[sql] returns fail</div><div>Finished request 1.</div><div>Cleaning up request 1 ID 41 with timestamp +23</div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>--<br>*--*--*--*--*--*<br>Duane<br>*--*--*--*--*--*<br>--<br>
</div>