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