Thread: Creating 2 Realmd in WoW Mangos Private Server

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 [Only registered and activated users can see links. ], [Only registered and activated users can see links. ], or [Only registered and activated users can see links. ] :)


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 [Only registered and activated users can see links. ] 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;yoursecondmango sdatabasename"


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

CREDITS: Reaper-X

Mozes mi naci MaNGOS za wow 3.0.9 (Nemora sa sajtom)a pass i userrname da bude
Root
Root
:P Pozz

Originally Posted by TheSerbianEllite_toBA

Mozes mi naci MaNGOS za wow 3.0.9 (Nemora sa sajtom)a pass i userrname da bude
Root
Root
:P Pozz

Imas na forumu... trazi :P

Originally Posted by Jerry

Imas na forumu... trazi :P

hehehe

jerry imam jedno pitanje.... Gde mogu da nadjem Repack Od Eterion WoW ili wow ge servera?

Originally Posted by jovica1994

jerry imam jedno pitanje.... Gde mogu da nadjem Repack Od Eterion WoW ili wow ge servera?

Moras traziti po forumu.

Great guide Jerry! :)

Matori Postoji Neki Srpski Server ?