Query master login table

[hsombini 0]

Hello, I'm trying to use Multiple-Zone servers, almost everything is working fine, except the query for the 'master' login table

 

I'm using two different VPS to host these two servers:

 

Server 1: login server, map server, char server

Server 2: map server, char server

 

The problem here is the query from the npc's of the Server 2, they do not apply to the 'master' login table on the Server 1, the query just run on the local database, who should not have any information about the 'login' table.

 

There's any way to force the query from the npc's run on the 'master' database or should I just forget about Multi-Zone servers on different machines ?

Edited September 2, 2013 by hsombini

[Kenpachi 64]

Please check your global SQL settings. They should match on both servers (not the IP of course ).

 

../conf/inter_athena.conf

 

// Global SQL settings// overridden by local settings when the hostname is defined there// (currently only the login-server reads/obeys these settings)sql.db_hostname: 127.0.0.1sql.db_port: 3306sql.db_username: ragnaroksql.db_password: ragnaroksql.db_database: ragnarok

[hsombini 0]

 

Please check your global SQL settings. They should match on both servers (not the IP of course ).

 

../conf/inter_athena.conf

 

// Global SQL settings// overridden by local settings when the hostname is defined there// (currently only the login-server reads/obeys these settings)sql.db_hostname: 127.0.0.1sql.db_port: 3306sql.db_username: ragnaroksql.db_password: ragnaroksql.db_database: ragnarok

 

They should have different ip? How the query on the Server 2 will run on the 'master' login table hosted on Server1 ?

 

This is the setting on the Server2

 

sql.db_hostname: IPServer1

sql.db_port: 3306

sql.db_username: ragnarokServer1

sql.db_password: ragnarokServer1

sql.db_database: ragnarokServer1

[Kenpachi 64]

 

They should have different ip?

Either both use IP of server1 or server1 uses 127.0.0.1 and server2 the IP of server1. So if your configurations is using the WAN-IP, both server config should match completely, otherwise 127.0.0.1/WAN-IP.

 

 

How the query on the Server 2 will run on the 'master' login table hosted on Server1 ?

The server should know this automatically since your config points to the correct server.

 

BTW; did you allow external connections for the MySQL server on server1? (Otherwise this wont work.)