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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Samstag, 01. April 2006 12:13 To: [EMAIL PROTECTED]; 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" <[EMAIL PROTECTED]> > An: "'FreeRadius users mailing list'" > <[email protected]> > 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: > [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > g] On Behalf Of [EMAIL PROTECTED] > Sent: Samstag, 01. April 2006 11:06 > To: [email protected] > 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
