Main Website RSS FeedCurrent Article

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

  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 ;)

RSS Feed for This Post538 Comment(s)

  1. 1
    pan | Jul 5, 2007 at 15:27 / 3:27 PM | Links to this comments | Reply

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

  2. 2
    Reaper-X | Jul 6, 2007 at 9:57 / 9:57 AM | Links to this comments | 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

  3. 3
    Jake | Jul 7, 2007 at 16:02 / 4:02 PM | Links to this comments | Reply

    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)

  4. 4
    Noobie | Jul 15, 2007 at 9:39 / 9:39 AM | Links to this comments | Reply

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

  5. 5
    kevin | Jul 16, 2007 at 23:13 / 11:13 PM | Links to this comments | Reply

    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?

  6. 6
    Benz | Jul 17, 2007 at 11:08 / 11:08 AM | Links to this comments | Reply

    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?

  7. 7
    Benz | Jul 17, 2007 at 11:17 / 11:17 AM | Links to this comments | Reply

    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")

  8. 8
    sjc | Jul 19, 2007 at 4:15 / 4:15 AM | Links to this comments | Reply

    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

  9. 9
    sjc | Jul 19, 2007 at 4:18 / 4:18 AM | Links to this comments | Reply

    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

  10. 10
    Benz | Jul 21, 2007 at 10:18 / 10:18 AM | Links to this comments | Reply

    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?

  11. 11
    ben | Jul 22, 2007 at 22:56 / 10:56 PM | Links to this comments | Reply

    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

  12. 12
    Benz | Jul 23, 2007 at 11:16 / 11:16 AM | Links to this comments | Reply

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

  13. 13
    Mardyr | Jul 26, 2007 at 22:19 / 10:19 PM | Links to this comments | Reply

    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

  14. 14
    bigtam | Jul 27, 2007 at 0:09 / 12:09 AM | Links to this comments | Reply

    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

  15. 15
    Rile | Jul 28, 2007 at 3:59 / 3:59 AM | Links to this comments | Reply

    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

  16. 16
    Mini | Jul 28, 2007 at 16:49 / 4:49 PM | Links to this comments | Reply

    I have same problem as you 2 above

  17. 17
    Jeff | Jul 31, 2007 at 11:24 / 11:24 AM | Links to this comments | Reply

    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

  18. 18
    Francois | Jul 31, 2007 at 18:21 / 6:21 PM | Links to this comments | Reply

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

  19. 19
    Joe | Aug 1, 2007 at 10:17 / 10:17 AM | Links to this comments | Reply

    I have the same exact problem.

  20. 20
    Joe | Aug 1, 2007 at 10:55 / 10:55 AM | Links to this comments | Reply

    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.

  21. 21
    murk | Aug 2, 2007 at 5:33 / 5:33 AM | Links to this comments | Reply

    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.

  22. 22
    murk | Aug 2, 2007 at 5:47 / 5:47 AM | Links to this comments | Reply

    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.

  23. 23
    hj72 | Aug 2, 2007 at 6:30 / 6:30 AM | Links to this comments | Reply

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

  24. 24
    amadaun | Aug 2, 2007 at 10:38 / 10:38 AM | Links to this comments | Reply

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

  25. 25
    murk | Aug 2, 2007 at 22:20 / 10:20 PM | Links to this comments | Reply

    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.

  26. 26
    David | Aug 2, 2007 at 22:54 / 10:54 PM | Links to this comments | Reply

    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!

  27. 27
    murk | Aug 3, 2007 at 1:21 / 1:21 AM | Links to this comments | Reply

    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.

  28. 28
    David | Aug 3, 2007 at 10:20 / 10:20 AM | Links to this comments | Reply

    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?

  29. 29
    David | Aug 3, 2007 at 11:58 / 11:58 AM | Links to this comments | Reply

    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!

  30. 30
    a3 | Aug 3, 2007 at 19:41 / 7:41 PM | Links to this comments | Reply

    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.

  31. 31
    David | Aug 3, 2007 at 23:28 / 11:28 PM | Links to this comments | Reply

    how do u make it? i cant do it

  32. 32
    Sothy | Aug 6, 2007 at 11:32 / 11:32 AM | Links to this comments | Reply

    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.

  33. 33
    Mini | Aug 7, 2007 at 21:33 / 9:33 PM | Links to this comments | Reply

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

  34. 34
    Mini | Aug 7, 2007 at 21:35 / 9:35 PM | Links to this comments | Reply

    Here is where i got Navicat btw
    http://www.mininova.org/tor/808328

  35. 35
    Joey | Aug 9, 2007 at 2:32 / 2:32 AM | Links to this comments | Reply

    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.

  36. 36
    Manchine | Aug 12, 2007 at 0:24 / 12:24 AM | Links to this comments | Reply

    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. =)

  37. 37
    Manchine | Aug 12, 2007 at 0:28 / 12:28 AM | Links to this comments | Reply

    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. =)

  38. 38
    Loki | Aug 12, 2007 at 0:52 / 12:52 AM | Links to this comments | Reply

    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?

  39. 39
    mudkiller | Aug 13, 2007 at 21:43 / 9:43 PM | Links to this comments | Reply

    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.

  40. 40
    Manchine | Aug 14, 2007 at 2:37 / 2:37 AM | Links to this comments | Reply

    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.

  41. 41
    Manchine | Aug 14, 2007 at 2:43 / 2:43 AM | Links to this comments | Reply

    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`

  42. 42
    HoBoJunction | Aug 14, 2007 at 14:39 / 2:39 PM | Links to this comments | Reply

    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.

  43. 43
    mudkiller | Aug 16, 2007 at 9:04 / 9:04 AM | Links to this comments | Reply

    Thanks a lot Manchine!
    It worked and I it connted with the other computer!

  44. 44
    Loki | Aug 16, 2007 at 14:05 / 2:05 PM | Links to this comments | Reply

    Nevermind. I'm dumb. lol.

  45. 45
    Katra | Aug 21, 2007 at 7:30 / 7:30 AM | Links to this comments | Reply

    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?

  46. 46
    Reaper-X | Aug 21, 2007 at 15:22 / 3:22 PM | Links to this comments | Reply

    if you're behind router, you'll need to setup port forwarding first or people won't be able to connect to your server

  47. 47
    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’.

  48. 48
    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)

  49. 49
    pogodamunky | Aug 22, 2007 at 2:48 / 2:48 AM | Links to this comments | Reply

    http://www.megaupload.com/?d=7XJDL5T7

  50. 50
    pogodamunky | Aug 22, 2007 at 4:04 / 4:04 AM | Links to this comments | Reply

    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?

  51. 51
    Seb | Aug 22, 2007 at 4:43 / 4:43 AM | Links to this comments | Reply

    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!

  52. 52
    pogodamunky | Aug 22, 2007 at 7:53 / 7:53 AM | Links to this comments | Reply

    ok I have another question, if I use hamachi what do my friends set thier reallist.wtf too?

  53. 53
    pogodamunky | Aug 22, 2007 at 8:58 / 8:58 AM | Links to this comments | Reply

    how do i set up to use hamachi and what do my friends need to do?

  54. 54
    Katra | Aug 22, 2007 at 17:28 / 5:28 PM | Links to this comments | Reply

    I've got the forwarding ports setup. But people outside my router are still unable to join? help??..

  55. 55
    cronis | Aug 22, 2007 at 22:47 / 10:47 PM | Links to this comments | Reply

    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?

  56. 56
    Kyle | Aug 23, 2007 at 5:21 / 5:21 AM | Links to this comments | Reply

    Hey when i type the mysql command it say it is not recognized command. Anyone know what i did wrong?

  57. 57
    Reaper-X | Aug 23, 2007 at 21:07 / 9:07 PM | Links to this comments | Reply

    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

  58. 58
    joe | Aug 23, 2007 at 22:20 / 10:20 PM | Links to this comments | Reply

    yeah same problem, cant get past step 1

  59. 59
    dmonday | Aug 23, 2007 at 23:30 / 11:30 PM | Links to this comments | Reply

    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

  60. 60
    pogodamunky | Aug 24, 2007 at 7:29 / 7:29 AM | Links to this comments | Reply

    well I do have a Dlink router, I heard that makes a difference

  61. 61
    Lohnn | Aug 24, 2007 at 21:28 / 9:28 PM | Links to this comments | Reply

    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

  62. 62
    Reaper-X | Aug 24, 2007 at 22:20 / 10:20 PM | Links to this comments | Reply

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

  63. 63
    Reaper-X | Aug 24, 2007 at 22:21 / 10:21 PM | Links to this comments | Reply

    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

  64. 64
    gamefreak (not related to the company) | Aug 25, 2007 at 14:04 / 2:04 PM | Links to this comments | Reply

    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.

  65. 65
    Reaper-X | Aug 25, 2007 at 14:46 / 2:46 PM | Links to this comments | Reply

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

  66. 66
    gamefreak (not related to the company) | Aug 26, 2007 at 6:45 / 6:45 AM | Links to this comments | Reply

    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.

  67. 67
    vertibreaker | Aug 29, 2007 at 20:08 / 8:08 PM | Links to this comments | Reply

    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

  68. 68
    Reaper-X | Aug 29, 2007 at 20:32 / 8:32 PM | Links to this comments | Reply

    hm ... that's strange .. btw try opening the task manager and see if there're two mysqld process running or not

  69. 69
    Reaper-X | Aug 29, 2007 at 20:37 / 8:37 PM | Links to this comments | Reply

    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 ;)

  70. 70
    Bimbalas | Aug 30, 2007 at 23:25 / 11:25 PM | Links to this comments | Reply

    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!

  71. 71
    Chris | Aug 31, 2007 at 3:11 / 3:11 AM | Links to this comments | Reply

    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

  72. 72
    Reaper-X | Aug 31, 2007 at 10:47 / 10:47 AM | Links to this comments | Reply

    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

  73. 73
    Daniel | Aug 31, 2007 at 19:00 / 7:00 PM | Links to this comments | Reply

    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

  74. 74
    Reck | Sep 1, 2007 at 6:48 / 6:48 AM | Links to this comments | Reply

    I have the same problem as most, no others can connect, they tell me it stays stuck at the connecting screen. Any help seeming as though there are many people with this problem? I triple checked and quadruple checked all my settings and their all exactly to your guide, but still noone other than me can connect to it. I'm using dyndns and am behind a router, no firewall, all required ports forwarded.

    BTW, your guide is the bomb diggity yo! lol.

  75. 75
    Assassin901 | Sep 1, 2007 at 9:40 / 9:40 AM | Links to this comments | Reply

    ok so hear is the story... my friend made a private server and it works until the realm selection and about the same problem as almost every1 else it wont continue. if possible could u plz help me? tyvm in advance =D

  76. 76
    Olen | Sep 2, 2007 at 7:15 / 7:15 AM | Links to this comments | Reply

    Hey Reaper X,
    K I am getting the 1049 error and you said it’s just cause I haven’t imported the create.sql file or whatever, but I don’t know how to import it.. can you help me out? I don’t know where to go from here

  77. 77
    Reaper-X | Sep 2, 2007 at 15:29 / 3:29 PM | Links to this comments | Reply

    you can see how to import it from the part 2 of this guide :)

  78. 78
    JuiceBoy | Sep 8, 2007 at 17:21 / 5:21 PM | Links to this comments | Reply

    Dude... I`ve got a little problem, maybe you, or any passing reader cand help me out... I`ve got a variable IP Address, and i`m kinda getting nerves of always changing the configs... can you help me out ?

  79. 79
    Reaper-X | Sep 8, 2007 at 21:25 / 9:25 PM | Links to this comments | Reply

    You can try using Dynamic DNS service from sitelutions.com, no-ip.org, etc

  80. 80
    Tobbe | Sep 9, 2007 at 20:49 / 8:49 PM | Links to this comments | Reply

    Hi, got the same problem as everyone else, maybe it is the portforwarding, but i cant understand how to do it:S please someone help me!

  81. 81
    punkybrewer | Sep 10, 2007 at 5:36 / 5:36 AM | Links to this comments | Reply

    ok so how do we import that file? And im not sure on how to setup my mangos download. :D pls help

  82. 82
    Oscar | Sep 11, 2007 at 5:13 / 5:13 AM | Links to this comments | Reply

    ok this is working great for me but i have a friends over alot for lans and stuff and im just really stuck on how to get ti too connect to toher PCs bar mine done everything you have said (i think) read all the ost tried every solton and same thing, it just wont connect people can see the server but not log in either getting looped on the Realm screen or not being able to connect at all,

    Problem A : when i do the UPDATE `realmlist` .......... at the the end it just turns into a "->" not giving me the nice answer i want to see How to fix this.

    Problem B : the Realmd.cmd dose run gives me error messages like.. you "Pc name" can not connect to that mysql or Could not connect to the mysql database "at ip adress"

    and heres some help to one of the above post if you use the .command in game you will bring up all the avaliable GM command.

    well please reply and hope to hear from you soon ty for any help i get.

  83. 83
    dylan | Sep 11, 2007 at 12:39 / 12:39 PM | Links to this comments | Reply

    i use SQLyog its awsoem i got my server up with this mysql didnt work for me >.>

  84. 84
    Reaper-X | Sep 11, 2007 at 13:15 / 1:15 PM | Links to this comments | Reply

    # Tobbe

    Try go to portforwarding.com to see how to forward port

    # Oscar

    Did you setup port forwarding after updating your realmlist ip address ? because if you're behind router you'll need to setup port forwarding so others can connect to your computer

    as for Realmd.cmd ... im sure every mangos release is different (some are good while some other are not quite good because they're using Debug Information, etc), for example my own release doesn't include that batch file :)

    # Dylan

    Well actually you can use any 3rd party mysql client :) ... but as a side note, the mysql command really working as long as you didn't copy paste the command directly :)

  85. 85
    Oscar | Sep 12, 2007 at 3:12 / 3:12 AM | Links to this comments | Reply

    sorry to bother again still having issues can you add me on MSN or ICQ at pete_charlton@hotmail.com

  86. 86
    alex | Sep 14, 2007 at 7:09 / 7:09 AM | Links to this comments | Reply

    hey guys I am getting the same problem as well . i get to logging in to server , i try to choose the server , but the massage keeps poping up and i can't login , can any one assist please?

  87. 87
    plz help or mail :) | Sep 16, 2007 at 20:38 / 8:38 PM | Links to this comments | Reply

    i got sqlyog now, but i can't expand realmd like said aboven, how should i do that?

  88. 88
    John | Sep 17, 2007 at 23:45 / 11:45 PM | Links to this comments | Reply

    if you guys need help, like right away, add Kain@xierchien.com to your MSN, I'm happy to give ya a hand

  89. 89
    darkbaxter | Sep 21, 2007 at 0:02 / 12:02 AM | Links to this comments | Reply

    Hey pal, EXCELLENT guide - i was getting mad trying to find the way to set server and play on 1 computer...

    With this guide, it was piece of cake.

    THANX!!!

  90. 90
    Reaper-X | Sep 21, 2007 at 6:57 / 6:57 AM | Links to this comments | Reply

    Thanks you very much for your kind words :)

    as a side note, i just released my own compiled mangos again and this time it's using rev 4488 ;)

  91. 91
    zeke | Sep 22, 2007 at 8:10 / 8:10 AM | Links to this comments | Reply

    for all of you having the realm loop or being unable to change the "update `realmlist` set `name` = 'My Server' where `id` = 1;"

    you have to use the ` button above the tab key for
    `realmlist` and `name` and `id` but you use two apostrophes for 'My Server'. hope this helps you all like it helped me after seeing your posts.

  92. 92
    TBSKira | Sep 22, 2007 at 20:10 / 8:10 PM | Links to this comments | Reply

    im having trouble with the realm loop thing. i click okay to join it says unable to join realm...or something like that and goes back t o the realm list.

  93. 93
    TBSKira | Sep 22, 2007 at 20:24 / 8:24 PM | Links to this comments | Reply

    zeke...where do i change that stuff...

  94. 94
    Neo | Sep 23, 2007 at 21:16 / 9:16 PM | Links to this comments | Reply

    Hey,
    I've done all but still my friends cant connect
    i made one at no-ip.
    i did that use realmd and then neofx.no-ip.biz
    changed realmlist to neofx.no-ip.biz
    and in hosts
    # 192.168.1.101 neofx.no-ip.biz

    still my friends cant connect.. what to do?

  95. 95
    Neo | Sep 23, 2007 at 21:21 / 9:21 PM | Links to this comments | Reply

    oh and i can connect, but just my friends cant

  96. 96
    angel | Sep 24, 2007 at 1:02 / 1:02 AM | Links to this comments | Reply

    hi all... i still haven't tried it but i first wanned to ask ... can a friend connect to my server trough Hamachi ?! The program creates some sort of lan connection between people ... i don't know what router is but from everything i read i think it's being used for real lan connections or somepthing ... so i just wanned to ask if my friends can connect trough Hamachi

  97. 97
    Ozzy | Sep 26, 2007 at 23:40 / 11:40 PM | Links to this comments | Reply

    Change the realmd.realmlist (realmlist table in realmd database) into your lan ip address or public ip address I DONT UNDERSTAND WHAT TO CHANGE AND WHERE plss help

  98. 98
    Reaper-X | Sep 27, 2007 at 0:53 / 12:53 AM | Links to this comments | Reply

    # Neo

    Sorry for late reply, i didn't saw your comment

    as for your question, have you set up port forwarding so that others can connect to your server ?

    # Angel

    Well .. i havent tried Hamachi (or other VPN) yet and the reason is, if i already open the ports on my computer and let other connect to it, there's no need for me to use VPN (Hamachi), right ? ;P

    # Ozzy

    Look at the example image above the whatismyip image, that's what you should type to update the realmlist ip address

  99. 99
    c-bass | Sep 28, 2007 at 2:32 / 2:32 AM | Links to this comments | Reply

    Where are all of you downloading Mangos from? I can't seem to find a legit copy.

  100. 100
    XeRmi | Sep 28, 2007 at 4:31 / 4:31 AM | Links to this comments | Reply

    Hey great tutorial ... i made a server with reaper-mangos-R4488-full package and done everything and it works great only if u can explain me how to make it public... i dont have a router because i dont play in LAN i wanna play over internet ... i puted my IP adress in realmlist.wtf. Everything is up, mangosd, realmd ... when i try to connect from other pc nothing ... could not connect ... what should i do? THANKS

  101. 101
    Reaper-X | Sep 28, 2007 at 18:59 / 6:59 PM | Links to this comments | Reply

    # c-bass

    Look at the right sidebar for the recent post and click on Mangos 4505 :P

    # Xermi

    ah you need to execute the sql command first (see the image above the whatismyip.com image) for an example

    but dont forget to use your lan ip address instead of the example shown on this page

  102. 102
    Prowler | Sep 28, 2007 at 23:10 / 11:10 PM | Links to this comments | Reply

    no matter what i try..doesnt work

  103. 103
    Prowler | Sep 28, 2007 at 23:17 / 11:17 PM | Links to this comments | Reply

    http://img406.imageshack.us/img406/8716/65429936qj2.jpg

    [img]http://img406.imageshack.us/img406/8716/65429936qj2.jpg[/img]

    Should it be like this? There are no rows changed or anything

  104. 104
    Reaper-X | Sep 28, 2007 at 23:28 / 11:28 PM | Links to this comments | Reply

    to make sure you've changed the realmlist table correctly, see below link for an example

    http://img216.imageshack.us/my.php?image=testmz4.jpg

  105. 105
    Prowler | Sep 28, 2007 at 23:41 / 11:41 PM | Links to this comments | Reply

    so that IP there should be my IP ?

  106. 106
    Prowler | Sep 28, 2007 at 23:45 / 11:45 PM | Links to this comments | Reply

    If it should be...then its not. But i ve typed in all the commands you ve wrote here :S

  107. 107
    Justin | Sep 29, 2007 at 5:05 / 5:05 AM | Links to this comments | Reply

    I try and do the MySQL path thing and it says this

    Where is your MySQL BIN path ?
    (for example C:\Program Files\MySQL\MySQL Server 5.0\bin)

    C:/Program Files/MySQL/MySQL Server 5.0/bin
    -- Connecting to localhost...
    mysqldump: Got error: 1045: Access denied for user 'mangos'@'localhost' (using p
    assword: YES) when trying to connect
    -- Connecting to localhost...
    mysqldump: Got error: 1045: Access denied for user 'mangos'@'localhost' (using p
    assword: YES) when trying to connect
    Bye

  108. 108
    c-bass | Sep 29, 2007 at 6:30 / 6:30 AM | Links to this comments | Reply

    thnx, i got mangos downloaded. 1 more question- will this support the latest version of WoW (v2.2.0)? if not, which version should i have?

  109. 109
    Reaper-X | Sep 29, 2007 at 6:48 / 6:48 AM | Links to this comments | Reply

    # Prowler

    Check the new image directly below the update process :)

  110. 110
    kwamezs | Oct 1, 2007 at 5:10 /