And the errors are?
Ivan Kalik
Kalik Informatika ISP
Dana 16/7/2007, "Jeff" <[EMAIL PROTECTED]> piše:
>I need to log connect speeds from users
>
>At any rate things working fine from our own carrier globalpops to capture
>these on the start packet
>
>but Yournetplus for some reason it doesn't work.
>
>I see this info in the update accounting packet so i thought I would modify
>the update query but It gives errors
>
>anyone know why this is wrong.. it stops right at the AscendDataRate ='26400'
>for example then nothing after
>
>Trying to gather the Ascend-Data-Rate and USR-Connect-Speed
>
> accounting_update_query = "UPDATE ${acct_table1} \
> SET FramedIPAddress = '%{Framed-IP-Address}', \
> AcctSessionTime = '%{Acct-Session-Time}', \
> AcctInputOctets = '%{Acct-Input-Octets}', \
> AcctOutputOctets = '%{Acct-Output-Octets}' \
> AscenDataRate = '%{Ascend-Xmit-Rate}' \
> USRConnectSpeed = '%{USR-Connect-Speed}' \
> WHERE AcctSessionId = '%{Acct-Session-Id}' \
> AND UserName = '%{SQL-User-Name}' \
> AND NASIPAddress= '%{NAS-IP-Address}'"
>
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
