gigawords how to?
Oguzhan Kayhan
oguzhank at bilkent.edu.tr
Tue May 27 18:07:53 CEST 2008
Hello, i tried to add gigawords for freeradius 2.0
And added the gigawords lines as i seen on web and final version was like
this..
accounting_update_query = "UPDATE ${acct_table1} \
SET FramedIPAddress = '%{Framed-IP-Address}', \
AcctSessionTime = '%{Acct-Session-Time}', \
AcctInputOctets = '%{Acct-Input-Octets}', \
AcctInputGigawords = '%{Acct-Input-Gigawords}', \
AcctOutputOctets = '%{Acct-Output-Octets}' \
AcctOutputGigawords='%{Acct-Output-Gigawords}', \
WHERE AcctSessionId = '%{Acct-Session-Id}' \
AND UserName = '%{SQL-User-Name}' \
AND NASIPAddress= '%{NAS-IP-Address}'"
But after restarting the freeradius i started to get the following errors.
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 'AcctOutputGigawords= '0',
WHERE AcctSessionId = '483bfd5200000007' ' at line 1
So what can be the error?
More information about the Freeradius-Users
mailing list