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

10/25/2011 19:36 Blinki12#586
Quote:
Originally Posted by 379332 View Post
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...]
same here ....
10/25/2011 21:53 zikor1337#587
Quote:
Originally Posted by TheSoulTrack View Post
So noone knows how to fix this error?
Your cert files are wrong. Use the cert files I gave in the "Files" archive.

Quote:
Originally Posted by 379332 View Post
[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?
Ini files are wrong or ODBC is not setted properly

Quote:
Originally Posted by wolff66 View Post
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
Wrong ini configuration. Check your ini files.

Quote:
Originally Posted by 379332 View Post
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...]
You can see it there... Database Connection Failed !

Check again your ini files !

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...]
You missed the certification step .
10/25/2011 23:39 Blinki12#588
mhh i think they are correct...
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Test
query=DRIVER={SQL Server};SERVER=COMPUTERNAME\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=31ch3lm4nn;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=COMPUTERNAME\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=31ch3lm4nn;DATABASE=Log_DB
capacity=10
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
10/26/2011 02:40 jorchom#589
ok thx probando
10/26/2011 02:42 nitrogino#590
please give me help for TeamViewer a conect DB msn [Only registered and activated users can see links. Click Here To Register...] plase
10/26/2011 03:29 379332#591
Quote:
You can see it there... Database Connection Failed !

Check again your ini files !
srShard.ini
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=SPNZ0X\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=miloka123;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=SPNZ0X\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=miloka123;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
anything missing?/btw is that the ini should i check for my sh_shard no beeing connect propelly with DB?

Quote:
Originally Posted by Blinki12 View Post
mhh i think they are correct...
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=Test
query=DRIVER={SQL Server};SERVER=COMPUTERNAME\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=31ch3lm4nn;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=COMPUTERNAME\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=31ch3lm4nn;DATABASE=Log_DB
capacity=10
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
change COMPUTERNAME to YOUR COMPUTER NAME
YAYgot it working
[Only registered and activated users can see links. Click Here To Register...]
thanks for this guide
btw now i wanna know how to change my name for [GM] and do you know any gm command? like spawns etc? i tryed changing name in SMC aint working
10/26/2011 10:33 Blinki12#592
Quote:
Originally Posted by 379332 View Post
srShard.ini
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=SPNZ0X\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=miloka123;DATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=SPNZ0X\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=miloka123;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
anything missing?/btw is that the ini should i check for my sh_shard no beeing connect propelly with DB?


change COMPUTERNAME to YOUR COMPUTER NAME
YAYgot it working
[Only registered and activated users can see links. Click Here To Register...]
thanks for this guide
btw now i wanna know how to change my name for [GM] and do you know any gm command? like spawns etc? i tryed changing name in SMC aint working
my computer name is COMPUTERNAME ... and SQL name
and i think my ini file is correct or?

i dont believe it , where is my fcking problem ?
10/26/2011 14:00 379332#593
any clue how to work with hamachi? i did set it up and i enter client try to connect image code does not appear
10/26/2011 14:56 wolff66#594
next error -.-
[Only registered and activated users can see links. Click Here To Register...]
How to fix it ?
10/26/2011 17:40 vorons#595
[Only registered and activated users can see links. Click Here To Register...]
Help!!! Guys please

Guys ! Help please !!! Add my skype . i show my problem ! Pleeeeeease
My skype : warrenonn1
10/27/2011 03:51 TheSoulTrack#596
Who can help me all it's ok but my server appears like check

i read that we must go in smc ,server control, right click on shard and check change operating service type operating

but it doesn't work
10/27/2011 15:17 Blinki12#597
[Only registered and activated users can see links. Click Here To Register...]
I dont see my problem ..
Why says my SR_SHARDManager DB connection fail?
help me pls
10/27/2011 18:16 nitrogino#598
Query Error!!! Query Result : -1, Query : select * from SK_SilkChange_BY_Web

Query Error!!! Query Result : -1, Query : update _Shard set nStatus = 0, nCurrentUserRatio = 0 where nID = 64 pleaseeeeeeee
10/27/2011 19:53 sonyBlack1982#599
hi all what ist the problem ODBC
[Only registered and activated users can see links. Click Here To Register...]
10/27/2011 20:01 wolff66#600
Can just someone help me ? when i fix one error then i will get 2 error more :/
anyway :
[Only registered and activated users can see links. Click Here To Register...]
i checked my ini files and there dont have any problem