Freeradius + Dialup Admin: client netmask entry in MySQL nas table

[Simon Powell-2]

Hi all,

I'm working on setting up a new freeradius server with the Dialup Admin
web interface and MySQL backend. I've successfully got the various
components up and running but I'm having a small issue with configuring
NAS clients. I'm using the 'nas' table in the db set up using the schema
in /etc/raddb/sql/mysql/nas.sql:

CREATE TABLE nas (
  id int(10) NOT NULL auto_increment,
  nasname varchar(128) NOT NULL,
  shortname varchar(32),
  type varchar(30) DEFAULT 'other',
  ports int(5),
  secret varchar(60) DEFAULT 'secret' NOT NULL,
#  server varchar(64),
  community varchar(50),
  description varchar(200) DEFAULT 'RADIUS Client',
  PRIMARY KEY (id),
  KEY nasname (nasname)
);


"readclients" is set to yes in sql.conf and the radiusd is correctly
picking up NAS info from the SQL table.

I've discovered from another post on the mailing list that in order to
use a netmask (as there's no separate netmask field in the table) you
must use the format <IP address>/<netmask> for the "nasname" field e.g.
192.168.0.0/24. This seems to work correctly for radiusd. However, when
the "nasname" is set to anything other than a simple IP address, the
Online Users view in Dialup Admin does not work properly. The page takes
a long time to load and when it does there are new entries for the new
clients BUT:

- there's no NAS name or short name listed for these new entries (e.g.
the text that says "nas1." and "Cisco 2511 access server" for the
default entries).
- the text that says "0 users connected" for the default entries just
says "users connected" for the new entries.
- the text that says "unknown free lines" for the default entries just
says "free lines" for the new entries.

Can anyone help with what I may be doing wrong?


Background, I'm running:

freeradius2-2.1.7-2.el5 on CentOS5

and

Dialup Admin Ver 1.80 (according to changelog)


Kind regards,

Simon Powell

This email, its content and any files transmitted with it are for the personal attention of the addressee only, any other usage or access is unauthorised. It may contain information which could be confidential or privileged. If you are not the intended addressee you may not copy, disclose, circulate or use it.
If you have received this email in error, please destroy it and notify the sender by email. Any representations or commitments expressed in this email are subject to contract. 
Although we use reasonable endeavours to virus scan all sent emails, it is the responsibility of the recipient to ensure that they are virus free and we advise you to carry out your own virus check before opening any attachments.  We cannot accept liability for any damage sustained as a result of software viruses.  We reserve the right to monitor email communications through our networks.
Arqiva Limited. Registered office: Crawley Court, Winchester, Hampshire SO21 2QA United Kingdom Registered in England and Wales number 2487597


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