[SOLVED]ISPConfig Cluster : Can't reach web interface on slave

Discussion in 'Installation/Configuration' started by AEG-Simply, May 15, 2017.

  1. AEG-Simply

    AEG-Simply New Member

    Hello there, I followed this tutorial :
    https://www.howtoforge.com/tutorial...abase-cluster-on-debian-8.4-with-ispconfig-3/
    It seems that I can't reach the web interface on 8080 on the slave server (master is available).

    Here is what I got with the ISPConfig test script :

    The master is in attachment.

    Here is the Slave :
    Code:
    ##### SERVER #####
    IP-address (as per hostname): [localhost]
    IP-address(es) (as per ifconfig): [localhost], ***.***.***.***
    [INFO] ISPConfig is installed.
    ##### ISPCONFIG #####
    ISPConfig version is 3.1dev
    ##### VERSION CHECK #####
    [INFO] php (cli) version is 5.6.30-0+deb8u1
    [INFO] php-cgi (used for cgi php in default vhost!) is version 5.6.30-0+deb8u1
    ##### PORT CHECK #####
    [WARN] Port 8080 (ISPConfig) seems NOT to be listening
    [WARN] Port 21 (FTP server) seems NOT to be listening
    ##### MAIL SERVER CHECK #####
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
        Apache 2 (PID 1003)
    [INFO] I found the following mail server(s):
        Postfix (PID 1391)
    [INFO] I found the following pop3 server(s):
        Dovecot (PID 4959)
    [INFO] I found the following imap server(s):
        Unknown process (init) (PID 1)
    [WARN] I could not determine which ftp server is running.
    
    ##### LISTENING PORTS #####
    (seulement        ()
    Adresse        (distante)
    ***.***.***.***:53        (587/named)
    ***.***.***.***:53        (587/named)
    [localhost]:53        (587/named)
    [anywhere]:22        (584/sshd)
    [anywhere]:25        (1391/master)
    [localhost]:953        (587/named)
    [anywhere]:993        (1/init)
    [anywhere]:43426        (562/rpc.statd)
    [anywhere]:995        (4959/dovecot)
    [anywhere]:4711        (4959/dovecot)
    [localhost]:10023        (686/postgrey.pid)
    [localhost]:10024        (1118/amavisd-new)
    [localhost]:10025        (1391/master)
    [localhost]:10026        (1118/amavisd-new)
    [localhost]:10027        (1391/master)
    [anywhere]:587        (1391/master)
    [localhost]:11211        (583/memcached)
    [anywhere]:110        (4959/dovecot)
    [anywhere]:143        (1/init)
    [anywhere]:111        (550/rpcbind)
    [anywhere]:10000        (1030/perl)
    [anywhere]:465        (1391/master)
    *:*:*:*::*:53        (587/named)
    *:*:*:*::*:22        (584/sshd)
    *:*:*:*::*:25        (1391/master)
    *:*:*:*::*:953        (587/named)
    *:*:*:*::*:443        (1003/apache2)
    *:*:*:*::*:993        (1/init)
    *:*:*:*::*:995        (4959/dovecot)
    *:*:*:*::*:47939        (562/rpc.statd)
    *:*:*:*::*:4711        (4959/dovecot)
    *:*:*:*::*:10023        (686/postgrey.pid)
    *:*:*:*::*:10024        (1118/amavisd-new)
    *:*:*:*::*:10026        (1118/amavisd-new)
    *:*:*:*::*:3306        (882/mysqld)
    *:*:*:*::*:587        (1391/master)
    [localhost]10        (4959/dovecot)
    [localhost]43        (1/init)
    [localhost]11        (550/rpcbind)
    [localhost]0000        (1030/perl)
    *:*:*:*::*:80        (1003/apache2)
    *:*:*:*::*:465        (1391/master)
    *:*:*:*::*:8081        (1003/apache2)
    ##### IPTABLES #####
    Chain INPUT (policy DROP)
    target     prot opt source               destination     
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0            state RELATED,ESTABLISHED
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0       
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0       
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:22
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:53
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            udp dpt:53
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:80
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:443
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:8080
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:25
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:3306
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:4711
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            udp dpt:64194
    
    Chain FORWARD (policy DROP)
    target     prot opt source               destination     
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp flags:0x17/0x02 limit: avg 1/sec burst 5
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            limit: avg 1/sec burst 5
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0            icmptype 8 limit: avg 1/sec burst 5
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp flags:0x17/0x04 limit: avg 1/sec burst 5
    
    Chain OUTPUT (policy DROP)
    target     prot opt source               destination     
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0            state RELATED,ESTABLISHED
    ACCEPT     all  --  [anywhere]/0            [anywhere]/0       
    ACCEPT     icmp --  [anywhere]/0            [anywhere]/0       
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:22
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:53
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            udp dpt:53
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:80
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:443
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:8080
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            udp dpt:123
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:25
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:3306
    ACCEPT     tcp  --  [anywhere]/0            [anywhere]/0            tcp dpt:4711
    ACCEPT     udp  --  [anywhere]/0            [anywhere]/0            udp dpt:64194
    This is what I got from the /var/log/apache2/error.log :
    Code:
    tail /var/log/apache2/error.log
    [ 2017-05-15 15:11:42.4407 1012/7f09b0940740 agents/HelperAgent/Main.cpp:650 ]: PassengerHelperAgent online, listening at unix:/tmp/passenger.1.0.1003/generation-0/request
    [ 2017-05-15 15:11:42.4970 1017/7f25dcf8e780 agents/LoggingAgent/Main.cpp:321 ]: PassengerLoggingAgent online, listening at unix:/tmp/passenger.1.0.1003/generation-0/logging
    [ 2017-05-15 15:11:42.4972 1009/7fca27ab3740 agents/Watchdog/Main.cpp:728 ]: All Phusion Passenger agents started!
    [Mon May 15 15:11:44.148618 2017] [:error] [pid 1003] python_init: Python version mismatch, expected '2.7.5+', found '2.7.9'.
    [Mon May 15 15:11:44.170810 2017] [:error] [pid 1003] python_init: Python executable found '/usr/bin/python'.
    [Mon May 15 15:11:44.170845 2017] [:error] [pid 1003] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-x86_64-linux-gnu:/usr/lib/python2.7/lib-tk:/usr/lib/python2.7/lib-old:/usr/lib/python2.7/lib-dynload'.
    [Mon May 15 15:11:44.170895 2017] [:notice] [pid 1003] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads.
    [Mon May 15 15:11:44.170901 2017] [:notice] [pid 1003] mod_python: using mutex_directory /tmp
    [Mon May 15 15:11:44.253880 2017] [mpm_prefork:notice] [pid 1003] AH00163: Apache/2.4.10 (Debian) mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcgid/2.3.9 Phusion_Passenger/4.0.53 mod_python/3.3.1 Python/2.7.9 OpenSSL/1.0.1t configured -- resuming normal operations
    [Mon May 15 15:11:44.253930 2017] [core:notice] [pid 1003] AH00094: Command line: '/usr/sbin/apache2'
    I saw some troubles, the ISPConfig Master/Slave are not in the exact same version, and the test script clearly show that my slave dont have the 8080 listening. But why?
     

    Attached Files:

  2. AEG-Simply

    AEG-Simply New Member

    I tried to update both serveur, now on 3.1.3, but problem not fixed.
     
  3. AEG-Simply

    AEG-Simply New Member

    Got an update.
    I found out that my ISPConfig-Slave did not have the ispconfig.vhost (in /etc/apache2/sites-available/ & enabled). I copied it manually from the ISPConfig-Master. After an apache2 restart, I have a :
    Code:
    SSLCertificateFile: file '/usr/local/ispconfig/interface/ssl/ispserver.crt' does not exist or is empty
    And indeed, there is not SSL files in this folder (therefore, theses files are present on Master).
    I commented out the lines in the ispconfig.vhost, and it works, but i don't have SSL on slave, obviously.

    Sooo... Can anybody help me out to figure where the error is from ? Did I missed something on the install or what ?
     
  4. AEG-Simply

    AEG-Simply New Member

    Oops, there is something more, I can't login on the ISPConfig-Slave with my ISPConfig-Master authentification... wrong credentials...
     
  5. AEG-Simply

    AEG-Simply New Member

    I modified the admin password in the database.
    I started a test, create a new client on master, synchronize all, and check if the client exist on the slave.

    Client doesn't exist.

    There is something awfully wrong with my setup, and I can't figure why.
     
  6. till

    till Super Moderator Staff Member ISPConfig Developer

  7. AEG-Simply

    AEG-Simply New Member

    I got 0 errors with the part Enable the debug Loglevel in ISPConfig
    But when it comes to Run the server script manually to get detailed debug output
    This is what I got :
    Code:
    PHP Warning:  mysqli_connect(): (28000/1045): Access denied for user 'ispcsrv3'@'ISPConfig-Slave' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 79
    PHP Warning:  mysqli_connect(): (28000/1045): Access denied for user 'ispcsrv3'@'ISPConfig-Slave' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    
    Where do this user came from ?
    The ispcrv3@'ISPConfig-Slave' exist on both server, and the md5 password hash is identical.
     
  8. AEG-Simply

    AEG-Simply New Member

    I somehow found the password of ispcsrv3, and I tried to connect to the Master from the slave manually using theses credentials but without success.

    Then I removed the old ispcsrv3 users in slave and in master.
    I created a 'ispcsrv3'@'%' and 'ispcsrv3'@'ISPConfig-Slave' with the password I got from /usr/local/ispconfig/interface/lib/config.inc.php on the master, with all rights on all dbispconfig, on the slave (and were automatically created on the master!?).

    I tried to connect to mysql manually using ispcsrv3 on slave to master, it works.

    But I have still the same error (Run the server script manually to get detailed debug output)
    Code:
    PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'ispcsrv3'@'ISPConfig-Slave' (using password: YES) in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 87
    PHP Warning: mysqli_connect(): (28000/1045): Access denied for user 'ispcsrv3'@'ISPConfig-Slave'
     
  9. AEG-Simply

    AEG-Simply New Member

    I managed to found that the password I used for the new ispcsrv3 sql account was not the one used by ISPConfig.

    Then I found out that the wrong password was in /usr/local/ispconfig/server/lib/config.inc.php, I just changed it to the one I found in /usr/local/ispconfig/interface/lib/config.inc.php from the Master, and there It goes, working !

    But I still don't know there this issue is from.
     

Share This Page