[Problems]DB - closing mysql connection

07/10/2012 21:46 PeSoiL#1
Hi guys. Me problems is the DB
Syslog and errlog

Syslog:
Code:
Jul 10 21:38:10 :: SETUP: channel 1 listen 13000 p2p 14000 count 1
Jul 10 21:38:10 :: SETUP: login 55  login_key 0 host 
Jul 10 21:38:10 :: SetPlay on 0 
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: SETUP: login_fail 0  login_key 0
Jul 10 21:38:10 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Jul 10 21:38:12 :: Connection accepted. (host: 127.0.0.1 handle: 2 fd: 21)
Jul 10 21:38:12 :: ACCEPT FROM 127.0.0.1
Jul 10 21:38:12 :: GM: PID 1 Login pesoil Character .ZohanG ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:12 :: GM: PID 2 Login pesoil Character ZohanG ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:12 :: GM: PID 3 Login rafix121 Character Rafix ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:12 :: GM: PID 33 Login noster12345 Character rZYT ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:12 :: GM: PID 34 Login airaki Character Airaki ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:12 :: QUERY_BOOT : AdminInfo (Request ServerIp 94.23.245.136) 
Jul 10 21:38:12 :: BOOT: PACKET: 990152
Jul 10 21:38:12 :: BOOT: VERSION: 6
Jul 10 21:38:12 :: sizeof(TMobTable) = 255
Jul 10 21:38:12 :: sizeof(TItemTable) = 154
Jul 10 21:38:12 :: sizeof(TShopTable) = 449
Jul 10 21:38:12 :: sizeof(TSkillTable) = 1475
Jul 10 21:38:12 :: sizeof(TRefineTable) = 53
Jul 10 21:38:12 :: sizeof(TItemAttrTable) = 69
Jul 10 21:38:12 :: sizeof(TItemRareTable) = 69
Jul 10 21:38:12 :: sizeof(TBanwordTable) = 25
Jul 10 21:38:12 :: sizeof(TLand) = 36
Jul 10 21:38:12 :: sizeof(TObjectProto) = 96
Jul 10 21:38:12 :: sizeof(TObject) = 40
Jul 10 21:38:12 :: sizeof(tAdminInfo) = 520 * 990152 
Jul 10 21:38:12 :: sizeof(TMonarchInfo) = 304 * 990152
Jul 10 21:38:12 :: ItemIDRange: SET  30000001 ~ 40000000 start: 30000451
Jul 10 21:38:12 :: ItemIDRange: SPARE SET  40000001 ~ 50000000 start: 40000001
Jul 10 21:38:12 :: Admin name .ZohanG ConntactIP 
Jul 10 21:38:12 :: Admin name ZohanG ConntactIP 
Jul 10 21:38:12 :: Admin name Rafix ConntactIP 
Jul 10 21:38:12 :: Admin name rZYT ConntactIP 
Jul 10 21:38:12 :: Admin name Airaki ConntactIP 
Jul 10 21:38:12 :: SETUP: channel 99 listen 13001 p2p 14001 count 2
Jul 10 21:38:12 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Jul 10 21:38:12 :: [       50] return 0/0/0 async 0/0/0
Jul 10 21:38:14 :: Connection accepted. (host: 127.0.0.1 handle: 3 fd: 22)
Jul 10 21:38:14 :: ACCEPT FROM 127.0.0.1
Jul 10 21:38:14 :: SetPlay off 0 
Jul 10 21:38:14 :: Connection closed. (host: 127.0.0.1)
Jul 10 21:38:14 :: ItemIDRange: returned. 10000001 ~ 20000000
Jul 10 21:38:14 :: ItemIDRange: Build: 10000001 ~ 20000000 start:10003452
SYSERR: Jul 10 21:38:14 :: Process: FDWATCH: peer null in event: ident 20
Jul 10 21:38:14 :: GM: PID 1 Login pesoil Character .ZohanG ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:14 :: GM: PID 2 Login pesoil Character ZohanG ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:14 :: GM: PID 3 Login rafix121 Character Rafix ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:14 :: GM: PID 33 Login noster12345 Character rZYT ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:14 :: GM: PID 34 Login airaki Character Airaki ContactIP  ServerIP ALL Authority 5[IMPLEMENTOR]
Jul 10 21:38:14 :: QUERY_BOOT : AdminInfo (Request ServerIp 94.23.245.136) 
Jul 10 21:38:14 :: BOOT: PACKET: 990152
Jul 10 21:38:14 :: BOOT: VERSION: 6
Jul 10 21:38:14 :: sizeof(TMobTable) = 255
Jul 10 21:38:14 :: sizeof(TItemTable) = 154
Jul 10 21:38:14 :: sizeof(TShopTable) = 449
Jul 10 21:38:14 :: sizeof(TSkillTable) = 1475
Jul 10 21:38:14 :: sizeof(TRefineTable) = 53
Jul 10 21:38:14 :: sizeof(TItemAttrTable) = 69
Jul 10 21:38:14 :: sizeof(TItemRareTable) = 69
Jul 10 21:38:14 :: sizeof(TBanwordTable) = 25
Jul 10 21:38:14 :: sizeof(TLand) = 36
Jul 10 21:38:14 :: sizeof(TObjectProto) = 96
Jul 10 21:38:14 :: sizeof(TObject) = 40
Jul 10 21:38:14 :: sizeof(tAdminInfo) = 520 * 990152 
Jul 10 21:38:14 :: sizeof(TMonarchInfo) = 304 * 990152
Jul 10 21:38:14 :: ItemIDRange: SET  50000001 ~ 60000000 start: 50000001
Jul 10 21:38:14 :: ItemIDRange: SPARE SET  60000001 ~ 70000000 start: 60000001
Jul 10 21:38:14 :: Admin name .ZohanG ConntactIP 
Jul 10 21:38:14 :: Admin name ZohanG ConntactIP 
Jul 10 21:38:14 :: Admin name Rafix ConntactIP 
Jul 10 21:38:14 :: Admin name rZYT ConntactIP 
Jul 10 21:38:14 :: Admin name Airaki ConntactIP 
Jul 10 21:38:14 :: SETUP: channel 22 listen 13022 p2p 14022 count 2
Jul 10 21:38:14 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Jul 10 21:38:16 :: Connection accepted. (host: 127.0.0.1 handle: 4 fd: 20)
Jul 10 21:38:16 :: ACCEPT FROM 127.0.0.1
Jul 10 21:38:16 :: AUTH_PEER ptr 0x28879780
Jul 10 21:38:16 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Jul 10 21:38:17 :: [      100] return 0/0/0 async 0/0/0
SYSERR: Jul 10 21:38:17 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
Jul 10 21:38:18 :: HEADER_GD_SET_EVENT_FLAG : No Changed CClientmanager::SetEventFlag(oxevent_status 0) 
Jul 10 21:38:18 :: MainLoop exited, Starting cache flushing
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Jul 10 21:38:18 :: AsyncSQL: closing mysql connection.
Syserr:
Code:
SYSERR: Jul 10 21:38:07 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Jul 10 21:38:07 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'name' in field list is ambiguous
query: SELECT pid, name, date FROM monarch_candidacy a, player b where a.pid = b.id
SYSERR: Jul 10 21:38:14 :: Process: FDWATCH: peer null in event: ident 20
SYSERR: Jul 10 21:38:17 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down.
Please help me.


Ps. Server Files not started
07/10/2012 21:50 PeSoiL#2
@xN0SkiLL you bottom spamers to ElitePvPers?
Please reply to topic, no spam :*
07/10/2012 22:48 Sintiax#3
Firewall offline?
07/10/2012 22:54 PeSoiL#4
@Sullivan™ This is dedicated Server.
unable ports db and mysql
07/12/2012 03:08 PeSoiL#5
@Refresh