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.dave@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.htm@Middle?>
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html