[HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step

giovani.junior · Jul 4, 2017, 12:30 PM

@giovani.junior:

…. when I click on confirm button appears 404 error. After hours and hours looking for what could be happening I gave up and decided to start over again, building a new VM.
In the second VM I took the same case: MySql and Freeradius are working fine, but now when I click on confirm button appears a blank page without any error. In browser address bar appears the Server IP + /$ symbol.
....

(The captive portal) web server log didn't mention what happened ??
Are you using the default built-in captive portal page ?

@Gertjan, the web server log doesn't show anything interesting or any error.
No, I am using the captive portal developed by deajan!
My best rgds!

giovani.junior · Jul 4, 2017, 12:33 PM

@deajan:

@giovani.junior: Don't use the integrated view button as behavior changed in 2.3.2+, see https://forum.pfsense.org/index.php?topic=132106.0
Also, have you configured the redirection address for the CP ?

@deajan, sorry me because my ignorance, but where is this view button? Is it a captive portal configuration or a resource in web page?
Yes, I had configured the redirection address to http://www.google.com.
My best regards!

giovani.junior · Jul 5, 2017, 12:31 PM

Hi guys!
I took a print screen from login e post login captive portal page.
Please, any idea?

![CP Image Login.png](/public/imported_attachments/1/CP Image Login.png)
![CP Image Login.png_thumb](/public/imported_attachments/1/CP Image Login.png_thumb)
![CP Post Login.png](/public/imported_attachments/1/CP Post Login.png)
![CP Post Login.png_thumb](/public/imported_attachments/1/CP Post Login.png_thumb)

Gertjan · Jul 5, 2017, 1:18 PM

@giovani.junior:

CP Post Login.png (23.07 kB, 1920x1032 - viewed 0 times.)

That image shows the problem very well.
http://192.168.56.200:8002/?
isn't a valid URL (IP is ok, port 8002 also - but with the file called '?' the web server (Nginx) will yell … euh log something and show you the file not found error - also known as world's famous "404".

Knowing that the correct URL will be build with "$PORTAL_ACTION$" I wonder what your this variable is in your case.

Edit your portal.html (and portal.php or whatever files are used to create te loggin page, and add this " html code ":

...

PORTAL_ACTION == [$PORTAL_ACTION$]

....

With my portal, this line shows :

PORTAL_ACTION == [https://brit-hotel-fumel.net:8003/index.php?zone=cpzone1]

and this is a valid URL (works with my pfSense setup - I'm using https, this explains the "8003" port - and the zone name is 'cpzone1')

So, what about showing your "portal login html files" ?

edit : I didn't test-drive, but this :
https://github.com/deajan/pfSense-cp-auth-onestep/blob/master/ozy-captive.php#L331
looks fine to me.

giovani.junior · Jul 6, 2017, 12:41 PM

Good morning Gertjan!
I am sending the index.php file.
Sincerly, I don't know what to do. I read a lot of docs about captive portal and followed the advices from other people with the same problem, but nothing is working.
My best regards and thanks by your attention!

index.txt

srvrgt · Jul 6, 2017, 11:35 PM

heyy guys, first of all thank you Deajan for the amazing work, really, it helps alot, now to my problem, i am currently on pfsense 2.3.4, and everything seems to be working fine except for the radius login part, i can see the users in the MYSQL database but they are all Rejected, the configuration of the ports on the radius server is ok, i was able to find this in the logs

"Invalid user (sql1: Failed to create the pair: Invalid vendor name in attribute name "Password"): [123] (from client tester port 2010 cli "

i believe from what ive read that there is no such thing as apassword atribute, it must be Cleartext-Password, the problem is that i cant seem to find where to change the value, could you please help me out?,

FYI if i use the test user and test password i can log in no problem and the mysql database also reflects that, so im guessing its just some sintaxis problem.

thanks

Gertjan · Jul 7, 2017, 9:42 AM

I'd like to mention that I'm NOT using Freeradius and MySQL to handle te Captive portal clients.
(I just 'stole' somewhat the GUI part).
I'm running the Captive portal for a hotel for many years now - just using the local client database, built into pfSense.

I tend to keep it simple, which guarantees that my portal is always available, which is THE most important thing for my clients.

Tracking or accounting my clients is not one of my priorities - I'm not selling Internet access - I just offer it.

srvrgt · Jul 7, 2017, 11:57 PM

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

alpax · Jul 26, 2017, 10:53 AM

@deajan thanks for the easy to follow tutorial. do you have tutorial on a case which users are limited to a certain amount of data?

charlesbiesseki · Aug 11, 2017, 2:29 PM

Good morning guys, I'm having this problem.

PHP ERROR: Type: 1, File: /var/etc/captiveportal_publicwifi.html, Line: 157, Message: Class 'mysqli' not found @ 2017-08-11 08:54:53

Gertjan · Aug 12, 2017, 10:27 AM

@charlesbiesseki:

Good morning guys, I'm having this problem.

PHP ERROR: Type: 1, File: /var/etc/captiveportal_publicwifi.html, Line: 157, Message: Class 'mysqli' not found @ 2017-08-11 08:54:53

This is what the error says :
Your are using "PHP mysqli extension" command(s) in your own portal login page. You can't. The PHP msqli extension library should be installed first.
I can't tell you how to do that on pfgSense. It might be possible.

mastrus · Aug 25, 2017, 6:35 PM

Hi everyone, I want to changhe the page after portal login, with putting some image to make it more readable.

I see that there are two variable in captiveportal-config.php $continue_string, $noScript_string, but i can't see it in the php main page.

Someone can me say where these variables are used, and where is the page after the portal login?

mackykulitz · Sep 4, 2017, 12:59 PM

@Gertjan:

@charlesbiesseki:

Good morning guys, I'm having this problem.

PHP ERROR: Type: 1, File: /var/etc/captiveportal_publicwifi.html, Line: 157, Message: Class 'mysqli' not found @ 2017-08-11 08:54:53

This is what the error says :
Your are using "PHP mysqli extension" command(s) in your own portal login page. You can't. The PHP msqli extension library should be installed first.
I can't tell you how to do that on pfgSense. It might be possible.

Install mysqli with pkg

mackykulitz · Oct 7, 2017, 9:12 AM

Hi Deajan,

I have configured your setup on my pfsense perfectly.

may i ask how can i set the time limit of the newly registered users and reset the time

ex: new user register, it will have access to internet for 3 hours then disconnect and can only reconnect without having to re-register after lets say after 12 hours.

and thanks for a great guide very much appreciated.. :)

nunoabsilva · Oct 26, 2017, 8:09 AM

Hi All,

anyone already have this working with pfsense 2.4.1?

thanks in advanced.

rudat · Nov 1, 2017, 11:56 PM

Maybe I found the solution for problem 2
in the File ozy-captive.php I changed the string "Password" to "Cleartext-Password"

if (!$statement = $db->prepare("INSERT INTO radcheck (username, attribute, value) VALUES (?, 'Cleartext-Password', ?)"))

can someone be so kind and confirm the solution?

Update
I solved the problem Nr.1 using the last new version v0.48 - 03 May 2017
download from https://github.com/deajan/pfSense-cp-auth-onestep

Promlem 2 now
after click on connect I recieve "Invalid credentials specfied" with the default
landing page username / password

–-----------------
Promlem 1
I receive the Message: „Cannot check database for user.(1) after click on connect at the landing page.
I need some help how to go forward debugging ,

Radius seams to be up and running
/root/pfSense-cp-auth-onestep/sql: radtest testu testp 127.0.0.1:1812 0 SuperTest
Sent Access-Request Id 87 from 0.0.0.0:5851 to 127.0.0.1:1812 length 75
User-Name = "testu"
User-Password = "testp"
NAS-IP-Address = 192.168.1.1
NAS-Port = 0
Message-Authenticator = 0x00
Cleartext-Password = "testp"
Received Access-Accept Id 87 from 127.0.0.1:1812 to 0.0.0.0:0 length 20

#even mysql is up and running

in schema.sql I changed in "CREATE TABLE radcheck" the line "op char(2) NOT NULL DEFAULT ':='," already
Running 2.4.1 with Freeradius 3

P.S
ozy-captive.php
@mysql_select_db(DBNAME, $con); seams to work
but this seams to fail ....

$query = "INSERT INTO reg_users (familyName, surName, roomNumber, emailAddress, macAddress, ipAddress, regDate, identificator, newsletter) VALUES ('$familyName', '$surName', '$roomNumber', '$emailAddress', '$macAddress' , '$ipAddress', '$regDate', '$identificator', '$newsletter');";

retestreak · Oct 31, 2017, 10:46 PM

I'm running the latest version of pfsense with freeradius3
I followed every detail in the guide but I still cant manage to make everything work.

I did try what user "srvrgt" suggested except changing the "==" to ";=" resulted in having an attribute error. ( I left the schema file as it was "==")
I've only changed the password value to cleartext-password in the php file.

Now I am facing 2 issues.

1. Whenever a client connects and fills in the form the user gets created in sql but somehow it is not showing up on radius clients tab.

2. When a client submits the form they first get redirected to the new captive portal after clicking the accept button the default pfsense captive portal comes on with the error code that username/password is wrong however
authentication for user testu:testp works because it is in the clients tab on radius

If someone could help me that would be great!
Thank you in advance

rudat · Nov 1, 2017, 9:14 AM

in the Post is written „:=„ an not „;=„ also a change im the php file

rudat · Nov 1, 2017, 3:10 PM

@retestreak:

I'm running the latest version of pfsense with freeradius3
I followed every detail in the guide but I still cant manage to make everything work.

I did try what user "srvrgt" suggested except changing the "==" to ";=" resulted in having an attribute error. ( I left the schema file as it was "==")
I've only changed the password value to cleartext-password in the php file.

Now I am facing 2 issues.

1. Whenever a client connects and fills in the form the user gets created in sql but somehow it is not showing up on radius clients tab.

2. When a client submits the form they first get redirected to the new captive portal after clicking the accept button the default pfsense captive portal comes on with the error code that username/password is wrong however
authentication for user testu:testp works because it is in the clients tab on radius

If someone could help me that would be great!
Thank you in advance

I used the version form v0.48 - 03 May 2017
download from https://github.com/deajan/pfSense-cp-auth-onestep

rudat · Nov 1, 2017, 9:34 PM

@srvrgt:

heyy guys, first of all thank you Deajan for the amazing work, really, it helps alot, now to my problem, i am currently on pfsense 2.3.4, and everything seems to be working fine except for the radius login part, i can see the users in the MYSQL database but they are all Rejected, the configuration of the ports on the radius server is ok, i was able to find this in the logs

"Invalid user (sql1: Failed to create the pair: Invalid vendor name in attribute name "Password"): [123] (from client tester port 2010 cli "

i believe from what ive read that there is no such thing as apassword atribute, it must be Cleartext-Password, the problem is that i cant seem to find where to change the value, could you please help me out?,

FYI if i use the test user and test password i can log in no problem and the mysql database also reflects that, so im guessing its just some sintaxis problem.

thanks

Do you found a Solution?