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: [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

- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to