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 '[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
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://lists.opensips.org/cgi-bin/mailman/listinfo/users
