Can't connect to my ispconfig panel

Discussion in 'Technical' started by Joey Devs, Nov 30, 2019.

  1. Joey Devs

    Joey Devs Member

    Good day
    Please help I can't connect to my ispconfig panel and all my website show "
    Error establishing a database connection
    . I tried to restart my server ubuntu 16.04 and apache2 but still the same problem.
    - Linux Distribution and version used on your server: Ubuntu 16.04.4
    - ISPConfig version: 3.1

    Code:
    ##### SERVER #####
    IP-address (as per hostname): [localhost]
    IP-address(es) (as per ifconfig): ***.***.***.***
    [WARN] ip addresses from hostname differ from ifconfig output. Please check your ip settings.
    [INFO] OS version is Ubuntu 16.04.4 LTS
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.1.13
    
    [WARN] Could not connect to mysql with given user data.
    [WARN] Could not use mysql command line to connect to the database. Check your mysql config!
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.0.28-0ubuntu***.***.***.***
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    [email protected]:~# cat htf_report.txt | more
    
    ##### SERVER #####
    IP-address (as per hostname): [localhost]
    IP-address(es) (as per ifconfig): ***.***.***.***
    [WARN] ip addresses from hostname differ from ifconfig output. Please check your ip settings.
    [INFO] OS version is Ubuntu 16.04.4 LTS
    
    [INFO] ISPConfig is installed.
    
    ##### ISPCONFIG #####
    ISPConfig version is 3.1.13
    
    [WARN] Could not connect to mysql with given user data.
    [WARN] Could not use mysql command line to connect to the database. Check your mysql config!
    
    ##### VERSION CHECK #####
    
    [INFO] php (cli) version is 7.0.28-0ubuntu***.***.***.***
    
    ##### PORT CHECK #####
    
    
    ##### MAIL SERVER CHECK #####
    
    
    ##### RUNNING SERVER PROCESSES #####
    
    [INFO] I found the following web server(s):
            Unknown process (fcgi-pm) (PID 20938)
    [INFO] I found the following mail server(s):
            Postfix (PID 1417)
    [INFO] I found the following pop3 server(s):
            Dovecot (PID 1059)
    [INFO] I found the following imap server(s):
            Dovecot (PID 1059)
    [INFO] I found the following ftp server(s):
            PureFTP (PID 1259)
    
    ##### LISTENING PORTS #####
    (only           ()
    Local           (Address)
    [localhost]:9000                (1022/php-fpm.conf))
    [localhost]:10025               (1417/master)
    [localhost]:10027               (1417/master)
    [anywhere]:587          (1417/master)
    [localhost]:11211               (1025/memcached)
    [anywhere]:110          (1059/dovecot)
    [anywhere]:143          (1059/dovecot)
    [anywhere]:465          (1417/master)
    [anywhere]:21           (1259/pure-ftpd)
    ***.***.***.***:53              (1018/named)
    [localhost]:53          (1018/named)
    [anywhere]:22           (1035/sshd)
    [anywhere]:25           (1417/master)
    [localhost]:953         (1018/named)
    [anywhere]:993          (1059/dovecot)
    [anywhere]:995          (1059/dovecot)
    *:*:*:*::*:587          (1417/master)
    [localhost]10           (1059/dovecot)
    [localhost]43           (1059/dovecot)
    *:*:*:*::*:8080         (20938/fcgi-pm)
    *:*:*:*::*:80           (20938/fcgi-pm)
    *:*:*:*::*:8081         (20938/fcgi-pm)
    *:*:*:*::*:465          (1417/master)
    *:*:*:*::*:21           (1259/pure-ftpd)
    *:*:*:*::*:53           (1018/named)
    *:*:*:*::*:22           (1035/sshd)
    *:*:*:*::*:25           (1417/master)
    *:*:*:*::*:953          (1018/named)
    *:*:*:*::*:443          (20938/fcgi-pm)
    *:*:*:*::*:993          (1059/dovecot)
    *:*:*:*::*:995          (1059/dovecot)
    
    
    
    
    ##### IPTABLES #####
    Chain INPUT (policy ACCEPT)
    target     prot opt source               destination
    f2b-dovecot-pop3imap  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 110,995,143,993
    f2b-pureftpd  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 21
    f2b-postfix-sasl  tcp  --  [anywhere]/0            [anywhere]/0            multiport dports 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-dovecot-pop3imap (1 references)
    target     prot opt source               destination
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    Chain f2b-postfix-sasl (1 references)
    target     prot opt source               destination
    REJECT     all  --  ***.***.***.***         [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***         [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    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
    REJECT     all  --  ***.***.***.***      [anywhere]/0            reject-with icmp-port-unreachable
    REJECT     all  --  ***.***.***.***        [anywhere]/0            reject-with icmp-port-unreachable
    RETURN     all  --  [anywhere]/0            [anywhere]/0
    
    
    I check my var/logs/apache2/error.log
    show


    Code:
    [Sat Nov 30 06:25:05.388258 2019] [:error] [pid 30859] python_init: Python version mismatch, expected '2.7.6', found '2.7.12'.
    [Sat Nov 30 06:25:05.388436 2019] [:error] [pid 30859] python_init: Python executable found '/usr/bin/python'.
    [Sat Nov 30 06:25:05.388442 2019] [:error] [pid 30859] python_init: Python path being used '/usr/lib/python2.7/:/usr/lib/python2.7/plat-x86_64-lin$
    [Sat Nov 30 06:25:05.388461 2019] [:notice] [pid 30859] mod_python: Creating 8 session mutexes based on 150 max processes and 0 max threads.
    [Sat Nov 30 06:25:05.388480 2019] [:notice] [pid 30859] mod_python: using mutex_directory /tmp
    [Sat Nov 30 06:25:05.410724 2019] [ssl:warn] [pid 30859] AH01906: mywebsite.com:8080:0 server certificate is a CA certificate (BasicConstrai$
    [Sat Nov 30 06:25:05.410868 2019] [ssl:error] [pid 30859] AH02217: ssl_stapling_init_cert: can't retrieve issuer certificate! [subject: emailAddre$
    [Sat Nov 30 06:25:05.410879 2019] [ssl:error] [pid 30859] AH02604: Unable to configure certificate mywebsite.com:8080:0 for stapling
    [Sat Nov 30 06:25:05.411327 2019] [mpm_prefork:notice] [pid 30859] AH00163: Apache/2.4.18 (Ubuntu) mod_fastcgi/mod_fastcgi-SNAP-0910052141 mod_fcg$
    [Sat Nov 30 06:25:05.411358 2019] [core:notice] [pid 30859] AH00094: Command line: '/usr/sbin/apache2'
    [Sat Nov 30 06:25:05.411392 2019] [mpm_prefork:warn] [pid 30859] AH00167: long lost child came home! (pid 30862)
    Failed loading /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-20131226/xdebug.so:  /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-201312$
    [Sat Nov 30 07:24:40.617647 2019] [log_config:warn] [pid 3704] (28)No space left on device: [client 80.216.146.233:39182] AH00646: Error writing t$
    Failed loading /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-20131226/xdebug.so:  /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-201312$
    [Sat Nov 30 08:02:06.708888 2019] [log_config:warn] [pid 9141] (28)No space left on device: [client 189.146.69.31:49984] AH00646: Error writing to$
    Failed loading /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-20131226/xdebug.so:  /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-201312$
    Failed loading /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-20131226/xdebug.so:  /opt/php-5.6.30/lib/php/extensions/no-debug-non-zts-201312$
    [Sat Nov 30 08:42:53.311747 2019] [log_config:warn] [pid 24690] (28)No space left on device: [client 167.250.15.2:39050] AH00646: Error writing to$
    [Sat Nov 30 08:43:18.334528 2019] [log_config:warn] [pid 20059] (28)No space left on device: [client 109.234.153.134:27249] AH00646: Error writing$
    [Sat Nov 30 08:43:18.334753 2019] [log_config:warn] [pid 20278] (28)No space left on device: [client 109.234.153.134:49785] AH00646: Error writing$
    [Sat Nov 30 08:43:23.407865 2019] [log_config:warn] [pid 9146] (28)No space left on device: [client 109.234.153.130:54871] AH00646: Error writing $
    e
    Then also check mysql service
    Code:
    systemctl status mysql.service
    Code:
    mysql.service - LSB: Start and stop the mysql database server daemon
       Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
       Active: failed (Result: exit-code) since Fri 2019-11-29 23:09:18 UTC; 24h ago
         Docs: man:systemd-sysv-generator(8)
      Process: 32564 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)
    
    Warning: Journal has been rotated since unit was started. Log output is incomplete or unavailable.
    
    Then i tried to update my ispconfig via update.sh command

    Code:
    Creating backup of "/usr/local/ispconfig" directory...
    Creating backup of "/etc" directory...
    Unable to connect to mysql server No such file or directory
    MySQL root password [XXXXXX]:
    
    
     
    Last edited: Dec 1, 2019
  2. Joey Devs

    Joey Devs Member

    I think my mysql server in ispconfig can't connect how to fix it please thanks for the help guys.
     
  3. Taleman

    Taleman Well-Known Member HowtoForge Supporter

    The error log in #1 has all lines cut short. You should cut and paste in a way that complete lines are shown. And that paste has extra stuff from somewhere, that just confuses.
    You implied you posted output of
    Code:
    systemctl status mysql.service
    That has to be more than one line. In addition to complete lines, you should paste all lines.
    You seem to be using ISPConfig, but post in LInux forum.
    Do this first:
    https://www.howtoforge.com/community/threads/please-read-before-posting.58408/
    Then show what is the output of the following command. All lines, complete lines and try to avoid lines not related to this output.
    Code:
    systemctl --state=failed
     
  4. Joey Devs

    Joey Devs Member

    Thanks sir for fast response. Sorry because I've use my mobile phone now I edited my new post
    then here is the output
    systemctl --state=failed
    Code:
      UNIT          LOAD   ACTIVE SUB    DESCRIPTION
    ‚óŹ mysql.service loaded failed failed LSB: Start and stop the mysql database server daemon
    
    LOAD   = Reflects whether the unit definition was properly loaded.
    ACTIVE = The high-level unit activation state, i.e. generalization of SUB.
    SUB    = The low-level unit activation state, values depend on unit type.
    
    1 loaded units listed. Pass --all to see loaded but inactive units, too.
    To show all installed unit files use 'systemctl list-unit-files'.
    
    
     
  5. Joey Devs

    Joey Devs Member

    Then I contact my vps provider then told me that my default MySQL port is closed
    send me this output
    Code:
    ---[Network]--- Ping XXX.XXX.XXX.XXX is OK 
    3 packets transmitted, 3 received, 0% packet loss, time 412ms rtt min/avg/max/mdev = 0.301/0.351/0.407/0.043 ms ---[Ports]--- 
    20/tcp closed ftp-data conn-refused 
    21/tcp open ftp syn-ack 
    22/tcp open ssh syn-ack 
    25/tcp filtered smtp no-response 
    53/tcp open domain syn-ack 
    80/tcp open http syn-ack 
    143/tcp open imap syn-ack 
    443/tcp open https syn-ack 
    587/tcp open submission syn-ack 
    993/tcp open imaps syn-ack 
    2083/tcp closed radsec conn-refused 
    2087/tcp closed eli conn-refused 
    3306/tcp closed mysql conn-refused
    3389/tcp closed ms-term-serv conn-refused
    8443/tcp closed https-alt conn-refused 
    10000/tcp closed snet-sensor-mgmt conn-refused 
     
  6. Joey Devs

    Joey Devs Member

    I already fix thanks a lot
    Just open port 3306
     

Share This Page