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 ##### 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]:
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
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'.
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
