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