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

MeDoSam · 05/29/2018, 22:51

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 :

Quote:

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 :

Quote:

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

My srShard.ini :

Quote:

[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 · 05/30/2018, 00:14

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 · 05/30/2018, 01:11

use this

ScarOnline · 05/30/2018, 03:05

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

Code:

<%
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 · 05/31/2018, 07:25

Inbox fb.com/gschanbo

MeDoSam · 05/31/2018, 23:42

Quote:

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

Quote:
Originally Posted by ScarOnline
check DBConnect.asp at C:\inetpub\wwwroot
it should be like that
Code:
<%
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 · 06/01/2018, 02:52

Quote:

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

Code:

<%@ 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 · 06/01/2018, 03:28

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 · 06/01/2018, 20:10

Quote:
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
Code:
<%@ 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

Quote:

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 · 06/01/2018, 20:49

Quote:

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/

محمد منتصر · 02/15/2019, 17:50

Same Here

Dracula Untold · 02/15/2019, 20:28

pm me on skype i will help u

franviapro · 11/19/2021, 10:18

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

Judgelemental · 11/19/2021, 11:50

Quote:

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 · 11/19/2021, 12:13

Quote:

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?