(no subject)

[Seferovic Edvin]

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 at gmx.at [mailto:i-isp at gmx.at] 
Sent: Samstag, 01. April 2006 12:13
To: edvin.seferovic at 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 at kolp.at>
> An: "'FreeRadius users mailing list'"
> <freeradius-users at 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 at lists.freeradius.org
>
[mailto:freeradius-users-bounces+edvin.seferovic=kolp.at at lists.freeradius.or
> g] On Behalf Of i-isp at gmx.at
> Sent: Samstag, 01. April 2006 11:06
> To: freeradius-users at 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