Tipologie server: 40k
*Resursă folosită:by Mafia83
*ServerFiles utilizat:by Mafia83
*Syserr:
Poză:
*Detalii suplimentare:
Cand deschid CH1 si CH2 totul functioneaza si ma pot conecta la server si nu am nicio eroare in syserr , dar cand deschid CH1 , CH2 ,CH3 , CH4 serverul nu porneste si primesc "Connection refused" in putty.
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
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: 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
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: 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: 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: 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
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
Multumesc !
de 
de 
de 
de