1

Topic: Cant connect to maria DB remotely

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):  1.7.0
- Deployed with iRedMail Easy or the downloadable installer? Downloadables installer
- Linux/BSD distribution name and version:  Ubuntu 22.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):  MySQL
- Web server (Apache or Nginx): NGINX
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
Hello everyone so I have enabled MySQL to listen on port 3306:
tcp        0      0 0.0.0.0:3306            0.0.0.0:*               LISTEN      5780/mariadbd

Still no connection is allowed.
UFW is disabled
Iptables config:
Chain INPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     tcp  --  anywhere             anywhere             tcp dpt:mysql

but still no luck.

When doing a port scan seems port 3306 is filtered.
Any ideas?

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: Cant connect to maria DB remotely

Open port 3306 in nftables firewall (/etc/nftables.conf), or disable nftables temporarily.

Ubuntu 22.04 and 24.04 use nftables as firewall, not ufw or iptables.

3

Re: Cant connect to maria DB remotely

在安装的时候如何永久关闭nftables,或者在不影响之前配置的ufw规则,平移添加进来,亦或者在安装的时候,在显著未知标记,比如颜色或者空行、粗体字让用户确认?

4

Re: Cant connect to maria DB remotely

Thanks!!!! that worked. I was going crazy.




ZhangHuangbin wrote:

Open port 3306 in nftables firewall (/etc/nftables.conf), or disable nftables temporarily.

Ubuntu 22.04 and 24.04 use nftables as firewall, not ufw or iptables.