Modify the sql queries ( in your sql.conf file ) under Accounting Updates. Instead of using "UPDATE" use "INSERT" queries to get a row for each accounting update. Regards, Edvin -----Original Message----- From: i-isp@gmx.at [mailto:i-isp@gmx.at] Sent: Samstag, 01. April 2006 12:13 To: edvin.seferovic@kolp.at; FreeRadius users mailing list Subject: RE: (no subject) Hi, 1. Ok 2. which must be modify? 3. Ok PS:I am planing to use such system to detect misuse ;) what do you mean? best regards harald
--- Ursprüngliche Nachricht --- Von: "Seferovic Edvin" <edvin.seferovic@kolp.at> An: "'FreeRadius users mailing list'" <freeradius-users@lists.freeradius.org> Betreff: RE: (no subject) Datum: Sat, 1 Apr 2006 11:45:59 +0200
Hi,
1. modify your pppoe-server to send accouting updates every hour or less 2. modify sql.conf to write an entry to sql for each accouting-update packet 3. based on session start time and update time you can calculate and see the hourly transfer.
Regards,
Edvin
PS: I am planing to use such system to detect misuse ;)
-----Original Message----- From: freeradius-users-bounces+edvin.seferovic=kolp.at@lists.freeradius.org
[mailto:freeradius-users-bounces+edvin.seferovic=kolp.at@lists.freeradius.or
g] On Behalf Of i-isp@gmx.at Sent: Samstag, 01. April 2006 11:06 To: freeradius-users@lists.freeradius.org Subject: (no subject)
hi,
i have freeradius + mysql + cisco + pppoe clients.
the pppoe client is 3 day online. the radius have 1 line with input/output octets
the statistic for the users must to every hours the input/output octets
have you a idea?
best regrds harald
-- "Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ... Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-- Echte DSL-Flatrate dauerhaft für 0,- Euro*! "Feel free" mit GMX DSL! http://www.gmx.net/de/go/dsl