AAC Web connection + tfs

[bpm91]

I would like to know if anyone knows how I can connect a computer where my server runs to a computer where my website is located.
I'm using tfs 1.5 and myaac
they are different machines

 

[Gesior.pl]

Assuming that both are servers with public IPs (2 VPSes/2 dedics):
1. On computer with TFS make database (MySQL/MariaDB) listens on all IPs (IP 0.0.0.0 in config) ex. for MariaDB replace bind-address = 127.0.0.1 to bind-address = 0.0.0.0 in /etc/mysql/mariadb.conf.d/50-server.cnf and restart MySQL (sudo systemctl restart mysql).
2. In database (MySQL/MariaDB) allow some account (ex. root) to login from IP %, which means 'any ip' - phpmyadmin or some other tool to edit it. Often it's set to 127.0.0.1 by default.
3. On computer with website put copy of TFS files somewhere, then edit config.lua and make it point to server with TFS database ex.:

-- your TFS and MySQL server IP
mysqlHost = "12.34.56.78"
mysqlUser = "root"
mysqlPass = "secretpassword"
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

 

[bpm91]

ty gesior, u are best

 

[bpm91]

Assuming that both are servers with public IPs (2 VPSes/2 dedics):
1. On computer with TFS make database (MySQL/MariaDB) listens on all IPs (IP 0.0.0.0 in config) ex. for MariaDB replace bind-address = 127.0.0.1 to bind-address = 0.0.0.0 in /etc/mysql/mariadb.conf.d/50-server.cnf and restart MySQL (sudo systemctl restart mysql).
2. In database (MySQL/MariaDB) allow some account (ex. root) to login from IP %, which means 'any ip' - phpmyadmin or some other tool to edit it. Often it's set to 127.0.0.1 by default.
3. On computer with website put copy of TFS files somewhere, then edit config.lua and make it point to server with TFS database ex.:

-- your TFS and MySQL server IP
mysqlHost = "12.34.56.78"
mysqlUser = "root"
mysqlPass = "secretpassword"
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

When I have 2 machines, 1 website and 1 machine with a database, how do I put this in otservlist.org? Could you tell me? How would I display it in name format and not IP?

 

[highsanta]

When I have 2 machines, 1 website and 1 machine with a database, how do I put this in otservlist.org? Could you tell me? How would I display it in name format and not IP?

Post automatically merged: Jan 15, 2025

ChatGPT - New chat

Shared via ChatGPT

chatgpt.com

updated

 

[bpm91]

Assuming that both are servers with public IPs (2 VPSes/2 dedics):
1. On computer with TFS make database (MySQL/MariaDB) listens on all IPs (IP 0.0.0.0 in config) ex. for MariaDB replace bind-address = 127.0.0.1 to bind-address = 0.0.0.0 in /etc/mysql/mariadb.conf.d/50-server.cnf and restart MySQL (sudo systemctl restart mysql).
2. In database (MySQL/MariaDB) allow some account (ex. root) to login from IP %, which means 'any ip' - phpmyadmin or some other tool to edit it. Often it's set to 127.0.0.1 by default.
3. On computer with website put copy of TFS files somewhere, then edit config.lua and make it point to server with TFS database ex.:

-- your TFS and MySQL server IP
mysqlHost = "12.34.56.78"
mysqlUser = "root"
mysqlPass = "secretpassword"
mysqlDatabase = "forgottenserver"
mysqlPort = 3306
mysqlSock = ""

Ty Gesior

 

[Gesior.pl]

When I have 2 machines, 1 website and 1 machine with a database, how do I put this in otservlist.org? Could you tell me? How would I display it in name format and not IP?

People often put website on separate IP, to block possibility to DDoS website and make OTS offline - if someone DDoS website, website will go down, but OTS and database running on separate VPS will stay untouched.
When they do it, they always configure CloudFlare.com protection for www. With CloudFlare protection you cannot host anything else on same IP, as it will block all connections that do not connect to ports 80/443 or use other communication protocol than website (http/websocket).

With that configuration, you can setup nginx/apache on OTS VPS with simple 'redirect to website domain' code, but then your server with OTS will allow website connections (port 80/443) and it will allow attackers to DDoS it.

That's how 90% of OTSes work nowadays. You can check on otservlist, everyone adds their server with subdomain. Website is on x.com (domain protected by CloudFlare) and OTS is listed as up.x.com, on.x.com, play.x.com, status.x.com, login.x.com etc. (with protection disabled in CloudFlare panel for given subdomain). You can check top servers from otservlist:

https://otservlist.org/

If you copy their IP and paste in web browser ex. on.aurera-global.com, sv.kaldrox.com, play.olders.online, it will show error that website is offline, as none of them use 'redirect' on IP with OTS, to reduce chance of DDoS. Players are used to it and they know that they have to remove subdomain from address to visit OTS website.

 

[bpm91]

I did what you mentioned, I left a subdomain