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

[Dani Popa]

you should enable sql in freeradius or use freeradius-xs(it have by 
default sql enabled) provided by ag-projects

Dani

On 03/24/11 13:33, Tijmen de Mes wrote:
> 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
>
> _______________________________________________
> Users mailing list
> Users at lists.opensips.org
> http://lists.opensips.org/cgi-bin/mailman/listinfo/users
>