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

[Duane Larson]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20121109/a8b0dcd5/attachment.htm>