ISPConfig 3.1.15p2 loses configuration of web server, db server, mail server, and firewall server
My old server uses 3.1.13 and does not exhibit this issue. Ubuntu 18.04 nginx mysql My new server exhibits the issue. Ubuntu 18.04 nginx mariadb
On my new server, I took a snapshot of the old server and migrated it over - client directories/sites, ISPConfig files/configurations, and other configurations. I used this site's step as a guideline, but made alterations along the way (mostly what got backed up and what got restored) https://www.zvonimir-buzanic.from.hr/migration-of-ispconfig-3-to-new-server
I also migrated from MySQL to Mariadb during the move, by not making backups of the Mysql schema and config and reinstalling that portion from scratch instead.
I then upgraded to the latest version of ispconfig 3.1.15p2 on the new server.
I've noticed very frequently (around once a day) I can no longer log into the ISPConfig control panel. Running through all the checks I've found on various howtoforge forum threads, none of them appeared to work. So I reinstall ISPConfig using the update.php script. Here is the output:
root@server3:/tmp/update_stable.sh.CmXozREuP2/ispconfig3_install/install# php -q update.php
--------------------------------------------------------------------------------
_____ ___________ _____ __ _ ____
|_ _/ ___| ___ \ / __ \ / _(_) /__ \
| | \ `--.| |_/ / | / \/ ___ _ __ | |_ _ __ _ _/ /
| | `--. \ __/ | | / _ \| '_ \| _| |/ _` | |_ |
_| |_/\__/ / | | \__/\ (_) | | | | | | | (_| | ___\ \
\___/\____/\_| \____/\___/|_| |_|_| |_|\__, | \____/
__/ |
|___/
--------------------------------------------------------------------------------
>> Update
Operating System: Ubuntu 18.04.3 LTS (Bionic Beaver)
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: 1153: "Got a packet bigger than 'max_allowed_packet' bytes" when using LOCK TABLES
Checking ISPConfig database .. OK
Starting incremental database update.
Loading SQL patch file: /tmp/update_stable.sh.CmXozREuP2/ispconfig3_install/install/sql/incremental/upd_dev_collection.sql
Reconfigure Permissions in master database? (yes,no) [no]:
Service 'mail_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: yes
Service 'web_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: yes
Service 'firewall_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: yes
Service 'db_server' has been detected (currently disabled) do you want to enable and configure it? (yes,no) [no]: yes
Reconfigure Services? (yes,no,selected) [yes]:
Configuring Postfix
Configuring Dovecot
Configuring Spamassassin
Configuring Amavisd
Configuring Getmail
Configuring Pureftpd
Configuring nginx
Skipping config of Apps vhost
Configuring Jailkit
Configuring Ubuntu Firewall
Configuring Database
Updating ISPConfig
ISPConfig Port [8080]:
Create new ISPConfig SSL certificate (yes,no) [no]:
Reconfigure Crontab? (yes,no) [yes]:
Updating Crontab
Restarting services ...
Update finished.
root@server3:/tmp/update_stable.sh.CmXozREuP2/ispconfig3_install/install# uptime 16:23:42 up 11 days, 22:30, 1 user, load average: 0.80, 1.03, 0.95
As you can see, the web_server, db_server, firewall_server, and mail_server appeared to lose their configuration - as they're showing disabled in the update. Once I run this, they're enabled and I can log in for another day... and then I have to do the update process again in order to access the control panel.
Can anyone shed some light into why these settings are being lost? I am happy to provide any logs, etc that are needed to troubleshoot, I'm just not sure which logs are relevant for the issue. When I view nginx error log and mysql's log, nothing shows out of the ordinary - looks like the usual behavior from the server.