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

[Tijmen de Mes]

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
> 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/a4d1e4c3/attachment.htm>