solve my problem pls.........

Newbie Spellweaver
Joined
May 27, 2010
Messages
88
Reaction score
12
still can't log into game......i have search it,but still not the answer yet....here my loginsvr log


[Thu Jun 10 2010 20:28:01.287051 3086067392]: open log file '/var/log/cabal/LoginSvr_01.log'
[Thu Jun 10 2010 20:28:01.287727 3086067392]: LOG LEVEL: 3
[Thu Jun 10 2010 20:28:01.288106 3086067392]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jun 10 2010 20:28:01.291125 3086067392]: Start LoginSvr_01 Server
[Thu Jun 10 2010 20:28:01.291702 3086067392]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Thu Jun 10 2010 20:28:01.291979 3086067392]: TestChannelGroupIdxStartPoint=50
[Thu Jun 10 2010 20:28:01.292176 3086067392]: affiliatedCorpIP=121.170.135.;
[Thu Jun 10 2010 20:28:01.292726 3086067392]: AdminIP=121.170.135.;
[Thu Jun 10 2010 20:28:01.293007 3086067392]: client_version=22
[Thu Jun 10 2010 20:28:01.293070 3086067392]: IgnoreClientVersion(1)
[Thu Jun 10 2010 20:28:01.293141 3086067392]: UseAntiOnlineGameAddictionSystem(1)
[Thu Jun 10 2010 20:28:01.293200 3086067392]: AdultAge(18)
[Thu Jun 10 2010 20:28:01.293719 3086067392]: DefaultAgeAdult(1)
[Thu Jun 10 2010 20:28:01.293971 3086067392]: UsePSS(0)
[Thu Jun 10 2010 20:28:01.294029 3086067392]: CachedPSS(0)
[Thu Jun 10 2010 20:28:01.294085 3086067392]: PssCacheDurationMin(1440)
[Thu Jun 10 2010 20:28:01.294141 3086067392]: CutIfPssUserNotFound(0)
[Thu Jun 10 2010 20:28:01.294689 3086067392]: PssLogLevel(0)
[Thu Jun 10 2010 20:28:01.294972 3086067392]: InstantPlayTimeClearIntervalMin(300)
[Thu Jun 10 2010 20:28:01.295089 3086067392]: IDC(1)
[Thu Jun 10 2010 20:28:01.295153 3086067392]: SharedPssPersonId(0)
[Thu Jun 10 2010 20:28:01.295697 3086067392]: NormalClientMagicKey(1168110)
[Thu Jun 10 2010 20:28:01.295758 3086067392]: UseImageAuth(0)
[Thu Jun 10 2010 20:28:01.296017 3086067392]: ImageAuthDataPath(./ImageAuth/)
[Thu Jun 10 2010 20:28:01.296178 3086067392]: ImageAuthMaxTryCount(5)
[Thu Jun 10 2010 20:28:01.296727 3086067392]: ImageAuthWaitTime(120000)
[Thu Jun 10 2010 20:28:01.296961 3086067392]: BlockIfImageAuthFail(0)
[Thu Jun 10 2010 20:28:01.297021 3086067392]: UseServerListManualOrder(0)
[Thu Jun 10 2010 20:28:01.297073 3086067392]: 00:00 => 0
[Thu Jun 10 2010 20:28:01.297126 3086067392]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Thu Jun 10 2010 20:28:01.297180 3086067392]: ImageAuthDataMgr Init Begin
[Thu Jun 10 2010 20:28:03.193503 3086067392]: ImageAuthDataMgr Init End(Count:1995)
[Thu Jun 10 2010 20:28:03.199495 3086067392]: try connect 127.0.0.1:38170, Sync
[Thu Jun 10 2010 20:28:03.206802 3086067392]: sock 7 ->LinkHandler Open
[Thu Jun 10 2010 20:28:03.207502 3086067392]: SendIPSConnect2Svr (195:128:01:00)
[Thu Jun 10 2010 20:28:03.207669 3086067392]: try connect 127.0.0.1:38180, Sync
[Thu Jun 10 2010 20:28:03.212613 3086067392]: sock 9 ->LinkHandler Open
[Thu Jun 10 2010 20:28:03.212764 3086067392]: SendIPSConnect2Svr (195:128:01:00)
[Thu Jun 10 2010 20:28:03.213617 3086067392]: try listening 38101 port
[Thu Jun 10 2010 20:28:03.646632 3077766048]: CProcessLayer(0)::svc Start [3077766048]
[Thu Jun 10 2010 20:28:03.647636 3077766048]: ServerState changed(0 -> 0)
[Thu Jun 10 2010 21:01:22.613772 3086067392]: accept success 11(192.168.133.2:3570)
[Thu Jun 10 2010 21:01:22.638473 3086067392]: 1.open user 11 [99CA4D0] (192.168.133.2)
[Thu Jun 10 2010 21:01:22.861591 3077766048]: AuthRequest: UserID(test), Addr(192.168.133.2)
[Thu Jun 10 2010 21:02:04.786355 3086067392]: 1.close user 11 [99CA4D0] (192.168.133.2)
[Thu Jun 10 2010 21:11:04.779978 3086173888]: open log file '/var/log/cabal/LoginSvr_01.log'
[Thu Jun 10 2010 21:11:04.780216 3086173888]: LOG LEVEL: 3
[Thu Jun 10 2010 21:11:04.780298 3086173888]: MemPoolUnitSizeClass(0): 14336Bytes
[Thu Jun 10 2010 21:11:04.781246 3086173888]: Start LoginSvr_01 Server
[Thu Jun 10 2010 21:11:04.781360 3086173888]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Thu Jun 10 2010 21:11:04.781470 3086173888]: TestChannelGroupIdxStartPoint=50
[Thu Jun 10 2010 21:11:04.781584 3086173888]: affiliatedCorpIP=121.170.135.;
[Thu Jun 10 2010 21:11:04.781648 3086173888]: AdminIP=121.170.135.;
[Thu Jun 10 2010 21:11:04.781718 3086173888]: client_version=22
[Thu Jun 10 2010 21:11:04.781777 3086173888]: IgnoreClientVersion(1)
[Thu Jun 10 2010 21:11:04.781846 3086173888]: UseAntiOnlineGameAddictionSystem(1)
[Thu Jun 10 2010 21:11:04.783836 3086173888]: AdultAge(18)
[Thu Jun 10 2010 21:11:04.783936 3086173888]: DefaultAgeAdult(1)
[Thu Jun 10 2010 21:11:04.785733 3086173888]: UsePSS(0)
[Thu Jun 10 2010 21:11:04.785802 3086173888]: CachedPSS(0)
[Thu Jun 10 2010 21:11:04.785859 3086173888]: PssCacheDurationMin(1440)
[Thu Jun 10 2010 21:11:04.785939 3086173888]: CutIfPssUserNotFound(0)
[Thu Jun 10 2010 21:11:04.786006 3086173888]: PssLogLevel(0)
[Thu Jun 10 2010 21:11:04.786064 3086173888]: InstantPlayTimeClearIntervalMin(300)
[Thu Jun 10 2010 21:11:04.786121 3086173888]: IDC(1)
[Thu Jun 10 2010 21:11:04.786177 3086173888]: SharedPssPersonId(0)
[Thu Jun 10 2010 21:11:04.786233 3086173888]: NormalClientMagicKey(1168110)
[Thu Jun 10 2010 21:11:04.786320 3086173888]: UseImageAuth(0)
[Thu Jun 10 2010 21:11:04.786400 3086173888]: ImageAuthDataPath(./ImageAuth/)
[Thu Jun 10 2010 21:11:04.786462 3086173888]: ImageAuthMaxTryCount(5)
[Thu Jun 10 2010 21:11:04.786523 3086173888]: ImageAuthWaitTime(120000)
[Thu Jun 10 2010 21:11:04.786580 3086173888]: BlockIfImageAuthFail(0)
[Thu Jun 10 2010 21:11:04.786638 3086173888]: UseServerListManualOrder(0)
[Thu Jun 10 2010 21:11:04.786691 3086173888]: 00:00 => 0
[Thu Jun 10 2010 21:11:04.786743 3086173888]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Thu Jun 10 2010 21:11:04.786796 3086173888]: ImageAuthDataMgr Init Begin
[Thu Jun 10 2010 21:11:06.666465 3086173888]: ImageAuthDataMgr Init End(Count:1995)
[Thu Jun 10 2010 21:11:06.668662 3086173888]: try connect 127.0.0.1:38170, Sync
[Thu Jun 10 2010 21:11:06.671312 3086173888]: sock 7 ->LinkHandler Open
[Thu Jun 10 2010 21:11:06.671440 3086173888]: SendIPSConnect2Svr (195:128:01:00)
[Thu Jun 10 2010 21:11:06.671598 3086173888]: try connect 127.0.0.1:38180, Sync
[Thu Jun 10 2010 21:11:06.672562 3086173888]: sock 9 ->LinkHandler Open
[Thu Jun 10 2010 21:11:06.672680 3086173888]: SendIPSConnect2Svr (195:128:01:00)
[Thu Jun 10 2010 21:11:06.672954 3086173888]: try listening 38101 port
[Thu Jun 10 2010 21:11:06.673105 3086173888]: [##ERROR##] listen 38101 port fail (Address already in use)
[Thu Jun 10 2010 21:11:06.673330 3086173888]: [##ERROR##] active fail
[Thu Jun 10 2010 21:11:07.887369 3077872544]: CProcessLayer(0)::svc Start [3077872544]
[Thu Jun 10 2010 21:11:07.888570 3077872544]: CProcessLayer(0)::svc Terminated [3077872544]
[Thu Jun 10 2010 21:12:09.940338 3086067392]: accept success 11(192.168.133.2:3733)
[Thu Jun 10 2010 21:12:09.941418 3086067392]: 1.open user 11 [99CA4D0] (192.168.133.2)
[Thu Jun 10 2010 21:12:10.128210 3077766048]: AuthRequest: UserID(nabilkfcbp1), Addr(192.168.133.2)
[Thu Jun 10 2010 21:12:52.004714 3086067392]: 1.close user 11 [99CA4D0] (192.168.133.2)
[Thu Jun 10 2010 21:13:09.277168 3086067392]: accept success 11(192.168.133.2:3734)
[Thu Jun 10 2010 21:13:09.279230 3086067392]: 1.open user 11 [99CA4D0] (192.168.133.2)
[Thu Jun 10 2010 21:13:09.443164 3077766048]: AuthRequest: UserID(test), Addr(192.168.133.2)
[Thu Jun 10 2010 21:14:56.078247 3086067392]: 1.close user 11 [99CA4D0] (192.168.133.2)
[Thu Jun 10 2010 21:48:22.784523 3086067392]: accept success 11(192.168.133.1:4901)
[Thu Jun 10 2010 21:48:22.788439 3086067392]: 1.open user 11 [99CA4D0] (192.168.133.1)
[Thu Jun 10 2010 21:48:23.022878 3077766048]: AuthRequest: UserID(test), Addr(192.168.133.1)
[Thu Jun 10 2010 21:49:06.295018 3086067392]: 1.close user 11 [99CA4D0] (192.168.133.1)
[Thu Jun 10 2010 22:46:00.869058 3086067392]: accept success 11(192.168.133.1:6315)
[Thu Jun 10 2010 22:46:00.884292 3086067392]: 1.open user 11 [99CA4D0] (192.168.133.1)
[Thu Jun 10 2010 22:46:01.029996 3077766048]: AuthRequest: UserID(lala), Addr(192.168.133.1)
[Thu Jun 10 2010 22:46:43.601873 3086067392]: 1.close user 11 [99CA4D0] (192.168.133.1)
[Thu Jun 10 2010 22:48:23.003958 3086067392]: accept success 11(192.168.133.1:6316)
[Thu Jun 10 2010 22:48:23.009404 3086067392]: 1.open user 11 [99CA4D0] (192.168.133.1)
[Thu Jun 10 2010 22:48:23.170942 3077766048]: AuthRequest: UserID(lala), Addr(192.168.133.1)
[Thu Jun 10 2010 22:49:05.248031 3086067392]: 1.close user 11 [99CA4D0] (192.168.133.1)
 
The "port in use" error means that another process is already using it. This usually happens when reconfiguring the server when auto restart is enabled (last question in cabal_config). Simply reboot centos to fix it.

I also can't see SQL answering the login request. After the IP address in the AuthRequest: there should be a number which means SQL either accepted or rejected the username/pass and it isn't there. Check you can ping the windows IP from centos and post the results of running the query below on any db:

Code:
Declare @insname varchar(25)
if convert(varchar(25),serverproperty('instancename')) is null
  set @insname='MSSQLSERVER'
else
  set @insname=convert(varchar(25),serverproperty('instancename'))
  select @insname as 'Instance',
  serverproperty('productversion') as 'Ver', serverproperty('productlevel') as 'SP',
  serverproperty('edition') as 'Edition'
  if @insname<>'MSSQLSERVER'
  begin
    select 'THIS IS BAD! You must reinstall MSSQL. Please follow the guides next time.' as 'MSSQL is a named instance!'
  end

  begin
    Declare @inspath varchar(10),@reg varchar(100),@tcpremote as int
    EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
    @key='Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\',
    @value_name=@insname,
    @value=@inspath OUTPUT
    set @reg='Software\Microsoft\Microsoft SQL Server\' + @inspath + '\MSSQLSERVER\SuperSocketNetLib\tcp\'
    EXEC master.dbo.xp_regread @rootkey='HKEY_LOCAL_MACHINE',
    @key=@reg,
    @value_name='Enabled',
    @value=@tcpremote OUTPUT
    select @inspath as 'Instance path',@tcpremote as 'Remote connections enabled?'
    if @tcpremote='0'
      begin
        EXEC master.dbo.xp_regwrite @rootkey='HKEY_LOCAL_MACHINE',
        @key=@reg, @value_name='Enabled', @type='REG_DWORD',@value=1
        select 'I enabled remote connections ! Please reboot !' as 'Remote connections checker'
      end
    else
      begin
        select 'This is good! I have nothing to do :(' as 'Remote connections checker'
      end
    select account.dbo.fn_md5('test') as 'xp_md5.dll check'
  end
 
Upvote 0
i can ping window ip from centos......here the result of the query

boyxx - solve my problem pls......... - RaGEZONE Forums
 
Upvote 0
Back