Opps..Sorry I just missed to type a "," after outputoctets line. Problem solved.
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?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html