URGENT!! Please!!

**maggieta2** · 15-08-10

hello, good evening, well I need a little help since I have a problem that the truth is no longer how to solve!. happens that I had made my working days with full server database friend chummpy. but at one point shut down the server and lit it again, is that users could not get including me. as a solution because I could not find support, and create the server again with the empty database marrow but also all over again if I write a correct password but I can not go wrong if I get error, do not understand what happens anyone can help me.
here I will send all my logs.

CASHDBAGENT.

Code:

[Sat Aug 14 2010 20:48:28.992129 3085924048]: open log file  '/var/log/cabal/CashDBAgent.log'
[Sat Aug 14 2010 20:48:28.992316 3085924048]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:28.992384 3085924048]: MemPoolUnitSizeClass(0): 14336Bytes
[Sat Aug 14 2010 20:48:29.152168 3085924048]: Start CashDBAgent Server
[Sat Aug 14 2010 20:48:29.157447 3085924048]: UseEcryptText (Off)
[Sat Aug 14 2010 20:48:29.190645 3085921168]: CProcessLayer(0)::svc Start [3085921168]
[Sat Aug 14 2010 20:48:29.190839 3075431312]: CProcessLayer(0)::svc Start [3075431312]
[Sat Aug 14 2010 20:48:29.190993 3064941456]: CProcessLayer(0)::svc Start [3064941456]
[Sat Aug 14 2010 20:48:29.191085 3054451600]: CProcessLayer(0)::svc Start [3054451600]
[Sat Aug 14 2010 20:48:29.244137 3085924048]: try listening 38190 port
[Sat Aug 14 2010 20:48:29.245071 3043961744]: CProcessLayer(0)::svc Start [3043961744]
[Sat Aug 14 2010 20:48:29.245183 3033471888]: CProcessLayer(0)::svc Start [3033471888]
[Sat Aug 14 2010 20:48:29.245303 3022982032]: CProcessLayer(0)::svc Start [3022982032]
[Sat Aug 14 2010 20:48:29.245477 3012492176]: CProcessLayer(0)::svc Start [3012492176]
[Sat Aug 14 2010 20:48:29.245614 3002002320]: CProcessLayer(0)::svc Start [3002002320]
[Sat Aug 14 2010 20:48:29.245705 2991512464]: CProcessLayer(0)::svc Start [2991512464]
[Sat Aug 14 2010 20:48:29.759704 3085924048]: accept success 8(127.0.0.1:35176)
[Sat Aug 14 2010 20:48:29.761260 3085924048]: 1.open user 8 [8A54360] (127.0.0.1)
[Sat Aug 14 2010 20:48:30.103951 3085924048]: accept success 10(127.0.0.1:35180)
[Sat Aug 14 2010 20:48:30.104152 3085924048]: 2.open user 10 [8A62A80] (127.0.0.1)
[Sat Aug 14 2010 20:48:30.706483 3085924048]: accept success 11(127.0.0.1:35184)
[Sat Aug 14 2010 20:48:30.706633 3085924048]: 3.open user 11 [8A6ECB8] (127.0.0.1)

ChatNode

Code:

[Sat Aug 14 2010 20:48:29.447154 3086080496]: open log file  '/var/log/cabal/ChatNode_08.log'
[Sat Aug 14 2010 20:48:29.447337 3086080496]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:29.447408 3086080496]: MemPoolUnitSizeClass(2): 24576Bytes
[Sat Aug 14 2010 20:48:29.448081 3086080496]: Start ChatNode_08 Server
[Sat Aug 14 2010 20:48:29.448144 3086080496]: main(): ChatServerId(250:8:1)
[Sat Aug 14 2010 20:48:29.448193 3086080496]: ReloadConfig(): ReloadConfig
[Sat Aug 14 2010 20:48:29.448229 3086080496]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:29.448265 3086080496]: SetSayChannelMgrLogSay(): LogSay: 0
[Sat Aug 14 2010 20:48:29.448292 3086080496]: ReloadConfig(): BroadCastOverServerNation: 0
[Sat Aug 14 2010 20:48:29.448319 3086080496]: ReloadConfig(): UseGuildCreateFee: 1
[Sat Aug 14 2010 20:48:29.448346 3086080496]: ReloadConfig(): CharLevelForGuildCreate: 40
[Sat Aug 14 2010 20:48:29.448372 3086080496]: ReloadConfig(): AllowGuildBoard: 0
[Sat Aug 14 2010 20:48:29.455357 3085806480]: CProcessLayer(0)::svc Start [3085806480]
[Sat Aug 14 2010 20:48:29.455552 3075316624]: CProcessLayer(0)::svc Start [3075316624]
[Sat Aug 14 2010 20:48:29.455645 3064826768]: CProcessLayer(0)::svc Start [3064826768]
[Sat Aug 14 2010 20:48:29.455766 3054336912]: CProcessLayer(0)::svc Start [3054336912]
[Sat Aug 14 2010 20:48:29.455862 3043847056]: CProcessLayer(0)::svc Start [3043847056]
[Sat Aug 14 2010 20:48:29.495523 3086080496]: try connect 127.0.0.1:38170, Sync
[Sat Aug 14 2010 20:48:29.497027 3086080496]: sock 5 ->LinkHandler Open
[Sat Aug 14 2010 20:48:29.497117 3086080496]: SendIPSConnect2Svr (250:08:01:00)
[Sat Aug 14 2010 20:48:29.497201 3086080496]: try connect 127.0.0.1:38188, Sync
[Sat Aug 14 2010 20:48:29.499269 3086080496]: sock 7 ->LinkHandler Open
[Sat Aug 14 2010 20:48:29.499329 3086080496]: SendIPSConnect2Svr (250:08:01:00)
[Sat Aug 14 2010 20:48:29.499395 3086080496]: try listening 38128 port
[Sat Aug 14 2010 20:48:29.501148 3022867344]: CProcessLayer(0)::svc Start [3022867344]
[Sat Aug 14 2010 20:48:29.501358 3012377488]: CProcessLayer(0)::svc Start [3012377488]
[Sat Aug 14 2010 20:48:29.503588 3033357200]: CProcessLayer(0)::svc Start [3033357200]
[Sat Aug 14 2010 20:48:29.762565 3086080496]: accept success 9(127.0.0.1:49139)
[Sat Aug 14 2010 20:48:29.763133 3086080496]: 1.open user 9 [87817F0] (127.0.0.1)
[Sat Aug 14 2010 20:48:30.105521 3086080496]: accept success 10(127.0.0.1:49143)
[Sat Aug 14 2010 20:48:30.105700 3086080496]: 2.open user 10 [8788E78] (127.0.0.1)
[Sat Aug 14 2010 20:48:30.707539 3086080496]: accept success 11(127.0.0.1:49147)
[Sat Aug 14 2010 20:48:30.707691 3086080496]: 3.open user 11 [878F088] (127.0.0.1)
[Sat Aug 14 2010 20:48:55.199824 3022867344]: OnIPCConnect2Svr(): new WorldSvr linked(161, 8, 4)
[Sat Aug 14 2010 20:48:55.359624 3085806480]: OnIPCConnect2Svr(): new WorldSvr linked(161, 8, 1)
[Sat Aug 14 2010 20:48:57.608612 3064826768]: OnIPCConnect2Svr(): new WorldSvr linked(161, 8, 5)

DBAgent

Code:

[Sat Aug 14 2010 20:48:29.187755 3086292688]: open log file  '/var/log/cabal/DBAgent_08.log'
[Sat Aug 14 2010 20:48:29.187936 3086292688]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:29.188011 3086292688]: MemPoolUnitSizeClass(2): 24576Bytes
[Sat Aug 14 2010 20:48:29.189074 3086292688]: Start DBAgent_08 Server
[Sat Aug 14 2010 20:48:29.189903 3086292688]: UseEcryptText (Off)
[Sat Aug 14 2010 20:48:29.191268 3086289808]: CProcessLayer(0)::svc Start [3086289808]
[Sat Aug 14 2010 20:48:29.244828 3086292688]: try listening 38188 port
[Sat Aug 14 2010 20:48:29.245816 3075799952]: CProcessLayer(0)::svc Start [3075799952]
[Sat Aug 14 2010 20:48:29.245903 3065310096]: CProcessLayer(0)::svc Start [3065310096]
[Sat Aug 14 2010 20:48:29.246003 3054820240]: CProcessLayer(0)::svc Start [3054820240]
[Sat Aug 14 2010 20:48:29.246113 3044330384]: CProcessLayer(0)::svc Start [3044330384]
[Sat Aug 14 2010 20:48:29.497500 3086292688]: accept success 8(127.0.0.1:58189)
[Sat Aug 14 2010 20:48:29.498992 3086292688]: 1.open user 8 [8D3FB68] (127.0.0.1)
[Sat Aug 14 2010 20:48:29.757908 3086292688]: accept success 10(127.0.0.1:58191)
[Sat Aug 14 2010 20:48:29.758262 3086292688]: 2.open user 10 [8D4E2A8] (127.0.0.1)
[Sat Aug 14 2010 20:48:30.101800 3086292688]: accept success 11(127.0.0.1:58195)
[Sat Aug 14 2010 20:48:30.102169 3086292688]: 3.open user 11 [8D5A4B8] (127.0.0.1)
[Sat Aug 14 2010 20:48:30.705298 3086292688]: accept success 12(127.0.0.1:58199)
[Sat Aug 14 2010 20:48:30.705502 3086292688]: 4.open user 12 [8D666F0] (127.0.0.1)
[Sat Aug 14 2010 20:48:56.450533 3054820240]: Database Connect success!
[Sat Aug 14 2010 20:48:56.536813 3086289808]: Database Connect success!
[Sat Aug 14 2010 20:48:56.644965 3065310096]: Database Connect success!
[Sat Aug 14 2010 20:48:57.533756 3044330384]: Database Connect success!
[Sat Aug 14 2010 20:48:58.418933 3075799952]: Database Connect success!

GLOBALDBAGENT

Code:

[Sat Aug 14 2010 20:48:28.465636 3086218960]: open log file  '/var/log/cabal/GlobalDBAgent.log'
[Sat Aug 14 2010 20:48:28.466186 3086218960]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:28.466298 3086218960]: MemPoolUnitSizeClass(0): 14336Bytes
[Sat Aug 14 2010 20:48:28.467343 3086218960]: Start GlobalDBAgent Server
[Sat Aug 14 2010 20:48:28.468186 3086218960]: UseEcryptText (Off)
[Sat Aug 14 2010 20:48:28.469437 3086216080]: CProcessLayer(0)::svc Start [3086216080]
[Sat Aug 14 2010 20:48:28.469600 3075726224]: CProcessLayer(0)::svc Start [3075726224]
[Sat Aug 14 2010 20:48:28.469692 3065236368]: CProcessLayer(0)::svc Start [3065236368]
[Sat Aug 14 2010 20:48:28.469804 3054746512]: CProcessLayer(0)::svc Start [3054746512]
[Sat Aug 14 2010 20:48:28.584090 3044256656]: CProcessLayer(0)::svc Start [3044256656]
[Sat Aug 14 2010 20:48:28.584753 3086218960]: try listening 38180 port
[Sat Aug 14 2010 20:48:28.585105 3033766800]: CProcessLayer(0)::svc Start [3033766800]
[Sat Aug 14 2010 20:48:28.585208 3023276944]: CProcessLayer(0)::svc Start [3023276944]
[Sat Aug 14 2010 20:48:28.585400 3012787088]: CProcessLayer(0)::svc Start [3012787088]
[Sat Aug 14 2010 20:48:28.585493 3002297232]: CProcessLayer(0)::svc Start [3002297232]
[Sat Aug 14 2010 20:48:28.585585 2991807376]: CProcessLayer(0)::svc Start [2991807376]
[Sat Aug 14 2010 20:48:28.947998 3086218960]: accept success 8(127.0.0.1:46979)
[Sat Aug 14 2010 20:48:28.949619 3086218960]: 1.open user 8 [9540388] (127.0.0.1)
[Sat Aug 14 2010 20:48:53.216920 3086218960]: accept success 10(127.0.0.1:46995)
[Sat Aug 14 2010 20:48:53.457929 3086218960]: 2.open user 10 [954EAA0] (127.0.0.1)
[Sat Aug 14 2010 20:50:29.457573 3075726224]: Database Connect success!
[Sat Aug 14 2010 20:50:29.585375 3075726224]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Sat Aug 14 2010 20:50:29.585530 3075726224]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
[Sat Aug 14 2010 20:50:29.585554 3075726224]: [##ERROR##] DB ERROR(CODE)     : 242
[Sat Aug 14 2010 20:50:29.585571 3075726224]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Aug 14 2010 20:50:29.585588 3075726224]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Sat Aug 14 2010 20:50:29.585605 3075726224]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ?               , ?               , ?          ,  ?               )}
[Sat Aug 14 2010 20:50:29.718606 3075726224]: Database Connect success!
[Sat Aug 14 2010 20:50:29.718671 3075726224]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Sat Aug 14 2010 20:50:29.718699 3075726224]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)
[Sat Aug 14 2010 20:55:12.597796 3075726224]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Sat Aug 14 2010 20:55:12.597892 3075726224]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
[Sat Aug 14 2010 20:55:12.597913 3075726224]: [##ERROR##] DB ERROR(CODE)     : 242
[Sat Aug 14 2010 20:55:12.597931 3075726224]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Sat Aug 14 2010 20:55:12.597948 3075726224]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Sat Aug 14 2010 20:55:12.597965 3075726224]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ?               , ?               , ?          ,  ?               )}
[Sat Aug 14 2010 20:55:12.735965 3075726224]: Database Connect success!
[Sat Aug 14 2010 20:55:12.736024 3075726224]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Sat Aug 14 2010 20:55:12.736049 3075726224]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)

GlobalMgrSvr

Code:

[Sat Aug 14 2010 20:48:28.747610 3086608096]: open log file  '/var/log/cabal/GlobalMgrSvr.log'
[Sat Aug 14 2010 20:48:28.747799 3086608096]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:28.747864 3086608096]: MemPoolUnitSizeClass(0): 14336Bytes
[Sat Aug 14 2010 20:48:28.748929 3086608096]: Start GlobalMgrSvr Server
[Sat Aug 14 2010 20:48:28.756695 3086608096]: LoadServerAndChannelType(1)
[Sat Aug 14 2010 20:48:28.756806 3086608096]: channelType[1][1]: 0
[Sat Aug 14 2010 20:48:28.756835 3086608096]: maxUserName[1][1]: 100
[Sat Aug 14 2010 20:48:28.757575 3086608096]: channelType[2][1]: 1
[Sat Aug 14 2010 20:48:28.757611 3086608096]: maxUserName[2][1]: 100
[Sat Aug 14 2010 20:48:28.758198 3086608096]: channelType[3][1]: 8
[Sat Aug 14 2010 20:48:28.758251 3086608096]: maxUserName[3][1]: 100
[Sat Aug 14 2010 20:48:28.758858 3086608096]: channelType[4][10]: 16908368
[Sat Aug 14 2010 20:48:28.758888 3086608096]: maxUserName[4][10]: 100
[Sat Aug 14 2010 20:48:28.759420 3086608096]: channelType[5][1]: 0
[Sat Aug 14 2010 20:48:28.759457 3086608096]: maxUserName[5][1]: 100
[Sat Aug 14 2010 20:48:28.759520 3086608096]: channelType[5][10]: 16908368
[Sat Aug 14 2010 20:48:28.759547 3086608096]: maxUserName[5][10]: 100
[Sat Aug 14 2010 20:48:28.760206 3086608096]: channelType[6][1]: 0
[Sat Aug 14 2010 20:48:28.760251 3086608096]: maxUserName[6][1]: 100
[Sat Aug 14 2010 20:48:28.760289 3086608096]: channelType[6][4]: 8
[Sat Aug 14 2010 20:48:28.760315 3086608096]: maxUserName[6][4]: 100
[Sat Aug 14 2010 20:48:28.760365 3086608096]: channelType[6][10]: 16908368
[Sat Aug 14 2010 20:48:28.760391 3086608096]: maxUserName[6][10]: 100
[Sat Aug 14 2010 20:48:28.761015 3086608096]: channelType[7][1]: 1
[Sat Aug 14 2010 20:48:28.761047 3086608096]: maxUserName[7][1]: 100
[Sat Aug 14 2010 20:48:28.761084 3086608096]: channelType[7][4]: 8
[Sat Aug 14 2010 20:48:28.761111 3086608096]: maxUserName[7][4]: 100
[Sat Aug 14 2010 20:48:28.761161 3086608096]: channelType[7][10]: 16908368
[Sat Aug 14 2010 20:48:28.761188 3086608096]: maxUserName[7][10]: 100
[Sat Aug 14 2010 20:48:28.762259 3086608096]: channelType[8][1]: 1
[Sat Aug 14 2010 20:48:28.762323 3086608096]: maxUserName[8][1]: 100
[Sat Aug 14 2010 20:48:28.762365 3086608096]: channelType[8][4]: 4
[Sat Aug 14 2010 20:48:28.762392 3086608096]: maxUserName[8][4]: 100
[Sat Aug 14 2010 20:48:28.762421 3086608096]: channelType[8][5]: 12
[Sat Aug 14 2010 20:48:28.762447 3086608096]: maxUserName[8][5]: 100
[Sat Aug 14 2010 20:48:28.762493 3086608096]: channelType[8][10]: 16908368
[Sat Aug 14 2010 20:48:28.762520 3086608096]: maxUserName[8][10]: 100
[Sat Aug 14 2010 20:48:28.763079 3086608096]: channelType[9][1]: 1
[Sat Aug 14 2010 20:48:28.763111 3086608096]: maxUserName[9][1]: 100
[Sat Aug 14 2010 20:48:28.763139 3086608096]: channelType[9][2]: 4
[Sat Aug 14 2010 20:48:28.763165 3086608096]: maxUserName[9][2]: 100
[Sat Aug 14 2010 20:48:28.763198 3086608096]: channelType[9][4]: 8
[Sat Aug 14 2010 20:48:28.763239 3086608096]: maxUserName[9][4]: 100
[Sat Aug 14 2010 20:48:28.763292 3086608096]: channelType[9][10]: 16908368
[Sat Aug 14 2010 20:48:28.763319 3086608096]: maxUserName[9][10]: 100
[Sat Aug 14 2010 20:48:28.763859 3086608096]: channelType[10][1]: 0
[Sat Aug 14 2010 20:48:28.763889 3086608096]: maxUserName[10][1]: 100
[Sat Aug 14 2010 20:48:28.763917 3086608096]: channelType[10][2]: 4
[Sat Aug 14 2010 20:48:28.763944 3086608096]: maxUserName[10][2]: 100
[Sat Aug 14 2010 20:48:28.763982 3086608096]: channelType[10][4]: 5
[Sat Aug 14 2010 20:48:28.764008 3086608096]: maxUserName[10][4]: 100
[Sat Aug 14 2010 20:48:28.764036 3086608096]: channelType[10][5]: 12
[Sat Aug 14 2010 20:48:28.764063 3086608096]: maxUserName[10][5]: 100
[Sat Aug 14 2010 20:48:28.764116 3086608096]: channelType[10][10]: 16908368
[Sat Aug 14 2010 20:48:28.764142 3086608096]: maxUserName[10][10]: 100
[Sat Aug 14 2010 20:48:28.764680 3086608096]: channelType[11][1]: 0
[Sat Aug 14 2010 20:48:28.764710 3086608096]: maxUserName[11][1]: 100
[Sat Aug 14 2010 20:48:28.765297 3086608096]: channelType[12][1]: 8
[Sat Aug 14 2010 20:48:28.765328 3086608096]: maxUserName[12][1]: 100
[Sat Aug 14 2010 20:48:28.768635 3086608096]: channelType[18][1]: 0
[Sat Aug 14 2010 20:48:28.768755 3086608096]: maxUserName[18][1]: 100
[Sat Aug 14 2010 20:48:28.768791 3086608096]: channelType[18][2]: 1
[Sat Aug 14 2010 20:48:28.768818 3086608096]: maxUserName[18][2]: 100
[Sat Aug 14 2010 20:48:28.769391 3086608096]: channelType[19][1]: 0
[Sat Aug 14 2010 20:48:28.769422 3086608096]: maxUserName[19][1]: 100
[Sat Aug 14 2010 20:48:28.769451 3086608096]: channelType[19][2]: 1
[Sat Aug 14 2010 20:48:28.769477 3086608096]: maxUserName[19][2]: 100
[Sat Aug 14 2010 20:48:28.770338 3086608096]: channelType[20][1]: 0
[Sat Aug 14 2010 20:48:28.770434 3086608096]: maxUserName[20][1]: 100
[Sat Aug 14 2010 20:48:28.770465 3086608096]: channelType[20][2]: 1
[Sat Aug 14 2010 20:48:28.770492 3086608096]: maxUserName[20][2]: 100
[Sat Aug 14 2010 20:48:28.773108 3086608096]: channelType[24][1]: 1
[Sat Aug 14 2010 20:48:28.773208 3086608096]: maxUserName[24][1]: 100
[Sat Aug 14 2010 20:48:28.947179 3086608096]: try connect 127.0.0.1:38180, Sync
[Sat Aug 14 2010 20:48:28.950351 3086608096]: sock 7 ->LinkHandler Open
[Sat Aug 14 2010 20:48:28.950451 3086608096]: SendIPSConnect2Svr (246:128:00:00)
[Sat Aug 14 2010 20:48:28.950512 3086608096]: try listening 38170 port
[Sat Aug 14 2010 20:48:28.990896 3086138256]: CProcessLayer(0)::svc Start [3086138256]
[Sat Aug 14 2010 20:48:29.495972 3086608096]: accept success 10(127.0.0.1:54073)
[Sat Aug 14 2010 20:48:29.496187 3086608096]: 1.open user 10 [95476B0] (127.0.0.1)
[Sat Aug 14 2010 20:48:29.500023 3086138256]: new chatnode session (08:01)
[Sat Aug 14 2010 20:48:29.752625 3086608096]: accept success 11(127.0.0.1:54075)
[Sat Aug 14 2010 20:48:29.752846 3086608096]: 2.open user 11 [954DB00] (127.0.0.1)
[Sat Aug 14 2010 20:48:29.763457 3086138256]: new chat server session (250:08:01)
[Sat Aug 14 2010 20:48:30.099836 3086608096]: accept success 12(127.0.0.1:54079)
[Sat Aug 14 2010 20:48:30.100024 3086608096]: 3.open user 12 [9554098] (127.0.0.1)
[Sat Aug 14 2010 20:48:30.702851 3086608096]: accept success 13(127.0.0.1:54083)
[Sat Aug 14 2010 20:48:30.703115 3086608096]: 4.open user 13 [955A328] (127.0.0.1)
[Sat Aug 14 2010 20:48:52.723274 3086608096]: accept success 14(127.0.0.1:54087)
[Sat Aug 14 2010 20:48:53.004960 3086608096]: 5.open user 14 [95605B8] (127.0.0.1)
[Sat Aug 14 2010 20:48:53.214821 3086138256]: new server session (128:01)
[Sat Aug 14 2010 20:48:55.147739 3086138256]: new server session (08:04)
[Sat Aug 14 2010 20:48:55.425957 3086138256]: new server session (08:01)
[Sat Aug 14 2010 20:48:57.610114 3086138256]: new server session (08:05)

LoginSvr

Code:

[Sat Aug 14 2010 20:48:31.622343 3086273008]: open log file  '/var/log/cabal/LoginSvr_01.log'
[Sat Aug 14 2010 20:48:31.622574 3086273008]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:31.622637 3086273008]: MemPoolUnitSizeClass(0): 14336Bytes
[Sat Aug 14 2010 20:48:31.623550 3086273008]: Start LoginSvr_01 Server
[Sat Aug 14 2010 20:48:31.623626 3086273008]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Sat Aug 14 2010 20:48:31.623666 3086273008]: TestChannelGroupIdxStartPoint=50
[Sat Aug 14 2010 20:48:31.623765 3086273008]: affiliatedCorpIP=121.170.135.;
[Sat Aug 14 2010 20:48:31.623797 3086273008]: AdminIP=121.170.135.;
[Sat Aug 14 2010 20:48:31.623834 3086273008]: client_version=22
[Sat Aug 14 2010 20:48:31.623873 3086273008]: IgnoreClientVersion(1)
[Sat Aug 14 2010 20:48:31.623910 3086273008]: UseAntiOnlineGameAddictionSystem(1)
[Sat Aug 14 2010 20:48:31.623936 3086273008]: AdultAge(18)
[Sat Aug 14 2010 20:48:31.623960 3086273008]: DefaultAgeAdult(1)
[Sat Aug 14 2010 20:48:31.623985 3086273008]: UsePSS(0)
[Sat Aug 14 2010 20:48:31.624010 3086273008]: CachedPSS(0)
[Sat Aug 14 2010 20:48:31.624039 3086273008]: PssCacheDurationMin(1440)
[Sat Aug 14 2010 20:48:31.624065 3086273008]: CutIfPssUserNotFound(0)
[Sat Aug 14 2010 20:48:31.624091 3086273008]: PssLogLevel(0)
[Sat Aug 14 2010 20:48:31.624115 3086273008]: InstantPlayTimeClearIntervalMin(300)
[Sat Aug 14 2010 20:48:31.624141 3086273008]: IDC(1)
[Sat Aug 14 2010 20:48:31.624165 3086273008]: SharedPssPersonId(0)
[Sat Aug 14 2010 20:48:31.624191 3086273008]: NormalClientMagicKey(1168110)
[Sat Aug 14 2010 20:48:31.624216 3086273008]: UseImageAuth(0)
[Sat Aug 14 2010 20:48:31.624261 3086273008]: ImageAuthDataPath(./ImageAuth/)
[Sat Aug 14 2010 20:48:31.624288 3086273008]: ImageAuthMaxTryCount(5)
[Sat Aug 14 2010 20:48:31.624314 3086273008]: ImageAuthWaitTime(120000)
[Sat Aug 14 2010 20:48:31.624339 3086273008]: BlockIfImageAuthFail(0)
[Sat Aug 14 2010 20:48:31.624365 3086273008]: UseServerListManualOrder(0)
[Sat Aug 14 2010 20:48:31.624388 3086273008]: 00:00 => 0
[Sat Aug 14 2010 20:48:31.624411 3086273008]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Sat Aug 14 2010 20:48:31.624436 3086273008]: ImageAuthDataMgr Init Begin
[Sat Aug 14 2010 20:48:52.376596 3086273008]: ImageAuthDataMgr Init End(Count:1995)
[Sat Aug 14 2010 20:48:52.718428 3077970832]: CProcessLayer(0)::svc Start [3077970832]
[Sat Aug 14 2010 20:48:52.722649 3086273008]: try connect 127.0.0.1:38170, Sync
[Sat Aug 14 2010 20:48:53.213696 3086273008]: sock 7 ->LinkHandler Open
[Sat Aug 14 2010 20:48:53.213888 3086273008]: SendIPSConnect2Svr (195:128:01:00)
[Sat Aug 14 2010 20:48:53.214075 3086273008]: try connect 127.0.0.1:38180, Sync
[Sat Aug 14 2010 20:48:53.214400 3086273008]: sock 9 ->LinkHandler Open
[Sat Aug 14 2010 20:48:53.214448 3086273008]: SendIPSConnect2Svr (195:128:01:00)
[Sat Aug 14 2010 20:48:53.214529 3086273008]: try listening 38101 port
[Sat Aug 14 2010 20:48:53.216521 3077970832]: ServerState changed(0 -> 0)
[Sat Aug 14 2010 20:50:29.118594 3086273008]: accept success 11(190.206.121.107:4325)
[Sat Aug 14 2010 20:50:29.118928 3086273008]: 1.open user 11 [86AE0C8] (190.206.121.107)
[Sat Aug 14 2010 20:50:29.342166 3077970832]: AuthRequest: UserID(gabotamn), Addr(190.206.121.107)
[Sat Aug 14 2010 20:51:16.077380 3086273008]: 1.close user 11 [86AE0C8] (190.206.121.107)
[Sat Aug 14 2010 20:51:25.620283 3086273008]: accept success 11(190.206.121.107:4326)
[Sat Aug 14 2010 20:51:25.620475 3086273008]: 1.open user 11 [86AE0C8] (190.206.121.107)
[Sat Aug 14 2010 20:51:25.832654 3077970832]: AuthRequest: UserID(gabotamn), Addr(190.206.121.107)
[Sat Aug 14 2010 20:51:25.874010 3077970832]: AuthResult: UserID(gabotamn), Addr(190.206.121.107), Result(33), UserNum(0)
[Sat Aug 14 2010 20:51:26.470978 3086273008]: 1.close user 11 [86AE0C8] (190.206.121.107)
[Sat Aug 14 2010 20:55:12.299571 3086273008]: accept success 11(190.206.121.107:4327)
[Sat Aug 14 2010 20:55:12.299861 3086273008]: 1.open user 11 [86AE0C8] (190.206.121.107)
[Sat Aug 14 2010 20:55:12.502933 3077970832]: AuthRequest: UserID(gabotamn), Addr(190.206.121.107)
[Sat Aug 14 2010 20:55:48.785970 3086273008]: 1.close user 11 [86AE0C8] (190.206.121.107)

Worldsvr..

Code:

[Sat Aug 14 2010 20:48:29.746142 3488240]: open log file  '/var/log/cabal/WorldSvr_08_01.log'
[Sat Aug 14 2010 20:48:29.746387 3488240]: LOG LEVEL: 3
[Sat Aug 14 2010 20:48:29.746487 3488240]: MemPoolUnitSizeClass(5): 16384Bytes
[Sat Aug 14 2010 20:48:29.747487 3488240]: Start WorldSvr_08_01 Server
[Sat Aug 14 2010 20:48:29.747636 3488240]: CheckSkillCoolTimeHack (Off)
[Sat Aug 14 2010 20:48:29.747665 3488240]: CheckShopHack (Off)
[Sat Aug 14 2010 20:48:29.747690 3488240]: CheckWarpHack (Off)
[Sat Aug 14 2010 20:48:29.747718 3488240]: CheckWareHouseHack (Off)
[Sat Aug 14 2010 20:48:29.747766 3488240]: UseCheckDistanceSkillHack (Off)
[Sat Aug 14 2010 20:48:29.747793 3488240]: MaxTimeHackingCount(2)
[Sat Aug 14 2010 20:48:29.747819 3488240]: MaxDistanceHackingCount(2)
[Sat Aug 14 2010 20:48:29.747846 3488240]: UseNonClientCheck (Off)
[Sat Aug 14 2010 20:48:29.747872 3488240]: NonClientDisAdvantageRate (90)
[Sat Aug 14 2010 20:48:29.747898 3488240]: useDropDiscount (On)
[Sat Aug 14 2010 20:48:29.747924 3488240]: UseBlessingBeadCheck (Off)
[Sat Aug 14 2010 20:48:29.747950 3488240]: AllowTradeChannel (Off)
[Sat Aug 14 2010 20:48:29.747985 3488240]: UseCheckMissionIdx(Off)
[Sat Aug 14 2010 20:48:29.748011 3488240]: UseCheckDeadStatActive(Off)
[Sat Aug 14 2010 20:48:29.748038 3488240]: reload ActiveDeadStatCount(30)
[Sat Aug 14 2010 20:48:29.748064 3488240]: UseHackcheckByTimeScope (Off)
[Sat Aug 14 2010 20:48:29.748090 3488240]: CheckSkillTimeHackScope(60000)
[Sat Aug 14 2010 20:48:29.748117 3488240]: UseMobsChaseModify (On)
[Sat Aug 14 2010 20:48:29.748143 3488240]: UseAlzDbHackCheck (Off)
[Sat Aug 14 2010 20:48:29.748169 3488240]: UseCutIfAlzDbHacked (Off)
[Sat Aug 14 2010 20:48:29.748195 3488240]: useCheckUserAttack (Off)
[Sat Aug 14 2010 20:48:29.748284 3488240]: UseHackUserDBSave (On)
[Sat Aug 14 2010 20:48:29.748319 3488240]: UseAdminUser (On)
[Sat Aug 14 2010 20:48:29.748374 3488240]: UseAntiOnlineGameAddictionSystem(1)
[Sat Aug 14 2010 20:48:29.748402 3488240]: InstantPlayTimeClearIntervalMin(300)
[Sat Aug 14 2010 20:48:29.748438 3488240]: InstantPlayTimeDbUpdateIntervalMin(5)
[Sat Aug 14 2010 20:48:29.748465 3488240]: InstantPlayTimeNotifyIntervalMin(1)
[Sat Aug 14 2010 20:48:29.748492 3488240]: AdvantageBoundaryTime(10800, 18000)
[Sat Aug 14 2010 20:48:29.748519 3488240]: InstantPlayTimeDebugMultiple(1)
[Sat Aug 14 2010 20:48:29.748545 3488240]: UseCheckBelongItem (Off)
[Sat Aug 14 2010 20:48:29.748571 3488240]: UseCheckDMZArea (Off)
[Sat Aug 14 2010 20:48:29.748597 3488240]: AllowCashShop(1)
[Sat Aug 14 2010 20:48:29.748623 3488240]: AllowNetcafePoint(0)
[Sat Aug 14 2010 20:48:29.748648 3488240]: RestrictOddCircleUseCountInDungeon (On)
[Sat Aug 14 2010 20:48:29.749398 3488240]: UseAdditionalMissionDungeonInstanceInPremiumCH (Off)
[Sat Aug 14 2010 20:48:29.749458 3488240]: UseAdditionalMissionDungeonInstanceInPremiumUser (Off)
[Sat Aug 14 2010 20:48:29.749483 3488240]: AdditionalMissionDungeonInstanceCount (0)
[Sat Aug 14 2010 20:48:29.749510 3488240]: UsePvpBetting (Off)
[Sat Aug 14 2010 20:48:29.749619 3488240]: PShopOpenLimitCount (0)
[Sat Aug 14 2010 20:48:29.749646 3488240]: UseTradeChannelRestriction (Off)
[Sat Aug 14 2010 20:48:29.749672 3488240]: UseArtOfDefensePenalty (On)
[Sat Aug 14 2010 20:48:29.749699 3488240]: IgnorePartyInviteDistance (Off)
[Sat Aug 14 2010 20:48:29.749748 3488240]: UseWorldDrop (On)
[Sat Aug 14 2010 20:48:29.749777 3488240]: UseInventoryHackCheck (Off)
[Sat Aug 14 2010 20:48:29.749803 3488240]: UseRandomValueWriteLog (Off)
[Sat Aug 14 2010 20:48:29.749829 3488240]: UseMinLevDiffValueForExpCalc (On)
[Sat Aug 14 2010 20:48:29.749855 3488240]: UsePartyMinExpForInvalidPartyMember (On)
[Sat Aug 14 2010 20:48:29.749880 3488240]: UseIgnoreOtherBlessBuff (Off)
[Sat Aug 14 2010 20:48:29.749905 3488240]: Extended Alz Mode
[Sat Aug 14 2010 20:48:29.749951 3488240]: GameGuard enabled version
[Sat Aug 14 2010 20:48:29.749983 3488240]: GameGuard turned off
[Sat Aug 14 2010 20:48:29.750005 3488240]: APEX enabled version
[Sat Aug 14 2010 20:48:29.750029 3488240]: APEX turned off
[Sat Aug 14 2010 20:48:29.750061 3488240]: XTrap disabled version
[Sat Aug 14 2010 20:48:29.750136 3488240]: WaitUntilChannelTypeSet(Off)
[Sat Aug 14 2010 20:48:29.750164 3488240]: UseBootUpGmsChannelType(On)
[Sat Aug 14 2010 20:48:29.751387 3488240]: Local ip = 200.109.142.89 (from ini)
[Sat Aug 14 2010 20:48:29.751478 3488240]: MaxAttackHackTime (300000)
[Sat Aug 14 2010 20:48:29.751506 3488240]: SpeedHackCheckTime (10000)
[Sat Aug 14 2010 20:48:29.752301 3488240]: try connect 127.0.0.1:38170, Sync
[Sat Aug 14 2010 20:48:29.753617 3488240]: sock 5 ->LinkHandler Open
[Sat Aug 14 2010 20:48:29.753708 3488240]: SendIPSConnect2Svr (161:08:01:00)
[Sat Aug 14 2010 20:48:29.753850 3488240]: try connect 127.0.0.1:38188, Sync
[Sat Aug 14 2010 20:48:29.759179 3488240]: sock 7 ->LinkHandler Open
[Sat Aug 14 2010 20:48:29.759286 3488240]: SendIPSConnect2Svr (161:08:01:00)
[Sat Aug 14 2010 20:48:29.759358 3488240]: try connect 127.0.0.1:38190, Sync
[Sat Aug 14 2010 20:48:29.761699 3488240]: sock 8 ->LinkHandler Open
[Sat Aug 14 2010 20:48:29.761780 3488240]: SendIPSConnect2Svr (161:08:01:00)
[Sat Aug 14 2010 20:48:29.761860 3488240]: try connect 127.0.0.1:38128, Sync
[Sat Aug 14 2010 20:48:29.764030 3488240]: sock 9 ->LinkHandler Open
[Sat Aug 14 2010 20:48:29.764092 3488240]: SendIPSConnect2Svr (161:08:01:00)
[Sat Aug 14 2010 20:48:29.807489 24017808]: CProcessLayer(0)::svc Start [24017808]
[Sat Aug 14 2010 20:48:30.005845 3488240]: GuildCreateFee: 10000000
[Sat Aug 14 2010 20:48:39.431982 92593040]: CProcessLayer(1)::svc Start [92593040]
[Sat Aug 14 2010 20:48:39.724471 39291792]: CProcessLayer(2)::svc Start [39291792]
[Sat Aug 14 2010 20:48:40.198549 72076176]: CProcessLayer(3)::svc Start [72076176]
[Sat Aug 14 2010 20:48:41.055626 118741904]: CProcessLayer(4)::svc Start [118741904]
[Sat Aug 14 2010 20:48:42.123062 129231760]: CProcessLayer(5)::svc Start [129231760]
[Sat Aug 14 2010 20:48:43.211165 3086330768]: CProcessLayer(6)::svc Start [3086330768]
[Sat Aug 14 2010 20:48:43.566804 3075840912]: CProcessLayer(7)::svc Start [3075840912]
[Sat Aug 14 2010 20:48:43.748198 3060104080]: CProcessLayer(8)::svc Start [3060104080]
[Sat Aug 14 2010 20:48:44.131802 3043322768]: CProcessLayer(9)::svc Start [3043322768]
[Sat Aug 14 2010 20:48:44.738603 3025615760]: CProcessLayer(10)::svc Start [3025615760]
[Sat Aug 14 2010 20:48:45.219519 3007073168]: CProcessLayer(13)::svc Start [3007073168]
[Sat Aug 14 2010 20:48:45.786680 2991721360]: CProcessLayer(14)::svc Start [2991721360]
[Sat Aug 14 2010 20:48:46.489906 2972367760]: CProcessLayer(19)::svc Start [2972367760]
[Sat Aug 14 2010 20:48:47.253382 2958265232]: CProcessLayer(23)::svc Start [2958265232]
[Sat Aug 14 2010 20:48:47.263321 2943363984]: CProcessLayer(24)::svc Start [2943363984]
[Sat Aug 14 2010 20:48:48.050624 2928425872]: CProcessLayer(25)::svc Start [2928425872]
[Sat Aug 14 2010 20:48:48.050703 2914073488]: CProcessLayer(26)::svc Start [2914073488]
[Sat Aug 14 2010 20:48:49.169547 2899721104]: CProcessLayer(27)::svc Start [2899721104]
[Sat Aug 14 2010 20:48:49.369553 2885368720]: CProcessLayer(28)::svc Start [2885368720]
[Sat Aug 14 2010 20:48:49.369817 2870541200]: CProcessLayer(29)::svc Start [2870541200]
[Sat Aug 14 2010 20:48:50.274062 3488240]: try listening 38111 port
[Sat Aug 14 2010 20:48:50.858698 2855545744]: CProcessLayer(30)::svc Start [2855545744]
[Sat Aug 14 2010 20:48:55.500848 24017808]: ChannelType changed(0 -> 1)

My firewall is off and antivirus:S

**MentaL**

**TanGzkie** · 15-08-10

Check your PM..

**emi** · 15-08-10

See that :[Sat Aug 14 2010 20:50:29.585530 3075726224]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo
There is a problem with your premium settings

**maggieta2** · 15-08-10

no, nothing, i make renew the server and no loggin :S:S the conection of user is closed :S

**maggieta2** · 16-08-10

please help

**maggieta2** · 17-08-10

Originally Posted by emi

See that :[Sat Aug 14 2010 20:50:29.585530 3075726224]: [##ERROR##] DB ERROR(MSG) : [FreeTDS][SQL Server]La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo
There is a problem with your premium settings

i dont understand, to you refer.

but i in this moment format my pc install xp, install sql 2000 configure, restore the db, make the user, make the link server, install vmware, transfer the files, install cabal, configure, and up the server.
logical to run :S... but no!!!, continue the error, i don't understand what is the problem, all is good, and i use the Chumpy files :S :S:S:S please help, realy need up this, my old user's is furious in this moment, and don't see solutions!!

**chumpywumpy** · 23-08-10

This is a time conversion bug with sql2000 and some language types (not sure if it exists on 2005).

Check your stored procedures in the account db. cabal_sp_auth

Code:

	-- Check free ip
	DECLARE @rIsFreeIp as int
	SET @rIsFreeIp = 0

	IF EXISTS (SELECT * FROM cabal_freeip_list WHERE IP=@ip)
	BEGIN
		SET @rIsFreeIp = 1
	END


/*  ! WARNING ! Causes problems on some languages
	-- Free time (everyday PM 21~22)
	DECLARE @StartFreeTime as DATETIME, @EndFreeTime as DATETIME
	SET @StartFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '21:00:00'
	SET @EndFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'
	IF @rExpireDate < GETDATE() and @StartFreeTime < GETDATE() and GETDATE() < @EndFreeTime
	BEGIN
		SET @rType = 2
		SET @rExpireDate = @EndFreeTime
	END
*/

	--IF @rExpireDate < GETDATE() and @rPayMinutes <= 0 and @rIsFreeIp <> 1
	--BEGIN
		-- ?? ?? ??
		--COMMIT TRAN
		--SELECT @AR_TIMEEXP, @rusernum, @rlogin
		--RETURN
	--END

Find that code and add the 2 red lines where i did and the problem will go away. Nobody uses free time premium anyway

**magraopb** · 24-08-10

i have same problem like maggieta2, but this dont work to me

Originally Posted by chumpywumpy

This is a time conversion bug with sql2000 and some language types (not sure if it exists on 2005).

Check your stored procedures in the account db. cabal_sp_auth

Code:

    -- Check free ip
    DECLARE @rIsFreeIp as int
    SET @rIsFreeIp = 0

    IF EXISTS (SELECT * FROM cabal_freeip_list WHERE IP=@ip)
    BEGIN
        SET @rIsFreeIp = 1
    END


/*  ! WARNING ! Causes problems on some languages
    -- Free time (everyday PM 21~22)
    DECLARE @StartFreeTime as DATETIME, @EndFreeTime as DATETIME
    SET @StartFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '21:00:00'
    SET @EndFreeTime = CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'
    IF @rExpireDate < GETDATE() and @StartFreeTime < GETDATE() and GETDATE() < @EndFreeTime
    BEGIN
        SET @rType = 2
        SET @rExpireDate = @EndFreeTime
    END
*/

    --IF @rExpireDate < GETDATE() and @rPayMinutes <= 0 and @rIsFreeIp <> 1
    --BEGIN
        -- ?? ?? ??
        --COMMIT TRAN
        --SELECT @AR_TIMEEXP, @rusernum, @rlogin
        --RETURN
    --END

Find that code and add the 2 red lines where i did and the problem will go away. Nobody uses free time premium anyway

URGENT!! Please!!

Thread Tools

Search Thread

URGENT!! Please!!

Re: URGENT!! Please!!

Re: URGENT!! Please!!

Re: URGENT!! Please!!

Re: URGENT!! Please!!

Re: URGENT!! Please!!

Re: URGENT!! Please!!

Re: URGENT!! Please!!

Advertisement