[Question] Link Auth DB between 2 dedicated server.

[Soldan]

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.

[schlumpf]

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

[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?

[stoneharry]

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.

[Soldan]

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.

[schlumpf]

NEVER. USE. MYTHCORE.

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

[stoneharry]

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.

[Steff]

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 %  !!!