Allowing all IPs to connect to my database and FTP

[lavishsphere]

Shouldn’t these 2 rules be allowing every IP to access the databases I made and the FTP via port 21? Yet, why is my VPS on a new IP getting rejected. I just want to allow free roam access from every single IP to my ftp port and database port.

Do I need to do a command on my VPS or am I doing something wrong?

[sahsanu]

@lavishsphere

Shouldn’t these 2 rules be allowing every IP to access the databases I made and the FTP via port 21?

Regarding FTP, yes, that should work fine, what’s the error you get trying to connect to your FTP?

Regarding DB, you are allowing access to port 3306 but keep in mind that by default, mysql will only LISTEN on localhost (127.0.0.1) so you should modify the conf to made mysql LISTEN on your public ip.

More info on this post (keep in mind that your mysql users must be allowed to connect from external ips, not only by localhost):

External database connection

I want to be able to use hestiacp just to create a mysql database and be able to consume these databases externally using the host/ip of my server, I checked on the server and noticed that port 3306 is not open for this type of connection, in the panel can hestia release?, I’ve tried to add a rule to this port and it had no effect. [Screenshot_37] PORT STATE SERVICE 3306/tcp closed mysql

[lavishsphere]

Looks like FTP is working now. I had set my bind address to 0.0.0.0, changed it to “*” and restarted mariadb, I’m still getting this error:

Error updating guild information: Error: connect ECONNRESET 45.134.39.71:3306
    at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1605:16) {
  errno: -104,
  code: 'ECONNRESET',
  syscall: 'connect',
  address: '45.134.39.71',
  port: 3306,
  fatal: true
}

[sahsanu]

@lavishsphere

changed it to “*” and restarted mariadb, I’m still getting this error:

I can connect:

$ telnet 45.134.39.71 3306
Trying 45.134.39.71...
Connected to 45.134.39.71.
Escape character is '^]'.
c
5.5.5-10.11.6-MariaDB-0+deb12u1_^ea7-x9Q▒▒-lJmh@H*8xt_]mysql_native_password

[lavishsphere]

hmm might be something with the pterodactyl ufw, ill have to ask the host to look into that. thanks.