<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=GB2312">
</head>
<body text="#000000" bgcolor="#ffffff">
<div class="moz-text-plain" wrap="true" style="font-family:
-moz-fixed; font-size: 14px;" lang="x-western">
<pre wrap="">Hello,
I have installed opensips 1.6.4 + mediaproxy + cdrtool + freeradius + mysql, and I have followed the install guide from <a class="moz-txt-link-freetext" href="http://cdrtool.ag-projects.com/wiki/Install">http://cdrtool.ag-projects.com/wiki/Install</a>.
I am able to find accounting record in the freeradius server log file at <i class="moz-txt-slash"><span class="moz-txt-tag">/</span>var/log/freeradius/radacct<span class="moz-txt-tag">/</span></i>, 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 '<a class="moz-txt-link-abbreviated" href="mailto:301@192.168.11.212">301@192.168.11.212</a>', nas '127.0.0.1']
Would anybody tell me is there something wrong with my config ? Thanks
Regards,
Simon
</pre>
</div>
</body>
</html>