Dialup Admin NAS List

[Kostas Kalevras]

Cory Robson wrote:

>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.
>  
>

So edit lib/sql/nas_list.php3 to read the radacct table instead and set 
the nas type/port num variables to some default value.

>
>
>-----Original Message-----
>From: freeradius-users-bounces+cory=cmi.net.au at lists.freeradius.org
>[mailto:freeradius-users-bounces+cory=cmi.net.au at 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
>
>
>- 
>List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
>  
>