gigawords how to?

27 May 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?

Oguzhan Kayhan

Oguzhan Kayhan

tags

participants (1)