[alvaroag]

That's because your distro has some iptables rules pre-configured. The only distro I remember does that is CentOS. How to disable it depends on CentOS version. For version 7, run "systemctl disable iptables ip6tables firewalld". For versions 6 and older, run "chkconfig --del iptables; chkconfig --del ip6tables; chkconfig --del firewalld". After that, those firewall rules will not longer be applied.

But, WARNING: It's not a good idea to let your vps with no firewall rules. That turns your server really vulnerable, and you probably don't want that. managing ipbales rules directly has the OS does it not an option either, unless you are really familiar with it. My recommendation is to use Shorewall, as well as it's IPv6 version, Shorewall6, as they are both easy to configure and really powerful.

[hipporookie]

Alrighty. I have let my IP address (which is static) connect to my Linux database, likewise goes for my webhost. Delete, insert, select and update permission given. I'm still having the issue where I have to iptables --flush everytime I reboot the VPS though. Otherwise nothing will work.

[alvaroag]

"Whilst you can use the VPS as a database server this may not be recommended in light of security as this means traffic is passed through to your VPS via a public connection. By default the database is set on "localhost" this is for security reasons. "

But what if you only allow the webhost IP that is trying to retrieve info from the VPS database? How'll that affect the security if it's only the host that can access it? I guess that's possible.

Oh, I understood it upside down. You want to use a database located on your VPS from a web hosting outside OVH. Some hosting providers won't allow that, but most would. You can just try it.

However, what Dani is pointing out is about security. No matter the firewall rules or authentication rules you, the communication will go thru a public network, and that cannot be considered secure. But it may work, anyway.

[hipporookie]

"Whilst you can use the VPS as a database server this may not be recommended in light of security as this means traffic is passed through to your VPS via a public connection. By default the database is set on "localhost" this is for security reasons. "

But what if you only allow the webhost IP that is trying to retrieve info from the VPS database? How'll that affect the security if it's only the host that can access it? I guess that's possible.

[hipporookie]

Hi.

I'm stilling having port issues what so ever. I just installed teamspeak, and it is running - but I cannot connect.

ip flush did the thing.

However, everytime I reboot my VPS I have to do a ip flush. How come? That's annoying.

[Dani]

Hi

OVH has an open network we don't have any restrictions on the ports.

Whilst you can use the VPS as a database server this may not be recommended in light of security as this means traffic is passed through to your VPS via a public connection. By default the database is set on "localhost" this is for security reasons.

Based on your type of setup where by you have a server as an web server and another server as database server you would make use of the OVH vRack.

https://www.ovh.co.uk/solutions/vrack/

Thanks

Danny

[hipporookie]

Yes, I am running Linux. I ran the command you sent me and this is what I received https://i.gyazo.com/6646d0cc861b2f06...66e75397fb.png
I don't know much about linux in general, therefore I don't really understand how this work nor what that means.

About the other issue. I'm trying to connect to the VPS. I have a webhost, but I'd like to use the MySQL database hosted on my linux server. So it's not from the linux server to the webhost, but the other way. Not sure if that works either, but. The host I have is quite open, so I would be shocked if they'd restrict anything like that. I can hear with them though, but OVH doesn't restrict us from connecting to the VPS database I hope?

[alvaroag]

Hi. What OS are you using? Some Linux distros come with pre-configured firewall rules, so you would probably prefer to setup your own firewall(like shorewall or firehol). Run "iptables -L" ("L" in caps) to check if there are iptables rules set.

On the other issue.... most hosting providers don't allow external access to the database. Also, the web server may not be always the one that hosts databases. The best option here is to write to your hosting providers and ask them for external connection to the database. They will tell you if it's possible & allowed, and, if so, will give you the required parameters.

[hipporookie]

Howdy!

I have just set up my game server, but apparently it will not show up on the server list. It starts on port 7777, which is the default one for the server that I am running. According to the MySQL log and the server log, everything is running smoothly. Assume it has to do with the ports, but I have read around on the forums and apparently OVH haven't blocked any ports? Any tips on what it could be?

I'm also wondering about something else. I have a webhost (not at OVH) and I'd like to connect to the database that I use for the server. I assume the host will be the server IP, the port would be 3306 and then I could just simply use the username and password that I have registered, but it doesn't seem to work that way. I need help with both of these issues, any suggestions? About that port issue, also sent a ticket on that one.

It's VPS vps302183 if that helps.