<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi,<br>
<br>
Why should I take out these fields? These are separate fields and
should be set by radius and your radius client.<br>
<br>
Best regards,<br>
<br>
<pre class="moz-signature" cols="72">--
Tijmen de Mes
AG Projects</pre>
<br>
On 11/12/2012 04:35 PM, Duane Larson wrote:<br>
</div>
<blockquote
cite="mid:CAFcM1EpkgPyOD6PehLV4ks0zM+e9QhyUjCq9nY3GEa4ZJjQjdg@mail.gmail.com"
type="cite">Thanks Tijmen. So the OpenSIPS client shouldn't be
sending the "Connect-Info" like Adrian says? If that is the case
then would you also need to update the "radius_accounting.proc"
and take out the following
<div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>`CalledStationId`
varchar(50) NOT NULL default '',</div>
<div><span class="Apple-tab-span" style="white-space:pre"> </span>`CallingStationId`
varchar(50) NOT NULL default '',</div>
<div>Not that it concerns me just I just remembered see the
columns in the database when I was trying to figure out this
issue.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<br>
<div class="gmail_quote">On Mon, Nov 12, 2012 at 9:27 AM, Tijmen
de Mes <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:tijmen@ag-projects.com" target="_blank">tijmen@ag-projects.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0
.8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi,<br>
<br>
It has to be removed. Connect-Info is not in the
dictionary any more. In version 1 freeradius skipped the
field when it was not set or known, unlike version 2. So
that's why the sql broke, simply because the field is
not supplied.<br>
<br>
I will push a patch to remove it from CDRTool as well,
so the next version has the right sql.conf.
<div class="im"><br>
<br>
Best regards,<br>
<br>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
<br>
</div>
<div>
<div class="h5"> On 11/12/2012 04:17 PM, Duane Larson
wrote:<br>
</div>
</div>
</div>
<div>
<div class="h5">
<blockquote type="cite">That fixed it. Is there a
reason why the latest download cdrtool_9.0.0.tar.gz
has
/cdrtool_9.0.0/CDRTool/setup/radius/OpenSIPS/sql.conf
where it does include the line
<div>'%{Connect-Info}', \
<div>?<br>
<br>
<div class="gmail_quote"> On Mon, Nov 12, 2012
at 5:22 AM, Tijmen de Mes <span dir="ltr"><<a
moz-do-not-send="true"
href="mailto:tijmen@ag-projects.com"
target="_blank">tijmen@ag-projects.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote"
style="margin:0 0 0 .8ex;border-left:1px
#ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hi Duane,<br>
<br>
Please replace the stop query by:
<div><br>
<div> CALL
update_radacct_record( \</div>
<div> 'radius', \</div>
<div> '%S', \</div>
<div>
'%{Acct-Delay-Time}', \</div>
</div>
<div> '', \</div>
<div>
<div> '%{X-RTP-Stat}',
\</div>
<div>
'%{Acct-Session-Id}', \</div>
<div> '%{Sip-To-Tag}',
\</div>
<div> '%{Sip-From-Tag}'
\</div>
<div> )"</div>
<br>
</div>
Best regards,<br>
<br>
<pre cols="72">--
Tijmen de Mes
AG Projects</pre>
<div>
<div> <br>
On 11/10/2012 04:56 AM, Duane Larson
wrote:<br>
</div>
</div>
</div>
<blockquote type="cite">
<div>
<div>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
moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:9012014561@duanelarson.com"
target="_blank">9012014561@duanelarson.com</a>"</div>
<div>
Sip-Translated-Request-URI
= "<a
moz-do-not-send="true"
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
moz-do-not-send="true"
href="http://8.7.3.10"
target="_blank">8.7.3.10</a>"</div>
<div> Contact =
"<sip:<a
moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
href="http://duanelarson.com"
target="_blank">duanelarson.com</a>"
for User-Name = "<a
moz-do-not-send="true"
href="mailto:9012014561@duanelarson.com"
target="_blank">9012014561@duanelarson.com</a>"</div>
<div>[suffix] No such realm
"<a moz-do-not-send="true"
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
moz-do-not-send="true"
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
moz-do-not-send="true"
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>
<br>
<fieldset></fieldset>
<br>
</div>
</div>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org"
target="_blank">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
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">
<div><br>
</div>
-- <br>
--<br>
*--*--*--*--*--*<br>
Duane<br>
*--*--*--*--*--*<br>
--<br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</div>
</div>
</div>
<br>
_______________________________________________<br>
Users mailing list<br>
<a moz-do-not-send="true"
href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a moz-do-not-send="true"
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">
<div><br>
</div>
-- <br>
--<br>
*--*--*--*--*--*<br>
Duane<br>
*--*--*--*--*--*<br>
--<br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
</blockquote>
</body>
</html>