Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server > SRO PServer Guides & Releases
You last visited: Today at 19:20

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Guide] Most of vsro files problem solved here

Discussion on [Guide] Most of vsro files problem solved here within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Closed Thread
 
Old 10/25/2011, 19:36   #2236
 
elite*gold: 10
Join Date: Oct 2011
Posts: 116
Received Thanks: 57
Quote:
Originally Posted by 379332 View Post
any1 know why SR_SHARDMANAGER ain't working propelly?
everything is running ok, when I come to SR_SHARD and SR_GAMESERVER it keeps like this
when you start shardmanager, you have to wait till that "Cert" is gone from the monitor. after it you can start gameserver, and you have to wait again, till Cert gone. After it you can start others, and start services.
ColdIsTheVoid is offline  
Old 10/25/2011, 19:41   #2237
 
379332's Avatar
 
elite*gold: 0
Join Date: May 2007
Posts: 297
Received Thanks: 72
Quote:
Originally Posted by sladlejrhfpq View Post
when you start shardmanager, you have to wait till that "Cert" is gone from the monitor. after it you can start gameserver, and you have to wait again, till Cert gone. After it you can start others, and start services.
yeah i know but, in the event log appears "DB connection failed" is that normal? cuz it does nothing at all after w8ing
379332 is offline  
Old 10/25/2011, 20:07   #2238

 
elite*gold: 133
Join Date: Jan 2010
Posts: 33
Received Thanks: 4
Quote:
Originally Posted by obstjunky View Post
the last error is "server cord established:1 (188.40.139.231:15882)
what do you mean with biling server ?!
i have 4gb ram o.o
i check already server.cfg or shall i send?

in the second pic you dont see any error o.o
look the red font =P zoom the picture you will see it becaus i dont know anything how i can fix it >_>
or can you help me with TeamViewer?
@sladlejrhfpq this i write ^^ i think you have not read my post ^^ i hope you can help me =)
obstjunky is offline  
Old 10/25/2011, 22:32   #2239
 
elite*gold: 0
Join Date: Mar 2008
Posts: 27
Received Thanks: 2
Help me please, i will be very thankful if someone can help me over Team viewer or find some time for me on Skype, or ICQ or Facebook thx.. My problem.. I am going to mad :/



Uploaded with

HELP :/
Lubco is offline  
Old 10/27/2011, 18:17   #2240
 
elite*gold: 0
Join Date: Feb 2008
Posts: 104
Received Thanks: 6
Query Error!!! Query Result : -1, Query : select * from SK_SilkChange_BY_Web

Query Error!!! Query Result : -1, Query : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64 PLEASEEEEEEEEEEE HELP
nitrogino is offline  
Old 10/27/2011, 19:19   #2241
 
hexcode's Avatar
 
elite*gold: 0
Join Date: Oct 2007
Posts: 1,171
Received Thanks: 346
Quote:
Originally Posted by Lubco View Post
Help me please, i will be very thankful if someone can help me over Team viewer or find some time for me on Skype, or ICQ or Facebook thx.. My problem.. I am going to mad :/



Uploaded with

HELP :/
Check your ODBC (setting/Connection) and database connection.The GlobalManager cannot access SRO_VT_ACCOUNT database.
hexcode is offline  
Old 10/28/2011, 04:00   #2242
 
elite*gold: 0
Join Date: Jun 2010
Posts: 24
Received Thanks: 2
Who can help me whit this problem xD:



i think all it's ok check:

Code:
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=PASSWORD;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697
Code:
[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=MYIP
nip=MYIP
machine_manager_node_id=699
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01;DSN=SRO_VT_SHARD;UID=sa;PWD=PASSWORD;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01;DSN=Log_DB;UID=sa;PWD=PASSWORD;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
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 "MYIP", 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 "MYIP", 15880
		IBUVQueueReserveCount		20000
		IBUVQueuePrepareRatio		0.10
		IBUVFailureIPTolerance		0
		IBUVStringSize				1
		IBUVCharacterSet			"ABCDEF1234567890"
}

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

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

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

SR_GameServer {
		Certification "MYIP", 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 "MYIP", 15882
		BILLING_SERVER_URL 		"http://201.242.249.124:8080/"
		CREST_FTP_URL 			"ftp://crest:[email protected]/"
		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
}
Code:
/*
*/

SMC {	
DivisionManager "MYIP",15880
}

ModulePatch
{
	SrcPath	".\Patch_Internal"
	DestPath ".\Patch_Internal_Comp"
}
I think all it's ok but hope someone can help me ^^

Used SQLEXPRESS01 because i reinstall SQL to many times xD
TheSoulTrack is offline  
Old 10/28/2011, 05:04   #2243
 
elite*gold: 0
Join Date: Feb 2008
Posts: 104
Received Thanks: 6
plsss help mi error
nitrogino is offline  
Old 10/28/2011, 05:38   #2244
 
elite*gold: 0
Join Date: Apr 2008
Posts: 12
Received Thanks: 0
MY ERROR

fatal Query Error!!! Query Result : -1, Query : {?=CALL _DelExpiredRentItemInStorage (0, 7844,'2011-10-27 21:58:8')} 2011-10-27 21:58:09 530
fatal SQL Error State:42000, Native Error Code: 1FB2, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Error al convertir el tipo de datos varchar a smalldatetime. 2011-10-27 21:58:11 317
fatal {?=CALL _DelExpiredRentItemInStorage (0, 7844,'2011-10-27 21:58:8')} 2011-10-27 21:58:11 322
fatal CALL _DelExpiredRentItemInStorage failed!! StorageType[0],StorageID[7844] 2011-10-27 21:58:11 372
fatal LOADTARGET_CHARDATA_N_INVENTORY(PC Inventory) Failed (693) 2011-10-27 21:58:11 376
warnning Character Data Loading Failed[JID: 3, CharID: 7844] 2011-10-27 21:58:11 464
warnning CharDataLoadingCompleted:: CharData loading failed![JID: 3, CharID: 7844] 2011-10-27 21:58:11 469

SOME ONE KNOW HOW TO FIX MY PROBLEM? THIS ERROR ITS WHEN I TRY TO START MY CHAR AFTER I CREATE IT
negron2 is offline  
Old 10/28/2011, 09:15   #2245
 
elite*gold: 0
Join Date: Feb 2008
Posts: 104
Received Thanks: 6
2011-10-28 01:09:05 [GlobalManager] Query Error!!! Query Result : -1, Query : exec _QueryActivePunishmet
2011-10-28 01:09:05 [GlobalManager] SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_QueryActivePunishmet'.
2011-10-28 01:09:05 [GlobalManager] exec _QueryActivePunishmet





FIXXXXXXXXX? PLEASE
nitrogino is offline  
Old 10/28/2011, 10:49   #2246
 
hexcode's Avatar
 
elite*gold: 0
Join Date: Oct 2007
Posts: 1,171
Received Thanks: 346
Quote:
Originally Posted by TheSoulTrack View Post
Who can help me whit this problem xD:



i think all it's ok check:

Code:
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=PASSWORD;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697
Code:
[global]
count=1
[entry0]
id=335
operation_type=22
name=SRO Vietnam TestLocal
wip=MYIP
nip=MYIP
machine_manager_node_id=699
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01;DSN=SRO_VT_SHARD;UID=sa;PWD=PASSWORD;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01;DSN=Log_DB;UID=sa;PWD=PASSWORD;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
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 "MYIP", 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 "MYIP", 15880
		IBUVQueueReserveCount		20000
		IBUVQueuePrepareRatio		0.10
		IBUVFailureIPTolerance		0
		IBUVStringSize				1
		IBUVCharacterSet			"ABCDEF1234567890"
}

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

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

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

SR_GameServer {
		Certification "MYIP", 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 "MYIP", 15882
		BILLING_SERVER_URL 		"http://201.242.249.124:8080/"
		CREST_FTP_URL 			"ftp://crest:[email protected]/"
		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 					
		ArenaMatchPoint 				1
}
Code:
/*
*/

SMC {	
DivisionManager "MYIP",15880
}

ModulePatch
{
	SrcPath	".\Patch_Internal"
	DestPath ".\Patch_Internal_Comp"
}
I think all it's ok but hope someone can help me ^^

Used SQLEXPRESS01 because i reinstall SQL to many times xD
Check this arguments in config files :

line: query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=PASSWORD;

You must use computer name or IP not a User.

SERVER=MYUSER\SQLEXPRESS01; -> SERVER=PC_Name\SQLEXPRESS;(or SERVER=.\SQLEXPRESS; if you start Cert and SQL on same PC)

Check and make correction in all files.
Regards
hexcode is offline  
Old 10/28/2011, 13:24   #2247
 
elite*gold: 0
Join Date: Mar 2009
Posts: 28
Received Thanks: 0
@Abdelfattah

Please help !
prometeus is offline  
Old 10/28/2011, 15:18   #2248
 
hexcode's Avatar
 
elite*gold: 0
Join Date: Oct 2007
Posts: 1,171
Received Thanks: 346
Quote:
Originally Posted by prometeus View Post
@Abdelfattah

Please help !
Probably ur char is in DISABLED region.Check _RefRegionBindAssocServer Table.CHINA must be set 1 (Enabled) Don't forget to execute this command after corrections(run as sql query SQL Management Studio)

Quote:
use SRO_VT_SHARD
go
exec _LinkRefRegions
Regards
hexcode is offline  
Old 10/28/2011, 17:55   #2249
 
elite*gold: 0
Join Date: Mar 2009
Posts: 28
Received Thanks: 0
Quote:
Originally Posted by hexcode View Post
Probably ur char is in DISABLED region.Check _RefRegionBindAssocServer Table.CHINA must be set 1 (Enabled) Don't forget to execute this command after corrections(run as sql query SQL Management Studio)



Regards
THANK YOU
prometeus is offline  
Old 10/28/2011, 18:04   #2250

 
elite*gold: 133
Join Date: Jan 2010
Posts: 33
Received Thanks: 4
Quote:
Originally Posted by sladlejrhfpq View Post
lol, you used wrong patch as i see, this one is for 2 or 3 pc, you need only one, download the Patch 1, and make sure it is for only one pc, because if you want to start the services, and only one gameserver running for example, you will get error at smc

try but i hope you can help me ^^ the shardmanager is closing after frew seconds when i'm start the shardmanager >_>

look @ pic i hope you know it ^^
[URL=http://imageshack.us/photo/my-images/705/screenshot2011102300061.jpg/]
or this error

[URL=http://imageshack.us/photo/my-images/831/screenshot2011102300521.jpg/]
obstjunky is offline  
Closed Thread

Tags
download, files, guide, silkroad, vsro




All times are GMT +1. The time now is 19:20.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.