Re: SQL replacement for clients.conf?

2005-09-15 Thread Ben Dowling 
Hi,

Am I to take it that it is not possible to use SQL for the clients.conf
file? And if that it the case could someone please explain what the nas
table is for in the database schema?

Cheers, Ben

On Wed, 2005-09-14 at 22:42 +0100, Ben Dowling wrote:
 Hi,
 
 Is it possible to replace clients.conf with an SQL table? I assume that
 is what the NAS table is for in the schema, but I have seen no mention
 of it being used, or any documentation, for it on the web.
 
 If it is possible could you please provide me with an example setup.
 
 Cheers, Ben
 
 - 
 List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

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

Re: SQL replacement for clients.conf?

2005-09-15 Thread Ben Dowling 
On Wed, 2005-09-14 at 22:42 +0100, Ben Dowling wrote:
 Hi,
 
 Is it possible to replace clients.conf with an SQL table? I assume that
 is what the NAS table is for in the schema, but I have seen no mention
 of it being used, or any documentation, for it on the web.
 
 If it is possible could you please provide me with an example setup.
 
 Cheers, Ben
 
 - 
 List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

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

Re: SQL replacement for clients.conf?

2005-09-15 Thread Alan DeKok 
 Am I to take it that it is not possible to use SQL for the clients.conf
 file? And if that it the case could someone please explain what the nas
 table is for in the database schema?

  It's possible.  You do need at least one entry in clients.conf,
though.  I suggest 127.0.0.1

  Then, read sql.conf, and set readclients=yes

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

Re: SQL replacement for clients.conf?

2005-09-15 Thread Guy Fraser 
On Thu, 2005-15-09 at 15:08 -0400, Alan DeKok wrote:
  Am I to take it that it is not possible to use SQL for the clients.conf
  file? And if that it the case could someone please explain what the nas
  table is for in the database schema?
 
   It's possible.  You do need at least one entry in clients.conf,
 though.  I suggest 127.0.0.1
 
   Then, read sql.conf, and set readclients=yes
 
   Alan DeKok.

Cool.

I am working with FreeBSD and the updates for 1.0.5 are not 
in the cvsup repository yet, so my comment is in regards to 
1.0.4, but may apply to 1.0.5.

I to a look at the postgresql stuff and it appears as though 
the schema will need a little tweak in order to be compitible 
with rlm_sql.c's requirements.

A SERIAL column named Id will need to be added.

This will make it compatible :

-- SQL clients table
CREATE TABLE nas (
id  SERIAL PRIMARY KEY,
nasname VARCHAR(128),
shortname   VARCHAR(32) NOT NULL,
typeVARCHAR(30),
ports   int4,
secret  VARCHAR(60) NOT NULL,
community   VARCHAR(50),
description TEXT
);

This is not required, but this info used to be in the nas
table in the postgresql schema.

-- additional nas info table included in previous nas table
CREATE TABLE nas (
id  int4 NOT NULL,
ipaddr  INET PRIMARY KEY,
snmpVARCHAR(10),
naslocation VARCHAR(32)
);




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

SQL replacement for clients.conf?

2005-09-14 Thread Ben Dowling 
Hi,

Is it possible to replace clients.conf with an SQL table? I assume that
is what the NAS table is for in the schema, but I have seen no mention
of it being used, or any documentation, for it on the web.

If it is possible could you please provide me with an example setup.

Cheers, Ben

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