Upgrade to Ubuntu 20.04.1 LTS with MSQL Server 8.0 Meltdown

Discussion in 'Server Operation' started by zapyahoo, Oct 14, 2020.

  1. zapyahoo

    zapyahoo Member

    The ubuntu server LTS upgrade came out and I do-release-upgrade from ubuntu 18 to ubuntu 20.04.
    This version comes packed with MSQL 8 that I also upgraded.
    I had Ispconfig 3.1.15p3 already installed.
    After the dist upgrade the ispconfig control panel on port 8080 turned into a blank page.
    I already dpkg-reconfigure mysql-server-8 and manually run ispconfig update php -q update.php. To no avail still blank page.
    The apache error log displays:
    Code:
    [Wed Oct 14 12:45:28.203972 2020] [fcgid:warn] [pid 2194] [client ***.***.56.1:46856] mod_fcgid: stderr: PHP Fatal error:  Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/interface/lib/app.inc.php:166
    [Wed Oct 14 12:45:28.204023 2020] [fcgid:warn] [pid 2194] [client ***.***.56.1:46856] mod_fcgid: stderr: Stack trace:
    [Wed Oct 14 12:45:28.204028 2020] [fcgid:warn] [pid 2194] [client ***.***.56.1:46856] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(93): app->conf('interface', 'session_timeout')
    [Wed Oct 14 12:45:28.204031 2020] [fcgid:warn] [pid 2194] [client ***.***.56.1:46856] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(381): app->initialize_session()
    [Wed Oct 14 12:45:28.204044 2020] [fcgid:warn] [pid 2194] [client ***.***.56.1:46856] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...')
    [Wed Oct 14 12:45:28.204047 2020] [fcgid:warn] [pid 2194] [client ***.***.56.1:46856] mod_fcgid: stderr: #3 {main}
    [Wed Oct 14 12:45:28.204050 2020] [fcgid:warn] [pid 2194] [client ***.***.56.1:46856] mod_fcgid: stderr:   thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 166
    
    Anyone else had this issue?
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    ISPConfig 3.1.15p3 neither supports Ubuntu 20.04 nor MySQL 8. You will have to upgrade to an ISPConfig 3.2 pre-release like the current nightly builds https://www.ispconfig.org/blog/ispconfig-nightly-builds-available-now/ to get your system back to a workings state if you don't want to revert the whole setup to the state before the dist upgrade.
     
  3. zapyahoo

    zapyahoo Member

    I see. Nope, do not want to revert.
    Is there a special update process from 3.1 to 3.2 or I just do the manual update with the nightly build?
    Thanks
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    Just do a manual update using the nightly build, then go through the Ubuntu 20.04 perfect server guide to ensure all required packages are installed and you might have to adjust the php settings to php 7.4 paths under System > server config in ISPConfig.
     
  5. zapyahoo

    zapyahoo Member

    Just did... found it here:
    https://www.ispconfig.org/blog/ispconfig-3-2-beta-3-released/
    Still getting blank page, error log:

    Code:
    [Wed Oct 14 13:32:22.919952 2020] [fcgid:warn] [pid 5343] [client ***.***..56.1:47480] mod_fcgid: stderr: PHP Fatal error:  Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/interface/lib/app.inc.php:166
    [Wed Oct 14 13:32:22.920046 2020] [fcgid:warn] [pid 5343] [client ***..***..56.1:47480] mod_fcgid: stderr: Stack trace:
    [Wed Oct 14 13:32:22.920078 2020] [fcgid:warn] [pid 5343] [client ***..***..56.1:47480] mod_fcgid: stderr: #0 /usr/local/ispconfig/interface/lib/app.inc.php(93): app->conf('interface', 'session_timeout')
    [Wed Oct 14 13:32:22.920097 2020] [fcgid:warn] [pid 5343] [client ***..***..56.1:47480] mod_fcgid: stderr: #1 /usr/local/ispconfig/interface/lib/app.inc.php(398): app->initialize_session()
    [Wed Oct 14 13:32:22.920110 2020] [fcgid:warn] [pid 5343] [client ***..***..56.1:47480] mod_fcgid: stderr: #2 /usr/local/ispconfig/interface/web/index.php(32): require_once('/usr/local/ispc...')
    [Wed Oct 14 13:32:22.920123 2020] [fcgid:warn] [pid 5343] [client ***..***..56.1:47480] mod_fcgid: stderr: #3 {main}
    [Wed Oct 14 13:32:22.920135 2020] [fcgid:warn] [pid 5343] [client ***..***..56.1:47480] mod_fcgid: stderr:   thrown in /usr/local/ispconfig/interface/lib/app.inc.php on line 166
    
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

    There is no function missing in the code of course, so there must be something completely messed up with your PHP config if PHP can't find functions anymore. Please do the exact steps I outlined in #4.
     
  7. zapyahoo

    zapyahoo Member

  8. zapyahoo

    zapyahoo Member

    The issues were related to mysql 8 and php 7.4.
    My php packages 7.0 UP were all manual sury installations since they were not supported by the distro package manager.
    https://www.howtoforge.com/tutorial...fig-3-from-debian-packages-on-debian-8-and-9/
    Mysql 8 is very much different from my installed 5.7 version packed in LTS 18.
    I guess it all should work from a fresh install but from an upgrade 16/18 LTS it should pretty much break when it comes to tables and user permissions.
    Everything is up and running now but I still have more clean-up to do since this was an upgrade :D
    Server: test (Ubuntu 20.04.1 LTS (Focal Fossa)) ISPConfig 3.2dev20201014
     
  9. till

    till Super Moderator Staff Member ISPConfig Developer

    Sury is for Debian only, for Ubuntu you get the same packages from ondrej ppa:

    Code:
    sudo apt-get update
    sudo apt -y install software-properties-common
    sudo add-apt-repository ppa:ondrej/php
    sudo apt-get update
    MySQL 8 is generally not really compatible with MySQL 5.7 and MariaDB, so if possible, I would use MariaDB in the future instead of MySQL.
     
  10. benurb

    benurb New Member

    In addition to what Till said, I would strongly recommend not to mix Ondrej Sury's packages with the ones provided by your distro. They are not really intended to work together. Ondrej offers php versions ranging from 5.6 to 7.4 currently, so there should be no reason to use the ones from your distro.
     
  11. Jesse Norell

    Jesse Norell Well-Known Member Staff Member Howtoforge Staff

    I think you should be fine on debian/ubuntu, as Ondrej is who creates the php packages for the distributions as well. I have used them together on debian for a few years with no issues.
     
  12. benurb

    benurb New Member

    Ye, you're probably right. My experience orginates from days where Ubuntu's php packages where not multi version and would write their configs into /etc/php and not /etc/php/<version>. But as far as I can tell all currently supported Ubuntu/Debian releases now use the multi version approach.
     

Share This Page