Good day Sorry for double post that was posted in linux forum. Kindly delete it or move my first post thanks. 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 ##### root@nursingcpdunits:~# 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]: 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
I already fix now I just allow port 3306 Code: iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPT
