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
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 :
Note :
Here’s the summary of the process on how you’re going to do it :
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 :

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 :

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

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 :
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 :

your-lan-ip-address your-newly-created-dns-name
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 ;)
Leave a response
Really thanks a lot for this guide, it really helped me a lot. With some more trial and error I finally got my server to be accesible from internet. Again thanks for this awesome guide.
Regards,
Most people don’t realise until it’s too late that 7 out of 10 Xboxes develop serious faults including the 3 light ‘red ring of death’, E74, freezing and much more. We offer a 1 hour fix alternative as opposed to a 6 – 12 week wait if you use a reair center
set realmlist logon.wowgraid.net
I know this post is old, but I have spent the better part of a work day trying to figure out the nature of the realm loop… Your solution worked like a charm! Thank you, thank you, thank you!
as the message says, you are gay. go away and do us all a favor by earning a darwin award. Kind Regards.
Hello,
Thank you SO MUCH for creating these guides, they have helped me immensely.
I have come across a problem that refuses to go away. I’m trying to make my private server public and I continually reach failure.
My DNS address is thenunsofvoarcraft.dyndns.tv
I have edited the realmlist table in the realmd database to reflect this.
I have edited the hosts file to say the following:
192.168.1.205 thenunsofvoarcraft.dyndns.tv
I have ports 3724 and 8085 forwarded on my router.
My realmlist.wtf file reads “set realmlist thenunsofvoarcraft.dyndns.tv”
And no matter what I do, I get the same error message: “Unable to connect to realm list server”.
I have tried changing IP addresses in the Hosts file. I have tried putting my router in DMZ. Nothing has worked. I have reviewed these guides, among other guides, time and time again and I’m continually met with failure.
What exactly am I doing wrong?
Omg i am at my wits end with this i am trying to set up a LAN server using my IP address i have used what you have said to do and have tried to log on to WoW on another CPU on the network it says cannot Validate game version plz check the sit blah blah blah once the realm is up and running how do i get into that through WoW??
Hey, just browsing thrue the comments, and found that there are a lot of questions regarding the use of the MySQL CLI.
When using it, note the following:
Every statement MUST be closed with a ‘;’ or else it’ll just start a new line for the same statement.
You don’t have to enclose a table or fieldname within the database with a ‘. You should, however, use it when entering strings, or words / phrases as variable to store.
Also, regarding the connectivity problems, read up on the basic principles of network addressing and possibly even WINS or DNS. This should resolve a lot of problems.
Personally I make full use of the DNS server in my router because it enables me to tinker with the LAN with LAN-Parties and testing computers. I use the NetBIOS name of my server computer instead of an IP address. This means I can plug the server in a different routerport without the hassle of reconfiguring Mangos or the router.
Hope that helped
I know problem is in hosts – 127.0.0.1 myservername.ath.cx, but if I change it(127.0.0.1) to my IP, I can’t connect.. And other ppl too… Whats the problem may be? I allready learned from a-z that portforward.com, but he says I gonna choose my router’s model, but I don’t have it… 2 weeks lookin in anykinds of mangos guides and still nothing, cuz everywhere “router, router, router”…
… Dunno what going on. In first, I downloaded Mangos repack, MySQL, Navicat… Created everything what I need in Dyndns.com, typed in hosts (!) 127.0.0.1 myservername.ath.cx (why 127.0.0.1 instead of my lan ip? cuz otherwise I can’t connect in all). typed in CMD everything what is needed (UPDATE `realmlist` ….. to my lan IP), typed my dynds name in realmd.realmlist(tryed instead of that with my lan ip), opened ports in Firewall, typed address in realmlist.wtf, SO I can connect, everything is REALY fine, exept that, like no1 can connect to me. Letts get back to Hosts… If I type my lan IP instead of 127.0.0.1 I get “Unnable to connect”. Still, no1 can connect to me. Portforwarding? Answer – I’m using LAN/Local Area Connection and when type my IP into i-net browser, nothing going to happen… COULD YOU PLEASE help me, answering step by step what to do? Cuz I’m not verry well in those things… btw, sry for my english, I’m far away from your country :) Thank You Very Much!
@ryno
what type of router are you using atm?
Hey Guys, I have a good knowledge of port forwarding and such, even when I tried to do a port range on a D’link router (which doesnt have the option to port range)
But my problem is, I can connect to my server perfectly
People outside my network can connect to my server perfectly
People OTHER than me INSIDE my network, like my brother, cannot connect to my “No-Ip or Dyndns” address, but when I put my internal IP inside the realmlist.wtf file on my brothers computer, It gets as far as connecting to realm, then it just basically timesout on “Connecting”
I need some help to make sure my brother can connect to my server too.
Thanks
are you talking via Xover cable?
lol, just figured it out a sec after posting here
anyways here’s the solution to those who get stuck on that one — you must use the ‘ marks and not the ` marks around the ip address…
i’m getting the ERROR 1054 (42S22): Unkown column ‘192.168.1.100′ in the ‘field list’ when entering:
update `realmlist` set `address` = `192.168.1.100` where `id` =1;
haven’t seen the solution here yet.. so any help?
Okay now ive corrected it but it says it cant validate game version. how do i work around that?
It works fine till I try to change the IP I ger
ERROE 1064 : you have an error in your sql syntax; cheack the manual that corresponds to your mysql server version for the right syntax to use.
I’m useing the most up to date versions/ OS=Windows
upitqh zvie jreicokd wdvh tyig vsbkmio ojmzgn
PLEASE HELP!!!!!!! 3 dayz in to this……mind….going…..slowly but surely……becoming insane!!!!! I have followed every step….5…6…7…hell probably 10 times a day…… I can log on with ease! but my lil bro in the other room on the same network gets stuck at..connecting..WE CAN’T FIGURE OUT WHY!!!! someone please help before i throw my computer in the POOL!