[HELP]Billing Server is Dead/ShardManager ERROR plz Help me

[MeDoSam]

Hey guys,

after so much wasted time I give up and ask the experts here, I hope you can help me. Please read the full thread before you post something like "you must check your IIS etc.".

################################################## ###############

My problem is the SR_ShardManager application. Everytime when I try to start it, it closes fast as hell and give me the information: "Billing Server is dead", check the image below:


I am starting the applications in this order:1. Cert [WORKS FINE]
2. Glob
3. Machine Manager [WORKS FINE]
4. Download Manager [WORKS FINE]
5. Gateway Manager [WORKS FINE]
6. Farm Manager [WORKS FINE]
7. Agent Server xtrap [WORKS FINE]
8. SR_Shard Manager [SUCK]
9. etc....
10. etc.....[/quote]

I have edittet the IIS settings like this (correct):


My server.cfg :

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
}

netengine_debug_option_debugger_present {
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX
}

netengine_debug_option_stand_alone {
DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX
}

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
Certification "192.168.1.20", 36000
LoginFailureTolerance 10
IBUVFailureTolerance 10
LoginFailureBlockTimeMin 10
IBUVFailureBlockTimeMin 10
AutomatedPunisher "AutomatedPunisher"
LoginPunishmentGuide "Blocked for 5 minutes due to incorrect password entered 10 times"
LoginPunishmentDescription "Blocked for 5 minutes due to incorrect password entered 10 times"
IBUVPunishmentGuide "Blocked for 5 minutes due to incorrect code entered 10 times"
IBUVPunishmentDescription "Blocked for 5 minutes due to incorrect code entered 10 times"
NetCafeIPRefreshTime 200
MaxUserForNonePCBangIP 1000
}


GatewayServer {
LastFullVersion_SR_Client 190
Certification "192.168.1.20", 25001
IBUVQueueReserveCount 20000
IBUVQueuePrepareRatio 0
IBUVFailureIPTolerance 5
IBUVStringSize 1
IBUVCharacterSet "0"
}
DownloadServer {
Certification "192.168.1.20", 25001
}
FarmManager {
Certification "192.168.1.20", 25001
}

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

MachineManager {
Certification "192.168.1.20", 25001
}

SR_GameServer {
Certification "192.168.1.20", 25003
SockTCPCount "500"
ExpRatio "70000"
ExpRatioParty "75000"
DropItemRatio "25000"
DropGoldAmountCoef "3000"
HwanGainFactor "500"
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"
//#enOPEN_MARKET_SYSTEM
//RE FTW

DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "ON"
ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "ON"


}

SR_ShardManager {
Certification "192.168.1.20", 25003
BILLING_SERVER_URL "http://192.168.1.20:8080/"
CREST_FTP_URL "ftp://sa:[email protected]/SRO_CREST/"
ChristmasEvent2007 0
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
}

My srGlobalService.ini :

[global]
count=1
[entry0]
id=20
operation_type=22
name=SRO_Vietnam_TestLocal [F] 0
query=

My srShard.ini :

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

Some question about things which I haven´t understand:

- For what do I need FileZilla and the folder "SRO_CREST" which is empty?
- Should it run permanently? Because keep it close.


I hope somebody can help me

[blapanda]

Are you sure that the database files are also equally named? Even inside the stored procedures?

Other than that, you might have not checked the .asp files.

[B1Q]

use this

[ScarOnline]

check DBConnect.asp at C:\inetpub\wwwroot
it should be like that

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=PCNAME\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=YOURPASSWORD;"
DBConnA.Open strConnectA
%>

recheck IIS features it should be like that



also check this url (your ip:port/test.asp) ()
it respond something like this

otherwise you haven't configure the IIS correctly
about FileZilla, SRO_CREST these for Guild Emblem

[1vuonchuoi9]

Inbox fb.com/gschanbo

[MeDoSam]

Originally Posted by blapanda

Are you sure that the database files are also equally named? Even inside the stored procedures?

Other than that, you might have not checked the .asp files.

yas Database data is sound

Originally Posted by ScarOnline

check DBConnect.asp at C:\inetpub\wwwroot
it should be like that

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=PCNAME\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=YOURPASSWORD;"
DBConnA.Open strConnectA
%>

recheck IIS features it should be like that



also check this url (your iport/test.asp) ()
it respond something like this

otherwise you haven't configure the IIS correctly
about FileZilla, SRO_CREST these for Guild Emblem

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=SQLOLEDB;Data Source=MEDO\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=1902196833;"
DBConnA.Open strConnectA

%>

[ScarOnline]

Originally Posted by MeDoSam

yas Database data is sound

make sure the test.asp file is exist in the following location C:\inetpub\wwwroot , if it doesn't exist you've to create it in the same location

<%@ language="vbscript"%>
<html><body>The current server time is: 
<%
response.write(Date & " " & Time)
%>
</body></html>

then request it in your browser

it respond something like the following image

[loader8]

i think the problem is with FileZilla account check your Filezilla Account and check your server.cgf
BILLING_SERVER_URL ""
CREST_FTP_URL "ftp://"

[MeDoSam]

Originally Posted by ScarOnline

make sure the test.asp file is exist in the following location C:\inetpub\wwwroot , if it doesn't exist you've to create it in the same location

<%@ language="vbscript"%>
<html><body>The current server time is: 
<%
response.write(Date & " " & Time)
%>
</body></html>

then request it in your browser

it respond something like the following image

File test.asp exists

Originally Posted by loader8

i think the problem is with FileZilla account check your Filezilla Account and check your server.cgf
BILLING_SERVER_URL ""
CREST_FTP_URL "ftp://"

Can i know how to check out acount FileZilla

fill Server.cgf

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 
    }

    netengine_debug_option_debugger_present    {
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX 
    }

    netengine_debug_option_stand_alone    {
            DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX 
    }

}

////////////////////////////////////////////////////////////////////////////////////////////
GlobalManager {
        Certification "192.168.1.20", 36000 
        LoginFailureTolerance        10
        IBUVFailureTolerance        10
        LoginFailureBlockTimeMin    10
        IBUVFailureBlockTimeMin        10
        AutomatedPunisher            "AutomatedPunisher"
        LoginPunishmentGuide        "Blocked for 5 minutes due to incorrect password entered 10 times"
        LoginPunishmentDescription    "Blocked for 5 minutes due to incorrect password entered 10 times"
        IBUVPunishmentGuide            "Blocked for 5 minutes due to incorrect code entered 10 times"
        IBUVPunishmentDescription    "Blocked for 5 minutes due to incorrect code entered 10 times"
        NetCafeIPRefreshTime 20
        MaxUserForNonePCBangIP 10
}


GatewayServer {
        LastFullVersion_SR_Client     190
        Certification "192.168.1.20", 25001
        IBUVQueueReserveCount        20000
        IBUVQueuePrepareRatio        0
        IBUVFailureIPTolerance        5
        IBUVStringSize                0
        IBUVCharacterSet            "0"
}
DownloadServer {
        Certification "192.168.1.20", 25001
}
FarmManager {
    Certification "192.168.1.20", 25001
}

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

MachineManager {
    Certification "192.168.1.20", 25001
}

SR_GameServer { 
        Certification "192.168.1.20", 25003 
        SockTCPCount                                       "500" 
        ExpRatio                                           "70000" 
        ExpRatioParty                                      "75000"  
        DropItemRatio                                      "25000" 
        DropGoldAmountCoef                                 "3000" 
        HwanGainFactor                                     "500" 
        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" 
            //#enOPEN_MARKET_SYSTEM 
            //RE FTW 

        DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL     "ON" 
        ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED         "ON" 


} 

SR_ShardManager { 
        Certification "192.168.1.20", 25003 
        BILLING_SERVER_URL                 "http://192.168.1.20:8080/" 
        CREST_FTP_URL                     "ftp://sa:[email protected]/SRO_CREST/"
        ChristmasEvent2007                 0 
        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 
} 


[ScarOnline]

Originally Posted by MeDoSam

File test.asp exists
Can i know how to check out acount FileZilla

Filezilla is unimportant even if its data are correct or not, SR_ShardManager should work.
your problem is in IIS, so you should request the below url

then tell me if it work or not !

for more information about setting up filezilla, you can follow this guide


filezilla settings in server.cfg should be like this
ftp://id:password@yourip/

[محمد منتصر]

Same Here

[Dracula Untold]

pm me on skype i will help u

[franviapro]

because when I enter my server the server disconnects me. Please... help me

[Judgelemental]

Originally Posted by franviapro

because when I enter my server the server disconnects me. Please... help me

Try this :

Here's the file in case the link is down:

[franviapro]

Originally Posted by Judgelemental

Try this :

Here's the file in case the link is down:

I try to play on my pc by myself :-). what you tell me I have already done. even so it always disconnects me. I like the work you teach but how can I get it? link?