Creating Public Server for LAN Party - Setting up Private WoW Server
By Reaper-X on Jul 3, 2007 in Guide, MMORPG, Misc. Games, Tutorials, Video Games
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 ;)
Website RSS Feed
Stumble this post
Bookmark this post on Del.icio.us
Submit this post to Digg
Submit this post to Reddit
Print this
Trackback URL
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??
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
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)
Umm when i tried
mysql> Use realmd
Database changed
mysql> Update and i dont get this part what do do to thesE?
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?
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?
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")
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!
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
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?
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
. . . 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
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
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
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 same problem as you 2 above
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
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 have the same exact problem.
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.
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.
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
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...
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.
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!
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.
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?
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.
how do u make it? i cant do it
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.
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!!!
Here is where i got Navicat btw
http://www.mininova.org/tor/808328
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.
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. =)
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. =)
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?
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.
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`
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.
Thanks a lot Manchine!
It worked and I it connted with the other computer!
Nevermind. I'm dumb. lol.
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
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)
http://www.megaupload.com/?d=7XJDL5T7
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?
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!
ok I have another question, if I use hamachi what do my friends set thier reallist.wtf too?
how do i set up to use hamachi and what do my friends need to do?
I've got the forwarding ports setup. But people outside my router are still unable to join? help??..
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?
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
yeah same problem, cant get past step 1
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
well I do have a Dlink router, I heard that makes a difference
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
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 :)
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
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 :)
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.
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
hm ... that's strange .. btw try opening the task manager and see if there're two mysqld process running or not
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 ;)
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!
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
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
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
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.
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
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
you can see how to import it from the part 2 of this guide :)
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 ?
You can try using Dynamic DNS service from sitelutions.com, no-ip.org, etc
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!
ok so how do we import that file? And im not sure on how to setup my mangos download. :D pls help
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.
i use SQLyog its awsoem i got my server up with this mysql didnt work for me >.>
# 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 :)
sorry to bother again still having issues can you add me on MSN or ICQ at pete_charlton@hotmail.com
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?
i got sqlyog now, but i can't expand realmd like said aboven, how should i do that?
if you guys need help, like right away, add Kain@xierchien.com to your MSN, I'm happy to give ya a hand
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!!!
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 ;)
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.
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.
zeke...where do i change that stuff...
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?
oh and i can connect, but just my friends cant
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
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
# 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
Where are all of you downloading Mangos from? I can't seem to find a legit copy.
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
# 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
no matter what i try..doesnt work
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
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
so that IP there should be my IP ?
If it should be...then its not. But i ve typed in all the commands you ve wrote here :S
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
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?
# Prowler
Check the new image directly below the update process :)
Hey great guide my server is set up and everything. BUt my brother and i are shareing the same internet connection through a router and i set up everything like you told me but everytime he tries to log into my server from his machine it tells him unable to validate game version. i went into realmd and it shows his ip and accepts it so i dont know why he cant connect to my server.
is it absoutly necessary to have a router to share your server?
Reaper--
Firstly, thank you so much for everything. ^_^ This has opened many doors that perhaps shouldn't have been opened for me, as I am going to lose alot of sleep over this! ^.~
But to my problem: Whenever I go to change the name of my server in MySQL, I enter in the command line:
update `realmlist` set `name` = ‘My Server’ where `id` = 1;
And then I just get a blank command prompt, perhaps with a little '`' in front of it-- that is to say, not a normal command prompt. Whenever I type in 'quit' or 'exit', it just sits there, not doing anything. Kind of like when you'd press 'escape' on those old DOS machines? You'd get a funny, blank command prompt and nothing would happen.
Anyway, thoughts, insights? ^^ Everything works as you said it would... except this. ^^;
another one from me, i've now gotten the server going, and set everyhting up per instuction, but i can't seem to log in, from my pc, or from another on the lan, any ideas?? all i get in wow, is the unable to connect message
thanks
this does not really help the ppl that want to make a server just for L.A.N's... because most of us r not able to do half the stuff on SQL... we r only in school man. i just want to make a TBC server for my friens when we lan but cant even get that right with this GREAT GUIDE... i have done all u have said but still nothing has worked really... well it worked but stops working when i get to the next step... i might not b the brightest computer guy but i can not do this wit this guide... dont get me wrong its good... just not user friendly for ppl that r not good wit computer programs like SQL... its very higher grade stuff for school going kids.
Thanks anyway man hope to hear from u soon.
kris@bpst.co.za
Kris:)
Everyone try looking at my new post first to answer your questions :)
I am having problem with my friend entering my server. Kept stuck on the realm list, he said he tried to get in but it kept taking him back to realm list.
I have forwarded ports listed here:
3306, 8085, 3724, 1400, 1401, and 80.
Still having the same problem. I even tried DMZ on the computer where wow server is on. Still having the same problem. I am guessing that there isn't any problem with ports. There is something that prevent someone from entering my wow server. I use Hamachi with the friend.
I have Norton Anti-Virus with small internet software, i have disabled it with DMZ on, still not work.
What else can I do?
# ExoriaX
Have you configure the realmlist to use your public ip address instead of your local ip address?
I think it isn't working anymore, after the last patch, it says: corrupt file...
realmlist? did u mean realmlist.wtf?
set realmlist [wan ip]?
Forget to add, i searched in my computer and found the following:
realmlist.wtf
realmlist.frm
realmlist.MYD
realmlist.MYI
Which am i suppose to edit and what program should i open with it? frm, myd, and myi seems to be messed up in notepad but i can see "127.0.0.1" in some of them. I dont think it would be good idea to edit them in notepad where they look messed up. If u think i could edit in notepad then i will try.
Damn.. I cant forward ports because I cant setup a static ip address.. And because of that, I cant play with my friend DX
How can I use that DMZ? (yes, i am a noob)
Please answer me how to use it..
Hey, I have fixed up my other issues with mangos, but now I have the problem where my exp rate wont change. In mangosd.conf I have changed the kill exp rate to 7, but that didn't change anything in the game. I tried using 'reaper-x-mangos' to change the exp rate to 7, but that didn't work either. Also now when people are connected to my server I get a SESSION: received unhandled opcode SMSG_UNKIWN_978 <0x03D2).
Can you please tell what does all that error means and how I can firstly change my exp rate (i want it to be a high rate) and secondly change the item drop rate.
Thanks
i have problem with wow pravite server my friend set up server i enter his server it fine but i stuck on realm list then i click enter realm it said " logging in server " then back realm list "repeat" mean some program or something prevent can enter game ? does anyone know how to fix it ?
thanks :)
i have problem with wow pravite server stuck on irealm it said " logging in server " then back realm list "repeat" mean some program or something prevent can enter game ? does anyone know how to fix it ?
thanks :)
# BUG
are you using the 4535 revision ?
# ExoriaX
Not you can't edit that file directly, you'll need to use sql client to do it, if you're using my latest mangos revision 4535, you can just use the reaper-x-mangos.bat to help you with this step :)
# InfernoX
You can configure DMZ and port forward from your router configuration page :)
also if you don't have static ip, you can use free dynamic dns service
# Mike
that's because you're using the new 2.0 and 2.2.2 which is still not fully supported yet and thats why you get that message :)
as for editing the rate, i believe i've added that feature to edit your rate easily from the batch file provided in my 4535 release
# exo7
First you need to know that you've put the correct ip address in your realmd realmlist table, and also don't forget to configure your router to forward port 8085 and 3724 or else they won't be able to join your server
Hello again reaper-x,
Thanks for the reply, but as I tried to say before the "reaper-x-mangos.bat" R4535 does not work correctly.
I enter my MySQL install directory, then choose "4 Mangos Config Editor (you need to run this at least once)." Then it goes through the process of asking, what drop rate, exp rate, ect and just as a test I enter 99 into all of them. then i quit the program. run realmd.exe and mangos.exe, log into the game from another computer, kill something only to find the exp rate & drop rate still to be at 1X (50exp).
I also have tried changing the drop and exp rate inside mangos.config but that also did not fix the problem. I tried over righting the .sql files from the folder containing "reaper-x-mangos.bat" into the folder daemon>OriginalSQL>Mangos-4535. That however still has left with the the same exp and drop rate.
Obviously mangos.exe is getting it exp and drop rate values from another source, would you please be able to tell me from where that is, so I can fix it.
Thanks again
# Mike
Thanks for telling me, i just fixed it (lol i forgot to change the path)
http://www.reaper-x.com/files/reaper-x-mangos-bat.rar
grab the fix, and extract it into reaper-eazy-mangos directory overwriting the old one
as for you've edited the files by yourself manually and it's not working, that's because i put comment on that line ;)
and, mangosd read the exp rate directly from the mangosd.conf .. try it :)
ok, i started up mysql and it said:
071005 13:42:32 InnoDB: Started; log sequence number 0 43655
071005 13:42:41 [Note] db\bin\mysqld.exe: ready for connections.
Version: '5.0.27-community' socket: '' port: 3306 MySQL Community Edition
Which seems to be working just fine. I started reaper-x-mangos.bat i typed 1 to install, it asked me for mysql root password and i typed it in. Then few seconds later it said:
'mysql' is not recognized as an internal or external command, operable program or batch file.
I am not sure what's happening there.
Forget to add that i am using MAB's Private Server and i am trying to upgrade mangos 4535 that includes with reaper-x-mangos.bat.
MAB's Private Server 2.1.3:
http://www.youtube.com/watch?v=z43oER3Byew
ok, I am trying to do the mangosand play wow like you said, an i have configured everything, but when i try to login to wow, it just sits there for about a minute, then it says unable to connect. BTW, if i disconnect from the internet, like im trying to play offline, it says unable to connect automatically. Can you help me?
above, where i said automatically, i meant it happened immediately. I am trying to play wow and run mangos from the same computer BTW
Thank You,
I know have a successful server up and running.
Hi!
Reaper hats off to you sir. Thank your very much for this guide and all things have been working out great. Played on my server for 6 hours yesterday and i noticed some things.
Mobs are slightly Overpowered for some reason, i had no problem with it but my 2 friends who joined me kept whining (probably b/c of the lack of Skilzzz), but anyhow i noticed mobs being able to take some damange than usual and because of this the game is slower. Which leads to my next question, i'm still playing with it but when i use the mangos config editor, and change the loots i cant tell a ingame difference.
How does that # work in mangos config editor, it says default is =1, but if i put 2 does that mean i doubled the xp, gold etc?
For some reason random monsters are on mounts, like a boar or something with and epic dwarf mount, kind a cracks me up but just wanted to mention its around.
Im not too worried about mobs are being too strong i just wanna up the XP and such.
Thank you
Forgot some things there sry, im running wow 2.1.3
with the 4524 mangos. Also when i start up mangos i get this error while its loading all its crazy little things.
Creature (Entry: 23157) have non-existed modelId_A (0)
Creature (Entry: 23157) have non-existed modelId_H (0)
Loading spellscripttarget
================================100%
>> Loaded 0 spellscripttarget from `spell_script_target`. DB table `spell_script_target` is empty.
Any input?
Thanks
# ExoriaX
>> ‘mysql’ is not recognized as an internal or external command, operable program or batch file.
That error message mean, it couldn't locate the mysql.exe
so to fix it, you'll need to know where mysql.exe can be found .. if you previously use a repack that include everything, i'd suggest you to delete the previously included mysql and then do some fresh reinstall of mysql
# Logan
Could you tell me what's the error message exactly ? (look at the server.log)
# Magnus
Unfortunately i made a slight mistake on the reaper-x-mangos.bat and just uploaded the new one with fix yesterday :)
try looking at my 4535 post (you dont need to download the whole package again) ;)
# Reaper-X
Is it possible to run only from ur package (4535) with mysql server 5.0. If so can I delete MAB's Private Server 2.1.3?
Ok, let me make it much clearly.
I downloaded ur package (4535) and extracted it to:
C:\Mangos
I downloaded MySQL Server 5.0 from MySQL.com and followed the guide for setting up MySQL with ur guide:
http://www.reaper-x.com/2007/06/27/mysql-installation-and-configuration-setting-up-private-wow-server/
I got no problem with installing MySQL. I followed the guide perfectly.
I extracted DBC, Maps, and Vmaps and copied the folders to:
C:\Mangos\
I have no problem with that also.
Then I went to:
C:\Mangos\reaper-eazy-mangos\
I started reaper-x-mangos.bat and run it. It asked me where is my MySQL bin path? I use it as default cuz i followed ur guide about installing and configuring MySQL perfectly. So the default path is:
C:\Program Files\MySQL\MySQL Server 5.0\bin
I pressed enter then error said:
"ERROR 2003 : Can't connect to MySQL server on 'localhost' "
Seems like the MySQL isn't started. How do I start it?
That's the exactly what I do recently without using MAB's Private Server 2.1.3. Only ur package (4535) and MySQL Server 5.0 that's all.
Thanks,
ExoriaX
Here's the video of screen i record on my computer:
http://www.exoriax.net/downloads/mysqlerror.avi
Ok i seem finally got mysql to run. I found out that i only need to type 'net start mysql' in command line to start mysql.
Then i used installation in reaper-x-mangos.bat and it installed just fine, no errors at all and imported database also.
I went to:
C:\Mangos\
And start realmd then it said:
Could not connect to MySQL database at 127.0.0.1: Can't connect to MySQL server on '127.0.0.1' (10061)
Cannot connect to database
Here's the video:
http://www.exoriax.net/downloads/realmderror.avi
MySQL is running as it said in video and i cannot connect to it? I don't understand what's happening?
ok hey reaper again lol its been a few days since i last talked to you and everything is fine wit my server but i cant get my port fowarding to work, so i cant have my friends play wit me!
I tried using http://www.portfoward.com but they dont have my router on there and i tried using the routers ip address in my web browser but it just gives me a summary of my router......
i dont wanna buy a program to do my port fowarding so what can i do?
my router is an Arris TM402G
oh and i do have a static ip address set-up.
and i dont have internet explore or netscape for my browser i have Foxfire....idk if that changes anything.
oh and i have tried searching for other sites that could help but i couldnt find anything.. :(
Hey Reaper-X nice guide.
I got everything to work ... but my friedns can't join. They could when we tried local but now i've changed it all ( DNS with no-ip.biz) and all, but when my friends try to connect it just says can't connect. Now i have tried Port-fowarding but it doesn't allways work ( donno got this set up [My PC] > DI-524 Router > DSL-502t Router > ISP , i got 2 routers caus the 502 only has 1 port and no wireless) Any way port forwarding is a ***** on these things and i can't get it to work ( i think , is there any way to test it?) . Plz hlp is there a programm or something that can forword it for the router? or anything plz hlp
# B
Unfortunately i havent tried using that router too. The only thing i can suggest is, to look at your router documentation / manual directly :(
# ExoriaX
Could you tell me what is your my.ini looks like ?
p.s you can paste the contents of your my.ini file into :
http://www.pastebin.ca
# Manu
you can always use DMZ on both if you want the easiest way :)
i wish i could! lol i cant find the damn thing anywhere....hmmmmm...... lets hope i find if soon
http://www.pastebin.ca/729105
Ok i have posted my my.ini file from:
C:\Program Files\MySQL\MySQL Server 5.0\my.ini
I hope u could figure out what's wrong.
Thanks,
ExoriaX
hey, i got everything up and runnin. it all works great cept one problem. some of my friends get kicked and get a critical error messeage when they try to open the charactor sheet in game, anyone know what might cause this and how to fix?
awesome guide reaper thx
ooook.....so i followed all instructions....and it still doesnt work....i think i may have put something wrong in my realmlist/realmd/mangosd files as my IP. i have like 3 IPs and i dont no which im supposed to use (LAN, Router, Public)
Hello Reaper-X,
I have succesfully setup a lan server, which works perfectly with all the computers in my house. However when my friend tries to connect using my external ip from his house, he writes in details (username, password) then it says authenticating then handshaking then success then sits there for a while and then comes up with the realmlist, then he clicks on the freerealm realm and it says logging in to server and then it sits there for a little bit and then goes back to the realmlist.
The ports 8085, 3724, 1400, 1401 are forwarded to my server from my router. Also my firewall allows those ports.
If it helps I can give you a test account, in an email, with my realmlist.wtf.
I really don't know whats stoping it from working.
PS: In realmd.exe my friends IP comes up and says accepting connection. then User "his user" successfully authenticated.
Just thought I'd add that. XD
# B
to be honest, actually this is the first time i heard about this ARIS TM402G :D .. so im really sorry for this
# ExoriaX
I can't open that site (retried for more than 10 times but still can't open that site) .. so i think im going to check it later today (if you want to see my local timezone, you can look at the time this comment was posted here)
# nordus
probably there's a missing file (game data) in your friend wow installation
# Clueless
the answer is depend but basically im guessing that your question basically the same as Mike2 question :)
# Mike2
Actually you'll need to use the same ip address as used on your realmd.realmlist address (in mysql database)
for example (this is not the realmlist.wtf file inside your wow directory),
- if you set 192.168.1.1 as your realmd ip address, that mean you only allow those who are in the same network as you to join your server
- if you use your public ip in realmd.realmlist, that mean you allow everyone to connect to your server as long as they know your ip address and you didn't block any outside connection from your firewall ;)
I am having a problem connecting to wow from thae same computer that mangosd and realmd is on. I believe I have everything setup correctly according to the tutorials provided (which are excellent by the way!) can someone IM me @ jemmck or email me at jemsmck@gmail.com with some helpful tips?
HI guys, and thank you so much reaper for the guide, i followed it and my friends love playing on my server. Only problem is, I cant join them!
MY sql, mangos an realmd all running on the computer im using wow on. I set the IP in realmlist to my public IP address, forwarded all the ports, and my friends can play, no problems.
In realmlists.wtf, ive tried 127.0.0.1 (my local host), ive tried my lan ip, 192.168.2.10, and ive tried my public IP, and ive tried my dns XXX.no-ip.biz, none of thse will get me past my realm selection screen.
do I have to edit my hosts file? ive done xxx.no-ip.biz with all the above addresses, nothing seems to work, can someone please help me out here? be much appreciated.
Thanks again reaper!
Weird cuz it is still working fine for me. If ur still having problem to enter that link then i have uploaded my.ini to my own site here's the link:
http://www.exoriax.net/downloads/my.ini
Hope this helps.
P.S. Now i have to wait next day for ur response. :(
well the my.ini has nothing to do with the network or internet, jus table values an what not for sql configuration, and my sql is runnin perfectly, the prob has to be with my realmlists.wtf file or my hosts file. I knwo sql is doin its job fine cause my friends are playing on my server right now, but I cannot connect to it.
what....what is realmd.realmlist? i have a realmd and a realmd.conf but where is the other one?
nvm i found it....and changed it to my public IP....i still dont know what they are supposed to put into their realmlist files in the WoW folder to sign on though.
I seem to be able to get pass the realmd error i posted previously by edited the ports in my.ini. I dont know why it is set to 3308. I changed them to 3306 and it worked fine but i got error with vmaps and maps.
Am i suppose to extract them during the wow client is 2.1.3?
I looked up in google about vmaps and maps error. I have extracted them properly and still get error.
So, I found a thread on ur forum, Reaper-X about vmaps and maps error.
I tried this as u said on that thread:
vmap.enableLOS = 1
vmap.enableHeight = 1
into
vmap.enableLOS = 0
vmap.enableHeight = 0
It works just fine and my server is running just fine i can login/create chars.
What else could i do to fix this error? Remember, i have extracted it when my wow client is patch v2.2.2.
here's the video of mangosd error (vmaps and maps):
http://www.exoriax.net/downloads/mangosderror.avi
Well, everything works perfectly, i can enter my server and my friend can enter my server so the only thing that i turned off are:
vmap.enableLOS = 0
vmap.enableHeight = 0
Are they that necessary? If so how do i fix the vmaps and maps error?
# ExoriaX
Ah ... actually enabling vmaps of course is a lot better, im pretty sure you just close that window right away before it's finished extracting ;)
try deleting the buildings and vmaps, directory first and then run the SIMPLE.bat (to extract vmaps once again) and wait until you see :
PRESS ANY KEY TO CONTINUE MESSAGE
before that message appear you just have to wait (it'll took 2 hours on some computer, or 30 - 45 minutes if you have fast computer)
I seem to be able to get pass the realmd error i posted previously by edited the ports in my.ini. I dont know why it is set to 3308. I changed them to 3306 and it worked fine
Actually that's why i want to see your my.ini file ;) ... but i guess now you've found it
# Clueless
You just need to tell them your public ip too
# John
Actually the my.ini part is specifically for exoriax, because he is having problem with mangos and realmd process can't connect to mysql, and it seems i was right his mysql running on port 3308 :)
As for your question, you just need to add your LAN IP address that is used to connect your computer to router to your windows host file
for example your dyndns address : my-cool-wow.com
now you just need to add :
192.168.2.2 my-cool-wow.com
into your windows host file :)
Hey guys im stuck by the part of which ip adress to put in the realmlist and thus i get a loop with connecting to server.Which is the correct one to put the realmlist ?
I've done everything, mangosd.exe works, realmd.exe works, changed the realmlist.wtf and when i go to connect on WoW it says: Connecting then 5 seconds after disconnected from server. please help, this is frustrating
Ok i have successfully running server with no errors and vmaps/maps work perfectly.
Hint: Just a hint that i closed when it said
work complete. no errors.
I thought its end. I just realized that it started the vmap_assembler.exe and is still running from inside. This is how i noticed by seeing the files in vmaps constantly increasing. I was like "oh" lol.
Well, anyway, it is working like charm.
Is there a place where i can report bugs so u can fix them? I have seen several bugs since yesterday.
I am a little unclear about the part requiring you to register on one of the dns sites. I registered, but what exactly is the dns name (and do I set my public ip address to where realmd.realmlist accesses the server from?)
Alright, I've figured out everything with the dns name and done all the steps, but whenever I try logging on, the "Unable to Connect" message comes up (on the WoW client).
One more thing, when I try to log on using my lan IP address there is an error message something along the lines of "Unable to validate game version. This may be due to corrupt files, ..."
I was wondering if this was because of the latest bug fix patch or because of something else.
if ur friends want to join LAN over internet use Hamachi named program...its imba...no need to leave from ur room to go to LAN ^^
Hello again Reaper :P
I installed Mangos and it works very fine, nothing to say. The problem is when i try to modify my system32 file called "hosts": it doesn't modify the file instead, but it creates a new file called hosts.txt. My friends can connect to my server, it works. But I can't connect to my own server by the pc who runs mangosd and realmd. Please help me if you can.
# Xyzy
I'm still not sure what is your problem actually, btw which mangos version you're using ?
# Infernal Demon
Try to make sure that the host file is not set to read only, and if you choose to open it using notepad make sure you choose SAVE FILE AS, and then overwrite the original host file :)
Well, I've fixed the "Unable to Connect" (it was because of a file problem; the same as infernal demon's, in fact), but now am faced with the "Unable to validate game version" problem.
And my Mangos version is 4535.
Alright, I fixed the problem by updating to the latest mangos version.
Reaper, thanks a ton for compiling this all together.
And one last thing, is it possible to make it so that I don't need to run realmd.exe and mangosd.exe every time I log on?
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.
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!
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
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.
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.
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.
# 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 :)
The Hosts thing worked. Praise to you, Reaper. :)
Awesome work, and keep it going!
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.
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.
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
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 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?
# 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) :)
im getting an fatal error trying to run the extract program i get
CLR error: 80004005
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)
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
Wtf, after typing my public ip into the realmd db it worked? O_o
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
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 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?
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?
GOT IT THANKS SO MUCH!!!
like.... where teh !@&^% fuck do i get Mangos^^
Thx^^
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
Meant to say how to enable Quests :P not questions
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?
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.
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
nvm fixed the problem
# 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) :)
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.
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)
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?
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
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)
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
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
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
Yeah I am having the exact same problem. I thought it was a database problem...but it isn't. That I can tell anyway.
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.
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.
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?
be*
2.2.3*
When I run mangosd.exe it says the following:
You have _outdated_ DBC files. Please extract correct versions current using client.
Sorry for these noobish replies. I didn't realise it had to be updated after the patch. Well, it seems to work now.
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...
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?
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
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?
Hello.... i got problem with update my realmlist in CM to make my server online all i get is a sound from my computer and a error...
plz help me =)
Reaper... So far so good other then 2 days of trying to plug this together... Please send email reply if possible... trying to setup semi-private (open through internet/port forwarding to select ppl) i can get server up and running connecting locally. though lan will let me connect but not go past realm selection. I am using mangos 4651, MySQL 6.0, and SQLyog to edit the data (for some reason the cmd prompt will not work for me no matter what i try (or how many times i re-install after wiping it out) from local machine runs perfect.
Ports forwarded: 8080, 8085 (default wow port, 3724
signed up at no-ip.com for internet forwardinginto my router (this is what i have placed in the realmlist.wtf) work on local (as it should) but to no avail no others (including myself on one of my few lan terminals) the best i can get is stuck at realm... I must be retarded (i am not that fluent in this type of databasin/scripting. Im sure i am missing something small....
btw... no firewall installed. Im puzzled...
thank you
I already fixed it with the 'lazy method' described here:
http://www.mangosproject.org/forum/index.php?showtopic=11737
No idea why the other method does not work for me.
Reaper, a big thanx for putting together the mangos releases.
Nvm, realmd and mangos, but now I have another problem.
My cousin (doesn't live near me) wants to connect to my server. Is this possible ? (Because it says "Unable to connect" to him, and everyone here can connect).
It may because its only "set realmlist xxx.xxx.xxx.xxx" that works and not my "set realmlist muskar.no-ip.org" that works.
I enabled the 3427, 8085, 1400, 1401 and 80 ports to forward.
The server is online and can be reached from anywhere through my wireless internet connection (LAN).
BUT, when my cousin tries to connect, it just says Unable to Connect.
Would it work if he modified his IP to a Static IP identical to mine but with 1 different value in the last 2 digits (XXX.XXX.XXX.X##)? I haven't checked if he did it right, but it doesn't seem to work.
Any ideas?
One more question:
I would like to modify the values within
Nvm, realmd and mangos, but now I have another problem.
My cousin (doesn't live near me) wants to connect to my server. Is this possible ? (Because it says "Unable to connect" to him, and everyone here can connect).
It may because its only "set realmlist xxx.xxx.xxx.xxx" that works and not my "set realmlist muskar.no-ip.org" that works.
I enabled the 3427, 8085, 1400, 1401 and 80 ports to forward.
The server is online and can be reached from anywhere through my wireless internet connection (LAN).
BUT, when my cousin tries to connect, it just says Unable to Connect.
Would it work if he modified his IP to a Static IP identical to mine but with 1 different value in the last 2 digits (XXX.XXX.XXX.X##)? I haven't checked if he did it right, but it doesn't seem to work.
Any ideas?
One more question:
I would like to modify the values within 'mangosd.conf', but each time I do, and saved it, mangosd.exe immediatly closes (as if I didn't modify the option 4 in 'reaper-x-mangos.bat')?!
I would like help with this. (Sorry if I double posted, I may have clicked while I wrote this)
# Arez
Try changing the realmd port from 3724 into something else (7000 usually should do the trick) by editing the realmd.conf manually :)
btw this problem also occured to someone else who lives in UK and using cable connection although he don't have firewall installed and conencted to the internet directly
# Muskar
actually if you set the realmlist into :
muskar.no-ip.org
you'll need to tell your cousin to use that address too :)
as for mangosd.exe close immediately, i'd suggest you to run the mangosd.exe from the command prompt directly so you can see the error message ;)
I still need help i tried everthing but nothing works :( I canät change my realm as the image above i jusst got an error is it possible to do it public in a other way?
#Reaper-X
I knew that he had to edit the realmlist.wtf-file and he did.
What would happen if he got a copy of my 'hosts' file from C:\WINDOWS\system32\drivers\etc\ [where the last lines are modified to:
'127.0.0.1 localhost # Default LAN
192.168.ØØØ.ØØØ muskar.servegame.org # WoW Private Server' (with real numbers replaced with the Ø's)]?
I know this isn't required from other internet accessable Mangos servers, so I doubt it.
A few things:
1. I would like to know how to test if the server is accessable from a computer that isn't behind my router without having one.
If this is impossible, I have to get mates to attempt to log in each time.
2. It's unlucky that each time I feel to post here, you have just gone to bed (or at least off this board), so it takes a while to get answers.
3. I would like an answer on my reply in 'Installing and Setting up Apache 2.2 series with PHP 5 on Windows' as I am trying to setup a register page, so my mates can register, without letting me know their password.
4. The mangosd.exe error was:
C:\Documents and Settings\USER>Desktop\ReaperMangos4651\mangosd.exe
DOTCONF++: failed to open file 'C:\Documents and Settings\USER\mangosd.conf':
No such file or directory
Could not find configuration file mangosd.conf.
5. I would like to know if you could administrate which commands each gm level could use. Do you know how to edit this?
# Fladdy
Could you tell me are you using my mangos release or another release ? and could you tell me what is the error message ? :)
# Muskar
1. If it's okay with you, i can try accessing your wow server :) (just tell me what is the realmlist name and also create a test account)
2. haha well actually that's because i live in another timezone
3. actually it just a guide on how to setup your own webserver, but you'll need to create the registration page by yourself (and you need to know about php) .. or you can also use a premade registration page that can be downloaded from mangos forum directly :)
4. Did you run the reaper-x-mangos.bat again and choose option #4 ? btw if you previously use 4629 release you can just simply copy the previous mangosd.conf into the 4651 directory since there's nothing changed in mangosd.conf (and i'll always make sure that if there's anything changed i'll post it directly on my release) :)
5. Ah .. you can see what GM level required in order to use specific command by looking at the command table, other than that you can also change it too
here's an example on how to see the level required for specific command if you don't have mysql client installed
1. go into command prompt
2. type :
2.1 mysql -umangos -pmangos -D mangos
2.2 select `name`,`security` from `command` where `name` like '%tele%';
btw here's what the output from the above command look like :
+------------+----------+
| name | security |
+------------+----------+
| addtele | 3 |
| deltele | 3 |
| grouptele | 1 |
| lookuptele | 1 |
| nametele | 1 |
| tele | 1 |
+------------+----------+
6 rows in set (0.00 sec)
the above example will show you the required level to use the tele command :) .. but of course you can change tele to another command to see the level required for anything you want :)
I hope there will be comments today, or some time soon.
If I forgot to specify something before you can make a reply, please tell me what it is.
Sorry, it didnt show your reply, even after 2 times of refreshing the page.
1. Yeah you could.
In LAN, people can access it by 192.168.1.136, but I guess thats only for LAN as it's my LAN IP adress.
My DNS host name is muskar.servegame.org, but it doesn't work, only for me.
Maybe its the ports that are already used, I dunno.
Tell me if you need anything else.
I have it up running now, and for a few hours forth.
2. yeah I know q: but I'm still able to login before you get off, but I always reply at 18/6 pm in my time zone (GMT+1) so it happens to be 24/12 am to you.
3. I am experienced with php, and my issue is not to create my own website, but getting apache to work (in step 9) and getting http:\localhost\test.php to be displayed.
4. So you have to do option 4, after you changed the conf file to save it for mangosd.exe properly? I will try that.
No I did not use the previous release, then I would already know what to do in these steps.
5. Ok that worked.
Ok, now I know how to check it the level, but can you show me how to edit the security level?
And is level 0, normal players?
As far as I'm concerned, they start out with .start, .info etc. etc., it doesn't show that?
ADD TO REPLY:
1. Btw, if you can connect, then here is the login:
Account: Reaper-X
Password: test123
4. Could the location of mangosd.exe and mangos.conf have anything to do with this process?
As it says it can't find the file in C:\Documents and Settings\USER\, but it is neither there it is located.
It is located at C:\Documents and Settings\USER\Desktop\ReaperMangos4651\ at the moment.
5.
This was the command to find all commands.
select `name`,`security` from `command` where `name` like '%%';
But I cannot find the command to change it.
1. Actually if you want me / other to be able to access your server, you'll need to use that DNS address first (which mean you'll need to also set that one first as your realmlist in mysql) :)
2. Ah that's probably because i'm currently offline because of my connection problem (perhaps you won't believe me, if i'm saying that i pay a lot of money monthly to get an internet connection that can only be used at night although that is a fact)
http://www.reaper-x.com/2006/11/10/telkom-speedy-adsl-access-at-dial-up-speed/
3. Have you tried downloading the sample configuration and compare it with your httpd.conf ? because if php file can't be parsed by the web server that mean there's something missing at the loadmodule section :)
4. Actually i made that one in order for people to adjust the datadir properly (because most of the time they seem to be skipping this step) or else the mangosd process will close immediately ;)
5. You can edit it using this command :)
update `command` set `security` = '1' where `name` = 'addtele' limit 1;
the above example change the security level for addtele into 1 :)
and yes 0 = normal player
hehe I am hoping eventually I will learn what my problem is with all the other comments, but I keep getting confused :S lol.
# Slacker6
Could you tell me what's the problem actually ?
Ok sorry for the double post...but that internet deal is a big rip off lol. And I thought my internet was bad living 50 miles from nearest city. Ok I am going to explain my problem and see if maybe you can help me since your on :D. I set my LANIP in realmlist and inside the MySQL. Opened all the ports in firewall on all computers and networking box. But so far only me can connect to my realm and I have tried everything that I can find. Anything with a 127.0.0.7 or whatever value of numbers to my ip address...something I forgot?
# Muskar
try setting the realmlist address to muskar.servegame.org first, also make sure that currently there's no other software using port 3724 and you've port forwarded port 3724 :)
if you're having problem with port 3724 (someone from UK previously having this problem)
you'll need to open realmd.conf and replace port 3724 with another value like 7000 for example, and then restart the realmd.exe process
forgot to tell you this, i was able to ping your machine using the dns name you've provided
I will try to set it up public and see if you can connect sometime would that be ok reaper?
When i copy the command the error diseppeard but i only get " '> "
The database iam using:
Mangos 4629, ScriptDev2 150 with Silvermoon 18.5 and UDB 0.8 323 support 2.2.3
hope that was all =)
Then I should of course forward port 7000 instead, right?
Ok srry for this off-topic question but.. Muskar are u from Swe?
Darn, doesn't work, still "Unable to Connect" from the outside.
Nope, Denmark, why?
Just wonder im from swe i saw u timezone ^^
#Reaper-X
1. And how was it I did that?
3. Yes, actually, and it was corrected, but now it tells me this when atttempt to start Apache2.2:
(OS 10048)A socket-adress may only be used once. : make_sock: could not bind to adress 0.0.0.0:80
no listening sockets available, shutting down
Unable to open logs
Note the errors or messages above, and press the key to exit.
the <-ø-ESC-ø-> key*
-ø-
does not exit, but I write it for it to undetect the html script form.
Hmm.. when I made the 7000 port instead of the 3427 port as I had before, the server went all down for everyone (no errors in either mangosd.exe or realmd.exe - but still "unable to connect" even for me).
- Hey! I just discovered that I used the wrong port before. It's 3724, and not 3427 - that may have been the last standing reason to make people unable to connect (except maybe for the mysql realmlist settings), but I screwed the server up somehow, so it doesn't matter >.>
I would like to know how I discover why I can't connect to my server.
This is the line in realmd.conf:
# Default RealmServerPort
RealmServerPort = 3724
And as far as I'm concerned, this should be correct.
Nevermind, of some reason it all works again now (for ppl behind my router).
But people are still unable to connect to my server, I will try port 7000 again. If it doesn't work, then I would like to know how to make sure I edited the realmlist in MySQL.
I am really sorry for the many posts in a row in your offline period, but I just come up with more questions..
Changing the forwarding port, from 3724 to something else, makes it impossible to play (Yes, I do change realmd.conf).
1. What if I just added a new port called realmd too, and kept the old one?
Did not work.
2. What if I haven't changed my LAN IP from 192.168.1.13 to 192.168.1.136 as instructed on the MaNGOS forums?
I do not know. I still have the complete same connection to the internet, and it should have some effect somehow.
3. What if I changed the IP address in the hosts-file located in the 'C:\WINDOWS\system32\drivers\etc'-folder under the server I added called muskar.servegame.org from my LAN IP address to my external IP address?
In a way, it seems like a thing to try. But...
First, The tutorial adviced strictly not to put the external address due to unknown consequences.
Secondly, muskar.servegame.org is supposed to represent and replace my external IP address.
And thirdly, I do not know which connections this file has to other programs or applications, so I have nothing to say.
What am I gonna do? I do not know what I can do to change this issue.
Ok I have setup public WoW at. slacker6.no-ip.org. Account name test pass test. If you guys can logon tell me so I know it works. Right now it works on my PC finally but my desktop next to me does not work. But it also has a screwed up firewall. So please post a comment if you can log on. :D Thanks.
Oh wait nvm. I cannot log into game server :(. Any help please?
Reaper are u ever online on ur MSN! i sent u a post threw that but u havnt replyed or anything my problem is basically the same as every1 else's. i dont have a router and i dont have a firewall except the Windows firewall which is turned off. so i figured i didnt need to port forward anything but i forwarded all the ports listed above. im not trying to make my server so any1 can play on it just me and like 2 friends. but if anyone can logon the realmlist is nickswow.no-ip.biz and the username is a and the pass is a. if anyone can login u r welcome to play but i will have to make u another account. reaper u can reply by Email which is Nicholaspugh@yahoo.com or post here but i really need some help please.
~~NOTE~~ is a dsl box a router. im not sure if it is or not??
LOL u nub, yes most DSL boxes have routers in them. wwww.portfoward.com is your friend, it probably has a guide for your exact router, look it up.
# Muskar
No problem actually :)
as for your question, btw after you changed the realmd port into another value (in this case 7000) did you also change the realmlist.wtf to use that port ?
for example, right after editing the realmd.conf to use port 7000
you'll also need to change the realmlist.wtf to use your new port
for example muskar.servegame.org:7000
that's it :)
>> Secondly, muskar.servegame.org is supposed to represent and replace my external IP address.
Actually you'll need to use that one if you're going to allow people from the internet to connect to your server or else they'll stuck at the connecting to xxxx (i assume that your firewall configured to allow access to that port)
>> make_sock: could not bind to adress 0.0.0.0:80
no listening sockets available, shutting down
If apache can't bind to port 80, i'm sure there's other program running in the background use the same port 80 too
the solutions to the above problem are (choose which one you prefer to use) :
1. Close the program that use port 80
2. Open httpd.conf and adjust apache to use another port for example 81
# Slacker6
Sure no problem i can try joining your server :D
# NickPugh
Unfortunately i rarely use IM program (and haven't used msn since ... erm .. i can't remember it exactly lol)
btw i can ping your computer without problem, and if you're still having the same problem try looking at my answer to Muskar question :)
# Slacker6
What is your excact problem? It could be anything.
Is your realmd.exe running, is your mangosd.exe running? Are they telling you any errors? Is your realmlist.wtf adjused correctly? etc.
Please tell me the excact problem and what you did, and please if you have an error, look at the error log and tell me what it says.
sorry, didn't see your reply, Reaper-X
and thanks for the reply.
1. I just did the following:
>> Port Forwarded port 7000 for Realmd.
>> Adjusted my firewall to give access to port 7000 TCP and 7000 UDP.
>> Adjusted realmlist.wtf to
set realmlist muskar.servegame.org:7000
>> Adjusted realmd.conf to
RealmServerPort = 7000
It's still not working, what did I do wrong?
2. I would like to announce a few things that may have something to do with this.
My DNS host is configured to do the following:
> No, do not alias "*.hostname.domain" to same settings.
> Host with IP address
> TTL: 60s. Default dynamic DNS value
(I do have a dynamic external IP address).
Is this somehow incorrect?
My LAN IP address is not automaticly configured, I use a manual and static IP address.
This couldn't have do a difference since I adjusted every setting about TCP/LAN IPs I know to this manual address, could it?
3. I adjusted these lines:
Listen 80
AND
ServerName localhost:80
to
Listen 81
AND
ServerName localhost:81
I hope this was the correct lines.
EDIT OF LAST REPLY:
1. There was some serious progress. People can connect to my server now, but it doesn't come further than 'Logging in to game server'.
Any ideas?
could you tell me what did you set your realmlist address to ? (in mysql) is it muskar.servegame.org ?
btw to make things easy, try disabling firewall first (you can adjust that later when you're sure that people was able to connect to your server) :)
and then run the realmd.exe and mangosd.exe process and tell me when your server is ready
EDIT :
btw when i try to connect to your server using
Reaper-X (user)
test123 (pass)
i get the invalid message
as for the apache httpd.conf ... yes .. that's the correct line :)
My firewall is now off.
The Reaper-X account I made was deleted during the change from Silvermoon to Unified, where I forgot to restore character data after installing.
It is now created and mangosd.exe and realmd.exe are running.
I asked previously how to check what I adjused mySQL settings to, but I got not reply.
Hello again....
I didn't get any reply from my post =(
- A sidenote:
Apache is now working successfully with the new port settings.
When i copy the command the error diseppeard but i only get ” ‘> ”
The database iam using:
Mangos 4629, ScriptDev2 150 with Silvermoon 18.5 and UDB 0.8 323 support 2.2.3
hope that was all =)
Is what you wrote.
And he asked what the error was.
# Reaper-X
ROFL, I see it in this very guide >.>
use realmd
update `realmlist` set `address` = ‘muskar.servegame.org’ where `id` =1;
I'm very sorry q: so it was that I should adjust it to, right? or 'muskar.servegame.org:7000'?
YAY WTFPWN it works =D
Glad to know that your server finally accessible from the internet :D
and you need to use muskar.servegame.org only in as your realmlist address (the mysql one)
>> I asked previously how to check what I adjused mySQL settings to, but I got not reply.
Which one ? the update command ? i'm sure i've replied to your question :)
# Fladdy
Could you tell me what's the error message actually ? btw if you mean that you got mysql> prompt instead of success or similar words
that is usually caused because you didn't use single quotes when inserting the sql query :)
p.s if you use my mangos release, you can just use reaper-x-mangos.bat and choose option #5 to edit your realm name and your realm ip
I can adjust teh realm for LAN and that but... so u mean that i can choose 5 wich is for Conf LAN i can make it public there? i can make a LAN but not so my freinds outisde can join
actually adjusting lan and internet basically is just the same with the exception if you're planning on creating public server :
1. You'll need to set up some port forwarding
2. Adjusting your firewall to allow access on the port specified in mangosd.conf and realmd.conf
3. Set your realmlist to use your dyndns address or your static ip address (public / external ip address that is static) :)
Nothing works i can't make it online i can make it LAN but not public so my freinds can join =(=(=(
first you need to tell me have you set up port forwarding to allow TCP / UDP to port 3724 and 8085 ? because that's the most important thing to do before anything else (even if you set your realm address correctly but if you didn't set up port forwarding ... then no one can connect to your server)
and then what is your dyndns address ?
Ok I have done everything from what I can tell with what Muskar did. But when I go to connect I cannot even connect. I have changed internal DNS
-->
127.0.0.1 localhost
192.168.1.102 slacker6.no-ip.org
Is that correct? First line was there and the first part is my LAN and second is my DNS. I have yet to check if people can log in. So
User: Jorden
Pass: jorden (case-sensitive)
Someone tell me if you can log on I may loose internet off and on today but my programs will be up :S I will continue trying to figure out my problem but hope someone can help me first :D. Currently I just cannot connect and have to try on my other PCs. Have opened all ports and changed port forwarding and have set realmlist slacker6.no-ip.org:5000.
# Slacker6
I can't even ping your pc :(
I got mine up and working finally, took some great time.
New question:
How do I create a new realm where TBC isn't allowed? (detailed answer would be nice).
Fortunately .. i have created a guide on how to create 2 realmd :P
Dang you can't ping me. Now that bites :(. Ah I guess making my own server wasn't meant to happen for me yet.
# Reaper-X
Remember saying this?
4. Actually i made that one in order for people to adjust the datadir properly (because most of the time they seem to be skipping this step) or else the mangosd process will close immediately ;)
I didn't really understand that.
So I save the mangosd.conf file and then I go to Reaper-X-Mangos and pick option number 4 and set the same values as I just did, and it should work?
gah im haveing toubel.. my friend cant connect.. i run the server threw hamachi.. told him my IP he copy/paste into his realmlist and did everthing my friend did on his server yet he cant connect... i dont know how to forward IP's or anything.. maby my pc is blocking it.. but i turn off my firewall and still he cant get through
ok i messed something up im not sure wht but i cant start mysql now i changed a port from 3306 to 3307 by accident and i exited out b/c i needed to get some sleep last night. i will post when i figure out how to fix that
I port forwading thoose 2 ports that u tell and Msngos.exe and realmd.exe are allowed but i seen that everyone has like 7000 or 500 at the end of their realm my is fladdy.no-ip.org
i can't make it works but if u wanna try.....
WOHOHOH it's working :D:D:D:D
i have a question
my server works and everything but when my friend trys to log in on the ip he logs in succes! but when he goes to the sellect realm...he clicks on the realm then the server thing comes back on and i have realmd and mangos running?? plz help?
# Slacker6
I can guess that something / some software on your computer blocking echo requests (ping), and since ping is blocked i can safely assume that it'll block any other thing as well :D
so i'd suggest you first to :
1. Check your router configuration, and see if you allow ping request or not (most router plus adsl modem nowadays has firewall built-in)
2. check your software firewall configuration (windows firewall, or other firewall)
# Muskar
Actually when you choose option #4, you'll get the mangosd.conf file and if you'd like to adjust it manually you can always open that file directly :)
# Fladdy
That's why i said that port forwarding is the most important of all ;) unless :
Your computer is connected to the internet directly (dial up connection, or cable internet that is connected directly to your lan card) but if you're using ADSL connection then you'll need to set up port forwarding first (most of the time unless you set bridged mode in your router or set a DMZ)
# JERRY
That problem usually appear if your friend didn't use the same Realmdlist address as specified in your realmlist table (mysql)
for example (if you want to reproduce this from LAN) :
you choose option #5 on reaper-x-mangos.bat, and set your realm address to 127.0.0.1
and your friend from LAN try to connect to your server by putting your LAN Ip address in his realmlist.wtf file (for example 192.168.1.1)
he'll be able to connect to your server ... but .. he'll be stuck at the login / realm selection forever
unless, you changed the realmlist address to 192.168.1.1 :)
Thank you Reaper-X for the guides, they are put together well, kudo's and gratz to you.
Also thank you Prowler for your pic. without it i could not set up MySQL correctly. i kept using `id` =1; at the end, then saw yours was `id` -1; and that did the trick. I don't knwo why, but it worked.
Absolutely great instructions and content throughout the site, thank you so much for all your hard work and effort!
I changed in realmd database to 7000 instead of 3472 or something like that and added that to my realm and i worked =)=)
it says "access denied for user" (using password ??
Your guide is clearly set up thanks but i have a problem when others try to log to my server through lan/ip it says connecting to server and brings up the servers you click on the server then it will say connecting to server again and it will loop forever
Thanks again reaper i got this to work with pretty easie and me and a couple of frends have been playing so keep up the good work :)
Well..a little question from me to...cause I've tried to make this work for 2 days, and just got the little mistake I've been making...now it works....but..if i want to make some modifications to the server...like to modify weapons or stuff....how can i do that?
Or where do i find the item id's?
# Reaper-X
Just thought that I'd leave a comment thanking you for such a great and simple guide. It can't be put any simpler than how you did it. You really are good at this kind of stuff and showing others how to set things up. Do you do something similar for a career? If not you should! :)
I've tried doing 2 other guides before I came across this one and I'm glad I found yours :).
After going through your guide and being successful at getting my server up and running for LAN I went back to the other 2 guides I was trying to use and found that they were missing a few steps which led to many errors, which is why they weren't working. Thanks to your guide I have a pretty good understanding now how servers work, Thanks!
I was wondering if you could email me or post on this thread an answer to my question, which some others might be wondering as well.
First I'll say this: Me and my friends are playing on LAN which works great. We like to play WoW normal (like you would on Blizzard's server). The prob is we can't get together frequently enough. So I was going to set a server up on each of theirs so that they can level whenever they could and then LAN our servers together for group quests. What I was planning on doing is "jumping" our characters onto one of the servers when we wanted to LAN, then "jump" their characters back onto their servers when we were done. This is possible because I know that the GM's on Blizzard's servers do this somehow. I was just wondering if you knew of a way or if you could find a way for me since I've been looking for a way for awhile now. Thanks in advance! Your comments that I've read so far are really clear and helpful.
# Ok this part is for anyone having problems connecting:
First of all if your friends can connect and you can't (if your trying to play wow on your sever) that's because you can't. Correct me if I'm wrong but once you change your IP so others can connect you no longer have the loop-back IP .
Clarification:
'127.0.0.1' is your loop-back IP if your playing wow alone WHILE using the same comp as your server. (I don't see how no one gets this... read Reaper-X's guide carefully it makes sense). Once you change this IP to allow others to use your server threw LAN, WAN, online, or something else you CAN NO LONGER PLAY WOW ON THE SAME COMP THAT YOU ARE USING AS A SERVER.
LAN IP is the IP you change your realmlist IP to and your realmd.wtf file to. You also have anyone connecting to your comp change their realmd.wtf file to that IP address. Through a router or online is the same way, but you use a diff IP as said in Reaper-X's guide.
Also, if you are getting errors (I've seen a lot of posts mentioning errors being received) that means you did something wrong in one of the steps. I would know cause I too had these errors (In previous guides before this one, only had one in this one) and based on what I've read I had and was able to fix them. So far every error I've seen posted here I know how to fix... but I don't have the time to answer them all. Most off them are as simple as back tracking your steps through the guide and seeing what you did wrong (these are simple mistakes).
For people having a connection problem on LAN disable your firewall (all of them if you have more than one on your pc) and the people connecting to yours and see if that helps. If it works re-enable your firewall and check for blocked ports.
I'll help answer more problems later but what I have said should help most of everyone out since it seems these were the most common posts. Sorry if I can't answer them all or be more specific or detailed since it would make this already long comment way to long.
How do I change my server's name?
I'm back with a prob i ahve not seen on the site yet Reaper, so i hope you can help or anyone else out there.
I can log on the server fine with my firends, i am hosting btw. i opened the server up to a freind today to he can play, and after 30min to an hour Mangosd encountered an error and had to shut down. we are useing 4651 w/o the bots, and useing the project silvermoon database. it will do the same thing on the unified database also. i did just port forward 1400 nad 1401 to see if that will help, so i am waiting on that reult. if you ahve any input ata all, please e-mail me and/or post it. I will greatly appreceate it.
# Zenn
Thank you very much Zenn :)
as for your question, the only method i can think of is of course by simply creating backup when you're going to shutdown the server and send it to your friend email address ... and restore the data from your friend computer
but of course in order to do this, your friend also need to set up the mangos server and the mysql server itself :)
# Dhomeli
If you're using my release you can use the reaper-x-mangos.bat to adjust your realm name :)
# Vilexan
Could you tell me what is your operating system ?
i must ask this but what steps wuold you go through on your friends computers so that they could conenct with yours?
btw could i get some help on port forwarding as that guide doesn't make any sense to me plz?
unfortunately i can't help you on setting up port forwarding on your router because every router use different configuration page :(
i'd suggest you to look at your router manual directly or try visiting portforward.com :)
by all means these should be my last two questions:
how would you go about setting up your friends computers to connect to your server over the internet, as the guide only explains how to make you own computer accessible.
and
if you set up the server, can you connect to the game and play it as a GM from the same computer?
# Reaper-X
Lol that's the same thing I was thinking of... the only prob is that all of the characters get backed up. Then when you go to restore you'll over right the current characters on that server. Is there a way to restore portions of the backup characters without over righting? I haven't tried it yet so that's why I'm asking. Thanks for the help and fast reply! :)
# Zack
I mentioned the solution to your problem that you seem to be having and most others in my one and only bulky post just a bit above yours. I guess I'll just have to repeat myself.
First of all to have your friends connect all you have to do is have them or you configure their IP in their realmd.wtf file to your servers LAN, WAN, router, or online IP (whichever one your doing).
Example: I'm using the LAN connection so all I had to do is type ipconfig in my command prompt window to get my LAN IP. I then took that IP and entered it in on my realmlist IP and I also edited my realmd.wtf file to this IP. You can see what you have to do by reading Reaper-X's guide. All of what I have just said is in his guide but put a different way using pictures and text.
To answer your second question, that I know of, you can only play wow on your comp and use it as a server if your using the loop-back IP. The loop-back IP is 127.0.0.1, if you change this IP to your LAN, WAN, router or online IP you can no longer play wow on your comp (no matter if your GM or not) and use it as a server at the same time. Hope that helps! :)
thank you very much zenn, you be very smart and i hope reaper-X appreciates your help as it is very good
# Zack
Lol thanks, I'm just trying to lend Reaper-X a hand at answering some of these posts as a way of paying him back. He's put a lot of time into making his guide easy to follow and understandable and and he's posted a lot of helpful posts as well.
# Zack
thank you very much zenn, you be very smart and i hope reaper-X appreciates your help as it is very good
Of course :) i always appreciate anyone who like to help others to solve their problem ;)
# Zenn
Well you can do it easily using this command (type it from the mangosd prompt)
writepdump outputfilename your-character-GUID
and it'll produce file that can be restored using :
loadpdump inputfilename account-id
to restore the data to the account id specified
but please remember that by using the loadpdump command you'll not overwrite the previous character data but it'll create a data based from your dumpdata and insert it as new GUID
that's it :)
oki so connecting to the computer over the internet is as simple as changing the other computers realmd.wtf so it reads my external ip address?
Reaper,
i am using windows xp, i will be using vista as soon as my laptop comes back, but teh game, sql, and mangos is all on a 250 gig external hard drive.
here is another problen for you. this might be progamming side of mangos though, if you enter orgrimmar through the front and getto the bank as if you are going to the hippogryph master, you get teleported to an unknown area, i think it might be programmers or gm island.
also, everytime i run the server and log on to my toons, i have to re do the tool bars, some ofthe spells delete them selfs from the toolbars.
Thank you again Reaper. Much appreceated.
# Zack
Yes, it is as easy as that. :)
If you have any problems connecting after doing that it's most likely because some of your or their ports are being blocked. If you drop ALL of your firewalls (some comps have more than one firewall on them) and have the people connecting to your comp drop ALL of their firewalls this should fix the problem. If this does fix the problem find out what ports are blocked and open them and then put your firewall(s) back up. Same thing goes for whoever is connecting to your server. :) Hope that helps!
#Reaper-X
Thanks very much! I'll have to give it a shot! :)
#Reaper-X
lol I gave it a shot and when I type the commands writedump or loaddump it tells me "Unknown Command". All of the other commands under help are working that I know of. I went through and tried a few just in case and the ones I tried worked.
Do you know why it is doing this? For some reason its just these two commands... Im stumped. Thanks.
#Reaper-X
I discovered the error myself.
It was due to the fact that I typed the following in the motd (line 282):
Motd = "Welcome to Muskar's Private WAN Party Server.@Type .commands to check which commands are available to you. Enjoy your stay."
The error here was the ' I used as ownership, not a quotation.
Anyway, I removed it and it all worked fine.
Thanks in advance.
zenn it worked better than you said... i can use the server from the same computer! and i have someone from seden playing lawl
#Zack
I'm glad its working for you. :)
Well it is possible to play WoW and run your server on the same comp at the same time if you follow Reaper-X's guide on how to set up two realms.
Well let me rephrase myself then, I could be wrong but I thought once you removed the loop-back IP and inserted a different IP such as a LAN IP that you could no longer play WoW on the same realm as your friends while running the server on the same comp at the same time.
I'm curious can you see your friend that is playing on your server who's playing from seden?
Maybe the online IP works differently than I thought. I know that isn't the case for the LAN IP though cause I've tried playing on the same realm as my friends connecting through LAN IP while I was on my server and it doesn't work. The reason is because I've got that realm set up for the LAN IP and not the loop-back IP which keeps me from connecting.
I've even tried connecting to the realm set up with the LAN IP using the LAN IP on my server in the realmd.wtf file and that still doesn't work. So I'm stumped if you can actually do as what you said your doing and can also see your friend at the same time.
I'll have to try it again to see if what your saying is true the next time I LAN with my friends. If I'm wrong I apologize for misleading everyone.
well iwasn't using lan i was usingdyndns hosting thingmy and putting that into my realm.wtf
iwas also using reapers other magons guide thatisn't in thisfour step guide
http://www.reaper-x.com/2007/10/29/reaper-mangos-4651-scriptdev2-151-with-project-silvermoon-and-unified-database/
the mangos package in it is verygood
oki i must know HOW in the hell can you play music over your wow private server?
Well, I have read every post made, installed as per instructions 3 times now, spent the best part of a whole day trying to get other pc's on the lan to connect, tried dropping firewalls, opening all ports, special rules to allow ip's on lan to connect to all ports....
Still cannot get the other 2 lan pc's to get past the realmlist loop... keeps going back to select realm again n again n again.
Reaper, all due respect to you, you have done a fine job, but could you offer any solution, maybe advice or link to an emulator that is workable.
Thanks
missed a bit above.. in the realmd.exe I can see the other lan pc's connect/authenticated, but then nada. yes I am behind a router, and am pretty sure the ports are forwarded correctly,
Im sorry for late reply because i've been preparing for my next mangos release (it's already released now) and using 4703 core :)
# Zack
you can type .playsound but ... only you can hear that :)
# Slap
could you test by yourself to look up if port 3724 (if you didn't change it) are accessible or not by doing online port scan from below link :
https://www.grc.com/x/ne.dll?bh0bkyd2
some people having problem with port 3724 got stealthed, and if you do experience the same problem then you need to change the realmd port from 3724 into something else (7000 for example) in realmd.conf and don't forget to port forward it too ;)
p.s if you change the realmd port into another value other than 3724 you'll need to use :
xxxxx:7000
in your realmlist.wtf file
hey, when i write in cmd the line "update 'realmlist' set...."
i get "error 1064 :you have an error.."
can u help me here (btw if u answer plz write how to fix it as simple as u can, if u know what i mean)
sorry for the bad english.
thx :)
Hello dear Reaper-X I have set up an angos-4629-scriptdev2-150-with-silvermoon-185-and-udb-08-323-support-223
I followed the stepps and all i am able to log into my MySQL and all. I started it 127.0.0.1 in mysql and i made an account and when i enterd wow it get "Unable To Connect"
Why does it do that please answer me on mail or msn (email adress is msn too)
ok,i already set my port to 3724 and used my dns name in my realmlist.but my friend still cant connect to my server :(
Well, i have now done everything i now, and i cant still get this problem solved, so hear me out. ok.
i try to do my server public, (just if friends could log in) i have tried everything of your advices, but nothing seem's to work.
i dont use router, is it needed? i have tried both ways, for local network and accessible from everywhere, but nothing work's, i have my LAN IP in address spot, in realmd realmlist. port is setted up 8085, and i call my server Perkeles. i can log in just fine, and everything works, no crashes, but my friends cant log in,
i have made them accounts, but it say's "unable to connect" i have tried taking out my firewall, but it doesn,t help.
(in my mangos, realm, and mangosd are setted to ""127.0.0.1;3306;root;xxxxxx;realmdmod"" should i change something there?)
The problem that makes you can connect and other people not are that you havent changed the realmlist in mysql to your hamachi or lan or net ipadress
hm..i still having the problem to open for internet...my friend still cant join...ok,what i m done now is...i used my lan ip in my wow database realmlist,and my fren using my public ip address.2,configure the foward port START 3724,END 8085(isit correct?),and i need to rfill in the Local Ip address....what is the local IP address?cos is required...thats mean i only have 3 column i need to fill in my router port,start port number,end port number,local ip address...just i cant understand how to fill in 3724 and 8085,and local ip address.pls help this.Ok now,in my prompt window,when i trying to type in (UPDATE `reamlist` SET `address` = ‘′ WHERE `id` =1;,is always show me '>,`>,or...error...so i know at the moment i m using my lan ip address for mysql when i check (select * realmlist;).Isit the same thing when i set my IP address at the reaper-X-Mangos at (5)?.ok last,change the Host Ip and dns name,i already register a new host name and i m using my public ip address,so i m suing my public ip and my dns name in my Host(the thing inside the system 32\driver\host\etc),but when i trying to write my public Ip in my host there,i saw the Ip 127.0.0.1 localhost in there,should i delete it or just write under the localhost?ok this is what i m doing for connect to internet,but it wont work....i know i m making some mistake in the step....Pls correct for me,the step,what IP,Port no should i use in what column,and everything what i done,Pls correct for me...thx alot..
Correct:
UPDATE `reamlist` SET `address` = ‘′ WHERE `id` =1; for Public internet connecting.(if for pulbic,should i use the Lan ip or public IP?)and continue to the previous msg..thx.(after type in is show me '> or `> or erroe bla bla )
Ok, i believe i have set up everything perfectly, but because i can't connect PERIOD i obviously did something off...
if you have anything to help solve this, things to check, if you've had this problem that would be sooooo sweet! i'm open to anything and everything i'm soooo dying to use my server!
Actually to be more specific so i get better answers, turning off firewall doesn't help, and i do have the ports, etc... i have it to my physical address, which is under a dydns which is in my realmlist... i can not access it on another computer, my friend who has also changed realmlist to my dydns can not connect... my question really is do i do something to get wow to recognize my server? what, cuz u guys=smart and i=dumber =P
please reply, even if its a little statement it could help a HUGE bit, for me and others
i just check my public ip address again and it change...why my public ip address always change?
# solixes
Ah you'll need to use your public ip .. but before that, i'd suggest you to check your router setting first :) ... because even though you've put the correct address, but if you didn't set up correct port forwarding .. people won't be able to connect to your server
and if you're using dynamic ip address, then you'll need to setup a dyndns address first so you don't need to tell your new ip address everytime :)
# Error!
I'm really sorry for late reply, because if there are many questions asked at once (in different post) i often get lost lol
as for your question, first i'd suggest you to check your port forwarding setup first because you'll need to configure that one first (since different router has different configuration page, i can't really tell you on how to configure it manually, i'd suggest you to look at your router manual instead)
and no, even if your firewall has been turned off, but if you didn't properly set up port forwarding on your router, people still won't be able to connect to your server :)
Thnx for reply and it was right on time =)
i will try the port forwarding soon so cross your fingers...
"Gustaf | Nov 13, 2007 at 23:00 / 11:00 PM |
The problem that makes you can connect and other people not are that you havent changed the realmlist in mysql to your hamachi or lan or net ipadress"
i have changed realmlist in SQLyog program,(realmd realmlist) to my LAN IP, but do i need to change my lan ip to somwhere else too? (do i need to reconfigure MySQL server 5.0 as well?)
sorry to comment again...but i believe theres only one more error to get past!!!! wooohooo =)
anyways, when i try to login i get the message
"Unable to validate game version. This may be caused by file corruption or the interference of another program. Please visit http://us.blizzard.com/support/article.xml?articleid=21370 for more iinformation and possible solutions to this issue"... i dunno why that popped up, its probably some noobish error, but ya if you have any suggestions that'd b sweeeeeeeet!
Ok,i had successful 50% for my internet connection,now my friend can connect to my server,but he stuck at the REALM,he cant pass over here and cant create a character....but for my self i can log in and play well...what is the problem now?
Hello dear Reaper-X I have set up an angos-4629-scriptdev2-150-with-silvermoon-185-and-udb-08-323-support-223
I followed the steps and all i am able to log into my MySQL and all. I started it 127.0.0.1 in mysql and i made an account for me!.. and when i enterd wow it get “Unable To Connect”
Why does it do that please answer me on mail or msn (email adress is msn t
Hey reaper... my "other computer" by using Public Server... can connect until reach the server selection.. after that... i select the server.. and it keep asking and asking...
any tip?
Thanks...
Cant**** Sorry for bad english
Ok,in my router to forward port has port start and port end,so i need to use port start at 3724,port end at 8085?or just use 3724 on start and end port?2nd question is for my firewall setting,in my fire wall exception i already edit port for WOW and port number 3724 to allowed the other connection to connect to my server,so do i need to set another edit port for 8085 WOW in my firewall setting?As lke i lsaid previous i can connect to my game well,but my friend is stuck at the realm,he cant log in to realm,but he can access to username and password,but after log in just stuck at the realm...cant creater character...keep jumping out the realmlist,what should i do now?thx for the help :)
Oh yea,and what is Local Ip address?Cos the port forwarding is required LOCAL IP ADDRESS,so is my Lan IP,Public IP or Router IP?Atm i am using Lan IP(192.168.1.1)for the Local IP address column..isit correct?
Reaper or anybody else,
After writting the ip address to the db, next you verify it was written.
I can't see it too well but what is the character between "select" and "from realmlist ;"?
nm regarding my previous post. Had to take the time to look through these comments to see a screeshot reaper posted on imgshack regarding verifying db ip
it's
select * from realmlist;
# Sephy
Have you set up port forwarding first ? btw are you trying to create public server which is accessible from the internet or from lan only ?
# Gustaf
If you get unable to connect message usually that caused by some program interrupting connection made to port 3724 .. btw could you tell me are you trying to create public server or private server ?
# solixes
Could you try visiting below link first ? (it's an online port scanner) and also make sure that realmd.exe process and mangosd.exe process already running (and you're currently playing on your server before testing it)
https://www.grc.com/x/ne.dll?bh0bkyd2
and see whether your port 3724 stealthed or not :) .. if it's stealthed that mean you'll need to change the realmd port into another value
# Brinuz
Realmd loop usually caused by inproper address used from your client :)
and based from your description it seems that you currently use your public ip address as your realm address, and want to make connection from another computer inside your lan
all you have to do is just :
open the windows host file (C:\Windows\system32\drivers\etc\host) using notepad and add these line at the end of the file
YOUR_LAN_IP_ADDRESS YOUR_DNS_ADDRESS
for example
192.168.1.1 mycoolwowserver.no-ip.org
# Kage
Yep that's correct, btw if you're using my mangos release, all you have to do is just choose option 5 on reaper-x-mangos.bat (it'll show you the verification too) ;)
okey. now i try to make a server accessible from anywhere. okey done so far.
i created my own "address" Dyndns.com with my PUBLIC IP.
i putted this DNS address (perkeles.servegame.org) in to my realmd-> realmlist. in my SQLyog,
i think it does same thing, than mysql -u root -p in CMD window (btw i cant do it in CMD)
so realmlist is fine.
i Opened C:\Windows\System32\Drivers\etc\hosts
in notepad, and putted there:
MY LAN IP perkeles.servegame.org
(lan ip in CMD window, ipconfig)
i have now opened totally 3 ports, 3724, 8085 and 3306 and nothing helps, i opened my router ports with this guide:
http://portforward.com/english/routers/port_forwarding/Telewell/TW-EQ-501/World_of_Warcraft.htm
it's telewell router guide. and i use telewell.
i can log in just fine, but my friends cannot.
it always said's "unable to connect"
my mangosd.conf and realmd.conf are setted up by 127.0.0.1 (there is root and password)
can that make a difference?
i just now cant say what is the problem, i have tried closing my firewall, but even that didn't work at all, (i use avast) can somebody solve this problem?
-Sephy the unlucky
PS.
does it do anygood if i try downloading navicat or apache?,
i got MySQL, SQLyog, Mangos, and your reaper updates,
-Sephy the unlucky
yeap dude.. i already did that before.. but it stills the same.. ;(
Hey Reaper, How do I know where is my realmd database?
I have a lot of trouble trying to find it...and that's the only thing that's not working with my server creation
# Sephy
my mangosd.conf and realmd.conf are setted up by 127.0.0.1 (there is root and password)
can that make a difference?
actually that one is used to connect to your mysql server and you don't need to worry about that ;)
as for navicat, or other 3rd party client actually that's depend on whether you're going to do some complex stuff or not ;)
btw could you try visiting below link (online port scanner)
https://www.grc.com/x/ne.dll?bh0bkyd2
to see whether you have port 3724 blocked / stealthed or not
# Brinuz
Could you try ping your realmd address from your other computer and see whether it display your public ip address or your lan ip address
# Juan
Are you using my release and didn't change the database name ? if so .. all you have to do is just run reaper-x-mangos.bat and choose option 5 to configure it :)
https://www.grc.com/x/ne.dll?bh0bkyd2
i looked my 3724 port and it's stealthed, so i need to unstealth it right?
is there any guide to do it?
or do i need to do this on my own?
btw, thanks for help and a great guide :)
# Sephy
If you see it's stealhed probably there's blizzard updater running in the background (because blizzard use p2p network to distribute their patch and use 3724 as the default) unless you disabled it complete of course :)
the solution to fix it other than disabling blizzard updater completely, you can just change the realmd port into another value, for example 7000,7001,etc
all you have to do is just open realmd.conf using notepad or wordpad (if it's show you a loooong line without line break then you need to open it using wordpad) and change 3724 into something else
but please note, if you change the realmd port into something else, you'll also need to tell your users / friends to use that port in the realmlist.wtf file
for example
mycoolwowserver.com:7000
ok, but i dont need to change my DNS "address"?
(perkeles.servegame.org)
so i just type in realmlist:
perkeles.servegame.org:9000 (if i use port 9000)
and change realmd.conf file this line? ->
# Default RealmServerPort
RealmServerPort = 3724
to
# Default RealmServerPort
RealmServerPort = 9000
and tell all my friends to change realmlist file to:
set realmlist perkeles.servegame.org:9000
:) (this is for everybody else how has problems, with router) thank you, once more reaper! :D
i tried and it didn't work.. =/ i changed those things and, -_- "unable to connect"
(i tried even using to port in SQLyog but it didn't help either.
i tried withport 9000 and port 7000..
is there i way to disaible my blizzard updater completely? =(
-Sephy the real unlucky
I Am stuck in the same part... worked for lan but didn´t for incoming connections... didn´t even worked for me when i changed dns
I found that the hosts file is not in C:\Windows\System32\Drivers\etc\hosts is that a problem?
# Sephy
erm ... after you changed the realmd port into the new value .. did you also set up port forwarding for it and also reconfigure your firewall to allow that port (if there's any though the most important part is the port forwarding) :)
and if you're sure that you've opened your port correctly try running the realmd and mangosd process once again (with the new port value) and see whether it's still stealthed or not ... basically if you've changed the port value and still got the same stealthed message or blocked that mean there's something else blocking incoming connection
and btw you don't need to change anything in the database using SQLYog or the command line, because realmd port is defined in the realmd.conf (that one in the database is your world server and it's better to leave it at the default value 8085) ;)
# zekiel
Incoming connection doesn't use your host file actually, because they query the dns server directly (or connecting to your ip address directly)
before doing anything else, i'd suggest you to check port 3724 to see whether it's stealthed or not, look at my previous comment on how to do it :)
I fixed it... thanks man, great guide, very usefull, I now have 4488 running prefectly, but... can i upload to the newest or I have to make a fresh install of it? thx again reaper
my friends still can't connect?there only reads: Connecting...it's stuck on that..
i can connect, but they can't, help me, i did do everything what did u said on this guide!
Giving help now actually :P
You could also just like use...
reaper-eazy-mangos.bat
in reaper-eazy-mangos folder
(If your using latest version)
hehe
(If im right btw, i dont know for sure i just think so because it has an option to set the name, and to set the ip address, and these things!)
Correct me if im wrong
Dudethatneeds(gives here)help.=p
Hi, I was playing on my private server then I had to go do something, and when I came back I tried logging in and my characters were gone. I can't make new ones either. Anyone know how to fix this?
It's an internet server by the way.
I'll be more specifc, when I tried loading up the server it said, SQL ERROR: Table ' .\characters\character' is marked as crashed and should be repaired. Then it went on with loading the server and I still can't make a character. Do you know what to do?
Hi! What about version of your patch: 4703 custom?
- Third :
What do you mean? I did an account and a host szyszchlun.no-ip.biz.
- Fourth:
use realmdmod
UPDATE `realmlist` SET `address` = 'szyszchlun.no-it.biz’ WHERE `id` =1;
What about realmd.exe? There is Database: 127.0.0.1. How to change it? I did Update and everything what i should. Thanks.
P.S
Sorry for my English. I'm from Poland:)
thx for the guide it was Great worked out well! just one problem...when i run ad.exe in the root directory it says error and i ignore that and all but no maps folder shows up when its done...tell me whats wrong plz and to be more specific the error says somethin like (error patch-2.mpq) idk what it means but the maps folder wont show up
Still not working -_- i know now that my port is stealth, i have now, opened that port everywhere. but still not working..
C:\WINDOWS\system32\drivers\etc --> host,
there is my Lan IP and my DNSDomain:
192.******* perkeles.servegame.org
should i put my port ther too? like
192.******* perkeles.servegame.org:65535
(PS, i have 2 computer in my home, using same network, can that make a difference? do i need to open something at my other computer?)
-Sephy the unlucky
I can log in fine to this, but when i use adifferent computer in the house or a friend tries to log in, they cant. help
I have same problem that u have colin =/
But i think my router is "my problem", it wont open ports -_-
# gamefreak
Ah .. usually patch-2 (in any version of wow) gets deleted automatically when you just upgraded to major vesion such as from 2.2.3 to 2.3.0 or 2.1.3 to 2.2.0 back then and automatically appear again when there's minor upgrade :)
which mean ... you're currently using major version 2.3.0 or 2.2.0 which is not supported yet :)
# Colin
Since configuring port forwarding different on every router i can't tell you on how to do it (i'd suggest you to look at your router manual)
# Sephy
Won't open ports ? then i can guess you're using a defective router because every router allows you to set up port forwarding
are you sure you've checked changing your port (anything above 1024 or above 5000) and then run the realmd process and later set up port forwarding for that new port
finally check your new port to see if the new port also stealthed or not ;)
i have now tried couple of ports xD, 7000,9000 255, 65535, and now is 4488 :D
(every port seem's to be in stealth mode, EVERY PORT)
http://portforward.com/english/routers/port_forwarding/Telewell/TW-EQ-501/World_of_Warcraft.htm
that's the guide i used for opening my port
i have opened ports 2 ports there, 8085 and 4488 (4488 is what i use now.)
i've stopped my firewall's like 2 times, (didn't work) (i use avast)
then i used just windows firewall, and used a guide for that too, (nope, didn't work)
always says "unable to connect" i think it's my router =/ do you know any good programs to control ports?
(i tried one on PortForwarding.com, but it didn't help me, there is no telewell router, in that program)
my router is Telewell TW-EA501 ADSL modem.
Tell me if you can help me :P
this is a major problem to me. thx for all help, in advance.
-Sephy the unlucky
ok Reaper, i get Unable to connect when trying to get in on my lan, my sister wants to play on my server, everything else is fine, outside users cna get on i have my dns setup the server installed etc. but when she trys to get on it says unable to connect.. can u help me please..
all my friends from the US & UK can connect with my realmlist. but hers wont, i have edited her hosts file to include a doze ips, internal and external and none of them allow her to get on. my connection is useing 127.0.0.1 as im the host of the server on my pc with wow. she has her own pc..
we use a wireless netwrok and all computers share the same ip adress ( external ) i have DMZ setup aswell as all ports open
but i still cant figure it out .. can u help me plz..
O im useing mangos 4703 and patch 2.2.3
sry for my lack of knowledge, but what do you mean, what should i do with the port fowarding manual?
I forwarded the 2 ports you said to and the 1400 and 1401 that David suggested, but it still doesn't work
do we do TCP or UDP and port forwarding
and when my frnd connects he says the realmlist keeps popping back up
ok now my fnrd can connect but i cant???
#bAnKs
Did you do what reaper said about connecting to the computer thats running mangosd and realmd?
or i should say, playing on the computer thats running mangosd and realmd
i have made a list of what i think can be wrong, (i'm not sure about them so, please correct me)
i have 2 computers on my home, they use same router/modem, can other computer, or it's firewall be the problem?
when i run mangos there is always text like
Zeppeli - Orcgrimmar to undercity moved to 1256.2356 - 4566.4332 (or something like that)
i use port 4488, and i use avast, in avast u really cant control port's, so i tried to quit avast, but it didn't work either.
i can connect fine to my server, but nobody else can, "unable to connect" that means something is bloccking my friends,
-i have opened port's in modem, (but they look stealh still)
- configured my firewall, windows + avast.
-server works fine.
i dont no what to do anymore :(
-Sephy the unlucky
Hi all,
Got the same problem, like most of you do.
Got athome a network running. On one of my pc's there is the mangos server running.
for example on 192.168.1.3
I am playing from another pc. example 192.168.1.2
in the DB of the realmd i changed the ip to the server ip 192.168.1.3
So everybody on my network can login and no problems at all.
But. People from outsite, can connect to the server (forwared the ports) and they see the realm list. But cant get in to the realm.
If i change the ip-adres in the realmd DB to my public adres or dns name, the people from outsite can log in and also on the realm, but then people from my network (local) can connect but only see the realm list, but cant get in to it.
I tried alot, but nothing seems to help.
Any suggestions?
Thnx in advanced,
Jiheld
I did what you did at CMD window, but it wont work.. could someone say what he exactly typed?
#xalvor
You mean with the update and stuff? I'll tell you, it's probably the quotes that are getting you, ok first you do:
-u root -p
*enter*
(enter your root password)
*enter*
use realmd
*enter*
(OK here is where most mess up, I will use ' for the quotes, and i will use * for the ` things that are above tab and to the left of 1)
update *realmlist* set *address* = '(your ip)' where *id* =1;
it should work
now for my problem, i still can't get it to work, i can play on it, but others cant connect, not even a computer from somewhere in my house...
Colin i have the same problem, have u tried to cheack are your port's stealth?
i guess i cant "unsteatlh" my port's so nobody else can connect =/
colin do you have 2 computer in your home? using same router/modem?
Ya I do, and what do you mean by stealth lol
Hey, i thought this guide worked really well for me.
Although i seem to be having some trouble getting people on other internet connections onto the server. it will say connecting for a long time then say unable to connect. One of my friends did this and his server works, but he has no router and i do. Is this the problem?
- I have opened ports on windows firewall and tried just turning off my macafee firewall.
- I made sure i was using my lan ip for realmd.
- Im pretty sure i set up my port forwording with a static ip.
anywase i hope that gives you some insight on my problem, thanks.
I dont think i have done anything with my dmz? that the problem?
sorry for double post
I keep getting this problem. Can someone please help me?
http://img102.imageshack.us/img102/6945/problemwithpublicpp7.png
# Nick
Ah it seems that you mistype ` character with '
btw if you're using my release you can just simply choose option #5 to change your realmd address :)
# I survived barrens chat and Colin
Usually that was caused by incorrect router configuration or there's another program use the same port as the realmd port
3724 by default also used by the blizzard updater, i'd suggest you to change the realmd port in realmd.conf into something else first :)
and don't forget if you change the realmd port you'll also need to change your realmlist.wtf file to use that port
for example
IP_ADDRESS:NEW_PORT_VALUE
#Reaper X
Where can I find your release? Is it in the ReaperMangos4703 folder?
yep, all you have to do is just run reaper-x-mangos.bat and choose option 5 :)
let me know if you still have problem ;)
I did that and my friend see's my server and tries to go on it. But it keeps taking him to the Realm List and he can't log on to it. Also here's what I get for what your tut says to do.
ERROR 1046 (3D000): No Database Selected
Does this also work when your friend is somewhere else? Like I didn't read LAN Party yet I did this and my friend who lives like 25 minutes away from me can access this and see the server. Can't log in it though.
Sup Reaper-X i got it to work a long time ago but now seem to be having trouble wondering if u could help me please Symptoms: when someone registers on my registration page they register but are not able to connect it stays at handshaking what is the problem. If i make the account manually it works fine but if they make it on the registration page it doesnt work a little help please
Does this work with SQLyog too(going into the realmd database and changing the server address)?
HI,reaper
can help me plz?im using a DNS(NO-IP.ORG) but nobody can connect to the server,i have a router(with ports open) and firewall(with ports open too),what can i do?
xalvor, The Database u need to go to is realmdmod
Rizadiza, Did U do The Option in were u can set it up for LAN and internet when u do that u ned to add the DNS that u chose and then they need to set their realmlist to set realmlist (The DNS U Chose)
That should help both of u so.
Thanks For The Great Guides. I was Gonna Get The PS2 Emulatar but i dont have the kinda specs u do and u said it wasnt all that great on urs
Sorry im using another version then u guys and it is Realmd not Realmdmod sorry
This article was very useful for our techies. I hope it helps to install our own server
Yea!! it worked!! :D thx reaper!
have got server running over internet but you can only connect from internet not lan, used no-ip.com address, and put router ip in the address in db, every one on internet can connect but i cant through the same router tried everything server must have its own internet connection. then it works fine
just to update I missed one of your earlier tips, if everyone puts there new dns_name in the address in the db i.e (me.no-ip.com) and updates there hosts file on all lan machines, they must add to the bottom one line {server_ip dns_name} then everyone can get on the server
Oh my God, I don't get server running for everyone whitout hamachi.. :¨( and they cannot log anymore :'/ can u help? when they try to login it says: unable to connect, and server is running and hamachi is running and mysql is running too :'{
Hey and first off. tnx for a great core pcak to start a PS with. Got it working first try. Now i'm woundring.
How is it possible to let people start off at lvl 70 (char of theire choice) with a Tier set of my choice? ofc for that class and faction etc and start money 5000g. I see many pS's that offers this but cant find out how.
Would love any help what so ever. If just a hint to how to get it done
Hello. First of all, thanks to reaper-x for this great guide! I have followed it very closely (Me not being one of those skilled on this subject) and have had great luck until now. People in my network (4 other computers, using same router) can connect fine, but anyone outside my network cannot. I used DYNdns.com for my hostname. When someone tries to connect, they just sit at "Connecting" for a long time, before going to "Unable to connect". Now the strangest thing is this... Realmd wont even detect anyone attempting to connect. Doesnt even say Connection failed. Help would be appreciated. If anyone needs more info to help out, please just say so. One thing that I have a doubt about is my firewall port forwards. I use mcaffee, so anyone who can explain exactly how to do it with mcaffee would be much appreciated... Not sure if I did it right.
Vin The First Thing That I Think Might Not Be Setup Right U Mentioned U Have A Router Well That Is The Problem U have To Port Forward For The Router as well So Find Ur Default Gateway type that into ur address bar of the internet explorer of ur choice and type admin amdin into the username password box that should work then u have to find port forward and forward the ports needed and then it should work fine that is what fixed my problem so their u go
Could you tell me what you have set up for your router? I think I configured it right, but Im not positive. For the private server, I have:
Mysql1 3306 to 3306 on TCP
Realmd 3724 to 3724 on TCP
World Server 8085 to 8085 on TCP
Any help would be appreciated. Trying desperately to get this up and running for my buds. Thanks to anyone out there helping n00bs like me :P
For D-link router try DMZ option in ur router config, did work 4 me ,btw tnx 4 every thing Reaper, so nice to have my own server :)
Ok so I am using Hamachi and the new 4703 build. My friends can log in and get past authentication but however the realmstatus is always offline to them and they can't log in. I have tried numerous combinations of fixes, changing of SQL file IP fields, and other things. Is it not possible for me to run the server on this computer which is connected to the internet via a wireless adapter and have my friends connect to the server via Hamachi IP?
hey reaper you replied to my problem ealier and i understand changing the port from 3724 to something like 37240 but i dont understand what you mean by changing the realmlist.wtf file. i think i might be missing something.
thanks.
i am wanting to creat a server but i don't now how to
Hey thanks reaper i set my realmlist.wtf file to:
set realmlist public ip:new port
that had me stuck for so long trying to figure out why i couldnt host lol.
Anyone have any suggestions as to why on my private server the other network users can't get to the character selection screen.
They can log in just fine, see the realm / server name and what type it is.
But then they get caught in an endless loop where it won't go past that realm / server screen.
Also I noticed while running around my map will not fill in to the areas I have explored.
Any help would be great!!
Thanks
I am completely stuck & have spend hours searching for a solution, but with no joy :(
I had to change 3724 to a different port because Blizz downloader was already using it.
I saw the reply about changing realmlift.wft, I tried changing it both on the server and at this end but still the same.
A grc scan shows both ports open, but if anyone tries to log on, nothing comes up in realmd.
Game says connecting & then times out.
I've got everything up and running but and when i set my realm under the DNS name, (with reaper-x-mangos.exe) people from the outside can connect but im the one stuck at realm selection - when i try in my internal ip , i can play but people from the outside are stuck
what can i do to connect aswell as the external peeps?
ok i did all the steps up there made a dns name forwarded ports and everything when i open realmd.exe it says cannot connect to database i know this is cause in the realmd.con where it had the 127.0.0.1 its been changed to my ip after doing the steps about making it public how do i fix this
I keep getting the error
ERROR 1054 (42S22): Unknown collum `192.168.0.1` in `field list`
after having typed
update `realmlist` set `address` = `192.168.0.1` where `id` -1;
Even if I use
update `realmlist` set `address` = `192.168.0.1` where `id` =1;
It doesn't work, anyone know what's going wrong, or what i've done wrong?
Oh god, I read the command wrong, my bad, problem fixed.
I think I have a decent beat on things with this server, I'll recap just in case it can help someone else out.
When configuring the IP for the realm, if you used your LAN IP "192.168.0.5" or something similar, only people inside your LAN with the IP range "192.168.0.1 => 192.169.0.255" can access the server without issue. If you used your public IP like: "68.56.103.212" (thats a made up ip by the way, usually LAN IPs start with 192.168, public can be anything) then only people across the internet can connect to the server, and NOT people on the LAN with the server. at least not without setting up a DNS to bounce the reference? I can't seem to get this to work exactly.
I've got Reapers easy Mangos 4875, and its working great, it is set to the public IP, Ive had a friend connect to it across the internet without problems. On my LAN I can't log into the realm, but i can log into the account.
The difference I have from these other posts here is that I am not playing on the server computer, but on another computer on my LAN. I've setup a DNS that forwards to my public IP (using no-ip.com) and put that in my realmlist.wtf, but i am having the same problem of being able to log into the account, but not enter the actual realm.
I've played with editing hosts, but do I need to edit the hosts file on both my computer, AND the server computer? and what do I need to put into my hosts file(s) for each computer?
I've edited the hosts file on my computer to add
192.168.0.4 mydns.serveftp.com
whereas the first LAN IP is my wow server,
The Mangos realmd is set to my public IP
my realmlist on my LAN computer is set to a dns address that i have redirecting to my public IP.
Now forgive me if im missing something, but wouldnt this be exactly the same as simply putting that same LAN IP into my realmlist.wtf because if im using a hosts listing in windows, i don't even need to use the dns, I could make up a dns name because all im doing to telling my local computer to send anything my computer tries to send to that dns, to that LAN IP directly instead.
So when I come up to the exact same problem of being able to log into the account but not the realm, it isn't surprising... so now, what am I missing?
Ok now I FINALLY understand after seeing this post:
http://www.mangosproject.org/forum/index.php?showtopic=11737
So, in order to make it so both WAN and LAN users can connect, I need to change the realm IP to the dns that was created. I dunno how I missed that in the earlier posts, guess it just wasn't obvious to me.
So to recap for anyone having the same problem as I.
All clients should have the realmlist.wtf reference the dns that was created, which should direct to the public WAN IP that the server is setup on. The server itself needs to have the realmd reflect NOT the LAN or PUBLIC IP, but the dns address. THEN the hosts files on each computer on the same LAN with the server must be edited to show the LAN IP address of the server AND the newly created dns that directs to the public IP.
furthermore proper router port forwarding needs to be established, where the Public IP will forward all port traffic for ports 8085 and 3724 to the servers LAN IP address.
hwy when do you think you'll have a "how to create custom items" thread up if you make one?
hey i cant get my friend in canada to connect
i'm not chaning all that shit cuz it costs 55 bucks!!!!! anyway i have my set realmlist to my ip that comes up on "ipconfig" and thats what i have the port forwarded to any helpers?
I'm having unimaginable amount of trouble doing this...
I have my realmlist set to my DNS which is directed to my LAN IP, I also have my realmlist.wtf set to said DNS. I have all required ports forwarded, and my friends have all added my DNS to their C:\WINDOWS\system32\drivers\etc\hosts file. But we all get stuck at connecting...
I tried a separate set-up, got farther, but ran into everyone else's problem...
I have my realmlist.wtf and realmd,realmlist table set to my public LAN (192.168.xx.xx), and all my friends have their realmlist.wtf files set to the same LAN. I have all ports forwarded, and if that weren't enough, we're all on Hamachi together. I can get into the server but my friends all get stuck in the "Connecting to Game Server" loop and can't join my server. Help?!?! I'm at my wit's end!
please help =(. I use your 2.3.0 private server and then i tried to make it public. I failed in it ;) and then tried to make it private back but now when logging in i have (...)Success (3seconds) i choose my realm, then Logging to the game server... and again realm choose window D:. What should i do??
-thx
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
# 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) :)
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. _
Sorry for the re-post :( but I forgot to tell you the ports where in fact open =p
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?
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
sorry for typos bad speller and lack of sleep
and my name in irc is wikid as well
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
# Reaper-X
that link won't load for me. does that = my port is unaccessible?
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...
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...
Yp, pretty much exactly what we're getting, but my sql still encounters the same problem I posted before.
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
PS.
Do I need to register for no-ip.com enhanced in order to host?
Oh thats right he sighned up and created a DNS using Dnydns.com
my realmist is
set realmlist nicksprivateserver.no-ip.biz
is that a correct one or does it have to be .com?
# 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 :)
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
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
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
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
by the way, is there a way to change the server name?
yes.
i think u can do it in mangos.exe
open it with notepad n look after server name or somethink :P
@happy_k
u mean mangosd?
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 !!
Help plz i still cant connect Btw ur guide is great anyway reaper :p
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??
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
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"
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?
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
Pee wee i had the same problem you used QUOAATION MARKS (') where you should of used Tiles ` at ID
#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
@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