Custom Search
Creating Public Server for LAN Party – Setting up Private WoW Server
Posted by Reaper-X Jul 3 2007 6:05 pm
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 :
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) :
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 :
- 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
- 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 ;)
Trackbacks/Pingbacks
- How to set up public WoW Server » Reaper-X .:[ ID ]:.
- Reaper Mangos 4875 - Easy WoW Private Server for WoW 2.3.0 » Reaper-X .:[ ID ]:.
- Reaper Mangos Mod 4651, Scriptdev2 151 AHBot with JailPatch and Unified Database » Reaper-X .:[ ID ]:.
- Reaper Mangos Mod 4703 - Easy Custom WoW Mangos Private Server » Reaper-X .:[ ID ]:.
- Reaper Mangos 4703 - Easy WoW Mangos Private Server » Reaper-X .:[ ID ]:.
- Mangos 4629, ScriptDev2 150 with Silvermoon 18.5 and UDB 0.8 323 support 2.2.3 » Reaper-X .:[ ID ]:.
- Mangos 4602, ScriptDev2 145 with Unified Database 0.7.5 CS319 work with WoW 2.1.3 to 2.2.3 » Reaper-X .:[ ID ]:.
- Mangos 4577, ScriptDev2 140 with PSDB and UDB work with WoW 2.1.3 to 2.2.3 » Reaper-X .:[ ID ]:.
- Mangos 4535 ScriptDev2 137 work with WoW 2.1.3, 2.2, and 2.2.2 » Reaper-X .:[ ID ]:.
- Creating WoW Private Server the easier way (perhaps) » Reaper-X .:[ ID ]:.
- WoW Mangos 4524 modified to work with WoW 2.1.3 and 2.2 » Reaper-X .:[ ID ]:.
- How to Configure MaNGOS the World of Warcraft Emulator » Reaper-X .:[ ID ]:.
- Configuring Mangos for TBC Server or WoW Classic Server - Setting up Private WoW Server » Reaper-X .:[ ID ]:.
Leave a response
Connect with me
Hey all, sweet guide ReaperX, ummm I was recently trying with a friend to get him on my server and he can log in fine, but he gets stuck at the “Logging into Game Server” part. Someone please help, email is craziwhyteboi23@aol.com
Hi all!
As far as I can see You guys are enjoying Your time on WoW and that’s cool! :) But, could anyone help me to solve such freaky problem lol:
OK. So,first>>>Here’s my home LAN/Internet system scheme:
PC#2 (launches mangos server)>PC#1 (on LAN)>Modem. Both PC’s uses Kaspersky firewall.
(this “>” “means connects to” :) )
PC#1 has 2 LAN cards, so the Internet connection is bridged and both PC’s can use Internet.
If I launch server+wow on PC#2 only-it works (with some realmd/IP changes), PC#2+PC#1=LAN works perfectly with no problems too. But I can’t get it working with connections from other PC’s that aren’t in my LAN. So that’s the problem, is it possible to play with such LAN configuration on PC#1,PC#2 and on other Non-LAN PC’s? Also it would be great if someone could explain how :) lol Thanks in advance!
Btw Reaper-X u rock man! Yeah!
have you tried running the mangos server on PC#1, and tried connecting to the server from PC#2 ? and if it works without problem, ask someone outside your LAN to connect to your server
How do you get the list for creature id’s and item id’s? I’m not sure which file(s) it is or how to open them. Any help is greatly appreciated. Thanks
well … since it’s stored on database the easiest way to get creature id and item id is using 3rd party mysql client
i’d suggest you to get NaviCat or SQLyog or similar program (most people who left comment here are using NaviCat / SQLYog) to assist you with this process
as a note, i never tried Navicat / sqlyog before … the only third party mysql client im using is PHPMyAdmin :)
ps. the creature id can be found in creature_template table while item id can be found in item_template table ;)
thx for the earlier info Reaper but now that i got to the part where i type use realmd it says does not exist so i got to create it and when i try to get to mysql page it says my acess was denied for some reason even when i had the right password so i changed it and it didnt work still said i was denied can you tell me whats wrong now because im really close to this and ive restarted to much so if i quit ill probaly never come back to it… just like alot of problems b4. Plz and thx for your upcoming answer.
hm … that’s strange .. btw try opening the task manager and see if there’re two mysqld process running or not
ok so i get to the part where you type in mysql and this is what happens C:/Documents and Settings/owner(not beta 4 some reason)>mysql -u root -p then it says ‘mysql’ is not reconized as an internal or external command operable program or batch file and then goes back to the beginning message or promp or whatever. help me please ive restarted 3 times and have searched many sites but none got m this far either way i dont wannna restart again so plz tell me whats rong.
i laughed when i saw your nickname LoL .. anyway to answer your question :
- try running the mysql server instance config wizard to automatically add mysql path to your windows environment variable
or there’s another way too (actually im using this when doing some remote assistance for WoW server) :
- open command prompt (tyep CMD from RUN)
- then type this at the command prompt window :
1. PATH and it’ll show you the current env. path
2. then Type PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin … if you installed mysql to different directory adjust it accordingly
3. then Type PATH again
4. if you do step 2 correctly you’ll see below line :
PATH=C:\Program Files\MySQL\MySQL Server 5.0\bin
as a note, the above command effect is temporary, which mean … if you close the command prompt window where you typed it in. You’ll need to retype the above command again :)
well I do have a Dlink router, I heard that makes a difference
since i never used DLink before, i cant say much about it
but im sure as long as you can set up port forwarding it should do the trick
hey, when entering
UPDATE `realmlist` SET `address` = ‘192.168.0.3’ WHERE `id` =1;
it just shows like this
mysql>UPDATE `realmlist` SET `address` = ‘192.168.0.3’ WHERE `id` =1;
‘>
and makes a nerw line with the ‘> thing :S
thanks, Danny
ah that’s probably because at the IP Address part you’re not using single quote to enclose the ip address value
try using single quote to enclose it :)
Hey when i type the mysql command it say it is not recognized command. Anyone know what i did wrong?
try running the mysql server instance config wizard to set up mysql in your path automatically :)
for more info about it, please check the first part of this guide about mysql
where can i get mangos [tompack?] v.2.1.3? torrents dont work for me idk why. just says seeding or w/e and then says downloading buy never downloads. give me a link plz?
I’ve got the forwarding ports setup. But people outside my router are still unable to join? help??..
ok I have another question, if I use hamachi what do my friends set thier reallist.wtf too?
I have wireless internet and i set my realmd to my lan ip not my computers ip using the command program and i’ll try to connect with my lan ip in my realmlist and it says unable to connect but when i use my computers ip i can connect but it takes me to realm selection. i click the realm then i click ok but it takes me back to realm selection again. i use hamachi and my friends can connect fine but i can’t connect even though im running the server. please help!
how do i set up to use hamachi and what do my friends need to do?
Same problem as everyone else, I get everything set up the way it’s supposed to be, but the game sticks at the “Logging in game server” screen, I forwarded all the ports you suggested and even the ports David said, but still no luck. I think i know whats wrong though, when trying to access the database with Mangold using the no-ip address it says “Host ‘no-ip address’ is not allowed to connect to this MySQL” any thoughts on this?
Ive tried about everything and when i input the command use realmd it just keep giving me “ERROR 1049 (42000): Unkown database ‘realmd’.
that error message mean you havent created the realmd database yet :)
you can fix it by importing the create-database.sql (or other sql file with similar filename)
Do people need to be on my router to be able to join my server? or do i need to continue to the next step?
if you’re behind router, you’ll need to setup port forwarding first or people won’t be able to connect to your server
Thanks a lot Manchine!
It worked and I it connted with the other computer!
My symptoms:
People outside my LAN can connect, but can’t get past the Realm selection screen. (i have tried the suggestions listed above)
People inside my LAN can connect if they use my internal IP, but cant even authenticate if they use the DNS redirect… talk about confusing.
I used a DNS redirect service (No-ip.com)
Changed my host file so that i can connect from the same PC as the server – this works using either internal IP or DNS redirect.
Im so confused as to what it could be. It doesn’t even make sense in my head.
I am stuck at step 2 for LAN server I keep geting this error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ”real
mlist’ set ‘address’ = ‘192.168.0.101′ where ‘id’ =1′ at line 1
Can anyone help me thanks.
Your using the wrong syntax. Correct syntax:
UPDATE `reamlist` SET `address` = ‘192.168.3.3′ WHERE `id` =1;
The first 5 ` are the tilde key, The ‘ in front of and behind the ip address are apostrophe key, the `id` are both tilde key. UPDATE SET and WHERE are not case sensitive btw. Just keeping with Reaper’s format for example sake.
Ok, SO i’ve set everything up exactly as described, I have the server running perfectly on my computer. I’m not understanding how to connect to the server from another computer though.
I have installed and set up MySQL and Mangos on my friends PC, and i’ve changed all of the connections to my pcs IP address, but when I try to log onto it it just says “Unable to connect”
Any Idea what i’m doing wrong? Anybody?
Nevermind. I’m dumb. lol.
after i put in “mysql -u root -p” i put in my password then it says welcome and the other stuff, but when i try to type “use realmd” it says “ERROR 1049 (42000): Unkown darabase ‘realmd’. Please help me.
Here is where i got Navicat btw
http://www.mininova.org/tor/808328
Got lan tu work:D Here is what i did…
u need NAVICAT to edit the wow server!
u need to edit the ip in c:\tompack\db\realmd\realmlist.frm.
to use NAVICAT u need to start START MYSQL then use NAVICAT to make a new connection.
#Connection name: MaNGOS or whatewer
#Password: root
#Then OK
Open the New Connection MaNGOS and the REALMD, then the REALMLIST.ALL THIS U DO IN NAVICAT
EDIT the IP to the IP u want then close the NAVICAT
Start the wow server and play!!!
Error on Startup Server
2007-07-31 04:07:25 Loading Quests…
2007-07-31 04:07:26 ERROR:Quest 3647 has `RequiredSkill` = 20219 but skill 20219 doesn’t exist, quest can’t be done.
2007-07-31 04:07:26 ERROR:Quest 3646 has `RequiredSkill` = 20222 but skill 20222 doesn’t exist, quest can’t be done.
2007-07-31 04:07:26 ERROR:Quest 3645 has `RequiredSkill` = 20219 but skill 20219 doesn’t exist, quest can’t be done.
2007-07-31 04:07:26 ERROR:Quest 3644 has `RequiredSkill` = 20222 but skill 20222 doesn’t exist, quest can’t be done.
how do u make it? i cant do it
PROBLEM SOLVED REGARDING NOT GETTING PAST REALM SCREEN….
Ok, here is what you need to do for all of you that were having the same problem I was having where you could login from the outside internet but then it would not let you past the realm screen.
The following ports need to be forwarded from your router to the LAN ip address of your WoW server…
3724
8085
1400
1401
I through my workstation out into the DMZ and I was able to login, so I downloaded a port sniffer to monitor port activity on my WoW server box and I found out that 1400 and 1401 are used for the mangosd.exe. So, I took my machine back out of the DMZ and just setup the above four ports to forward to my WoW server and WALLAH! So, I hope this helps a TON of you out there that were beating your head against the wall as I was! I knew there were some other ports being used!
Now, go have TONS of FUN on your public accessible private WoW servers!
Lan issues yet again.
Ok so ive done everything as listed verbatim. I have set up the dynamic ip for this host system and changed the ips in the conf files on the clients. A few questions.
What should be running on the host and client systems besides WoW? eg Mangos etc
The strange thing is I can even send in-game mail to people on other systems, i just cant see when they are online and standing infront of me.
It didn’t work for me so, plz tell me what program u used, i want to try it to. Hope u will anwer soon.
//Lohnn
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?
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.
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!
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.
http://www.megaupload.com/?d=7XJDL5T7
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…
yeah same problem, cant get past step 1
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.
I have the exakt same problem… latest mango, db and everything… playing on LAN works fine… virtual server thru router does not
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.
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 :-)
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
I have the same exact problem.
I have same problem as you 2 above
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
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
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
. . . 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
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
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?
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
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
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″)
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?
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?
Umm when i tried
mysql> Use realmd
Database changed
mysql> Update and i dont get this part what do do to thesE?
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)
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
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. =)
hi can u help me set this up in remote assistance on msn. I have tried everything and am ready to give up. Plz help!! add me on msn my addy is clarkcj@hotmail.co.uk
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??
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.
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. =)
The first 4 are the tilde key, sorry, I gotta get a new keyboard. =P
Correct syntax:
UPDATE `realmlist` SET `address` = ‘192.168.3.3′ WHERE `id` =1;
`realmlist` `address`