Hi,
Why should I take out these fields? These are separate fields and should
be set by radius and your radius client.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/12/2012 04:35 PM, Duane Larson wrote:
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
`CalledStationId` varchar(50) NOT NULL default '',
`CallingStationId` varchar(50) NOT NULL default '',
Not that it concerns me just I just remembered see the columns in the
database when I was trying to figure out this issue.
On Mon, Nov 12, 2012 at 9:27 AM, Tijmen de Mes <[email protected]
<mailto:[email protected]>> wrote:
Hi,
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.
I will push a patch to remove it from CDRTool as well, so the next
version has the right sql.conf.
Best regards,
--
Tijmen de Mes
AG Projects
On 11/12/2012 04:17 PM, Duane Larson wrote:
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
'%{Connect-Info}', \
?
On Mon, Nov 12, 2012 at 5:22 AM, Tijmen de Mes
<[email protected] <mailto:[email protected]>> wrote:
Hi Duane,
Please replace the stop query by:
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)"
Best regards,
--
Tijmen de Mes
AG Projects
On 11/10/2012 04:56 AM, Duane Larson wrote:
And just to add to what I already stated this is what I have
in the sql.conf in case someone asks
accounting_stop_query = "\
CALL update_radacct_record( \
'radius', \
'%S', \
'%{Acct-Delay-Time}', \
'%{Connect-Info}', \
'%{X-RTP-Stat}', \
'%{Acct-Session-Id}', \
'%{Sip-To-Tag}', \
'%{Sip-From-Tag}' \
)"
On Fri, Nov 9, 2012 at 8:33 PM, Duane Larson
<[email protected] <mailto:[email protected]>> wrote:
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)
rad_recv: Accounting-Request packet from host
10.182.236.97 port 54401, id=41, length=324
Acct-Status-Type = Stop
Service-Type = Sip-Session
Sip-Response-Code = 200
Sip-Method = Bye
Event-Timestamp = 1352513799
Sip-From-Tag = "ppkc6hfcm6"
Sip-To-Tag = "as70add6af"
Acct-Session-Id = "00b99d506047-zch6q5chlhq1"
User-Name = "[email protected]
<mailto:[email protected]>"
Sip-Translated-Request-URI =
"sip:[email protected]:5060
<http://sip:[email protected]:5060>"
User-Agent = "snom821/8.7.3.10 <http://8.7.3.10>"
Contact = "<sip:9012014561
<tel:9012014561>@192.168.88.13:3073;line=ci5jnp3t>;reg-id=1"
From-Header = "\"Duane Larson\"
<sip:[email protected]
<mailto:sip%[email protected]>>;tag=ppkc6hfcm6"
NAS-Port = 5060
Acct-Delay-Time = 0
NAS-IP-Address = 10.182.236.97
# Executing section preacct from file
/etc/freeradius/radiusd.conf
+- entering group preacct {...}
++[preprocess] returns ok
[acct_unique] Hashing 'Sip-To-Tag =
"as70add6af",Sip-From-Tag =
"ppkc6hfcm6",Client-IP-Address =
10.182.236.97,Acct-Session-Id = "00b99d506047-zch6q5chlhq1"'
[acct_unique] Acct-Unique-Session-ID = "3508a1820be8a06a".
++[acct_unique] returns ok
[suffix] Looking up realm "duanelarson.com
<http://duanelarson.com>" for User-Name =
"[email protected]
<mailto:[email protected]>"
[suffix] No such realm "duanelarson.com
<http://duanelarson.com>"
++[suffix] returns noop
# Executing section accounting from file
/etc/freeradius/radiusd.conf
+- entering group accounting {...}
[detail] expand:
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
->
/var/log/freeradius/radacct/10.182.236.97/detail-20121109
<http://10.182.236.97/detail-20121109>
[detail]
/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
expands to
/var/log/freeradius/radacct/10.182.236.97/detail-20121109
<http://10.182.236.97/detail-20121109>
[detail] expand: %t -> Fri Nov 9 20:16:39 2012
++[detail] returns ok
[sql] WARNING: *Unknown module "Connect-Info"* in string
expansion "%', '%{X-RTP-Stat}',
'%{Acct-Session-Id}', '%{Sip-To-Tag}',
'%{Sip-From-Tag}' )"
rlm_sql (sql): Reserving sql socket id: 23
rlm_sql_mysql: MYSQL check_error: 1064 received
[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
rlm_sql_mysql: MYSQL check_error: 1064 received
rlm_sql_mysql: Cannot store result
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'
rlm_sql (sql): Released sql socket id: 23
++[sql] returns fail
Finished request 1.
Cleaning up request 1 ID 41 with timestamp +23
--
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected] <mailto:[email protected]>
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
--
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
