Errors after updating



  • 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, '34๐Ÿ‡ฉ๐Ÿ‡ช1a: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, '34๐Ÿ‡ฉ๐Ÿ‡ช1a: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, '34๐Ÿ‡ฉ๐Ÿ‡ช1a: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, '34๐Ÿ‡ฉ๐Ÿ‡ช1a: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:48๐Ÿ†Žb1:...', '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:48๐Ÿ†Žb1:...', '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:48๐Ÿ†Žb1:...', '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, '34๐Ÿ‡ฉ๐Ÿ‡ช1a: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



  • @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.



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


Log in to reply