Hello, ok I’m busy starting a WISP and so I’m designing a website where users can register and automatically get a pppoe account after paying for 1 of the 3 available internet packages. I’m using freeradius with mysql, everything is working except for one problem I’ve ran into.
I have 3 IP ranges on which the users connect once authenticated, each different “internet package” of which there’s 3 is on a different ip range for example:
users on package 1 : 192.168.0.0/24 (default gateway needs to be 192.168.0.254)
users on package 2 : 192.168.1.0/24 (default gateway needs to be 192.168.1.254)
users on package 3 : 192.168.2.0/24 (default gateway needs to be 192.168.2.254)
The problem is I need a MySQL attribute on FreeRADIUS that can control the IP address named “Local Address” on my PPP profile on routeros. I’m sure this must be posible as I’m using MySQL + FreeRADIUS to control the “Remote Address” on the existing PPP profile, I just can’t seem to get google to take me there 
. Below is the MySQL code of the 3 user groups:
CREATE TABLE radgroupreply (
id int(11) unsigned NOT NULL auto_increment,
groupname varchar(64) NOT NULL default '',
attribute varchar(32) NOT NULL default '',
op char(2) NOT NULL DEFAULT '=',
value varchar(253) NOT NULL default '',
PRIMARY KEY (id),
KEY groupname (groupname(32))
) ;
INSERT INTO radgroupreply (groupname, attribute, op, value) VALUES
-- Group1 Package Users (need their gw to be 192.168.0.254)
--
('Group1','Framed-Compression','==','Van-Jacobsen-TCP-IP'),
('Group1','Framed-Protocol','==','PPP'),
('Group1','Session-Timeout',':=','84800'),
('Group1','Port-Limit',':=','1'),
('Group1','Framed-Routing',':=','Broadcast-Listen'),
('Group1','Mikrotik-Rate-Limit',':=','256K/512K 512K/1024K 256K/512K 45/60 3'),
('Group1','Framed-IP-Netmask',':=','255.255.255.0'),
('Group1','Framed-Pool',':=','Group1'),
('Group1','Service-Type','==','Framed-User'),
-- Group2 Package Users (need their gw to be 192.168.1.254)
--
('Group2','Framed-Compression','==','Van-Jacobsen-TCP-IP'),
('Group2','Framed-Protocol','==','PPP'),
('Group2','Session-Timeout',':=','84800'),
('Group2','Port-Limit',':=','1'),
('Group2','Framed-Routing',':=','Broadcast-Listen'),
('Group2','Mikrotik-Rate-Limit',':=','384K/768K 768K/1536K 384K/768K 30/45 5'),
('Group2','Framed-IP-Netmask',':=','255.255.255.128'),
('Group2','Framed-Pool',':=','Group2'),
('Group2','Service-Type','==','Framed-User'),
-- Group3 Package Users (need their gw to be 192.168.2.254)
--
('Group3','Framed-Compression','==','Van-Jacobsen-TCP-IP'),
('Group3','Framed-Protocol','==','PPP'),
('Group3','Session-Timeout',':=','84800'),
('Group3','Port-Limit',':=','1'),
('Group3','Framed-Routing',':=','Broadcast-Listen'),
('Group3','Mikrotik-Rate-Limit',':=','512K/1024K 1024K/2048K 512K/1024K 15/30 7'),
('Group3','Framed-IP-Netmask',':=','255.255.255.255'),
('Group3','Framed-Pool',':=','Group3'),
('Group3','Service-Type','==','Framed-User');
Thanks in advance I can really use the help.