gigawords how to?

Oguzhan Kayhan oguzhank at bilkent.edu.tr
Tue May 27 19:01:36 CEST 2008


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
>





More information about the Freeradius-Users mailing list