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
Leave a response
Connect with me
I seem to have the same problem as Neromyr:
People can connect from outside (internet), but when I connect from the same computer the server is running on I can log in but then get ‘can not connect to realm list server’.
I do see the message that authentication was successfull.
I use my dns in the sql database. I have LAN ip and dns in my host file.
I use dns in my local realmlist.wtf file
I can use public IP or DNS on the outide computers realmlist.wtf file.
Switching off virus scanner and disabling firewall did not help.
I’m puzzled. can anyone help?
Yeah to Muskcar…have to run Realmd and Mangose program at the time you are playing or it wont work. I just can’t connect on other pcs is my problem :D
Now I got it all up running for a while, but after I configured all the ports and the settings, it tells me the server is offline.
Is there some programs that needs to run while Im playing on the server?
ok an Update i got a little closer… i set up a Static LAN IP and that fixed my LAN conection problem i also found how to properly forward ports… but i still cant get it to connect useing my Public IP 24.15.xxx.xxx i am useing ur 2.2.3 Silvermoon Project DB (i used EZ-Reaper set up .bat and used option 5 that fixed my LAN issue… so i tried useing that option for my Public IP and it didn’t work wouldn’t let me or my friends connect… please help…
Sorry for these noobish replies. I didn’t realise it had to be updated after the patch. Well, it seems to work now.
When I run mangosd.exe it says the following:
You have _outdated_ DBC files. Please extract correct versions current using client.
be*
2.2.3*
Darn… I didn’t have the latest WoW update when I installed Mangos etc.
Now I just updated to 2.2.2 – Will all the things I’ve extracted me deleted or incorrect?
Nevermind. I actually found out that I needed to follow
http://www.reaper-x.com/2007/10/29/reaper-mangos-4651-scriptdev2-151-with-project-silvermoon-and-unified-database/
too. Didnt see other things than the installation there.
I hope it works after I did these steps out.
Okay, I really didnt get this question answered in an understandable way:
I downloaded MySQL Community 5.0 and installed excactly as
http://www.reaper-x.com/2007/06/27/mysql-installation-and-configuration-setting-up-private-wow-server/
told me.
I downloaded ReaperMangos4651 to the desktop and installed excactly as described on
http://www.reaper-x.com/2007/10/10/wow-mangos-map-vmaps-and-dbc-extraction-guide/
with no errors.
Then I went to this step (am I missing something, people said that you needed to test your server first before making LAN possible – well I do not know how to set it up yet, I only followed the guides I was told).
And when I hit “use realmd” it says:
mysql> use realmd
ERROR 1049 (42000): Unknown database ‘realmd’
mysql>
I would like to know what to do. Described, or a link to the guide I missed.
Yeah I am having the exact same problem. I thought it was a database problem…but it isn’t. That I can tell anyway.
my friends have changed their realmlist.wtf file to nickswow.no-ip.biz which is from no-ip.com and they cannot connect it keeps saying cannot connect but i connect just fine using that solution please
OK i can connect to it from my computer but no one else can PLEASE HELP ME no one outside my LAN can connect how to fix this please tell me
sry let me clearify… I get it to work with the defualt 127.0.0.1 set up when i use my LAN IP the 192.168.x.xxx number i cant log in but my other computer can but CAN NOT get past the realm select screen and when i use my PUBLIC IP 25.15.xxx.xxx NO computer can log on…
i have tryied NO-IP as _______.servegame.com, but still doesn’t work i have tried Hamachi nothing different i have ports 1399-1402 3754-3756 and 8084-8046 ports open and forwarded to my LAN IP (as for comcast u can only forward to IP 192.168.x.xxx) oh and i DID remember to change the realm.wtf files also
hey i am tring to make it public other than that GREAT guides actually the ONLY one i could understand and get to work what i am tring to do is make it so my friend can connect from his house i run 2 comps in my house and i get that 1 to get to realm select but it keeps kicking me back will not enter the realm… (i am willing to do anything that will help as long as its free of charge) and i am using Navicat (thanks in advanced)
ok thx for everything reaper-x everything worked
my server is public just a fiew more questions
1. must people that connect 2 my server have mangos?(i shouldnt think so)
2. i can log in but none of my friends can.
for them it seas unable to connect, wich probably means that i havent forwaeded the ports correctly, just 1 more thing i switched windows firewall off and it still didnt work.(if they need mangos to choin then that is the answer)
thx guys, best guide eva
first i have to say gratz nice guide,very clear etc. just 1 more thing: if my friend or someone else would want to connect 2 my server would he have to download and do all the steps i did to make my server aswell or do i just have 2 make his acc and he sets his realmlist?
LoginDatabaseInfo = “127.0.0.1;3306;mangos;mangos;realmd”
WorldDatabaseInfo = “127.0.0.1;3306;mangos;mangos;mangos”
Would i need to change this? (I forgot to add this in my last comment)
Ok my lanip is 192.168.1.101. My address (I assume is my ip) is the same thing. I changed all the 127.0.0.1 with that ip address and my PC works fine I just can’t connect anywhere else. So frsutrating :S.
Its ok for the late reply, I have been posting sort of everywhere and then I fix my problem :D Sorry.
# Slacker6
Im so sorry for late reply, i didn’t see your comments coming through
btw could you tell me, what is the lan ip address you ran the mangosd process, and also could you tell me what is the realmlist address you’re using ? (in mysql) :)
nvm fixed the problem
Hi,
im having trouble updating the realm list through the cmd. i type in:
update `realmlist` set `address` = ‘60.230.226.34′ where ‘id’ =1;
however it comes up with “Query Ok, 0 rows affected, 1 warning”. therefore the address has not changed.
thanks
Please check this page out reaper. I have looked everywhere and done everything on how to fix this. I opened all of my ports I have changed all my information used local IP. What else I am missing to where they cant connect? It tries, it keeps trying to connect for a long time. Please help.
Well reaper, your biggest fan is back with a problem that I cannot fix nor figure out. I am using LAN server and my computer the files are on works perfect, but cannot connect to other computers. Do I move files to the other computers as well?
Meant to say how to enable Quests :P not questions
How do you enable question on a private server ? I got mine set up and play , but i wanted to goof off with some quests. I use Antrix not mangos
like…. where teh !@&^% fuck do i get Mangos^^
Thx^^
GOT IT THANKS SO MUCH!!!
Hey there Reaper!
I have sorted out all issues.
Only 1 remains, people on an outside internet connection cannot connect to my server.
I have forwarded the following: 3724,8085 on inbound rules. What could be wrong?
Hey im trying to connect to my frieds private server. Everything works fine but when i log in to the server i get to the realm list click his mangos server then it tells me “logging into server.” Then it just kicks me back to the realm list again. What are we doing wrong?
Im completely in despair, it still doesn’t work for my friend, it still works for me thus if i try to connect to my server over lan & internet it works fine…
Hey Reaper,
Very nice job on the guides!
I have one problem. My server work fine, it can LAN from one PC to another “Behind” my router. But when I try to connect from an outside connection, then people get the message “Connecting”, “Unable to…”
I have a no-ip address which seems to work great. My MySQL is working good, but I don’t know if this will effect the “Connecting” – When you said go to mysql -u root, I wrote in the UPDATE ‘realmlist…. etc, but I get a syntax error. Could it be that I am using a different version of MySQL, at the moment I am using 6.0, and thats the one problem it gives me.
Other than that, I have opend the ports, etc etc. Im stuck right now. My brain is burning!
Thanks
Zac
Wtf, after typing my public ip into the realmd db it worked? O_o
Now, even more strange things are happening… i now have the same problem when i try to connect… =O (Got my dyndns in the realmlist; doesn’t work with localhost either) Does not work with 2.1.3 or 2.2.3, both can’t log into the realm; But the realm daemon that old badass always says ’successfuly authenticated and so on’ *sniff*
So, what is this supposed to mean? =O
Thx for your reply Reaper, but if you want to to test if my dynamic ip label works, i gotta tell you sry but it works ;P Tested it with a nwn server before; with both ports and everything worked fine
But anyway, here it goes:
hunt3r.kicks-ass.net
(Heh, yea DynDNS ;P)
im getting an fatal error trying to run the extract program i get
CLR error: 80004005
# CaptainCleric
Your welcome :)
# Neromyr
Could you tell me is the ip address in your realmlist table match your dns address (if you use dyndns service) or your public ip address ?
Also as a note, if you set your realmlist address (the one at mysql db), you’ll need to edit your HOST file in C:\windows\system32\drivers\etc
and add :
yourdnsaddress yourlanipaddress
or else you won’t be able to connect to your server :)
# wow
Are you trying to connect to the mangos server which is configured to accept incoming connection from the internet / public server / accessible to everyone who know your ip address ? or just a normal private server ?
# Hunt3R
Could you tell me what is your realmlist address (the dyndns address) that is used on your realmlist table? (if you don’t want to put your realm address here, you can send it to me via email) :)
# Darguk
try executing the command manually :)
http://www.reaper-x.com/2007/07/03/creating-public-server-for-lan-party-setting-up-private-wow-server/#comment-16116
Thanks to Manchine , I’ll include the fix later (because some people have problem with using the dot realmd.realmlist without going through the use command) :)
when i try to enter the ip adress, i get this messasge: ERROR 1064 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 ”realmlist’ SET ‘address’ = ‘**.***.**.***’ WHERE ‘id’ =1′ at line 1
any suggestions Reaper-X?
Hmmm I do have the same problem as some of the popl here; got a 100% working mangos, set all up properly for anyone outside in the internet to reach it; but when my friend tried, he had all correct wtf’s and so on (we tried it on LAN before) he couldn’t reach the realm, meaning he couldn’t make a char on it. He *could* connect but actually everytime he tried to connect to the realm he just got sent back to the realm listings.
Heeeeelp!^^
When i try to log in my account ( which is gm account ) its sas Unable to Connect everytime.
I set the Realmlist.wtf to 127.0.0.1
I apologize I meant to put option 5. I am at work at the moment and do not have the batch file open in front of me. but now that i think about it option 6 is quit and option 5 is to set it up for a local or internet connection.
alas I have tried everything i know of and cannot seem to get it to work properly. if i set it up to where its only the local machine it works just fine on that machine. but if i set it to use either my public IP address or a DNS it keeps giving me the “cannot connect to realm list server” and i know the ports are open on the router as well as on the systems firewall because i checked over both three times. I look at the Realmd window and it says accepting connection from (connecting computers IP) then it says that the account was authenticated succesfully. which is the same thing it says when i connect locally so i don’t know whats going on. MySQL is running because when i tried unistalling MySQL and running it. it gave me an error so i reinstalled MySQL and then Reinstalled mangos and set it up and it worked locally. I ran processes 1,4 & 6 in your set up bat file and checked with MySQL to see if it had adjusted the parameters like it showed doing it through MySQL in your guide. and it did so i can’t understand why its giving me the error it is on the client side. and i checked to make sure that the realmlist.wtf was set properly as well. can you help me? please.
The Hosts thing worked. Praise to you, Reaper. :)
Awesome work, and keep it going!
# CaptainCleric
Try to ask your girlfriend to add your hostname into the HOSTS file inside windows\system32\drivers\etc directory for example
yourservername yourserverlanipaddress
# Xyzy
Although it’s possible but i dont recommend it but just in case you want to do it, feel free to choose these options :)
1. Create windows service for mangos and realmd – http://support.microsoft.com/kb/251192
2. Put realmd and mangosd in your startup :)
Hey.
CaptainCleric I seem to be having the same issue you had commented about. Anyway you can fill me in on the solution? Thx in advance. And great job on the tuts Reaper.
Ok I’ve followed the guide and set up a dynamic DNS I try to connect and realmd says that the user was authenticated but the client side says “Unable to connect to realm list server” I’m not sure exactly what i’m missing or did wrong. If anyone know plaease help.Thanks in advance to any who can help.
Scratch that last one. I got it all to work, apart from one little problem.
I can connect, and people connecting via WAN can connect, but my girlfriend on the LAN cannot.
Hey!
First I would like to thank you for this guide.
Although i still managed to do something wrong.
I’ve changed the realmd.realmlist into my lan ip and changed my Realmlist.wtf to my lan ip and everything else discribed in the guide, or so it seems.
The problem is, when i try to start the Realmd and Mangosd applications they get an error that goes like this:
“Could not connect to MySQL database at 127.0.0.1: Access denien for user ‘root’@'localhost’ ”
Dont really know if it’s me having done something wrong at some point, but please, if anyone know something or have any suggestions, please, dont be shy :D
Thanks in advance
ReaperX, congrats go out to you!
A small problem, amidst all the others that you are probably swamped with. Everything works perfectly on a LAN-type server.
But when I try to switch to WAN-type, I hit a problem. I am able to connect, but noone else is, including people in my LAN (although they are connecting from outside the LAN using this method, technically).
I set up the Dynamic DNS service, as required. I set up my Router to handle Port Forwarding for the four mentioned in these posts, and did the same with my firewall. My realmlist files (the MySQL one and the .wtf one) are both using my Public IP address (Which is dynamic, I believe. Or I just can’t remember the one I might have had yesterday).
When my friends try to connect, they sit at the connecting screen for a moment, and then are told they cannot connect.
I’m utterly baffled. Any help would be appreciated.
Thanks in advance!
I am wondering what are all the ports that need to be forwarded? I have tried all I can find and nothing will work. I still keep on getting the occurence of it will connect me but take me back to the realmlist and everytime I do it it continues to happen. HELP ME PLEASE!!! Thanks:) oh and btw you did a great job at this and I want to thank you for taking time that it took to do it all. As well as it is funny with the thing when you close it it says byee and then cyaa lol I found that funny.