Setting Up Server

09/12/2011 15:48 fiction12#91
Quote:
Originally Posted by hambal View Post
i cant even restore bak files it give me error got sql 2005
When ur restoring the Db check in options (Overwrite the existence database)... this image might help u, it's an example...
[Only registered and activated users can see links. Click Here To Register...]
09/12/2011 15:51 Ninja_Stylez#92
[Only registered and activated users can see links. Click Here To Register...]

I stuck on the odbc :(

If any1 can help me with some tips or advices will be great :)

edit : Images 1 and 2 (db restore) 3 (how to run ODBC)
09/12/2011 15:53 links2007#93
Quote:
Originally Posted by meteorfal1 View Post
how you passed this:
cannot establish keep alive session : 192.168.2.2 32003 (bind 0.0.0.0)

??
just open gateway server and it will say server cord stablished :4 192.168.1.2 32003
09/12/2011 15:57 meteorfal1#94
Quote:
Originally Posted by links2007 View Post
just open gateway server and it will say server cord stablished :4 192.168.1.2 32003
oke i will try now this

but it still gives this error me
09/12/2011 15:59 badibatu22#95
Quote:
Originally Posted by links2007 View Post
just open gateway server and it will say server cord stablished :4 192.168.1.2 32003
can u put here ur server.cfg with html code ?
HTML Code:
like this
09/12/2011 15:59 meteorfal1#96
[Only registered and activated users can see links. Click Here To Register...]

i get hre last
09/12/2011 15:59 hambal#97
Quote:
Originally Posted by fiction12 View Post
When ur restoring the Db check in options (Overwrite the existence database)... this image might help u, it's an example...
[Only registered and activated users can see links. Click Here To Register...]
reinstalled my sql so maybe it will work now :P
09/12/2011 16:02 Ninja_Stylez#98
Meteorfal1 Can you explain me the things with the OBDC? Or any1 ?
09/12/2011 16:04 links2007#99
Quote:
Originally Posted by badibatu22 View Post
can u put here ur server.cfg with html code ?
HTML Code:
like this
HTML Code:
Common {
	debug_option_debugger_present	{
			DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
			DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
			DEBUG_OPTION_ASSERT_CANCEL_EXIT
	}
	
	debug_option_stand_alone	{			
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}

	netengine_debug_option_debugger_present	{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}

	netengine_debug_option_stand_alone	{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP 
	}

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
//	Certification "192.168.1.3", 32001
	Certification "192.168.1.3", 32001
	
	LoginFailureTolerance		3				// 최대 로그인 패스워드 오류 허용치
	IBUVFailureTolerance		3				// 최대 이미지 인증 오류 허용치
	LoginFailureBlockTimeMin	10				// 블럭 시간(분) - 로그인 패스워드 오류 
	IBUVFailureBlockTimeMin		10				// 블럭 시간(분) - 이미지 인증 오류 
	AutomatedPunisher		"AutomatedPunisher"		// 블럭 주체 이름 (기존 블럭은 gm 명)
	LoginPunishmentGuide		"Blocked for 10 minutes due to incorrect password entered 3 times"	// 패스워드 오류에 대한 블럭 가이드
	LoginPunishmentDescription	"Blocked for 10 minutes due to incorrect password entered 3 times"	// 패스워드 오류에 대한 블럭 설명
	IBUVPunishmentGuide		"Blocked for 10 minutes due to incorrect code entered 3 times"		// 이미지 인증 오류에 대한 블럭 가이드
	IBUVPunishmentDescription	"Blocked for 10 minutes due to incorrect code entered 3 times"		// 이미지 인증 오류에 대한 블럭 설명

}

GatewayServer {
	LastFullVersion_SR_Client 130
	Certification "192.168.1.3", 32000
	IBUVQueueReserveCount		20000	// IBUV를 위해 미리 생성해 놓을 이미지 갯수	
	IBUVQueuePrepareRatio		0.05	// 아이들 타임에 이미지 생성할 비율
	IBUVFailureIPTolerance		0	// 한 IP당 IBUV 실패를 허용할 최대 오류 허용치, 0이면 블럭 안하겠다는 거지.

	// 추가된 넘이다!!!!!
	//////////////////////////////////////////////////////////
	IBUVStringSize			6 	// 한글 캐릭터셋 사용 시 3, 알파벳 캐릭터 셋만 사용하는 경우 6 으로 세팅한다.
	IBUVCharacterSet		"ABCDEFGHLMNQRTabdehimn2345678"
	//////////////////////////////////////////////////////////
}

DownloadServer {
        Certification "192.168.1.3", 32000
}
FarmManager {
	Certification "192.168.1.3", 32000
}

AgentServer {
	Certification "192.168.1.3", 32004
}

MachineManager {
	Certification "192.168.1.3", 32000
}

SR_GameServer {
	Certification "192.168.1.3", 32004

	ExpRatio             100
        ExpRatioParty        100
      
	DropItemRatio       0,1
        DropGoldAmountCoef   0,1	
        //WINTER_EVENT_2009		EVENT_ON	// 2009년 겨울 이벤트
	//EUBUSINESS_EVENT		EVENT_ON
        //GOLDEN_PIG_FEBRUARY_EVENT	EVENT_ON
	//THANKS_GIVING_EVENT		EVENT_ON
	//LIBERATION_EVENT		EVENT_ON
	LOCALE LOCALE_VIETNAM	// for Helper mark 
       
         //#ifdef OPEN_MARKET_SYSTEM
        SET_FEE_RATE            "0,5,5,5"
        SELL_FEE_RATE           "0,10,10,10"
         //#endif OPEN_MARKET_SYSTEM
}

SR_ShardManager {
	Certification "127.0.0.1", 32004
	//BILLING_SERVER_URL "http://127.0.0.1:8080/"
	//CREST_FTP_URL "ftp://crest:crest@localhost/"
        ExtraExpRatio		0.1
        ChristmasEvent2007 0
	//SERVER_EVENT_SYSTEM             ON
       LOCALE LOCALE_VIETNAM
       FlagEvent 			0
       FlagEvent                        1
       HourForMeterRateLevelFirst	22
       HourForMeterRateLevelSecond	23

	BattleArenaRandom 1
	BattleArenaParty 1
	BattleArenaGuild 1
	BattleArenaJob 1
	ArenaMatchOccupy 1
	ArenaMatchFlag 1
	ArenaMatchPoint 1
}
btw ShardManager doesn't work for me it closes after a few seconds and say: Billing server Dead!!
09/12/2011 16:07 badibatu22#100
Quote:
Originally Posted by links2007 View Post
HTML Code:
Common {
	debug_option_debugger_present	{
			DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
			DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
			DEBUG_OPTION_ASSERT_CANCEL_EXIT
	}
	
	debug_option_stand_alone	{			
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}

	netengine_debug_option_debugger_present	{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}

	netengine_debug_option_stand_alone	{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX ,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP 
	}

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
//	Certification "192.168.1.3", 32001
	Certification "192.168.1.3", 32001
	
	LoginFailureTolerance		3				// 최대 로그인 패스워드 오류 허용치
	IBUVFailureTolerance		3				// 최대 이미지 인증 오류 허용치
	LoginFailureBlockTimeMin	10				// 블럭 시간(분) - 로그인 패스워드 오류 
	IBUVFailureBlockTimeMin		10				// 블럭 시간(분) - 이미지 인증 오류 
	AutomatedPunisher		"AutomatedPunisher"		// 블럭 주체 이름 (기존 블럭은 gm 명)
	LoginPunishmentGuide		"Blocked for 10 minutes due to incorrect password entered 3 times"	// 패스워드 오류에 대한 블럭 가이드
	LoginPunishmentDescription	"Blocked for 10 minutes due to incorrect password entered 3 times"	// 패스워드 오류에 대한 블럭 설명
	IBUVPunishmentGuide		"Blocked for 10 minutes due to incorrect code entered 3 times"		// 이미지 인증 오류에 대한 블럭 가이드
	IBUVPunishmentDescription	"Blocked for 10 minutes due to incorrect code entered 3 times"		// 이미지 인증 오류에 대한 블럭 설명

}

GatewayServer {
	LastFullVersion_SR_Client 130
	Certification "192.168.1.3", 32000
	IBUVQueueReserveCount		20000	// IBUV를 위해 미리 생성해 놓을 이미지 갯수	
	IBUVQueuePrepareRatio		0.05	// 아이들 타임에 이미지 생성할 비율
	IBUVFailureIPTolerance		0	// 한 IP당 IBUV 실패를 허용할 최대 오류 허용치, 0이면 블럭 안하겠다는 거지.

	// 추가된 넘이다!!!!!
	//////////////////////////////////////////////////////////
	IBUVStringSize			6 	// 한글 캐릭터셋 사용 시 3, 알파벳 캐릭터 셋만 사용하는 경우 6 으로 세팅한다.
	IBUVCharacterSet		"ABCDEFGHLMNQRTabdehimn2345678"
	//////////////////////////////////////////////////////////
}

DownloadServer {
        Certification "192.168.1.3", 32000
}
FarmManager {
	Certification "192.168.1.3", 32000
}

AgentServer {
	Certification "192.168.1.3", 32004
}

MachineManager {
	Certification "192.168.1.3", 32000
}

SR_GameServer {
	Certification "192.168.1.3", 32004

	ExpRatio             100
        ExpRatioParty        100
      
	DropItemRatio       0,1
        DropGoldAmountCoef   0,1	
        //WINTER_EVENT_2009		EVENT_ON	// 2009년 겨울 이벤트
	//EUBUSINESS_EVENT		EVENT_ON
        //GOLDEN_PIG_FEBRUARY_EVENT	EVENT_ON
	//THANKS_GIVING_EVENT		EVENT_ON
	//LIBERATION_EVENT		EVENT_ON
	LOCALE LOCALE_VIETNAM	// for Helper mark 
       
         //#ifdef OPEN_MARKET_SYSTEM
        SET_FEE_RATE            "0,5,5,5"
        SELL_FEE_RATE           "0,10,10,10"
         //#endif OPEN_MARKET_SYSTEM
}

SR_ShardManager {
	Certification "127.0.0.1", 32004
	//BILLING_SERVER_URL "http://127.0.0.1:8080/"
	//CREST_FTP_URL "ftp://crest:crest@localhost/"
        ExtraExpRatio		0.1
        ChristmasEvent2007 0
	//SERVER_EVENT_SYSTEM             ON
       LOCALE LOCALE_VIETNAM
       FlagEvent 			0
       FlagEvent                        1
       HourForMeterRateLevelFirst	22
       HourForMeterRateLevelSecond	23

	BattleArenaRandom 1
	BattleArenaParty 1
	BattleArenaGuild 1
	BattleArenaJob 1
	ArenaMatchOccupy 1
	ArenaMatchFlag 1
	ArenaMatchPoint 1
}
btw ShardManager doesn't work for me it closes after a few seconds and say: Billing server Dead!!
did u try to make shard same ip as others it still local ip
09/12/2011 16:12 hambal#101
it doesnt work on local ip right ?
09/12/2011 16:13 badibatu22#102
Quote:
Originally Posted by hambal View Post
it doesnt work on local ip right ?
yep
09/12/2011 16:15 hambal#103
ty badibatu22
09/12/2011 16:17 InZiDeR#104
Quote:
Originally Posted by meteorfal1 View Post
you need first some information about this shits

#first i will explain short and tomorrow i will do good guide before i leave community

first you need sql server 2005 and management studio express pack

then you need to restore dbs to sql

then go and set odbcs first need to look cert odbc then go server config file

Errors:
@who gets error 5 access denied, you need to run mssql on local system account

@who gets error 2 not found, i dont know this ones reason but create data and log files mdf and ldf on first directory like C:\Log_DB.ldf etc.

and that is the prof i am started to work ^^ just start i done cert and odbc now going to sleep tomorrow i will try to open a test sw
[Only registered and activated users can see links. Click Here To Register...]


i think thats enogh guilde for now for more info go and google error or info

and i think you need apache for the billing server i dont know apache runs asp ^^
For those who have the error 2(SQL 2005) (Cannot find specific path) i have a solution for u.

Create an empty Database bevore with exactly the same name as excample "Log_DB" after that you set restore Database and go in options to set "Overwrite existing DB" and set "to Database" = Log_DB.

It should work and he should overwrite the current Database that was empty ;)

And now you have all tables in it and its fully restored.

Sorry for my bad english :D


EDIT: Ohh and i forgot, if you create the empty database don't forget to set it as sql server 2000 compatiblity and not 2005. =)
09/12/2011 16:18 dimkacool#105
hey guys, I have problem with Certification... Well I launch Cert and it says it launched successfully, but than I launch GlobalManager and after a sec it crashes...

Anyone can help?