Re: [afnog] Icradius user statistic

["David Ziggy Lubowa" <ziggy at one2net.co.ug>]

Hey

well you could do 2 things, install webmin and make andministration easy
or you couldrely on the mysql commands, i will break down both for you. I assume what
you want is in"radacct" accounting for all the connections each. If you had webmin you
could simplyjust go to that table and do a simple search based on username, or you
could right asimple shell script that can extract records for you from the mysql database,

[snip]


echo "select UserName, AcctStartTime, AcctStopTime from radacct where
Realm ='xxx'"| mysql -u xxx -pxxxx  radius >> file.txt

[/snip]

notice that i used "Realm" this is if you have different realms set in
your ic-radius and youare usign them otherwise you dont need it.

hope this helps




> Hi all!
> I've just install icradius with mysql database. It works fine.
> But I would like to extract user statistic from icradius log table. Can
> anybody tell me a tool for doing this? or How to do It?
> Regards.
>
> --------------------------------------------- at :-)
> DOSSOU Franck Lucky
> Chef Section Plateforme NTIC
> Office des Postes et Télécommunications du BENIN
> BP 5959 Cotonou
> BENIN
> Tel :+229 31 65 25 / 31 88 88 / 91 74 33
> Fax :+229 31 83 72
>
> -------------------------------------------------
> Ce Message a été envoyé par http://courriel.opt.bj
>
> __________________________________________________
> This is the Africa Network Operators' Group(AfNOG)
> technical discussion list.
> The AfNOG website is: <http://www.afnog.org>


--
David Ziggy Lubowa
Network Engineer
One2net
-----------------------------------
A Network Of People And Technology


__________________________________________________
This is the Africa Network Operators' Group(AfNOG) 
technical discussion list.
The AfNOG website is: <http://www.afnog.org>