ISPConfig version 3.1.13 installed but cannot be reached

Discussion in 'Installation/Configuration' started by BenCode, Nov 27, 2018.

  1. BenCode

    BenCode New Member

    Well done! ISPConfig installed and configured correctly :D
    After followed an installation guide with 'ISPConfig 3.1: Automated installation on Debian 9', the ISPConfig was successfully installed but cannot reach the ISPConfig panel page, instead it reached the 'Apache2 Debian Default Page' (see the attached image) using only my public static IP address without any ports followed by, e.g. ip address + 8080.

    Tips to those who helped:
    This installation has root access permission, and ports has been opened before the installation as below:
    • 20-22
    • 25
    • 53
    • 80
    • 110
    • 443
    • 3306
    • 8080-8081

    Thanks to Till's advise (and Taleman as well), below is the debug script result of this installation:

    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] ISPConfig is installed.

    ##### ISPCONFIG #####
    ISPConfig version is 3.1.13

    [WARN] Could not connect to mysql with given user data.

    ##### VERSION CHECK #####

    [INFO] php (cli) version is 7.0.30-0+deb9u1

    ##### PORT CHECK #####


    ##### MAIL SERVER CHECK #####


    ##### RUNNING SERVER PROCESSES #####

    [INFO] I found the following web server(s):
    Apache 2 (PID 23632)
    [INFO] I found the following mail server(s):
    Postfix (PID 23405)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 23454)
    [INFO] I found the following imap server(s):
    Dovecot (PID 23454)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 23557)

    ##### LISTENING PORTS #####
    --More--
     

    Attached Files:

  2. till

    till Super Moderator Staff Member ISPConfig Developer

    That's just a small portion of the test script output, please post the full result.
     
  3. BenCode

    BenCode New Member

    Just run another test but it looks the same, please check the screenshot. Can you please give an example of the script outputs or other commands so I can do a text for what you are really looking for?
    The test result was based on the command below:
    First to login as root >> sudo -s
    then,
    • wget -q -O htf-common-issues.php "this is the gitplace link (your forum doesn't allow new users to include a link on it)" && php -q htf-common-issues.php
    again use below command to get the result:
    • cat htf_report.txt | more
     

    Attached Files:

    • ds.PNG
      ds.PNG
      File size:
      61.7 KB
      Views:
      8
  4. BenCode

    BenCode New Member

    Have run another test with the command below:
    • php -q htf-common-issues.php --debug
    And the full result as below:
    The programs included with the Debian GNU/Linux system are free software;
    the exact distribution terms for each program are described in the
    individual files in /usr/share/doc/*/copyright.

    Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
    permitted by applicable law.
    Last login: Tue Nov 27 10:02:28 2018 from xx.xxx.xxx.x (ip address)
    [email protected](ip address):~$ sudo -s
    [email protected]:/home/admin# php -q htf-common-issues.php --debug

    ##### SERVER #####
    IP-address (as per hostname): 127.0.1.1
    [WARN] could not determine server's ip address by ifconfig
    [INFO] ISPConfig is installed.

    ##### ISPCONFIG #####
    ISPConfig version is 3.1.13

    PHP Warning: mysqli_connect(): (HY000/2002): No such file or directory in /home/admin/htf
    -common-issues.php on line 184
    [WARN] Could not connect to mysql with given user data.

    ##### VERSION CHECK #####

    [INFO] php (cli) version is 7.0.30-0+deb9u1

    ##### PORT CHECK #####


    ##### MAIL SERVER CHECK #####


    ##### RUNNING SERVER PROCESSES #####

    [INFO] I found the following web server(s):
    Apache 2 (PID 23632)
    [INFO] I found the following mail server(s):
    Postfix (PID 23405)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 23454)
    [INFO] I found the following imap server(s):
    Dovecot (PID 23454)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 23557)

    ##### LISTENING PORTS #####
    (only()
    Local(Address)
    127.0.0.1:10023(10001/postgrey)
    127.0.0.1:10024(23689/amavisd-new)
    127.0.0.1:10025(23405/master)
    127.0.0.1:10026(23689/amavisd-new)
    127.0.0.1:10027(23405/master)
    0.0.0.0:587(23405/master)
    127.0.0.1:11211(9930/memcached)
    0.0.0.0:110(23454/dovecot)
    0.0.0.0:143(23454/dovecot)
    0.0.0.0:465(23405/master)
    172.26.0.197:53(23560/named)
    127.0.0.1:53(23560/named)
    0.0.0.0:21(23557/pure-ftpd)
    0.0.0.0:22(537/sshd)
    127.0.0.1:953(23560/named)
    0.0.0.0:25(23405/master)
    0.0.0.0:993(23454/dovecot)
    0.0.0.0:995(23454/dovecot)
    ::1:10024(23689/amavisd-new)
    ::1:10026(23689/amavisd-new)
    :::587(23405/master)
    :::110(23454/dovecot)
    :::143(23454/dovecot)
    :::80(23632/apache2)
    :::8080(23632/apache2)
    :::465(23405/master)
    :::8081(23632/apache2)
    :::53(23560/named)
    :::21(23557/pure-ftpd)
    :::22(537/sshd)
    ::1:953(23560/named)
    :::25(23405/master)
    :::443(23632/apache2)
    :::993(23454/dovecot)
    :::995(23454/dovecot)




    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target prot opt source destination
    f2b-pureftpd tcp -- 0.0.0.0/0 0.0.0.0/0 multiport dports 21
    f2b-postfix-sasl tcp -- 0.0.0.0/0 0.0.0.0/0 multiport dports 25
    f2b-sshd tcp -- 0.0.0.0/0 0.0.0.0/0 multiport dports 22

    Chain FORWARD (policy ACCEPT)
    target prot opt source destination

    Chain OUTPUT (policy ACCEPT)
    target prot opt source destination

    Chain f2b-postfix-sasl (1 references)
    target prot opt source destination
    RETURN all -- 0.0.0.0/0 0.0.0.0/0

    Chain f2b-pureftpd (1 references)
    target prot opt source destination
    RETURN all -- 0.0.0.0/0 0.0.0.0/0

    Chain f2b-sshd (1 references)
    target prot opt source destination
    RETURN all -- 0.0.0.0/0 0.0.0.0/0



    [email protected]:/home/admin#
     
  5. BenCode

    BenCode New Member

    Below is a Debian log using the command below:
    • ls -lht /var/log | head
    • ping -c 3 8.8.8.8

    Linux ip--xxx-xx-x-xxx 4.9.0-8-amd64 #1 SMP Debian 4.9.110-3+deb9u5 (2018-09-30) x86_64

    The programs included with the Debian GNU/Linux system are free software;
    the exact distribution terms for each program are described in the
    individual files in /usr/share/doc/*/copyright.

    Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
    permitted by applicable law.
    Last login: Tue Nov 27 10:04:23 2018 from xx.xxx.xxx.x
    [email protected]:~$ sudo -s
    [email protected]:/home/admin# Is -Iht /var/log | head
    bash: Is: command not found
    [email protected]:/home/admin# ls -lht /var/log | head
    total 3.6M
    -rw-r----- 1 root adm 391K Nov 27 10:34 auth.log
    -rw-r----- 1 root adm 923K Nov 27 10:34 syslog
    -rw-r----- 1 root adm 207K Nov 27 10:33 daemon.log
    -rw-rw-r-- 1 root utmp 1.4M Nov 27 10:32 lastlog
    -rw-rw-r-- 1 root utmp 7.2K Nov 27 10:32 wtmp
    -rw-r----- 1 root adm 364K Nov 27 09:48 mail.info
    -rw-r--r-- 1 root adm 364K Nov 27 09:48 mail.log
    -rw-r--r-- 1 root adm 212K Nov 27 09:48 mail.warn
    -rw-r----- 1 root adm 43K Nov 27 09:48 mail.err

    [email protected]:/home/admin# ping -c 3 8.8.8.8

    PING 8.8.8.8 (8.8.8.8) 56(84) bytes of data.
    64 bytes from 8.8.8.8: icmp_seq=1 ttl=118 time=1.86 ms
    64 bytes from 8.8.8.8: icmp_seq=2 ttl=118 time=1.97 ms
    64 bytes from 8.8.8.8: icmp_seq=3 ttl=118 time=1.95 ms

    --- 8.8.8.8 ping statistics ---
    3 packets transmitted, 3 received, 0% packet loss, time 2003ms
    rtt min/avg/max/mdev = 1.863/1.931/1.978/0.061 ms
    [email protected]:/home/admin#
     
  6. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    You seem to have changed setup, this is different from the first report.
    What do commands show:
    Code:
    hostname
    hostname -f
    Not connecting to database pretty much renders ISPConfig and the services inoperable. are the database host, user and password correct? Try connecting from command line, for example, to verify the settings work.
     
  7. BenCode

    BenCode New Member

    Have only tried two different option for YES or No to installing the PHPMyAdmin along with this installation. Both the installation was successful and both of them are reached the Apache Debian default page.
    ISPConfig 3.1: Automated installation on Debian 9

    The installation guide says:
    Due to a bug in dbconfig-common, we can't automate PHPMyAdmin installation for now. So hit 'enter' and on the next question select 'NO' (attention because the default is 'YES').
     
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    Just a guess, you did not run the test script as root. the test script must be run as root user to give correct results.
     
  9. BenCode

    BenCode New Member

    Please double check the code provided above:
    [email protected]ip--xxx-xx-x-xxx:/home/admin# ping -c 3 8.8.8.8

    The last couple times of test was run under the command, sudo -s from start to finish.
    Anyway, will test it again using just the sudo each time rather than sudo -s in one go.
     
  10. BenCode

    BenCode New Member

    FIRST TEST

    Login to SSH as root:

    SUDO -S

    Then:
    wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    And then:
    cat htf_report.txt | more

    Total output data from the test

    Linux ip- (server internal ip address) 4.9.0-8-amd64 #1 SMP Debian 4.9.110-3+deb9u5 (2018-09-30) x86_64

    The programs included with the Debian GNU/Linux system are free software;
    the exact distribution terms for each program are described in the
    individual files in /usr/share/doc/*/copyright.

    Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
    permitted by applicable law.
    Last login: Tue Nov 27 10:04:23 2018 from 54.240.194.1
    [email protected]:~$ sudo -s
    [email protected]:/home/admin# Is -Iht /var/log | head
    bash: Is: command not found
    [email protected]:/home/admin# ls -lht /var/log | head
    total 3.6M
    -rw-r----- 1 root adm 391K Nov 27 10:34 auth.log
    -rw-r----- 1 root adm 923K Nov 27 10:34 syslog
    -rw-r----- 1 root adm 207K Nov 27 10:33 daemon.log
    -rw-rw-r-- 1 root utmp 1.4M Nov 27 10:32 lastlog
    -rw-rw-r-- 1 root utmp 7.2K Nov 27 10:32 wtmp
    -rw-r----- 1 root adm 364K Nov 27 09:48 mail.info
    -rw-r--r-- 1 root adm 364K Nov 27 09:48 mail.log
    -rw-r--r-- 1 root adm 212K Nov 27 09:48 mail.warn
    -rw-r----- 1 root adm 43K Nov 27 09:48 mail.err
    [email protected]:/home/admin# ping -c 3 8.8.8.8
    PING 8.8.8.8 (8.8.8.8) 56(84) bytes of data.
    64 bytes from 8.8.8.8: icmp_seq=1 ttl=118 time=1.86 ms
    64 bytes from 8.8.8.8: icmp_seq=2 ttl=118 time=1.97 ms
    64 bytes from 8.8.8.8: icmp_seq=3 ttl=118 time=1.95 ms

    --- 8.8.8.8 ping statistics ---
    3 packets transmitted, 3 received, 0% packet loss, time 2003ms
    rtt min/avg/max/mdev = 1.863/1.931/1.978/0.061 ms
    [email protected]:/home/admin#

    ==============================================================

    SECOND TEST (This kind of test looks the same as the previous post. The difference between the two test is 'cat htf_report.txt' and 'cat htf_report.txt | more')

    Login to SSH as root:
    SUDO -S

    Then:
    wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    And then:
    cat htf_report.txt | more

    Total output data from the test

    The programs included with the Debian GNU/Linux system are free software;
    the exact distribution terms for each program are described in the
    individual files in /usr/share/doc/*/copyright.

    Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
    permitted by applicable law.
    Last login: Thu Nov 29 04:32:06 2018 from 54.240.194.25
    [email protected]:~$ sudo -s
    [email protected]:/home/admin# wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispcon
    fig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    ##### SCRIPT FINISHED #####
    Results can be found in htf_report.txt
    To view results use your favourite text editor or type 'cat htf_report.txt | more' on the
    server console.

    If you want to see the non-anonymized output start the script with --debug as parameter (p
    hp -q htf-common-issues.php --debug).

    [email protected]:/home/admin# cat htf_report.txt | more

    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] ISPConfig is installed.

    ##### ISPCONFIG #####
    ISPConfig version is 3.1.13


    ##### VERSION CHECK #####

    [INFO] php (cli) version is 7.0.30-0+deb9u1

    ##### PORT CHECK #####


    ##### MAIL SERVER CHECK #####


    ##### RUNNING SERVER PROCESSES #####

    [INFO] I found the following web server(s):
    Apache 2 (PID 837)
    [INFO] I found the following mail server(s):
    Postfix (PID 1056)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 635)
    [INFO] I found the following imap server(s):
    Dovecot (PID 635)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 962)

    ##### LISTENING PORTS #####
    (only()
    --More--
     
  11. BenCode

    BenCode New Member

    Please discard the first part of the last post because that was using a different command on it. Here is the out using the command: 'cat htf_report.txt' without '| more', see below:

    Login to SSH as a root
    sudo -s

    Then RUN:
    wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispconfig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    and run:
    cat htf_report.txt

    And the ouput:
    The programs included with the Debian GNU/Linux system are free software;
    the exact distribution terms for each program are described in the
    individual files in /usr/share/doc/*/copyright.

    Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
    permitted by applicable law.
    Last login: Thu Nov 29 04:15:27 2018 from xx.xxx.xxx.xx (ip address)
    [email protected]:~$ sudo -s
    [email protected]:/home/admin# wget -q -O htf-common-issues.php "http://gitplace.net/pixcept/ispcon
    fig-tools/raw/stable/htf-common-issues.php" && php -q htf-common-issues.php

    ##### SCRIPT FINISHED #####
    Results can be found in htf_report.txt
    To view results use your favourite text editor or type 'cat htf_report.txt | more' on the
    server console.

    If you want to see the non-anonymized output start the script with --debug as parameter (p
    hp -q htf-common-issues.php --debug).

    [email protected]:/home/admin# cat htf_report.txt

    ##### SERVER #####
    IP-address (as per hostname): ***.***.***.***
    [WARN] could not determine server's ip address by ifconfig
    [INFO] ISPConfig is installed.

    ##### ISPCONFIG #####
    ISPConfig version is 3.1.13


    ##### VERSION CHECK #####

    [INFO] php (cli) version is 7.0.30-0+deb9u1

    ##### PORT CHECK #####


    ##### MAIL SERVER CHECK #####


    ##### RUNNING SERVER PROCESSES #####

    [INFO] I found the following web server(s):
    Apache 2 (PID 837)
    [INFO] I found the following mail server(s):
    Postfix (PID 1056)
    [INFO] I found the following pop3 server(s):
    Dovecot (PID 635)
    [INFO] I found the following imap server(s):
    Dovecot (PID 635)
    [INFO] I found the following ftp server(s):
    PureFTP (PID 962)

    ##### LISTENING PORTS #####
    (only()
    Local(Address)
    [localhost]:10023(887/postgrey)
    [localhost]:10024(1074/amavisd-new)
    [localhost]:10025(1056/master)
    [localhost]:10026(1074/amavisd-new)
    [localhost]:10027(1056/master)
    [anywhere]:587(1056/master)
    [localhost]:11211(574/memcached)
    [anywhere]:110(635/dovecot)
    [anywhere]:143(635/dovecot)
    [anywhere]:465(1056/master)
    [anywhere]:21(962/pure-ftpd)
    ***.***.***.***:53(563/named)
    [localhost]:53(563/named)
    [anywhere]:22(622/sshd)
    [anywhere]:25(1056/master)
    [localhost]:953(563/named)
    [anywhere]:993(635/dovecot)
    [anywhere]:995(635/dovecot)
    *:*:*:*::*:10024(1074/amavisd-new)
    *:*:*:*::*:10026(1074/amavisd-new)
    *:*:*:*::*:3306(803/mysqld)
    *:*:*:*::*:587(1056/master)
    [localhost]10(635/dovecot)
    [localhost]43(635/dovecot)
    *:*:*:*::*:80(837/apache2)
    *:*:*:*::*:8080(837/apache2)
    *:*:*:*::*:465(1056/master)
    *:*:*:*::*:8081(837/apache2)
    *:*:*:*::*:21(962/pure-ftpd)
    *:*:*:*::*:53(563/named)
    *:*:*:*::*:22(622/sshd)
    *:*:*:*::*:25(1056/master)
    *:*:*:*::*:953(563/named)
    *:*:*:*::*:443(837/apache2)
    *:*:*:*::*:993(635/dovecot)
    *:*:*:*::*:995(635/dovecot)



    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target prot opt source destination
    f2b-pureftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21
    f2b-postfix-sasl tcp -- [anywhere]/0 [anywhere]/0 multiport dport
    s 25
    f2b-sshd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 22

    Chain FORWARD (policy ACCEPT)
    target prot opt source destination

    Chain OUTPUT (policy ACCEPT)
    target prot opt source destination

    Chain f2b-postfix-sasl (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0

    Chain f2b-pureftpd (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0

    Chain f2b-sshd (1 references)
    target prot opt source destination
    RETURN all -- [anywhere]/0 [anywhere]/0


    [email protected]:/home/admin#
     
  12. till

    till Super Moderator Staff Member ISPConfig Developer

    The result looks ok so far so you should be able to reach ispconfig on port 8080. Please post the content of the ispconfig vhost file from /etc/apache2/sites-available/ folder.
     
  13. BenCode

    BenCode New Member

    Still unable to get there. I Will reinstall it again sometime over the weekend and see how is going.
     
  14. till

    till Super Moderator Staff Member ISPConfig Developer

    You should consider using one of the official install guides (Perfect server guides) instead of that third party auto installer. You can find the list of install guides here: https://www.ispconfig.org/documentation/
    The problem with an autoinstaller is that you don't see when a step fails which makes it complicated to debug at the end and autoinstallers fail easily when the base environment where you run it is not completely clean.
     

Share This Page