Creating 2 Realmd in WoW Mangos Private Server
By Reaper-X on Oct 20, 2007 in Emulators, Tutorials
Some people have requested a guide on how to create or link their WoW Private server realmd so their users can choose whatever realmd they want to login to (for example, the first realmd is the PVP World, while the second realmd is to those who prefer normal world) :) … and that’s why i decided to create this guide, and hopefully it’ll be not confusing (i tried my best to make it easy to understand but you judge it by yourself) :)
So here goes the guide :
Requirements :
1. Basic knowledge about MySQL and know how to use MySQL Client program such as Navicat, SQLYog, or PHPMyadmin :)
2. Have lots of free memory / RAM left for best result (i’m using 3GB DDR2 Dual Channel RAM)
3. Mangos already worked and you can use it before trying to attempt this ;)
Note : Depending on which mangos revision you’re using the realmd column might be different (if you’re using my 4602 version then you can just use the same sql query as shown in this example)
also as a side note, you just need to have 1 account to login to each realmd, but it’ll use different data inside each database used
Here are the steps :
1. First make a copy of your mangos (or your mangos directory), so in the end you’ll get two mangos directory, in this example i was using my own compiled version 4617 (my latest version which is available for download for everyone is 4602)
2. Now you’ll need to create a new realmd id as shown on below image, and you can use below sql query if you’re using my 4602 release but if you’re using lower version, there are two option for you to choose : 1. Upgrade or 2. Adjust the column name accordingly
The above query will automatically assign REALMD ID 2 as it’s ID Number if you didn’t touch anything before in realmd table, and another thing to note is use different value for the WORLD Server PORT (in this example i’m using 8086
3. After finished with the above process, now of course you’ll need to create new Mangos Database first for your second realmd, and to do this we need to create a new database and then import the Mangos-UDB.sql file (if you’re using my 4602 release) or adjust it as necessary if you’re using another release, see below image for the example :
3.1 Creating New Mangos Database
or type mysqladmin -u root -p create database-name … if you can’t see the command used on above image
3.2 Importing Mangos DB
After finished creating new database for your second database, now you’ll need to import the fully working database from before into your newly created mangos database (if you’re using my 4602 release, the database name was called mangos-udb.sql and can be found in reaper-eazy-mangos folder)
4. Now you just need to go inside your second mangos directory which is created at step #1 and then open mangosd.conf inside that directory and search for this line :
RealmID = 1
and replace it with :
RealmID = 2
and then search for :
GameType = 1
replace it with :
GameType = 0
and now search for :
WorldDatabaseInfo = "127.0.0.1;3306;mangos;mangos;mangos"
and replace it with :
WorldDatabaseInfo = "127.0.0.1;3306;root;yourpassword;yoursecondmangosdatabasename"
lastly search for :
WorldServerPort = 8085
and replace it with :
WorldServerPort = 8086
The above step was done because the previous mangos user doesn’t have the privilege to touch that new database name so we need to use root that has global privilege (this is the most quickest and dirtiest way) :P
As a side note, it’d be better for you to create new username for your second database and grant privilege to it for better security (it’s not good to use root account) :)
5. Run the realmd.exe from any of your mangos directory (the first directory which was there before, or the new mangos directory which is created for this purpose), and then run mangosd.exe from the first directory and the second directory
So that result in three new process created … 1 realmd.exe, and 2 mangosd.exe from different directory
6. Now login with your previous username or create a new username and if you’ve done all of the above steps correctly you’ll see two realmd that you can use as shown on below image :
6.1 Realmd Selection Screen
6.2 The first Database With all the characters from before (i think you already saw my character for each screenshot used lol)
6.3 The Second Realmd which is used for this guide
That’s it … i hope you can understand the above explanation … and just like before, if i missed anything just let me know about it :)
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
Sweet, thanks now I can have 2 servers.
Great guide, Also i Haven't seen a "Ascent" guide for this? is there one about? thanks in advance
How did you make those custom weapons
"How did you make those custom weapons"
u can use http://wow-v.com/weaponcreator.php
"u can use http://wow-v.com/weaponcreator.php"
I see. It gives me some sort of text however I'm still not sure what to do with that...
Hi, I have two computer's that can run wow servers(i am already have one up and running). my question is can i use both of those computers to run two wow server at once on the same router? And still be able to get a connection from outside the router. How different are these steps and can you explain how to do this. thank you
# Kek
I'm really sorry but i haven't got a chance to try ascent :( ... i don't know why but it seems that ascent only allow specific people to access their svn repositories (or at least that's what i'm thinking)
# Malevo
It's a sql file, but i haven't actually tried using / importing the sql file from them directly :)
# Question
Actually as long as you run it on different ports, it should be fine :)
Sorry for posting this here since its off topic, but this seems to be the only place peeps are helping me with this. So yeah, I created an SQL file for my item and I opened mysql through navicat. I just need to know where to execute the batch file or something.
unfortunately i dont use navicat so i dont know where to execute it in navicat
but if you're interested on executing / importing that sql file via the command prompt, here are the step :
Note : i assume you've set the mysql bin path into your environment variable path
1. open command prompt
2. change directory to where you put that sql file
3. type :
mysql -umangos -pmangos -D mangos < that_sql_filename.sql
and done :)
Hey reaper,
If you check comments here I wanted to say my server is up and running beautifully and I love you for your time spent to work on this. But I have hit a problem when it comes to the second database. How does the long file stretch work when you replace the "mangos, mangos,manogs" deal?
Never mind man, I fix my problems before you do hehe. Thanks for the support though. When I have someone to tell this stuff to I fix it right away. ;).
Slacker
How do i add the .reload3 and the .reload 147 id commands to my server?? because i got the 2.1.3 server and the new nether drake mounts dont work it makes my character fly but there is no drake?? what do i do to fix please help and email me at ballzan@gmail.com
# Slacker6
lol .. glad you found the solution by yourself :D
# cman
actually that nether drake is dependant on which database you're using
if you're using my 4629 release and choose use the Unified Database, then you can use Nether Drake ;)
"i assume you’ve set the mysql bin path into your environment variable path"
huh? o.o
whats your ip man.. i wanna join ya server ^^
hey reaper-x
Once i make the sever, how do i make it have bc? Do i need to have another sever then the one you have provided?
# Malevo
Ah .. try running the server instance config from the mysql shortcut in start menu if you want to set mysql to be included in your Env. path automatically :)
# beaver
Unfortunately it's not possible for me to run internet based server because i'm still using slow connection (my upload speed 5 - 8 Kilobytes / second).. and that's why i only open it for LAN connection only :(
# njbs
you mean Burning Crusade ? actually you can set TBC default into 1 by editing the account table in realmd (TBC Column)
but if you're using the mangosd command line to create new account (create username password), you'll need to also type setbc username 1 :)
what do u mean by setby username 1?
do i need a differnt database if i where to get bc?
will i need better mangos?
can i link me the site to create mangos?
I edit my items using SQLYog, go to your database (dbc), then under mangos, go to item_template and you can edit every item in the game there. You can also do much more than edit items, but also NPC's, scripts, loot, and so on. After editing it you just save it in the window log, and save it into your data file from the SQLYlog program. Hope that made sense.
Can u add me for msn? please my msn is Marius_94_1@hotmail.com!!!
i need help with making my new server its gonna go up! please some of thoose peopels!
i need make it!
You're not making 2 realmds, you're making 2 world servers or 2 instances of mangosd actually...might wanna get your wording right before publishing.
Hi there I have my server up and running all perfect but dont have any people ,animals or items also when I type something and click enter nothing appears can anyone please help?
Many thanks..
Dor.x
# Dorvita
Could you tell me which mangos revision you're using actually ?
# Jimmy
I'm really sorry for late reply because i didn't saw your comment coming through
actually previously (before writing this) i received email from few people and ask whether they're able to run separate database with 2 realmd, and since i got confused on what they're trying to do so i guess basically they're looking for something like this
and i'm really sorry if i'm not using the correct words because well basically i'm still learning too :)
Hi there, I recently updated to the latest release yesterday, and now made another server.
Now, in SQLyog, I have the main database fodlers, then my new one called mangos-db2 which i imported the database file into. So, now when i load the first mangosd.exe it loads both the servers at once, but, the new server loops. I had managed to get access once but I can not get in anymore. I just thought that if i could get this to work properly i wouldnt have to hog all my ram by loading two seperate servers accessing the database.
All of the tables work in relation perfect so its just the looping i cant seem to fix by adding the ip to the realmd table.
I've manage to make my own server and everythings working:D But i just wonder can i make my own weapons? I've searched google for like 1/2 weeks now, (without finding anything)
Then my friend telled me that you were going to make a guide about it is that true? And thanks for all the help your site gave me:D
Lol, the whole thing I was trying to make this damnit second realm, I didnt get anything with this step one, omfg ! Do I have to download it !? And what is it querty pfft ... From all understendable so easy guides I found this one the most hardable to understend, and I still dont get first step with this damn programm sql or something, on how this working and etc !! What is it actually ? And can you share download link ???? Would be perfect -.- ... Anyway thanks for ' good ' guide.
I mount 2 local realm + 1 remote realm (internet on another city) (3 realms) whit only 1 logon db, and work perfect!!!!
Ya, finally got mine to work, have the same sort of set up as EZ-Mouse, with one logon db.
lol luckers, all I got is giant list of mistakes, and wtf this programm needed in 2nd step ? -_-
# Snurro
Yes, currently i'm working on it .. and hopefully it'll be not confusing as this one (that's why it took me a while to write it lol)
# EZ-Mouse and Sscutlima
Glad to know it works for you too :)
# SauronTheGreat
Lol ... ah actually as long as you have mysql installed, then you can do it too
here's a manual step on how to do it :
1. open command prompt
2. type :
mysql -umangos -pmangos -D realmd
INSERT INTO `realmlist` VALUES ( NULL, 'YOUR SECOND REALMD NAME', '127.0.0.1', 8086, 0, 2, 0, 0, 0 );
to see if you've done it correctly type :
SELECT * FROM `realmlist`;
and see if you can see your newly created realmd name after typing the above SELECT ;)
A really short (and proudly hard to understand guide) about to connect internet realms to your logon server
first stem, in the logon server db, create a list whit all Id Names and IP (and ports if necesary) of your internet realms, i.e:
(shown as vertical fields)
--------------------------------------------
id: 1
name: internet server 1
address:
port:
icon: 0
color: 0
timezone: 0
allowedSecurityLevel: 0
population: 0
--------------------------------------------
Repeat many time how realm u want to mount (changing the ID in ALL cases)
THEN be sure all your internet realm can work perfect as local realms, if work, ok, we can continue, if all work good, then edit your mangosd.conf and change that configurations parameters only!
RealmID = 2
(REMEMBER: must match the realmlist on the db logon serv!!!!!)
GameType = 1
(or 0 NORMAL 1 PVP 4 NORMAL 6 RP 8 RPPVP)
--and---
LoginDatabaseInfo = ";;;;realmd"
i.e.:
LoginDatabaseInfo = "243.45.159.45;3306;mangos;mangospws;realmd"
the rest of connections can keep being local adresses on each realm
ok, we are ready, now, we can up our realmlist
run the REALMD.EXE on the logon server
then.
run the MANGOSD.EXE (ONLY don't run the realmd.exe) on each internet realm.
if all your connection to the logon db on each realm work then u have a wow serv whit internet_realm_list
NOTE: make sure your logon serv can see your realms, and your realm can see the logon serv, and their DB (whit te respectives permision for insert, delete, update...etc, u know what permission need ;))
:S Ok, thanks great guide, but :S how can I remove realm ? Coz I have one incorrect ;S out of three ;S thx again ;S
Also: Realm shows to be offline -.- and this WorldDatabaseInfo = “127.0.0.1;3306;mangos;mangos;mangos” cannot be found, even if you uses WORLD as key word -_- ...
Ok, now I found anything, it says error, that mysql server isnt correct :/
yo..reaper, i have stared a web site using shadowhunters repack (mangos) my problem is that when i use the speed commands i get stuck i cant move at all.. u know what this is or how i can fix it? =:)
sorry..lol i meant server not website :P
How can i make 2 mangosd.exe to run in one Mangos Restarter? I made 2 realms...but i need to make the restarter to work for both...what shoul i do?
hello reaper, first of all i want to ty for all the guides u have posted. and second if possible i need some help with the account site for others to create their own accounts instead of me doing manually. email= s457l9a1321@hotmail.com
hey reaper i am having trouble with getting my world friends on my server my server is up and running but my netherlands friends can't get on it what am i doing wrong please help me thank you
For all of you still looking for working DBC files /having problems with extracting your own can do what I did. I downloaded the latest ASCENT server and used the DBC files for the reaper-x-mangos server. worked perfectly.
Thanks reaper and a merry christmas!
well i did everything it said, but then for some reason when i try to log into the second server it says "cannot connect"
im lost
hey i was just wondering how do you change your gm character's rank
How do you change your gm accounts ranking?
my server is working fine i just forgot how to change my accounts ranks
having problems with characters in the two realms. the characters from realm 1 are being used in realm 2 is there a way to fix that? or am i missing a step on here...
acount ranks can be changed on 2 ways,
easy in mangosd.exe or some harder in sqlyog
-open mangosd.exe and type setgm 'name' 'rank'
3 = admin
2 = gm
1 = moderator
0 = player
or the harder way:
-open sql yog, go to the realmd db,
then to account and search for the player and set his rank (collum nr. 4)
like:
setgm bloody 3
for admin =D
-d unknown command.
Any reason?
*******************************
C:\Documents and Settings\Jeremy>mysql -umangos -pmangos -d realmd
mysql: unknown option '-d'
********************************
im having this same problem you create a character in one realm and when u switch realms the character is on the second realm can this be resovled?
when i open the second mangosd it just stood could not connect to mysql database at Ô127.0.0.1: unknown mysql server host 'Ô127.0.0.1'
Cannot connect to world database Ô127.0.0.1
ok i know ure problem mate u have copied a line from this post and as reaper stated it will give u curly quotes "“ see the difference go into ure config and replace the quotes with normal quotes this will resolve the problem
sorry this was for weiss935
ok i know ure problem mate u have copied a line from this post and as reaper stated it will give u curly quotes ““ see the difference go into ure config and replace the quotes with normal quotes this will resolve the problem
Jerememy you need a capital -D or it will not understand your command :)
very grateful if someone has a solution to the character system i.e having diff characters for each realm, im kinda thinkin u would need 2 databases but if not please let me know :)
n1t3 i found the solution jst after my last post lol
project needs
1. need 1 realm server
2. need 2 mangos server running pointing to same realmd but different db
3. edit realm config to load both realms
4. make 2 database name 1 mangos and other mango
5. make sure both database are starting properly
follow these steps and should be no problems.
hope this helps im gna try it now
ok for anyone wanting to have different characters on each realm here is wat you have to do:
1. edit mysql with your preffered tool i used phpmyadmin which is quite user friendly.
go into the characters database and click operations and then at the section copy database to type in characters2 then ensure structure and data is selected and click go.
2. open the mangosd.conf for the second server and edit this line:
CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters"
to:
CharacterDatabaseInfo = "127.0.0.1;3306;mangos;mangos;characters2"
now i also creates another user so my line is:
CharacterDatabaseInfo = "127.0.0.1;3306;mangos2;mangos;characters2"
note the user us mangos2 however im no certain u need to do this as i havnt tried without it if u do simply go to the home page of phpmyadmin and click privelages and then create new user ensure u set the username to mangos2 and password to mangos and give the user full privelages to the relevant databases i.e realmd and characters2 and so on..
hope this helps
ALL with 2 realms and same characters. It is an easy fix actually. you need to create a second character database and add it into your mangosd.conf same as you did with the realm. ex: i named my second mangos database `mangos2` and i also created `characters2` then upload your characters.sql to database. and chage mangosd.conf. Hope this helps.
-Chris
i don't understand how to create a new database.
Help please
now i've got it.
“127.0.0.1;3306;root;yourpassword;yoursecondmangosdatabasename”
I don't know my seconddatabasename or my password.
how do i get them?
i've fixed that:P now when my server is upp i just find the second realm. but i have both mangosd open and one realmd open.
pls i need help!
add me on msn ill help u :)
dundeesteve@hotmail.co.uk
weiss935 i got dc and you went offline i hope u get it sorted im not familiar with the dlink but u need to get port 8085 and 8086 forwarded on ure internal ip 192.168.1.3 and it didnt seem to work
um ho do ifind the mongos first step were are they that would help
Has anyone had a problem with actually logging in to a second realm on their server? I can see the realm when I log in, but when I try to get on the new realm, it bounces me back to the list of realms. The original realm is still accessible. I've got all the ports forwarded correctly (the original realm works fine). I've also tried addressing the 2nd database with the root user and password in mangosd.conf. I have also given the mangos user permissions to the new databases in MySQL. Any ideas?
Reaper-- Thanks for all the time you put into this. You Rock!
Hi, I have 2 mangos.exe
one on a PC and another on a second PC.
I want to use an only reaml.exe on one of two PC.
Problem is when I insert the ip in the mangos.conf of the realm.exe on other PC, I have a connection mistake to the DB
i have done everything right now and i have two realms but when i open the first mangos it can't find the error loading ' gameobject.template' table (not exist?)
what can i do?
OK i got the server running with no prob, i cant figure out how to get a dign in page running at all and now this 2nd realm thing is driving me nuts. i got it when i log in i see all 3 realms and can log into all 3 of them BUT they are all the same ... same scharacters and everything, so if i delete from 1 realm it deletes that alt from all 3 realms. i know ihafta be missing something here, even tho that has to have been the most confusing guide i have read yet. i am using navicat, mysql and of course reaper x mangos 5225, seeing as how the guide wasnt to helpful can someone tell me what i am doin wrong .. i did everything just like this guide said and still nothing .. or is this guide seriously outdated and dont work for 5225?
@kradnam
u need to make a new characters database
so make a new DB called characters2
then import the DB from the reaper folder and assign ur second realm in mangosd.conf to point to that second characters
that way u can have 2 different character things to save too
and do the same for ur 3rd db
@Firane
Woot thanks much, i have read 3 of 4 diff guides how to and not one mentions a 2nd characters database.. how the hell can that be left out ... well thanks so much again now if i can find a guide on how to get a web account page goin i will be good
@kradnam
@reaper
your welcome
yea in the guide i didnt really see anything about that
when i looked at it i would think for sure reaper would have that in there
its like the most important part
u might want to add that in reaper
I have an interesting problem. I have the second realm up and running, and when I log into wow, I can choose either realm.. The problem is that when I log out of one realm, and it takes me back to the character list, and I click change realm, it just says retrieving realm list. It will not bring the list of realms back up until I completely exit wow, and log in again.
Any ideas?
i've done a new character database named characters2 and writed it in mangosd but when i start mangosd it didn't find characters2 database. what to do?
and when i try to login to realmd 2 this text comes loggin in to relm 2 and then i come back to there i choose realm but the other realm works great
@kradnam
if you copied the mangos database into mangos2 and 3, then the character info would stay the same.
Since these are seperate databases, you can delete characters from 1 of them , and it won't affect the others.
how do i delete databases?
my first realm is named reaper-x and how can i name it to weiss realm 1?
hello, one little problem about 3.2 i have done everything in 3.1 and when i try to do 3.2 when i write: mysql -u root -p... and press enter then system shows me the system canot find file specified! plz help me.
write:
mysql -u root -p realmd
i mean mysql -u root -p -D realmd
wen i make my ps will i be abll to go on wow with out internet and can i limit the amant off pips that go on ther ??
its up and running but how do i log in... i dont have an active accoutn do i have to have one?
Hy..it's my first server, but I have a little problem,.....It's stock at connected,...can someone help me with this.....???
Tks....