[HOWTO] Captive portal + FreeRADIUS + local MySQL user friendly single step
-
I think I wrote about this in section 2.1.2.
Anyway, thanks for the feedback. -
Ahhh I see your right. I must have missed that some how. Anyway thanks again!
-
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
-
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?
-
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.
-
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!
-
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 repositoriesAlmost 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
-
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. -
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
-
What's your output of php -m ?
-
[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
-
It seems that the mysql extension is there.
Can you please restart php-fpm ? And if it does not work, restart pfSense ? -
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?
-
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.
-
Many thanks - all working now.
-
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
-
As stated above, you have the php mysql extension.
Please restart php-fpm from console and try again. -
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
-
is it possible to use a node.js file for the captive portal? Or using mongodb?
-
@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
-
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 ).
-
I found on log crash of pfsense as :
Crash report begins. Anonymous machine information: amd64 10.3-RELEASE FreeBSD 10.3-RELEASE #6 05adf0a(RELENG_2_3_0): Mon Apr 11 18:52:07 CDT 2016 root@ce23-amd64-builder:/builder/pfsense-230/tmp/obj/builder/pfsense-230/tmp/FreeBSD-src/sys/pfSense Crash report details: PHP Errors: [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/ecl.php:0 [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/ecl.php:34 [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP 3\. require_once() /etc/inc/functions.inc:170 [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP 4\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:49 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.bootup:33 [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP 3\. require_once() /etc/inc/pkg-utils.inc:58 [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP 4\. require_once() /etc/inc/service-utils.inc:56 [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/captiveportal.inc:58 [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:50 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.linkup:0 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.linkup:34 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 2\. parse_config_bootup() /etc/rc.bootup:162 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.lib.inc:309 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 2\. parse_config_bootup() /etc/rc.bootup:162 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 3\. alias_make_table() /etc/inc/config.lib.inc:328 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.linkup:0 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.linkup:34 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:51 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 2\. interfaces_configure() /etc/rc.bootup:250 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 3\. interface_configure() /etc/inc/interfaces.inc:1112 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 4\. interface_netgraph_needed() /etc/inc/interfaces.inc:3425 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 2\. interfaces_configure() /etc/rc.bootup:250 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 3\. interface_configure() /etc/inc/interfaces.inc:1112 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 4\. interface_netgraph_needed() /etc/inc/interfaces.inc:3425 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 2\. openvpn_resync_all() /etc/rc.bootup:261 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 3\. openvpn_create_dirs() /etc/inc/openvpn.inc:1309 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 2\. filter_configure_sync() /etc/rc.bootup:268 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 3\. filter_nat_rules_generate() /etc/inc/filter.inc:297 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 4\. filter_nat_rules_automatic_tonathosts() /etc/inc/filter.inc:2093 [21-Jul-2016 11:09:52 Asia/Ho_Chi_Minh] PHP 5\. get_staticroutes() /etc/inc/filter.inc:1594 [21-Jul-2016 11:09:53 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:53 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/sshd:0 [21-Jul-2016 11:09:53 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/sshd:33 [21-Jul-2016 11:09:53 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:53 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 2\. system_routing_configure() /etc/rc.bootup:299 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 3\. system_staticroutes_configure() /etc/inc/system.inc:657 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 4\. get_staticroutes() /etc/inc/system.inc:667 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 2\. services_unbound_configure() /etc/rc.bootup:308 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 3\. sync_unbound_service() /etc/inc/services.inc:2194 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 4\. unbound_generate_config() /etc/inc/unbound.inc:489 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 5\. unbound_acls_config() /etc/inc/unbound.inc:169 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 6\. filter_nat_rules_automatic_tonathosts() /etc/inc/unbound.inc:766 [21-Jul-2016 11:09:54 Asia/Ho_Chi_Minh] PHP 7\. get_staticroutes() /etc/inc/filter.inc:1594 [21-Jul-2016 11:09:55 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:55 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.bootup:0 [21-Jul-2016 11:09:55 Asia/Ho_Chi_Minh] PHP 2\. filter_configure_sync() /etc/rc.bootup:337 [21-Jul-2016 11:09:55 Asia/Ho_Chi_Minh] PHP 3\. filter_nat_rules_generate() /etc/inc/filter.inc:297 [21-Jul-2016 11:09:55 Asia/Ho_Chi_Minh] PHP 4\. filter_nat_rules_automatic_tonathosts() /etc/inc/filter.inc:2093 [21-Jul-2016 11:09:55 Asia/Ho_Chi_Minh] PHP 5\. get_staticroutes() /etc/inc/filter.inc:1594 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.dyndns.update:0 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.dyndns.update:31 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.banner:0 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.banner:32 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:56 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:09:59 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:09:59 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.start_packages:0 [21-Jul-2016 11:09:59 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.start_packages:31 [21-Jul-2016 11:09:59 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:09:59 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.conf_mount_rw:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.conf_mount_rw:31 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. display_login_form() /etc/inc/authgui.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/authgui.inc:198 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/shaper.inc:62 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/functions.inc:170 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 9\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 10\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 11\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. display_login_form() /etc/inc/authgui.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. filter_generate_optcfg_array() /etc/inc/authgui.inc:199 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. display_login_form() /etc/inc/authgui.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. filter_generate_optcfg_array() /etc/inc/authgui.inc:199 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. display_login_form() /etc/inc/authgui.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/authgui.inc:198 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/shaper.inc:62 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/functions.inc:170 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 9\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 10\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 11\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. display_login_form() /etc/inc/authgui.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. filter_generate_optcfg_array() /etc/inc/authgui.inc:199 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 4\. display_login_form() /etc/inc/authgui.inc:63 [21-Jul-2016 11:10:01 Asia/Ho_Chi_Minh] PHP 5\. filter_generate_optcfg_array() /etc/inc/authgui.inc:199 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.conf_mount_ro:0 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.conf_mount_ro:31 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 1\. {main}() /etc/rc.banner:0 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 2\. require_once() /etc/rc.banner:32 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 3\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:02 Asia/Ho_Chi_Minh] PHP 4\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 5\. get_configured_ip_addresses() /etc/inc/auth.inc:201 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/util.inc:1399 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 9\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 10\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/index.php:0 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/index.php:73 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 5\. get_configured_ip_addresses() /etc/inc/auth.inc:201 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/util.inc:1399 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 9\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:05 Asia/Ho_Chi_Minh] PHP 10\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/widgets/widgets/system_information.widget.php:0 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/widgets/widgets/system_information.widget.php:58 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 3\. require_once() /etc/inc/functions.inc:170 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 4\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/widgets/widgets/system_information.widget.php:0 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/widgets/widgets/system_information.widget.php:59 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 3\. header() /usr/local/www/guiconfig.inc:72 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/widgets/widgets/system_information.widget.php:0 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/widgets/widgets/system_information.widget.php:59 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 3\. header() /usr/local/www/guiconfig.inc:73 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/widgets/widgets/system_information.widget.php:0 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/widgets/widgets/system_information.widget.php:59 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 3\. header() /usr/local/www/guiconfig.inc:74 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/widgets/widgets/system_information.widget.php:0 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/widgets/widgets/system_information.widget.php:59 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 3\. header() /usr/local/www/guiconfig.inc:75 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/widgets/widgets/system_information.widget.php:0 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/widgets/widgets/system_information.widget.php:59 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 3\. header() /usr/local/www/guiconfig.inc:78 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/widgets/widgets/system_information.widget.php:0 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/widgets/widgets/system_information.widget.php:59 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 4\. session_auth() /etc/inc/authgui.inc:62 [21-Jul-2016 11:10:10 Asia/Ho_Chi_Minh] PHP 5\. session_start() /etc/inc/auth.inc:1573 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/getstats.php:0 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/getstats.php:69 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/getstats.php:0 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/getstats.php:69 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 5\. get_configured_ip_addresses() /etc/inc/auth.inc:201 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/util.inc:1399 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 9\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:17 Asia/Ho_Chi_Minh] PHP 10\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/getstats.php:0 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/getstats.php:69 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/getstats.php:0 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 2\. require_once() /usr/local/www/getstats.php:69 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 5\. get_configured_ip_addresses() /etc/inc/auth.inc:201 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/util.inc:1399 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 9\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:28 Asia/Ho_Chi_Minh] PHP 10\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/crash_reporter.php:0 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 2\. require() /usr/local/www/crash_reporter.php:63 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/crash_reporter.php:0 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 2\. require() /usr/local/www/crash_reporter.php:63 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 5\. get_configured_ip_addresses() /etc/inc/auth.inc:201 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/util.inc:1399 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 9\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:10:31 Asia/Ho_Chi_Minh] PHP 10\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/crash_reporter.php:0 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 2\. require() /usr/local/www/crash_reporter.php:63 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/crash_reporter.php:0 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 2\. require() /usr/local/www/crash_reporter.php:63 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 5\. get_configured_ip_addresses() /etc/inc/auth.inc:201 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/util.inc:1399 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 9\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:11:13 Asia/Ho_Chi_Minh] PHP 10\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/crash_reporter.php:0 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 2\. require() /usr/local/www/crash_reporter.php:63 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 5\. require_once() /etc/inc/auth.inc:63 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 6\. parse_config() /etc/inc/config.gui.inc:92 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 7\. alias_make_table() /etc/inc/config.lib.inc:185 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP Stack trace: [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 1\. {main}() /usr/local/www/crash_reporter.php:0 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 2\. require() /usr/local/www/crash_reporter.php:63 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 3\. require_once() /usr/local/www/guiconfig.inc:79 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 4\. include_once() /etc/inc/authgui.inc:55 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 5\. get_configured_ip_addresses() /etc/inc/auth.inc:201 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 6\. require_once() /etc/inc/util.inc:1399 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 7\. require_once() /etc/inc/interfaces.inc:61 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 8\. require_once() /etc/inc/gwlb.inc:54 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 9\. parse_config() /etc/inc/config.inc:218 [21-Jul-2016 11:11:16 Asia/Ho_Chi_Minh] PHP 10\. alias_make_table() /etc/inc/config.lib.inc:185 Filename: /var/crash/minfree 2048
-
@nhimcoi30889 Sorry to hear. But the error doesn't suggest the problem comes from the captiveportal files I've written.
What pfSense version are you running ?
Can you reproduce the error on a VM ? -
@abebraham:
is it possible to use a node.js file for the captive portal? Or using mongodb?
MySQL is used because of the FreeRADIUS authentication.
You may adapt the php script to whatever database your RADIUS server uses. -
@nhimcoi30889 Sorry to hear. But the error doesn't suggest the problem comes from the captiveportal files I've written.
What pfSense version are you running ?
Can you reproduce the error on a VM ?Hi deajan,
my issue resolved by rollback pfsense ver 2.2.6 (issue on ver >= 2.3 )
i have a question more. i found this on captiveportal-config.php file$confirmationCode = "0000";
If i want this code generate via mysql ?
For example, i gen about 100 codes map with 100 email and storage on database. When user input their email and confirmationCode after they access internet -
@nhimcoi30889 This captive portal isn't supposed to work that way. It's an "no account setup" portal page.
If you want to use it the way you describe, you should create the radius accounts you want with the confirmation code as password, and remove the part where the radius account is created from the main CP file.
-
Hi Deajan,
I can to create account on Radius with format email address ?
For example : test@abc.com -
@nhimcoi30889 Sorry but your sentence makes no sense to me. If your question was if radius supports emails as usernames, the answer is yes.
-
HI deajan,
today i just upgrade from 2.2.6 to 2.3.1 Release
After upgraded, i start mysql againt but show error :[2.3.1-RELEASE][admin@pfSense.it.mt]/root: service mysql-server.sh start Starting mysql. Bad -c option /usr/local/etc/rc.d/mysql-server.sh: WARNING: failed to start mysql
Can u help me?
-
Upgrades in 2.2.X are destructive for MySQL installation because they basically reinstalls a full OS.
Only 2.3.X upgrade series won't destroy anything because they work fine grained.In order to get things working again, you have to uninstall and reinstall mysql. Keep in mind that directions to install mysql for 2.3.x aren't the same as for 2.2.x.
-
Hi Deajan,
I tried remove old mysql and reinstall new version but problem the same
Can you give solution ? -
Hi deajan,
can you help me ? -
How am I supposed to know what happens with your setup without even knowing what you did to uninstall / reinstall mysql ?
-
Hi Deajan,
Do you try with pfsense 2.3.2 ?
I tried , the first it working normally
But after reboot mysql not working, and FreeRadius2 dont working
This is log when i start FreeRadius2Aug 10 17:14:04 radiusd 57335 rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked Aug 10 17:14:04 radiusd 57335 rlm_sql (sql): Attempting to connect to radius@127.0.0.1:3306/radius Aug 10 17:14:04 radiusd 57335 rlm_sql (sql): Attempting to connect rlm_sql_mysql #0 Aug 10 17:14:04 radiusd 57335 rlm_sql_mysql: Starting connect to MySQL server for #0 Aug 10 17:15:19 radiusd 57335 rlm_sql_mysql: Couldn't connect socket to MySQL server radius@127.0.0.1:radius Aug 10 17:15:19 radiusd 57335 rlm_sql_mysql: Mysql error 'Can't connect to MySQL server on '127.0.0.1' (60)' Aug 10 17:15:19 radiusd 57335 rlm_sql (sql): Failed to connect DB handle #0 Aug 10 17:15:19 radiusd 57335 rlm_sql (sql): There are no DB handles to use! skipped 5, tried to connect 0 Aug 10 17:15:19 radiusd 57335 Failed to load clients from SQL. Aug 10 17:15:19 radiusd 57335 rlm_sql (sql): Closing sqlsocket 4 Aug 10 17:15:19 radiusd 57335 rlm_sql (sql): Closing sqlsocket 3 Aug 10 17:15:19 radiusd 57335 rlm_sql (sql): Closing sqlsocket 2 Aug 10 17:15:19 radiusd 57335 rlm_sql (sql): Closing sqlsocket 1 Aug 10 17:15:19 radiusd 57335 rlm_sql (sql): Closing sqlsocket 0 Aug 10 17:15:19 radiusd 57335 /usr/local/etc/raddb/sql.conf[2]: Instantiation failed for module "sql" Aug 10 17:15:19 radiusd 57335 /usr/local/etc/raddb/sites-enabled/default[185]: Failed to find "sql" in the "modules" section. Aug 10 17:15:19 radiusd 57335 /usr/local/etc/raddb/sites-enabled/default[185]: Failed to parse "sql" entry. Aug 10 17:15:19 radiusd 57335 /usr/local/etc/raddb/sites-enabled/default[69]: Errors parsing authorize section. Aug 10 17:15:19 radiusd 57335 Failed to load virtual server <default></default>
This is error when connect mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
I tried add manual file my.cnf to /usr/local/etc/mysql/my.cnf but dont working
Can you give some recomment ?
Tks bro -
Hi Deajan.
Firstly a big thank for this great howto. Detailed and comprehensive.
Now, I apologize, I'm a newbee about pfSense (although an experienced Linux/PHP/DB/ecc. programmer), so my question might be trivial.
The network I'm trying to setup with your captive portal feature has a router (Zyxel) with REDIUS support. The router is also configured to act as DHCP server for my local network. Actually my pfSense machine/installation will be used ONLY for RADIUS/CaptivePortal authentication. In other words, my pfSense installation is configured in "appliance" mode, i.e. with the only one eth interface (WAN) enabled. I've configured the router to assign a static IP to my pfSense server.
The point now is this. When I create a CP zone in the WebConfigurator, at the bottom of the page I read the following hint:Don't forget to enable the DHCP server on the captive portal interface! Make sure that the default/maximum DHCP lease time is higher than the hard timeout entered on this page. Also, the DNS Forwarder or Resolver must be enabled for DNS lookups by unauthenticated clients to work.
What about the DHCP server on the CP interface? Do I need to disable the router's DHCP server, in order to have pfSense assign all the mess, or is there another way to configure the DNS resolver?
Thanks again for the great howto and any suggestion you'll give. -
Sorry for the late reply.
As long as the DNS is pfSense, I think you can use whatever DHCP server you like. -
I'm pretty sure that you have two instances of mysql running. Check with ps aux.
-
Hi deajan,
First thank you very much for this perfect HOWTO.
But I got a problem when i import the admin.sql script. Please have a look below:
mysql radius < admin.sql ERROR 1064 (42000) at line 31: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PRIVIELGES' at line 1
Do you have any idea how to fix it? I am running a brand new pfsense 2.3 on a PC. Thank you in advance.
-
There was a typo in admin.sql, should read PRIVILEGES and not PRIVIELGES.
Corrected on github. You may redownload the latest archive at https://github.com/deajan/pfSense-cp-auth-onestep/archive/master.zip -
There was a typo in admin.sql, should read PRIVILEGES and not PRIVIELGES.
Corrected on github. You may redownload the latest archive at https://github.com/deajan/pfSense-cp-auth-onestep/archive/master.zipMerci!!! Problem solved!!