[GUIDE]Running two Realms with diffrent Databases!

[melikeme]

Hey all, this is a guide I wrote to have two realms on the same server computer and the same realmlist for people to connect. The two servers (as said in the title) can have different databases, different rates, different spawns, characters, everything! all connected to the one realmlist and same accounts. In this guide I presume you have a server runing already, and know the basics of ports and stuff, and have your server public WITHOUT HAMACHI. This guide is for advanced users.

The basic principle of this is that each server must have its own port, otherwise they will be joined and conflict with each other. This creates an issue with characters not showing up, and more that you are unknowing of.
The point of having two MySQL databases is so you can customize one, and not the other, and people can choose which one to go on.

Declarations:
Server1 folder = The folder you have for your Cypack or other server already.
Server2 folder = The copy of the folder you will make in this guide.
Server1Database = The MySQL database you already have for your Cypack or other server.
Server2Database = A new, clean Cypack or other server database that you will create in this guide.
PUCLICIP = The IP that people use to connect to your server.
REALM1NAME = The name of you first Realm, which is your original one you have already.
REALM2NAME = The name of your new Realm that you will make in this guide.
PASSWORD = Your MySQL password.

Step One:
- Copy your server files and put them in another folder (I will call it Server2 in this guide). Then delete the logonserver.exe and logonserver.conf files.
- Create a new database in Navicat or called "accounts" (no "" of course ).
- Go into your Server1 folder and open up logonserver.conf.
- Change:
CODE
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "PASSWORD"
Name = "antrix"
Port = "3306"
Type = "1">

To:
CODE
<LogonDatabase Hostname = "localhost"
Username = "root"
Password = "PASSWORD"
Name = "accounts"
Port = "3306"
Type = "1">


Step Two:
- Create a new database in Navicat (I'll call it Server2Database in this guide).
- Set up Server2Database with a new copy of the Cypack database.
- Right click on the "accounts" table in Navicat in and click Dump SQL File. Save this somewhere you remember.
- Go into the "Accounts" database you created in step one, and right click on it and click Execute Batch File and choose the file you dumped just before. This should add the "accounts" table with all your accounts into it.
- Delete the "accounts" table from Server1Database and Server2Database.

Step Three:
- Login to your router, and navigate to where you open ports.
- Open the port 8130.
- Go into your Server2 folder and open Ascent.conf.
- Change:
CODE
<WorldDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server1Database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server1Database" Port = "3306" Type = "1">

To:
CODE
<WorldDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server2Database" Port = "3306" Type = "1">
<CharacterDatabase Hostname = "localhost" Username = "root" Password = "PASSWORD" Name = "Server2Database" Port = "3306" Type = "1">
.
Change:
CODE
<Listen Host = "0.0.0.0"
WorldServerPort = "8129">

To:
CODE
<Listen Host = "0.0.0.0"
WorldServerPort = "8130">

- Go into your Server2 folder and open Realms.conf.
- Change:
CODE
<Realm1 Name = "REALM1NAME"
Address = "PUBLICIP:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">

To:
CODE
<Realm1 Name = "REALM2NAME"
Address = "PUBLICIP:8130"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">


Step Four:
- Go to Server1 folder and start logonserver.exe and ascent.exe
- Once they are both fully done loading, go into your Server2 folder and start ascent.exe

Congratulations! You now have 2 seperate realms!

You can configure all your rates and stuff for one realm, and not the other. So one realm can be high-rate, and one lower-rate.

Credits to Robert .
(Not the Robert from these forums).

Enjoy!

[MentaL]

[Niikkoo]

i haVE one problem:when i try to create char theres no char in my char selection screen(before i enter world)

[Niikkoo]

nvm i fixed that ,now i cant say any npc in game (both realms!)

[Niikkoo]

The basic principle of this is that each server must have its own port, otherwise they will be joined and conflict with each other. This creates an issue with characters not showing up, and more that you are unknowing of.

and u cant do nothing about this?

[melikeme]

Dont u understand it ??
for example :
<Listen Host = "5.13.69.166"
WorldServerPort = "8129">
--------------------------------
u must change ALL THE PORTS IN ALL THE CONFIG FILES!! got it ._> ?

[Niikkoo]

ah yeah silly me ,thx

[melikeme]

hehe np ^_^

[Kira90]

THANX Nice TUT <--- HELPED ME :o

[mihai00792]

i haVE one problem:when i try to create char theres no char in my char selection screen(before i enter world)

how you rezolv this problem... i heave this problem .... pls help me