[Guide] Most of vsro files problem solved here

[bibi_fr]

Originally Posted by bibi_fr

Hello,

First Thanx for your works and time spend for us !

Im getting a certification error !

After try a lots of time and read the post i post for getting help

Ip Set at mine
port set a your
DB Set and checked a lot of time

Certification succeful but always a same prob

Check pics



Thanx for help

After a mp help i checked my Window Firewall and he's disable
After that i don't have any firewall on this pc !

Need a little help xD

[Dr.Abdelfattah]

Originally Posted by bibi_fr

After a mp help i checked my Window Firewall and he's disable
After that i don't have any firewall on this pc !

Need a little help xD

GlobalManager port 32001 not 32000 ..
change it and it will works fine

[cardoso125874]

where i creat account for login?

[formatme]

can some 1 tell me how to edit the ip from ******?

[akira_lee]

....sever online but when login get C8...

[6_lucifer_6]

i get this when i open cert..

[Dr.Abdelfattah]

Originally Posted by akira_lee

....sever online but when login get C8...

Quote:
Originally Posted by Dumfiesta
Got my server working. Here's a few tips:

• Change operation_type in your cert files to 22, or your client will crash
• Also, change the shard id from 64 to 99 in srShard.ini and srNodeData.ini
• To log on as a GM, you need to add your client IP (as an integer, LE) to _PrivilegedIP
• Remember to fix the IPs and connection string in your billing scripts, or you'll get DC'd

This is all assuming you've got your servers to initialize properly.
-----------------------------------------------------------------------------------------
maybe help and don't forget to open sro from other machine (not machine u host vsro on it) ...

Originally Posted by 6_lucifer_6

i get this when i open cert..

check ur IP u enter in ini configs

Originally Posted by 6_lucifer_6

i get this when i open cert..

check ur IP u enter in ini configs

[Ninja1337]

That's what i got when i run everything Sr_gameworld and SR_manager are not working

[bibi_fr]

Originally Posted by abdelfattah

GlobalManager port 32001 not 32000 ..
change it and it will works fine

Port is already on 32001 lol

You see only the gatewayserver port xD

Server.cgf

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.10", 32001
	Certification "192.168.1.10", 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.10", 32000
	IBUVQueueReserveCount		20000	// IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö	
	IBUVQueuePrepareRatio		0.05	// ¾ÆÀ̵é ŸÀÓ¿¡ À̹ÌÁö »ý¼ºÇÒ ºñÀ²
	IBUVFailureIPTolerance		0	// ÇÑ IP´ç IBUV ½ÇÆи¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇÏ°Ú´Ù´Â °ÅÁö.

	// Ãß°¡µÈ ³ÑÀÌ´Ù!!!!!
	//////////////////////////////////////////////////////////
	IBUVStringSize			6 	// ÇÑ±Û Ä³¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆĺª ij¸¯ÅÍ ¼Â¸¸ »ç¿ëÇÏ´Â °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù.
	IBUVCharacterSet		"ABCDEFGHLMNQRTabdehimn2345678"
	//////////////////////////////////////////////////////////
}

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

AgentServer {
	Certification "192.168.1.10", 32004
}

MachineManager {
	Certification "192.168.1.10", 32000
}

SR_GameServer {
	Certification "192.168.1.10", 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 "192.168.1.10", 32004
	BILLING_SERVER_URL "http://192.168.1.10: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
}

srGlobalService.ini

[global]
count=1
[entry0]
operation_type=17
name=SRO_GameOn_Official
query=DRIVER={SQL Server};SERVER=FABIEN-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=697

srNodeType.ini

[global]
count=8
[entry0]
id=335
operation_type=17
name=GMGS
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=0
[entry1]
id=336
operation_type=17
name=DN1
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=701
[entry2]
id=338
operation_type=17
name=GWS1
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=699
[entry3]
id=339
operation_type=17
name=FMGS1
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=0
[entry4]
id=340
operation_type=17
name=SDMGS1
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=706
[entry5]
id=341
operation_type=17
name=SD1AGS1
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=708
[entry6]
id=344
operation_type=17
name=SD1GAS1
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=714
[entry7]
id=133
operation_type=0
name=Certification Manager
wip=192.168.1.10
nip=192.168.1.10
machine_manager_node_id=0

srShard.ini

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

[Dr.Abdelfattah]

Some Usefull things after setup ur server

Copied from not my write ..

Use this query to clean out old data from VT_ACCOUNT tables.

PHP Code:

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans] 


If you need to create your own GM account:

PHP Code:

1. You need a md5 hasher. (can google it)
2. Go to TB_Users table
3. Fill the form like this:

    JID: Fills automatically
    StrUserID: Username
    password: password
    status: can leave blank
    GMRank: Set this to 1 (Server Dev) 2 (content administrator) 3 (content user) 4 (content marketer) 5 (content monitor) 6 (Content GM) 7 (content GM Leader)
    sec_primary - set it to 1 (3 is normal user)
    sec_content - set it to 1 (3 is normal user)


4. You can fill in the other neccesary fields like email, adress so on, but they're not really neccesary. 


This will clean up Log database instantly.

PHP Code:

USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent] 


Use this to prune all old character data from shard.

PHP Code:

//..basically you need to delete these manually. 


[formatme]

im getting this error


what ip and port do i use for the client? 192.168.x.x or 127.0.0.1
and what port

[Tazdingo7]

Please help :

I have this error :


You know why ?

I do all the steps until this point when i try to open the CustomCertificationServer Batch File

Another question , what ports i need to open ?

Thanks

I like your efforts abdelfattah to help the community. Thanks to you too

[nansif2]

i just want know why in login screen my client crash... (before login)

[formatme]

Official IP Detected, Official IP Pass the 'In Service' Check
how do u get pass that? im using 127

[mokadidi]

i need help whit SR_ShardManager if some one want to help whit teamviewver