help in vsro files globalserver cannot connect to db

09/24/2011 23:29 xman2887#1
help in vsro files globalserver cannot connect to db

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 "5.207.21.28"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 
"5.207.21.28"15880
        IBUVQueueReserveCount        20000
        IBUVQueuePrepareRatio        0.10
        IBUVFailureIPTolerance        0
        IBUVStringSize                1
        IBUVCharacterSet            
"ABCDEF1234567890"
}

DownloadServer {
        
Certification "5.207.21.28"15880
}
FarmManager {
        
Certification "5.207.21.28"15880
}

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

MachineManager {
        
Certification "5.207.21.28"15880
        CERTIFICATION_IP_BIND 
"5.207.21.28"
}

SR_GameServer {
        
Certification "5.207.21.28"15882
        SockTCPCount                                     
"5000"
        
ExpRatio                                         "95000"
        
ExpRatioParty                                     "35000" 
        
DropItemRatio                                     "5000"
        
DropGoldAmountCoef                                 "55000"
        
HwanGainFactor                                     "500"
        
ShowFormulaDetail                                 "9"
    
            
//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 "5.207.21.28"15882
        BILLING_SERVER_URL                 
"http://5.207.21.28:80/"
        
CREST_FTP_URL                     "ftp://crest:crest@127.0.0.1/"
        
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
PHP Code:
[global]
count=1
[entry0]
operation_type=22
name
=SRO_Vietnam_TestLocal
query
=DRIVER={SQL Server};SERVER=VSRO-PC\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=1234;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id
=697 
srShard
PHP Code:
[global]
count=1
[entry0]
id=64
global_operation_id
=20
operation_type
=22
name
=SroLand
query
=DRIVER={SQL Server};SERVER=VSRO-PC\SQLEXPRESS;DSN=Silkroad_Shard;UID=sa;PWD=1234;DATABASE=SRO_VT_SHARD
query_log
=DRIVER={SQL Server};SERVER=VSRO-PC\SQLEXPRESS;DSN=Account_DB;UID=sa;PWD=1234;DATABASE=SRO_VT_LOG
capacity
=300
shard_manager_node_id
=705
u1
=240
u2
=208
u3
=17
u4
=1
u5
=0
u6
=0
u7
=
any one help please
09/30/2011 18:28 bartus117#2
i got this problem too ;/
09/30/2011 20:41 Raptursh#3
i got it too ='(
10/20/2011 21:13 ch00b#4
[global]
count=1
[entry0]
operation_type=22
name=SRO_Vietnam_TestLocal
query=DRIVER={SQL Server};SERVER=VSRO-PCSQLEXPRESS;DSN=SRO_VT_ACCOUNT;DATABASE=SRO_VT_AC COUNT
global_manager_node_id=697

try this way
10/21/2011 00:05 sbhtkvnkl34#5
Srshard
PHP Code:
[global]
count=1
[entry0]
id=64
global_operation_id
=20
operation_type
=22
name
=SroLand
query
=DRIVER={SQL Server};SERVER=\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=Your pass;DATABASE=SRO_VT_SHARD_INIT
query_log
=DRIVER={SQL Server};SERVER=\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=Your pass;DATABASE=Log_DB
capacity
=20
shard_manager_node_id
=705
u1
=240
u2
=208
u3
=17
u4
=1
u5
=0
u6
=0
u7
=
server.cfg
***if still dont work change the port from 8080 to 80***
i set your ip here so try it out

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 "5.207.21.28"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 
"5.207.21.28"15880
        IBUVQueueReserveCount        20000
        IBUVQueuePrepareRatio        0.10
        IBUVFailureIPTolerance        0
        IBUVStringSize                1
        IBUVCharacterSet            
"ABCDEF1234567890"
}

DownloadServer {
        
Certification "5.207.21.28"15880
}
FarmManager {
        
Certification "5.207.21.28"15880
}

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

MachineManager {
        
Certification "5.207.21.28"15880
        CERTIFICATION_IP_BIND 
"5.207.21.28"
}

SR_GameServer {
        
Certification "5.207.21.28"15882
        SockTCPCount                                     
"500"
        
ExpRatio                                         "350"
        
ExpRatioParty                                     "350" 
        
DropItemRatio                                     "500"
        
DropGoldAmountCoef                                 "150"
        
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 "5.207.21.28"15882
        BILLING_SERVER_URL                 
"http://5.207.21.28:8080/"
        
CREST_FTP_URL                     "ftp://crest:FTP PASS@5.207.21.28/SRO_CREST/"
        
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

10/21/2011 17:37 alexutublade#6
Guys , "DNS" it's the ODBC name you set when you created the ODBC settings , did you created them?