Matchserver error if password=wrong good if not bad!

[rhys918]

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?

[MentaL]

[Phoenix]

Execute these both scripts on your database:

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)

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

[rhys918]

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