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
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 doe
error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near
'AscendDataRate = '19200' USRConnectSpeed = '' WHERE
AcctSess' at line 1
_
From: [EMAIL PROTECTED]
To: FreeRad
Jeff said:
> USRConnectSpeed = '%{USR-Connect-Speed}' \
Did you actually add a USRConnectSpeed column to the radacct table? There
isn't one by default.
-- hugh
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
he update query cause i see one or the other on in update packet, for
ynp so then i would have what i need, but as i stated this errors out with the
error i mentioned below trying to do this
Jeff
_
From: Hugh Messenger [mailto:[EMAIL PROTECTED]
To: 'FreeRadius users
Jeff wrote:
> Mon Jul 16 11:23:22 2007 : Error: rlm_sql (sql): 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 'AscendDataRate = '24000' USRConnectSpee
2007 : Error: rlm_sql (sql): 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
'AscendDataRate = '19200', USRConnectSpeed = ''
Yes. You are missing commas before AscendDataRate and USRConnectSpeed
expressions that you have added to the update query.
Ivan Kalik
Kalik Informatika ISP
Dana 16/7/2007, "Dennis Skinner" <[EMAIL PROTECTED]> piše:
>Jeff wrote:
>> Mon Jul 16 11:23:22 2007 : Error: rlm_sql (sql): Couldn't update
Jeff wrote:
> AcctOutputOctets = '%{Acct-Output-Octets}' \
Need comma on live above. This is a MySQL issue, not a FR issue.
Please read the MySQL docs if you don't understand how to create a valid
query.
--
Dennis Skinner
Systems Administrator
BlueFrog Internet
http://www.bluefrog.com
-0400
Subject: Re: mysql accounting connect speeds
Jeff wrote:
> AcctOutputOctets = '%{Acct-Output-Octets}' \
Need comma on live above. This is a MySQL issue, not a FR issue.
Please read the MySQL docs if you don't understand how to create a valid
query.
--
Dennis Skinner
Sys
10 matches
Mail list logo