Log / Dialup admin Nas lookup

classic Classic list List threaded Threaded
3 messages Options
| Threaded
Open this post in threaded view
|

Log / Dialup admin Nas lookup

Cris Boisvert
Freeradius fedora core 3
Mysql with dialup admin..

Is their a way to have the dialup admin show all the users that have logged
in to one
Nas Server in a one month period? But not list all the login and accounting
info?

I just need a list of the users not everytime each logged in.

Currently I do this.. From the radius.log


Cat radius.log | grep nasserveraddress > NEWFILE

Then I import the file and sort them and delete all the login lines but
one..

Any recccomenddations?

Thanx
Cris

-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
| Threaded
Open this post in threaded view
|

RE: Log / Dialup admin Nas lookup

Shepherd, Dave
You could try radiusreport

        http://www.pgregg.com/projects/radiusreport/

Very nice perl script, and if I remember there is a switch to just list
who has ever logged in.

To get it from the specific NAS point it top the relevant detail file.

HTH

Dave Shepherd

> -----Original Message-----
> From: [hidden email]
[mailto:freeradius-

> [hidden email]] On Behalf Of Cris Boisvert
> Sent: 21 June 2005 16:09
> To: 'FreeRadius users mailing list'
> Subject: Log / Dialup admin Nas lookup
>
> Freeradius fedora core 3
> Mysql with dialup admin..
>
> Is their a way to have the dialup admin show all the users that have
> logged
> in to one
> Nas Server in a one month period? But not list all the login and
> accounting
> info?
>
> I just need a list of the users not everytime each logged in.
>
> Currently I do this.. From the radius.log
>
>
> Cat radius.log | grep nasserveraddress > NEWFILE
>
> Then I import the file and sort them and delete all the login lines
but

> one..
>
> Any recccomenddations?
>
> Thanx
> Cris
>
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html


-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
| Threaded
Open this post in threaded view
|

Re: Log / Dialup admin Nas lookup

Marcin M. Jessa-2

You can also log to SQL and then sort on the info stored in radacct.
Should be relatively easy for a newbie PHP coder to write a script doing that.

Marcin.


On Tue, 21 Jun 2005 22:02:08 +0100
"Shepherd, Dave" <[hidden email]> wrote:

> You could try radiusreport
>
> http://www.pgregg.com/projects/radiusreport/
>
> Very nice perl script, and if I remember there is a switch to just list
> who has ever logged in.
>
> To get it from the specific NAS point it top the relevant detail file.
>
> HTH
>
> Dave Shepherd
>
> > -----Original Message-----
> > From: [hidden email]
> [mailto:freeradius-
> > [hidden email]] On Behalf Of Cris Boisvert
> > Sent: 21 June 2005 16:09
> > To: 'FreeRadius users mailing list'
> > Subject: Log / Dialup admin Nas lookup
> >
> > Freeradius fedora core 3
> > Mysql with dialup admin..
> >
> > Is their a way to have the dialup admin show all the users that have
> > logged
> > in to one
> > Nas Server in a one month period? But not list all the login and
> > accounting
> > info?
> >
> > I just need a list of the users not everytime each logged in.
> >
> > Currently I do this.. From the radius.log
> >
> >
> > Cat radius.log | grep nasserveraddress > NEWFILE
> >
> > Then I import the file and sort them and delete all the login lines
> but
> > one..
> >
> > Any recccomenddations?
> >
> > Thanx
> > Cris
> >
> > -
> > List info/subscribe/unsubscribe? See
> > http://www.freeradius.org/list/users.html
>
>
> -
> List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html