Errors after updating

BenBellamy · Mar 3, 2020, 6:39 PM

I updated to 2.4.4-RELEASE-p3 (amd64) a short time ago and before the system rebooted it reported that that upgrade had failed, but then after rebooting it seems to be running. However, there are several php errors reported, show below. I am new to pfSense, having inherited it a month ago. Any explanation, assistance, or suggestions would be much appreciated.

[03-Mar-2020 12:54:38 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, '341a:81:97:...', '10.0.1.140')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 12:56:34 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, '341a:81:97:...', '10.0.1.140')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 12:56:42 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, 'f0:79:60:29:dd:...', '10.0.1.230')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 12:57:50 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, '341a:81:97:...', '10.0.1.140')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 12:58:38 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, '341a:81:97:...', '10.0.1.140')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 13:00:21 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, 'fc:fc:48b1:...', '10.0.1.113')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 13:00:27 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, 'fc:fc:48b1:...', '10.0.1.113')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 13:00:57 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, 'fc:fc:48b1:...', '10.0.1.113')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 13:02:45 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, 'f0:79:60:29:dd:...', '10.0.1.230')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 13:04:19 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, 'f0:79:60:29:dd:...', '10.0.1.230')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 13:04:41 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, '341a:81:97:...', '10.0.1.140')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157
[03-Mar-2020 13:05:00 America/Kentucky/Louisville] PHP Fatal error: Uncaught Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157
Stack trace:
#0 /etc/inc/pfsense-utils.inc(2646): include()
#1 /etc/inc/captiveportal.inc(2147): get_include_contents('/var/etc/captiv...')
#2 /usr/local/captiveportal/index.php(248): portal_reply_page('http://capitalc...', 'login', NULL, 'f0:79:60:29:dd:...', '10.0.1.230')
#3 {main}
thrown in /var/etc/captiveportal_guestwifi.html on line 157

Gertjan · Mar 4, 2020, 3:14 PM

@BenBellamy said in Errors after updating:

Error: Class 'mysqli' not found in /var/etc/captiveportal_guestwifi.html:157

This means that a 'self made' captive portal login page contains PHP code.
Fastest solution : activate the build in, default login page.
Or, rean on :
The PHP in the login page script 'html' file uses mysqli PHP data base functions.
Or the PHP lib extension 'mysql" isn't installed, probably because something was installed that includes this PHP lib before, like (I think - have to check) the pfSense freeradius package, and removed since.

If freeradius is still installed, and your issue starts after a recent RC (?) update, open an SSH option 8 command line and enter :

/etc/rc.d/ldconfig start
ELF ldconfig path: /lib /usr/lib /usr/lib/compat /usr/local/lib /usr/local/lib/freeradius-3.0.20 /usr/local/lib/ipsec /usr/local/lib/mysql /usr/local/lib/perl5/5.30/mach/CORE
32-bit compatibility ldconfig path: /usr/lib32

No need to reboot.
As you can see, "mysql PGP libs" can now be found, and you'll be ok.

BenBellamy · Mar 4, 2020, 7:23 PM

@Gertjan Thank you VERY much! I appreciate your time and effort!