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