الموقع العربي الاول للعبة Silkroad Online

الموقع العربي الاول للعبة Silkroad Online (https://silkroad4arab.com/vb/index.php)
-   قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة (https://silkroad4arab.com/vb/forumdisplay.php?f=226)
-   -   مشكلة فى global manager Can't connect to account DB (https://silkroad4arab.com/vb/showthread.php?t=591352)

karimnour2015 01-09-2015 03:31 PM

مشكلة فى global manager Can't connect to account DB
 
cannot occupy db session : select * from SK_SilkChange_BY_Web
cannot occupy db session : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64

-------------------------

server.cfg

-------------------------

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 "25.137.29.152", 32000
LoginFailureTolerance 3
IBUVFailureTolerance 3
LoginFailureBlockTimeMin 0
IBUVFailureBlockTimeMin 0
AutomatedPunisher "AutomatedPunisher"
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.137.29.152", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 1
IBUVCharacterSet "ABCDEF1234567890"
}

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

AgentServer {
Certification "25.137.29.152", 15882 //no global manager running lol
//traffic_filter_activity "service_off"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}

MachineManager {
Certification "25.137.29.152", 15880
CERTIFICATION_IP_BIND "25.137.29.152"
}

SR_GameServer {
Certification "25.137.29.152", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "15000"
HwanGainFactor "250"
ShowFormulaDetail "1"

//WINTER_EVENT_2009 EVENT_ON
EUBUSINESS_EVENT EVENT_ON
GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
THANKS_GIVING_EVENT EVENT_ON
LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM

//#ifdef OPEN_MARKET_SYSTEM
SET_FEE_RATE "0,5,5,5"
SELL_FEE_RATE "0,10,10,10"
//#endif OPEN_MARKET_SYSTEM
//RE FTW

DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "OFF"
ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"


}

SR_ShardManager {
Certification "25.137.29.152", 15882
BILLING_SERVER_URL "http://25.137.29.152:8080/"
CREST_FTP_URL "ftp://conter:[email protected]/"
ChristmasEvent2007 1
SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 1
//HourForMeterRateLevelFirst 24
//HourForMeterRateLevelSecond 0

BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1
}

-------------------------

srGlobalService.ini

-------------------------
[global]
count=1
[entry0]
operation_type=22
name=conter road
query=DRIVER={SQL Server};SERVER=WIN7-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123;DA TABASE=SRO_VT_ACCOUNT
global_manager_node_id=697
-------------------------

srNodeType.ini

------------------------
[global]
count=1
[entry0]
id=335
operation_type=22
name=conter road
wip=25.137.29.152
nip=25.137.29.152
machine_manager_node_id=699
-------------------------

srShard.ini

-------------------------
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=conter road
query=DRIVER={SQL Server};SERVER=WIN7-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=123;DATA BASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=WIN7-PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=sa;PWD=123;D ATABASE=SRO_VT_SHARDLOG
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
------------------------

DBConnect.asp

------------------------
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=WIN-PC\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123;"
DBConnA.Open strConnectA

%>
------------------------
جربة اكتر من مره و على جهزين مختلفين و نفس المشكلة ارجو الحل فى اسرع وقت و انا عندى تيم فيور لو حابب تساعدنى شكرا :shy:

karimnour2015 01-09-2015 04:31 PM

رد: مشكلة فى global manager Can't connect to account DB
 
:busted_red::toobad:

omar hapshy 01-09-2015 04:51 PM

رد: مشكلة فى global manager Can't connect to account DB
 
ODBC
اتاكد منها

karimnour2015 01-09-2015 04:56 PM

رد: مشكلة فى global manager Can't connect to account DB
 
ODBC WORK + IIS + SQL

karimnour2015 01-09-2015 05:01 PM

رد: مشكلة فى global manager Can't connect to account DB
 
:sad2:

karimnour2015 01-09-2015 05:49 PM

رد: مشكلة فى global manager Can't connect to account DB
 
help يا رجالة :weeping:

Dangers SrO 02-09-2015 12:12 PM

رد: مشكلة فى global manager Can't connect to account DB
 
صوره من المشكله

geraya.sama 02-09-2015 03:28 PM

رد: مشكلة فى global manager Can't connect to account DB
 
يا ريت صوره للمشكله
وعموما طالما مش عايزه تشتغل يبقى فى ip غلط انت عملهراجع تانى على الخطوات ممكن انت عامل خطوه غلط ولو كله صح
يبقى فى مشكله فى ملفات السيرفر اللى انت شغال منه عموما جرب الاول وشوف والملفات نقدر نرفع لو فيها مشكله

karimnour2015 03-09-2015 06:34 AM

رد: مشكلة فى global manager Can't connect to account DB
 
http://im61.gulfup.com/RQiYMf.jpg

karimnour2015 03-09-2015 06:36 AM

رد: مشكلة فى global manager Can't connect to account DB
 
DBConnect
http://im55.gulfup.com/7IE2u4.jpg

karimnour2015 03-09-2015 06:37 AM

رد: مشكلة فى global manager Can't connect to account DB
 
srshard
http://im43.gulfup.com/S28joK.jpg

karimnour2015 03-09-2015 06:39 AM

رد: مشكلة فى global manager Can't connect to account DB
 
srnodetype
http://im71.gulfup.com/yroDol.jpg

karimnour2015 03-09-2015 06:40 AM

رد: مشكلة فى global manager Can't connect to account DB
 
srglobalservice
http://im80.gulfup.com/JEiech.jpg

karimnour2015 03-09-2015 06:41 AM

رد: مشكلة فى global manager Can't connect to account DB
 
ODBC
http://im62.gulfup.com/FPiBJi.jpg

karimnour2015 03-09-2015 11:18 AM

رد: مشكلة فى global manager Can't connect to account DB
 
HELP :mf_grenade::mf_grenade::mf_grenade::mf_grenade::m f_grenade::mf_grenade::mf_grenade::mf_grenade::mf_ grenade::mf_grenade::mf_grenade::mf_grenade::mf_gr enade::mf_grenade::mf_grenade::mf_grenade::mf_gren ade::mf_grenade::mf_grenade::mf_grenade::mf_grenad e::mf_grenade::mf_grenade::mf_grenade::mf_grenade: :mf_grenade::mf_grenade::mf_grenade::mf_grenade::m f_grenade:


الساعة الآن 09:48 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.