[Guide] Setting up a server based on VSRO server files

[Dr.Abdelfattah]

Please Read First my ReadMe.txt in attachemnt ()
--------------------------------------------------------------------------------------
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

---------------------------------------------------------------------------
Download all Server Files you need from here

 Spoiler

Server Files
{
Part 1 :



Part 2 :



Part 3 :



password is "fortheworstcommunityever".
}

Database Dumps
{
Clean Database Working with MSSQL 2005



}

Changeset vsro obt v247-v249 (u wont need it, unless you are just interested in viewing it)
{


}

Xtrap update files
{


}

Billing ASP scripts
{


}

Custom certification server
{
(from pushedx aka Drew Benton)
(applications by pushedx aka Drew, ini configuration by Dr.Abdelfattah)
}

Latest SMC Build
{


}

---------------------------------------------------------------------------
You can get MSSQL 2008 express edition from official Microsoft website

 Spoiler

() same as SSMS

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

 Spoiler

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 (needed for some mssql servers!!) :

 Spoiler

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.

Simple Explain About Certification :

 Spoiler

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).

Arrange :

 Spoiler

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,

 Spoiler

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 :

 Spoiler

PHP 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
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 


---------------------------------------------------------------------------
(already done in the cleaned databases...)

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.

PHP 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

 Spoiler

{
- Wrong MSSQL server setup
- Wrong certification server configs
- Wrong database names
- Wrong ODBC setup (not needed in some times)
- Wrong IIS setup
- Wrong ip addresses/ports defined in server.cfg
}

---------------------------------------------------------------------------
Some info you should know

 Spoiler

{
- 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 :
- Tons more
- Every GameServer could handel 50K spawned objects Only .
}

---------------------------------------------------------------------------
Common Problems (and solve)



---------------------------------------------------------------------------
[Guide] Patching Media.pk2 ip address using XVI32
Written by Chern0byl

 Spoiler

So, since some people had problems patching Media.pk2 using pk2 tools and media patchers, i decided to make a guide to explain, how to do it "manually" using only hex editor.

So, first of all, you will need some hex editor (i would preffer XVI32 for such thing to do). You can get it here :

After you are done downloading, extract it to a some folder, and run xvi32.exe, open your media.pk2 file, and preff Ctrl + F (search), select Text string as search option, and type in the current ip address, or hostname which media contains. After it finds the text string, just rewrite it with whichever ip/hostname you need. After you are done, you might get in situation when your hostname/ip is not same length as old one (smaller). If so, you will have to set remaining symbols to null. Following screen shot shows how to do it.

After you are done, just save your Media.

---------------------------------------------------------------------------
searched in youtube

 Spoiler

---

------------------------------------------------------------------
Cracking GameServer to fix rates
Writed By

 Spoiler

So, some people might have problems even at such basic stuff as cracking a experience limit.

Gameserver reads rates as (real rate * 1000), it means, if you set rates to
35000, experience gain coefficent will be 35x. By default, gameserver forbidds making them more than 250 (2.5 x), but it's easy to crack.

So, open your SR_GameServer executable using OllyDBG, and patch the following addresses with following assembly codes.


================================================== ===========================
Individual experience ratio

PHP Code:

0042714C F6C4 50 TEST AH,42 


================================================== ===========================
Party experience ratio

PHP Code:

004271F5 F6C4 42 TEST AH,42 


================================================== ===========================
Item drop rate

PHP Code:

004272A0 F6C4 42 TEST AH,42 


================================================== ===========================
Gold drop amount rate

PHP Code:

00427349 F6C4 42 TEST AH,42 


================================================== ===========================
HWLAN (berserker) gain factor

PHP Code:

004273CA |. F6C4 44 TEST AH,42 


================================================== ===========================
Bypass creation of huge .dmp files (less lags)

PHP Code:

00964060 81EC 6C060000 SUB ESP,66C 


change command to

PHP Code:

jmp 009642FD 


================================================== ===========================




To do it, follow this screenshots. Open the file using OllyDBG (F3)


Double-click the line you were jumped to, and...


Do same for all addresses.

---------------------------------------------------------------------

Database

Use this query to clean out old data from SRO_VT_ACCOUNT tables. (If you Don't use cleaned Database)

 Spoiler

PHP Code:

USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans] 


---------------------------------------------------------------------------
If you need to create your own GM account:

 Spoiler

PHP Code:

1. You need a md5 hasher. (can google it)
2. Go to TB_Users table
3. Fill the form like this:

JID: Fills automatically
StrUserID: Username
password: password
status: can leave blank
GMRank: Set this to 1 (Server Dev) 2 (content administrator) 3 (content user) 4 (content marketer) 5 (content monitor) 6 (Content GM) 7 (content GM Leader)
sec_primary - set it to 1 (3 is normal user)
sec_content - set it to 1 (3 is normal user)


4. You can fill in the other neccesary fields like email, adress so on, but they're not really neccesary. 


---------------------------------------------------------------------------
This will clean up Log database instantly :

 Spoiler

 Spoiler

PHP Code:

USE [SRO_VT_LOG]
GO
TRUNCATE TABLE [dbo].[_LogCashItem]
TRUNCATE TABLE [dbo].[_LogEventChar]
TRUNCATE TABLE [dbo].[_LogEventItem]
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress]
TRUNCATE TABLE [dbo].[_LogSchedule]
TRUNCATE TABLE [dbo].[_LogServerEvent] 


Use this to prune all old character data from shard :

PHP Code:

//..basically you need to delete these manually. (If you don't use cleaned databases) 


---------------------------------------------------------------------------------------
Simple registration page for official server files (php)

 Spoiler

Download

-----------------------------------------------------------------------------------------
green/red/black books :
chernobyl write :

 Spoiler

So, since vsro has such a "nice" thing like green/red/black books, i've made a simple solution for this, temporary, through.

So, You have to open your GlobalManager.exe, and search for this HEX code

PHP Code:

7570646174652054425F555345522073657420416363506C61 7954696D65 


Which means

PHP Code:

update TB_USER set AccPlayTime 


Now just change AccPlayTime part to a some another name, for example, OnlineTime. After you are done, save the file, and open sql server management studio, open SRO_VT_ACCOUNT database, TB_User table, set all AccPlayTime field values to 0, and create a new column named "OnlineTime" (int).

Simple as that, but not the best solution. Users will have to relogin in order to be able to gain experience once green book appears (it will just reset).

You can use nearly any hex editor for this. I'd preffer Hex Workshop, or XVI32.

---------------------------------------------------------------------------

[Guide]How to Make GM Acc Working 100%! (already written in the top post !)

 Spoiler

First:Open MMSQL>>>>SRO_VT_ACCOUNT>>>>Right Click on it>>>> Choose New Query>>>>Write This

PHP Code:

GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog]
TRUNCATE TABLE [dbo].[SK_ItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog]
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog]
TRUNCATE TABLE [dbo].[SK_ResetSkillLog]
TRUNCATE TABLE [dbo].[SK_Silk]
TRUNCATE TABLE [dbo].[SK_SilkBuyList]
TRUNCATE TABLE [dbo].[SK_SilkGoods]
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS]
TRUNCATE TABLE [dbo].[SR_ShardCharNames]
TRUNCATE TABLE [dbo].[TB_Net2e]
TRUNCATE TABLE [dbo].[TB_Net2e_Bak]
TRUNCATE TABLE [dbo].[tb_paygate_trans] 


DONT FORGET TO MAKE SMC ACC
LIKE THIS
Open TB_User>>>
do like this
PHP Code:

JID:leave it
StrUserID:Username of SMC
Password:go to any MD5 Site and wirte any word you want then you will get the MD5 Code....go to Password table and put it
Sec_primary:1
sec_content:1

Close MSSQL after you done from this part!
---------------------------------------------------------------------------

Second:
After your Close the MSSQL>>>>Go open (SMC with the user we just made in TB_User)(but ofc you have to open the others .exe so your can open SMC)>>>>Choose Security>>>Choose User Security>>>>Right Click on the Write Page in SMC>>>>Click on Add User>>>>User Property will Appear(it will be like this)

PHP Code:

UserID=Username
Password=your Acc Password
Retype Password=Just type your password again
Name=you can write any name you want
SSNumber=write in the first table(1) and the 2nd table write(1)
Organiztion=write anything you want
Role=write anything you want
PrimarySecurityGroup=Choose Content GM
ContentSecurityGroup=Choose Content GM
Granted IP Adress=abit Complex 


if you using Hamachi ip then you going write it in Granted IP Adress
if you using 192.168.x.x then you going write it in Granted IP Adress
we done From this Part
---------------------------------------------------------------------------

Three:
After you done from Second Part
go open MSSQL>>>TB_User>>>>you going find the acc we just created>>>>Look what you going do

PHP Code:

Status:1
GMrank:1
Sec_Primary:Change it from 6 to 1
Sec_Content:Change it From 6 to 1 


After you done from TB_User>>>Open _PrivilegedIP>>>put the IP you write in Granted IP Adress
it would be like this

PHP Code:

IP1:192
IP2:168
IP3:x
IP4:x
IP5:192
IP6:168
IP7:x
IP8:x 


or the ip you put at Granted IP Adress

hope you understand this part ^^
Now all you going do is Close MSSQL and Restart your Server >>>then you can Log on Game with the GM Acc
this Guide Credit to me(iam same one who posted it there at epvp)
Hope so it helpfull for you guys

---------------------------------------------------------------------------
FTP Server (filezilla) (for security reason don't setup open ftp like for guild/union pic in the machine which host server files)

 Spoiler

Link:

----------------------------------------------------------------------
Microsoft SQL Server 2005

 Spoiler

>> SQL Server 2005 - 32 bit (x86)
>>>>

>> SQL Server 2005 Managament Studio 32 bit (x86)
>>>>

>> SQL Server 2005 - 64 bit (x64)
>>>>

>> SQL Server 2005 Managament Studio 64bit (x64)
>>>>

I suggest to use google search instead of using those .. !!!

---------------------------------------------------------------------------
To support ur iis server to open php scripts

 Spoiler

---------------------------------------------------------------------------
Full problems FiX here (for 2 aka 3 machines)

 Spoiler

--------------------------------------------------------------------------
Make ur server without hamachi if u have static ip

 Spoiler

---------------------------------------------------------------------------
Add Stater Items for Chars :

 Spoiler

> Databases > SRO_VT_SHARD_INIT > Programmability > Stored Procedures > _AddNewChar.dbo
Right click it, click "Modify"
to add start items to your inventory scroll to the bottom
add lines like this :

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,12
ITEM_CH_SWORD_11_SET_B_RARE means Fight nova sword, obviously.... 1 means amount, 12 means plussvalue

like this :
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CODE',(Amount),(Plusvalue)

mine looks like this

 Spoiler

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLU S',1,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_GLOBAL_CHATTING',50,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_INVENTORY_ADDITION',1,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,12 
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,12

---------------------------------------------------------------------------
This is very useful

 Spoiler

---------------------------------------------------------------------------
New Items Useful to Run Your Server
non xtrap agent/sro_client by chernobyl

 Spoiler

Download :

---------------------------------------------------------------------------
And full working Clean Databases works on SQL 2005 by Artuuro

 Spoiler

Download :

---------------------------------------------------------------------------
Some Basic Security Guides you need to read before run your server for Public :

 Spoiler

Ddos


Basic Security Guide


This guide security is secret !!


Basic Security guide too

---------------------------------------------------------------------------
Basic Experience about creating Server (Guide) :

.

[MAFIA001]

COPY PASTA

[6_lucifer_6]

so? he deliverd it here... dont like it? their is always exit button..

[the_belgian]

Who cares about copy/paste if it's usefull ? duhhh

[formatme]

what client do we use and how do u edit the ip

[Dr.Abdelfattah]

Originally Posted by formatme

what client do we use and how do u edit the ip

u can use BloodySro client

[Chernobyl*]

Why did you remove the last line ?

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

[formatme]

Originally Posted by abdelfattah

u can use BloodySro client

how do i edit the ip tho?

[Dr.Abdelfattah]

Originally Posted by Chernobyl*

Why did you remove the last line ?

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

Oo srry i don't see that ,, anyway if u need to delete this thread i have no problem i just copied here cuz i have no time to make full guide for vsro files

[Tazdingo7]

Im get stucked here : "After you are done with it, start third batch file ("3 - CustomCertificationServer.bat")"

I have this error :


You know why ?

I do all the steps until this point when i try to open the CustomCertificationServer Batch File

Another question , what ports i need to open ?

[Dr.Abdelfattah]

Originally Posted by Tazdingo7

Im get stucked here : "After you are done with it, start third batch file ("3 - CustomCertificationServer.bat")"

I have this error :


You know why ?

I do all the steps until this point when i try to open the CustomCertificationServer Batch File

Another question , what ports i need to open ?

check ip u enter in srNodeType.ini , it must be ur machine ip

[Lupin*]

can someone help me with this error , i think its cannot connect to my account db

[Tazdingo7]

Originally Posted by abdelfattah

check ip u enter in srNodeType.ini , it must be ur machine ip

emmmm

What's wrong ?

PHP Code:

[global]
count=8
[entry0]
id=335
operation_type=17
name=GMGS
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=0
[entry1]
id=336
operation_type=17
name=DN1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=701
[entry2]
id=338
operation_type=17
name=GWS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=699
[entry3]
id=339
operation_type=17
name=FMGS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=0
[entry4]
id=340
operation_type=17
name=SDMGS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=706
[entry5]
id=341
operation_type=17
name=SD1AGS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=708
[entry6]
id=344
operation_type=17
name=SD1GAS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=714
[entry7]
id=133
operation_type=0
name=Certification Manager
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=0 


[Dr.Abdelfattah]

Originally Posted by thetbot

can someone help me with this error , i think its cannot connect to my account db

your database info is wrong ,,,
if u sure u enter right info just check this



and this




are differant posts

Originally Posted by Tazdingo7

emmmm

What's wrong ?

PHP Code:

[global]
count=8
[entry0]
id=335
operation_type=17
name=GMGS
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=0
[entry1]
id=336
operation_type=17
name=DN1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=701
[entry2]
id=338
operation_type=17
name=GWS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=699
[entry3]
id=339
operation_type=17
name=FMGS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=0
[entry4]
id=340
operation_type=17
name=SDMGS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=706
[entry5]
id=341
operation_type=17
name=SD1AGS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=708
[entry6]
id=344
operation_type=17
name=SD1GAS1
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=714
[entry7]
id=133
operation_type=0
name=Certification Manager
wip=190.105.48.131
nip=190.105.48.131
machine_manager_node_id=0 


loolz this ip is wrong
190.105.48.131
the right one is 192.168.1.103 from ur IPv4 connection

[mokadidi]

2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [FarmManager] server cord established : 11 (192.168.0.100:51966)
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 21:25:54 [SR_ShardManager] server cord established : 1 (192.168.0.100:32004)
2011-09-13 21:26:06 [SR_ShardManager] Query Error!!! Query Result : -1, Query : {?=CALL _ExistsServiceOffRentItem}
2011-09-13 21:26:06 [SR_ShardManager] SQL Error State:42000, Native Error Code: AFC, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure '_ExistsServiceOffRentItem'.
2011-09-13 21:26:06 [SR_ShardManager] {?=CALL _ExistsServiceOffRentItem}
2011-09-13 21:26:06 [SR_ShardManager] BillingServer is Dead!!

help plz