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

Tijmen de Mes tijmen at ag-projects.com
Mon Nov 12 16:27:29 CET 2012


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 
> <mailto: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 <mailto: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
>>         <mailto:9012014561 at duanelarson.com>"
>>                 Sip-Translated-Request-URI =
>>         "sip:9012014563 at 108.166.97.17:5060
>>         <http://sip:9012014563@108.166.97.17: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:9012014561 at duanelarson.com
>>         <mailto:sip%3A9012014561 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
>>         <http://duanelarson.com>" for User-Name =
>>         "9012014561 at duanelarson.com <mailto:9012014561 at duanelarson.com>"
>>         [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
>>     Users at lists.opensips.org  <mailto:Users at lists.opensips.org>
>>     http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>
>     _______________________________________________
>     Users mailing list
>     Users at lists.opensips.org <mailto: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/d9cdf81b/attachment-0001.htm>


More information about the Users mailing list