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

Please check the new version on how to create wow private server for better version. Besides the new guide list everything in a single page for easier reading

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

  1. The First part is all about Installing and Configuring MySQL on your Windows Machine
  2. The Second part is about Configuring the WoW Mangos itself
  3. The Third part is all about Setting up Private WOW Server for Lan Party
  4. 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 :

  1. Working Mangos installation (really important)
  2. 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 :

  1. Change the realmd.realmlist (realmlist table in realmd database) into your lan ip address or public ip address
  2. Set the realmlist.wtf to use that lan ip address
  3. 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 :

  1. Open command prompt window or you can also use the same command prompt window from before
  2. 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 :

  1. You need to use your public ip address instead of your lan ip address (you can see your public ip by visiting whatismyip.com)
  2. 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)
  3. 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 ;)

Comment?

Note: Comment may not appear right away.

563 comments on “Creating Public Server for LAN Party – Setting up Private WoW Server

  1. Murk, you have proved my point then. If you turned off your firewall then you have placed your PC in the DMZ (de-militarized zone) where none of the ports are blocked from the outside internet. The problem with doing this is it opens up your PC to hackers. However, you have proved my point in that there is at least ONE additional port, if not more than one, that is being missed here and needs to be PROPERLY port forwarded from the router for this to work from outside. I wish someone would ACCURATELY POST ALL OF THE PORTS that need to be rerouted. Can someone please shed some light on this?

  2. I got mine working. Had to shut down my firewall, Windows Firewall, and share the C:\WOW folder over my network… I don’t know which of those 3 was the key, but it worked.

  3. I am having the same problem. I have port forwarding setup properly for both ports from the router and I have updated the realm information to reflect the DNS entry I created for it with my domain. When I try to login from an outside internet connection it lets me in but then when it gets to the realm screen I cannot login to the realm. It just times out and comes right back to the realm selection screen. I know that I am missing something stupid, but I have read through TONS of threads out on the net and have not found ONE thread documenting how to solve this problem. I am a network engineer, so I know that I have everything setup exactly as you have told us to do it, so what am I missing? I am ready to throw this out in the DMZ to see if that fixes it – perhaps there is another port that needs to be redirected??? Please advise. Thanks!

  4. also, does anyone know where I can find a good list of GM commands, alot of the lists are incomplete, and provide no information as to what the commands actually do.

    Basically I need to know how to change skill levels, add skills, add reputation, etc… if there’s a way to just do that in the database that would be awesome too. Thanks.

  5. Not sure what im doing wrong, already have mangos and such set up, can get into the game myself fine, but when im trying to set up the lan ip, i cant get into it. whenever i put in “mysql -u root -p” into the command prompt, it just says that its not recognized as a command or file, and wont run the command.

    Im sure what im doing wrong is really basic and simple, but cant figure it out…

  6. sorry, to add to what I said earlier, I have the DNS set up right on my computer and my friends on the LAN. Also I tried what Joe said and that didn’t fix anything. It has their account created and everything, just won’t let them chose the realm that pops up. Thanks.

    1. I have the exakt same problem… latest mango, db and everything… playing on LAN works fine… virtual server thru router does not

  7. Having a problem when my friends try to log on. They can log into the server, but cannot get past the realm selection screen. I’m not sure if it’s a problem with my mangos or with some security setting or what. I can log on fine, but they can’t. Anyone’s help would be greatly appreciated. Thanks.

  8. Hi.

    Can someone give me a link where I can download the latest mangos server that supports WoW classic ver 2.1.3, but that doesn’t require Megaupload or me to download a .torrent file?

    Thanks for the help :-)

  9. I can login, create accounts play and everything works great. However like other people I am unable to connect with other computers on my own lan. It will connect and I can choose the realm. Then it says logging in to game server and then goes back to choosing a realm. It wont connect. I have done this several times with the same results. Anyone figured it out yet.

    Thanks,
    Jeff

    1. K I got mine to work now.
      You need to change your realmlist IP for your server into your computer’s IP (it can’t be localhost which mine was defaulted to) just like Reaper-X said. But in the example he used a weird way to change it that I didn’t understand cuz I don’t know anything about this stuff.

      Anyways I used SQLyog to connect to the database and did this:
      1 expand “realmd”
      2 highlight “realmlist”
      3 select “View Data” from the “Table” menu
      4 enter your computer’s IP into the address field 5 click the save button.
      6 Exit out and restart the database
      and now my friend can connect to my LAN server.
      PS there was another ID in there called (NULL) and I just left that alone. It still has 127.0.0.1 for that one on mine but it works so I’m not gonna touch it.

  10. i have same problem as you 2 above,
    I hosted it from this computer and i can log in fine, then when i tried from other computers in lan ( got 10 of them) its ask me to choose realm list and when i klick ok it ask me again and again.. basicly stucked there

  11. I have the same problem – all running well on a windoze machine. Can play on that, but when I connect from another machine, I get the realms list and that’s it…cannot get any further either

  12. hello i am on lan with a couple of mates ive got trouble setting it up so my friends can come in

    it says “logging in to game server” and is just stuck there
    i can come in there wihtout trouble can any1 help thanks

  13. . . . nevermind my last post. i found Reaper’s own instructions on how to change the servername:

    You can change it from the dabatase using this command :

    1. mysql -u root -p
    2. use realmd
    3. update `realmlist` set `name` = ‘My Server’ where `id` = 1;
    4. quit

  14. ok so what do i do if i just want the server too my self and dont want too set it up for LAN do i need too do the last 2 steps or after the first 2 can i use it im in the middle of extracting the thing with ad.exe
    thx

  15. my realm is called “ReaperX”. i’ve been searching the config files in Mangos to see where i can change the name of the server, but to no avail.

    Anybody know where it’s located?

  16. Nevermind!

    Benz posted the solution before I was done writing my issue.

    The ‘community’ version does in fact use the same syntax as the one used in this demo, for anyone referring to these comments.

    sjc

  17. Hey,
    using ‘My SQL’ my server version is ‘5.0.45-community-nt’.

    My issue is that this version does not seem to follow the same syntax as the one used in this guide. I’m wondering if anyone could give me suggestions as to the correct syntax for the version I am using (see above).

    Perhaps it’s better if I find a copy of the version used in the guide?

    thanks,
    sjc

  18. nevermind, here it is:

    update `realmlist` set `address` = ‘(your ip address)’ where `id` =1;

    the ip address is in single quotes, and everything else is in that “`” character that shares the button with the tilde key (next to the number key “1”)

  19. i’m having trouble reading what you have to type after UPDATE “realmlist” SET etc, etc, etc. . . . i can’t tell if those are apostrophe’s, or quotations, or what. the image is kinda blurred. can you post it out?

  20. First, WOW!! Thanks so much for the guide! It has been so clear to this point and I am up and running with the server and playing on the same computer. I am haveing just a bit of trouble on this step so I can set up the LAN to play with friends at the house. I just cant seem to read the image you have posted above. I cant tell if it has = (equals) or – (dashes) I cant tell where there are ‘ (apostrophies) or ` (tildes) Can you give me a hand?

  21. Umm when i tried
    mysql> Use realmd
    Database changed
    mysql> Update and i dont get this part what do do to thesE?

  22. Dear Reaper-x, i wish to hack an online multiplayer game, i was hoping you could do it for me for free of charge. Kind regards, Jake (Please reply)

  23. your welcome pan :)

    btw there are several possibilities for that error message :

    – you havent set up mangos
    – you use different database name for the mangos realmd

    1. Reaper-X You simply forgot to circle the “use realmd” command in your image file. That’s why peeps are getting Error 1046, and unknown database commands. Simple fix.

      So, peeps it goes like this:

      mysql -u -root -p [enter]
      use realmd [enter]
      UPDATE `reamlist` SET `address` = ‘192.168.3.3’ WHERE `id` =1;

      Just change 192.168.3.3 to your lan ip address. Enjoy! And Thanks Reaper-X, very nicely done guide. =)

    2. Oops…slight syntax correction and clarification:

      mysql -u -root -p [enter]
      use realmd [enter]
      UPDATE `reamlist` SET `address` = ‘192.168.3.3′ WHERE `id` =1;[enter]

      ` is on your tilde key, ‘ is your quote key. They do matter so use proper systax. =)

  24. thnx for sharing but how do u do it?because for the cmd thing right,i have the the ipconfig but i dont know how to do the realmd it says unnown database ‘realmd’
    what should i do??