C
@srvrgt said in [HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step:
FOLLOWUP, in case anyone is hitting the same problem as me, the problem is with freeradius3, so first of all you need to change the attribute type on the file ozy-captive :
From : “INTO radcheck (username, attribute, value) VALUES (?, ‘Password’, ?)”)) "
TO: INTO radcheck (username, attribute, value) VALUES (?, ‘Cleartext-Password’, ?)"))
And then you need to change the file Schema.sql BEFORE you add it to the radius database
FROM:
CREATE TABLE radcheck (
id int(11) unsigned NOT NULL auto_increment,
username varchar(64) NOT NULL default ‘’,
attribute varchar(64) NOT NULL default ‘’,
op char(2) NOT NULL DEFAULT ‘==’,
value varchar(253) NOT NULL default ‘’,
PRIMARY KEY (id),
KEY username (username(32))
) ;
TO:
CREATE TABLE radcheck (
id int(11) unsigned NOT NULL auto_increment,
username varchar(64) NOT NULL default ‘’,
attribute varchar(64) NOT NULL default ‘’,
op char(2) NOT NULL DEFAULT ‘:=’,
value varchar(253) NOT NULL default ‘’,
PRIMARY KEY (id),
KEY username (username(32))
) ;
I hope this helps anyone My problem was with pfsense 2.3.4 FRERADIUS 3
Hi, @deajan, hi @rudat . I can confirm @srvrgt post. I've used the base work to setup a small captive portal in a hotel. Everything used to worked great until I upgraded to the latest version of pfSense/OzyCaptive-single-step. It stopped working. After modifying the table structure as per srvrgt advice, everything works flawlessly again.
I think you should update your code in the project repo, specifying that your latest version requires pfSense 2.4.3/freeradius3.
Thanks everybody for the outstanding work!
P.S.: Does anyone know a simple way to limit bandwidth on per-user basis? (something like this -obviously fictional -
INSERT INTO radcheck (id, username, attribute, op, value) VALUES (NULL, ‘Eleonor’, ‘Max-Input-Bandwidth’, ‘<=’, ‘5242880’);
