[OpenSIPS-Users] CDRTool - Unknown module "Connect-Info"

[Adrian Georgescu]

Your radius client is not sending it. You should fix the client, not the server.

Adrian

 
On Nov 12, 2012, at 4: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 list
>> Users at lists.opensips.org
>> http://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 list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121112/5f26b004/attachment.htm>