Creating Public Server for LAN Party – Setting up Private WoW Server

This is the old guide, please read the new guide on how to create public world of warcraft server instead

This is the third part of the Creating your own World of Warcraft Server using Mangos

The First part is all about Installing and Configuring MySQL on your Windows Machine
The Second part is about Configuring the WoW Mangos itself
The Third part is all about Setting up Private WOW Server for Lan Party
The Fourth part is all about Installing and Setting up Apache Webserver with PHP

Okay … after taking a break for few days now i’m going to continue with the complete mangos configuration guide. And in this topic i’m going to tell you how to create public server … erm … i mean private server for lan party purpose (if you intend to create public server using mangos, that means you’re violating the mangos license agreement)

and to make thing shorter … let’s start the guide ;)

Requirements :

Working Mangos installation (really important)
Knowledge on how to set up port forwarding from your router and your firewall software if installed, because each router have different configuration page (required if you’re going to host WoW Server behind router)

Note :

In this example the wow server process is located at virtual machine using 192.168.3.3 as the LAN IP Address
Im connecting from another virtual machine to that ip address
Mangos and realmd process must not be started first
This process can be used for both WoW Mangos TBC Server or Classic Server

Here’s the summary of the process on how you’re going to do it :

Change the realmd.realmlist (realmlist table in realmd database) into your lan ip address or public ip address
Set the realmlist.wtf to use that lan ip address
Optional : If you’re going to host your wow server behind the router then you’ll need to set up port forwarding for port 8085 (World Server) and 3724 (Realmd). But if you have firewall software installed on your computer then you’d need to configure your firewall to allow connection to that port

Setting up WoW Server for LAN / Local Area Network :

First of all you need to know what is your lan ip address, especially if you’re using DHCP to automatically assign your ip address, and to do this first you need to open the command prompt window

Start Menu => Run => Type CMD

then type ipconfig like example below :

Your lan ip address

From the above image you can see that the ip address used was 192.168.3.3 so you’ll need to set up your realmlist to use that ip address so here’s how to use it :

Open command prompt window or you can also use the same command prompt window from before
type below command (image) :

Adjust it to your lan ip address

Note : Don’t forget to adjust the 192.168.3.3 to use your lan ip address because i’m sure your lan ip address is different

And now we need to make sure that it is get properly written into the database so here’s how to check it

Checking IP Address for WOW LAN

After done with the above process, now you just need to set your realmlist.wtf file in your WoW Game Directory (for example, C:\Program Files\World of Warcraft\realmlist.wtf) to use that ip address … and you’re done then the next step would be starting the mangos process and realmd process, and try connecting to your wow server from other computer in your network

Setting up for Internet / Accessible from anywhere :

Basically there are no actual differences between configuring wow to be accessible from LAN except :

You need to use your public ip address instead of your lan ip address (you can see your public ip by visiting whatismyip.com)
You need to configure your router to forward port 3724 and 8085 (and no don’t forward the port used by MySQL, because previously someone port forward the mysql port too)
If you use firewall, allow connection to your computer on port 3724 and 8085 too

Note : If you’re having problem on port forwarding / do not understand how port forwarding works, then i suggest you to visit this page

But what if you ran the realmd and mangos server on the same computer and you’re trying to connect to it (connect to the same computer where mangos and realmd process started) ? and yes i’m sure you want to play using this method if you only have 1 computer in your home like me

Then you need to follow this step :

Look at your public ip from whatismyip.com and make a note of your public ip address

Your public IP Address

Sign up with Dynamic DNS service such as No-Ip.com , Dyndns.com or sitelutions.com and set up your desired dns name to your public ip address
Use the newly created DNS name as the address for realmd.realmlist instead of your public ip address (using the same sql command on example above)
Look at your lan ip address using the above example
Open C:\Windows\System32\Drivers\etc\hosts using notepad or your favorite text editor
add new lines using below format at the bottom of the hosts file

your-lan-ip-address your-newly-created-dns-name

save it
adjust the realmlist.wtf to use your newly created dns name
set up port forwarding
and you’re done :)

Please note, only invite trusted people to your wow server (for example your friends only) and do not attempt to create real public server unless you really know what you’re doing ;)

Well … that’s all about it … and at this time you should be able to get your friends to play on your server … unfortunately you still need to add your friends account manually which is not good for LAN Party Server

So for the next part i’m going to tell you how to set up webserver with php on your computer so your friends can register account easily ;)

Comments Navigation « Previous 1 2 3 4 ... 11 Next »

exo7 said Oct 5, 2007 at 9:30 am

i have problem with wow pravite server my friend set up server i enter his server it fine but i stuck on realm list then i click enter realm it said ” logging in server ” then back realm list “repeat” mean some program or something prevent can enter game ? does anyone know how to fix it ?

thanks :)

Link to this comment Reply to this comment
Mike said Oct 5, 2007 at 8:40 am

Hey, I have fixed up my other issues with mangos, but now I have the problem where my exp rate wont change. In mangosd.conf I have changed the kill exp rate to 7, but that didn’t change anything in the game. I tried using ‘reaper-x-mangos’ to change the exp rate to 7, but that didn’t work either. Also now when people are connected to my server I get a SESSION: received unhandled opcode SMSG_UNKIWN_978 <0×03D2).

Can you please tell what does all that error means and how I can firstly change my exp rate (i want it to be a high rate) and secondly change the item drop rate.
Thanks

Link to this comment Reply to this comment
InfernoX said Oct 5, 2007 at 3:07 am

How can I use that DMZ? (yes, i am a noob)
Please answer me how to use it..

Link to this comment Reply to this comment
InfernoX said Oct 5, 2007 at 3:04 am

Damn.. I cant forward ports because I cant setup a static ip address.. And because of that, I cant play with my friend DX

Link to this comment Reply to this comment
ExoriaX said Oct 2, 2007 at 11:41 pm

Forget to add, i searched in my computer and found the following:

realmlist.wtf
realmlist.frm
realmlist.MYD
realmlist.MYI

Which am i suppose to edit and what program should i open with it? frm, myd, and myi seems to be messed up in notepad but i can see “127.0.0.1″ in some of them. I dont think it would be good idea to edit them in notepad where they look messed up. If u think i could edit in notepad then i will try.

Link to this comment Reply to this comment
ExoriaX said Oct 2, 2007 at 11:26 pm

realmlist? did u mean realmlist.wtf?

set realmlist [wan ip]?

Link to this comment Reply to this comment
BUG said Oct 2, 2007 at 11:21 pm

I think it isn’t working anymore, after the last patch, it says: corrupt file…

Link to this comment Reply to this comment
Reaper-X said Oct 2, 2007 at 9:53 pm

# ExoriaX

Have you configure the realmlist to use your public ip address instead of your local ip address?

Link to this comment Reply to this comment
ExoriaX said Oct 2, 2007 at 4:50 pm

I am having problem with my friend entering my server. Kept stuck on the realm list, he said he tried to get in but it kept taking him back to realm list.

I have forwarded ports listed here:

3306, 8085, 3724, 1400, 1401, and 80.

Still having the same problem. I even tried DMZ on the computer where wow server is on. Still having the same problem. I am guessing that there isn’t any problem with ports. There is something that prevent someone from entering my wow server. I use Hamachi with the friend.

I have Norton Anti-Virus with small internet software, i have disabled it with DMZ on, still not work.

What else can I do?

Link to this comment Reply to this comment
Reaper-X said Oct 2, 2007 at 3:12 am

Everyone try looking at my new post first to answer your questions :)

Link to this comment Reply to this comment
kris said Oct 2, 2007 at 1:36 am

this does not really help the ppl that want to make a server just for L.A.N’s… because most of us r not able to do half the stuff on SQL… we r only in school man. i just want to make a TBC server for my friens when we lan but cant even get that right with this GREAT GUIDE… i have done all u have said but still nothing has worked really… well it worked but stops working when i get to the next step… i might not b the brightest computer guy but i can not do this wit this guide… dont get me wrong its good… just not user friendly for ppl that r not good wit computer programs like SQL… its very higher grade stuff for school going kids.

Thanks anyway man hope to hear from u soon.

kris@bpst.co.za

Kris:)

Link to this comment Reply to this comment
Sykohtyk said Oct 1, 2007 at 9:16 pm

another one from me, i’ve now gotten the server going, and set everyhting up per instuction, but i can’t seem to log in, from my pc, or from another on the lan, any ideas?? all i get in wow, is the unable to connect message

thanks

Link to this comment Reply to this comment
Ritsuko said Oct 1, 2007 at 1:43 pm

Reaper–

Firstly, thank you so much for everything. ^_^ This has opened many doors that perhaps shouldn’t have been opened for me, as I am going to lose alot of sleep over this! ^.~

But to my problem: Whenever I go to change the name of my server in MySQL, I enter in the command line:

update `realmlist` set `name` = ‘My Server’ where `id` = 1;

And then I just get a blank command prompt, perhaps with a little ‘`’ in front of it– that is to say, not a normal command prompt. Whenever I type in ‘quit’ or ‘exit’, it just sits there, not doing anything. Kind of like when you’d press ‘escape’ on those old DOS machines? You’d get a funny, blank command prompt and nothing would happen.

Anyway, thoughts, insights? ^^ Everything works as you said it would… except this. ^^;

Link to this comment Reply to this comment
AC said Oct 1, 2007 at 9:12 am

is it absoutly necessary to have a router to share your server?

Link to this comment Reply to this comment
kwamezs said Oct 1, 2007 at 5:10 am

Hey great guide my server is set up and everything. BUt my brother and i are shareing the same internet connection through a router and i set up everything like you told me but everytime he tries to log into my server from his machine it tells him unable to validate game version. i went into realmd and it shows his ip and accepts it so i dont know why he cant connect to my server.

Link to this comment Reply to this comment
Reaper-X said Sep 29, 2007 at 6:48 am

# Prowler

Check the new image directly below the update process :)

Link to this comment Reply to this comment
c-bass said Sep 29, 2007 at 6:30 am

thnx, i got mangos downloaded. 1 more question- will this support the latest version of WoW (v2.2.0)? if not, which version should i have?

Link to this comment Reply to this comment
Justin said Sep 29, 2007 at 5:05 am

I try and do the MySQL path thing and it says this

Where is your MySQL BIN path ?
(for example C:\Program Files\MySQL\MySQL Server 5.0\bin)

C:/Program Files/MySQL/MySQL Server 5.0/bin
– Connecting to localhost…
mysqldump: Got error: 1045: Access denied for user ‘mangos’@'localhost’ (using p
assword: YES) when trying to connect
– Connecting to localhost…
mysqldump: Got error: 1045: Access denied for user ‘mangos’@'localhost’ (using p
assword: YES) when trying to connect
Bye

Link to this comment Reply to this comment
Prowler said Sep 28, 2007 at 11:45 pm

If it should be…then its not. But i ve typed in all the commands you ve wrote here :S

Link to this comment Reply to this comment
Prowler said Sep 28, 2007 at 11:41 pm

so that IP there should be my IP ?

Link to this comment Reply to this comment
Reaper-X said Sep 28, 2007 at 11:28 pm

to make sure you’ve changed the realmlist table correctly, see below link for an example

http://img216.imageshack.us/my.php?image=testmz4.jpg

Link to this comment Reply to this comment
Prowler said Sep 28, 2007 at 11:17 pm

http://img406.imageshack.us/img406/8716/65429936qj2.jpg

[img]http://img406.imageshack.us/img406/8716/65429936qj2.jpg[/img]

Should it be like this? There are no rows changed or anything

Link to this comment Reply to this comment
Prowler said Sep 28, 2007 at 11:10 pm

no matter what i try..doesnt work

Link to this comment Reply to this comment
Reaper-X said Sep 28, 2007 at 6:59 pm

# c-bass

Look at the right sidebar for the recent post and click on Mangos 4505 :P

# Xermi

ah you need to execute the sql command first (see the image above the whatismyip.com image) for an example

but dont forget to use your lan ip address instead of the example shown on this page

Link to this comment Reply to this comment
XeRmi said Sep 28, 2007 at 4:31 am

Hey great tutorial … i made a server with reaper-mangos-R4488-full package and done everything and it works great only if u can explain me how to make it public… i dont have a router because i dont play in LAN i wanna play over internet … i puted my IP adress in realmlist.wtf. Everything is up, mangosd, realmd … when i try to connect from other pc nothing … could not connect … what should i do? THANKS

Link to this comment Reply to this comment
c-bass said Sep 28, 2007 at 2:32 am

Where are all of you downloading Mangos from? I can’t seem to find a legit copy.

Link to this comment Reply to this comment
Reaper-X said Sep 27, 2007 at 12:53 am

# Neo

Sorry for late reply, i didn’t saw your comment

as for your question, have you set up port forwarding so that others can connect to your server ?

# Angel

Well .. i havent tried Hamachi (or other VPN) yet and the reason is, if i already open the ports on my computer and let other connect to it, there’s no need for me to use VPN (Hamachi), right ? ;P

# Ozzy

Look at the example image above the whatismyip image, that’s what you should type to update the realmlist ip address

Link to this comment Reply to this comment
Ozzy said Sep 26, 2007 at 11:40 pm

Change the realmd.realmlist (realmlist table in realmd database) into your lan ip address or public ip address I DONT UNDERSTAND WHAT TO CHANGE AND WHERE plss help

Link to this comment Reply to this comment
angel said Sep 24, 2007 at 1:02 am

hi all… i still haven’t tried it but i first wanned to ask … can a friend connect to my server trough Hamachi ?! The program creates some sort of lan connection between people … i don’t know what router is but from everything i read i think it’s being used for real lan connections or somepthing … so i just wanned to ask if my friends can connect trough Hamachi

Link to this comment Reply to this comment
Neo said Sep 23, 2007 at 9:21 pm

oh and i can connect, but just my friends cant

Link to this comment Reply to this comment
Neo said Sep 23, 2007 at 9:16 pm

Hey,
I’ve done all but still my friends cant connect
i made one at no-ip.
i did that use realmd and then neofx.no-ip.biz
changed realmlist to neofx.no-ip.biz
and in hosts
# 192.168.1.101 neofx.no-ip.biz

still my friends cant connect.. what to do?

Link to this comment Reply to this comment
TBSKira said Sep 22, 2007 at 8:24 pm

zeke…where do i change that stuff…

Link to this comment Reply to this comment
TBSKira said Sep 22, 2007 at 8:10 pm

im having trouble with the realm loop thing. i click okay to join it says unable to join realm…or something like that and goes back t o the realm list.

Link to this comment Reply to this comment
zeke said Sep 22, 2007 at 8:10 am

for all of you having the realm loop or being unable to change the “update `realmlist` set `name` = ‘My Server’ where `id` = 1;”

you have to use the ` button above the tab key for
`realmlist` and `name` and `id` but you use two apostrophes for ‘My Server’. hope this helps you all like it helped me after seeing your posts.

Link to this comment Reply to this comment
Reaper-X said Sep 21, 2007 at 6:57 am

Thanks you very much for your kind words :)

as a side note, i just released my own compiled mangos again and this time it’s using rev 4488 ;)

Link to this comment Reply to this comment
darkbaxter said Sep 21, 2007 at 12:02 am

Hey pal, EXCELLENT guide – i was getting mad trying to find the way to set server and play on 1 computer…

With this guide, it was piece of cake.

THANX!!!

Link to this comment Reply to this comment
John said Sep 17, 2007 at 11:45 pm

if you guys need help, like right away, add Kain@xierchien.com to your MSN, I’m happy to give ya a hand

Link to this comment Reply to this comment
plz help or mail :) said Sep 16, 2007 at 8:38 pm

i got sqlyog now, but i can’t expand realmd like said aboven, how should i do that?

Link to this comment Reply to this comment
alex said Sep 14, 2007 at 7:09 am

hey guys I am getting the same problem as well . i get to logging in to server , i try to choose the server , but the massage keeps poping up and i can’t login , can any one assist please?

Link to this comment Reply to this comment
Oscar said Sep 12, 2007 at 3:12 am

sorry to bother again still having issues can you add me on MSN or ICQ at pete_charlton@hotmail.com

Link to this comment Reply to this comment
Reaper-X said Sep 11, 2007 at 1:15 pm

# Tobbe

Try go to portforwarding.com to see how to forward port

# Oscar

Did you setup port forwarding after updating your realmlist ip address ? because if you’re behind router you’ll need to setup port forwarding so others can connect to your computer

as for Realmd.cmd … im sure every mangos release is different (some are good while some other are not quite good because they’re using Debug Information, etc), for example my own release doesn’t include that batch file :)

# Dylan

Well actually you can use any 3rd party mysql client :) … but as a side note, the mysql command really working as long as you didn’t copy paste the command directly :)

Link to this comment Reply to this comment
dylan said Sep 11, 2007 at 12:39 pm

i use SQLyog its awsoem i got my server up with this mysql didnt work for me >.>

Link to this comment Reply to this comment
Oscar said Sep 11, 2007 at 5:13 am

ok this is working great for me but i have a friends over alot for lans and stuff and im just really stuck on how to get ti too connect to toher PCs bar mine done everything you have said (i think) read all the ost tried every solton and same thing, it just wont connect people can see the server but not log in either getting looped on the Realm screen or not being able to connect at all,

Problem A : when i do the UPDATE `realmlist` ………. at the the end it just turns into a “->” not giving me the nice answer i want to see How to fix this.

Problem B : the Realmd.cmd dose run gives me error messages like.. you “Pc name” can not connect to that mysql or Could not connect to the mysql database “at ip adress”

and heres some help to one of the above post if you use the .command in game you will bring up all the avaliable GM command.

well please reply and hope to hear from you soon ty for any help i get.

Link to this comment Reply to this comment
punkybrewer said Sep 10, 2007 at 5:36 am

ok so how do we import that file? And im not sure on how to setup my mangos download. :D pls help

Link to this comment Reply to this comment
Tobbe said Sep 9, 2007 at 8:49 pm

Hi, got the same problem as everyone else, maybe it is the portforwarding, but i cant understand how to do it:S please someone help me!

Link to this comment Reply to this comment
Reaper-X said Sep 8, 2007 at 9:25 pm

You can try using Dynamic DNS service from sitelutions.com, no-ip.org, etc

Link to this comment Reply to this comment
JuiceBoy said Sep 8, 2007 at 5:21 pm

Dude… I`ve got a little problem, maybe you, or any passing reader cand help me out… I`ve got a variable IP Address, and i`m kinda getting nerves of always changing the configs… can you help me out ?

Link to this comment Reply to this comment
Olen said Sep 2, 2007 at 7:15 am

Hey Reaper X,
K I am getting the 1049 error and you said it’s just cause I haven’t imported the create.sql file or whatever, but I don’t know how to import it.. can you help me out? I don’t know where to go from here

Link to this comment Reply to this comment
- Reaper-X said Sep 2, 2007 at 3:29 pm
  
  you can see how to import it from the part 2 of this guide :)
  
  Link to this comment
Assassin901 said Sep 1, 2007 at 9:40 am

ok so hear is the story… my friend made a private server and it works until the realm selection and about the same problem as almost every1 else it wont continue. if possible could u plz help me? tyvm in advance =D

Link to this comment Reply to this comment
Reck said Sep 1, 2007 at 6:48 am

I have the same problem as most, no others can connect, they tell me it stays stuck at the connecting screen. Any help seeming as though there are many people with this problem? I triple checked and quadruple checked all my settings and their all exactly to your guide, but still noone other than me can connect to it. I’m using dyndns and am behind a router, no firewall, all required ports forwarded.

BTW, your guide is the bomb diggity yo! lol.

Link to this comment Reply to this comment