I followed this tutorial https://www.howtoforge.com/tutorial...tabase-cluster-on-debian-8.4-with-ispconfig-3 In tandem with this https://www.howtoforge.com/tutorial...l-pureftpd-bind-postfix-doveot-and-ispconfig/ Enabling root access to complete all steps. Everything seems to have gone without a hitch, and indeed our primary node is up. However after trying to make some changes to secondary node, we just show datalog_status_u_server, with about 7 pending actions that won't resolve... I think I may have boshed something... is there a way to simply check what's going down for real? Or should I redo the steps for the slave configuration? I didn't see anything in the first mentioned Debian tutorial that would prohibit it from being adapted to Ubuntu.
See https://www.howtoforge.com/community/threads/please-read-before-posting.58408/ It has info about troubleshooting when pending actions are not written to disk.
I did not see that section originally, I apologize for wasting time. Will report back after troubleshooting further. Code: 2018-09-19 01:38 miyagi.gethosting.today Debug Remove Lock: /usr/local/ispconfig/server/temp/.ispconfig_lock 2018-09-19 01:38 miyagi.gethosting.today Debug Restarting httpd: systemctl restart apache2.service 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'restartHttpd' from module 'web_module'. 2018-09-19 01:38 miyagi.gethosting.today Debug Processed datalog_id 105 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Network configuration disabled in server settings. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Writing the conf file: /etc/apache2/sites-available/ispconfig.conf 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'server_ip' from plugin 'apache2_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Processed datalog_id 103 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Network configuration disabled in server settings. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'postfix_server_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Network configuration disabled in server settings. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'network_settings_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'update' from plugin 'apps_vhost_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Writing the conf file: /etc/apache2/sites-available/ispconfig.conf 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'server_ip' from plugin 'apache2_plugin' raised by event 'server_update'. 2018-09-19 01:38 miyagi.gethosting.today Debug Found 2 changes, starting update process. 2018-09-19 01:38 miyagi.gethosting.today Debug Calling function 'check_phpini_changes' from plugin 'webserver_plugin' raised by action 'server_plugins_loaded'. daniel-san.gethosting.today is the name of the second server. I have enabled debug loglevel for both. Nothing shows for daniel-san.
Is this the server.sh script result from first or from the second node? If it's from first node, then please run server.sh on the second node and post the result.
No sorry, this is. Code: root@daniel-san:~# /usr/local/ispconfig/server/server.sh 19.09.2018-02:03 - WARNING - There is already an instance of server.php running with pid 26957. PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'2607:fcc8:fe90:4600::9' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 80 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'2607:fcc8:fe90:4600::9' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'2607:fcc8:fe90:4600::9' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'2607:fcc8:fe90:4600::9' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'2607:fcc8:fe90:4600::9' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 PHP Warning: mysqli_real_connect(): (HY000/1045): Access denied for user 'ispcsrv3'@'2607:fcc8:fe90:4600::9' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 83 Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible! root@daniel-san:~#
Ok, that's the problem, the second server can not connect to the MySQL database of the first one. This can happen when not all hostnames of all nodes are in the /etc/hosts files of all servers (see instructions in cluster tutorial) or when you entered an IP address instead of a hostname during installation of the second server when the installer asked for the hostname of the second server. the first step to fix that is to check the /etc/hosts file of both nodes and ensure that they both contain lines for both server hostnames as shown in the tutorial.
Till, thank you very much for your hard work, quick responses, and overall professional attitude. Editing my /etc/hosts file was the issue. Though I'm having an issue with static IPs, since my router doesn't allow me to lease IPv6, and setting up the 01-netcfg.yaml as outlined in another of the howtoforge tutorials, for setting up ubuntu minimal server with modifications works... but now I have an IP from the static config, and from dhcp lease... so that's my next step You have solved my issue once again! -- I don't know if this is optimal... but I simply added the leased IPs from DHCP to the /etc/hosts file... both static and leased work... Code: cashman@miyagi:~$ cat /etc/hosts 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.0.26 miyagi.gethosting.today miyagi 2607:fcc8:fe90:4600::1 miyagi.gethosting.today miyagi <-- Static set in /etc/netplan/01-netcfg.yaml 2607:fcc8:fe90:4600::7 miyagi.gethosting.today miyagi <-- Leased IP 192.168.0.27 daniel-san.gethosting.today 2607:fcc8:fe90:4600::2 daniel-san.gethosting.today <-- Static set in /etc/netplan/01-netcfg.yaml 2607:fcc8:fe90:4600::9 daniel-san.gethosting.today <-- Leased IP # The following lines are desirable for IPv6 capable hosts ::1 localhost ip6-localhost ip6-loopback fe00::0 ip6-localnet ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts Code: cashman@daniel-san:~$ cat /etc/hosts 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 192.168.0.27 daniel-san.gethosting.today daniel-san 2607:fcc8:fe90:4600::2 daniel-san.gethosting.today daniel-san <-- Static set in /etc/netplan/01-netcfg.yaml 2607:fcc8:fe90:4600::9 daniel-san.gethosting.today daniel-san <-- Leased IP 192.168.0.26 daniel-san.gethosting.today 2607:fcc8:fe90:4600::1 daniel-san.gethosting.today <-- Static set in /etc/netplan/01-netcfg.yaml 2607:fcc8:fe90:4600::7 daniel-san.gethosting.today <-- Leased IP # The following lines are desirable for IPv6 capable hosts ::1 localhost ip6-localhost ip6-loopback fe00::0 ip6-localnet ff02::1 ip6-allnodes ff02::2 ip6-allrouters ff02::3 ip6-allhosts Have to eliminate redundancy =/