{Guide/Release} SQL Server configuration For vsro files & Patches options

Dr.Abdelfattah · 09/30/2011, 20:50

Quote:

Originally Posted by menapato

i when open global manager

how to fix all errors and i need to how setub OBCD
thx

lool are u need to open global manager then sr gameserver ?!!!!!
and give me ur ini folder + server.cfg to solve ur global manager error

cardoso125874 · 09/30/2011, 21:41

i this using 2 dedicate server with patch 3.1 but mobs not fix spawn and pet bug.. with 2 pc not can open forgot world?

octage · 10/02/2011, 19:59

How can I dezactivate that 100% green buff, who goes to 50% red and than to 0% grey, and playing becomes impossible (no exp,sp,gold,items

).... OR better, tell me where can I find this Code:

//HourForMeterRateLevelFirst 24
//HourForMeterRateLevelSecond 0

so I can change it to this Code:

HourForMeterRateLevelFirst 22
HourForMeterRateLevelSecond 23

from what i've heard this will make the 100% green buff 24/7

....

I'm w8ing for an answer ty.

Dr.Abdelfattah · 10/02/2011, 20:45

Quote:

Originally Posted by cardoso125874

i this using 2 dedicate server with patch 3.1 but mobs not fix spawn and pet bug.. with 2 pc not can open forgot world?

check ur regoins that u made some like roc and jangan and west chin and dw on first sr gameserber
and erup and alex and etc on 2nd gameserver

Quote:

Originally Posted by octage

How can I dezactivate that 100% green buff, who goes to 50% red and than to 0% grey, and playing becomes impossible (no exp,sp,gold,items ).... OR better, tell me where can I find this Code:

//HourForMeterRateLevelFirst 24
//HourForMeterRateLevelSecond 0

so I can change it to this Code:

HourForMeterRateLevelFirst 22
HourForMeterRateLevelSecond 23

from what i've heard this will make the 100% green buff 24/7 ....

I'm w8ing for an answer ty.

PHP Code:


			
SR_ShardManager {
        Certification "ip", 15882
        BILLING_SERVER_URL                 "http://ip:port/"
        CREST_FTP_URL                     "ftp://user:passs@ip:port/SRO_CREST"
        ChristmasEvent2007                 0
        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
}

in server.cfg

6_lucifer_6 · 10/03/2011, 02:58

i keep getting this fcking error

can some one help?

Dr.Abdelfattah · 10/03/2011, 04:19

Quote:

Originally Posted by 6_lucifer_6

i keep getting this fcking error

can some one help?

wrong db info

6_lucifer_6 · 10/03/2011, 04:26

i figure that out.. but idk how to fix it

can u tall me wat 2 do?..

OMG help me!!!!!!

ColdIsTheVoid · 10/03/2011, 20:33

Quote:

Originally Posted by 6_lucifer_6

i figure that out.. but idk how to fix it

can u tall me wat 2 do?..

OMG help me!!!!!!

check the info you wrote (sql server, user and pw) at the srShard.ini and srGlobalService.ini correct the mistake, compile again, and try

jacksondl15 · 10/04/2011, 16:07

Hey all,1 month I'm trying, my server is check, closed..
My configss

i've download patch 1 and patch 2

SrShard.ini

PHP Code:


			
[global]

count=1

[entry0]

id=64

global_operation_id=20

operation_type=22

name=Test

query=DRIVER={SQL Server};SERVER=PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD

query_log=DRIVER={SQL Server};SERVER=PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARDLOG

capacity=300

shard_manager_node_id=705

u1=240

u2=208

u3=17

u4=1

u5=0

u6=0

u7=0

SrNodeType

PHP Code:


			
[global]

count=1

[entry0]

id=335

operation_type=22

name=SRO Vietnam TestLocal

wip=192.168.1.64

nip=192.168.1.64

machine_manager_node_id=699

GlobalService

PHP Code:


			
[global]

count=1

[entry0]

operation_type=22

name=SRO_Vietnam_TestLocal

query=DRIVER={SQL Server};SERVER=PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=123456;DATABASE=SRO_VT_ACCOUNT

global_manager_node_id=697

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 "192.168.1.64", 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 "192.168.1.64", 15880

        IBUVQueueReserveCount        20000

        IBUVQueuePrepareRatio        0.10

        IBUVFailureIPTolerance        0

        IBUVStringSize                1

        IBUVCharacterSet            "ABCDEF1234567890"

}



DownloadServer {

        Certification "192.168.1.64", 15880

}

FarmManager {

        Certification "192.168.1.64", 15880

}



AgentServer {

        Certification "192.168.1.64", 15882 //no global manager running lol

            //traffic_filter_activity     "service_off"

            //MaxUser 5000

            //SockTCPCount 15000

        MaxConnectionsPerServer         "5000"

        MaxConnectionsPer1_OServer         "5000"

}



MachineManager {

        Certification "192.168.1.64", 15880

        CERTIFICATION_IP_BIND "192.168.1.64"

}



SR_GameServer {

        Certification "192.168.1.64", 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 "192.168.1.64", 15882

        BILLING_SERVER_URL                 "http://192.168.1.64:21/"

        CREST_FTP_URL                     "ftp://sa:[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

}

SQL2005 CONFIGS :
Priviledip

GameBand

Shard Service

SMC :
Start all service

AllServers offline

Abdominal Condition

Processe Blind

SERVER STATS

I NEED HELP, I FOLLOW ALL TUTORIALS AND NOTHING..

WHAT'S WRONG WITH MY CONFIGS??

Dr.Abdelfattah · 10/04/2011, 21:55

Quote:

Originally Posted by jacksondl15

Hey all,1 month I'm trying, my server is check, closed..
My configss

i've download patch 1 and patch 2

SrShard.ini

PHP Code:

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

SrNodeType

PHP Code:

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

GlobalService

PHP Code:

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

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 "192.168.1.64", 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 "192.168.1.64", 15880 IBUVQueueReserveCount 20000 IBUVQueuePrepareRatio 0.10 IBUVFailureIPTolerance 0 IBUVStringSize 1 IBUVCharacterSet "ABCDEF1234567890" } DownloadServer { Certification "192.168.1.64", 15880 } FarmManager { Certification "192.168.1.64", 15880 } AgentServer { Certification "192.168.1.64", 15882 //no global manager running lol //traffic_filter_activity "service_off" //MaxUser 5000 //SockTCPCount 15000 MaxConnectionsPerServer "5000" MaxConnectionsPer1_OServer "5000" } MachineManager { Certification "192.168.1.64", 15880 CERTIFICATION_IP_BIND "192.168.1.64" } SR_GameServer { Certification "192.168.1.64", 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 "192.168.1.64", 15882 BILLING_SERVER_URL "http://192.168.1.64:21/" CREST_FTP_URL "ftp://sa:[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 }

SQL2005 CONFIGS :
Priviledip

GameBand

Shard Service

SMC :
Start all service

AllServers offline

Abdominal Condition

Processe Blind

SERVER STATS

I NEED HELP, I FOLLOW ALL TUTORIALS AND NOTHING..

WHAT'S WRONG WITH MY CONFIGS??

i answer u in private

buriko_0007 · 10/05/2011, 14:40

Quote:

Originally Posted by ferdi61tr

Second machine shardmanager successfully certificated but it loading too slowly (about 30min)

And this error on second machine gameserver:

Connected to ShardManager [#705]
Disconnected from ShardManager, all user connections will be lost (but, data saved)!!! [#705]
server cord closed : 2

It repeat this error.

Same error.

psro123 · 10/05/2011, 21:57

why i get error S1030 when i try to make character i got everythings working before and i checked my database and server.cfg and cert there's no wrong could anyone help me plz

ColdIsTheVoid · 10/06/2011, 23:34

THANK YOU DR.ABDELFATTAH

r4full · 10/07/2011, 03:07

I have 2 problems , cant make Reg Page , and when i start the server and connect with TESTACC i get dc after 10 sec why?

lory75 · 10/07/2011, 18:23

Ok... it's like hours and hours that i'm trying to Fix DB Connection Failed! on 2nd machine...it's impossible...i've done all possible (disabled firewall on main machine, sql remote connection..(also i don't know why i can't connect to my sql server from another pc..) however pls help me :'( xD

DR.ABDELFATTAH can you enter in my TW? Pls