First of all I want to admit that my english is not perfect (but who cares perfect is only a word).
-------------------------------------------------------------------------------------------------------
Now lets quit the crying about my english and get to the point.
You guys want to know how to run a LAN or/and WAN Server.
Now let me first explain the basics to those who are not fimilair with ICT.
1. Facts:
=LAN means Local Area Network indicating that its inside your home or company.
LANs have ip ranges like:
10.0.0.x CLASS A
192.168.0.x CLASS C
these classes just indicate how large your LAN can be, class A for instance can have more computers plugged into it then a CLASS B or C.
A LAN is mostly protected by a router firewall, a router also splits your WAN address into LAN addresses like I showed above (the one with the ranges).
=WAN means Wide Area Network and is mostly pointed to the internet since its spread all across the globe. Everyone connected to the internet has a unique ip address which you can see here: http://www.ip-adress.com/. Some have dynamic others have static address. Now you can only host a WoW Server when you have a static WAN IP address because when its dynamic it changes time to time and information must be altered everytime it does.
2. Setting up a LAN Server (non-wan).
You have everything ready, like the WoW maps imported to the server map, mysql server running with the sql tables imported.
Check points for the server dir.:
Maps: Crash Logs, dbc, maps and sql.
Needed exes: restarter.exe, ad.exe, mangosd.exe and realmd.exe
CONF files: mangosd.conf, realmd.conf and restart.conf
Check points for the mysql server:
Databases: mangos and realmd (sometimes mangos_bc and realmd_bc)
If all is there then lets get started.
I first want you to take a look at the CONF files in your Server dir.
Mangosd.conf:
there are 2 lines which are really important:
LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;[password];mangos"
Now when you run a LAN server you only need to look at the ip address: 127.0.0.1.
This number indicates that your mysql server is running a the local computer.
You can also have you mysql server somewhere else in your network, although this is not recommended since there is a network connection between the two computers and this takes more time.
If you do have a mysql server on an other computer, just search for it LAN address: Start>Run>cmd>ipconfig (search for the line IP-Address).
Then your config will look like the following(using a class C example address):
LoginDatabaseInfo = "192.168.25.25;3306;root;[password];realmd"
WorldDatabaseInfo = "192.168.25.25;3306;root;[password];mangos"
Realmd.conf:
there is one line which is important in this file:
LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
As you've read above the ip address 127.0.0.1 indicates that the mysql server is located on the server you have the server dir. on.
If you have mysql server running somewhere else your conf files will be like this:
LoginDatabaseInfo = "192.168.25.25;3306;root;[password];realmd"
Mysql Database changes:
Open your application you use to changes table information within your mysql database, for instance I use: SQLyog.
Then goto the realmd database and then to the table "Realmlist".
You will see the following:
ID: 1 NAME: [your server name] ADDRESS: 127.0.0.1 PORT: 8085 ICON: 1 COLOR: 0 TIMEZONE: 1
Change your NAME: to whatever you like and change the ADDRESS: to the computer ip address on which the server runs like: 192.168.25.25. If you keep it on the 127.0.0.1 address realmlist loops will occur.
Now start your server: Restarter.exe or the two files realmd.exe and mangosd.exe.
start playing:
goto the computer you are playing wow on and backup the realmlist.wtf (if you are playing official or other stuff). Then open the realmlist.wtf with notepad, you should probably see something like the following:
set realmlist eu.logon.worldofwarcraft.com
set patchlist eu.version.worldofwarcraft.com
make it look like this:
set realmlist 192.168.25.25
set patchlist eu.version.worldofwarcraft.com
you can leave the patchlist alone since your server wont request a patch from that line.
3. Setting up a WAN Server (both LAN and WAN).
You have learned much about both LAN and WAN.
Now iam only going to show you how to make things work smooth and not going further into the educational part of ICT. HINT: GOTO SCHOOL!
In lan I told you about internal ip addresses also known as LAN.
Now iam going to tell you about "external" ip addresses which is knwon as WAN.
You have everything ready, like the WoW maps imported to the server map, mysql server running with the sql tables imported.
Check points for the server dir.:
Maps: Crash Logs, dbc, maps and sql.
Needed exes: restarter.exe, ad.exe, mangosd.exe and realmd.exe
CONF files: mangosd.conf, realmd.conf and restart.conf
Check points for the mysql server:
Databases: mangos and realmd (sometimes mangos_bc and realmd_bc)
If all is there then lets get started.
I first want you to take a look at the CONF files in your Server dir.
Mangosd.conf:
there are 2 lines which are really important:
LoginDatabaseInfo = "127.0.0.1;3306;root;[password];realmd"
WorldDatabaseInfo = "127.0.0.1;3306;root;[password];mangos"
The only thing we need to change here is the 127.0.0.1 ip address.
You have learned that this is your localhost (server local address).
We need to change this into a DNS name which you can get everywhere.
The site I recommend you is: No-IP - Dynamic DNS, Static DNS for Your Dynamic IP.
sign up there and make a DNS name, your conf file will now look like this:
LoginDatabaseInfo = "name.noip.org;3306;root;[password];realmd"
WorldDatabaseInfo = "name.noip.org;3306;root;[password];mangos"
Realmd.conf:
just like the mangosd.conf you will only need to change the 127.0.0.1 ip address to your registered DNS name:
LoginDatabaseInfo = "name.noip.org;3306;root;[password];realmd"
Now this part is done you can move on to the next.
Hosts file of windows:
find the hosts file of your WoW server computer.
Use windows search to find the hosts file.
This file will translate names to an ip address for YOUR computer.
Note that changing this will only effect the computer where you changed it on, not the rest of the computers inside your network.
The file is located within the map: C:\WINDOWS\system32\drivers\etc (if you hate windows search).
The file looks as following:
127.0.0.1 localhost
add this line "UNDER" this localhost line:
127.0.0.1 name.noip.org
and then it must look like this:
127.0.0.1 localhost
127.0.0.1 name.noip.org
WARNING: Never change the localhost name! and seperate the ip address from the name with the TAB key else it will become unstable!
Now goto the computer on which you play wow and make the hosts file look like this:
127.0.0.1 localhost
192.168.25.25 name.noip.org
WARNING: Never change the localhost name! and seperate the ip address from the name with the TAB key else it will become unstable!
Mysql Database changes:
Open your application you use to changes table information within your mysql database, for instance I use: SQLyog.
Then goto the realmd database and then to the table "Realmlist".
You will see the following:
ID: 1 NAME: [your server name] ADDRESS: 127.0.0.1 PORT: 8085 ICON: 1 COLOR: 0 TIMEZONE: 1
Change your NAME: to whatever you like and change the ADDRESS: to the DNS name you have registered: name.noip.org. If you keep it on the 127.0.0.1 address realmlist loops will occur and your friends will not be able to connect to it!
Router configuration:
This is the most important part of my whole story.
I already talked about the router firewall.
Try to find your routers manual and look for NAT or Port Forwaring.
If you cannot find it, try to contact the routers manufacturer and ask him about how to publish port to the internet.
Now the following ports will need to be opened for both UDP and TCP:
3306, 8085 and 3724.
Mostly you have to fill in the LAN ip address for which the ports need to be opened.
I suggest you open all the three ports for: your server and for the mysql server not on the same computer as the wow server.
Now start your server: Restarter.exe or the two files realmd.exe and mangosd.exe located on your wow server.
Playing on your WAN and LAN server:
now I am going to explain how you and your friends can connect to your wow server.
goto the computer you are playing wow on and backup the realmlist.wtf (if you are playing official or other stuff). Then open the realmlist.wtf with notepad, you should probably see something like the following:
set realmlist eu.logon.worldofwarcraft.com
set patchlist eu.version.worldofwarcraft.com
make it look like this:
set realmlist name.noip.org
set patchlist eu.version.worldofwarcraft.com
your friends will need to do the same.
You will probably ask yourself why you can loggin with the same name as your friends, well its easy: you have changed your hosts file so the name.noip.org will be converted to 192.168.25.25 on which the server runs!
Your friends do NOT need to change the hosts file because then it will run to a dead end!
you can leave the patchlist alone since your server wont request a patch from that line.
Now start playing and have fun!
Reply With Quote![[Mangos][Guide] Running a LAN and WAN Server](http://ragezone.com/hyper728.png)
