Re: Get clients virtual_server info from SQL nas table

2008-07-07 Thread A . L . M . Buxey
Hi, > /* > * Table structure for table 'nas' > */ > CREATE TABLE nas ( > id SERIAL PRIMARY KEY, > nasname VARCHAR(128) NOT NULL, > shortname VARCHAR(32) NOT NULL, > typeVARCHAR(30) NOT NULL DEFAULT 'other', > ports int4, > secret VARCHAR(60)

Re: Get clients virtual_server info from SQL nas table

2008-07-05 Thread Alan DeKok
nf-vale wrote: > 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: ... > Where can I get the most "updated" SQL schema for postgres? 2.0.5 > sources? That would be a good idea, yes. > Is it

Re: Get clients virtual_server info from SQL nas table

2008-07-05 Thread nf-vale
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 nee

Re: Get clients virtual_server info from SQL nas table

2008-07-05 Thread Alan DeKok
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 clie

Get clients virtual_server info from SQL nas table

2008-07-05 Thread nf-vale
Hi all, 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,

RE: SQL NAS table

2005-10-25 Thread Alex M
, 2005 1:06 PM To: freeradius-users@lists.freeradius.org Subject: Re: SQL NAS table On Tue, 2005-25-10 at 12:52 -0400, Alex M wrote: > Can some one point me to the documentation on use of SQL NAS table? > > So that I can add nas devices to the DB and not a text file? > ...snip... Th

RE: SQL NAS table

2005-10-25 Thread Alex M
you tell me what other fields are normaly stend for? Thanks! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Guy Fraser Sent: Tuesday, October 25, 2005 1:06 PM To: freeradius-users@lists.freeradius.org Subject: Re: SQL NAS table On Tue, 2005-25-10 at

Re: SQL NAS table

2005-10-25 Thread Guy Fraser
On Tue, 2005-25-10 at 12:52 -0400, Alex M wrote: > Can some one point me to the documentation on use of SQL NAS table? > > So that I can add nas devices to the DB and not a text file? > ...snip... There has been discussion on this in the past, here is a message I sent as a resp

SQL NAS table

2005-10-25 Thread Alex M
Can some one point me to the documentation on use of SQL NAS table? So that I can add nas devices to the DB and not a text file?     Thanks! - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html