Setting up a server based on VSRO server files

So, since i got some free time, i can write this for everyone out there trying to get the server working without success for now. As you might already know, i've shared files i leaked from Vietnam Silkroad official servers to the community. So, here is what you will need for setting up a Silkroad server based on VSRO server files.

1. Windows XP/2003 Server/Windows 7/Windows 2008 Server/Windows 2008 Server r2 (one of those)
2. For handling 1000 players with all regions working, you will need 2 machines (you can run one as virtual)
3. One of the machines must have at least core i5 processor, and 6 - 8 GB of RAM, second might be slower a bit
4. Microsoft .NET framework 3.5+
5. Microsoft SQL Server 2000/2005/2008/2008 r2 (i will use 2k8 in this guide)
6. Microsoft SQL Server Management Studio (in 2000 it's integrated, for 2005 u need to download it, same as for 2008). SSMS 2005 wont work with mssql server 2008
7. A bit of knowledge how that stuff works

You can get MSSQL 2008 express edition from official Microsoft website (http://www.microsoft.com/sqlserver/e...s/express.aspx) same as SSMS

Well, since it's RageZone, i think, people got enough brain to set MSSQL server up.

Anyway, after installing mssql server, get those files i've also released

Server Files
{
Part 1 : http://www.multiupload.com/Z8X1DWXRQK
Part 2 : http://www.multiupload.com/X9NMM7K4NG
Part 3 : http://www.multiupload.com/PLM0JPYBCR

Files was released on EPVP originally, and password is "fortheworstcommunityever".
}

Database Dumps
{
http://www.mediafire.com/?oah3o9s2sc7gbtq
}

Changeset vsro obt v247-v249 (u wont need it, unless you are just interested in viewing it)
{
http://www.multiupload.com/SCTI13W09V
}

Xtrap update files
{
http://www.multiupload.com/DQ56P6SYNT
}

Billing ASP scripts
{
http://www.multiupload.com/36KNG9FI3Q
}

Custom certification server
{
http://www.multiupload.com/LS0SANRMYA (from pushedx aka Drew Benton)
http://www.mediafire.com/?859th9rwajcru9u (config files from LegendaryDev)
}

Latest SMC Build
{
http://www.multiupload.com/EFEYOIRUOZ
}





So, let's start. Save all that files in a some folder on your hard disk, and extract them.

After you are done with setting up a mssql server, and restoring databases (i consider, database names will be SRO_VT_ACCOUNT, SRO_VT_SHARD, SRO_VT_SHARDLOG), you have to
create 3 ODBC sources (you can name then however you want, but i preffer to call them the same way as databases). Specify "SQL Server" as ODBC driver. Default language must be
English for all databases.
Also, you have to set ODBC default database names this way :

SRO_VT_ACCOUNT -> SRO_VT_ACCOUNT
SRO_VT_SHARD -> SRO_VT_SHARD
SRO_VT_SHARDLOG -> SRO_VT_SHARDLOG

It's pretty simple and understandable, because i use the same database names as ODBC.

Don't forget to edit _ShardService table, and change Shard ID to 64 in SRO_VT_ACCOUNT database.

After you are done with ODBC, you must configure your custom certification server to work with your database server. Just run 1 - Decompile file in it's folder,
it will decompile current packt.dat file, and save .ini files at "ini" folder. Open it, and you will see few files, which you have to replace with those
which you downloaded in another archive (from LegendaryDev). After you are done, open your "srGlobalService.ini", and configure it to work with your database
server. Don't forget, by default, mssql 2005 and 2008 does not bind on port 1433, they uses ODBC. So, you shouldn't put ",1433" after your server hostname (which
should look like "PC_NAME\SQLEXPRESS", or just "PC_NAME". Do same for "srShard.ini" file (also, you can edit some shard configuration there, like capacity).
Do not make server capacity more than 1000 for now (i will tell why a bit later). Then you will have to change the ip addresses for binding certification server. For
this, open srNoteType.ini, and change "wip" to your WAN ip, and "nip" to your local ip. After you are done with your common certification configs, run "2 - Compile.bat" file in order
to make a new "packt.dat" file (new one will be named "new_packt.dat"). After you are done with it, start third batch file ("3 - CustomCertificationServer.bat")

Now, if the certification window starts, and shows a message, that says server successfully bound on port 32000 (or any other, if you modifyed it), you are ready to begin configuring
server.cfg in your main server files folder. If it doesent, you should be done something wrong (it should be IP in 99% of cases).

Well, if you suceeded, open your server.cfg file in the main server files folder, and change all "Certification" ip addresses to your one. Take a look at SR_ShardManager and SR_GameServer configuration.
As you can see, there is a billing url at shard settings, which you will have to set up by installing a IIS server, and creating a website instance on some unused port running. Files you should put on your IIS website
are in the beginning of post (billing asp scripts). Also, don't forget to enable asp support in your IIS server, otwertise, it will not work (will give IIS core error, and wont work propertly).
You have to edit DBConnect.asp file with your MSSQL server security information. Don't forget to edit your billing server url in your server.cfg (it should be like "http://silkroad.net:1337/").
After you are done, you might try to start your server. Here is the sequence in which you should do it (might be different, but this one will work for sure).

1 - Custom certification server
2 - GlobalManager
3 - MachineManager
4 - DownloadServer
5 - GatewayServer
6 - FarmManager
7 - AgentServer
8 - SR_ShardManager
9 - SR_GameServer

If you got everything running fine, you might try to start the service. For doing it, you have to download SMC (also check the top of this post), create a new server developer account, and log in using SMC.
For doing it, open your SSMSE, go to SRO_VT_ACCOUNT database, open TB_User table, and a new row with your account infos there (password is encrypted with usual md5 function). For giving account a rights
to access through SMC, you will have to change it's "sec_primary" to 1, same as "sec_content". Also, for connecting to SMC you will have to add your IP address to official ip ranges list.
For doing it, you have to edit _PrivilegedIP table in SRO_VT_ACCOUNT database (by default, it uses reverse integer "encryption", but you can modify it to use normal IP ranges. You can do it using this query :

Code:

---

USE [SRO_VT_ACCOUNT]
GO
/****** Object:  Table [dbo].[_PrivilegedIP]    Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop table _PrivilegedIP
GO
CREATE TABLE [dbo].[_PrivilegedIP](
        [IP1] [tinyint] NOT NULL,
        [IP2] [tinyint] NOT NULL,
        [IP3] [tinyint] NOT NULL,
        [IP4] [tinyint] NOT NULL,
        [IP5] [tinyint] NOT NULL,
        [IP6] [tinyint] NOT NULL,
        [IP7] [tinyint] NOT NULL,
        [IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO

---

After it's done, just add your ip range like this : if your ip is 127.0.0.1, for example, add each part of it in one column.

Code:

---

        127 0 0 1 127 0 0 5

---

This will add 4 ip addresses into allowable ip ranges (127.0.0.1 - 127.0.0.5).

After you are done, restart your GatewayServer, if it was running while you were doing it.

Now you will have to edit your client side (server division ip address is stored at Media.pk2), you have to edit it with XVI32, Hex Workshop, or some other hexadecimal editor.
Well, you can also use a software writen by other people, like "Media Patcher", etc.




Common problems are
{
- Wrong MSSQL server setup
- Wrong certification server configs
- Wrong database names
- Wrong ODBC setup
- Wrong IIS setup
- Wrong ip addresses/ports defined in server.cfg
}

Some info you should know
{
- One agent server supports only 1000 users
- You can't run 1 gameserver with ALL regions working (_RefRegionBindAssocServer table in SRO_VT_SHARD database; 0 = disabled, 1 = gs1, 2 = gs2, 3 = g3)
- You can run only 1 gameserver/any another module instance at a single physical/virtual machine
- I don't have any sources of server modules executables to provide, so, reversing is the way to go for fixing stuff
- For adding new gameserver/agentserver/any other instance nodes, you have to know some stuff about the way modules are being certificated/linked
- Certification server reads the first network adapter primary ip address
- Basic certification architecture : http://img195.imageshack.us/img195/6518/certx.png
- Tons more
}

I will update this guide through time, as much as i can. There is tons of things to tell that you should know, but i'm just too lazy at the moment, so, you will have to wait for updates.

Another thing, i wouldn't like to see this at epvpz.

Awesome guide thanks alot mate.

Well, it will grow... Since there is tons of things you should know...

No idea on the connecting issues eh?

Posted a guide : http://forum.ragezone.com/f723/guide...3/#post6542892

lol i know. I'm in it. It's not that.. i did it all fine. It has to do with something else im sure because I'm not the only one with the issue theres like 20 people i know so far with it. damnit! lol eh i'll figure it out eventually.

My head exploded with so much information - please stand by.
I hope someday I would sum this up and put my server on :S.

PS
Would it work with hamachi to make "private" server?

Chernobyl, can you tell me what cause this error
http://i52.tinypic.com/sy5teq.png
server is running, my local ip with 192.168.xx.xx
in media pk i patched with 127.0.0.1 port 15779

im using Legendarydev ini's and cert

if i make ip 192.168.x.x in media pk,launcher does not start

Quote:

---

Originally Posted by Nah001

Chernobyl, can you tell me what cause this error
http://i52.tinypic.com/sy5teq.png
server is running, my local ip with 198.168.xx.xx
in media pk i patched with 127.0.0.1 port 15579

im using Legendarydev ini's and cert

if i make ip 198.168.x.x in media pk,launcher does not start

---

same here. how to fix this.

Quote:

---

Originally Posted by s2k

same here. how to fix this.

---

It can't start with 198. Its either 10. or 192.

Gave you a Delta subscription for several years. Enjoy.

Thanks mate! I will try to help this community as muchs I can too!

Quote:

---

Originally Posted by Orusei

It can't start with 198. Its either 10. or 192.

---

doesn't work with 192. launcher only start with 127.0.0.1

Quote:

---

Originally Posted by s2k

doesn't work with 192. launcher only start with 127.0.0.1

---

Could try using windows hostlist to redirect localhost to your network ip.

MentaL, as far as i know, there is a IP in it, so, hosts isn't solution.

#offtop : sent PM

Heres the ODBC registry files for those who needs em: SRO_ODBC_REG.rar (made myself)

Guys i cant open DownloadServer "cannot certify server body : [DownloadServer]" Everything in configuration is fine..the DownloadServer open and close fastly..so i start to think maybe i have missing some software in my pc? help me =))

so i followed your guide but
got this error(after long time w8ing lol)

http://img17.imageshack.us/img17/5561/dfsafdsafadd.png
then got this
http://img849.imageshack.us/img849/1...sdhsdjfsdh.png

so what's the problem here?

Well, shard manager seems to be linked a bit incorrectly, it might also just have to wait... :)

Quote:

---

Originally Posted by stemale

Guys i cant open DownloadServer "cannot certify server body : [DownloadServer]" Everything in configuration is fine..the DownloadServer open and close fastly..so i start to think maybe i have missing some software in my pc? help me =))

---

You haven't configured your DownloadServer port properly mostlikely.

Quote:

---

Originally Posted by Chern0byl

Well, shard manager seems to be linked a bit incorrectly, it might also just have to wait... :)

---

that's normal? if i made everything right?

Thanks alot for guide !

Quote:

---

Originally Posted by Artuuro_lv

You haven't configured your DownloadServer port properly mostlikely.

---

Offtop check pm if you can help me ..thx=)

Quote:

---

Originally Posted by Orusei

It can't start with 198. Its either 10. or 192.

---

Use hamachi is much easy, that use your local IP.

All seems fine but...
http://i53.tinypic.com/2exx2rp.png
Where is error ?

cezaland how did you start machinemanager?

Quote:

---

Originally Posted by benike1

cezaland how did you start machinemanager?

---

MachineManager.exe -> Right Click -> Run :blink:

Quote:

---

Originally Posted by CEZALAND

MachineManager.exe -> Right Click -> Run :blink:

---

lol. what port? 32000?

Quote:

---

Originally Posted by benike1

lol. what port? 32000?

---

Code:

---

MachineManager {
        Certification "5.141.179.118", 15880
        CERTIFICATION_IP_BIND "5.141.179.118"
}

---

I am using Chernobyl's server.cfg :/:


look to here:
http://forum.ragezone.com/f722/compl...ml#post6541242

I know it is a stupid question, but I never used the Microsoft SQL Server 2008. Can you tell me how to set it up :)

Quote:

---

Originally Posted by polileusz

I know it is a stupid question, but I never used the Microsoft SQL Server 2008. Can you tell me how to set it up :)

---

A Question is never stupid, only a answer can be stupid :rolleyes:

someone can help me install or cracking the billing server i dont understand shardmgr say invalid url billingserver cant open site
BillingServer Died!
how to fix ?
here the config of billing
BILLING_SERVER_URL "http://192.168.1.150:80"

Quote:

---

Originally Posted by mage300

someone can help me install or cracking the billing server i dont understand shardmgr say invalid url billingserver cant open site
BillingServer Died!
how to fix ?
here the config of billing
BILLING_SERVER_URL "http://192.168.1.150:80"

---

install IIS server and Filezilla ftp server :huh:

Hi Cherno can you upload your DBConnect.asp, i get always the Error: Failed getting silk data: cant open url!
Silk Data loading failed.

Any Solution?

Quote:

---

Originally Posted by CEZALAND

A Question is never stupid, only a answer can be stupid :rolleyes:

---

Are you able to give me some tips or link to how to set it up please :): I will be very thankful

Quote:

---

Originally Posted by CEZALAND

Code:

---

MachineManager {
        Certification "5.141.179.118", 15880
        CERTIFICATION_IP_BIND "5.141.179.118"
}

---

I am using Chernobyl's server.cfg :/:


look to here:
http://forum.ragezone.com/f722/compl...ml#post6541242

---

can you upload your ini folder as well?

what about this

cannot establish keep alive session : 5.68.175.106 32003 (bind 0.0.0.0)

Quote:

---

Originally Posted by saxz

can you upload your ini folder as well?

---

Blitzkrieq_Bin_Data.rar
if you found any error and if you can fix that error share with me, i think i have an error about system :(:

---------- Post added at 06:28 PM ---------- Previous post was at 06:26 PM ----------

so anybody can't help to me about it?

http://i53.tinypic.com/2exx2rp.png

I anyone able to give me some tips or link to how to set Microsoft SQL Server 2008 up please I will be very thankful

Quote:

---

Originally Posted by CEZALAND

Blitzkrieq_Bin_Data.rar
if you found any error and if you can fix that error share with me, i think i have an error about system :(:

---------- Post added at 06:28 PM ---------- Previous post was at 06:26 PM ----------

so anybody can't help to me about it?

http://i53.tinypic.com/2exx2rp.png

---

i already compile ini with yours
but everytime i open CustomCertificationServer it just crash o.o
you think what's the problem?

Quote:

---

Originally Posted by saxz

i already compile ini with yours
but everytime i open CustomCertificationServer it just crash o.o
you think what's the problem?

---

try this CustomCertificationServer.bat

Code:

---

@echo off
CustomCertificationServer.exe packt.dat
pause

---

and send error to us :closedeyes:

cezaland, i download your cert inis (changed the database stuff), then i compiled, but when i start certification.bat it says: Could not locale a certification manager node type

i configre it make filezila server enter infromation to server.cfg
still dont work there is way to bypass billingserver?
or can somebody explain me in tw(teamviewer)?

Quote:

---

Originally Posted by benike1

cezaland, i download your cert inis (changed the database stuff), then i compiled, but when i start certification.bat it says: Could not locale a certification manager node type

---

Try this certification server:
http://forum.ragezone.com/f722/compl...ml#post6542359

Can you tell me how do to restore those files ? Thanks

Quote:

---

Originally Posted by CEZALAND

Try this certification server:
http://forum.ragezone.com/f722/compl...ml#post6542359

---

ty. good this working

Quote:

---

Originally Posted by CEZALAND

Try this certification server:
http://forum.ragezone.com/f722/compl...ml#post6542359

---

i click customcertification.bat and it opens, then close instatly..

another problem
http://img706.imageshack.us/img706/7992/testzo.png
why DB failed o.o

Quote:

---

Originally Posted by saxz

another problem
http://img706.imageshack.us/img706/7992/testzo.png
why DB failed o.o

---

Check srShard.ini/ODBC sources.

Chernobyl can you tell me how to set Microsoft SQL Server 2008 ? Because I can't connet to the database :(:

Cherno how to configure the DBConnect.asp i dont know what i should type on Provider=? o.O

Quote:

---

Originally Posted by skeyline

Cherno how to configure the DBConnect.asp i dont know what i should type on Provider=? o.O

---

Change only hostname/username/password.

Chernobyl,
Must i use IIS? Or i could use Xampp for example ,I have Apache and Filezilla with Xampp now.And i'm getting the "Billing server is dead" error.

can anyone upload working cert ini's and server.cfg?

http://img851.imageshack.us/img851/8727/asdfdafed.png

ok i passed the DB Failed
now it stay like this..and wont load anything so why?


edit:like this:"Provider=SQLOLEDB;Data Source=5.2.193.153;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123456;"
or wrong?

Quote:

---

Originally Posted by saxz

http://img851.imageshack.us/img851/8727/asdfdafed.png

ok i passed the DB Failed
now it stay like this..and wont load anything so why?


edit:like this:"Provider=SQLOLEDB;Data Source=5.2.193.153;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123456;"
or wrong?

---

not ip !
5.2.193.153

true is;
NAME\SQLEXPRESS

Quote:

---

Originally Posted by saxz

http://img851.imageshack.us/img851/8727/asdfdafed.png

ok i passed the DB Failed
now it stay like this..and wont load anything so why?


edit:like this:"Provider=SQLOLEDB;Data Source=5.2.193.153;Initial Catalog=SRO_VT_ACCOUNT;user ID=sa;password=123456;"
or wrong?

---

Try using ".\SQLEXPRESS" or just "." as hostname.

Im still having trouble.

I have , global + agentserver + farm manager + download server + agent server + gateway server + machine manager all connecting to each other fine.

But Sharmanager just doesnt open. It opens and instantly closes. I already did the IIS and ftp server. And just checked and both work.

Im running out of idea why shard manager and gameserver just wont open and stay open instead of instantly closing.

Can I use other programs than Microsoft SQL Server 2008?

Quote:

---

Originally Posted by Larkon

Im still having trouble.

I have , global + agentserver + farm manager + download server + agent server + gateway server + machine manager all connecting to each other fine.

But Sharmanager just doesnt open. It opens and instantly closes. I already did the IIS and ftp server. And just checked and both work.

Im running out of idea why shard manager and gameserver just wont open and stay open instead of instantly closing.

---

any idea i have the same problem

Quote:

---

Originally Posted by Chern0byl

Try using ".\SQLEXPRESS" or just "." as hostname.

---

ah ok
so what about the error?
it will stay like this forever?
nth will load?

Quote:

---

Originally Posted by saxz

ah ok
so what about the error?
it will stay like this forever?
nth will load?

---

If gameserver/shard couldn't access database (it loads tons of static/dynamic data from it), it won't even try to load completely.

Cherno could you answer what possibly could be the problem to my problem lol. IS on page 4 , last post.

strConnectA = "Provider=SQLOLEDB;Data Source=Skeyline-Home\SQLEXPRESS;Initial Catalog=SRO_VT_ACCOUNT;"

now i got this Error from Gameserver: Failed to getting silk data: unknown success code(An error occured...)

any solution?

Quote:

---

Originally Posted by Larkon

Im still having trouble.

I have , global + agentserver + farm manager + download server + agent server + gateway server + machine manager all connecting to each other fine.

But Sharmanager just doesnt open. It opens and instantly closes. I already did the IIS and ftp server. And just checked and both work.

Im running out of idea why shard manager and gameserver just wont open and stay open instead of instantly closing.

---

Seems, something is wrong with

a) billing
b) srShard.ini database connection/ODBC

Cher, is possible start server fully not starting MachineManager? mine no start, but server start normally and entering in smc server start with no erros.

http://i1133.photobucket.com/albums/...tu/Adsz-29.png

first question should i make all patches ?

2nd question i created the server on hamachi ip , will i edit media with hamachi ip ? or local ip ? and can i use bloody client ? or legendarydev's 1.118 client ?

3nd question , can i run server w/o machine manager ? , cuz its crashes every time i cant find the solution , everything running fine w/o machine manager

waiting the answers :)

Quote:

---

Originally Posted by Lordkill

Cher, is possible start server fully not starting MachineManager? mine no start, but server start normally and entering in smc server start with no erros.

---

Check my post at CAZELAND's thread, where he posted files i released. I gave a link to updated SMC.

Cherno i will post what I have for billing and srShard.ini database connection/odbc

If i put this in my browser " http://192.168.x.x:8080/ " of course with my ip. It will show this

Code:

---

HTTP Error 403.14 - Forbidden

The Web server is configured to not list the contents of this directory.

---

Is my first time using IIS so , if the site is not supposed to show that than im doing something wrong.


Shar.ini

Code:

---


[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SRO
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=ihavemyusernamehere;PWD=andmypasswordhere;DATABASE=SRO_VT_SHARD
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=myusernamehere;PWD=andmypasswordhere;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

---

When it comes to ODBC. I have setup all 3 odbc with " SQL SERVER" each to its individual database.

I just cant seem to figure out whats the problem.


For DBCONNECT.ASP

Code:

---

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=DAYAN-PC\SQLEXPRESS;Data Source=192.168.x.x;Initial Catalog=SRO_VT_ACCOUNT;user ID=mydatabaseusername;password=mydatabasepassword;"
DBConnA.Open strConnectA

%>

---

of course with my ip again.

Quote:

---

Originally Posted by Chern0byl

If gameserver/shard couldn't access database (it loads tons of static/dynamic data from it), it won't even try to load completely.

---

like this one?
if you talk about this
how can i fix it?
http://img231.imageshack.us/img231/2756/likethisf.png

Quote:

---

Originally Posted by saxz

like this one?
if you talk about this
how can i fix it?
http://img231.imageshack.us/img231/2756/likethisf.png

---

You don't have to fix it, it will work.

Quote:

---

Originally Posted by Chern0byl

You don't have to fix it, it will work.

---

how it work if SR_ShardManager closed after some data loaded in game server?

Chern check my post in this page. You see anything wrong?

Chernobyl can you help me? or anyone
i start sro, but my client crash after 2 second (sro_client.exe stopped working) what should i do?

I have a feeling cause i saw it in another serverfiles. That am i supposed to have a "billin.ini" or "billing.cfg" in my files? Cause if i am , than i dont have it.

Quote:

---

Originally Posted by Larkon

Cherno i will post what I have for billing and srShard.ini database connection/odbc

If i put this in my browser " http://192.168.x.x:8080/ " of course with my ip. It will show this

Code:

---

HTTP Error 403.14 - Forbidden

The Web server is configured to not list the contents of this directory.

---

Is my first time using IIS so , if the site is not supposed to show that than im doing something wrong.


Shar.ini

Code:

---


[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SRO
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=ihavemyusernamehere;PWD=andmypasswordhere;DATABASE=SRO_VT_SHARD
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=myusernamehere;PWD=andmypasswordhere;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

---

When it comes to ODBC. I have setup all 3 odbc with " SQL SERVER" each to its individual database.

I just cant seem to figure out whats the problem.


For DBCONNECT.ASP

Code:

---

<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=DAYAN-PC\SQLEXPRESS;Data Source=192.168.x.x;Initial Catalog=SRO_VT_ACCOUNT;user ID=mydatabaseusername;password=mydatabasepassword;"
DBConnA.Open strConnectA

%>

---

of course with my ip again.

---

Leave data provider as it was, change Source to DAYAN-PC\SQLEXPRESS.

Temple : Reputation Check Faild ! - CShardSJ_TempleOfAnubisAndIsisGate

And SR_ShardManager crash...=\

Quote:

---

Originally Posted by stemale

Temple : Reputation Check Faild ! - CShardSJ_TempleOfAnubisAndIsisGate

And SR_ShardManager crash...=\

---

Full log, please.

Quote:

---

Originally Posted by Chern0byl

Full log, please.

---

can u answer my questions ?:blush:

Quote:

---

Originally Posted by Chern0byl

Full log, please.

---

Quote:

---

2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [FarmManager] server cord established : 21
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 1
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 2
2011-09-13 22:56:40 [SR_GameServer] server cord established : 15 (
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 3
2011-09-13 22:56:40 [AgentServer] server cord established : 15
2011-09-13 22:57:29 [SR_ShardManager] SR_ShardManager is initialized successfully
2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!
2011-09-13 22:57:30 [AgentServer] 705:SR_ShardManager is blind : 0 users are banned
2011-09-13 22:57:30 [SR_GameServer] server cord closed : 15
2011-09-13 22:57:30 [FarmManager] server cord closed : 21

---

i think this is it

Quote:

---

Originally Posted by Chern0byl

Leave data provider as it was, change Source to DAYAN-PC\SQLEXPRESS.

---

I did that , this shardmanager sure really does not want to open at all.. :grr: . Just instantly closes.

Quote:

---

Originally Posted by stemale

i think this is it

---

2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!

http://img856.imageshack.us/img856/1...kethisdsds.png
http://img832.imageshack.us/img832/3086/likes2.png

everything Fine now?
can i log on server now?

Chern when u have a chance , come to teamviewer pretty quick and take a look at this shard. I've done all that you've told me. yet it wont open.

Am i missing a "billing.ini" or "billin.cfg" file that im supposed to have ? Cause I dont have it.

Anyways Teamviewer ID : 912 180 783 PAss: 2110

Quote:

---

Originally Posted by saxz

http://img856.imageshack.us/img856/1...kethisdsds.png
http://img832.imageshack.us/img832/3086/likes2.png

everything Fine now?
can i log on server now?

---

Change shard state to Operating, and yep, then you will be able to log in.

Quote:

---

Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'CREATE'.

---

this query giving me this error

Quote:

---

USE [Silkroad]
GO
/****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop table_PrivilegedIP
CREATE TABLE [dbo].[_PrivilegedIP](
[IP1] [tinyint] NOT NULL,
[IP2] [tinyint] NOT NULL,
[IP3] [tinyint] NOT NULL,
[IP4] [tinyint] NOT NULL,
[IP5] [tinyint] NOT NULL,
[IP6] [tinyint] NOT NULL,
[IP7] [tinyint] NOT NULL,
[IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO

---

Quote:

---

Originally Posted by Chern0byl

Change shard state to Operating, and yep, then you will be able to log in.

---

sorry for noob Q
BUT HOW I DO IT!

Quote:

---

Originally Posted by Chern0byl

2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!

---

Yea but how now i can know what a problem ?

Quote:

---

Originally Posted by saxz

sorry for noob Q
BUT HOW I DO IT!

---

Right click shard service, and search for "Change Service Type -> Operating".

Quote:

---

Originally Posted by Chern0byl

Right click shard service, and search for "Change Service Type -> Operating".

---

Thx!...........

Failed to getting silk data: unknown success code (1)
Silk Data Loading Failed [JID: 1]
AQ Failed! Log out!! [AQType: 9]

i can do what i want i get this error in gamemanger and get a instante DC -.-

Cherno , once the shardmanager closes instant. Shouldnt there be a error log file somewhere? to know what the problem was ?. Where would this file be at ? is it the .dmp files?

Quote:

---

Originally Posted by Larkon

Cherno , once the shardmanager closes instant. Shouldnt there be a error log file somewhere? to know what the problem was ?. Where would this file be at ? is it the .dmp files?

---

Probably, wrong port defined at server.cfg for module certification.

btw Chernobyl, what php version are you using for the registration php files you placed on the 1st page? i got wamp with php 3. something and the mssql extension isnt there, can you tell me what apache and php version you are using? or what software bundle xamp wamp etc.

Quote:

---

Originally Posted by Chern0byl

Probably, wrong port defined at server.cfg for module certification.

---

IM using your server.cfg ^^

the port are

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 ,
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 "192.168.x.x", 32000
LoginFailureTolerance 3 // ÃÖ´ë ·Î±×ÀÎ Æнº¿öµå ¿À·ù Çã¿ëÄ¡
IBUVFailureTolerance 3 // ÃÖ´ë À̹ÌÁö ÀÎÁõ ¿À·ù Çã¿ëÄ¡
LoginFailureBlockTimeMin 0 // ºí·° ½Ã°£(ºÐ) - ·Î±×ÀÎ Æнº¿öµå ¿À·ù
IBUVFailureBlockTimeMin 0 // ºí·° ½Ã°£(ºÐ) - À̹ÌÁö ÀÎÁõ ¿À·ù
AutomatedPunisher "AutomatedPunisher" // ºí·° ÁÖü À̸§ (±âÁ¸ ºí·°Àº gm ¸í)
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 1
Certification "192.168.x.x", 15880
IBUVQueueReserveCount 20000 // IBUV¸¦ À§ÇØ ¹Ì¸® »ý¼ºÇØ ³õÀ» À̹ÌÁö °¹¼ö
IBUVQueuePrepareRatio 0.10 // ¾ÆÀ̵é ŸÀÓ¿¡ À̹ÌÁö »ý¼ºÇÒ ºñÀ²
IBUVFailureIPTolerance 0 // ÇÑ IP´ç IBUV ½ÇÆи¦ Çã¿ëÇÒ ÃÖ´ë ¿À·ù Çã¿ëÄ¡, 0ÀÌ¸é ºí·° ¾ÈÇÏ°Ú´Ù´Â °ÅÁö.

// Ãß°¡µÈ ³ÑÀÌ´Ù!!!!!
//////////////////////////////////////////////////////////
IBUVStringSize 5 // ÇÑ±Û Ä³¸¯Åͼ »ç¿ë ½Ã 3, ¾ËÆĺª ij¸¯ÅÍ ¼Â¸¸ »ç¿ëÇÏ´Â °æ¿ì 6 À¸·Î ¼¼ÆÃÇÑ´Ù.
IBUVCharacterSet "ABCDEF1234567890"
//////////////////////////////////////////////////////////
}

DownloadServer {
Certification "192.168.x.x", 15880
}
FarmManager {
Certification "192.168.x.x", 15880
}

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

MachineManager {
Certification "192.168.x.x", 15880
CERTIFICATION_IP_BIND "192.168.x.x"
}

SR_GameServer {
Certification "192.168.x.x", 15882
SockTCPCount "5000"
ExpRatio "35000"
ExpRatioParty "35000"
DropItemRatio "5000"
DropGoldAmountCoef "15000"
HwanGainFactor 250
ShowFormulaDetail 1

//WINTER_EVENT_2009 EVENT_ON // 2009³â °Ü¿ï À̺¥Æ®
//EUBUSINESS_EVENT EVENT_ON
//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
//THANKS_GIVING_EVENT EVENT_ON
//LIBERATION_EVENT EVENT_ON
LOCALE LOCALE_VIETNAM // for Helper mark

//#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 "192.168.x.x", 15882
BILLING_SERVER_URL "http://192.168.x.x:80/"
CREST_FTP_URL "ftp://Dayan:723miroku8787@192.168.x.x/"
ChristmasEvent2007 0
//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
}

---

Everything certs together and opens . but not shard or game. They are instant close. Thast why im asking , shouldnt they release some error logs somewhere? to find out what the issue was ?

Are the .dmp the error logs?

after i did what you told me about change shard
i tried to log on game with my hamachi ip
http://img651.imageshack.us/img651/6513/startd.png
after i clicked start i got
http://img196.imageshack.us/img196/6...erproblemd.png

so where the problem?

Edit:server.cfg wrong ports?

Quote:

---

Originally Posted by saxz

after i did what you told me about change shard
i tried to log on game with my hamachi ip
http://img651.imageshack.us/img651/6513/startd.png
after i clicked start i got
http://img196.imageshack.us/img196/6...erproblemd.png

so where the problem?

Edit:server.cfg wrong ports?

---

i have same problem :grr:

Quote:

---

Originally Posted by CEZALAND

i have same problem :grr:

---

^^
as i said in post
i think the problem in server.cfg(ports)

hey

is this right?

http://img18.imageshack.us/img18/9755/errorku.jpg

on Server Machine i get illegal Machine
and illegal Machine = certification Manager

why?

and i can't see my server on XServerStats

pls help

Chern0byl because I work the certificate which you have in your guide