Installing 2nd server: ERROR: Unable to load SQL-Dump into database table.

I have one ISPConfig server up and running (Ubuntu 22.04). It will be the primary host for my site and the control panel: cp. mydomain. com
I have a new server created, same OS, etc. all up to date: cp2. mydomain. com

The /etc/hosts on both servers are configured, mysql access on the Primary cp. mydomain. com is set up for root@cp2. mydomain .com (as well as the various network addresses). root@cp2... has global access with grant options. Port 3306 is open and I can connect to the primary Mysql server from the new server.

One the new, additional server I run:

It runs normally, installs PHP, etc. and then runs the ISP install where I choose expert mode and answer Yes to the Shall this server join an existing ISPConfig multiserver setup.

When prompted for the MySQL master server, I enter: cp. mydomain. com, and accept defaults except for the root password on the primary server. Immediately I get:

Here is the output of the installation:

Code:

root@cp2:~# wget -O - https://get.ispconfig.org | sh -s -- --ssh-port=420 --ssh-password-authentication=no --ssh-
permit-root=no --no-mailman --use-php=8.0,8.1,7.4 --monit --monit-alert-email=kevin+cp2 @ mydomain. com --no-dns
--use-ftp-ports=40110-40210 --lang=en --unattended-upgrades --interactive --debug
--2023-01-05 09:59:19--  https://get.ispconfig.org/
Resolving get.ispconfig.org (get. ispconfig. org)... 2606:4700:20::ac43:4b70, 2606:4700:20::681a:bf6, 2606:4700:20::681a:af6, ...
Connecting to get.ispconfig.org (get. ispconfig. org)|2606:4700:20::ac43:4b70|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2003 (2.0K) [application/octet-stream]
Saving to: ‘STDOUT’

-                            100%[============================================>]   1.96K  --.-KB/s    in 0s     

2023-01-05 09:59:20 (37.5 MB/s) - written to stdout [2003/2003]

PHP cli missing, trying to install.
Selecting previously unselected package mailcap.
(Reading database ... 120746 files and directories currently installed.)
Preparing to unpack .../0-mailcap_3.70+nmu1ubuntu1_all.deb ...
Unpacking mailcap (3.70+nmu1ubuntu1) ...
Selecting previously unselected package mime-support.
Preparing to unpack .../1-mime-support_3.66_all.deb ...
Unpacking mime-support (3.66) ...
Selecting previously unselected package php-common.
Preparing to unpack .../2-php-common_2%3a92ubuntu1_all.deb ...
Unpacking php-common (2:92ubuntu1) ...
Selecting previously unselected package php8.1-common.
Preparing to unpack .../3-php8.1-common_8.1.2-1ubuntu2.9_amd64.deb ...
Unpacking php8.1-common (8.1.2-1ubuntu2.9) ...
Selecting previously unselected package php8.1-opcache.
Preparing to unpack .../4-php8.1-opcache_8.1.2-1ubuntu2.9_amd64.deb ...
Unpacking php8.1-opcache (8.1.2-1ubuntu2.9) ...
Selecting previously unselected package php8.1-readline.
Preparing to unpack .../5-php8.1-readline_8.1.2-1ubuntu2.9_amd64.deb ...
Unpacking php8.1-readline (8.1.2-1ubuntu2.9) ...
Selecting previously unselected package php8.1-cli.
Preparing to unpack .../6-php8.1-cli_8.1.2-1ubuntu2.9_amd64.deb ...
Unpacking php8.1-cli (8.1.2-1ubuntu2.9) ...
Selecting previously unselected package php-cli.
Preparing to unpack .../7-php-cli_2%3a8.1+92ubuntu1_all.deb ...
Unpacking php-cli (2:8.1+92ubuntu1) ...
Setting up php-common (2:92ubuntu1) ...
Created symlink /etc/systemd/system/timers.target.wants/phpsessionclean.timer → /lib/systemd/system/phpsessionclean.timer.
Setting up php8.1-common (8.1.2-1ubuntu2.9) ...

Creating config file /etc/php/8.1/mods-available/calendar.ini with new version

Creating config file /etc/php/8.1/mods-available/ctype.ini with new version

Creating config file /etc/php/8.1/mods-available/exif.ini with new version

Creating config file /etc/php/8.1/mods-available/fileinfo.ini with new version

Creating config file /etc/php/8.1/mods-available/ffi.ini with new version

Creating config file /etc/php/8.1/mods-available/ftp.ini with new version

Creating config file /etc/php/8.1/mods-available/gettext.ini with new version

Creating config file /etc/php/8.1/mods-available/iconv.ini with new version

Creating config file /etc/php/8.1/mods-available/pdo.ini with new version

Creating config file /etc/php/8.1/mods-available/phar.ini with new version

Creating config file /etc/php/8.1/mods-available/posix.ini with new version

Creating config file /etc/php/8.1/mods-available/shmop.ini with new version

Creating config file /etc/php/8.1/mods-available/sockets.ini with new version

Creating config file /etc/php/8.1/mods-available/sysvmsg.ini with new version

Creating config file /etc/php/8.1/mods-available/sysvsem.ini with new version

Creating config file /etc/php/8.1/mods-available/sysvshm.ini with new version

Creating config file /etc/php/8.1/mods-available/tokenizer.ini with new version
Setting up php8.1-readline (8.1.2-1ubuntu2.9) ...

Creating config file /etc/php/8.1/mods-available/readline.ini with new version
Setting up mailcap (3.70+nmu1ubuntu1) ...
Setting up php8.1-opcache (8.1.2-1ubuntu2.9) ...

Creating config file /etc/php/8.1/mods-available/opcache.ini with new version
Setting up mime-support (3.66) ...
Setting up php8.1-cli (8.1.2-1ubuntu2.9) ...
update-alternatives: using /usr/bin/php8.1 to provide /usr/bin/php (php) in auto mode
update-alternatives: using /usr/bin/phar8.1 to provide /usr/bin/phar (phar) in auto mode
update-alternatives: using /usr/bin/phar.phar8.1 to provide /usr/bin/phar.phar (phar.phar) in auto mode

Creating config file /etc/php/8.1/cli/php.ini with new version
Setting up php-cli (2:8.1+92ubuntu1) ...
update-alternatives: using /usr/bin/php.default to provide /usr/bin/php (php) in auto mode
update-alternatives: using /usr/bin/phar.default to provide /usr/bin/phar (phar) in auto mode
update-alternatives: using /usr/bin/phar.phar.default to provide /usr/bin/phar.phar (phar.phar) in auto mode
Processing triggers for man-db (2.10.2-1) ...
Processing triggers for php8.1-cli (8.1.2-1ubuntu2.9) ...
Scanning processes...                                                                                             
Scanning linux images...                                                                                         

Running kernel seems to be up-to-date.

No services need to be restarted.

No containers need to be restarted.

No user sessions are running outdated binaries.

No VM guests are running outdated hypervisor (qemu) binaries on this host.
Selecting previously unselected package libonig5:amd64.
(Reading database ... 120891 files and directories currently installed.)
Preparing to unpack .../libonig5_6.9.7.1-2build1_amd64.deb ...
Unpacking libonig5:amd64 (6.9.7.1-2build1) ...
Selecting previously unselected package php8.1-mbstring.
Preparing to unpack .../php8.1-mbstring_8.1.2-1ubuntu2.9_amd64.deb ...
Unpacking php8.1-mbstring (8.1.2-1ubuntu2.9) ...
Selecting previously unselected package php-mbstring.
Preparing to unpack .../php-mbstring_2%3a8.1+92ubuntu1_all.deb ...
Unpacking php-mbstring (2:8.1+92ubuntu1) ...
Setting up libonig5:amd64 (6.9.7.1-2build1) ...
Setting up php8.1-mbstring (8.1.2-1ubuntu2.9) ...

Creating config file /etc/php/8.1/mods-available/mbstring.ini with new version
Setting up php-mbstring (2:8.1+92ubuntu1) ...
Processing triggers for libc-bin (2.35-0ubuntu3.1) ...
Processing triggers for php8.1-cli (8.1.2-1ubuntu2.9) ...
Scanning processes...                                                                                             
Scanning linux images...                                                                                         

Running kernel seems to be up-to-date.

No services need to be restarted.

No containers need to be restarted.

No user sessions are running outdated binaries.

No VM guests are running outdated hypervisor (qemu) binaries on this host.
WARNING! This script will reconfigure your complete server!
It should be run on a freshly installed server and all current configuration that you have done will most likely be lost!
Type 'yes' if you really want to continue: yes
[INFO] Starting perfect server setup for Ubuntu 22.04.1 LTS
[INFO] Checking hostname.
[INFO] Configuring apt repositories.
[INFO] Updating packages
[INFO] Updated packages
[INFO] Installing packages ssh, openssh-server, nano, vim-nox, lsb-release, apt-transport-https, ca-certificates, wget, git, gnupg, software-properties-common, curl, cron, ntp
[INFO] Installed packages ssh, openssh-server, nano, vim-nox, lsb-release, apt-transport-https, ca-certificates, wget, git, gnupg, software-properties-common, curl, cron, ntp
[INFO] Activating rspamd repository.
[INFO] Activating sury php repository.
[INFO] Activating GoAccess repository.
[INFO] Updating packages (after enabling 3rd party repos).
[INFO] Updated packages
[INFO] Default shell is currently dash.
[INFO] Setting bash as default shell.
[INFO] Default shell is now bash.
[INFO] Installing packages dbconfig-common, postfix, postfix-mysql, postfix-doc, mariadb-client, mariadb-server, openssl, rkhunter, binutils, sudo, getmail6
[INFO] Installed packages dbconfig-common, postfix, postfix-mysql, postfix-doc, mariadb-client, mariadb-server, openssl, rkhunter, binutils, sudo, getmail6
[INFO] Installing packages dovecot-imapd, dovecot-pop3d, dovecot-mysql, dovecot-sieve, dovecot-managesieved, dovecot-lmtpd
[INFO] Installed packages dovecot-imapd, dovecot-pop3d, dovecot-mysql, dovecot-sieve, dovecot-managesieved, dovecot-lmtpd
[INFO] Generating MySQL password.
[INFO] Writing MySQL config files.
[INFO] Configuring postfix.
[INFO] Restarting postfix
[INFO] Installing packages software-properties-common, update-inetd, dnsutils, resolvconf, clamav, clamav-daemon, clamav-docs, zip, unzip, bzip2, xz-utils, lzip, rar, borgbackup, arj, nomarch, lzop, cabextract, apt-listchanges, libnet-ldap-perl, libauthen-sasl-perl, daemon, libio-string-perl, libio-socket-ssl-perl, libnet-ident-perl, libnet-dns-perl, libdbd-mysql-perl, bind9, rspamd, redis-server, postgrey, p7zip, p7zip-full, unrar-free, lrzip
[INFO] Installed packages software-properties-common, update-inetd, dnsutils, resolvconf, clamav, clamav-daemon, clamav-docs, zip, unzip, bzip2, xz-utils, lzip, rar, borgbackup, arj, nomarch, lzop, cabextract, apt-listchanges, libnet-ldap-perl, libauthen-sasl-perl, daemon, libio-string-perl, libio-socket-ssl-perl, libnet-ident-perl, libnet-dns-perl, libdbd-mysql-perl, bind9, rspamd, redis-server, postgrey, p7zip, p7zip-full, unrar-free, lrzip
[INFO] Stopping Rspamd.
[INFO] (Re)starting Bind.
[INFO] Disabling spamassassin daemon.
[INFO] Checking local dns resolver.
[INFO] Installing packages apache2, apache2-doc, apache2-utils, libapache2-mod-fcgid, apache2-suexec-pristine, libapache2-mod-python, libapache2-mod-passenger
[INFO] Installed packages apache2, apache2-doc, apache2-utils, libapache2-mod-fcgid, apache2-suexec-pristine, libapache2-mod-python, libapache2-mod-passenger
[INFO] Installing packages php-pear, php-memcache, php-imagick, mcrypt, imagemagick, libruby, memcached, php-apcu, jailkit, php8.0, php8.0-common, php8.0-gd, php8.0-mysql, php8.0-imap, php8.0-cli, php8.0-curl, php8.0-intl, php8.0-pspell, php8.0-sqlite3, php8.0-tidy, php8.0-xsl, php8.0-zip, php8.0-mbstring, php8.0-soap, php8.0-opcache, php8.0-cgi, php8.0-fpm, php8.1, php8.1-common, php8.1-gd, php8.1-mysql, php8.1-imap, php8.1-cli, php8.1-curl, php8.1-intl, php8.1-pspell, php8.1-sqlite3, php8.1-tidy, php8.1-xsl, php8.1-zip, php8.1-mbstring, php8.1-soap, php8.1-opcache, php8.1-cgi, php8.1-fpm, php7.4, php7.4-common, php7.4-gd, php7.4-mysql, php7.4-imap, php7.4-cli, php7.4-curl, php7.4-intl, php7.4-pspell, php7.4-sqlite3, php7.4-tidy, php7.4-xmlrpc, php7.4-xsl, php7.4-zip, php7.4-mbstring, php7.4-soap, php7.4-opcache, php7.4-cgi, php7.4-fpm
[INFO] Installed packages php-pear, php-memcache, php-imagick, mcrypt, imagemagick, libruby, memcached, php-apcu, jailkit, php8.0, php8.0-common, php8.0-gd, php8.0-mysql, php8.0-imap, php8.0-cli, php8.0-curl, php8.0-intl, php8.0-pspell, php8.0-sqlite3, php8.0-tidy, php8.0-xsl, php8.0-zip, php8.0-mbstring, php8.0-soap, php8.0-opcache, php8.0-cgi, php8.0-fpm, php8.1, php8.1-common, php8.1-gd, php8.1-mysql, php8.1-imap, php8.1-cli, php8.1-curl, php8.1-intl, php8.1-pspell, php8.1-sqlite3, php8.1-tidy, php8.1-xsl, php8.1-zip, php8.1-mbstring, php8.1-soap, php8.1-opcache, php8.1-cgi, php8.1-fpm, php7.4, php7.4-common, php7.4-gd, php7.4-mysql, php7.4-imap, php7.4-cli, php7.4-curl, php7.4-intl, php7.4-pspell, php7.4-sqlite3, php7.4-tidy, php7.4-xmlrpc, php7.4-xsl, php7.4-zip, php7.4-mbstring, php7.4-soap, php7.4-opcache, php7.4-cgi, php7.4-fpm
[INFO] Disabling conflicting apache modules.
[INFO] Enabling apache modules.
[INFO] Enabling default PHP-FPM config.
[INFO] Setting default system PHP version.
[INFO] Installing phpMyAdmin
[INFO] HTTPoxy config.
[INFO] Installing acme.sh (Let's Encrypt).
[INFO] acme.sh (Let's Encrypt) installed.
[INFO] Installing packages quota, quotatool, haveged, geoip-database, libclass-dbi-mysql-perl, libtimedate-perl, build-essential, autoconf, automake, libtool, flex, bison, debhelper, binutils
[INFO] Installed packages quota, quotatool, haveged, geoip-database, libclass-dbi-mysql-perl, libtimedate-perl, build-essential, autoconf, automake, libtool, flex, bison, debhelper, binutils
[INFO] Adding quota to fstab.
[INFO] Installing packages pure-ftpd-common, pure-ftpd-mysql, webalizer, awstats, goaccess
[INFO] Installed packages pure-ftpd-common, pure-ftpd-mysql, webalizer, awstats, goaccess
[INFO] Enabling TLS for pureftpd
[INFO] Disabling awstats cron.
[INFO] Installing packages fail2ban, ufw
[INFO] Installed packages fail2ban, ufw
[INFO] Installing Monit
[INFO] Installing packages monit
[INFO] Installed packages monit
[INFO] Configuring Monit.
[INFO] Configuring SSHd
[INFO] Installing UnattendedUpgrades
[INFO] Installing packages unattended-upgrades, apt-listchanges
[INFO] Installed packages unattended-upgrades, apt-listchanges
[INFO] Installing roundcube.
[INFO] Installing packages roundcube, roundcube-core, roundcube-mysql, roundcube-plugins
[INFO] Installed packages roundcube, roundcube-core, roundcube-mysql, roundcube-plugins
[INFO] Installing ISPConfig3.
[INFO] Your MySQL root password is: pVL67fw5YJWjfAcb7Nrb


--------------------------------------------------------------------------------
 _____ ___________   _____              __ _         ____
|_   _/  ___| ___ \ /  __ \            / _(_)       /__  \
  | | \ `--.| |_/ / | /  \/ ___  _ __ | |_ _  __ _    _/ /
  | |  `--. \  __/  | |    / _ \| '_ \|  _| |/ _` |  |_ |
 _| |_/\__/ / |     | \__/\ (_) | | | | | | | (_| | ___\ \
 \___/\____/\_|      \____/\___/|_| |_|_| |_|\__, | \____/
                                              __/ |
                                             |___/
--------------------------------------------------------------------------------


>> Initial configuration  

Operating System: Ubuntu 22.04.1 LTS (Jammy Jellyfish)

    Following will be a few questions for primary configuration so be careful.
    Default values are in [brackets] and can be accepted with <ENTER>.
    Tap in "quit" (without the quotes) to stop the installer.


Select language (en,de) [en]: en

Installation mode (standard,expert) [standard]: expert

Full qualified hostname (FQDN) of the server, eg server1.domain.tld  [cp2. mydomain. com]:

MySQL server hostname [localhost]:

MySQL server port [3306]:

MySQL root username [root]:

MySQL root password []:

MySQL database to create [dbispconfig]:

MySQL charset [utf8]:

The next two questions are about the internal ISPConfig database user and password.
It is recommended to accept the defaults which are 'ispconfig' as username and a random password.
If you use a different password, use only numbers and chars for the password.

ISPConfig mysql database username [ispconfig]:

ISPConfig mysql database password [1c2xxxxxxxxxxxxxxxxxxx8e]:

Shall this server join an existing ISPConfig multiserver setup (y,n) [n]: y

MySQL master server hostname []: cp .mydomain. com

MySQL master server port [3306]:

MySQL master server root username [root]:

MySQL master server root password []: xxxxxxxxxxxxxxxxxxxxx

MySQL master server database name [dbispconfig]:
ERROR: Unable to load SQL-Dump into database table.
[INFO] Adding PHP version(s) to ISPConfig.
[ERROR] Exception occured: ISPConfigOSException -> Could not read ISPConfig settings file. (/ispconfig.ai.php:15)
root@cp2:~#

The setup log's last line where the installation fails reads:

In the multi-server set up I'm not trying to cluster, etc., I want servers for staging and production and move will move the project code from one server to the next, etc. All servers will have a web server, mysql, mail, etc.
I downloaded the manual, although it doesn't refer to the autoinstaller script. I walked through the multiserver setup section and it appears the autoinstaller is doing the work in updating and installing packages needed, etc.
Obviously I'm doing something wrong. The 3.1 manual states to answer 'n' to the join a multi-server set up.
Should I set up the 2nd/3rd servers as if they were stand-alone, then come back to run the install script in expert mode to join the muiltiserver setup?

 

Geeze, I'm such a dunce. I accepted the input that was provided. In the script, the message telling me what my local root password is set to was displayed, I assumed I just accepted the defaults. Of course looking at it now, the default was [] so blank/no password. In the manual, it shows just pressing enter to accept what was there, but of course in the manual it had a password in the brackets[] to accept :-/ Thank you so much!