Getting internet access to server working

I am sorry to post something that has so many views but I have been through them all and can't seem to find what I need. I downloaded the full repack for the burning crusade server from here and read through to get the sql fixed and this set up and is working fine within my house. I have a static ip from my internet provider and I have a dlink router and i have set my computer to have a static ip as well. I have my Computer's static IP in the realmd.conf and mangosd.conf fileand in the realmlist i have it as my address and the ip for the database. Set up this way and giving my friend the static ip i have for outside he gets logged in and it shows in my realmd window he is connected but it pops up the window that says connected and stays there. I read a walkthrough that said to change the address portion in realmlist to my public ip which i assume would be my external ip but when I do this then try to connect at home it does the same thing by going to the connected window and staying there. It won't let me into the character select although it says i am connected.

I have forwarded ports 3306, 3724,8085,3443, and 8080 in the virtual server section of my dlink router which automatically made rules in the firewall part of the dlink. In Windows XP i added all these ports to the firewall as well. The walkthrough also said to forward ports 3427-3800 which i am unable to figure out how to do on my dlink. I do not know how to forward a group of ports. If this is my problem could someone let me know how to forward ports other than using the virtual server section on the dlink. I have this server working like a charm internally and would like a few friends to play with so any help would be appreciated.

same problem here, lets wait for an answer :)

:busted_co

ok, check these problems.....

portforward there prots too...
443
80

then go INTO your SQL database, go to realmd_bc (or whatever u named it) and go to the queary n select "realmlist" n browse that, make sure the IP for the relam is the same as your static IP (no-ip or whatever u got).

TURN OFF your router firewall & forward 443, 80, 3306, 3724,8085,3443, and 8080 in your firewall on your comp too

try that n tell me what happens, but my guess is its the extra port forwards

I don't think the error has anything to do with port forwarding. I'm also having the same issue. At first I figured it was that that was causing the problem. I have been playing on and off with it for nearly a week now. I have come to this conclusion because if you set everything completly through localhost and disable the firewall, internet included, you get the exact same problem. A network scan confirms all connections needed are there. I've also noticed that it's calling for odd ports that varies every time I select cancel.

on your port forwards, did u tell it to let a specific type though (TCP) or all?
because i got my server working fine

Thanks, I tried forwarding those ports, changing the ip to static in realmd and my dlink firewall was already disabled but as soon as i do that and try and log in myself it goes to where it says connected and hangs there. This is what it has been doing externally before.

and to answer your previous question on my port forwards i wasn't sure what to choose so i chose both to play it safe.

The only ports you needed to forward are 8085 and 3724. Those are the world and realm servers respectively. 8080 is your webpage. 3306 you should cancel the forward and firewall. Its the sql server that only MaNGOS needs to see... which is on the same PC. 443 has nothing to do with MaNGOS unless you have it configured to accept remote terminal requests... in which case I think he meant 3443... close it, you'll never use it. From what I hear you need to edit your hosts file if you're behind a router. I honestly don't know why. But that may fix your problem.

This should fix your problem (assuming port forwarding is already set up properly):

Remember when you edited the .CONF files? Realmd and Mangos?
1. Open realmd.conf in notepad.

2. Find the line that reads LoginDatabaseInfo = "(IP Address);3306;root;password;realmd"
Note: The things in the quotes might not match exactly, depending on what you named your realmd database.

3. Change the IP address to your external IP (should NOT be a 192.168. number).
Note: If you don't know how to find this, visit WhatsMyIp or WhatIsMyIPAddress to find out.

4. Save and close realmd.conf.

5. Open mangosd.conf in notepad.

6. Find the lines that read LoginDatabaseInfo=... and WorldDatabaseInfo=...

7. Change the IP in the first line (LoginDatabaseInfo) to the same external IP you used in realmd.conf (the one that's not a 192.168. IP address).

8. Change the IP in the second line (WorldDatabaseInfo) to "127.0.0.1".

9. Double-check that your passwords are correct and that your database names are right (LoginDatabaseInfo should have realmd at the end and WorldDatabaseInfo should have mangos at the end).
Note: Some people set up their database with the names realmd_bc and mangos_bc. Just use whichever name you have in your SQL database.

10. Save and close mangos.conf.

11. Restart your server and log in.


I hope that helps some of you.

No it dident, when i wrote in what what you said but with my ip number and then tryed to start up it said on the realmd:
2007-05-08 19:45:04 ERROR:Could not connect to MySQL database at 213.100.142.***: Host 'c213-100-142-***.swipnet.se' is not allowed to connect to this MySQL server

2007-05-08 19:45:04 ERROR:Cannot connect to database

and on the mangosd:
2007-05-08 19:47:08 ERROR:Could not connect to MySQL database at 213.100.142.***: Host 'c213-100-142-***.swipnet.se' is not allowed to connect to this MySQL server

2007-05-08 19:47:08 ERROR:Cannot connect to login database
213.100.142.***;3309;root;*****;realmd_bc

I have realy tried everything i can think of, could use some help plz...

oh and by the way it works fine with 127.0.0.1

If you just want to play locally, you can use 127.0.0.1 and it'll run just fine. That won't work if you're trying to have Internet connectivity on your server.

I'm writing a step-by-step guide with pictures on how to set up an Internet-ready MaNGOS server. Just give me a little time and I'll post it here once I've been able to test the instructions on a few computers.

Thanks that would be needed alot in here. I'm waiting eagerly for it.

MEGAUPLOAD - The leading online storage and file delivery service

Well I followed the tutorial to the letter and it actualy worked! Thanks man!

Oh one thing, I had some problems at the beginning like the realmd or mangos just closed down all the time. Then i went in to my router again and checked around some and found out that you could put your computer away from your firewall and i did it and bam it worked.

The option was called DMZ i think. So everyone out there that have gone thrue the tutorial and failed try get your router to disconnect you from the firewall and it should work ferfectly.

Thanks again and good luck.

Oh sorry for my bad spelling...

All right. I have figured out what my problem was and I suspect you guys are having the same problem. It had nothing to do with port forwarding as I suspected. In fact the error message ewolve is getting is pretty much the same error I was getting. The reason this occurs is Mangos is opening a remote connection to mysql. This is disabled by default in development servers. If you ran the binary, which I suspect a lot of you have, you have a development server. In order to grant access you need to run these commands on the console

Code:

---


GRANT ALL PRIVILEGES ON *.* TO USERNAME@IP IDENTIFIED BY "PASSWORD";

FLUSH PRIVILEGES;

---

Make sure to modify the command to your server. Restart mysql and everything should work assuming you are forwarding properly.

HI guys!
i got problem here,I wan to make my server Online and all other player can login to my server,ok im doing is that right?:

Quote:

---

MySQL/SQLyog:
address:[MyNo-IP address]
dbinfo:[MyNo-IP address];3306;root;[MySQLpassword];realmd

realmd:-
LoginDatabaseInfo = "127.0.0.1;3306;root;[MySQLpassword];realmd"
mangosd:-
LoginDatabaseInfo = "127.0.0.1;3306;root;[MySQLpassword];realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;[MySQLpassword];mangos"

---

i use SQLyog and MySQL.
Thanks you

n;a