I am at the end of the installation and migration from my old server to a new and I was about to do a resync on the new server, just to find that most resync tools are gone. Under Debian 10 / Buster (Debian 10.9.0 with ISPconfig 3.2.4), the new server, I only see Resync Tool for "All Services", "Websites" and "Client and reseller", while in my old Debian 9 / Stretch server (Debian 9.13 with ISPconfig 3.2.4) had considerably more Resync tools to choose from, namely "All Services", "Websites", "Client and reseller", "Cronjobs", "Client Database config", "Maildomains", "Mailboxes", "Mailfilter" and "Client and Reseller". What happened to the rich set of Resync tools in Debian 10 / Buster (with ISPconfig 3.2.4) ? Is this a config error? If so, what do I need to do to fix it? Thanks!
Yep! Only the mail server is down according to ISPconfig, but "# service postfix status" says differently. What I am hoping to achieve too is that the database and users (that I have untared from the source server) can become visible from within ISPconfig3 and not just CLI and phpMyAdmin.
It does not matter which services are down or running, but what services are enabled on the host for which you are doing resync. In ISPConfig Panel, go to System tab and System | "Server Services".
...and they are online, except for the SMTP-server. For some reason it looks like that, but when I check the status of it, it's up.
In the server services list, click on the server name and share a screenshot of what's shown there. So not in the overview but in the edit form for the server services.
Weird. This all looks good and the resync tool should show all functions. Are all modules enabeld for your user? If so, try doing a force update: Code: ispconfig_update.sh --force
Ok. This resulted in this: ( I took a snapshot of it before I started the update. After the update I could no longer reach ISPconfig3 so I put back the snapshot. (it's Proxmox on it) ) Code: >> Update Operating System: Debian 10.0 (Buster) or compatible This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: Creating backup of "/usr/local/ispconfig" directory... Creating backup of "/etc" directory... mysqldump: Got error: 1932: "Table 'dbispconfig.software_package' doesn't exist in engine" when using LOCK TABLES Checking ISPConfig database .. Some tables where not 'OK'. Please check the list below. dbispconfig.software_package Error : Table 'dbispconfig.software_package' doesn't exist in engine status : Operation failed dbispconfig.software_repo Error : Table 'dbispconfig.software_repo' doesn't exist in engine status : Operation failed dbispconfig.software_update Error : Table 'dbispconfig.software_update' doesn't exist in engine status : Operation failed dbispconfig.software_update_inst Error : Table 'dbispconfig.software_update_inst' doesn't exist in engine status : Operation failed Repairing tables dbispconfig.software_package Error : Table 'dbispconfig.software_package' doesn't exist in engine status : Operation failed dbispconfig.software_repo Error : Table 'dbispconfig.software_repo' doesn't exist in engine status : Operation failed dbispconfig.software_update Error : Table 'dbispconfig.software_update' doesn't exist in engine status : Operation failed dbispconfig.software_update_inst Error : Table 'dbispconfig.software_update_inst' doesn't exist in engine status : Operation failed Press enter to continue or CTRL-C to cancel the installation .. Starting incremental database update. Loading SQL patch file: /tmp/update_runner.sh.h11b3hyq45/install/sql/incremental/upd_dev_collection.sql Reconfigure Permissions in master database? (yes,no) [no]: Reconfigure Permissions in master database? (yes,no) [no]: Reconfigure Services? (yes,no,selected) [yes]: Configuring Postfix Configuring Dovecot Configuring Spamassassin Configuring Amavisd Configuring Getmail Configuring BIND Configuring Pureftpd Configuring Apache Configuring vlogger Configuring Apps vhost Configuring Jailkit Configuring Ubuntu Firewall Configuring Database Updating ISPConfig ISPConfig Port [<thePort>]: Create new ISPConfig SSL certificate (yes,no) [no]: Reconfigure Crontab? (yes,no) [yes]: Updating Crontab Restarting services ... PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209
Please run the test script as described in the read before posting: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
Before forced upgrade of ISPconfig3 Here I could access ISPconfig3 web interface sp Apache and MySQL was up and running. (by the way, the error I had with Postfix, is fixed) (I should mention that the server is on a LAN and is NATed from the outside of the FW. The port for ISPconfig3 is not the standard since Tomcat is there, just an old habit since I came across that problem a long time ago) Code: ##### SERVER ##### IP-address (as per hostname): ***.***.***.*** [WARN] could not determine server's ip address by ifconfig [INFO] OS version is Debian GNU/Linux 10 (buster) [INFO] uptime: 17:00:55 up 15:10, 3 users, load average: 0.22, 0.26, 0.45 [INFO] memory: total used free shared buff/cache available Mem: 23Gi 1.7Gi 229Mi 31Mi 21Gi 21Gi Swap: 974Mi 2.0Mi 972Mi [INFO] systemd failed services status: UNIT LOAD ACTIVE SUB DESCRIPTION ● ntp.service loaded failed failed Network Time Service LOAD = Reflects whether the unit definition was properly loaded. ACTIVE = The high-level unit activation state, i.e. generalization of SUB. SUB = The low-level unit activation state, values depend on unit type. 1 loaded units listed. Pass --all to see loaded but inactive units, too. To show all installed unit files use 'systemctl list-unit-files'. [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.2.4 ##### VERSION CHECK ##### [INFO] php (cli) version is 7.2.34-18+0~20210223.60+debian10~1.gbpb21322 ##### PORT CHECK ##### [WARN] Port 8080 (ISPConfig) seems NOT to be listening ##### MAIL SERVER CHECK ##### ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 20482) [INFO] I found the following mail server(s): Postfix (PID 19490) [INFO] I found the following pop3 server(s): Dovecot (PID 496) [INFO] I found the following imap server(s): Dovecot (PID 496) [INFO] I found the following ftp server(s): PureFTP (PID 761) ##### LISTENING PORTS ##### (only () Local (Address) [anywhere]:993 (496/dovecot) [anywhere]:995 (496/dovecot) [localhost]:10023 (686/postgrey) [localhost]:10024 (1206/amavisd-new) [localhost]:10025 (19490/master) [localhost]:10026 (1206/amavisd-new) [localhost]:10027 (19490/master) [anywhere]:587 (19490/master) [localhost]:11211 (495/memcached) [anywhere]:110 (496/dovecot) [anywhere]:143 (496/dovecot) [anywhere]:465 (19490/master) [anywhere]:21 (761/pure-ftpd) [localhost]:53 (540/named) [anywhere]:22 (533/sshd) [anywhere]:25 (19490/master) [localhost]:953 (540/named) *:*:*:*::*:993 (496/dovecot) *:*:*:*::*:8099 (20482/apache2) *:*:*:*::*:995 (496/dovecot) *:*:*:*::*:10023 (686/postgrey) *:*:*:*::*:10024 (1206/amavisd-new) *:*:*:*::*:10026 (1206/amavisd-new) *:*:*:*::*:3306 (588/mysqld) *:*:*:*::*:587 (19490/master) [localhost]10 (496/dovecot) [localhost]43 (496/dovecot) *:*:*:*::*:80 (20482/apache2) *:*:*:*::*:8081 (20482/apache2) *:*:*:*::*:465 (19490/master) *:*:*:*::*:21 (761/pure-ftpd) *:*:*:*::*:53 (540/named) *:*:*:*::*:22 (533/sshd) *:*:*:*::*:25 (19490/master) *:*:*:*::*:953 (540/named) *:*:*:*::*:443 (20482/apache2) ##### IPTABLES ##### Chain INPUT (policy DROP) target prot opt source destination ufw-before-logging-input all -- [anywhere]/0 [anywhere]/0 ufw-before-input all -- [anywhere]/0 [anywhere]/0 ufw-after-input all -- [anywhere]/0 [anywhere]/0 ufw-after-logging-input all -- [anywhere]/0 [anywhere]/0 ufw-reject-input all -- [anywhere]/0 [anywhere]/0 ufw-track-input all -- [anywhere]/0 [anywhere]/0 Chain FORWARD (policy DROP) target prot opt source destination ufw-before-logging-forward all -- [anywhere]/0 [anywhere]/0 ufw-before-forward all -- [anywhere]/0 [anywhere]/0 ufw-after-forward all -- [anywhere]/0 [anywhere]/0 ufw-after-logging-forward all -- [anywhere]/0 [anywhere]/0 ufw-reject-forward all -- [anywhere]/0 [anywhere]/0 ufw-track-forward all -- [anywhere]/0 [anywhere]/0 Chain OUTPUT (policy ACCEPT) target prot opt source destination ufw-before-logging-output all -- [anywhere]/0 [anywhere]/0 ufw-before-output all -- [anywhere]/0 [anywhere]/0 ufw-after-output all -- [anywhere]/0 [anywhere]/0 ufw-after-logging-output all -- [anywhere]/0 [anywhere]/0 ufw-reject-output all -- [anywhere]/0 [anywhere]/0 ufw-track-output all -- [anywhere]/0 [anywhere]/0 Chain ufw-before-logging-input (1 references) target prot opt source destination Chain ufw-before-logging-output (1 references) target prot opt source destination Chain ufw-before-logging-forward (1 references) target prot opt source destination Chain ufw-before-input (1 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 ACCEPT all -- [anywhere]/0 [anywhere]/0 ctstate RELATED,ESTABLISHED ufw-logging-deny all -- [anywhere]/0 [anywhere]/0 ctstate INVALID DROP all -- [anywhere]/0 [anywhere]/0 ctstate INVALID ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 3 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 11 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 12 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 8 ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp spt:67 dpt:68 ufw-not-local all -- [anywhere]/0 [anywhere]/0 ACCEPT udp -- [anywhere]/0 ***.***.***.*** udp dpt:5353 ACCEPT udp -- [anywhere]/0 ***.***.***.*** udp dpt:1900 ufw-user-input all -- [anywhere]/0 [anywhere]/0 Chain ufw-before-output (1 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 ACCEPT all -- [anywhere]/0 [anywhere]/0 ctstate RELATED,ESTABLISHED ufw-user-output all -- [anywhere]/0 [anywhere]/0 Chain ufw-before-forward (1 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 ctstate RELATED,ESTABLISHED ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 3 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 11 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 12 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 8 ufw-user-forward all -- [anywhere]/0 [anywhere]/0 Chain ufw-after-input (1 references) target prot opt source destination ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:137 ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:138 ufw-skip-to-policy-input tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:139 ufw-skip-to-policy-input tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:445 ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:67 ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:68 ufw-skip-to-policy-input all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type BROADCAST Chain ufw-after-output (1 references) target prot opt source destination Chain ufw-after-forward (1 references) target prot opt source destination Chain ufw-after-logging-input (1 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] " Chain ufw-after-logging-output (1 references) target prot opt source destination Chain ufw-after-logging-forward (1 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] " Chain ufw-reject-input (1 references) target prot opt source destination Chain ufw-reject-output (1 references) target prot opt source destination Chain ufw-reject-forward (1 references) target prot opt source destination Chain ufw-track-input (1 references) target prot opt source destination Chain ufw-track-output (1 references) target prot opt source destination ACCEPT tcp -- [anywhere]/0 [anywhere]/0 ctstate NEW ACCEPT udp -- [anywhere]/0 [anywhere]/0 ctstate NEW Chain ufw-track-forward (1 references) target prot opt source destination Chain ufw-logging-deny (2 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 ctstate INVALID limit: avg 3/min burst 10 LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] " Chain ufw-logging-allow (0 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW ALLOW] " Chain ufw-skip-to-policy-input (7 references) target prot opt source destination DROP all -- [anywhere]/0 [anywhere]/0 Chain ufw-skip-to-policy-output (0 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 Chain ufw-skip-to-policy-forward (0 references) target prot opt source destination DROP all -- [anywhere]/0 [anywhere]/0 Chain ufw-not-local (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type LOCAL RETURN all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type MULTICAST RETURN all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type BROADCAST ufw-logging-deny all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 DROP all -- [anywhere]/0 [anywhere]/0 Chain ufw-user-input (1 references) target prot opt source destination ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:22 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:25 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:53 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:80 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:110 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:143 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:443 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:465 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:587 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:993 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:3478 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:4190 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:4369 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:5672 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:8081 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:8099 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:9000 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:9001 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:9980 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:15672 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:16001 ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp dpt:53 ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp dpt:3478 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:2222 ACCEPT all -- ***.***.***.*** [anywhere]/0 Chain ufw-user-output (1 references) target prot opt source destination Chain ufw-user-forward (1 references) target prot opt source destination Chain ufw-user-logging-input (0 references) target prot opt source destination Chain ufw-user-logging-output (0 references) target prot opt source destination Chain ufw-user-logging-forward (0 references) target prot opt source destination Chain ufw-user-limit (0 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 5 LOG flags 0 level 4 prefix "[UFW LIMIT BLOCK] " REJECT all -- [anywhere]/0 [anywhere]/0 reject-with icmp-port-unreachable Chain ufw-user-limit-accept (0 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0
Part 2: During forced upgrade I get this: Code: >> Update Operating System: Debian 10.0 (Buster) or compatible This application will update ISPConfig 3 on your server. Shall the script create a ISPConfig backup in /var/backup/ now? (yes,no) [yes]: Creating backup of "/usr/local/ispconfig" directory... Creating backup of "/etc" directory... mysqldump: Got error: 1932: "Table 'dbispconfig.software_package' doesn't exist in engine" when using LOCK TABLES Checking ISPConfig database .. Some tables where not 'OK'. Please check the list below. dbispconfig.software_package Error : Table 'dbispconfig.software_package' doesn't exist in engine status : Operation failed dbispconfig.software_repo Error : Table 'dbispconfig.software_repo' doesn't exist in engine status : Operation failed dbispconfig.software_update Error : Table 'dbispconfig.software_update' doesn't exist in engine status : Operation failed dbispconfig.software_update_inst Error : Table 'dbispconfig.software_update_inst' doesn't exist in engine status : Operation failed Repairing tables dbispconfig.software_package Error : Table 'dbispconfig.software_package' doesn't exist in engine status : Operation failed dbispconfig.software_repo Error : Table 'dbispconfig.software_repo' doesn't exist in engine status : Operation failed dbispconfig.software_update Error : Table 'dbispconfig.software_update' doesn't exist in engine status : Operation failed dbispconfig.software_update_inst Error : Table 'dbispconfig.software_update_inst' doesn't exist in engine status : Operation failed Press enter to continue or CTRL-C to cancel the installation .. Starting incremental database update. Loading SQL patch file: /tmp/update_runner.sh.h11b3hyq45/install/sql/incremental/upd_dev_collection.sql Reconfigure Permissions in master database? (yes,no) [no]: Reconfigure Permissions in master database? (yes,no) [no]: Reconfigure Services? (yes,no,selected) [yes]: Configuring Postfix Configuring Dovecot Configuring Spamassassin Configuring Amavisd Configuring Getmail Configuring BIND Configuring Pureftpd Configuring Apache Configuring vlogger Configuring Apps vhost Configuring Jailkit Configuring Ubuntu Firewall Configuring Database Updating ISPConfig ISPConfig Port [<thePort>]: Create new ISPConfig SSL certificate (yes,no) [no]: Reconfigure Crontab? (yes,no) [yes]: Updating Crontab Restarting services ... PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /tmp/update_runner.sh.h11b3hyq45/install/lib/mysql.lib.php on line 209 After upgrade I get this when running the test script. Now the MySQL database is down so the result is expected. Code: root@si0001 ~/tmp # wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /root/tmp/htf-common-issues.php on line 245 ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) ##### SCRIPT FINISHED ##### Results can be found in htf_report.txt To view results use your favourite text editor or type 'cat htf_report.txt | more' on the server console. If you want to see the non-anonymized output start the script with --debug as parameter (php -q htf-common-issues.php --debug). Status of MySQL / MariaDB Code: root@si0001 ~/tmp # service mysql status ● mariadb.service - MariaDB 10.3.27 database server Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled) Drop-In: /etc/systemd/system/mysql.service.d └─limits.conf Active: failed (Result: exit-code) since Thu 2021-04-15 17:30:29 CEST; 11min ago Docs: man:mysqld(8) https://mariadb.com/kb/en/library/systemd/ Process: 23375 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS) Process: 23376 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS) Process: 23377 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 Process: 23422 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE) Main PID: 23422 (code=exited, status=1/FAILURE) Status: "MariaDB server is down" Apr 15 17:30:27 si0001 systemd[1]: Starting MariaDB 10.3.27 database server... Apr 15 17:30:27 si0001 mysqld[23422]: 2021-04-15 17:30:27 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 23422 . Apr 15 17:30:29 si0001 systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE Apr 15 17:30:29 si0001 systemd[1]: mariadb.service: Failed with result 'exit-code'. Apr 15 17:30:29 si0001 systemd[1]: Failed to start MariaDB 10.3.27 database server. The question is why the MariaDB is down and most of all why this happened during the forced upgrade. Then of course the original question of why Resync is not with all the services.
I forgot the output from the test script after the forced upgrade, here it is... Code: ##### SERVER ##### IP-address (as per hostname): ***.***.***.*** [WARN] could not determine server's ip address by ifconfig [INFO] OS version is Debian GNU/Linux 10 (buster) [INFO] uptime: 17:44:16 up 15:53, 3 users, load average: 0.00, 0.02, 0.08 [INFO] memory: total used free shared buff/cache available Mem: 23Gi 1.6Gi 482Mi 27Mi 21Gi 21Gi Swap: 974Mi 1.0Mi 973Mi [INFO] systemd failed services status: UNIT LOAD ACTIVE SUB DESCRIPTION ● mariadb.service loaded failed failed MariaDB 10.3.27 database server ● ntp.service loaded failed failed Network Time Service LOAD = Reflects whether the unit definition was properly loaded. ACTIVE = The high-level unit activation state, i.e. generalization of SUB. SUB = The low-level unit activation state, values depend on unit type. 2 loaded units listed. Pass --all to see loaded but inactive units, too. To show all installed unit files use 'systemctl list-unit-files'. [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.2.4 [WARN] Could not connect to mysql with given user data. [WARN] Could not use mysql command line to connect to the database. Check your mysql config! ##### VERSION CHECK ##### [INFO] php (cli) version is 7.2.34-18+0~20210223.60+debian10~1.gbpb21322 ##### PORT CHECK ##### [WARN] Port 8080 (ISPConfig) seems NOT to be listening ##### MAIL SERVER CHECK ##### ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 23718) [INFO] I found the following mail server(s): Postfix (PID 23632) [INFO] I found the following pop3 server(s): Dovecot (PID 23676) [INFO] I found the following imap server(s): Dovecot (PID 23676) [INFO] I found the following ftp server(s): PureFTP (PID 23778) ##### LISTENING PORTS ##### (only () Local (Address) [anywhere]:993 (23676/dovecot) [anywhere]:995 (23676/dovecot) [localhost]:10023 (686/postgrey) [localhost]:10024 (23663/amavisd-new) [localhost]:10025 (23632/master) [localhost]:10026 (23663/amavisd-new) [localhost]:10027 (23632/master) [anywhere]:587 (23632/master) [localhost]:11211 (495/memcached) [anywhere]:110 (23676/dovecot) [anywhere]:143 (23676/dovecot) [anywhere]:465 (23632/master) ***.***.***.***:53 (23790/named) [localhost]:53 (23790/named) [anywhere]:21 (23778/pure-ftpd) [anywhere]:22 (533/sshd) [localhost]:953 (23790/named) [anywhere]:25 (23632/master) *:*:*:*::*:993 (23676/dovecot) *:*:*:*::*:995 (23676/dovecot) *:*:*:*::*:8099 (23718/apache2) *:*:*:*::*:10023 (686/postgrey) *:*:*:*::*:10024 (23663/amavisd-new) *:*:*:*::*:10026 (23663/amavisd-new) *:*:*:*::*:587 (23632/master) [localhost]10 (23676/dovecot) [localhost]43 (23676/dovecot) *:*:*:*::*:80 (23718/apache2) *:*:*:*::*:8081 (23718/apache2) *:*:*:*::*:465 (23632/master) *:*:*:*::*:53 (23790/named) *:*:*:*::*:21 (23778/pure-ftpd) *:*:*:*::*:22 (533/sshd) *:*:*:*::*:953 (23790/named) *:*:*:*::*:25 (23632/master) *:*:*:*::*:443 (23718/apache2) ##### IPTABLES ##### Chain INPUT (policy DROP) target prot opt source destination ufw-before-logging-input all -- [anywhere]/0 [anywhere]/0 ufw-before-input all -- [anywhere]/0 [anywhere]/0 ufw-after-input all -- [anywhere]/0 [anywhere]/0 ufw-after-logging-input all -- [anywhere]/0 [anywhere]/0 ufw-reject-input all -- [anywhere]/0 [anywhere]/0 ufw-track-input all -- [anywhere]/0 [anywhere]/0 Chain FORWARD (policy DROP) target prot opt source destination ufw-before-logging-forward all -- [anywhere]/0 [anywhere]/0 ufw-before-forward all -- [anywhere]/0 [anywhere]/0 ufw-after-forward all -- [anywhere]/0 [anywhere]/0 ufw-after-logging-forward all -- [anywhere]/0 [anywhere]/0 ufw-reject-forward all -- [anywhere]/0 [anywhere]/0 ufw-track-forward all -- [anywhere]/0 [anywhere]/0 Chain OUTPUT (policy ACCEPT) target prot opt source destination ufw-before-logging-output all -- [anywhere]/0 [anywhere]/0 ufw-before-output all -- [anywhere]/0 [anywhere]/0 ufw-after-output all -- [anywhere]/0 [anywhere]/0 ufw-after-logging-output all -- [anywhere]/0 [anywhere]/0 ufw-reject-output all -- [anywhere]/0 [anywhere]/0 ufw-track-output all -- [anywhere]/0 [anywhere]/0 Chain ufw-before-logging-input (1 references) target prot opt source destination Chain ufw-before-logging-output (1 references) target prot opt source destination Chain ufw-before-logging-forward (1 references) target prot opt source destination Chain ufw-before-input (1 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 ACCEPT all -- [anywhere]/0 [anywhere]/0 ctstate RELATED,ESTABLISHED ufw-logging-deny all -- [anywhere]/0 [anywhere]/0 ctstate INVALID DROP all -- [anywhere]/0 [anywhere]/0 ctstate INVALID ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 3 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 11 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 12 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 8 ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp spt:67 dpt:68 ufw-not-local all -- [anywhere]/0 [anywhere]/0 ACCEPT udp -- [anywhere]/0 ***.***.***.*** udp dpt:5353 ACCEPT udp -- [anywhere]/0 ***.***.***.*** udp dpt:1900 ufw-user-input all -- [anywhere]/0 [anywhere]/0 Chain ufw-before-output (1 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 ACCEPT all -- [anywhere]/0 [anywhere]/0 ctstate RELATED,ESTABLISHED ufw-user-output all -- [anywhere]/0 [anywhere]/0 Chain ufw-before-forward (1 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 ctstate RELATED,ESTABLISHED ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 3 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 11 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 12 ACCEPT icmp -- [anywhere]/0 [anywhere]/0 icmptype 8 ufw-user-forward all -- [anywhere]/0 [anywhere]/0 Chain ufw-after-input (1 references) target prot opt source destination ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:137 ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:138 ufw-skip-to-policy-input tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:139 ufw-skip-to-policy-input tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:445 ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:67 ufw-skip-to-policy-input udp -- [anywhere]/0 [anywhere]/0 udp dpt:68 ufw-skip-to-policy-input all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type BROADCAST Chain ufw-after-output (1 references) target prot opt source destination Chain ufw-after-forward (1 references) target prot opt source destination Chain ufw-after-logging-input (1 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] " Chain ufw-after-logging-output (1 references) target prot opt source destination Chain ufw-after-logging-forward (1 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] " Chain ufw-reject-input (1 references) target prot opt source destination Chain ufw-reject-output (1 references) target prot opt source destination Chain ufw-reject-forward (1 references) target prot opt source destination Chain ufw-track-input (1 references) target prot opt source destination Chain ufw-track-output (1 references) target prot opt source destination ACCEPT tcp -- [anywhere]/0 [anywhere]/0 ctstate NEW ACCEPT udp -- [anywhere]/0 [anywhere]/0 ctstate NEW Chain ufw-track-forward (1 references) target prot opt source destination Chain ufw-logging-deny (2 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 ctstate INVALID limit: avg 3/min burst 10 LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW BLOCK] " Chain ufw-logging-allow (0 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 LOG flags 0 level 4 prefix "[UFW ALLOW] " Chain ufw-skip-to-policy-input (7 references) target prot opt source destination DROP all -- [anywhere]/0 [anywhere]/0 Chain ufw-skip-to-policy-output (0 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0 Chain ufw-skip-to-policy-forward (0 references) target prot opt source destination DROP all -- [anywhere]/0 [anywhere]/0 Chain ufw-not-local (1 references) target prot opt source destination RETURN all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type LOCAL RETURN all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type MULTICAST RETURN all -- [anywhere]/0 [anywhere]/0 ADDRTYPE match dst-type BROADCAST ufw-logging-deny all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 10 DROP all -- [anywhere]/0 [anywhere]/0 Chain ufw-user-input (1 references) target prot opt source destination ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:22 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:25 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:53 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:80 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:110 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:143 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:443 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:465 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:587 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:993 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:3478 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:4190 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:4369 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:5672 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:8081 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:8099 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:9000 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:9001 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:9980 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:15672 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:16001 ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp dpt:53 ACCEPT udp -- [anywhere]/0 [anywhere]/0 udp dpt:3478 ACCEPT tcp -- [anywhere]/0 [anywhere]/0 tcp dpt:2222 ACCEPT all -- ***.***.***.*** [anywhere]/0 Chain ufw-user-output (1 references) target prot opt source destination Chain ufw-user-forward (1 references) target prot opt source destination Chain ufw-user-logging-input (0 references) target prot opt source destination Chain ufw-user-logging-output (0 references) target prot opt source destination Chain ufw-user-logging-forward (0 references) target prot opt source destination Chain ufw-user-limit (0 references) target prot opt source destination LOG all -- [anywhere]/0 [anywhere]/0 limit: avg 3/min burst 5 LOG flags 0 level 4 prefix "[UFW LIMIT BLOCK] " REJECT all -- [anywhere]/0 [anywhere]/0 reject-with icmp-port-unreachable Chain ufw-user-limit-accept (0 references) target prot opt source destination ACCEPT all -- [anywhere]/0 [anywhere]/0
