Get clients virtual_server info from SQL nas table
A.L.M.Buxey at lboro.ac.uk
A.L.M.Buxey at lboro.ac.uk
Mon Jul 7 10:02:01 CEST 2008
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
More information about the Freeradius-Users
mailing list