Multiple servers

[kntybrn 4]

THey there, i have weird problem again

I'm trying to run multiple servers like that

DB > xxx.xxx.xxx.158

auth > xxx.xxx.xxx.155

DB server up and running in .158 but auth server cant connect .158 db and giving this print "connect: Connection Refused"

There is auth config;

HOSTNAME: Ephixa_Auth
CHANNEL: 1
PORT: 31009
P2P_PORT: 41100
DB_PORT: 11000
DB_ADDR: xxx.xxx.xxx.158
TABLE_POSTFIX:
ITEM_ID_RANGE: 000000001 000000002
PASSES_PER_SEC: 25
SAVE_EVENT_SECOND_CYCLE: 180
PING_EVENT_SECOND_CYCLE: 180
AUTH_SERVER: master
PLAYER_SQL: xxx.xxx.xxx.158 username strongpassword account
COMMON_SQL: xxx.xxx.xxx.158 username strongpassword common
LOG_SQL: xxx.xxx.xxx.158 username strongpassword log
LOCALE_SERVICE: turkey
MARK_SERVER: 1
CheckClientVersion: 1
ClientVersion: 1215955521

And There is db conf.txt;

WELCOME_MSG = "DB Server has been started"

SQL_ACCOUNT = "localhost account localusername strongpassword 0"
SQL_PLAYER = "localhost player localusername strongpassword 0"
SQL_COMMON = "localhost common localusername strongpassword 0"
SQL_HOTBACKUP = "localhost hotbackup localusername strongpassword 0"

TABLE_POSTFIX = ""

BIND_PORT               = 11000
DB_SLEEP_MSEC           = 10
CLIENT_HEART_FPS        = 10
HASH_PLAYER_LIFE_SEC    = 600
BACKUP_LIMIT_SEC        = 3600
PLAYER_ID_START = 100
PLAYER_DELETE_LEVEL_LIMIT = 15
PLAYER_DELETE_CHECK_SIMPLE = 1
ITEM_ID_RANGE = 2000000000 2100000000
MIN_LENGTH_OF_SOCIAL_ID	= 6
SIMPLE_SOCIALID = 1
NO_TXT = 1

There is no problem in MySQL server, only problem is db connection idk why

 

#Edit Auth server syserr

SYSERR: Jun  8 05:41:39 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:41:42 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:41:45 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:41:48 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:41:51 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:41:54 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:41:57 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:42:00 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:42:03 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:42:06 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.
SYSERR: Jun  8 05:42:09 :: socket_connect: HOST xxx.xxx.xxx.158:11000, could not connect.

 

[FlorinMarian 122]

I've never used this 

DB_ADDR: xxx.xxx.xxx.158

Just create from example 

/usr/home/game
/usr/home/game2

and for every game folder change DB_PORT (15001 & 15002 for example).

You have to be carefully with ports  too , example:

/usr/home/game/auth
PORT: 31009
P2P_PORT: 41100

/usr/home/game2/auth
PORT: 31010
P2P_PORT: 41200

If u create folders like this be sure u correct the symlinks.

Greetings.

[kntybrn 4]

ok thanks

 

but im not trying for that

[NoFr1ends 747]

There are maybe multiple reasons for this problem:

• Incoming connections to this port gets blocked by a firewall
• Maybe the DB core blocks connections from a public IP

But in general, I recommend to block public traffic to the DB core. You should consider to give the both server a private network to talk to each other. (Which is at the most hosting providers not possible, some OVH server has the feature vrack, that is what you need)

[kntybrn 4]

29 minutes ago, DevChuckNorris said:

There are maybe multiple reasons for this problem:

• Incoming connections to this port gets blocked by a firewall
• Maybe the DB core blocks connections from a public IP

But in general, I recommend to block public traffic to the DB core. You should consider to give the both server a private network to talk to each other. (Which is at the most hosting providers not possible, some OVH server has the feature vrack, that is what you need)

i wish to do multiple channel servers like gameforge, yes maybe you're right public ip can be blocked

[FlorinMarian 122]

Acum 24 minute, kntybrn a spus:

i wish to do multiple channel servers like gameforge, yes maybe you're right public ip can be blocked

It's easy to do it.

I had impression you try to make 2 different servers on same VPS.

Just multiplicate channel1 folder with a new folder name "channel2" and recreate symlinks.

Auth it's the same.

Look from my server:

/usr/home/game/channel1/CONFIG

HOSTNAME: ch_1
CHANNEL: 1
PORT: 13000
P2P_PORT: 30011
DB_PORT: 15001
DB_ADDR: localhost

/usr/home/game/channel2/CONFIG

HOSTNAME: ch_2
CHANNEL: 2
PORT: 14000
P2P_PORT: 40011
DB_PORT: 15001
DB_ADDR: localhost

 

[kntybrn 4]

On 08.06.2017 at 9:48 AM, FlorinMarian said:

It's easy to do it.

I had impression you try to make 2 different servers on same VPS.

Just multiplicate channel1 folder with a new folder name "channel2" and recreate symlinks.

Auth it's the same.

Look from my server:

/usr/home/game/channel1/CONFIG

HOSTNAME: ch_1
CHANNEL: 1
PORT: 13000
P2P_PORT: 30011
DB_PORT: 15001
DB_ADDR: localhost

/usr/home/game/channel2/CONFIG

HOSTNAME: ch_2
CHANNEL: 2
PORT: 14000
P2P_PORT: 40011
DB_PORT: 15001
DB_ADDR: localhost

 

Sorry for delay, but not thats, 5 VDS servers MySQL ve game servers, im not looking for all channels in one server

[FlorinMarian 122]

Acum 11 ore, kntybrn a spus:

Sorry for delay, but not thats, 5 VDS servers MySQL ve game servers, im not looking for all channels in one server

I think it's not a good idea to have separate VPS for every channel, much better a single strong VPS (SSD + multiple cores) and that's it.

[kntybrn 4]

This way more secure i think, because ddos attacks are annoying (in my country they doing for hobby.)

And I just want to learn how,

[hachiwari 136]

56 minut temu, kntybrn napisał:

This way more secure i think, because ddos attacks are annoying (in my country they doing for hobby.)

And I just want to learn how,

what country?Xd

[kntybrn 4]

37 minutes ago, hachiwari said:

what country?Xd

Turkey