Hi Dave, Radiusreport is a seperate project - see http://www.pgregg.com/projects/radiusreport/
Ivan posted an SQL statement above which answers your initial query. Simply execute the query on your SQL server. For simplified management you may want to take a look at installing and configuring daloradius - see http://daloradius.com/ Kind Regards, Phil 2009/11/4 Yagnesh Dave <yagnesh.d...@rediffmail.com> > Hi, > > I also found this command in the Radius E-book by O`reilly. > > radiusreport -i 0 -f detail > > But this command does not work, i get an error message saying not found. > > Please help me. > > Regards, > Yagnesh Dave > > On Wed, 04 Nov 2009 17:50:55 +0530 wrote > > >Hi, > > > > > > Thanks for your quick answer. I am very new to radius server, so i was not > able to understand what you pointed out below. It would be great if you can > elaborate a bit on it. > > > > > > Regards, > > > Yagnesh Dave. > > > > > > On Mon, 02 Nov 2009 17:04:11 +0530 wrote > > > >> Can you let me know where can we check the time for which a particular > > > > user is connected, basically this is required so that we can advice the > > > > customer if his ISDN line is connected for too long. > > > > > > SELECT (now() - AcctStartTime) FROM radacct WHERE UserName='some_user' AND > > > AcctStopTime IS NULL > > > > > > Ivan Kalik > > > Kalik Informatika ISP > > > > > > - > > > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > > > > > > <http://sigads.rediff.com/RealMedia/ads/click_nx.ads/www.rediffmail.com/signatureline....@middle?> > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html >
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html