(RADIATOR) Radiator accouting on mysql Mexico

[Hugh Irvine]

Hello Anton -

We include two CGI scripts with Radiator:

	radwho.cgi - used to view the session database

	radacct.cgi - used to view accounting records

Have a look at sections 11 and 12 in the Radiator 2.18.1 reference manual.

regards

Hugh


On Thursday 10 May 2001 04:26, Anton Krall wrote:
> 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.

-- 
Radiator: the most portable, flexible and configurable RADIUS server 
anywhere. Available on *NIX, *BSD, Windows 95/98/2000, NT, MacOS X.
-
Nets: internetwork inventory and management - graphical, extensible,
flexible with hardware, software, platform and database independence.
===
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.