[GUIDE] Setup a server without errors [1x GameServer]

10/23/2011 17:25 analfistel#571
Hey zikor1337 .. where is the SRO_VT_ACCOUNT.bak?
I dont can find it.. you can help me?
10/23/2011 20:59 bO_#572
successfully server certificated
server cord established : 1 (5.45.139.232:15882)
Connected to FarmManager [#704]
DB Connection Failed!
Says Shard manager and Game server to me!
Any solution???
10/24/2011 10:49 thedorinro#573
This was a very simple guide and very good also, i got it to work first shot and i don't even have experience with sql. Is all about paying attention and have a decent logic.
Thanks to zikor1337 i have my own private server now(private not public).
I managed to change a thing or two such as alchemy enchantment rates (30 + safe enchantment) auto max level on new char creation...etc.
I still haven't found a way to change the rates on the server or the rare drop probability.
I am running the server on Athlon X2 5000+BE (OC-ed to 3.2Ghz) with 4GB's or DDR2. and is stable and okay. I have no disconnects or stuff like that, it runs 99% stable.
Anyways good luck to you all and again thanks to zikor1337.

PS: Dupa ce mi-am facut serverul m-am plictisit enorm si instant de joc....nu mai are farmec deloc...asa ca nu recomand.
10/24/2011 12:36 Blinki12#574
Quote:
Originally Posted by bO_ View Post
Db connection failed
Says Shard manager to me!
Any solution???
same here^^
10/24/2011 17:05 bO_#575
Quote:
Originally Posted by Blinki12 View Post
same here^^
We need help!!! ^^
10/24/2011 17:42 TheSoulTrack#576
Hello everyone i have this litle problem xD

[Only registered and activated users can see links. Click Here To Register...]

i don't know what it is but someone told me that can be the database conection in srShard.ini and srGlobalService.ini or the ODBC but i think all is ok check here :

Code:
[global]
count=1
[entry0]
operation_type=17
name=SRO_GameOn_Official
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01,1433;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=password;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=69

Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=17
name=KOUGA
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01,1433;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=password;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01,1433;DSN=Log_DB;UID=sa;PWD=password;DATABASE=Log_DB
capacity=10
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
[Only registered and activated users can see links. Click Here To Register...]

I used SQLEXPRESS01 because i reinstall sql xD don't think that is the error >.>

So who can help me with that?
10/24/2011 18:18 Blinki12#577
Quote:
Originally Posted by bO_ View Post
successfully server certificated
server cord established : 1 (5.45.139.232:15882)
Connected to FarmManager [#704]
DB Connection Failed!
Says Shard manager and Game server to me!
Any solution???
pls help us =(
10/24/2011 19:04 379332#578
i'm getting this error when trying to open GlobalManager
[Only registered and activated users can see links. Click Here To Register...]
10/24/2011 19:09 TheSoulTrack#579
Quote:
Originally Posted by 379332 View Post
i'm getting this error when trying to open GlobalManager
[Only registered and activated users can see links. Click Here To Register...]
Open
3 - CustomCertificationServer in Blitzkrieq_Bin_Data\bin and wait till it says something like this :

Status: Certification Server started on YOURIP:32000
Status: Press ESC to exit...

And don't close it them try to open GlobalManager
10/24/2011 19:18 379332#580
Quote:
Originally Posted by TheSoulTrack View Post
Open
3 - CustomCertificationServer in Blitzkrieq_Bin_Data\bin and wait till it says something like this :

Status: Certification Server started on YOURIP:32000
Status: Press ESC to exit...

And don't close it them try to open GlobalManager
passed that error now it ask for certification and global manager closes
10/24/2011 19:55 TheSoulTrack#581
Quote:
Originally Posted by TheSoulTrack View Post
Hello everyone i have this litle problem xD

[Only registered and activated users can see links. Click Here To Register...]

i don't know what it is but someone told me that can be the database conection in srShard.ini and srGlobalService.ini or the ODBC but i think all is ok check here :

Code:
[global]
count=1
[entry0]
operation_type=17
name=SRO_GameOn_Official
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01,1433;DSN=SRO_VT_ACCOUNT;UID=sa;PWD=password;DATABASE=SRO_VT_ACCOUNT
global_manager_node_id=69

Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=17
name=KOUGA
query=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01,1433;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=password;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=MYUSER\SQLEXPRESS01,1433;DSN=Log_DB;UID=sa;PWD=password;DATABASE=Log_DB
capacity=10
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
[Only registered and activated users can see links. Click Here To Register...]

I used SQLEXPRESS01 because i reinstall sql xD don't think that is the error >.>

So who can help me with that?
So noone knows how to fix this error?
10/25/2011 07:57 379332#582
[Only registered and activated users can see links. Click Here To Register...]
Code:
notify	BILLING SERVER[dummy]	2011-10-25 03:55:36 979
notify	BillingMgr- Created!	2011-10-25 03:55:36 981
notify	BillingMgr- Service Initialized!	2011-10-25 03:55:36 982
notify	successfully server task registered	2011-10-25 03:55:36 983
notify	request server certification	2011-10-25 03:55:36 984
notify	Add ServerNotify : (1) - Certification	2011-10-25 03:55:37 058
notify	Add ServerNotify : (698) - GatewayServer	2011-10-25 03:55:37 194
notify	Add ServerNotify : (699) - MachineManager	2011-10-25 03:55:37 195
notify	Add ServerNotify : (700) - DownloadServer	2011-10-25 03:55:37 196
notify	Add ServerNotify : (704) - FarmManager	2011-10-25 03:55:37 199
notify	successfully server certificated	2011-10-25 03:55:37 202
fatal	server cord established : 1 (192.168.0.103:32001)	2011-10-25 03:55:37 204
notify	Successfully DB Initialized!	2011-10-25 03:55:37 254
fatal	Max User Count Restriction Per IP: system default (infinite)	2011-10-25 03:55:37 291
notify	Account DB Successfully Connected!	2011-10-25 03:55:37 292
notify	Silk DB is assigned to Account DB!!	2011-10-25 03:55:37 293
fatal	execute query error : select * from _SecurityDescription with (NOLOCK)	2011-10-25 03:55:37 294
fatal	Query Error!!! Query Result : -1, Query : select * from _SecurityDescription with (NOLOCK)	2011-10-25 03:55:37 295
fatal	SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '_SecurityDescription'.	2011-10-25 03:55:37 297
fatal	select * from _SecurityDescription with (NOLOCK)	2011-10-25 03:55:37 298
fatal	security description data loading failed....	2011-10-25 03:55:37 299
fatal	GlobalManager is initialized successfully	2011-10-25 03:55:37 299
fatal	execute query error : select * from SK_SilkChange_BY_Web	2011-10-25 03:55:41 971
fatal	Query Error!!! Query Result : -1, Query : select * from SK_SilkChange_BY_Web	2011-10-25 03:55:41 973
fatal	SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SK_SilkChange_BY_Web'.	2011-10-25 03:55:41 975
fatal	select * from SK_SilkChange_BY_Web	2011-10-25 03:55:41 978
fatal	execute query error : select * from SK_SilkChange_BY_Web	2011-10-25 03:55:46 971
fatal	Query Error!!! Query Result : -1, Query : select * from SK_SilkChange_BY_Web	2011-10-25 03:55:46 973
fatal	SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SK_SilkChange_BY_Web'.	2011-10-25 03:55:46 975
fatal	select * from SK_SilkChange_BY_Web	2011-10-25 03:55:46 977
fatal	execute query error : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 99	2011-10-25 03:55:46 978
fatal	Query Error!!! Query Result : -1, Query : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 99	2011-10-25 03:55:46 981
fatal	SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name '_Shard'.	2011-10-25 03:55:46 982
fatal	update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 99	2011-10-25 03:55:46 984
fatal	execute query error : select * from SK_SilkChange_BY_Web	2011-10-25 03:55:51 970
fatal	Query Error!!! Query Result : -1, Query : select * from SK_SilkChange_BY_Web	2011-10-25 03:55:51 972
fatal	SQL Error State:42S02, Native Error Code: D0, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'SK_SilkChange_BY_Web'.	2011-10-25 03:55:51 974
fatal	select * from SK_SilkChange_BY_Web	2011-10-25 03:55:51 977
can some1 help me please with this error?
10/25/2011 12:21 sonyBlack1982#583
hi all can help me pls msg me i give you TeamViewer 6

[Only registered and activated users can see links. Click Here To Register...]
10/25/2011 17:50 wolff66#584
Hi ! Can someone help me little bit ? :/
i got error :
[Only registered and activated users can see links. Click Here To Register...]
And i dont know how to fix it :S i hope someone can help me
10/25/2011 18:49 379332#585
any1 know why SR_SHARDMANAGER ain't working propelly?
everything is running ok, when I come to SR_SHARD and SR_GAMESERVER it keeps like this
[Only registered and activated users can see links. Click Here To Register...]