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

MasterBill

Ahhh I see your right. I must have missed that some how. Anyway thanks again!

novensiles

Hallo,

I did all fine but get

PHP ERROR: Type: 1, File: /var/etc/captiveportal_oberemuehle.html, Line: 126, Message: Call to undefined function mysql_connect()

after typed in registring datas and send it.

php56-mysql is Installed

All Packages Updated + Upgraded

jmonline

On a brand new pfsense 2.3-RELEASE (amd64)

I have edited /usr/local/etc/pkg/repos/pfSense.conf and set the following value:

FreeBSD: { enabled: yes }

I have then run :

pkg update

Then:

pkg install nano git

This then results in:


pkg install nano git
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
Updating pfSense-core repository catalogue...
pfSense-core repository is up-to-date.
Updating pfSense repository catalogue...
pfSense repository is up-to-date.
All repositories are up-to-date.
New version of pkg detected; it needs to be installed first.
The following 1 package(s) will be affected (of 0 checked):

Installed packages to be REINSTALLED:
        pkg-1.6.2 [pfSense]

2 MiB to be downloaded.

Proceed with this action? [y/N]: y
Fetching pkg-1.6.2.txz: 100%    2 MiB 632.9kB/s    00:04
Checking integrity... done (0 conflicting)
[1/1] Reinstalling pkg-1.6.2...
You may need to manually remove /usr/local/etc/pkg.conf if it is no longer needed.
[1/1] Extracting pkg-1.6.2: 100%
Message from pkg-1.6.2:
If you are upgrading from the old package format, first run:

  # pkg2ng
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
Updating pfSense-core repository catalogue...
pfSense-core repository is up-to-date.
Updating pfSense repository catalogue...
pfSense repository is up-to-date.
All repositories are up-to-date.
New version of pkg detected; it needs to be installed first.
Checking integrity... done (0 conflicting)
The most recent version of packages are already installed
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
Updating pfSense-core repository catalogue...
pfSense-core repository is up-to-date.
Updating pfSense repository catalogue...
pfSense repository is up-to-date.
All repositories are up-to-date.
New version of pkg detected; it needs to be installed first.

This then loops over and over and does not stop.

The same then happens if I run

pkg install mysql56-server

What am I missing please?

nimamhd

This is the bug of pkg and will fix in pkg 1.7.2:

https://github.com/freebsd/pkg/issues/1303

"" pkg infinite loop with multiple repos containing different versions of pkg ""

you can comment out all other repo and install what you want, then restore the configuration to default.

after install, the pkg will update to the last version that may cause the pfsense package system stop working, to resolve this:

run:

"pkg delete -f pkg" and install it again with pfsense repo.

A Former User

Hello Ozy, thank you so much for taking the time to do this. I can not stress how helpful this is!

I know this is a lot to ask but if anyone is considering to make a how to video I would really appreciate this. I am not so fluent in this type of configuration. Thank you!

beewolf

I have set the FreeBSD: { enabled: yes } but when I try to install the mysql56-server I get:

Updating pfSense-core repository catalogue…
pfSense-core repository is up-to-date.
Updating pfSense repository catalogue...
pfSense repository is up-to-date.
All repositories are up-to-date.
pkg: No packages available to install matching 'mysql56-server' have been found in the repositories

Almost as if it is not looking in the FreeBSD repo.

I have restarted after enabling FreeBSD and gone back in to check that it is enabled.

Any ideas? Thanks

deajan

Hi,

I've updated the captive portal code a couple of days ago with some bug fixes and minor improvements.
Sorry for not having answered earlier, been in holidays :)

@novensiles: can you give the output of "php -m" ?
@abebraham: sorry, but I think the text howto is enough. It's also easier to update it than to update a video. Feel free to ask for help here on the forum or github.
@beewolf: Repo files slightly changed between 2.3-RC and 2.3 final. I've updated the doc for this.

beewolf

Many thanks for that - all installed fine with those changes but I am getting the following error on trying to log in:

PHP ERROR: Type 1, File /var/etc/captiveortal_guest_wifi.html, Line 127, Message: Call to undefined functionmysql_connect()

Probably something I have done but am struggling to find what exactly. Any ideas? Thanks

deajan

What's your output of php -m ?

beewolf

[2.3.1-RELEASE][root@pfSense.skh]/root/pfsense-cp-auth-onestep/sql: php -m


bcmath
bz2
Core
ctype
curl
date
dom
ereg
filter
gettext
hash
json
ldap
libxml
mbstring
mcrypt
mhash
mysql
mysqlnd
openssl
pcntl
pcre
PDO
pdo_sqlite
pfSense
posix
radius
readline
Reflection
rrd
session
shmop
SimpleXML
sockets
SPL
sqlite3
ssh2
standard
suhosin
sysvmsg
sysvsem
sysvshm
tokenizer
xdebug
xml
xmlreader
xmlwriter
Zend OPcache
zlib
zmq

[Zend Modules]
Xdebug
Zend OPcache

deajan

It seems that the mysql extension is there.
Can you please restart php-fpm ? And if it does not work, restart pfSense ?

beewolf

Yes, thank you that worked - I should have tried that first!!

All seems to be working now in a test environment - just one thing, Freeradius needs to be started manually after a restart. Is this usual? Would it be possible to add the service to the MySQL cron job so it definitely starts automatically?

deajan

I'll add a note about rebooting to the guide.

As for the freeradius service, it depends on mysql service.
As there is no loading order, sometimes freeradius loads before mysql and may fail.

In order to get FreeRADIUS working all the time, I've setup the watchdog package to restart failing services.

beewolf

Many thanks - all working now.

novensiles


bcmath
bz2
Core
ctype
curl
date
dom
ereg
filter
gettext
hash
json
ldap
libxml
mbstring
mcrypt
mhash
mysql
mysqli
mysqlnd
openssl
pcntl
pcre
PDO
pdo_sqlite
pfSense
posix
radius
readline
Reflection
rrd
session
shmop
SimpleXML
sockets
SPL
sqlite3
ssh2
standard
suhosin
sysvmsg
sysvsem
sysvshm
tokenizer
xdebug
xml
xmlreader
xmlwriter
Zend OPcache
zlib
zmq

[Zend Modules]
Xdebug
Zend OPcache

deajan

As stated above, you have the php mysql extension.
Please restart php-fpm from console and try again.

beewolf

My system has been running fine for a week - I had to restart to get the cables sorted neatly and now whatever I do I cant get Freeradius to start. There is another post here:

https://forum.pfsense.org/index.php?topic=109775.msg611138#msg611138

with similar symptoms to what I am getting and I have tried the suggestions in that but no difference.

I realise that this is probably a freeradius/pfsense problem but really need some help sorting it - I don't want to have to rebuild again!

Many thanks

A Former User

is it possible to use a node.js file for the captive portal? Or using mongodb?

Gertjan

@abebraham:

is it possible to use a node.js file for the captive portal? Or using mongodb?

and why posting the same question twice ? https://forum.pfsense.org/index.php?topic=115337.0

nhimcoi30889

Hello Deajan,
Thank for guideline detail .
I have a problem when install
This is log :

Warning: Illegal string offset 'alias' in /etc/inc/util.inc on line 1684 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0584 234576 2\. require_once('/etc/inc/functions.inc') /usr/local/www/services_captiveportal.php:66 0.0586 234952 3\. require_once('/etc/inc/interfaces.inc') /etc/inc/functions.inc:170 0.0591 254296 4\. require_once('/etc/inc/gwlb.inc') /etc/inc/interfaces.inc:61 0.0591 254928 5\. require_once('/etc/inc/config.inc') /etc/inc/gwlb.inc:54 0.0595 265032 6\. parse_config() /etc/inc/config.inc:218 0.0598 372400 7\. alias_make_table() /etc/inc/config.lib.inc:185 Warning: Cannot modify header information - headers already sent by (output started at /etc/inc/util.inc:1684) in /usr/local/www/guiconfig.inc on line 72 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0618 938296 2\. require_once('/usr/local/www/guiconfig.inc') /usr/local/www/services_captiveportal.php:75 0.0618 958632 3\. header() /usr/local/www/guiconfig.inc:72 Warning: Cannot modify header information - headers already sent by (output started at /etc/inc/util.inc:1684) in /usr/local/www/guiconfig.inc on line 73 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0618 938296 2\. require_once('/usr/local/www/guiconfig.inc') /usr/local/www/services_captiveportal.php:75 0.0620 958760 3\. header() /usr/local/www/guiconfig.inc:73 Warning: Cannot modify header information - headers already sent by (output started at /etc/inc/util.inc:1684) in /usr/local/www/guiconfig.inc on line 74 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0618 938296 2\. require_once('/usr/local/www/guiconfig.inc') /usr/local/www/services_captiveportal.php:75 0.0621 958696 3\. header() /usr/local/www/guiconfig.inc:74 Warning: Cannot modify header information - headers already sent by (output started at /etc/inc/util.inc:1684) in /usr/local/www/guiconfig.inc on line 75 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0618 938296 2\. require_once('/usr/local/www/guiconfig.inc') /usr/local/www/services_captiveportal.php:75 0.0622 958696 3\. header() /usr/local/www/guiconfig.inc:75 Warning: Cannot modify header information - headers already sent by (output started at /etc/inc/util.inc:1684) in /usr/local/www/guiconfig.inc on line 78 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0618 938296 2\. require_once('/usr/local/www/guiconfig.inc') /usr/local/www/services_captiveportal.php:75 0.0623 958696 3\. header() /usr/local/www/guiconfig.inc:78 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /etc/inc/util.inc:1684) in /etc/inc/auth.inc on line 1573 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0618 938296 2\. require_once('/usr/local/www/guiconfig.inc') /usr/local/www/services_captiveportal.php:75 0.0624 959088 3\. require_once('/etc/inc/authgui.inc') /usr/local/www/guiconfig.inc:79 0.0812 1242720 4\. session_auth() /etc/inc/authgui.inc:62 0.0812 1244776 5\. session_start() /etc/inc/auth.inc:1573 Warning: Cannot modify header information - headers already sent by (output started at /etc/inc/util.inc:1684) in /usr/local/www/services_captiveportal.php on line 87 Call Stack: 0.0583 234136 1\. {main}() /usr/local/www/services_captiveportal.php:0 0.0821 1277104 2\. header() /usr/local/www/services_captiveportal.php:87

At the moment, i cant access Service/Captive Portal ( this show above ).