Whilst this is a good example it still doesn't suit my purpose. It requires someone to constantly update the list for it to be effective. This is not to be confused with the clients. I have multiple roaming numbers, therefore if a customer is travelling around and dials in at different locations I will receive a diff NASIP from that local POP. As this information is provided in the account start/stop and update packets then why enter them manually. Just drill through the existing radacct table filtering on no stop time to see a list of active NAS's and display them as I wanted. No further updating the separate table. -----Original Message----- From: freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org [mailto:freeradius-users-bounces+cory=cmi.net.au@lists.freeradius.org] On Behalf Of Kostas Kalevras Sent: Tuesday, 16 January 2007 6:53 PM To: FreeRadius users mailing list Subject: Re: Dialup Admin NAS List Cory Robson wrote:
I'm hoping someone may be able to assist in modifying the user_finger.php script to retrieve the list of NAS's for the online users from radacct table.
Why not just use the nas table. In the cvs version of dialupadmin there's a file called lib/sql/nas_list.php3 It will read the nas table and get the nas list. You could try changing that one if it suits your needs.
Basically instead of reading the text file and cycling through them to add the breakdown of NAS's I want to use something like
select DISTINCT NASIPAddress from radacct
add them to an array and use the php gethostbyaddr() function to retrieve the true hostname to sort them by
I don't need any of the snmp or NAS type or number of lines left as my upstream does not allow me to connect to verify the information anyway .
This should just be a quick change for someone more talented than I to remove the existing loop and replace it with the relevant sql loop instead.
Anyone ?
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html __________ NOD32 1981 (20070116) Information __________ This message was checked by NOD32 antivirus system. http://www.eset.com