Matchserver error if password=wrong good if not bad!

Results 1 to 3 of 3
  1. #1
    Account Upgraded | Title Enabled! rhys918 is offline
    MemberRank
    Apr 2009 Join Date
    EnglandLocation
    377Posts

    talk Matchserver error if password=wrong good if not bad!

    Hi I try to access my server and now for some reason it takes long to connect then sais cannot access server but if i type my password wrong it tell me i have typed it wrong here is my matchserver log

    success to update CustomIP
    [02/08/11 08:46:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 08:51:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 08:56:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:01:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:06:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:11:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:16:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:21:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:26:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:31:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:36:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:41:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    MMatchDBMgr::GetCustomIPList - Communication link failure

    success to update CustomIP
    [02/08/11 09:46:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:51:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 09:56:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:01:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:06:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:11:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:16:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:21:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:26:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:31:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:36:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:41:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    MMatchDBMgr::GetCustomIPList - Communication link failure

    success to update CustomIP
    [02/08/11 10:46:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:51:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 10:56:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:01:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:06:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:11:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:16:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:21:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:26:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:31:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:36:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:41:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    MMatchDBMgr::GetCustomIPList - Communication link failure

    success to update CustomIP
    [02/08/11 11:46:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    [02/08/11 11:51:37] GARBAGE SESSION CLEANING : ClientCount=0, SessionCount=1, AgentCount=1
    MMatchDBMgr::InsertConnLog - Communication link failure

    MMatchDBMgr::GetAccountCharList - Communication link failure

    [11:55:01] Async DB Query(ResponseAccountCharList) Failed
    MMatchDBMgr::InsertConnLog - Communication link failure

    MMatchDBMgr::GetAccountCharList - Communication link failure

    [11:55:12] Async DB Query(ResponseAccountCharList) Failed
    MMatchDBMgr::InsertConnLog - Communication link failure

    MMatchDBMgr::GetAccountCharList - Communication link failure

    [11:55:29] Async DB Query(ResponseAccountCharList) Failed
    MMatchDBMgr::InsertConnLog - Communication link failure

    MMatchDBMgr::GetAccountCharList - Communication link failure

    [11:55:55] Async DB Query(ResponseAccountCharList) Failed
    MMatchDBMgr::InsertConnLog - Communication link failure

    MMatchDBMgr::GetAccountCharList - Communication link failure

    [11:56:19] Async DB Query(ResponseAccountCharList) Failed
    [02/08/11 11:56:37] GARBAGE SESSION CLEANING : ClientCount=1, SessionCount=2, AgentCount=1
    RealCPNet> SessionCreated=92, SessionDestroyed=89


    How can i fix please?


  2. #2
    Ā  Phoenix is offline
    ModeratorRank
    Mar 2009 Join Date
    6,890Posts

    Re: Matchserver error if password=wrong good if not bad!

    Execute these both scripts on your database:

    Code:
    GO
    /****** Object:  StoredProcedure [dbo].[spInsertConnLog]    Script Date: 02/01/2011 20:15:07 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER OFF
    GO
    CREATE PROC [dbo].[spInsertConnLog] 
     @AID int
    , @IPPart1 tinyint
    , @IPPart2 tinyint
    , @IPPart3 tinyint
    , @IPPart4 tinyint
    , @CountryCode3	char(3)
    AS
     SET NOCOUNT ON
     INSERT INTO ConnLog( AID, Time, IPPart1, IPPart2, IPPart3, IPPart4, CountryCode3)
     VALUES (@AID, GETDATE(), @IPPart1, @IPPart2, @IPPart3, @IPPart4, @CountryCode3)
    Code:
    GO
    /****** Object:  StoredProcedure [dbo].[spIPFltGetCustomIPList]    Script Date: 02/01/2011 20:15:08 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE PROC [dbo].[spIPFltGetCustomIPList]
    
    AS
    
     SET NOCOUNT ON
    
     SELECT IPFrom, IPTo, IsBlock, CountryCode3, Comment FROM CustomIP(NOLOCK)
    
     ORDER BY IPFrom
    GO
    /****** Object:  StoredProcedure [dbo].[spAdmWebDeleteCustomIP]    Script Date: 02/01/2011 20:15:06 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE  PROC [dbo].[spAdmWebDeleteCustomIP]
     @IPFrom varchar(15)
    , @IPTo varchar(15)
    , @Ret int OUTPUT
    AS
     SET NOCOUNT ON
     DECLARE @TmpIPFrom BIGINT
     DECLARE @TmpIPTo BIGINT
     
     SET @TmpIPFrom = GunzDB.game.inet_aton( @IPFrom )
     SET @TmpIPTo = GunzDB.game.inet_aton( @IPTo )
     IF @TmpIPFrom > @TmpIPTo BEGIN
      SET @Ret = 0
      RETURN @Ret
     END
     
     DELETE CustomIP WHERE IPFrom = @TmpIPFrom AND IPTo = @TmpIPTo
     IF 0 <> @@ERROR SET @Ret = 0
     ELSE SET @Ret = 1
     RETURN @Ret
    This, however may not solve your problem because your database has a few errors. Use a different one. I can't find any stored procedure for 'GetAccountCharList'.

  3. #3
    Account Upgraded | Title Enabled! rhys918 is offline
    MemberRank
    Apr 2009 Join Date
    EnglandLocation
    377Posts

    Re: Matchserver error if password=wrong good if not bad!

    im using x-weaver what one would you reccomend to use and how would i use a new one with out all the accounts going :/



Advertisement