CrashDump.

My MatchServer Log:

Quote:

---

nhn server mode is real
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[04/12/11 21:15:40] DBMS connected
[04/12/11 21:15:40] Command registeration completed

10
MBMatchServer::AddClanServerSwitchDownSchedule - make close clan mode schedule success. next close clan mode time is 11-4-30 23:50

10
Inited client file list (1)
success init security.
FILE PATH : C:\Documents and Settings\matan\Desktop\SF\MatchServer\MD5HashValue.txt
MD5 Hash Value => 6e ff 40 c1 22 1e 4b 2b 33 ce 22 41 7d c4 3a 3d

================================== Server configure info ==================================
[04/12/11 21:15:41] Release Date : Jun 13 2007
[04/12/11 21:15:41] X-Trap Off
[04/12/11 21:15:41] MD5 Check Off
[04/12/11 21:15:41] Server Country : BRAZIL
[04/12/11 21:15:41] Command version : (56)
[04/12/11 21:15:41] Event usable state : (false)
[04/12/11 21:15:41] Load event size : (1)
[04/12/11 21:15:41] FileCRCCheckSum usable state : (false)
[04/12/11 21:15:41] FileCRC size : (1)
[04/12/11 21:15:41] Country Code Filter usalbe state : (false)
[04/12/11 21:15:41] Accept Invalied IP state : (true)
[04/12/11 21:15:41] Keeper IP : (212.235.17.90)
[04/12/11 21:15:41] Monitor IP : (127.0.0.1)
===========================================================================================

[04/12/11 21:15:41] Match Server Created (Port:3840800)
success to update CustomIP
MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

CrashDump Entered 1
CrashDump Entered 2
CrashDump Leaving
CrashDump Leaved

---

When the CrashDump Entered 1 Appears in my MatchServer LOG
my MatchServer just close automaticly, so please help me guys.
i'm using the 2007 Revs files

Post your server.ini here please. ~vJosh

Quote:

---

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="sa"

[SERVER]
MAXUSER=500
SERVERID=1
SERVERNAME="DreamGunz"
FREELOGINIP=""
KEEPERIP="MyIP"
MONITORIP="127.0.0.1"
MONITORPORT=9000
MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

---

Here it is

---------- Post added at 07:01 PM ---------- Previous post was at 06:51 PM ----------

Sorry for the double post, but someone can help me please?.

Code:

---

[DB]
DNS="GunzDB"
USERNAME="sa"
PASSWORD="MSSQL PASSWORD"

[SERVER]
MAXUSER=500
SERVERID=1
SERVERNAME="DreamGunz"
FREELOGINIP=""
KEEPERIP="WANIP"
MONITORIP="127.0.0.1"
MONITORPORT=9000
MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

---

By 'SA' as your database password, you're censoring your actual password yes?
Also, This seems fine, must be a problem with the matchserver itself or your database.
Are you sure that your database is named 'GunzDB' and have you setup your ODBC?

first, yea i do.
what do you think should be the problem with the database or matchserver?

Quote:

---

MMatchDBMgr::InsertConnLog - Invalid object name 'LogDB.game.ConnLog'.

---

Mentions 'DB' - Also if your DB is correct, its obviously going to be your matchserver.

Just execute the following scripts on your database. It is nothing related to the server.ini.

Code:

---

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spRegularUpdateConnLog]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spRegularUpdateConnLog]
AS
 SET NOCOUNT ON

 DECLARE @Year char(4)
 DECLARE @Mon char(2)
 DECLARE @OldDate smalldatetime
 DECLARE @OldTableName varchar(128)

 SET @OldDate = DATEADD( mm, -1, GETDATE() )
 SET @Year = DATEPART(yy, @OldDate)
 SET @Mon = DATEPART(mm, @OldDate)

 SET @OldTableName = ''ConnLog_'' + @Year +
  CASE WHEN @Mon < 10 THEN ''0'' + CAST(@Mon AS char(1))
  ELSE CAST(@Mon AS char(2)) END

 EXEC sp_rename ''ConnLog'', @OldTableName

 CREATE TABLE ConnLog(
  id int IDENTITY
 , AID int NOT NULL
 , Time smalldatetime
 , IPPart1 tinyint NOT NULL
 , IPPart2 tinyint NOT NULL
 , IPPart3 tinyint NOT NULL
 , IPPart4 tinyint NOT NULL
 , CountryCode3 char(3) )

 CREATE NONCLUSTERED INDEX IX_ConnLog_AID
 ON ConnLog( AID )

 CREATE NONCLUSTERED INDEX IX_ConnLog_Time
 ON ConnLog( Time )

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetCharClan]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetCharClan]
 @CID  int 
AS 
 SET NOCOUNT ON
 SELECT cl.CLID AS CLID, cl.Name AS ClanName FROM ClanMember cm(nolock), Clan cl(nolock) WHERE cm.cid=@CID AND cm.CLID=cl.CLID 

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanList]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanList] 
 @Page INT, 
 @Backward INT  = 0 
AS 
SET NOCOUNT ON
BEGIN 
 DECLARE @PageHead INT 
 DECLARE @RowCount INT 
 
 IF @Backward = 0 
 BEGIN 
  SELECT @RowCount = ((@Page -1) * 15 + 1) 
   
  SET ROWCOUNT @RowCount 
  SELECT @PageHead = CLID FROM Clan(NOLOCK) WHERE DeleteFlag=0 ORDER BY CLID DESC 
   
  SET ROWCOUNT 15 
  SELECT cl.CLID AS CLID, cl.Name as ClanName, c.Name AS Master, cl.RegDate AS RegDate, cl.EmblemUrl AS EmblemUrl, cl.Point AS Point 
  FROM Clan cl(NOLOCK), Character c(nolock) 
  WHERE cl.MasterCID=c.CID AND cl.DeleteFlag=0 AND cl.CLID<@PageHead 
  ORDER BY cl.CLID DESC 
 END 
 ELSE 
 BEGIN -- 역순 
  SELECT @RowCount = ((@Page -1) * 15 + 1) 
   
  SET ROWCOUNT @RowCount 
  SELECT @PageHead = CLID FROM Clan(NOLOCK) WHERE DeleteFlag=0 ORDER BY CLID 
   
  SET ROWCOUNT 15 
  SELECT CLID, ClanName, Master, RegDate, EmblemUrl, Point 
  FROM 
  ( 
  SELECT TOP 15 cl.CLID AS CLID, cl.Name as ClanName, c.Name AS Master, cl.RegDate AS RegDate, cl.EmblemUrl AS EmblemUrl, cl.Point AS Point 
  FROM Clan cl(NOLOCK), Character c(nolock) 
  WHERE cl.MasterCID=c.CID AND cl.DeleteFlag=0 AND cl.CLID>=@PageHead ORDER BY cl.CLID 
  ) AS t 
  ORDER BY CLID DESC 
 END 
END 

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanListSearchByName]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanListSearchByName]
 @Name VARCHAR(24) 
AS 
SET NOCOUNT ON
BEGIN 
 SELECT TOP 20 cl.CLID AS CLID, cl.Name as ClanName, c.Name AS Master, cl.RegDate AS RegDate, cl.EmblemUrl AS EmblemUrl, cl.Point AS Point 
 FROM Clan cl(NOLOCK), Character c(NOLOCK) 
 WHERE cl.MasterCID=c.CID AND c.DeleteFlag=0 AND cl.Name=@Name 
 ORDER BY cl.CLID 
END 

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanMember]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanMember] 
 @CLID  int 
AS 
 SET NOCOUNT ON
 SELECT cm.clid AS CLID, cm.Grade AS ClanGrade, c.cid AS CID, c.name AS CharName 
 FROM ClanMember cm(nolock), Character c(nolock) 
 WHERE CLID=@CLID AND cm.cid=c.cid 

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanRankingHistory]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE  PROC [dbo].[spWebGetClanRankingHistory] 
 @Year INT, 
 @Month INT, 
 @Page INT, 
 @Backward INT = 0 
AS 
SET NOCOUNT ON
BEGIN 
 /* 한페이지에 20개씩 보여준다 (속도를위해 갯수 고정) */ 
 DECLARE @RowCount INT 
 DECLARE @PageHead INT 
 
 IF @Backward = 0 
 BEGIN 
  SELECT @RowCount = ((@Page -1) * 20 + 1) 
  SELECT TOP 20 Ranking, ClanName as ClanName, Point, Wins, Losses, CLID FROM ClanHonorRanking(NOLOCK) 
  WHERE Year=@Year AND Month=@Month AND Ranking>0 AND Ranking >= @RowCount ORDER BY Ranking 
 END 
 ELSE 
 BEGIN 
  SELECT @RowCount = ((@Page -1) * 20 + 1) 
 
  SET ROWCOUNT @RowCount 
  SELECT @PageHead = Ranking FROM Clan(NOLOCK) WHERE DeleteFlag=0 ORDER BY Ranking DESC 
 
  SET ROWCOUNT 20 
  SELECT  Ranking, RankIncrease=0, ClanName, Point, Wins, Losses, CLID, EmblemUrl=NULL FROM 
  ( 
  SELECT TOP 20 Ranking, ClanName, Point, Wins, Losses, CLID FROM ClanHonorRanking(NOLOCK) 
  WHERE Year=@Year AND Month=@Month AND Ranking>0 AND Ranking <= @PageHead ORDER BY Ranking DESC 
  ) AS t ORDER BY Ranking 
 END 
END 
 

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanRankingMaxPage]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanRankingMaxPage] 
AS 
SET NOCOUNT ON
BEGIN 
 DECLARE @MaxPage INT 
 SELECT TOP 1 @MaxPage = Ranking / 20 + 1 FROM Clan(NOLOCK) WHERE DeleteFlag=0 AND Ranking>0 ORDER BY Ranking DESC 
-- SELECT @MaxPage 
 RETURN @MaxPage 
END 

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[spWebGetClanRankingSearchByRanking]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROC [dbo].[spWebGetClanRankingSearchByRanking] 
 @Ranking INT 
AS 
SET NOCOUNT ON
BEGIN 
 SELECT TOP 20 Ranking, RankIncrease, Name as ClanName, Point, Wins, Losses, CLID, EmblemUrl FROM Clan(NOLOCK) 
 WHERE DeleteFlag=0 AND Ranking>0 AND Ranking=@Ranking ORDER BY Ranking 
END 

'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ConnLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ConnLog](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [AID] [int] NOT NULL,
        [Time] [smalldatetime] NULL,
        [IPPart1] [tinyint] NOT NULL,
        [IPPart2] [tinyint] NOT NULL,
        [IPPart3] [tinyint] NOT NULL,
        [IPPart4] [tinyint] NOT NULL,
        [CountryCode3] [char](3) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DeleteAccountLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[DeleteAccountLog](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [UserID] [varchar](24) NOT NULL,
        [AID] [int] NOT NULL,
        [RegDate] [smalldatetime] NULL,
PRIMARY KEY CLUSTERED
(
        [id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ServerLogStorage]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ServerLogStorage](
        [id] [int] IDENTITY(1,1) NOT NULL,
        [ServerID] [smallint] NOT NULL,
        [PlayerCount] [int] NOT NULL,
        [GameCount] [int] NOT NULL,
        [BlockCount] [int] NOT NULL,
        [NonBlockCount] [int] NOT NULL,
        [Time] [smalldatetime] NOT NULL,
PRIMARY KEY CLUSTERED
(
        [id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]
END

---

Code:

---

USE [GunZDB]
GO
/****** Object:  StoredProcedure [dbo].[spInsertConnLog]    Script Date: 05/20/2009 23:46:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO

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

---

Ow phoenix thx !
it worked very nice ;) thx man ur the best.
HiroSoul thx too man!