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 ... 7 8 9 10 11 Next »

Hidden Vanquisher said Jan 17, 2008 at 4:21 am

@ JL

Mmph. They still work with this new IP. I don’t see what the difference is.

Link to this comment Reply to this comment
Renè said Jan 17, 2008 at 2:52 am

Plz help me.
i have created a server to my friend and brother, but they cant log on they can see the realm list but they cant log on, i have created account to them, so what is wrong??

Link to this comment Reply to this comment
Smackyou said Jan 16, 2008 at 9:29 pm

still no replay pls guy i wish to host the server now not next year…

i have another porblem when i enter my ip address and press enter this come up:

ERROR 1054 (42S22):Unknown column `***.***.*.***` in `field list`….what should i do now??

Link to this comment Reply to this comment
Kipper said Jan 16, 2008 at 2:32 pm

BTW, when logging in from within the lan, I get in the redundant realm selection screens, the username and pword logs in fine. and it even shows I have a toon in there still.

~thanks,

Kipper

Link to this comment Reply to this comment
Kipper said Jan 16, 2008 at 2:30 pm

Hi Reaper,

Your tutorial work perfectly for me. Everything was working perfectly, I was on, locally, and another buddy from wan. Now my two friends can connect and get in fine from the wan, but I am unable to from behind the wan. I have the mangos server running on a separate box from my client, however both are behind the same router and on the same server. Any ideas here? I am not using a dnsname, just the static ip.

Thanks,

~Kipp

Link to this comment Reply to this comment
JL said Jan 16, 2008 at 7:36 am

I think You should leave that address 127.0.0.1, cause the LAN IP goes to hosts file in windows, realmd.realmlist in mysql, and when You configure LAN with the .bat file. Every time i changed the line You wrote here with any other IP than 127.0.0.1, there was an error in realmd.exe, which could’t find the database. Hope i understand it well :) but even now i’m looking at a working realmd.exe, and it says 127.0.0.1, so that must be true.

Link to this comment Reply to this comment
Hidden Vanquisher said Jan 16, 2008 at 4:57 am

Hi Reaper, I’ve used your guide many a time but I’m trying something different. I don’t have your files all set up.

If I edit the realmd config file to my:

LoginDatabaseInfo = “192.168.xx.xxx;3306;root;root;realmd”

Where 192.168.xx.xxx is my LAN IP. Can others connect from a LAN?

Cheers Reaper.

Link to this comment Reply to this comment
JL said Jan 16, 2008 at 2:37 am

Thank You :) Yes, i gave up for a few hours, but now it’ll be up for some time. My friend just managed to get in finally, so it works, but i’d appreciate if You’d give me a second opinion. Tnx.

Link to this comment Reply to this comment
Smackyou said Jan 15, 2008 at 9:19 pm

#jl

i tryed to log in but it keept connecting and never connected ;)

b d way i dont now if your server was down or not at this time: 15.20 (my time +1) that was the time i chacked

Link to this comment Reply to this comment
JL said Jan 15, 2008 at 5:30 pm

If anyone would like to check my connection, you can login on larkinium.servegame.org with account login test password test :) thank you

Link to this comment Reply to this comment
JL said Jan 15, 2008 at 7:55 am

Hello, maybe someone can tell me. I just read ALL here about the ‘realm loop’, and problems with accessing the server from behind router, but none of it worked. I think this question still remains unanswered. What should i do to let my friend play on my server. I did everything that was posted here. She’s got realmlist edited properly, and i made her a working account. Please help, i’m sitting here too long ;]

Link to this comment Reply to this comment
Smackyou said Jan 15, 2008 at 3:34 am

ok my before post is solved tnx to old post but i have another porblem when i enter my ip address and press enter this come up:

ERROR 1054 (42S22):Unknown column `***.***.*.***` in `field list`….what should i do now??

Link to this comment Reply to this comment
Smackyou said Jan 15, 2008 at 2:53 am

have a problem when i go to change my reamlist and enter my ip address an error pops out :( and it says:

error 1064 (42000): you haev an error in your sql systax; check the manula that ‘realmlist’ set ‘address’ = ‘***.***.*.***’ where ‘id’ =1′ at line 1

dond mind my * just not to show my ip address thats all ;)

any help or sugestions that i must do or didnt do PLSS :)

Link to this comment Reply to this comment
peewee said Jan 14, 2008 at 9:49 pm

#Huntard

BTW, how do u put thos items in the game??

Link to this comment Reply to this comment
peewee said Jan 14, 2008 at 9:04 pm

#Huntard

LOL, ty,… ill check that out!!

so yh REAPER GIVE US A GIDE :)

thenx all….

still any 1 know about my dieing problem??

Link to this comment Reply to this comment
Huntard said Jan 14, 2008 at 8:34 pm

@peewee

hey, I’m still hoping reaper will make a guild for that that can help you more but all I know to do is to go to http://www.wow-v.com and you can create one there but I personally have no godly idea how to put it into the game

Link to this comment Reply to this comment
peewee said Jan 14, 2008 at 7:00 pm

#Kezia

Thanx, Ill try tht when i get home, so let me get it strate its ` not ‘?

Thanx agen :)

Also if any 1 can anser, how do i put custom venders in?
And;
I equip sertin thongs and lern sertin things and i die :(, But i cant ress, i clich reiec but i just stay there and cant ress….

Thanx

Link to this comment Reply to this comment
Kezia said Jan 14, 2008 at 6:17 am

Pee wee i had the same problem you used QUOAATION MARKS (’) where you should of used Tiles ` at ID

Link to this comment Reply to this comment
Kezia said Jan 14, 2008 at 5:34 am

2008-01-13 14:32:42 World Database: 192.168.1.5;8085;mangos;mangos;mangos
2008-01-13 14:32:43 ERROR:Could not connect to MySQL database at 192.168.1.5: Can’t connect to MySQL server on ‘192.168.1.5′ (10061)

2008-01-13 14:32:43 ERROR:Cannot connect to world database 192.168.1.5;8085;mangos;mangos;mangos
can anyone help

Link to this comment Reply to this comment
peewee said Jan 14, 2008 at 4:30 am

When i do;

update ‘realmlist’ set ‘address’ = ‘(my ip is hire)’ where ‘id’=1;

i get a error mesige saying;

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’ = ‘(my ip hire)’ where ‘id’=1′ at line 1

Can any 1 help me plz?

Link to this comment Reply to this comment
Golfkart said Jan 13, 2008 at 2:10 pm

Hey reaper, we got the ip address back to the local, but now we dont know how to change the dnydns thing. We cant get to our “Realmlistdatabase”

Link to this comment Reply to this comment
Smackyou said Jan 13, 2008 at 4:35 am

Frea | Aug 21, 2007 at 21:07 / 9:07 PM | Links to this comments | Reply

Ive tried about everything and when i input the command use realmd it just keep giving me “ERROR 1049 (42000): Unkown database ‘realmd’.

how do i do that??

(sry a small mistake) and than your answear posted before

Link to this comment Reply to this comment
Smackyou said Jan 13, 2008 at 4:33 am

Reaper-X | Aug 21, 2007 at 21:32 / 9:32 PM | Links to this comments | Reply

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)

how do i do that??

Link to this comment Reply to this comment
Dumbass said Jan 12, 2008 at 5:19 pm

Help plz i still cant connect Btw ur guide is great anyway reaper :p

Link to this comment Reply to this comment
Dumbass said Jan 12, 2008 at 12:22 am

Hi guys…
I followed all steps..
i really did everything… but if i start wow tpy my account name, pass.. i press enter and then a box says “Conecting” few moments later
“Unable To Conect” Plz help me !!

Link to this comment Reply to this comment
Huntard said Jan 11, 2008 at 8:28 pm

@happy_k
u mean mangosd?

Link to this comment Reply to this comment
happy_k said Jan 10, 2008 at 9:23 pm

yes.
i think u can do it in mangos.exe
open it with notepad n look after server name or somethink :P

Link to this comment Reply to this comment
Huntard said Jan 10, 2008 at 9:01 pm

by the way, is there a way to change the server name?

Link to this comment Reply to this comment
happy_k said Jan 9, 2008 at 9:11 pm

i have still the same problem i tryed out evry think but still nothink :(
as u said i seted back in realmd.exe the Ip from x-reaper.ath.cx to 127.0.0.1 n the end was that evry think work but im unable to connect the server :S (i seted in wow directory the realm file to x-reaper.ath.cx )
some tipps what shoud i do

happy_k

Link to this comment Reply to this comment
Jase said Jan 9, 2008 at 4:33 am

I am having a problem allowing other people to play on my server please could someone help me out i have tried what it says to do but I still do not understand very well as i am new to this.

Thanks

Jase

Link to this comment Reply to this comment
Huntard said Jan 7, 2008 at 11:12 pm

Hey sorry for posting so much reaper, but I have yet another problem/question >.<
Okay,
I opened the Hosts file and put both my LAN IP adress and the IP adress i get form whatismyip.com to what my server name thing is.
My friend was really exited because he got all the way to select a relam but he couldnt not *connect* to the realm
Is there an additional port forward I must do? And are hte ports UDP or TCP (something like that)
Thanks for the WICKED guide!!

The Huntard

Link to this comment Reply to this comment
Happy_k said Jan 7, 2008 at 10:10 pm

Ok i done it i run realmd n it work well but when i set x-reaper.ath.cx in my realmd.wtf file n enter wow /try to log in it say im unable to connect that server. what shoud i do here? :P

Link to this comment Reply to this comment
Reaper-X said Jan 7, 2008 at 6:04 pm

# Golfkart and Happy_k

Ah it seems you didn’t do it properly based from your description :)

Database: x-reaper.ath.cx;3306;mangos;realmd

the above sentences mean :

you’re trying to connect to mysql server which is located at x-reaper.ath.cx on port 3306 which is obviously can’t be accessed (by default because it only allow 127.0.0.1 connect to it)

so to fix it :

1. change it back to 127.0.0.1
2. and change the ip address in your realmlist database to your dyndns address

btw if both of you using my mangos release, all you have to do is just run reaper-x-mangos.bat and then choose option number 5 to edit your realm ip address :)

p.s this post was written before i created my own repack lol

# Huntard

Actually it doesn’t matter, and you can choose any name you want :)

Link to this comment Reply to this comment
Huntard said Jan 7, 2008 at 5:46 am

my realmist is
set realmlist nicksprivateserver.no-ip.biz
is that a correct one or does it have to be .com?

Link to this comment Reply to this comment
Golfkart said Jan 7, 2008 at 5:03 am

Oh thats right he sighned up and created a DNS using Dnydns.com

Link to this comment Reply to this comment
Huntard said Jan 7, 2008 at 4:59 am

PS.
Do I need to register for no-ip.com enhanced in order to host?

Link to this comment Reply to this comment
Golfkart said Jan 7, 2008 at 4:48 am

It gives us the whole “Mysql does not allow/accept that type of DNS” so how do we get it to allow it?

Thanks once again for the guide Reaper, Its gotta take a LOT of work =p

Link to this comment Reply to this comment
Golfkart said Jan 7, 2008 at 4:44 am

Yp, pretty much exactly what we’re getting, but my sql still encounters the same problem I posted before.

Link to this comment Reply to this comment
Happy_k said Jan 7, 2008 at 4:42 am

i do the same think as u and realmd
say there is no MySql server on that (non-ip addres). n i dont know what to do next…

Link to this comment Reply to this comment
Huntard said Jan 7, 2008 at 4:27 am

Reaper-X
What IP am I soposed to put as my realmlist? I went to no-ip.com and i made it forward to websight http://www.democ.com (don’t ask, not a real sight i think) and I have a realmlist
set realmlist democ.no-ip.info
what am I doing wrong? I cant get any friends to connect when they put that in their Realmlist.WTF thing…

Link to this comment Reply to this comment
nlax76 said Jan 7, 2008 at 3:21 am

# Reaper-X

that link won’t load for me. does that = my port is unaccessible?

Link to this comment Reply to this comment
wikid said Jan 6, 2008 at 11:25 pm

also for to tell yall this im gettin an error in my realmd saying that it cant connect to database and some other crap i cant remember ill probly be on irc at around 5 or 6 pm or somthing if anyone desides to go there and help if not just leave a message here sorry for being rude its lack of sleep i really am sorry just need some help

Link to this comment Reply to this comment
wikid said Jan 6, 2008 at 11:19 pm

and my name in irc is wikid as well

Link to this comment Reply to this comment
wikid said Jan 6, 2008 at 11:19 pm

sorry for typos bad speller and lack of sleep

Link to this comment Reply to this comment
wikid said Jan 6, 2008 at 11:16 pm

im really sorry iv been working on this for a lil over a month now and iv been up for about almost 2 days trying to figure this crap out and im a lil pissy so bear with me ok *sigh* where you have it in one of your blury pics to check the ip for the realmlist or what ever it says in the pic select = realmlist thing is that dont work i tryed select – realmist that didint work what in gods FORSAKEN NAME IS SUPOSED TO DO THERE CAUSE I CANT MAKE IT OUT ON THE PIC sorry again just a lil cranky O_O maybe if i could actualy talk to reaper or some one who knows how to do this imma go to sleep so im not so cranky if you have any one out there that has made there server has any mercy and has irc plz get ahold of me on irc and help me with this /server chat.elunacy.com #elunacy im not compleatly dumb so it wont be hard to help me im just like really about to throw my computer out the window O_O

Link to this comment Reply to this comment
Happy_k said Jan 6, 2008 at 9:30 pm

Hi
i have the same problem as Golfkart
i Sign up with Dynamic DNS service onDyndns.com
with “X-reaper” name n when i ran realmd
its say:
Database: x-reaper.ath.cx;3306;mangos;realmd
could not connect to mysql database at x-reaper.ath.cx cant connect to MySql server at
`x-reaper.ath.cx`
cannot connect to database.

what shoud i do now?

Link to this comment Reply to this comment
Golfkart said Jan 6, 2008 at 5:40 pm

Sorry for the re-post :( but I forgot to tell you the ports where in fact open =p

Link to this comment Reply to this comment
Golfkart said Jan 6, 2008 at 5:32 pm

Alright cool, we ran that, and we also found a way to save his DNS and public ip to the host file, but now, he trys to run my sql, and he gets this message:

“Using configuration file realmd.conf. mangos realm /0.8-SVN Database; (Public ip);3306;mangos;mangos;realmd could not connect to my sql database at (public ip): host ‘DNS (not sure if I can post it)’ is not allowed to connect to this mysql server. Cannot connect to database. _

Link to this comment Reply to this comment
Reaper-X said Jan 6, 2008 at 4:19 pm

# Golfkart

Could you ask your friend to run online port scanner first (after running mangosd and realmd process) and see whether port 3274 is accessible or not ? :)

http://www.grc.com/x/ne.dll?bh0bkyd2

# nlax76

Could you also run the online port scanner too ? (above link) :)

Link to this comment Reply to this comment
Golfkart said Jan 6, 2008 at 3:00 pm

Alright, so my friend has made a server and he can connect fine using his local ip. However, when we try to swich the realmlist to his public ip, we get the same “Unable to connect”

Now neither of us can change our host file with notepad, it gives us “Cannot create the file C:\Windows\System32\drivers\etc\hosts file. Make sure the path and file name are correct.”

Please help us out Reaper-X and thanks for the guide, its brought us all this way and this is our first problem =p

Link to this comment Reply to this comment