It has stopped connecting with the servant [Solved]

[lorfirewall]

Hello, I have or new problem, and is that, without coming to story, it has only stopped working. From I cannot yesterday enter the servant.
In logs it removes this one error to me:

[Fri Nov 13 2009 17:04:47.166846 3033770896]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ? , ? , ? , ? )}

I leave all the lodgs:

GlobalDBAgent:

[Fri Nov 13 2009 17:04:13.466742 3086223056]: open log file  '/var/log/cabal/GlobalDBAgent.log'
[Fri Nov 13 2009 17:04:13.466905 3086223056]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.466961 3086223056]: MemPoolUnitSizeClass(0): 14336Bytes
[Fri Nov 13 2009 17:04:13.467929 3086223056]: Start GlobalDBAgent Server
[Fri Nov 13 2009 17:04:13.468786 3086223056]: UseEcryptText (Off)
[Fri Nov 13 2009 17:04:13.470842 3086220176]: CProcessLayer(0)::svc Start [3086220176]
[Fri Nov 13 2009 17:04:13.470994 3075730320]: CProcessLayer(0)::svc Start [3075730320]
[Fri Nov 13 2009 17:04:13.471076 3065240464]: CProcessLayer(0)::svc Start [3065240464]
[Fri Nov 13 2009 17:04:13.471148 3054750608]: CProcessLayer(0)::svc Start [3054750608]
[Fri Nov 13 2009 17:04:13.471235 3044260752]: CProcessLayer(0)::svc Start [3044260752]
[Fri Nov 13 2009 17:04:13.471518 3086223056]: try listening 38180 port
[Fri Nov 13 2009 17:04:13.471736 3033770896]: CProcessLayer(0)::svc Start [3033770896]
[Fri Nov 13 2009 17:04:13.471812 3023281040]: CProcessLayer(0)::svc Start [3023281040]
[Fri Nov 13 2009 17:04:13.471883 3012791184]: CProcessLayer(0)::svc Start [3012791184]
[Fri Nov 13 2009 17:04:13.471966 3002301328]: CProcessLayer(0)::svc Start [3002301328]
[Fri Nov 13 2009 17:04:13.472039 2991811472]: CProcessLayer(0)::svc Start [2991811472]
[Fri Nov 13 2009 17:04:13.682942 3086223056]: accept success 8(127.0.0.1:36121)
[Fri Nov 13 2009 17:04:13.683505 3086223056]: 1.open user 8 [92D1720] (127.0.0.1)
[Fri Nov 13 2009 17:04:13.988259 3086223056]: accept success 10(127.0.0.1:36129)
[Fri Nov 13 2009 17:04:13.988405 3086223056]: 2.open user 10 [92DFE18] (127.0.0.1)
[Fri Nov 13 2009 17:04:43.003453 3065240464]: Database Connect success!
[Fri Nov 13 2009 17:04:47.162028 3033770896]: Database Connect success!
[Fri Nov 13 2009 17:04:47.166698 3033770896]: [##ERROR##] OnIPCAuthAccount fail (usernum: 0)
[Fri Nov 13 2009 17:04:47.166756 3033770896]: [##ERROR##] DB ERROR(MSG)      : [FreeTDS][SQL Server]La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
[Fri Nov 13 2009 17:04:47.166781 3033770896]: [##ERROR##] DB ERROR(CODE)     : 242
[Fri Nov 13 2009 17:04:47.166803 3033770896]: [##ERROR##] DB ERROR(VAR_INFO) : 
[Fri Nov 13 2009 17:04:47.166824 3033770896]: [##ERROR##] DB ERROR(SQLSTATE) : 22007
[Fri Nov 13 2009 17:04:47.166846 3033770896]: [##ERROR##] DB ERROR(STM_TEXT) : {call cabal_sp_auth( ?               , ?               , ?          ,  ?               )}
[Fri Nov 13 2009 17:04:47.174784 3033770896]: Database Connect success!
[Fri Nov 13 2009 17:04:47.174833 3033770896]: [##ERROR##] 'OnIPCAuthAccount' fail (Database/Auth.cpp:283)
[Fri Nov 13 2009 17:04:47.174880 3033770896]: [##ERROR##] UsrMap Fail : MainCmd(30) Ret(11B:0:283) Addr(127.0.0.1)

GlobalMgrSvr:

[Fri Nov 13 2009 17:04:13.529787 3086071520]: open log file  '/var/log/cabal/GlobalMgrSvr.log'
[Fri Nov 13 2009 17:04:13.530047 3086071520]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.530125 3086071520]: MemPoolUnitSizeClass(0): 14336Bytes
[Fri Nov 13 2009 17:04:13.531030 3086071520]: Start GlobalMgrSvr Server
[Fri Nov 13 2009 17:04:13.531617 3086071520]: LoadServerAndChannelType(1)
[Fri Nov 13 2009 17:04:13.531691 3086071520]: channelType[1][1]: 0
[Fri Nov 13 2009 17:04:13.531728 3086071520]: maxUserName[1][1]: 100
[Fri Nov 13 2009 17:04:13.533340 3086071520]: channelType[2][1]: 1
[Fri Nov 13 2009 17:04:13.533402 3086071520]: maxUserName[2][1]: 100
[Fri Nov 13 2009 17:04:13.535035 3086071520]: channelType[3][1]: 8
[Fri Nov 13 2009 17:04:13.535105 3086071520]: maxUserName[3][1]: 100
[Fri Nov 13 2009 17:04:13.536715 3086071520]: channelType[4][10]: 16908368
[Fri Nov 13 2009 17:04:13.536779 3086071520]: maxUserName[4][10]: 100
[Fri Nov 13 2009 17:04:13.538238 3086071520]: channelType[5][1]: 0
[Fri Nov 13 2009 17:04:13.538292 3086071520]: maxUserName[5][1]: 100
[Fri Nov 13 2009 17:04:13.538426 3086071520]: channelType[5][10]: 16908368
[Fri Nov 13 2009 17:04:13.538462 3086071520]: maxUserName[5][10]: 100
[Fri Nov 13 2009 17:04:13.539618 3086071520]: channelType[6][1]: 0
[Fri Nov 13 2009 17:04:13.539656 3086071520]: maxUserName[6][1]: 100
[Fri Nov 13 2009 17:04:13.539702 3086071520]: channelType[6][4]: 8
[Fri Nov 13 2009 17:04:13.539729 3086071520]: maxUserName[6][4]: 100
[Fri Nov 13 2009 17:04:13.539797 3086071520]: channelType[6][10]: 16908368
[Fri Nov 13 2009 17:04:13.539824 3086071520]: maxUserName[6][10]: 100
[Fri Nov 13 2009 17:04:13.540735 3086071520]: channelType[7][1]: 1
[Fri Nov 13 2009 17:04:13.540763 3086071520]: maxUserName[7][1]: 100
[Fri Nov 13 2009 17:04:13.540809 3086071520]: channelType[7][4]: 8
[Fri Nov 13 2009 17:04:13.540837 3086071520]: maxUserName[7][4]: 100
[Fri Nov 13 2009 17:04:13.540904 3086071520]: channelType[7][10]: 16908368
[Fri Nov 13 2009 17:04:13.540935 3086071520]: maxUserName[7][10]: 100
[Fri Nov 13 2009 17:04:13.541837 3086071520]: channelType[8][1]: 1
[Fri Nov 13 2009 17:04:13.541865 3086071520]: maxUserName[8][1]: 100
[Fri Nov 13 2009 17:04:13.541911 3086071520]: channelType[8][4]: 4
[Fri Nov 13 2009 17:04:13.541943 3086071520]: maxUserName[8][4]: 100
[Fri Nov 13 2009 17:04:13.541974 3086071520]: channelType[8][5]: 12
[Fri Nov 13 2009 17:04:13.542002 3086071520]: maxUserName[8][5]: 100
[Fri Nov 13 2009 17:04:13.542063 3086071520]: channelType[8][10]: 16908368
[Fri Nov 13 2009 17:04:13.542090 3086071520]: maxUserName[8][10]: 100
[Fri Nov 13 2009 17:04:13.543004 3086071520]: channelType[9][1]: 1
[Fri Nov 13 2009 17:04:13.543032 3086071520]: maxUserName[9][1]: 100
[Fri Nov 13 2009 17:04:13.543062 3086071520]: channelType[9][2]: 4
[Fri Nov 13 2009 17:04:13.543089 3086071520]: maxUserName[9][2]: 100
[Fri Nov 13 2009 17:04:13.543128 3086071520]: channelType[9][4]: 8
[Fri Nov 13 2009 17:04:13.543155 3086071520]: maxUserName[9][4]: 100
[Fri Nov 13 2009 17:04:13.543221 3086071520]: channelType[9][10]: 16908368
[Fri Nov 13 2009 17:04:13.543248 3086071520]: maxUserName[9][10]: 100
[Fri Nov 13 2009 17:04:13.544255 3086071520]: channelType[10][1]: 0
[Fri Nov 13 2009 17:04:13.544300 3086071520]: maxUserName[10][1]: 100
[Fri Nov 13 2009 17:04:13.544344 3086071520]: channelType[10][2]: 4
[Fri Nov 13 2009 17:04:13.544381 3086071520]: maxUserName[10][2]: 100
[Fri Nov 13 2009 17:04:13.544438 3086071520]: channelType[10][4]: 5
[Fri Nov 13 2009 17:04:13.544480 3086071520]: maxUserName[10][4]: 100
[Fri Nov 13 2009 17:04:13.544528 3086071520]: channelType[10][5]: 12
[Fri Nov 13 2009 17:04:13.544567 3086071520]: maxUserName[10][5]: 100
[Fri Nov 13 2009 17:04:13.544654 3086071520]: channelType[10][10]: 16908368
[Fri Nov 13 2009 17:04:13.544723 3086071520]: maxUserName[10][10]: 100
[Fri Nov 13 2009 17:04:13.546806 3086071520]: channelType[11][1]: 0
[Fri Nov 13 2009 17:04:13.546884 3086071520]: maxUserName[11][1]: 100
[Fri Nov 13 2009 17:04:13.548459 3086071520]: channelType[12][1]: 8
[Fri Nov 13 2009 17:04:13.548518 3086071520]: maxUserName[12][1]: 100
[Fri Nov 13 2009 17:04:13.556736 3086071520]: channelType[18][1]: 0
[Fri Nov 13 2009 17:04:13.556820 3086071520]: maxUserName[18][1]: 100
[Fri Nov 13 2009 17:04:13.556867 3086071520]: channelType[18][2]: 1
[Fri Nov 13 2009 17:04:13.556908 3086071520]: maxUserName[18][2]: 100
[Fri Nov 13 2009 17:04:13.558434 3086071520]: channelType[19][1]: 0
[Fri Nov 13 2009 17:04:13.558500 3086071520]: maxUserName[19][1]: 100
[Fri Nov 13 2009 17:04:13.558546 3086071520]: channelType[19][2]: 1
[Fri Nov 13 2009 17:04:13.558584 3086071520]: maxUserName[19][2]: 100
[Fri Nov 13 2009 17:04:13.560113 3086071520]: channelType[20][1]: 0
[Fri Nov 13 2009 17:04:13.560175 3086071520]: maxUserName[20][1]: 100
[Fri Nov 13 2009 17:04:13.560222 3086071520]: channelType[20][2]: 1
[Fri Nov 13 2009 17:04:13.560260 3086071520]: maxUserName[20][2]: 100
[Fri Nov 13 2009 17:04:13.565791 3086071520]: channelType[24][1]: 1
[Fri Nov 13 2009 17:04:13.565862 3086071520]: maxUserName[24][1]: 100
[Fri Nov 13 2009 17:04:13.682574 3086071520]: try connect 127.0.0.1:38180, Sync
[Fri Nov 13 2009 17:04:13.683080 3086071520]: sock 7 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.683165 3086071520]: SendIPSConnect2Svr (246:128:00:00)
[Fri Nov 13 2009 17:04:13.683244 3086071520]: try listening 38170 port
[Fri Nov 13 2009 17:04:13.683619 3085601680]: CProcessLayer(0)::svc Start [3085601680]
[Fri Nov 13 2009 17:04:13.731400 3086071520]: accept success 10(127.0.0.1:54164)
[Fri Nov 13 2009 17:04:13.731524 3086071520]: 1.open user 10 [90E6A48] (127.0.0.1)
[Fri Nov 13 2009 17:04:13.731722 3085601680]: new chatnode session (24:01)
[Fri Nov 13 2009 17:04:13.732389 3085601680]: new chat server session (250:24:01)
[Fri Nov 13 2009 17:04:13.784503 3086071520]: accept success 11(127.0.0.1:54166)
[Fri Nov 13 2009 17:04:13.784643 3086071520]: 2.open user 11 [90ED1A8] (127.0.0.1)
[Fri Nov 13 2009 17:04:13.987433 3086071520]: accept success 12(127.0.0.1:54170)
[Fri Nov 13 2009 17:04:13.987539 3086071520]: 3.open user 12 [90F3428] (127.0.0.1)
[Fri Nov 13 2009 17:04:13.988719 3085601680]: new server session (128:01)
[Fri Nov 13 2009 17:04:17.701128 3085601680]: new server session (24:01)

LoginSvr_01:

[Fri Nov 13 2009 17:04:13.858689 3086567920]: open log file  '/var/log/cabal/LoginSvr_01.log'
[Fri Nov 13 2009 17:04:13.858830 3086567920]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.858881 3086567920]: MemPoolUnitSizeClass(0): 14336Bytes
[Fri Nov 13 2009 17:04:13.859756 3086567920]: Start LoginSvr_01 Server
[Fri Nov 13 2009 17:04:13.859814 3086567920]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Fri Nov 13 2009 17:04:13.859858 3086567920]: TestChannelGroupIdxStartPoint=50
[Fri Nov 13 2009 17:04:13.859922 3086567920]: affiliatedCorpIP=121.170.135.;
[Fri Nov 13 2009 17:04:13.859956 3086567920]: AdminIP=121.170.135.;
[Fri Nov 13 2009 17:04:13.859994 3086567920]: client_version=22
[Fri Nov 13 2009 17:04:13.860026 3086567920]: IgnoreClientVersion(1)
[Fri Nov 13 2009 17:04:13.860063 3086567920]: UseAntiOnlineGameAddictionSystem(1)
[Fri Nov 13 2009 17:04:13.860095 3086567920]: AdultAge(18)
[Fri Nov 13 2009 17:04:13.860127 3086567920]: DefaultAgeAdult(1)
[Fri Nov 13 2009 17:04:13.860160 3086567920]: UsePSS(0)
[Fri Nov 13 2009 17:04:13.860191 3086567920]: CachedPSS(0)
[Fri Nov 13 2009 17:04:13.860222 3086567920]: PssCacheDurationMin(1440)
[Fri Nov 13 2009 17:04:13.860255 3086567920]: CutIfPssUserNotFound(0)
[Fri Nov 13 2009 17:04:13.860286 3086567920]: PssLogLevel(0)
[Fri Nov 13 2009 17:04:13.860317 3086567920]: InstantPlayTimeClearIntervalMin(300)
[Fri Nov 13 2009 17:04:13.860354 3086567920]: IDC(1)
[Fri Nov 13 2009 17:04:13.860386 3086567920]: SharedPssPersonId(0)
[Fri Nov 13 2009 17:04:13.860417 3086567920]: NormalClientMagicKey(1168110)
[Fri Nov 13 2009 17:04:13.860450 3086567920]: UseImageAuth(0)
[Fri Nov 13 2009 17:04:13.860483 3086567920]: ImageAuthDataPath(./ImageAuth/)
[Fri Nov 13 2009 17:04:13.860514 3086567920]: ImageAuthMaxTryCount(5)
[Fri Nov 13 2009 17:04:13.860546 3086567920]: ImageAuthWaitTime(120000)
[Fri Nov 13 2009 17:04:13.860578 3086567920]: BlockIfImageAuthFail(0)
[Fri Nov 13 2009 17:04:13.860609 3086567920]: UseServerListManualOrder(0)
[Fri Nov 13 2009 17:04:13.860639 3086567920]: 00:00 => 0
[Fri Nov 13 2009 17:04:13.860667 3086567920]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Fri Nov 13 2009 17:04:13.860697 3086567920]: ImageAuthDataMgr Init Begin
[Fri Nov 13 2009 17:04:13.986400 3086567920]: ImageAuthDataMgr Init End(Count:1995)
[Fri Nov 13 2009 17:04:13.987203 3086567920]: try connect 127.0.0.1:38170, Sync
[Fri Nov 13 2009 17:04:13.987919 3086567920]: sock 7 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.987983 3086567920]: SendIPSConnect2Svr (195:128:01:00)
[Fri Nov 13 2009 17:04:13.988076 3086567920]: try connect 127.0.0.1:38180, Sync
[Fri Nov 13 2009 17:04:13.988221 3086567920]: sock 9 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.988298 3086567920]: SendIPSConnect2Svr (195:128:01:00)
[Fri Nov 13 2009 17:04:13.988396 3086567920]: try listening 38101 port
[Fri Nov 13 2009 17:04:13.989309 3078265744]: CProcessLayer(0)::svc Start [3078265744]
[Fri Nov 13 2009 17:04:13.989411 3078265744]: ServerState changed(0 -> 0)
[Fri Nov 13 2009 17:04:42.979699 3086567920]: accept success 11(77.230.147.80:57083)
[Fri Nov 13 2009 17:04:42.979855 3086567920]: 1.open user 11 [94E94C8] (77.230.147.80)
[Fri Nov 13 2009 17:04:42.991761 3078265744]: AuthRequest: UserID(test1), Addr(77.230.147.80)
[Fri Nov 13 2009 17:04:43.005666 3078265744]: AuthResult: UserID(test1), Addr(77.230.147.80), Result(33), UserNum(0)
[Fri Nov 13 2009 17:04:43.009592 3086567920]: 1.close user 11 [94E94C8] (77.230.147.80)
[Fri Nov 13 2009 17:04:47.131549 3086567920]: accept success 11(77.230.147.80:57084)
[Fri Nov 13 2009 17:04:47.131695 3086567920]: 1.open user 11 [94E94C8] (77.230.147.80)
[Fri Nov 13 2009 17:04:47.154186 3078265744]: AuthRequest: UserID(test1), Addr(77.230.147.80)
[Fri Nov 13 2009 17:05:29.462505 3086567920]: 1.close user 11 [94E94C8] (77.230.147.80)

WorldSvr_24_01:

[Fri Nov 13 2009 17:04:13.779757 11528688]: open log file  '/var/log/cabal/WorldSvr_24_01.log'
[Fri Nov 13 2009 17:04:13.779873 11528688]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.779928 11528688]: MemPoolUnitSizeClass(5): 16384Bytes
[Fri Nov 13 2009 17:04:13.780775 11528688]: Start WorldSvr_24_01 Server
[Fri Nov 13 2009 17:04:13.780882 11528688]: CheckSkillCoolTimeHack (Off)
[Fri Nov 13 2009 17:04:13.780919 11528688]: CheckShopHack (Off)
[Fri Nov 13 2009 17:04:13.780952 11528688]: CheckWarpHack (Off)
[Fri Nov 13 2009 17:04:13.780984 11528688]: CheckWareHouseHack (Off)
[Fri Nov 13 2009 17:04:13.781014 11528688]: UseCheckDistanceSkillHack (Off)
[Fri Nov 13 2009 17:04:13.781049 11528688]: MaxTimeHackingCount(2)
[Fri Nov 13 2009 17:04:13.781081 11528688]: MaxDistanceHackingCount(2)
[Fri Nov 13 2009 17:04:13.781115 11528688]: UseNonClientCheck (Off)
[Fri Nov 13 2009 17:04:13.781147 11528688]: NonClientDisAdvantageRate (90)
[Fri Nov 13 2009 17:04:13.781181 11528688]: useDropDiscount (On)
[Fri Nov 13 2009 17:04:13.781216 11528688]: UseBlessingBeadCheck (Off)
[Fri Nov 13 2009 17:04:13.781249 11528688]: AllowTradeChannel (Off)
[Fri Nov 13 2009 17:04:13.781281 11528688]: UseCheckMissionIdx(Off)
[Fri Nov 13 2009 17:04:13.781316 11528688]: UseCheckDeadStatActive(Off)
[Fri Nov 13 2009 17:04:13.781349 11528688]: reload ActiveDeadStatCount(30)
[Fri Nov 13 2009 17:04:13.781390 11528688]: UseHackcheckByTimeScope (Off)
[Fri Nov 13 2009 17:04:13.781425 11528688]: CheckSkillTimeHackScope(60000)
[Fri Nov 13 2009 17:04:13.781459 11528688]: UseMobsChaseModify (On)
[Fri Nov 13 2009 17:04:13.781492 11528688]: UseAlzDbHackCheck (Off)
[Fri Nov 13 2009 17:04:13.781524 11528688]: UseCutIfAlzDbHacked (Off)
[Fri Nov 13 2009 17:04:13.781556 11528688]: useCheckUserAttack (Off)
[Fri Nov 13 2009 17:04:13.781591 11528688]: UseHackUserDBSave (On)
[Fri Nov 13 2009 17:04:13.781621 11528688]: UseAdminUser (On)
[Fri Nov 13 2009 17:04:13.781674 11528688]: UseAntiOnlineGameAddictionSystem(1)
[Fri Nov 13 2009 17:04:13.781708 11528688]: InstantPlayTimeClearIntervalMin(300)
[Fri Nov 13 2009 17:04:13.781746 11528688]: InstantPlayTimeDbUpdateIntervalMin(5)
[Fri Nov 13 2009 17:04:13.781781 11528688]: InstantPlayTimeNotifyIntervalMin(1)
[Fri Nov 13 2009 17:04:13.781818 11528688]: AdvantageBoundaryTime(10800, 18000)
[Fri Nov 13 2009 17:04:13.781854 11528688]: InstantPlayTimeDebugMultiple(1)
[Fri Nov 13 2009 17:04:13.781896 11528688]: UseCheckBelongItem (Off)
[Fri Nov 13 2009 17:04:13.781931 11528688]: UseCheckDMZArea (Off)
[Fri Nov 13 2009 17:04:13.781965 11528688]: AllowCashShop(1)
[Fri Nov 13 2009 17:04:13.782000 11528688]: AllowNetcafePoint(0)
[Fri Nov 13 2009 17:04:13.782034 11528688]: RestrictOddCircleUseCountInDungeon (On)
[Fri Nov 13 2009 17:04:13.782073 11528688]: UseAdditionalMissionDungeonInstanceInPremiumCH (Off)
[Fri Nov 13 2009 17:04:13.782103 11528688]: UseAdditionalMissionDungeonInstanceInPremiumUser (Off)
[Fri Nov 13 2009 17:04:13.782133 11528688]: AdditionalMissionDungeonInstanceCount (0)
[Fri Nov 13 2009 17:04:13.782169 11528688]: UsePvpBetting (Off)
[Fri Nov 13 2009 17:04:13.782203 11528688]: PShopOpenLimitCount (0)
[Fri Nov 13 2009 17:04:13.782238 11528688]: UseTradeChannelRestriction (Off)
[Fri Nov 13 2009 17:04:13.782275 11528688]: UseArtOfDefensePenalty (On)
[Fri Nov 13 2009 17:04:13.782310 11528688]: IgnorePartyInviteDistance (Off)
[Fri Nov 13 2009 17:04:13.782343 11528688]: UseWorldDrop (On)
[Fri Nov 13 2009 17:04:13.782382 11528688]: UseInventoryHackCheck (Off)
[Fri Nov 13 2009 17:04:13.782417 11528688]: UseRandomValueWriteLog (Off)
[Fri Nov 13 2009 17:04:13.782452 11528688]: UseMinLevDiffValueForExpCalc (On)
[Fri Nov 13 2009 17:04:13.782488 11528688]: UsePartyMinExpForInvalidPartyMember (On)
[Fri Nov 13 2009 17:04:13.782523 11528688]: UseIgnoreOtherBlessBuff (Off)
[Fri Nov 13 2009 17:04:13.782554 11528688]: Extended Alz Mode
[Fri Nov 13 2009 17:04:13.782588 11528688]: GameGuard enabled version
[Fri Nov 13 2009 17:04:13.782623 11528688]: GameGuard turned off
[Fri Nov 13 2009 17:04:13.782653 11528688]: APEX enabled version
[Fri Nov 13 2009 17:04:13.782689 11528688]: APEX turned off
[Fri Nov 13 2009 17:04:13.782751 11528688]: XTrap disabled version
[Fri Nov 13 2009 17:04:13.782786 11528688]: WaitUntilChannelTypeSet(Off)
[Fri Nov 13 2009 17:04:13.782821 11528688]: UseBootUpGmsChannelType(On)
[Fri Nov 13 2009 17:04:13.783585 11528688]: Local ip = 77.230.147.81 (from ini)
[Fri Nov 13 2009 17:04:13.783661 11528688]: MaxAttackHackTime (300000)
[Fri Nov 13 2009 17:04:13.783696 11528688]: SpeedHackCheckTime (10000)
[Fri Nov 13 2009 17:04:13.784248 11528688]: try connect 127.0.0.1:38170, Sync
[Fri Nov 13 2009 17:04:13.784788 11528688]: sock 5 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.784859 11528688]: SendIPSConnect2Svr (161:24:01:00)
[Fri Nov 13 2009 17:04:13.784968 11528688]: try connect 127.0.0.1:53424, Sync
[Fri Nov 13 2009 17:04:13.785428 11528688]: sock 7 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.785469 11528688]: SendIPSConnect2Svr (161:24:01:00)
[Fri Nov 13 2009 17:04:13.785529 11528688]: try connect 127.0.0.1:38190, Sync
[Fri Nov 13 2009 17:04:13.786009 23255952]: CProcessLayer(0)::svc Start [23255952]
[Fri Nov 13 2009 17:04:13.786658 11528688]: sock 8 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.786720 11528688]: SendIPSConnect2Svr (161:24:01:00)
[Fri Nov 13 2009 17:04:13.786819 11528688]: try connect 127.0.0.1:38144, Sync
[Fri Nov 13 2009 17:04:13.787009 11528688]: sock 9 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.787061 11528688]: SendIPSConnect2Svr (161:24:01:00)
[Fri Nov 13 2009 17:04:13.816098 11528688]: GuildCreateFee: 10000000
[Fri Nov 13 2009 17:04:15.509486 66022288]: CProcessLayer(1)::svc Start [66022288]
[Fri Nov 13 2009 17:04:15.564515 35576720]: CProcessLayer(2)::svc Start [35576720]
[Fri Nov 13 2009 17:04:15.625432 54455184]: CProcessLayer(3)::svc Start [54455184]
[Fri Nov 13 2009 17:04:15.682413 132959120]: CProcessLayer(4)::svc Start [132959120]
[Fri Nov 13 2009 17:04:15.737397 3084909456]: CProcessLayer(5)::svc Start [3084909456]
[Fri Nov 13 2009 17:04:15.794382 3074419600]: CProcessLayer(6)::svc Start [3074419600]
[Fri Nov 13 2009 17:04:15.851370 3063929744]: CProcessLayer(7)::svc Start [3063929744]
[Fri Nov 13 2009 17:04:15.912356 3050675088]: CProcessLayer(8)::svc Start [3050675088]
[Fri Nov 13 2009 17:04:15.963346 3033893776]: CProcessLayer(9)::svc Start [3033893776]
[Fri Nov 13 2009 17:04:16.016332 3016186768]: CProcessLayer(10)::svc Start [3016186768]
[Fri Nov 13 2009 17:04:16.069320 2998696848]: CProcessLayer(13)::svc Start [2998696848]
[Fri Nov 13 2009 17:04:16.130307 2985442192]: CProcessLayer(14)::svc Start [2985442192]
[Fri Nov 13 2009 17:04:16.187292 2966657936]: CProcessLayer(19)::svc Start [2966657936]
[Fri Nov 13 2009 17:04:16.224280 2953403280]: CProcessLayer(23)::svc Start [2953403280]
[Fri Nov 13 2009 17:04:16.267267 2940148624]: CProcessLayer(24)::svc Start [2940148624]
[Fri Nov 13 2009 17:04:16.306255 2925210512]: CProcessLayer(25)::svc Start [2925210512]
[Fri Nov 13 2009 17:04:16.343249 2910858128]: CProcessLayer(26)::svc Start [2910858128]
[Fri Nov 13 2009 17:04:16.398233 2896505744]: CProcessLayer(27)::svc Start [2896505744]
[Fri Nov 13 2009 17:04:16.437223 2882153360]: CProcessLayer(28)::svc Start [2882153360]
[Fri Nov 13 2009 17:04:16.477261 2867325840]: CProcessLayer(29)::svc Start [2867325840]
[Fri Nov 13 2009 17:04:16.532710 2852330384]: CProcessLayer(30)::svc Start [2852330384]
[Fri Nov 13 2009 17:04:16.555195 11528688]: try listening 38111 port
[Fri Nov 13 2009 17:04:17.701553 23255952]: ChannelType changed(0 -> 1)

CashDBAgent:

[Fri Nov 13 2009 17:04:13.587536 3086718672]: open log file  '/var/log/cabal/CashDBAgent.log'
[Fri Nov 13 2009 17:04:13.587656 3086718672]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.587697 3086718672]: MemPoolUnitSizeClass(0): 14336Bytes
[Fri Nov 13 2009 17:04:13.588565 3086718672]: Start CashDBAgent Server
[Fri Nov 13 2009 17:04:13.589087 3086718672]: UseEcryptText (Off)
[Fri Nov 13 2009 17:04:13.591293 3086715792]: CProcessLayer(0)::svc Start [3086715792]
[Fri Nov 13 2009 17:04:13.591429 3076225936]: CProcessLayer(0)::svc Start [3076225936]
[Fri Nov 13 2009 17:04:13.591499 3065736080]: CProcessLayer(0)::svc Start [3065736080]
[Fri Nov 13 2009 17:04:13.591568 3055246224]: CProcessLayer(0)::svc Start [3055246224]
[Fri Nov 13 2009 17:04:13.591645 3044756368]: CProcessLayer(0)::svc Start [3044756368]
[Fri Nov 13 2009 17:04:13.599246 3086718672]: try listening 38190 port
[Fri Nov 13 2009 17:04:13.601134 3034266512]: CProcessLayer(0)::svc Start [3034266512]
[Fri Nov 13 2009 17:04:13.601227 3023776656]: CProcessLayer(0)::svc Start [3023776656]
[Fri Nov 13 2009 17:04:13.601298 3013286800]: CProcessLayer(0)::svc Start [3013286800]
[Fri Nov 13 2009 17:04:13.601366 3002796944]: CProcessLayer(0)::svc Start [3002796944]
[Fri Nov 13 2009 17:04:13.601439 2992307088]: CProcessLayer(0)::svc Start [2992307088]
[Fri Nov 13 2009 17:04:13.785739 3086718672]: accept success 8(127.0.0.1:44863)
[Fri Nov 13 2009 17:04:13.786331 3086718672]: 1.open user 8 [94AE6F8] (127.0.0.1)

ChatNode_24:

[Fri Nov 13 2009 17:04:13.725582 3086068208]: open log file  '/var/log/cabal/ChatNode_24.log'
[Fri Nov 13 2009 17:04:13.725734 3086068208]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.725783 3086068208]: MemPoolUnitSizeClass(2): 24576Bytes
[Fri Nov 13 2009 17:04:13.726393 3086068208]: Start ChatNode_24 Server
[Fri Nov 13 2009 17:04:13.726470 3086068208]: main(): ChatServerId(250:24:1)
[Fri Nov 13 2009 17:04:13.726534 3086068208]: ReloadConfig(): ReloadConfig
[Fri Nov 13 2009 17:04:13.726565 3086068208]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.726605 3086068208]: SetSayChannelMgrLogSay(): LogSay: 0
[Fri Nov 13 2009 17:04:13.726643 3086068208]: ReloadConfig(): BroadCastOverServerNation: 0
[Fri Nov 13 2009 17:04:13.726693 3086068208]: ReloadConfig(): UseGuildCreateFee: 1
[Fri Nov 13 2009 17:04:13.726731 3086068208]: ReloadConfig(): CharLevelForGuildCreate: 40
[Fri Nov 13 2009 17:04:13.726769 3086068208]: ReloadConfig(): AllowGuildBoard: 0
[Fri Nov 13 2009 17:04:13.729227 3085794192]: CProcessLayer(0)::svc Start [3085794192]
[Fri Nov 13 2009 17:04:13.729382 3075304336]: CProcessLayer(0)::svc Start [3075304336]
[Fri Nov 13 2009 17:04:13.729466 3064814480]: CProcessLayer(0)::svc Start [3064814480]
[Fri Nov 13 2009 17:04:13.729547 3054324624]: CProcessLayer(0)::svc Start [3054324624]
[Fri Nov 13 2009 17:04:13.729620 3043834768]: CProcessLayer(0)::svc Start [3043834768]
[Fri Nov 13 2009 17:04:13.729692 3033344912]: CProcessLayer(0)::svc Start [3033344912]
[Fri Nov 13 2009 17:04:13.729969 3086068208]: try connect 127.0.0.1:38170, Sync
[Fri Nov 13 2009 17:04:13.730402 3086068208]: sock 5 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.730452 3086068208]: SendIPSConnect2Svr (250:24:01:00)
[Fri Nov 13 2009 17:04:13.730523 3086068208]: try connect 127.0.0.1:53424, Sync
[Fri Nov 13 2009 17:04:13.730631 3086068208]: sock 7 ->LinkHandler Open
[Fri Nov 13 2009 17:04:13.730681 3086068208]: SendIPSConnect2Svr (250:24:01:00)
[Fri Nov 13 2009 17:04:13.730740 3086068208]: try listening 38144 port
[Fri Nov 13 2009 17:04:13.731098 3022855056]: CProcessLayer(0)::svc Start [3022855056]
[Fri Nov 13 2009 17:04:13.731198 3012365200]: CProcessLayer(0)::svc Start [3012365200]
[Fri Nov 13 2009 17:04:13.787080 3086068208]: accept success 9(127.0.0.1:49899)
[Fri Nov 13 2009 17:04:13.787234 3086068208]: 1.open user 9 [908DBA8] (127.0.0.1)
[Fri Nov 13 2009 17:04:17.699854 3054324624]: OnIPCConnect2Svr(): new WorldSvr linked(161, 24, 1)

DBAgent_24:

[Fri Nov 13 2009 17:04:13.651393 3086677712]: open log file  '/var/log/cabal/DBAgent_24.log'
[Fri Nov 13 2009 17:04:13.651521 3086677712]: LOG LEVEL: 3
[Fri Nov 13 2009 17:04:13.651561 3086677712]: MemPoolUnitSizeClass(2): 24576Bytes
[Fri Nov 13 2009 17:04:13.652412 3086677712]: Start DBAgent_24 Server
[Fri Nov 13 2009 17:04:13.652942 3086677712]: UseEcryptText (Off)
[Fri Nov 13 2009 17:04:13.654950 3086674832]: CProcessLayer(0)::svc Start [3086674832]
[Fri Nov 13 2009 17:04:13.655075 3076184976]: CProcessLayer(0)::svc Start [3076184976]
[Fri Nov 13 2009 17:04:13.655144 3065695120]: CProcessLayer(0)::svc Start [3065695120]
[Fri Nov 13 2009 17:04:13.655212 3055205264]: CProcessLayer(0)::svc Start [3055205264]
[Fri Nov 13 2009 17:04:13.655340 3086677712]: try listening 53424 port
[Fri Nov 13 2009 17:04:13.655532 3044715408]: CProcessLayer(0)::svc Start [3044715408]
[Fri Nov 13 2009 17:04:13.730777 3086677712]: accept success 8(127.0.0.1:43200)
[Fri Nov 13 2009 17:04:13.731406 3086677712]: 1.open user 8 [849BF00] (127.0.0.1)
[Fri Nov 13 2009 17:04:13.785141 3086677712]: accept success 10(127.0.0.1:43202)
[Fri Nov 13 2009 17:04:13.785276 3086677712]: 2.open user 10 [84AA618] (127.0.0.1)
[Fri Nov 13 2009 17:04:17.710798 3065695120]: Database Connect success!
[Fri Nov 13 2009 17:04:17.718603 3055205264]: Database Connect success!
[Fri Nov 13 2009 17:04:17.735345 3076184976]: Database Connect success!
[Fri Nov 13 2009 17:06:13.863053 3044715408]: Database Connect success!

[MentaL]

[chumpywumpy]

This is something to do with invalid data that the server is trying to convert to a date byt the look of the error. Check your cabal_auth_table and cabal_character_table to see if there are any strange values in there.

This error has come up before but nobody has ever given me enough info to work out what causes it :/

[lorfirewall]

This is something to do with invalid data that the server is trying to convert to a date byt the look of the error. Check your cabal_auth_table and cabal_character_table to see if there are any strange values in there.

This error has come up before but nobody has ever given me enough info to work out what causes it :/

The DB are the two well, have format “00/00/00 00:00:00” in all the tables.
Not zero that the error is of the data bases “GAMEDB” and “ACCOUNT” I have recovered because them by the DB of installation, and leave the same error to me.

I have reinstated the exact servant of and the data bases but it continues leaving the same error. Of the program of the client it cannot be, we have tried because it with several and all do the same, do not connect.

Some advice?

[chumpywumpy]

The only thing you can really do is run a profiler on the database to see what data is being given to cabal_sp_auth. MSSQL express doesn't have one but if you use express you can download a non-microsoft one below:

http://code.google.com/p/sqlexpressp...downloads/list

Start a new trace and set it to look at "SPStarting" and "SPCompleted". Now try logging in and when it fails look at the profiler. Find the line that caputures the data going into cabal_sp_auth (check the TextData column) to see if it is valid data.

If you can't work it out from that then copy the query the profiler captured, paste it into an SQL query window and run it on the account db. This should give you a failure code which will tell me which bit failed.

[lorfirewall]

I have done what there are saying to me, and leaves the same error to me that in log of the servant "datetime".
I leave the captures you in attached archives.
I have not commented it, but for the MSQL use Vista x86.
I say it because I have found post in this forum that has had the same problem, and it says that it is of the MD5, but does not say it fixed as it.

[chumpywumpy]

I think i might know where it is going wrong. Paste the queries below into a new query window and run on account db. Post a screenshot of the results and it will tell me if i am correct.

select getdate()
select CONVERT(VARCHAR(11), GETDATE(), 20) + '21:00:00'
select CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'

[lorfirewall]

I think i might know where it is going wrong. Paste the queries below into a new query window and run on account db. Post a screenshot of the results and it will tell me if i am correct.

select getdate()
select CONVERT(VARCHAR(11), GETDATE(), 20) + '21:00:00'
select CONVERT(VARCHAR(11), GETDATE(), 20) + '00:00:00'

It watches the first consultation "getdate()" has given back east value:

2009-11-14 20:16:27.607

You have here them:

[chumpywumpy]

Very strange. That bit worked fine. Ok, try this one on the account db:

DECLARE @StartFreeTime as DATETIME, @EndFreeTime as DATETIME,@rExpireDate 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
  select 'Less than all'
END
select @StartFreeTime,@EndFreeTime,@rExpireDate
select account.dbo.fn_md5('test')

Also, can you post your cabal_sp_auth? The lines it is erroring on rae nothing to do with dates in mine and i'm wondering if yours is different somehow.

[lorfirewall]

It seems that no, it leaves this to me.

[chumpywumpy]

There is something weird going on here which i think is language settings related. The formats are ok and the only thing i can think of is that when trying to calculate the date it is thinking the day (14) is the month.

For now edit cabal_sp_auth and find this section:

-- 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

Change to (or delete):

-- 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 */

This section is only for "free time" type premium which we don't use so there should not be any problems with removing it.

[lorfirewall]

It pardons my ignorance but. “cabal_sp_auth” is a table of the data base? because not it encounter

[chumpywumpy]

Open the account database in the tree view on the left of MSSQL. Look in the "Programmability" folder (not sure what it will be called in your language) for "stored procedures" and you will find it in there. Right-click it and choose Edit, then make the change above and press F5 or "execute" to save it.

[lorfirewall]

Open the account database in the tree view on the left of MSSQL. Look in the "Programmability" folder (not sure what it will be called in your language) for "stored procedures" and you will find it in there. Right-click it and choose Edit, then make the change above and press F5 or "execute" to save it.

God mine, you are the master!
Not that Aryan without your aid.

Thanks uncle!