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