4Metin - Comunitate dedicata pasionatilor de Metin2 | Resurse | Sursa | Tutoriale | Serverfiles

Salut tuturor ! Cand pornesc CH1 si CH2 serverul functioneaza fara erori in syserr , cand incerc sa deschid CH3 , CH4 primesc "Connection refused" in putty si urmatoarele erori !

Syserr CH1: Gol

Syserr CH2 : SYSERR: Sep 5 22:42:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT id,map_index from player_shop WHERE channel=2 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Sep 5 22:42:00 :: heart_idle: losing 33 seconds. (lag occured)
SYSERR: Sep 5 22:42:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
SYSERR: Sep 5 22:42:00 :: socket_connect: HOST 81.180.203.106:14020, could not connect.
SYSERR: Sep 5 23:01:29 :: ChildLoop: MySQL connection was reconnected. querying locale set


Syserr CH3 : SYSERR: Sep 5 22:42:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT id,map_index from player_shop WHERE channel=3 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Sep 5 22:42:00 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
SYSERR: Sep 5 22:42:00 :: socket_connect: HOST 81.180.203.106:14020, could not connect.
SYSERR: Sep 5 23:01:30 :: ChildLoop: MySQL connection was reconnected. querying locale set

Syserr DB : SYSERR: Sep 5 22:41:12 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT MAX(id) FROM item WHERE id >= 180000001 and id <= 190000000
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 180000001 AND id <= 190000000
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT MAX(id) FROM item WHERE id >= 20000001 and id <= 30000000
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 20000001 AND id <= 30000000
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT MAX(id) FROM item WHERE id >= 60000001 and id <= 70000000
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 60000001 AND id <= 70000000
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT MAX(id) FROM item WHERE id >= 40000001 and id <= 50000000
SYSERR: Sep 5 22:41:55 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT COUNT(*) FROM item WHERE id >= 40000001 AND id <= 50000000
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 29
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 22
SYSERR: Sep 5 22:41:57 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 2 errno: 2003)
SYSERR: Sep 5 22:41:57 :: ChildLoop: AsyncSQL: retrying
SYSERR: Sep 5 22:42:02 :: ChildLoop: MySQL connection was reconnected. querying locale set

Syserr Game99 : SYSERR: Sep 5 22:41:57 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT id,map_index from player_shop WHERE channel=99 and status='OK' and exists(select name from player where id=player_id)
SYSERR: Sep 5 22:41:57 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Can't connect to MySQL server on '127.0.0.1' (61)
query: SELECT ps.id,ps.player_id,REPLACE('#PLAYER_NAME# Shop','#PLAYER_NAME#',p.name),ps.vnum,ps.count,ps.price,ps.socket0,ps.socket1,ps.socket2,ps.attrtype0,attrvalue0,ps.attrtype1,attrvalue1,ps.attrtype2,attrvalue2,ps.attrtype3,attrvalue3,ps.attrtype4,attrvalue4,ps.attrtype5,attrvalue5,ps.attrtype6,attrvalue6 FROM `player_shop_items` ps LEFT JOIN player p ON p.id=ps.player_id where not EXISTS(select name from player_shop WHERE id=ps.shop_id) and not ISNULL(p.name)
SYSERR: Sep 5 23:01:36 :: ChildLoop: MySQL connection was reconnected. querying locale set

Stie cineva cum pot rezolva aceasta problema ?Multumesc

SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 29
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 22
Ai verificat daca ai porturile corecte,ip, user, parola in fiecare config?

Problema posibil sa fie de la memoria ram, nu de la configuratie.
Daca vps-ul sau masina virtuala (virtualbox) nu detine destule resurse, procesele de game si mysql se vor opri automat din lipsa resurselor.
Incearca sa pornesti DOAR ch3 pentru a testa daca este o problema de configuratie sau de la resurse.

dinamicop scrie: ↑Mar Sep 05, 2023 8:17 pm SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 29
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 21
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 23
SYSERR: Sep 5 22:41:55 :: Process: FDWATCH: peer null in event: ident 22
Ai verificat daca ai porturile corecte,ip, user, parola in fiecare config?

Da , sunt bune !

F. Gabriel scrie: ↑Mar Sep 05, 2023 8:37 pm Problema posibil sa fie de la memoria ram, nu de la configuratie.
Daca vps-ul sau masina virtuala (virtualbox) nu detine destule resurse, procesele de game si mysql se vor opri automat din lipsa resurselor.
Incearca sa pornesti DOAR ch3 pentru a testa daca este o problema de configuratie sau de la resurse.

Am incercat cu ai zis tu si merge ! Am deschis doar ch3 si ch4 dupa am deschis ch1 si ch3 si tot asa intelegi ideea si a mers . Problema este din cauza memoriei ram fiind prea mica si cum deschideam mai mult de 2ch uri pica tot !
Multumesc pentru raspuns !
Problema Rezolvata !

Topic marcat ca si rezolvat!