I really didn't feel the need to post my specs etc, so i'm just wondering, Is it possible to connect to a MySQL Database from a different Server?
eg. My Cs Server Is Hosted On One server, i don't have access to put MySQL on that server, so I was wondering, If it was possible to connect using a Database from my Web Host?
Thanks.
Stu.
Just a little question involving MYSQL
Moderator: Forum Moderator
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
stu:
Asked and replied, read the FORUM RULES and/or use the Search.
But, for now, I'm not locking it since although implied in several messages it isn't clearly stated in none, so here goes:
To connect to a remote server you only need to replace 127.0.0.1 with your MySQL server IP or DNS name from amx_sql_host in "addons/amxmodx/configs/sql.cfg" and FT_mysql_host in "addons/amxmodx/configs/war3FT.cfg" and in the MySQL for Warcraft 3 FT simple Mini-HOWTO, provided you followed the rest of it correctly.
WARNING: Please take notice that this not always will give you the results expected. In fact it might rise the lag of your server if the MySQL server isn't close enough to avoid timeouts between it and the game server. Run a traceroute (tracert for Microsoft Windows) or a tracepath and a ping both with your MySQL server IP or DNS name as parameter from your gameserver and check the latency for a general idea.
(I wrote a much more detailed explanation once in the old forums with the intention of adding it later to the Mini-HOWTO, but I don't recall the post subject)
I hope this helps.
Asked and replied, read the FORUM RULES and/or use the Search.
But, for now, I'm not locking it since although implied in several messages it isn't clearly stated in none, so here goes:
To connect to a remote server you only need to replace 127.0.0.1 with your MySQL server IP or DNS name from amx_sql_host in "addons/amxmodx/configs/sql.cfg" and FT_mysql_host in "addons/amxmodx/configs/war3FT.cfg" and in the MySQL for Warcraft 3 FT simple Mini-HOWTO, provided you followed the rest of it correctly.
WARNING: Please take notice that this not always will give you the results expected. In fact it might rise the lag of your server if the MySQL server isn't close enough to avoid timeouts between it and the game server. Run a traceroute (tracert for Microsoft Windows) or a tracepath and a ping both with your MySQL server IP or DNS name as parameter from your gameserver and check the latency for a general idea.
(I wrote a much more detailed explanation once in the old forums with the intention of adding it later to the Mini-HOWTO, but I don't recall the post subject)
I hope this helps.
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
Hi
Thanks mate, sorry for not following the rules, i just didnt feel it was appropriate to post all my modules, plugins, etc.
Also, i didn't put it in the sql.cfg, only the war3ft.cfg, but it still works? I decided on using www.freesql.org, since my host doesnt allow incoming connections.
It seems to be working OK, but at the start of a new map / new connection, i have to type changerace to select race, since it automatically keeps me on my previous race? :\
Thanks mate, sorry for not following the rules, i just didnt feel it was appropriate to post all my modules, plugins, etc.
Also, i didn't put it in the sql.cfg, only the war3ft.cfg, but it still works? I decided on using www.freesql.org, since my host doesnt allow incoming connections.
It seems to be working OK, but at the start of a new map / new connection, i have to type changerace to select race, since it automatically keeps me on my previous race? :\
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
That is for server problems, you made a question you didn't have a problem, so no harm there.stu wrote:Thanks mate, sorry for not following the rules, i just didnt feel it was appropriate to post all my modules, plugins, etc.
Yes for Warcraft 3 FT, but if you want admins stored in a SQL database you'll have to do sql.cfg too.stu wrote:Also, i didn't put it in the sql.cfg, only the war3ft.cfg, but it still works?
Beats me, this has nothing to do with SQL (or at least I can't see the connection), lets see what Geesu has to say about that.stu wrote:It seems to be working OK, but at the start of a new map / new connection, i have to type changerace to select race, since it automatically keeps me on my previous race? :\
Regards,
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!