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 '[email protected]', nas '127.0.0.1'] Would anybody tell me is there something wrong with my config ? Thanks Regards, Simon _______________________________________________ Users mailing list [email protected] http://lists.opensips.org/cgi-bin/mailman/listinfo/users
