Register for your free account! | Forgot your password?

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

  • 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 07/10/2012, 21:50   #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 07/10/2012, 22:48   #3

 
elite*gold: 0
The Black Market: 251/0/0
Join Date: Jul 2012
Posts: 24,358
Received Thanks: 3,203
Firewall offline?
Sintiax is offline  
Old 07/10/2012, 22:54   #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 07/12/2012, 03:08   #5
 
elite*gold: 0
Join Date: May 2012
Posts: 6
Received Thanks: 0
@Refresh


PeSoiL is offline  
Closed Thread



« Waffen einfügen Oo | [HELP]Questlib erweiterung von Mijago »

Similar Threads
[HELP]Connection Problems.
08/08/2011 - Shaiya Private Server - 1 Replies
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 client was incompatible, dcing the players every minute or two, so i tride to change a few things, to...
Connection Problems - Tried Everything.
01/09/2011 - EO PServer Hosting - 4 Replies
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 that I'm hosting on Windows 7 and a different router. I currently have a Netgear Modem/Router...
Connection Problems
10/16/2009 - Diablo 2 - 7 Replies
Ich hab neuerdings in der Uni Probleme ins Battle.net zu gelangen. Internet funktioniert einwandfrei, saugen auch, nur ich kann im Battle.net nicht auf den Europe-Server zugreifen. Asia und US funktionieren alle. Benutzt Europe einen bestimmten...
MySQl/Navicat Connection Problems!
09/14/2008 - Flyff PServer - Discussions / Questions - 4 Replies
Guten Morgen ElitePvPers :> Folgendes hab bei Freunden einen Flyff Pserver Local zu hosten allerdings traten bei beiden exakt die gleich Probleme auf Obwohl!!!!! beide genau das selbe haben wie ich hab gestern versucht (seeeeehr lange...
Problems with connection
04/27/2007 - SRO Main - Discussions / Questions - 6 Replies
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 hapends...?? what is it?



All times are GMT +2. The time now is 10:56.


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.