Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Miscellaneous => Topic started by: Soldan on June 10, 2012, 01:00:59 pm

Title: [Question] Link Auth DB between 2 dedicated server.
Post by: Soldan on June 10, 2012, 01:00:59 pm

Hey guys,

I've just opened my server, as a realm in an already existing community with a good number of players. So, since there are about 500-600 players, we decided to have each realm on a different dedicated server.

I thought it would of been easy, like, in one dedicated server have one realm, with auth and worldserver, and in the other have it only with worldserver, and use the logindatabase from the first dedicated, and in their auth database, have our realm, with our servers IP.

It works, yes. But the server crashes every little while, and we are about 95% sure it's cause it closes the connection, and crashes the server.

What my question is, is am I doing it wrong? Is there another way to do it?

Thanks alot,
Soldan.

Title: Re: [Question] Link Auth DB between 2 dedicated server.
Post by: schlumpf on June 10, 2012, 01:02:51 pm

Instead of being pretty much sure, watch at the crash dump.

Title: Re: [Question] Link Auth DB between 2 dedicated server.
Post by: Soldan on June 10, 2012, 01:05:47 pm

The best thing is, it doesn't actually create a crash dump..

Because the server stays on "is not responding" and doesn't actually "close".

The error in the server log is always

WorldSocket :: handle_input: Peer has closed the connection


I'm trying to open both authservers, and it disconncts on login, is that because they are both using the same port?

Title: Re: [Question] Link Auth DB between 2 dedicated server.
Post by: stoneharry on June 10, 2012, 01:17:28 pm

Quote from: "Soldan"

The best thing is, it doesn't actually create a crash dump..

Because the server stays on "is not responding" and doesn't actually "close".

The error in the server log is always

WorldSocket :: handle_input: Peer has closed the connection


I'm trying to open both authservers, and it disconncts on login, is that because they are both using the same port?

Possible. If both realms are using the same port on each dedicated server. Instead increment the port on one of the servers and see if that results in the same result.

Errors like this require you to trace the program using a debugging program or trial and error. Output results at lines of code to see where execution halts, find the cause.

Title: Re: [Question] Link Auth DB between 2 dedicated server.
Post by: Soldan on June 10, 2012, 01:42:00 pm

Now even just using our own databases and auth/world it still crashes.

2012-06-10 12:38:04 WORLD: CMSG_CREATURE_QUERY 'Schembari "Uncle Sal" Shearbolt' - Entry: 29533.
2012-06-10 12:39:25 WorldSocket::handle_input: Peer has closed connection
2012-06-10 12:39:25 WorldSocket::handle_input: Peer has closed connection
2012-06-10 12:39:25 WorldSocket::handle_input: Peer has closed connection
2012-06-10 12:39:25 WorldSocket::handle_input: Peer has closed connection
2012-06-10 12:39:25 WorldSocket::handle_input: Peer has closed connection
2012-06-10 12:39:25 WorldSocket::handle_input: Peer has closed connection

NEVER. USE. MYTHCORE.

Title: Re: [Question] Link Auth DB between 2 dedicated server.
Post by: schlumpf on June 10, 2012, 02:07:36 pm

Quote from: "Soldan"

NEVER. USE. MYTHCORE.

NEVER. USE. TECHNOLOGY. YOU. DONT. UNDERSTAND.

Title: Re: [Question] Link Auth DB between 2 dedicated server.
Post by: stoneharry on June 10, 2012, 02:50:09 pm

May want to run some database diagnostics. See if any tables have crashed or become corrupt. You can repair them but it may result in data loss.

Title: Re: [Question] Link Auth DB between 2 dedicated server.
Post by: Steff on June 10, 2012, 04:36:22 pm

The server try toopen direct MySQL acces to the DB on the other server. If your Roots dont stay in the same hosting network OR you have an secured MySQL user with outside access to the DB it wil jsut not work.

This user should then only be allowed to access fromyour roots fix IP adress. NOT from %  !!!