I go yesterday to a party.. i come back to my home and i try enter game and i can't.. it say me these
http://img199.imageshack.us/img199/2...2131512000.jpg
i try 1000000 times and i cant enter it say me the same all time.. i reinstall CentOS, restore DB's... and i still can enter.. it say me the same error...
PLEASE HELP!!!!
have you tried using different accounts?
i will reinstall SQL now w8 me i say u if works :D
hehehe yes i see emm have u serverfiles? i have Mahi serverfiles, he files that he use in the Video have u anothers?
remove login trigger...
so simple? lol... have u good files emi?Originally Posted by emi5893
I need Update Files i have the old files from Mahi...
I don't understand your request
hahahaha i need serverfiles that works 100%
have u?
and.. i have these problem :S i install 5 times SQL and gives me all time the same error :S! please help me emi,,
here is the error:
http://img199.imageshack.us/img199/4093/sqlerror.jpg
Please help!!!!!
lol mmc error.
Volao are you running vista by any chance. Also Volao if ur using Mahi's old files, I highly suggest you do a total upgrade and move from SQL 2000 to 2005, and use Centos 4.7 with Server Repack 2.8. There's even a video on how to do that check in Tuts.
I Fix the problem :D! hehehe!
i only need new ServerFiles can someone give me 1 link? :D
Last edited by volao47; 14-12-09 at 12:52 AM.
use server repack 2.8.....
look in releases...
Ok.. i reinstall CentOS.. and SQL but these problem still going..
http://img199.imageshack.us/img199/2...2131512000.jpg
HELPP!!
The fixlogin trigger won't be the cause here as if that was present it would be doing the exact opposite.
In the db there is a Login value on both cabal_auth_table (account db) and cabal_character_table (gamedb). When you log in it sets the Login value to 1.
When you try logging on it can see that the value is already 1 and think you are trying to log in twice (which isn't allowed). Clicking Yes should set the value back to 1, kick the other connection out (if there is one) and then log you in. As that is not happening check the log files for errors.
The fixlogin trigger was a hack we used when we had the login buch which forced the Login value to always be 0 as "this account is already online" made it much harder to connect. If the trigger was there you would never even se that question.
Look in my sig for my GM tools. It has a "set all players offline" which is designed to fix problems like this. Make sure nobody is online when you use it though.
chumpy here are the logs.. please help me!
[Sat Feb 14 2015 13:34:38.382867 3086190288]: open log file '/var/log/cabal/LoginSvr_01.log'
[Sat Feb 14 2015 13:34:38.383080 3086190288]: LOG LEVEL: 3
[Sat Feb 14 2015 13:34:38.383154 3086190288]: MemPoolUnitSizeClass(0): 14336Bytes
[Sat Feb 14 2015 13:34:38.384634 3086190288]: Start LoginSvr_01 Server
[Sat Feb 14 2015 13:34:38.384771 3086190288]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Sat Feb 14 2015 13:34:38.384850 3086190288]: TestChannelGroupIdxStartPoint=50
[Sat Feb 14 2015 13:34:38.384956 3086190288]: affiliatedCorpIP=121.170.135.;
[Sat Feb 14 2015 13:34:38.384995 3086190288]: AdminIP=121.170.135.;
[Sat Feb 14 2015 13:34:38.385055 3086190288]: client_version=22
[Sat Feb 14 2015 13:34:38.385097 3086190288]: IgnoreClientVersion(1)
[Sat Feb 14 2015 13:34:38.385157 3086190288]: UseAntiOnlineGameAddictionSystem(1)
[Sat Feb 14 2015 13:34:38.385194 3086190288]: AdultAge(18)
[Sat Feb 14 2015 13:34:38.385231 3086190288]: DefaultAgeAdult(1)
[Sat Feb 14 2015 13:34:38.385368 3086190288]: UsePSS(0)
[Sat Feb 14 2015 13:34:38.385406 3086190288]: CachedPSS(0)
[Sat Feb 14 2015 13:34:38.385442 3086190288]: PssCacheDurationMin(1440)
[Sat Feb 14 2015 13:34:38.385479 3086190288]: CutIfPssUserNotFound(0)
[Sat Feb 14 2015 13:34:38.385516 3086190288]: PssLogLevel(0)
[Sat Feb 14 2015 13:34:38.385552 3086190288]: InstantPlayTimeClearIntervalMin(300)
[Sat Feb 14 2015 13:34:38.385589 3086190288]: IDC(1)
[Sat Feb 14 2015 13:34:38.385625 3086190288]: SharedPssPersonId(0)
[Sat Feb 14 2015 13:34:38.385662 3086190288]: NormalClientMagicKey(1168110)
[Sat Feb 14 2015 13:34:38.385698 3086190288]: UseImageAuth(0)
[Sat Feb 14 2015 13:34:38.385735 3086190288]: ImageAuthDataPath(./ImageAuth/)
[Sat Feb 14 2015 13:34:38.385771 3086190288]: ImageAuthMaxTryCount(5)
[Sat Feb 14 2015 13:34:38.385807 3086190288]: ImageAuthWaitTime(120000)
[Sat Feb 14 2015 13:34:38.385844 3086190288]: BlockIfImageAuthFail(0)
[Sat Feb 14 2015 13:34:38.385880 3086190288]: UseServerListManualOrder(0)
[Sat Feb 14 2015 13:34:38.385914 3086190288]: 00:00 => 0
[Sat Feb 14 2015 13:34:38.385949 3086190288]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Sat Feb 14 2015 13:34:38.385984 3086190288]: ImageAuthDataMgr Init Begin
[Sat Feb 14 2015 13:34:46.540483 3086190288]: ImageAuthDataMgr Init End(Count:1995)
[Sat Feb 14 2015 13:34:46.544462 3086190288]: try connect 127.0.0.1:38170, Sync
[Sat Feb 14 2015 13:34:46.558779 3086190288]: sock 7 ->LinkHandler Open
[Sat Feb 14 2015 13:34:46.559004 3086190288]: SendIPSConnect2Svr (195:128:01:00)
[Sat Feb 14 2015 13:34:46.559114 3086190288]: try connect 127.0.0.1:38180, Sync
[Sat Feb 14 2015 13:34:46.559368 3086190288]: sock 9 ->LinkHandler Open
[Sat Feb 14 2015 13:34:46.559476 3086190288]: SendIPSConnect2Svr (195:128:01:00)
[Sat Feb 14 2015 13:34:46.559591 3086190288]: try listening 38101 port
[Sat Feb 14 2015 13:34:46.565625 3077888912]: CProcessLayer(0)::svc Start [3077888912]
[Sat Feb 14 2015 13:34:46.567075 3077888912]: ServerState changed(0 -> 0)
[Sat Feb 14 2015 13:35:03.396109 3086190288]: accept success 11(190.121.100.17:3959)
[Sat Feb 14 2015 13:35:03.396368 3086190288]: 1.open user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:35:03.486561 3077888912]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:35:03.641843 3077888912]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sat Feb 14 2015 13:35:14.386256 3077888912]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:37:06.545143 3077888912]: NOACTV_LIMIT(120000) Addr(190.121.100.17)
[Sat Feb 14 2015 13:37:06.560629 3077888912]: 1.close user -1 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:49:26.557770 3086190288]: accept success 11(190.121.100.17:4023)
[Sat Feb 14 2015 13:49:26.559524 3086190288]: 1.open user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:49:26.598756 3077888912]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:50:43.704561 3086190288]: 1.close user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:50:44.689150 3086190288]: accept success 11(190.121.100.17:4024)
[Sat Feb 14 2015 13:50:44.689324 3086190288]: 1.open user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:50:44.733849 3077888912]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:51:33.556935 3086190288]: 1.close user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:51:34.080293 3086190288]: accept success 11(190.121.100.17:4025)
[Sat Feb 14 2015 13:51:34.080457 3086190288]: 1.open user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:51:34.127148 3077888912]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:51:38.784683 3086190288]: 1.close user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:52:50.654233 3086190288]: accept success 11(190.121.100.17:4132)
[Sat Feb 14 2015 13:52:50.658049 3086190288]: 1.open user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:52:50.697955 3077888912]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:53:31.620828 3086190288]: 1.close user 11 [99C1478] (190.121.100.17)
[Sat Feb 14 2015 13:53:53.012198 3086190288]: sock 9 ->LinkHandler close
[Sat Feb 14 2015 13:53:53.563196 3086190288]: sock 7 ->LinkHandler close
[Sat Feb 14 2015 13:53:58.014956 3086190288]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38180)
[Sat Feb 14 2015 13:53:58.015087 3086190288]: try connect 127.0.0.1:38180, Sync
[Sat Feb 14 2015 13:53:58.020982 3086190288]: sock -1 ->LinkHandler close
[Sat Feb 14 2015 13:53:58.021055 3086190288]: [##ERROR##] connect 127.0.0.1:38180 fail
[Sat Feb 14 2015 13:53:58.563277 3086190288]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Sat Feb 14 2015 13:53:58.563351 3086190288]: try connect 127.0.0.1:38170, Sync
[Sat Feb 14 2015 13:53:58.563580 3086190288]: sock -1 ->LinkHandler close
[Sat Feb 14 2015 13:53:58.563650 3086190288]: [##ERROR##] connect 127.0.0.1:38170 fail
[Sat Feb 14 2015 13:53:59.976470 3086190288]: SIGTERM
3086190288: work_pending_i: Interrupted system call
[Sat Feb 14 2015 13:54:00.567178 3077888912]: CProcessLayer(0)::svc Terminated [3077888912]
[Sat Feb 14 2015 13:54:04.934007 3085940432]: open log file '/var/log/cabal/LoginSvr_01.log'
[Sat Feb 14 2015 13:54:04.934288 3085940432]: LOG LEVEL: 3
[Sat Feb 14 2015 13:54:04.934353 3085940432]: MemPoolUnitSizeClass(0): 14336Bytes
[Sat Feb 14 2015 13:54:04.935931 3085940432]: Start LoginSvr_01 Server
[Sat Feb 14 2015 13:54:04.936078 3085940432]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Sat Feb 14 2015 13:54:04.936157 3085940432]: TestChannelGroupIdxStartPoint=50
[Sat Feb 14 2015 13:54:04.936270 3085940432]: affiliatedCorpIP=121.170.135.;
[Sat Feb 14 2015 13:54:04.936402 3085940432]: AdminIP=121.170.135.;
[Sat Feb 14 2015 13:54:04.936466 3085940432]: client_version=22
[Sat Feb 14 2015 13:54:04.936504 3085940432]: IgnoreClientVersion(1)
[Sat Feb 14 2015 13:54:04.936563 3085940432]: UseAntiOnlineGameAddictionSystem(1)
[Sat Feb 14 2015 13:54:04.936601 3085940432]: AdultAge(18)
[Sat Feb 14 2015 13:54:04.936638 3085940432]: DefaultAgeAdult(1)
[Sat Feb 14 2015 13:54:04.936674 3085940432]: UsePSS(0)
[Sat Feb 14 2015 13:54:04.936710 3085940432]: CachedPSS(0)
[Sat Feb 14 2015 13:54:04.936747 3085940432]: PssCacheDurationMin(1440)
[Sat Feb 14 2015 13:54:04.936783 3085940432]: CutIfPssUserNotFound(0)
[Sat Feb 14 2015 13:54:04.936820 3085940432]: PssLogLevel(0)
[Sat Feb 14 2015 13:54:04.936856 3085940432]: InstantPlayTimeClearIntervalMin(300)
[Sat Feb 14 2015 13:54:04.936893 3085940432]: IDC(1)
[Sat Feb 14 2015 13:54:04.936930 3085940432]: SharedPssPersonId(0)
[Sat Feb 14 2015 13:54:04.936966 3085940432]: NormalClientMagicKey(1168110)
[Sat Feb 14 2015 13:54:04.937003 3085940432]: UseImageAuth(0)
[Sat Feb 14 2015 13:54:04.937040 3085940432]: ImageAuthDataPath(./ImageAuth/)
[Sat Feb 14 2015 13:54:04.937076 3085940432]: ImageAuthMaxTryCount(5)
[Sat Feb 14 2015 13:54:04.937113 3085940432]: ImageAuthWaitTime(120000)
[Sat Feb 14 2015 13:54:04.937149 3085940432]: BlockIfImageAuthFail(0)
[Sat Feb 14 2015 13:54:04.937604 3085940432]: UseServerListManualOrder(0)
[Sat Feb 14 2015 13:54:04.937641 3085940432]: 00:00 => 0
[Sat Feb 14 2015 13:54:04.937700 3085940432]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Sat Feb 14 2015 13:54:04.937737 3085940432]: ImageAuthDataMgr Init Begin
[Sat Feb 14 2015 13:54:11.326877 3085940432]: ImageAuthDataMgr Init End(Count:1995)
[Sat Feb 14 2015 13:54:11.335016 3085940432]: try connect 127.0.0.1:38170, Sync
[Sat Feb 14 2015 13:54:11.351714 3085940432]: sock 7 ->LinkHandler Open
[Sat Feb 14 2015 13:54:11.351925 3085940432]: SendIPSConnect2Svr (195:128:01:00)
[Sat Feb 14 2015 13:54:11.352107 3085940432]: try connect 127.0.0.1:38180, Sync
[Sat Feb 14 2015 13:54:11.353438 3085940432]: sock 9 ->LinkHandler Open
[Sat Feb 14 2015 13:54:11.353617 3085940432]: SendIPSConnect2Svr (195:128:01:00)
[Sat Feb 14 2015 13:54:11.353740 3085940432]: try listening 38101 port
[Sat Feb 14 2015 13:54:11.360823 3077639056]: CProcessLayer(0)::svc Start [3077639056]
[Sat Feb 14 2015 13:54:11.361022 3077639056]: ServerState changed(0 -> 0)
[Sat Feb 14 2015 13:54:23.725897 3085940432]: accept success 11(190.121.100.17:4134)
[Sat Feb 14 2015 13:54:23.726294 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 13:54:23.788742 3077639056]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:54:23.829711 3077639056]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sat Feb 14 2015 13:54:34.789030 3077639056]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 13:54:41.320666 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:31:44.207408 3085940432]: accept success 11(190.121.100.17:4529)
[Sat Feb 14 2015 16:31:44.208144 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:31:44.208590 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:36:55.546400 3085940432]: accept success 11(190.121.100.17:4563)
[Sat Feb 14 2015 16:36:55.550170 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:36:55.592250 3077639056]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 16:36:55.621531 3077639056]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sat Feb 14 2015 16:37:06.389427 3077639056]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 16:39:01.334138 3077639056]: NOACTV_LIMIT(120000) Addr(190.121.100.17)
[Sat Feb 14 2015 16:39:01.338867 3077639056]: 1.close user -1 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:41:34.194261 3085940432]: accept success 11(190.121.100.17:4844)
[Sat Feb 14 2015 16:41:34.195982 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:41:34.236512 3077639056]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 16:41:34.258238 3077639056]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sat Feb 14 2015 16:41:45.214067 3077639056]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sat Feb 14 2015 16:41:54.058191 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:46:02.287797 3085940432]: accept success 11(190.121.100.17:1121)
[Sat Feb 14 2015 16:46:02.288131 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 16:46:02.289288 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:39:32.902463 3085940432]: accept success 11(190.121.100.17:1440)
[Sat Feb 14 2015 20:39:32.902962 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:39:32.904072 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:53:04.789388 3085940432]: accept success 11(190.121.100.17:1456)
[Sat Feb 14 2015 20:53:04.789791 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:53:04.800848 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:56:24.613087 3085940432]: accept success 11(190.121.100.17:1462)
[Sat Feb 14 2015 20:56:24.613385 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:56:24.622985 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:56:33.213339 3085940432]: accept success 11(190.121.100.17:1467)
[Sat Feb 14 2015 20:56:33.215283 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 20:56:33.224887 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 22:35:15.368435 3085940432]: accept success 11(190.121.100.17:1518)
[Sat Feb 14 2015 22:35:15.368972 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sat Feb 14 2015 22:35:15.399223 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 00:48:59.511529 3085940432]: accept success 11(190.121.100.17:1627)
[Sun Feb 15 2015 00:48:59.513205 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 00:48:59.513640 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 00:52:33.125993 3085940432]: accept success 11(190.121.100.17:1636)
[Sun Feb 15 2015 00:52:33.126281 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 00:52:33.127231 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 00:55:54.414443 3085940432]: accept success 11(190.121.86.140:33863)
[Sun Feb 15 2015 00:55:54.421926 3085940432]: 1.open user 11 [8F71478] (190.121.86.140)
[Sun Feb 15 2015 00:55:54.507913 3077639056]: AuthRequest: UserID(joaco53), Addr(190.121.86.140)
[Sun Feb 15 2015 00:55:57.991078 3085940432]: 1.close user 11 [8F71478] (190.121.86.140)
[Sun Feb 15 2015 01:46:38.819244 3085940432]: accept success 11(190.121.100.17:1682)
[Sun Feb 15 2015 01:46:38.819792 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 01:46:38.820839 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 01:46:46.315119 3085940432]: accept success 11(190.121.100.17:1687)
[Sun Feb 15 2015 01:46:46.315335 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 01:46:46.325940 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 02:39:26.543872 3085940432]: accept success 11(190.121.92.14:1239)
[Sun Feb 15 2015 02:39:26.546037 3085940432]: 1.open user 11 [8F71478] (190.121.92.14)
[Sun Feb 15 2015 02:39:26.587114 3077639056]: AuthRequest: UserID(nachox), Addr(190.121.92.14)
[Sun Feb 15 2015 02:39:35.053731 3085940432]: 1.close user 11 [8F71478] (190.121.92.14)
[Sun Feb 15 2015 02:39:55.742652 3085940432]: accept success 11(190.121.92.14:1251)
[Sun Feb 15 2015 02:39:55.742827 3085940432]: 1.open user 11 [8F71478] (190.121.92.14)
[Sun Feb 15 2015 02:39:55.783008 3077639056]: AuthRequest: UserID(nachox), Addr(190.121.92.14)
[Sun Feb 15 2015 02:39:55.842255 3077639056]: AuthResult: UserID(nachox), Addr(190.121.92.14), Result(34), UserNum(10)
[Sun Feb 15 2015 02:40:07.374148 3077639056]: AuthRequest: UserID(nachox), Addr(190.121.92.14)
[Sun Feb 15 2015 02:40:23.682534 3085940432]: accept success 12(190.121.100.17:1739)
[Sun Feb 15 2015 02:40:23.683065 3085940432]: 2.open user 12 [8F78058] (190.121.100.17)
[Sun Feb 15 2015 02:40:23.685067 3085940432]: 2.close user 12 [8F78058] (190.121.100.17)
[Sun Feb 15 2015 02:40:55.952163 3085940432]: accept success 12(190.121.100.17:1752)
[Sun Feb 15 2015 02:40:55.956864 3085940432]: 2.open user 12 [8F78058] (190.121.100.17)
[Sun Feb 15 2015 02:40:55.962028 3085940432]: 2.close user 12 [8F78058] (190.121.100.17)
[Sun Feb 15 2015 02:41:08.344411 3077639056]: AuthRequest: UserID(nachox), Addr(190.121.92.14)
[Sun Feb 15 2015 02:41:08.364584 3077639056]: AuthResult: UserID(nachox), Addr(190.121.92.14), Result(34), UserNum(10)
[Sun Feb 15 2015 02:41:12.073814 3085940432]: accept success 12(190.121.100.17:1765)
[Sun Feb 15 2015 02:41:12.073982 3085940432]: 2.open user 12 [8F78058] (190.121.100.17)
[Sun Feb 15 2015 02:41:12.075765 3085940432]: 2.close user 12 [8F78058] (190.121.100.17)
[Sun Feb 15 2015 02:41:19.525589 3077639056]: AuthRequest: UserID(nachox), Addr(190.121.92.14)
[Sun Feb 15 2015 02:42:01.334972 3077639056]: NOACTV_LIMIT(120000) Addr(190.121.92.14)
[Sun Feb 15 2015 02:42:01.336029 3077639056]: 1.close user -1 [8F71478] (190.121.92.14)
[Sun Feb 15 2015 02:42:05.055279 3085940432]: accept success 11(190.121.92.14:1346)
[Sun Feb 15 2015 02:42:05.057522 3085940432]: 1.open user 11 [8F71478] (190.121.92.14)
[Sun Feb 15 2015 02:42:05.109239 3077639056]: AuthRequest: UserID(nachox), Addr(190.121.92.14)
[Sun Feb 15 2015 02:42:05.116784 3077639056]: AuthResult: UserID(nachox), Addr(190.121.92.14), Result(34), UserNum(10)
[Sun Feb 15 2015 02:42:16.118978 3085940432]: 1.close user 11 [8F71478] (190.121.92.14)
[Sun Feb 15 2015 03:52:16.602956 3085940432]: accept success 11(190.121.100.17:1809)
[Sun Feb 15 2015 03:52:16.608577 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 03:52:16.611563 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 03:53:12.541139 3085940432]: accept success 11(190.121.100.17:1816)
[Sun Feb 15 2015 03:53:12.541313 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 03:53:12.551819 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 05:04:44.701899 3085940432]: accept success 11(190.121.100.17:1911)
[Sun Feb 15 2015 05:04:44.705194 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 05:04:44.706345 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 05:13:04.564631 3085940432]: accept success 11(190.121.100.17:1962)
[Sun Feb 15 2015 05:13:04.566963 3085940432]: 1.open user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 05:13:04.616382 3077639056]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sun Feb 15 2015 05:13:04.621073 3077639056]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sun Feb 15 2015 05:13:05.672508 3085940432]: 1.close user 11 [8F71478] (190.121.100.17)
[Sun Feb 15 2015 05:13:35.435442 3085940432]: sock 9 ->LinkHandler close
[Sun Feb 15 2015 05:13:37.350714 3085940432]: sock 7 ->LinkHandler close
[Sun Feb 15 2015 05:13:40.445039 3085940432]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38180)
[Sun Feb 15 2015 05:13:40.445142 3085940432]: try connect 127.0.0.1:38180, Sync
[Sun Feb 15 2015 05:13:40.450359 3085940432]: sock -1 ->LinkHandler close
[Sun Feb 15 2015 05:13:40.450433 3085940432]: [##ERROR##] connect 127.0.0.1:38180 fail
[Sun Feb 15 2015 05:13:42.352077 3085940432]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Sun Feb 15 2015 05:13:42.352175 3085940432]: try connect 127.0.0.1:38170, Sync
[Sun Feb 15 2015 05:13:42.352451 3085940432]: sock -1 ->LinkHandler close
[Sun Feb 15 2015 05:13:42.352522 3085940432]: [##ERROR##] connect 127.0.0.1:38170 fail
[Sun Feb 15 2015 05:13:43.691698 3085940432]: SIGTERM
3085940432: work_pending_i: Interrupted system call
[Sun Feb 15 2015 05:13:44.343757 3077639056]: CProcessLayer(0)::svc Terminated [3077639056]
[Sun Feb 15 2015 05:14:06.397251 3086517968]: open log file '/var/log/cabal/LoginSvr_01.log'
[Sun Feb 15 2015 05:14:06.397438 3086517968]: LOG LEVEL: 3
[Sun Feb 15 2015 05:14:06.397505 3086517968]: MemPoolUnitSizeClass(0): 14336Bytes
[Sun Feb 15 2015 05:14:06.399157 3086517968]: Start LoginSvr_01 Server
[Sun Feb 15 2015 05:14:06.399267 3086517968]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Sun Feb 15 2015 05:14:06.399347 3086517968]: TestChannelGroupIdxStartPoint=50
[Sun Feb 15 2015 05:14:06.399455 3086517968]: affiliatedCorpIP=121.170.135.;
[Sun Feb 15 2015 05:14:06.399496 3086517968]: AdminIP=121.170.135.;
[Sun Feb 15 2015 05:14:06.399581 3086517968]: client_version=22
[Sun Feb 15 2015 05:14:06.399621 3086517968]: IgnoreClientVersion(1)
[Sun Feb 15 2015 05:14:06.399682 3086517968]: UseAntiOnlineGameAddictionSystem(1)
[Sun Feb 15 2015 05:14:06.399721 3086517968]: AdultAge(18)
[Sun Feb 15 2015 05:14:06.399760 3086517968]: DefaultAgeAdult(1)
[Sun Feb 15 2015 05:14:06.399798 3086517968]: UsePSS(0)
[Sun Feb 15 2015 05:14:06.399836 3086517968]: CachedPSS(0)
[Sun Feb 15 2015 05:14:06.399874 3086517968]: PssCacheDurationMin(1440)
[Sun Feb 15 2015 05:14:06.399912 3086517968]: CutIfPssUserNotFound(0)
[Sun Feb 15 2015 05:14:06.399950 3086517968]: PssLogLevel(0)
[Sun Feb 15 2015 05:14:06.399988 3086517968]: InstantPlayTimeClearIntervalMin(300)
[Sun Feb 15 2015 05:14:06.400163 3086517968]: IDC(1)
[Sun Feb 15 2015 05:14:06.400204 3086517968]: SharedPssPersonId(0)
[Sun Feb 15 2015 05:14:06.400243 3086517968]: NormalClientMagicKey(1168110)
[Sun Feb 15 2015 05:14:06.400303 3086517968]: UseImageAuth(0)
[Sun Feb 15 2015 05:14:06.400342 3086517968]: ImageAuthDataPath(./ImageAuth/)
[Sun Feb 15 2015 05:14:06.400380 3086517968]: ImageAuthMaxTryCount(5)
[Sun Feb 15 2015 05:14:06.400418 3086517968]: ImageAuthWaitTime(120000)
[Sun Feb 15 2015 05:14:06.400456 3086517968]: BlockIfImageAuthFail(0)
[Sun Feb 15 2015 05:14:06.400494 3086517968]: UseServerListManualOrder(0)
[Sun Feb 15 2015 05:14:06.400550 3086517968]: 00:00 => 0
[Sun Feb 15 2015 05:14:06.400588 3086517968]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Sun Feb 15 2015 05:14:06.400625 3086517968]: ImageAuthDataMgr Init Begin
[Sun Feb 15 2015 05:14:13.002251 3086517968]: ImageAuthDataMgr Init End(Count:1995)
[Sun Feb 15 2015 05:14:13.008114 3086517968]: try connect 127.0.0.1:38170, Sync
[Sun Feb 15 2015 05:14:13.019296 3086517968]: sock 7 ->LinkHandler Open
[Sun Feb 15 2015 05:14:13.019561 3086517968]: SendIPSConnect2Svr (195:128:01:00)
[Sun Feb 15 2015 05:14:13.019672 3086517968]: try connect 127.0.0.1:38180, Sync
[Sun Feb 15 2015 05:14:13.020892 3086517968]: sock 9 ->LinkHandler Open
[Sun Feb 15 2015 05:14:13.021012 3086517968]: SendIPSConnect2Svr (195:128:01:00)
[Sun Feb 15 2015 05:14:13.021149 3086517968]: try listening 38101 port
[Sun Feb 15 2015 05:14:13.027125 3078216592]: CProcessLayer(0)::svc Start [3078216592]
[Sun Feb 15 2015 05:14:13.027315 3078216592]: ServerState changed(0 -> 0)
[Sun Feb 15 2015 05:14:44.718159 3086517968]: accept success 11(190.121.100.17:1967)
[Sun Feb 15 2015 05:14:44.736063 3086517968]: 1.open user 11 [9CF4478] (190.121.100.17)
[Sun Feb 15 2015 05:14:44.804608 3078216592]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sun Feb 15 2015 05:15:28.609604 3086517968]: 1.close user 11 [9CF4478] (190.121.100.17)
[Sun Feb 15 2015 05:15:29.424530 3086517968]: accept success 11(190.121.100.17:1968)
[Sun Feb 15 2015 05:15:29.424704 3086517968]: 1.open user 11 [9CF4478] (190.121.100.17)
[Sun Feb 15 2015 05:15:29.466541 3078216592]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sun Feb 15 2015 05:15:29.483755 3078216592]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sun Feb 15 2015 05:15:40.361959 3078216592]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sun Feb 15 2015 05:16:13.311670 3078216592]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sun Feb 15 2015 05:16:13.327868 3078216592]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sun Feb 15 2015 05:16:14.385814 3086517968]: 1.close user 11 [9CF4478] (190.121.100.17)
[Sun Feb 15 2015 05:18:03.626572 3078216592]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sun Feb 15 2015 05:18:31.924570 3078216592]: AuthRequest: UserID(volao477), Addr(190.121.100.17)
[Sun Feb 15 2015 05:18:31.927581 3078216592]: AuthResult: UserID(volao477), Addr(190.121.100.17), Result(34), UserNum(2)
[Sun Feb 15 2015 05:18:32.905237 3086517968]: 1.close user 11 [9CF4478] (190.121.100.17)
i need to fix it and sorry dor duplicate!
HELPP!!
please post dbagent logs too
here:
[Sun Feb 15 2015 08:08:51.138686 3086846448]: open log file '/var/log/cabal/DBAgent_01.log'
[Sun Feb 15 2015 08:08:51.139046 3086846448]: LOG LEVEL: 3
[Sun Feb 15 2015 08:08:51.139110 3086846448]: MemPoolUnitSizeClass(2): 24576Bytes
[Sun Feb 15 2015 08:08:51.140687 3086846448]: Start DBAgent_01 Server
[Sun Feb 15 2015 08:08:51.142088 3086846448]: UseEcryptText (Off)
[Sun Feb 15 2015 08:08:51.163099 3086842768]: CProcessLayer(0)::svc Start [3086842768]
[Sun Feb 15 2015 08:08:51.163351 3076352912]: CProcessLayer(0)::svc Start [3076352912]
[Sun Feb 15 2015 08:08:51.163667 3065863056]: CProcessLayer(0)::svc Start [3065863056]
[Sun Feb 15 2015 08:08:51.184737 3086846448]: try listening 38181 port
[Sun Feb 15 2015 08:08:51.185854 3044883344]: CProcessLayer(0)::svc Start [3044883344]
[Sun Feb 15 2015 08:08:51.186236 3055373200]: CProcessLayer(0)::svc Start [3055373200]
[Sun Feb 15 2015 08:08:51.583574 3086846448]: accept success 8(127.0.0.1:60684)
[Sun Feb 15 2015 08:08:51.585909 3086846448]: 1.open user 8 [83E4E90] (127.0.0.1)
[Sun Feb 15 2015 08:08:52.061359 3086846448]: accept success 10(127.0.0.1:60686)
[Sun Feb 15 2015 08:08:52.061543 3086846448]: 2.open user 10 [83F35D0] (127.0.0.1)
[Sun Feb 15 2015 08:09:15.347771 3044883344]: Database Connect success!
[Sun Feb 15 2015 08:09:15.378117 3076352912]: Database Connect success!
[Sun Feb 15 2015 08:09:15.379774 3065863056]: Database Connect success!
[Sun Feb 15 2015 08:09:15.445682 3065863056]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072
[Sun Feb 15 2015 08:09:52.085429 3055373200]: Database Connect success!
[Sat Feb 14 2015 11:15:24.356345 3086649840]: open log file '/var/log/cabal/DBAgent_01.log'
[Sat Feb 14 2015 11:15:24.402590 3086649840]: LOG LEVEL: 3
[Sat Feb 14 2015 11:15:24.402674 3086649840]: MemPoolUnitSizeClass(2): 24576Bytes
[Sat Feb 14 2015 11:15:24.404176 3086649840]: Start DBAgent_01 Server
[Sat Feb 14 2015 11:15:24.405787 3086649840]: UseEcryptText (Off)
[Sat Feb 14 2015 11:15:24.406694 3086646160]: CProcessLayer(0)::svc Start [3086646160]
[Sat Feb 14 2015 11:15:24.406965 3076156304]: CProcessLayer(0)::svc Start [3076156304]
[Sat Feb 14 2015 11:15:24.407166 3065666448]: CProcessLayer(0)::svc Start [3065666448]
[Sat Feb 14 2015 11:15:24.407588 3086649840]: try listening 38181 port
[Sat Feb 14 2015 11:15:24.408575 3055176592]: CProcessLayer(0)::svc Start [3055176592]
[Sat Feb 14 2015 11:15:24.408779 3044686736]: CProcessLayer(0)::svc Start [3044686736]
[Sat Feb 14 2015 11:15:24.902618 3086649840]: accept success 8(127.0.0.1:55456)
[Sat Feb 14 2015 11:15:24.910801 3086649840]: 1.open user 8 [9705E90] (127.0.0.1)
[Sat Feb 14 2015 11:15:25.887608 3086649840]: accept success 10(127.0.0.1:55458)
[Sat Feb 14 2015 11:15:25.887845 3086649840]: 2.open user 10 [97145D0] (127.0.0.1)
[Sat Feb 14 2015 11:16:07.647863 3065666448]: Database Connect success!
[Sat Feb 14 2015 11:16:07.660709 3055176592]: Database Connect success!
[Sat Feb 14 2015 11:16:07.661001 3044686736]: Database Connect success!
[Sat Feb 14 2015 11:16:07.744036 3044686736]: sock 10=> sendBuf is growed (size:32768). len(657), 17000, 131072
[Sat Feb 14 2015 11:16:26.014299 3086646160]: Database Connect success!
[Sat Feb 14 2015 11:19:25.915990 3076156304]: Database Connect success!
I don't see the problem :|
This looks like either the computer that is running the server is overloaded and SQL is too busy, or the connection between centos and windows is very weak.
In you rlogin log check at Sat Feb 14 2015 16:41:34.236512. Here it sees your login attempt and gets a result back from the db ok. It then spends a long time accepting connections and doing nothing with them (it isn't even showing the user names being entered). Finally at Sun Feb 15 2015 00:55:54.507913 it recognises a users name and then goes back to sleep before going back to normal behaviour at Sun Feb 15 2015 02:39:55.783008.
If, when the problems start appearing, windows is running out of ram or the CPU is at 100% then the computer isn't powerful enough. Unless somebody was also playing the game on that computer only allocating too much ram to vmware would cause that i would think. The only other reason i can think of is the connection between the two isn't very stable and there isn't much you can do about that as there aren't really any settings for it.
Chumpy.. i really need help!
I have my computer formating and install all again.. AND THE PROBLEM STILL HAPEND!
Play say me what i need to do!! PLEASEE!
I don't know what is causing it, all i can do is point to where it is going wrong in the log and make a few guesses based on the very small amount of info i have.
Is the computer being played on as well as hosting the server? If so that is almost certainly the problem.
Is the CPU or RAM getting maxed out?
When the problem happens can centos ping windows?
Is your copy of windows a "home" edition?
All i can tell is that there seems to be a connectivity problem which won't have a "change that and it will work" answer. The problem doesn't happen for anybody else so i don't even have any other examples to get info from. All you can do is slowly eliminate possibilities until you find the problem.
i have a quad core 2.66 CPU and 4GB RAM .. and i have xp professional sp3 ... chumpy i know that u can't do so much.. but can u say me what did u search first? i really need ur help :(!
here are my full logs: http://www.mediafire.com/?mjhjze2hqdn
Thanks!
Last edited by volao47; 17-12-09 at 04:54 PM.
There are a lot of errors in your logs there including one about invalid date types which is affecting cabal_sp_auth. This will be preventing the logins.
I have only recently found the cause of this one and it is definitely language related. The tests i did and the fix are on this topic:[FreeTDS][SQL Server]La conversión del tipo de datos char a datetime produjo un valor datetime fuera de intervalo.
http://forum.ragezone.com/f451/it-ha...5/#post5369557
Once applied reboot centos and i think it will fix it.
MASTEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEEERRRRRRRRR!!!!!!!!!!!!!!!!!
WOOOOWW!! I FIX IT!!! THANKS U A LOOOOT CHUMPYYY!!!!
U ARE REALLY RALLY THE BEST IN THE WORDL!!!!!!!
Thanks a looot!
Reply With Quote
