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

[Tijmen de Mes]

Hi,

You can enable sqltrace in freeradius to see what is wrong and try to
execute the queries manually.

Which version of freeradius are you using?

Best regards,

Tijmen de Mes
AG Projects

Op 3/24/11 11:01 AM, Simon Shum schreef:
> 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
>
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users