[OpenSIPS-Users] CDRTool - Unknown module "Connect-Info"
Duane Larson
duane.larson at gmail.com
Mon Nov 12 17:24:43 CET 2012
Sorry Tijmen I copied the wrong lines. This is what I meant to copy
`ConnectInfo_start` varchar(32) default NULL,
`ConnectInfo_stop` varchar(32) default NULL,
On Mon, Nov 12, 2012 at 10:20 AM, Tijmen de Mes <tijmen at ag-projects.com>wrote:
> 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 <tijmen at ag-projects.com>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 <tijmen at ag-projects.com>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 <duane.larson at gmail.com>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 = "9012014561 at duanelarson.com"
>>>> Sip-Translated-Request-URI = "sip:9012014563 at 108.166.97.17:5060
>>>> "
>>>> User-Agent = "snom821/8.7.3.10"
>>>> Contact = "<sip:9012014561 at 192.168.88.13:3073
>>>> ;line=ci5jnp3t>;reg-id=1"
>>>> From-Header = "\"Duane Larson\" <sip:9012014561 at duanelarson.com
>>>> >;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" for User-Name = "
>>>> 9012014561 at duanelarson.com"
>>>> [suffix] No such realm "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
>>>> [detail] /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d
>>>> expands to /var/log/freeradius/radacct/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 listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at lists.opensips.org
>>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>>
>>>
>>
>>
>> --
>> --
>> *--*--*--*--*--*
>> Duane
>> *--*--*--*--*--*
>> --
>>
>>
>> _______________________________________________
>> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>> _______________________________________________
>> Users mailing list
>> Users at lists.opensips.org
>> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>>
>>
>
>
> --
> --
> *--*--*--*--*--*
> Duane
> *--*--*--*--*--*
> --
>
>
> _______________________________________________
> Users mailing listUsers at lists.opensips.orghttp://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>
--
--
*--*--*--*--*--*
Duane
*--*--*--*--*--*
--
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121112/009618d5/attachment-0001.htm>
More information about the Users
mailing list