[SOLVED]Ubuntu Cluster 18.04 - Troubleshooting

Discussion in 'Installation/Configuration' started by Xase, Sep 19, 2018.

  1. Xase

    Xase Member

    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.
     
  2. Taleman

    Taleman Well-Known Member HowtoForge Supporter

  3. ahrasis

    ahrasis Well-Known Member

    I did that two months ago with Ubuntu 18.04, no problem at all. Try checking all your steps.
     
  4. Xase

    Xase Member

    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.
     
    Last edited: Sep 19, 2018
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  6. Xase

    Xase Member

    No sorry, this is.
    Code:
    [email protected]:~# /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!
    [email protected]:~#
    
     
  7. till

    till Super Moderator Staff Member ISPConfig Developer

    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.
     
  8. Xase

    Xase Member

    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:
    [email protected]:~$ 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:
    [email protected]:~$ 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 =/
     

Share This Page