Mail stuck inbound ispconfig 3 galera cluster

By Steven Protter · · amavis, Clustering & High Availability, dovecot, galera cluster, ispconfig, mysql, Networking, postfix, spamassassin, Systems Administration

Nail is stuck in the inbound que complaining about sql/mysql connect issues:

  1. Make sure hard coded passwords are the same in ispconfig.inc.php in /usr/local There are two config files with two password entries each they must be all the same.
  2. The password entries fo the mysql-*.cf files and there are a lt must be the same.
  3. You may need to go into the mysql -u root prompt and manually set the passwords there. Ise the new secure command style mysql> SET PASSWORD FOR ‘ispconfig’@’localhost’ = PASSWORD(“newpass”);
  4. php -q /usr/local/ispconfig/server/scripts/ispconfig_update.php -h Go through a services reconfigure. Watch the mysql error log wherever you have set it. When mysql faild to come up run galera_recover;galera_new_cluster to start the database. The php script will finish and mail will flow freely.