Register for your free account! | Forgot your password?

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

  • 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,367
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 no avail, i managed to get hold of a compatible client, which doesnt dc. I encountered a problem, however, none of my players can connect! Only myself, even though none of the ips required to run it publicly are on 127.0.0.1, can somebody please...
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 built in (not sure whether this is the issue) but I've port forwarded all ports necessary, server works absolutely beautifully but.. other people cannot connect to the server. I've tried so many different things, I've been through OEM's plenty of...
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 Port zum connecten, den die Uni vielleicht gesperrt hat? Wenn ja, kann ich das iwie umstellen/umgehen? Die Fehlermeldung dürfte ja hinlänglich bekannt sein "Verbindung zum Battle.net konnte nicht hergestellt werden... Falls sie ein Modem...
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 versucht) das Problem zu finden allerdings naja die müdigkeit übertraf mich und ich hab dann einfach auf meinem Server gespielt
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 +1. The time now is 12:33.


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.