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

05/29/2018 22:51 MeDoSam#1
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:
[Only registered and activated users can see links. Click Here To Register...]

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):[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

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:1902196833@192.168.1.20/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
05/30/2018 00:14 blapanda#2
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.
05/30/2018 01:11 B1Q#3
[Only registered and activated users can see links. Click Here To Register...]
use this
05/30/2018 03:05 ScarOnline#4
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
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

also check this url (your ip:port/test.asp) ([Only registered and activated users can see links. Click Here To Register...])
it respond something like this
[Only registered and activated users can see links. Click Here To Register...]
otherwise you haven't configure the IIS correctly
about FileZilla, SRO_CREST these for Guild Emblem
05/31/2018 07:25 1vuonchuoi9#5
Inbox fb.com/gschanbo
05/31/2018 23:42 MeDoSam#6
Quote:
Originally Posted by blapanda View Post
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 View Post
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
[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

also check this url (your ip:port/test.asp) ([Only registered and activated users can see links. Click Here To Register...])
it respond something like this
[Only registered and activated users can see links. Click Here To Register...]
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

%>


[Only registered and activated users can see links. Click Here To Register...]
06/01/2018 02:52 ScarOnline#7
Quote:
Originally Posted by MeDoSam View Post
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>
[Only registered and activated users can see links. Click Here To Register...]

then request it in your browser
[Only registered and activated users can see links. Click Here To Register...]
it respond something like the following image
[Only registered and activated users can see links. Click Here To Register...]
06/01/2018 03:28 loader8#8
i think the problem is with FileZilla account check your Filezilla Account and check your server.cgf
BILLING_SERVER_URL ""
CREST_FTP_URL "ftp://"
06/01/2018 20:10 MeDoSam#9
Quote:
Originally Posted by ScarOnline View Post
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>
[Only registered and activated users can see links. Click Here To Register...]

then request it in your browser
[Only registered and activated users can see links. Click Here To Register...]
it respond something like the following image
[Only registered and activated users can see links. Click Here To Register...]

File test.asp exists

Quote:
Originally Posted by loader8 View Post
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:192.168.1.20@192.168.1.20/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 

06/01/2018 20:49 ScarOnline#10
Quote:
Originally Posted by MeDoSam View Post
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
[Only registered and activated users can see links. Click Here To Register...]
then tell me if it work or not !

for more information about setting up filezilla, you can follow this guide
[Only registered and activated users can see links. Click Here To Register...]

filezilla settings in server.cfg should be like this
ftp://id:password@yourip/
02/15/2019 17:50 محمد منتصر#11
Same Here
02/15/2019 20:28 Dracula Untold#12
pm me on skype i will help u
11/19/2021 10:18 franviapro#13
because when I enter my server the server disconnects me. Please... help me
11/19/2021 11:50 Judgelemental#14
Quote:
Originally Posted by franviapro View Post
because when I enter my server the server disconnects me. Please... help me
Try this : [Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]
11/19/2021 12:13 franviapro#15
Quote:
Originally Posted by Judgelemental View Post
Try this : [Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]
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?