SOLVED
Hello, I've created a server with vsro 1.188 client and files.
So everything is setup, database, aspx files etc. and I've triple checked every single of connection strings. My cert files are okay too but on startup, sr_gameserver and sr_shardmanager does not connect to DB. Eveything except these 2 fucks working just fine, I've checked FTP and Billing files too nothing is wrong with them. Please take a look to the attachments. And do I need to extract media.pk2 and map.pk2 then put extracted shit into a folder inside server folder? I did it for data.pk2 into Data folder within server folder.
My server.cfg
PHP 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 "XX.XX.XX.XX", 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 "XX.XX.XX.XX", 15880
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0.10
IBUVFailureIPTolerance 0
IBUVStringSize 0
IBUVCharacterSet "ABCDEF1234567890"
}
DownloadServer {
Certification "XX.XX.XX.XX", 15880
}
FarmManager {
Certification "XX.XX.XX.XX", 15880
}
AgentServer {
Certification "XX.XX.XX.XX", 15882 //no global manager running lol
//traffic_filter_activity "service_of"
//MaxUser 5000
//SockTCPCount 15000
MaxConnectionsPerServer "5000"
MaxConnectionsPer1_OServer "5000"
}
MachineManager {
Certification "XX.XX.XX.XX", 15880
CERTIFICATION_IP_BIND "XX.XX.XX.XX"
}
SR_GameServer {
Certification "XX.XX.XX.XX", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "5000"
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 "XX.XX.XX.XX", 15882
BILLING_SERVER_URL "http://XX.XX.XX.XX:8080/"
CREST_FTP_URL "ftp://ftpuser:[Only registered and activated users can see links. Click Here To Register...].XX.XX:14741"
ExtraExpRatio 1000
ChristmasEvent2007 1
SERVER_EVENT_SYSTEM ON
LOCALE LOCALE_VIETNAM
FlagEvent 1
HourForMeterRateLevelFirst 22
HourForMeterRateLevelSecond 23
BattleArenaRandom 1
BattleArenaParty 1
BattleArenaGuild 1
BattleArenaJob 1
ArenaMatchOccupy 1
ArenaMatchFlag 1
ArenaMatchPoint 1
}
srShard.ini
PHP Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Test Server
query=DRIVER={SQL Server};SERVER=MYSERVER\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=1234;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=MYSERVER\SQLEXPRESSS;DSN=SRO_VT_LOG;UID=sa;PWD=1234;DATABASE=SRO_VT_LOG
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
DBConnect.asp
PHP Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=MYSERVER\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=1234;"
DBConnA.Open strConnectA
%>
What could be the problem ? :confused:
