Code: ##### SERVER ##### IP-address (as per hostname): ***.***.***.*** [WARN] could not determine server's ip address by ifconfig [INFO] OS version is Ubuntu 22.04.2 LTS [INFO] uptime: 04:10:27 up 14 days, 2:32, 1 user, load average: 0.02, 0.01, 0.00 [INFO] memory: total used free shared buff/cache available Mem: 7.6Gi 2.0Gi 1.2Gi 73Mi 4.3Gi 5.2Gi Swap: 0B 0B 0B [INFO] systemd failed services status: UNIT LOAD ACTIVE SUB DESCRIPTION ● console-setup.service loaded failed failed Set console font and keymap 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. [INFO] ISPConfig is installed. ##### ISPCONFIG ##### ISPConfig version is 3.2.9p1 ##### VERSION CHECK ##### [INFO] php (cli) version is 8.1.18 [INFO] php-cgi (used for cgi php in default vhost!) is version 8.1.18 ##### PORT CHECK ##### ##### MAIL SERVER CHECK ##### ##### RUNNING SERVER PROCESSES ##### [INFO] I found the following web server(s): Apache 2 (PID 2614175) [INFO] I found the following mail server(s): Postfix (PID 805065) [INFO] I found the following pop3 server(s): Dovecot (PID 182974) [INFO] I found the following imap server(s): Dovecot (PID 182974) [INFO] I found the following ftp server(s): PureFTP (PID 2678645) ##### LISTENING PORTS ##### (only () Local (Address) [localhost]:6379 (44252/redis-server) ***.***.***.***:53 (183188/named) ***.***.***.***:53 (183188/named) ***.***.***.***:53 (183188/named) ***.***.***.***:53 (183188/named) [localhost]:11211 (149056/memcached) [anywhere]:3306 (182342/mariadbd) [localhost]:11333 (182968/rspamd:) [localhost]:11332 (182968/rspamd:) [localhost]:11334 (182968/rspamd:) [anywhere]:25 (805065/master) [anywhere]:22 (177647/sshd:) [anywhere]:21 (2678645/pure-ftpd) [anywhere]:110 (182974/dovecot) [anywhere]:4190 (182974/dovecot) [anywhere]:143 (182974/dovecot) [localhost]:53 (183188/named) [localhost]:53 (183188/named) [localhost]:53 (183188/named) [localhost]:53 (183188/named) ***.***.***.***:53 (471/systemd-resolve) [anywhere]:465 (805065/master) [localhost]:953 (183188/named) [localhost]:953 (183188/named) [localhost]:953 (183188/named) [localhost]:953 (183188/named) [anywhere]:587 (805065/master) [anywhere]:995 (182974/dovecot) [anywhere]:993 (182974/dovecot) [localhost]:10023 (44501/postgrey) *:*:*:*::*:953 (183188/named) *:*:*:*::*:953 (183188/named) *:*:*:*::*:953 (183188/named) *:*:*:*::*:953 (183188/named) *:*:*:*::*:53 (183188/named) *:*:*:*::*:53 (183188/named) *:*:*:*::*:53 (183188/named) *:*:*:*::*:53 (183188/named) *:*:*:*::*:3306 (182342/mariadbd) *:*:*:*::*:8081 (2614175/apache2) *:*:*:*::*:8080 (2614175/apache2) *:*:*:*::*:25 (805065/master) *:*:*:*::*:22 (177647/sshd:) *:*:*:*::*:21 (2678645/pure-ftpd) [localhost]10 (182974/dovecot) *:*:*:*::*:4190 (182974/dovecot) *:*:*:*::*:80 (2614175/apache2) [localhost]43 (182974/dovecot) *:*:*:*::*:443 (2614175/apache2) *:*:*:*::*:465 (805065/master) *:*:*:*::*:587 (805065/master) *:*:*:*::*:6379 (44252/redis-server) *:*:*:*::*:995 (182974/dovecot) *:*:*:*::*:993 (182974/dovecot) *:*:*:*::*f816:3eff:fe71:53 (183188/named) *:*:*:*::*f816:3eff:fe71:53 (183188/named) *:*:*:*::*f816:3eff:fe71:53 (183188/named) *:*:*:*::*f816:3eff:fe71:53 (183188/named) ##### IPTABLES ##### Chain INPUT (policy ACCEPT) target prot opt source destination f2b-pure-ftpd tcp -- [anywhere]/0 [anywhere]/0 multiport dports 21 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-pure-ftpd (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 ##### LET'S ENCRYPT ##### acme.sh is installed in /root/.acme.sh/acme.sh I have just installed ispconfig server 2 weeks ago, but when I try to access any database remotely (through MySQL workbench) I get access denied No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04.2 LTS Release: 22.04 Codename: jammy PHP 8.1.18 (cli) (built: Apr 14 2023 04:39:44) (NTS) Copyright (c) The PHP Group Zend Engine v4.1.18, Copyright (c) Zend Technologies with Zend OPcache v8.1.18, Copyright (c), by Zend Technologies
also, have you run mysql_secure_installation? if you're trying to connect with root, remote root access may have been disabled by that script.
That command is run by typing it's command name. But what it does it sets mysql up so remote access by root is prevented, so not what you want. But are you connecting remotely as root? If not, this does not apply to your case. You would need to examine mysql settings to see what is allowed or denied there. Have you examined all log files to maybe get more info on why access is denied? Does that mysql workbench have verbose setting so it shows more info on what happens during attempt to connect? You could try connecting with command line mysql client or some other client, see what happens.
