Hi Alan, Thanks for your quick answer. In the freeradius-server-2.0.3/raddb/sql/postgresql/nas.sql file the sql table structure did not show any server column: /* * Table structure for table 'nas' */ CREATE TABLE nas ( id SERIAL PRIMARY KEY, nasname VARCHAR(128) NOT NULL, shortname VARCHAR(32) NOT NULL, type VARCHAR(30) NOT NULL DEFAULT 'other', ports int4, secret VARCHAR(60) NOT NULL, community VARCHAR(50), description VARCHAR(200) ); create index nas_nasname on nas (nasname); Where can I get the most "updated" SQL schema for postgres? 2.0.5 sources? Is it also possible for radiusd to retrieve realms and proxy information from SQL instead of files? Thx again, Nelson Vale Sáb, 2008-07-05 às 16:09 +0200, Alan DeKok escreveu:

nf-vale wrote:

...

In my deploy, freeradius is retrieving clients info from sql nas table, but this table does not have a "virtual _server" column, and need to use virtual servers. Is it possible to get "virtual_server" info from sql nas table, instead of clients.conf file. If yes, what do I need to do?

Update the SQL table to include the "server" column, as given in the sample nas.sql files.

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

Hi,

/* * Table structure for table 'nas' */ CREATE TABLE nas ( id SERIAL PRIMARY KEY, nasname VARCHAR(128) NOT NULL, shortname VARCHAR(32) NOT NULL, type VARCHAR(30) NOT NULL DEFAULT 'other', ports int4, secret VARCHAR(60) NOT NULL, community VARCHAR(50), description VARCHAR(200) ); create index nas_nasname on nas (nasname);

Where can I get the most "updated" SQL schema for postgres? 2.0.5 sources?

yes - please note that you will need to run 2.0.5 or later because up until then the FR postgres code couldnt handle the new server column due to a function being missing from handling SQL queries.

Is it also possible for radiusd to retrieve realms and proxy information from SQL instead of files?

..with further code, yes. alan