but you are assigning ip with your NAS, I need a schema that has ip pool provision. Honestly, I'm not sure if it will work with MySQL.
On Tue, 2004-10-26 at 04:03, Martin Jessa wrote: > 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
