(RADIATOR) Radiator accouting on mysql Mexico

[Anton Krall]

So... any good scripts on php or something for post processing the
info in the accounting table in mysql??

I need togenerate online time per user, top users, bandwidth, etc....
but mostly.. something via web would be nice like php..

Any ideas?

Saludos

Anton Krall
Director de Tecnologia
Inter.net Mexico
(www.mx.inter.net)
Email: akrall at team.inter.net
Directo: 5-241-7609
Conmutador: 5-241-7600
Mobile: 044-5105-5160

Outside Mexico:
Office: (525)241-7609
PBX: (525)241-7600
Mobile: (525)105-5160

______________________

Wednesday, May 09, 2001, 1:15:37 PM, you wrote:

MA> El 9 May 2001, a las 10:02, Anton Krall escribió:

>> Date:                 Wed, 9 May 2001 10:02:59 -0500
>> From:                 Anton Krall <akrall at team.inter.net>
>> X-Mailer:             The Bat! (v1.45) Personal
>> Reply-to:             Anton Krall <akrall at team.inter.net>
>> Organization:         Dir. de Tecnologia - Inter.net Mexico
>> To:                   radiator at open.com.au
>> Subject:              (RADIATOR) Radiator accouting on mysql Mexico
MA> <JOKE>¿mysql funciona distinto en Mexico que en otros lugares? :-)</JOKE>

>> Sender:               owner-radiator at open.com.au
>> 
>> Guys.. Im new to Radiator but let me explain my current situation.
>> 
>> My current setup is Radiator on Linux using mysql for the user
>> database and accounting records.
>> 
>> Im looking for tools for creating accouting times and bandwitdh usage
>> for my user to view via web and also for me to know what users are
>> online the most.
MA> That you have to do it by post-processing the accounting records, 
MA> Radiator just fills the table with whatever info you choose from what 
MA> comes from your NAS Radius accounting packets... (usually, time spent 
MA> connected, bytes and/or packets transmitted and received, etc.).

MA> Whatever you do with those records afterwards, it's up to you.

>> 
>> Also, is there a way when a certain user loggs in to push him a web
>> page url so itll open automatically everythime they login? but based
>> on a user attribute?
MA> Not through Radius... take into account that the Radius "client" is the 
MA> NAS and not the "final user" connecting to it.

MA> IF the NAS can, by some means, force that the first http request going 
MA> through a recently established PPP connection...
MA> AND IF it accepts some kind of proprietary Radius attribute with the URL 
MA> to be forced...
MA> AND IF it is somehow documented...
MA> THEN Radiator will be able to do that (and it will be probably easy to do 
MA> it).



MA> But the IF's are really big (especially the first one)...

MA> Consult your NAS vendor about it.



>> 
>> Thx for any info.
MA> De nada
>> 
>> Saludos
MA> Saludos para "vos" también 
MA> ;-)

>> 
>> Anton Krall
>> Director de Tecnologia
>> Inter.net Mexico
>> (www.mx.inter.net)
>> Email: akrall at team.inter.net
>> Directo: 5-241-7609
>> Conmutador: 5-241-7600
>> Mobile: 044-5105-5160
>> 
>> Outside Mexico:
>> Office: (525)241-7609
>> PBX: (525)241-7600
>> Mobile: (525)105-5160


===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.