Register for your free account! | Forgot your password?

Go Back   elitepvpers > Metin2 > Metin2 PServer - Discussions / Questions
You last visited: Today at 02:51

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Problems]DB - closing mysql connection

Closed Thread
 
Old   #1
 
elite*gold: 0
Join Date: May 2012
Posts: 6
Received Thanks: 0
[Problems]DB - closing mysql connection

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



PeSoiL is offline  
Old   #2
 
elite*gold: 0
Join Date: May 2012
Posts: 6
Received Thanks: 0
@xN0SkiLL you bottom spamers to ElitePvPers?
Please reply to topic, no spam :*


PeSoiL is offline  
Old   #3

 
elite*gold: 0
The Black Market: 251/0/0
Join Date: Jul 2012
Posts: 24,350
Received Thanks: 3,203
Firewall offline?
Sintiax is offline  
Old   #4
 
elite*gold: 0
Join Date: May 2012
Posts: 6
Received Thanks: 0
@Sullivan™ This is dedicated Server.
unable ports db and mysql


PeSoiL is offline  
Old   #5
 
elite*gold: 0
Join Date: May 2012
Posts: 6
Received Thanks: 0
@Refresh


PeSoiL is offline  
Closed Thread



« Previous Thread | Next Thread »

Similar Threads
[HELP]Connection Problems.
THIS IS WRITTEN ON BEHALF OF THE HOST OF THE SERVER Hello, i recently upgraded to EP5 from my EP4 Server, this went swimmingly, however, my EP5...
1 Replies - Shaiya Private Server
Connection Problems - Tried Everything.
I'm currently having problems getting people to connect to my server. I've done all this before and had no problems, the only difference is now, is...
4 Replies - EO PServer Hosting
Connection Problems
Ich hab neuerdings in der Uni Probleme ins Battle.net zu gelangen. Internet funktioniert einwandfrei, saugen auch, nur ich kann im Battle.net nicht...
7 Replies - Diablo 2
MySQl/Navicat Connection Problems!
Guten Morgen ElitePvPers :> Folgendes hab bei Freunden einen Flyff Pserver Local zu hosten allerdings traten bei beiden exakt die gleich...
4 Replies - Flyff PServer - Discussions / Questions
Problems with connection
Guy do u have problems to conneckt to the server? I run the bot I wrote the code and it says requesting user information.. and thats it nothing...
6 Replies - SRO Main - Discussions / Questions



All times are GMT +2. The time now is 02:51.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.