{Guide/Release} SQL Server configuration For vsro files & Patches options

09/21/2011 18:53 badji#46
i have some questions what do i need to have installed on second machine?

im having this error on my main pc after opening shard_manager

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


thx in advanced
09/21/2011 18:58 Dr.Abdelfattah#47
Quote:
Originally Posted by badji View Post
i have some questions what do i need to have installed on second machine?

im having this error on my main pc after opening shard_manager

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


thx in advanced
check the guide , if u do all steps well then check ur firewall in ur Main machine was closed !!
09/21/2011 19:06 bibi_fr#48
Well ! No 1 can join the server when i launch it !

Im already connected on it but he stay on check status for who join by ip !

One idea?



[Only registered and activated users can see links. Click Here To Register...]
09/21/2011 19:10 Dr.Abdelfattah#49
Quote:
Originally Posted by bibi_fr View Post
Well ! No 1 can join the server when i launch it !

Im already connected on it but he stay on check status for who join by ip !

One idea?
check ur _PrivilegedIP table
ips and so
if u have only one ip
as ex : 127.0.0.1
so write 127 0 0 1 127 0 0 1
09/21/2011 19:10 badji#50
my firewall is off on both machines here is smc running


if you can help me in teamviewer i would aprecciat it

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

heres my shard ini


[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=AZ TEST SERVER
query=DRIVER={SQL Server};SERVER=CRIS-PC\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123 4;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=CRIS-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=1234;DATABASE= Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
09/21/2011 19:13 kalixxx#51
@abdelfattah
I downloaded clean DB from here:
[Only registered and activated users can see links. Click Here To Register...]
But i have Failed creation character ERROR when using this DB and on SR SHARD MANAGER i got this error:

2011-09-21 18:24:05 [SR_ShardManager] Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (2, 14896,'Diaz',67,26957,1466.000000,79.000000,1488.0 00000,19554,11632,11633,11634,10893,0,32,32,32,39, 0,0)}
2011-09-21 18:24:05 [SR_ShardManager] SQL Error State:23000, Native Error Code: 223, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Inventory__Items". The conflict occurred in database "SRO_VT_SHARD", table "dbo._Items", column 'ID64'.

2011-09-21 18:24:05 [SR_ShardManager] {?=CALL _AddNewChar (2, 14896,'Diaz',67,26957,1466.000000,79.000000,1488.0 00000,19554,11632,11633,11634,10893,0,32,32,32,39, 0,0)}
2011-09-21 18:24:05 [SR_ShardManager] SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
2011-09-21 18:24:05 [SR_ShardManager] {?=CALL _AddNewChar (2, 14896,'Diaz',67,26957,1466.000000,79.000000,1488.0 00000,19554,11632,11633,11634,10893,0,32,32,32,39, 0,0)}

On Old DB there is no problem. Do u know how to solve this problem?
09/21/2011 19:13 pezant#52
Quote:
Originally Posted by Dr.Abdelfattah View Post
Patch 3 & 3.1 & 4 & 4.1
hosted on 2 machines (can't host on vmware :( )
Hey Abdelfattah. First off thanks for the work you've done. I was just curious why it's not possible to host these servers on VMWare.
Thanks.
09/21/2011 19:14 Dr.Abdelfattah#53
Quote:
Originally Posted by badji View Post
my firewall is off on both machines here is smc running


if you can help me in teamviewer i would aprecciat it

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

heres my shard ini


[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=AZ TEST SERVER
query=DRIVER={SQL Server};SERVER=CRIS-PC\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123 4;DATABASE=SRO_VT_SHARD_INIT
query_log=DRIVER={SQL Server};SERVER=CRIS-PC\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=1234;DATABASE= Log_DB
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
give me teamview in private ..

Quote:
Originally Posted by kalixxx View Post
@abdelfattah
I downloaded clean DB from here:
[Only registered and activated users can see links. Click Here To Register...]
But i have Failed creation character ERROR when using this DB and on SR SHARD MANAGER i got this error:

2011-09-21 18:24:05 [SR_ShardManager] Query Error!!! Query Result : -1, Query : {?=CALL _AddNewChar (2, 14896,'Diaz',67,26957,1466.000000,79.000000,1488.0 00000,19554,11632,11633,11634,10893,0,32,32,32,39, 0,0)}
2011-09-21 18:24:05 [SR_ShardManager] SQL Error State:23000, Native Error Code: 223, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Inventory__Items". The conflict occurred in database "SRO_VT_SHARD", table "dbo._Items", column 'ID64'.

2011-09-21 18:24:05 [SR_ShardManager] {?=CALL _AddNewChar (2, 14896,'Diaz',67,26957,1466.000000,79.000000,1488.0 00000,19554,11632,11633,11634,10893,0,32,32,32,39, 0,0)}
2011-09-21 18:24:05 [SR_ShardManager] SQL Error State:01000, Native Error Code: E25, ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
2011-09-21 18:24:05 [SR_ShardManager] {?=CALL _AddNewChar (2, 14896,'Diaz',67,26957,1466.000000,79.000000,1488.0 00000,19554,11632,11633,11634,10893,0,32,32,32,39, 0,0)}

On Old DB there is no problem. Do u know how to solve this problem?
use old DB :D and use my guides to make it clean ;)


Quote:
Originally Posted by pezant View Post
Hey Abdelfattah. First off thanks for the work you've done. I was just curious why it's not possible to host these servers on VMWare.
Thanks.
files don't support vmware due of ports and so :)
09/21/2011 19:19 bibi_fr#54
Quote:
Originally Posted by Dr.Abdelfattah View Post
check ur _PrivilegedIP table
ips and so
if u have only one ip
as ex : 127.0.0.1
so write 127 0 0 1 127 0 0 1
hehe not understand xD

Im connected on Local but other want join my server get a Check status on server !
09/21/2011 19:21 Dropdead*#55
are you sure it wont work on VMware? I hosted a cabal online server on one, but dont know if its the same.
09/21/2011 19:23 pezant#56
Quote:
Originally Posted by Dropdead* View Post
are you sure it wont work on VMware? I hosted a cabal online server on one, but dont know if its the same.
Yeah I think it will work on VMWare too. I have my single Silkroad server working on there. I'll do some testing when I get home from work and try to make it work.
09/21/2011 19:27 kalixxx#57
@abdelfattah
But in your guide from here:
[Only registered and activated users can see links. Click Here To Register...]
U write:
Use this to prune all old character data from shard.

PHP Code:
//..basically you need to delete these manually.
Tryied to manual delete but then my GamServer dont run or crash or Creation character error. Are there any other guide how clean SHARD DB?
09/21/2011 19:36 Dr.Abdelfattah#58
Quote:
Originally Posted by bibi_fr View Post
hehe not understand xD

Im connected on Local but other want join my server get a Check status on server !
open just this table and u will under stand it's the way wich gateway server connect with this table and pick up puplic ip wich players will connect too ;)

Quote:
Originally Posted by kalixxx View Post
@abdelfattah
But in your guide from here:
[Only registered and activated users can see links. Click Here To Register...]
U write:
Use this to prune all old character data from shard.

PHP Code:
//..basically you need to delete these manually.
Tryied to manual delete but then my GamServer dont run or crash or Creation character error. Are there any other guide how clean SHARD DB?
i will make new one ;)
09/21/2011 19:36 Honnor#59
[Only registered and activated users can see links. Click Here To Register...]
what is problem?
09/21/2011 19:42 Dr.Abdelfattah#60
Quote:
Originally Posted by Honnor View Post
[Only registered and activated users can see links. Click Here To Register...]
what is problem?
check ur db info