[OpenSIPS-Users] Cannot store Accounting Record into mysql Using Opensips 1.6.4 + CDRTool + Freeradius + mysql

[Simon Shum]

Hello,

I have installed opensips 1.6.4 + mediaproxy + cdrtool + freeradius + mysql, and I have followed the install guide from http://cdrtool.ag-projects.com/wiki/Install. 

I am able to find accounting record in the freeradius server log file at /var/log/freeradius/radacct/, but when I trying to look for the accounting record in the mysql database. I found the radacct table in radius database is empty. I read the /var/log/freeradius/radius.log and found the following logs:

Thu Mar 24 12:09:25 2011 : Error: [sql] Couldn't update SQL accounting ALIVE 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
Thu Mar 24 12:09:25 2011 : Error: rlm_sql_mysql: Cannot store result
Thu Mar 24 12:09:25 2011 : Error: 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'
Thu Mar 24 12:09:35 2011 : Error: [sql] Couldn't update SQL accounting ALIVE 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
Thu Mar 24 12:09:35 2011 : Error: rlm_sql_mysql: Cannot store result
Thu Mar 24 12:09:35 2011 : Error: 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'
Thu Mar 24 12:09:45 2011 : Error: [sql] Couldn't update SQL accounting ALIVE 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
Thu Mar 24 12:09:45 2011 : Error: rlm_sql_mysql: Cannot store result
Thu Mar 24 12:09:45 2011 : Error: 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'
Thu Mar 24 12:11:25 2011 : Info: [sql] stop packet with zero session length. [user '301 at 192.168.11.212', nas '127.0.0.1']


Would anybody tell me is there something wrong with my config ? Thanks

Regards,
Simon