Hey Til, I have a Ubuntu 16 install with two additional installs in proxmox lxc containers. Server 1 is ispconfig web, mail, db, dns, ftp, firewall. The two other servers are DNS only. For the last couple of months now they are updating DNS Zone files but not server settings. I have gone through the mysql error logs and the one thing that keeps showing up is the following: 2019-12-19T21:52:26.229672Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 2019-12-19T21:52:26.229785Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2019-12-19T21:52:26.232419Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.28-0ubuntu0.16.04.2) starting as process 3053 ... 2019-12-19T21:52:26.248031Z 0 [Note] InnoDB: PUNCH HOLE support available 2019-12-19T21:52:26.248073Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2019-12-19T21:52:26.248088Z 0 [Note] InnoDB: Uses event mutexes 2019-12-19T21:52:26.248099Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2019-12-19T21:52:26.248110Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.8 2019-12-19T21:52:26.248121Z 0 [Note] InnoDB: Using Linux native AIO 2019-12-19T21:52:26.248588Z 0 [Note] InnoDB: Number of pools: 1 2019-12-19T21:52:26.248775Z 0 [Note] InnoDB: Using CPU crc32 instructions 2019-12-19T21:52:26.251816Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2019-12-19T21:52:26.270153Z 0 [Note] InnoDB: Completed initialization of buffer pool 2019-12-19T21:52:26.273747Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2019-12-19T21:52:26.286844Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2019-12-19T21:52:26.299931Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2019-12-19T21:52:26.300020Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2019-12-19T21:52:26.321830Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2019-12-19T21:52:26.323176Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2019-12-19T21:52:26.323200Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2019-12-19T21:52:26.323831Z 0 [Note] InnoDB: Waiting for purge to start 2019-12-19T21:52:26.374062Z 0 [Note] InnoDB: 5.7.28 started; log sequence number 2732052 2019-12-19T21:52:26.374330Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2019-12-19T21:52:26.374588Z 0 [Note] Plugin 'FEDERATED' is disabled. 2019-12-19T21:52:26.377159Z 0 [Note] InnoDB: Buffer pool(s) load completed at 191219 21:52:26 2019-12-19T21:52:26.384178Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. 2019-12-19T21:52:26.384200Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory. 2019-12-19T21:52:26.385192Z 0 [Warning] CA certificate ca.pem is self signed. 2019-12-19T21:52:26.385251Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory. 2019-12-19T21:52:26.385381Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 2019-12-19T21:52:26.385446Z 0 [Note] IPv6 is available. 2019-12-19T21:52:26.385462Z 0 [Note] - '::' resolves to '::'; 2019-12-19T21:52:26.385490Z 0 [Note] Server socket created on IP: '::'. 2019-12-19T21:52:26.399910Z 0 [Note] Event Scheduler: Loaded 0 events 2019-12-19T21:52:26.400220Z 0 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.7.28-0ubuntu0.16.04.2' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu) 2019-12-19T21:52:26.990398Z 2 [Note] Access denied for user 'root'@'localhost' (using password: NO) 2019-12-19T21:52:31.762008Z 4 [Note] Got an error reading communication packets 2019-12-19T21:53:01.510249Z 8 [Note] Got an error reading communication packets 2019-12-19T21:54:01.759813Z 12 [Note] Got an error reading communication packets I have exhausted my limited amount of knowledge and cannot seem to get the red numbers on the master to go down on server updates for things like ip addresses and settings and such. Please advise as to what I might look for or try. All three servers are at the latest 3.1.15p2 version and all other functions seem to be working fine. Thanks for all your help and Happy Holidays to you and your family. Sincerely, Jeff McDaniel
Did you start a new thread for the same problem as https://www.howtoforge.com/communit...ets-and-multi-server-setup.83445/#post-397456 ? Quote from that other thread: How was this move done? Did the problems start immediately after the move? Start with this: https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ Then follow the troubleshooting instructions in http://www.faqforge.com/linux/debugging-ispconfig-3-server-actions-in-case-of-a-failure/ My quess is database connection does not work. Check the IP-numbers in /etc/hosts are correct in all three hosts. Check the database users can connect from the DNS slaves to the master.
