SR_ShardManager+Game Server DB Failed

08/22/2018 22:34 Yanivgali#1

I managed to run all the others but when I tried to open SR_ShardManager+Game Server it wrote me "DB Failed".
I looked for guide but I couldn't find any helpful guide I hope someone can help me (I'm sorry for my bad English I hope you understood me.)

server.cfg:

Spoiler

srGlobalService.ini:

Spoiler

srNodeType.ini:

Spoiler

srShard.ini:

Spoiler

DBConnect.asp:

Spoiler

08/23/2018 08:33 NorseGodTyr#2

Quote:

Originally Posted by Yanivgali

I managed to run all the others but when I tried to open SR_ShardManager+Game Server it wrote me "DB Failed".
I looked for guide but I couldn't find any helpful guide I hope someone can help me (I'm sorry for my bad English I hope you understood me.)

server.cfg:

Spoiler

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 "cert.joymax.com", 32000
Certification "25.22.107.206", 32000

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 "25.22.107.206", 15880
IBUVQueueReserveCount 20000 // IBUV를 위해 미리 생성해 놓을 이미지 갯수
IBUVQueuePrepareRatio 0.05 // 아이들 타임에 이미지 생성할 비율
IBUVFailureIPTolerance 0 // 한 IP당 IBUV 실패를 허용할 최대 오류 허용치, 0이면 블럭 안하겠다는 거지.

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

DownloadServer {
Certification "25.22.107.206", 15880
}
FarmManager {
Certification "25.22.107.206", 15880
}

AgentServer {
Certification "25.22.107.206", 15882
}

MachineManager {
Certification "25.22.107.206", 15880
}

SR_GameServer {
Certification "25.22.107.206", 15882

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 "25.22.107.206", 15882
BILLING_SERVER_URL "http://25.22.107.206:8080/"
CREST_FTP_URL "ftp://yaniv:19735647@25.22.107.206/"
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
}

srGlobalService.ini:

Spoiler

[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=AVIHAI-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=197356 47;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

srNodeType.ini:

Spoiler

[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=25.22.107.206
nip=25.22.107.206
machine_manager_node_id=699

srShard.ini:

Spoiler

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Server
query=DRIVER={SQL Server};SERVER=AVIHAI-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=19735647 ;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=AVIHAI-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=19735647;DATAB ASE=Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0

DBConnect.asp:

Spoiler

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=25.22.107.206;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=19735647;"
DBConnA.Open strConnectA

%>

check my thread here is a guide
[Only registered and activated users can see links. Click Here To Register...]

08/23/2018 15:15 Yanivgali#3

Quote:

Originally Posted by mialuisa

check my thread here is a guide
[Only registered and activated users can see links. Click Here To Register...]

This is very good tutorial but I still couldn't solve the problem because I did it accurately like this tutorial (I fixed DBConnect.asp due to this guide at least one problem is fixed)
I add pic of my problem.
[Only registered and activated users can see links. Click Here To Register...]

08/23/2018 16:09 Genoxid#4

Quote:

Originally Posted by Yanivgali

This is very good tutorial but I still couldn't solve the problem because I did it accurately like this tutorial (I fixed DBConnect.asp due to this guide at least one problem is fixed)
I add pic of my problem.
[Only registered and activated users can see links. Click Here To Register...]

odbc connection is missing or wrong ;)

08/23/2018 16:38 Yanivgali#5

Quote:

Originally Posted by Genoxid

odbc connection is missing or wrong ;)

I did it agian but still not working others idea>? :(

08/23/2018 18:01 NorseGodTyr#6

Quote:

Originally Posted by Yanivgali

I did it agian but still not working others idea>? :(

join my discord or pme on discord i will help you via anydesk is like teamviewer

08/23/2018 23:53 Yanivgali#7

Thanks everyone Problem solved thanks to mialuisa.:handsdown: