Problem with SR_GameServer & SR_ShardManager

[jeiceei]

SOLVED




Hello, I've created a server with vsro 1.188 client and files.
So everything is setup, database, aspx files etc. and I've triple checked every single of connection strings. My cert files are okay too but on startup, sr_gameserver and sr_shardmanager does not connect to DB. Eveything except these 2 fucks working just fine, I've checked FTP and Billing files too nothing is wrong with them. Please take a look to the attachments. And do I need to extract media.pk2 and map.pk2 then put extracted shit into a folder inside server folder? I did it for data.pk2 into Data folder within server folder.

My server.cfg

 Spoiler

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

DownloadServer {
        Certification "XX.XX.XX.XX", 15880
}
FarmManager {
        Certification "XX.XX.XX.XX", 15880
}

AgentServer {
        Certification "XX.XX.XX.XX", 15882 //no global manager running lol
            //traffic_filter_activity     "service_of"
            //MaxUser 5000
            //SockTCPCount 15000
        MaxConnectionsPerServer         "5000"
        MaxConnectionsPer1_OServer         "5000"
}

MachineManager {
        Certification "XX.XX.XX.XX", 15880
        CERTIFICATION_IP_BIND "XX.XX.XX.XX"
}

SR_GameServer {
        Certification "XX.XX.XX.XX", 15882
        SockTCPCount                                     "5000"
        ExpRatio                                         "35000"
        ExpRatioParty                                     "35000" 
        DropItemRatio                                     "5000"
        DropGoldAmountCoef                                 "5000"
        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 "XX.XX.XX.XX", 15882
        BILLING_SERVER_URL                 "http://XX.XX.XX.XX:8080/"
        CREST_FTP_URL                     "ftp://ftpuser:.XX.XX:14741"
        ExtraExpRatio                    1000
        ChristmasEvent2007                 1
        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
} 


srShard.ini

 Spoiler

PHP Code:

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


DBConnect.asp

 Spoiler

PHP Code:

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

%> 


What could be the problem ?

[mtnman33]

well judging by the limited info there is 2 possibilities the first and most likely id that you do not have the billing server files put in the location of you iss web server for connection purposes due to the fact that it is not showing up as billing server dead .
#2 , you do not have ODBC setup for web access to the database which will also cause that error . thats about the only 2 things that can cause that problem. hope this helps

[jeiceei]

Originally Posted by mtnman33

well judging by the limited info there is 2 possibilities the first and most likely id that you do not have the billing server files put in the location of you iss web server for connection purposes due to the fact that it is not showing up as billing server dead .
#2 , you do not have ODBC setup for web access to the database which will also cause that error . thats about the only 2 things that can cause that problem. hope this helps

I solved this with new Cert files.

[blapanda]

Originally Posted by jeiceei

I solved this with new Cert files.

And yet you have no clue what you've done right or wrong. Just copy and paste bolognese.
Have you even compared those certification configurations with each other, to actually learn what you or someone else did wrong on the first place?

Always make a protocol, such things can and prolly will happen at least once again.

[jeiceei]

Originally Posted by blapanda

And yet you have no clue what you've done right or wrong. Just copy and paste bolognese.
Have you even compared those certification configurations with each other, to actually learn what you or someone else did wrong on the first place?

Always make a protocol, such things can and prolly will happen at least once again.

actually they are the same, it could be the packt.dat corrupt

[blapanda]

Originally Posted by jeiceei

actually they are the same, it could be the packt.dat corrupt

And you know how to rebuild the packt.dat file, don't you?
You should have a compiler there (in form of a .bat(ch) file), usually.

[jeiceei]

Originally Posted by blapanda

And you know how to rebuild the packt.dat file, don't you?
You should have a compiler there (in form of a .bat(ch) file), usually.

I know mate, chill.

[blapanda]

Originally Posted by jeiceei

"chill"

lol, yea right, have fun "developer".

[jeiceei]

Originally Posted by blapanda

Oh wait, lemme do the same ****:



vvv




So, first of all, what is your problem, deutscher fanatiker?
Getting over here just for messing around? Keep your stuff to yourself. No need in annoying others with nonsense.
And I haven't insulted anyone here. Or did you EVER read anything about "**** you, you idiot" or anything similiar to that of my humble self calling that to others? Which is quite common on this so called "community". No, you haven't. Nor have I claimed being "kralest editor/developer/programmer"
Keep the facts straight.

"Having issues", saying the right people asking for help and reclaiming "I've solved it already with new cert", while "knowing" that the packt file needs to be recompiled? But yea, you have new cert files. Pro. Just pro brah.

Will be funny if any of you amateurs going to open a server and keep claiming that you are one of the bests showing up on this scene. Morons.

You really have some SERIOUS issues.

[blapanda]

Originally Posted by jeiceei

You really have some SERIOUS issues.

Dude, seriously, go and get something else to do than repeating yourself stupidly.

[jeiceei]

Originally Posted by blapanda

Dude, seriously, go and get something else to do than repeating yourself stupidly.

Now I am the one who repeats himself right. Okay KRALL

[tschulian]

Originally Posted by blapanda

Oh wait, lemme do the same shit:



vvv




So, first of all, what is your problem, deutscher fanatiker?
Getting over here just for messing around? Keep your stuff to yourself. No need in annoying others with nonsense.
And I haven't insulted anyone here. Or did you EVER read anything about "fuck you, you idiot" or anything similiar to that of my humble self calling that to others? Which is quite common on this so called "community". No, you haven't. Nor have I claimed being "kralest editor/developer/programmer"
Keep the facts straight.

"Having issues", saying the right people asking for help and reclaiming "I've solved it already with new cert", while "knowing" that the packt file needs to be recompiled? But yea, you have new cert files. Pro. Just pro brah.

Will be funny if any of you amateurs going to open a server and keep claiming that you are one of the bests showing up on this scene. Morons.

At least we are not praying N spraying.

Originally Posted by blapanda

Dude, seriously, go and get something else to do than repeating yourself stupidly.

oké fyll kral

[blapanda]

Originally Posted by tschulian

At least we are not praying N spraying.
oké fyll kral

Do you even comprehend and listen to that what you are actually writing?

[tschulian]

Originally Posted by blapanda

Do you even comprehend and listen to that what you are actually writing?

Menz 10k plaz oke?
#ihopethisisnotdeclaredasspamtho.


The Problem of the Thread Creator has been solved.
This Thread should be closed so the hate will come to an end.

[blapanda]

Originally Posted by tschulian

Menz 10k plaz oke?
#ihopethisisnotdeclaredasspamtho.


The Problem of the Thread Creator has been solved.
This Thread should be closed so the hate will come to an end.

Finally, you are showing some brains. And I thought, you cannot get even more retarded.