• This is a read only backup of the old Emudevs forum. If you want to have anything removed, please message me on Discord: KittyKaev

[SOLVED] Trinitycore multiple servers

Status
Not open for further replies.
yvoms

yvoms

Exalted Member
Im trying to set up 2 seprate realms, using the same realmlist, and the same authserver.
I have setup the following

1 auth server.
2 world servers.
2 world databases.
2 character databases.
2 entries in realmlist(database)
-

When i try to launch worldserver1 - its going all good.
when i try to launch worldserver2 - im getting an error.

The following error gets printed.

Code: 
DatabasePool world2 NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Read wiki at http://collab.kpsn.org/display/tc/TrinityCore+Home
Cannot connect to world database 127.0.0.1;3306;root;ascent;world2


worldserver.config
RealmID = 1
LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;world"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters"
WorldServerPort = 8085

worldserver2.config
RealmID = 2
LoginDatabaseInfo = "127.0.0.1;3306;root;ascent;auth"
WorldDatabaseInfo = "127.0.0.1;3306;root;ascent;world2"
CharacterDatabaseInfo = "127.0.0.1;3306;root;ascent;characters2"
WorldServerPort = 8086

And i've set up realmlist.db like the following.
vBGKvpP.png



Also worldserver(1) is being runned from a folder called release.
worldserver(2) is being runned from a folder called release2.

When i run both the worldservers from the same folder, worldserver(2) uses worldserver.conf <- belongs to worldserver(1).
Meaning i'd need to be able to assign config to the correct executeable, which i have no clue on how to do that.
Therefore i split the worldservers into differing folders.

But even when trying to outsmart the computer, it returned me the error.
Does this have to do with connections from user X on IP X have been limited or have i made a error somewhere?
 
Hyperion

Hyperion

Founder
Loos like you set it up right to me. That error can be caused by not updating your DB with the tc/sql/updates provided. So make sure you've done that
 
yvoms

yvoms

Exalted Member
Importing the latest TDB right now, in to both the worlddatabases.
Lets hope it works!


-- Derp i think i deleted my other world database rofl.
 
Last edited:
yvoms

yvoms

Exalted Member
TDB_full_335.57_2014_10_19 <- im downloading that, im gonna import it to both the world databases, i have a backup of the old one i think.
Just got to love dropbox sometimes.

Anyways i found out what i did wrong.
I tried to use a 2 year old database, i tought the above one was the most updated one.
but found out it was 2 years old.
Trying the newer one now :)
 
yvoms

yvoms

Exalted Member
thank you i've resolved it, had to do with wrong priveleges and wrong database version.
 
Status
Not open for further replies.
Top