Hi, Make use of '=' opperand instead of ':=' for Reply Attribute . And don't forget to read Docs ;-)
On Tuesday 26 October 2004 14: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 -- Best Regards, Nachko Halachev - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
