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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] g] On Behalf Of [EMAIL PROTECTED] 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