Hi. I use Mikrotik as my NAS server and there i have configured an IP-Pool called Official And this is my SQL:
CREATE TABLE radreply ( id int(11) unsigned NOT NULL auto_increment, UserName varchar(64) NOT NULL default '', Attribute varchar(32) NOT NULL default '', op char(2) NOT NULL default '=', Value varchar(253) NOT NULL default '', prio int(10) unsigned NOT NULL default '0', PRIMARY KEY (id), KEY UserName (UserName(32)) ) TYPE=MyISAM; INSERT INTO radreply VALUES (341,'username','Ascend-Data-Rate','=','524288',0); INSERT INTO radreply VALUES (340,'username','Ascend-Data-Rate','=','524288',1); INSERT INTO radreply VALUES (339,'username','Port-Limit','=','1',0); INSERT INTO radreply VALUES (338,'username','Framed-IP-Address','=','255.255.255.254',0); INSERT INTO radreply VALUES (402,'username','Framed-Pool',':=','Official',0); Any other values are taken care of by the NAS server. Cheers. On Tue, 26 Oct 2004 14:09:55 -0700 ral <[EMAIL PROTECTED]> wrote: > Hi, > > I'm trying to use mysql with freeradius, my problem is, it looks like ip > pool doesn't work, I'm not sure with my schema though, can anyone give > me a sample of the schema for this? > > > Thanks. > > Lito > > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html