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

10/04/2011 05:00 MaryoHacker#271
You really deserve to be Thanked for this ,, TY BRO !!! <3
10/04/2011 05:05 vnzla#272
Quote:
Originally Posted by ahmedpepo View Post
i have carsh from
SR_GameServer
any one help
RefRegionBindAssocServer
CHINA 1
TQ 1
West_China 1
Oasis_Kingdom 1
Thief Village 1
Roc 1
Eu 1
Am 1
Ca 1
SD 1
KingsValley 1
Pharaoh 1
DELTA 1
TEMPLE 1
FORT_JA_AREA 1
FORT_DW_AREA 0
FORT_HT_AREA 1
FORT_CT_AREA 0
FORT_SK_AREA 0
FORT_BJ_AREA 1
FORT_HM_AREA 1
FORT_ER_AREA 1
ARENA_OCCUPY 1
ARENA_FLAG 1
ARENA_SCORE 1
SIEGE_DUNGEON 1
ARENA_GNGWC 0
GOD_TOGUI 1
GOD_WRECK_IN 1
GOD_FLAME 1
GOD_WRECK_OUT 1
EVENT_GHOST 0
JUPITER 0
PRISON 0
GM_EVENT 0
disable TQ = 0 and try
10/04/2011 06:52 ahmedpepo#273
Quote:
Originally Posted by vnzla View Post
disable TQ = 0 and try
Not Work
Ty For Help
10/04/2011 07:05 6_lucifer_6#274
hmm i changed my shard.ini .. and now shard is crashing every 2-3 seconds..

Quote:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=123456;D ATABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=sa;PWD=12345 6;DATABASE=SRO_VT_SHARDLOG
capacity=20
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...]

how do i fix it?
10/04/2011 07:17 liquidknight#275
Excellent guide. Finally had the time to try it out and it works perfectly.:handsdown:

6_lucifer_6 Try this.
Quote:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=12345 6;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
10/04/2011 07:23 6_lucifer_6#276
how do i fix this??

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

here is my shard ini

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=pass;DAT ABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=pass;DATABASE= Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
10/04/2011 11:45 smedheaddk#277
Quote:
Originally Posted by 6_lucifer_6 View Post
how do i fix this??

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

here is my shard ini

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=pass;DAT ABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=pass;DATABASE= Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=pass;DAT ABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=pass;DATABASE= Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
10/04/2011 13:57 zikor1337#278
Quote:
Originally Posted by 6_lucifer_6 View Post
how do i fix this??

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

here is my shard ini

[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=sa;PWD=pass;DAT ABASE=SRO_VT_SHARD
query_log=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=pass;DATABASE= Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SroLand
query=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=pass;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=ROMKA-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=pass;DATABASE=Log_DB
capacity=20
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
if you used the same db names I used in the guide.

But, your error is not from the Database. Your billing server is dead. That means your server.cfg is fucked up or you didn't installed IIS as I did in the guide.

First try to use the srShard.ini that I gave you. If it doesn't work, then it is the IIS.
10/04/2011 14:10 baddarkness#279
ok i am working on widows 7 32 bit
have 3 ram and procesador corel quad 2.8
i have alredy post this like 15 times no one can find a solucion
dont tell me is obdc because i have 3 obdc for all data base
create and its working perfect it say sucessfuly ...
so now pliss tell what is the problem i already do over the server like 15 times and is not working
pliss help me if you can
sorry for my bad english!!
[Only registered and activated users can see links. Click Here To Register...]
10/04/2011 14:20 zikor1337#280
Quote:
Originally Posted by baddarkness View Post
ok i am working on widows 7 32 bit
have 3 ram and procesador corel quad 2.8
i have alredy post this like 15 times no one can find a solucion
dont tell me is obdc because i have 3 obdc for all data base
create and its working perfect it say sucessfuly ...
so now pliss tell what is the problem i already do over the server like 15 times and is not working
pliss help me if you can
sorry for my bad english!!
[Only registered and activated users can see links. Click Here To Register...]
your pc is too weak .

Also... make a screen with the whole error ...
10/04/2011 15:06 baddarkness#281
Quote:
Originally Posted by zikor1337 View Post
your pc is too weak .

Also... make a screen with the whole error ...

ohh my pc is to week thats wy my frend run a server on a dual corel wit 2 gigas ram y and i am 2 times his pc and get this eror ?

Quote:
2011-10-04 08:40:23 [GlobalManager] server cord established : 1 (190.37.226.119:32000)
2011-10-04 08:40:23 [GlobalManager] GlobalManager is initialized successfully
2011-10-04 08:40:26 [GlobalManager] server cord established : 2 (190.37.226.119:55180)
2011-10-04 08:41:23 [GlobalManager] server cord established : 5 (190.37.226.119:55186)
2011-10-04 08:41:25 IBUV: StringSize: 1, CharSet: ABCDEF1234567890
2011-10-04 08:41:25 IBUV: CharSet(ABCDEF1234567890)
2011-10-04 08:41:25 IBUV: Preserved image created : (dwImageCount)
2011-10-04 08:41:26 [GlobalManager] server cord established : 6 (190.37.226.119:55187)
2011-10-04 08:41:28 [GlobalManager] server cord established : 7 (190.37.226.119:55188)
2011-10-04 08:41:29 [FarmManager] server cord established : 1 (190.37.226.119:15880)
2011-10-04 08:41:29 [FarmManager] FarmManager is initialized successfully
2011-10-04 08:41:31 [FarmManager] server cord established : 2 (190.37.226.119:55189)
2011-10-04 08:41:31 [AgentServer] server cord established : 1 (190.37.226.119:15882)
2011-10-04 08:41:31 [AgentServer] AgentServer is initialized successfully
2011-10-04 08:41:33 [FarmManager] server cord established : 3 (190.37.226.119:55192)
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-10-04 08:41:33 [SR_ShardManager] server cord established : 1 (190.37.226.119:15882)
2011-10-04 08:41:33 [SR_ShardManager] server cord established : 2 (190.37.226.119:55191)
2011-10-04 08:42:03 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:05 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:07 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:09 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:10 [SR_ShardManager] Query Error!!! Query Result : -1, Query : SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-10-04 08:42:10 [SR_ShardManager] SQL Error State:42000, Native Error Code: AD7, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The code page 949 is not supported by the server.

2011-10-04 08:42:10 [SR_ShardManager] SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-10-04 08:42:10 [SR_ShardManager] SQL Error State:42000, Native Error Code: 4231, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
2011-10-04 08:42:10 [SR_ShardManager] SELECT AssociationCodeName,Reputation,PriorOccupation FROM _AssociationReputation WHERE AssociationCodeName = 'TraderHunter' and AssociationTypeName = 'TEMPLE_ANUBIS'
2011-10-04 08:42:11 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:13 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:15 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:17 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:19 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:21 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
2011-10-04 08:42:23 [AgentServer] cannot establish keep alive session : 190.37.226.119 15885 (bind 0.0.0.0)
pliss tell me a good solucion !!
10/04/2011 15:27 caine_neros#282
Okay i got a little thing ... Certification instant closes -.-" What should i do ? i did all the thing's ..
10/04/2011 16:19 sarkoplata#283
I repeat ... I Can't find IIS Console on my windows turn features on or off !
I use win7 ultimate x64
10/04/2011 16:28 sjuk987#284
I can login to my sro, i play everything looks fine, but my friend can't. He get C9, can anybody help me?? I use hamachi :)
10/04/2011 16:33 zikor1337#285
Quote:
Originally Posted by sjuk987 View Post
I can login to my sro, i play everything looks fine, but my friend can't. He get C9, can anybody help me?? I use hamachi :)
Your or His Hamachi settings are the problem .