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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
