|
You last visited: Today at 22:56
Advertisement
{Guide/Release} SQL Server configuration For vsro files & Patches options
Discussion on {Guide/Release} SQL Server configuration For vsro files & Patches options within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
09/21/2011, 18:53
|
#46
|
elite*gold: 0 
Join Date: Dec 2007
Posts: 138
Received Thanks: 25
|
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
thx in advanced
|
|
|
|
09/21/2011, 18:58
|
#47
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,374
|
Quote:
Originally Posted by badji
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
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
|
#48
|
elite*gold: 0
Join Date: Nov 2010
Posts: 516
Received Thanks: 117
|
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?
|
|
|
|
|
09/21/2011, 19:10
|
#49
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,374
|
Quote:
Originally Posted by bibi_fr
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
|
#50
|
elite*gold: 0
Join Date: Dec 2007
Posts: 138
Received Thanks: 25
|
my firewall is off on both machines here is smc running
if you can help me in teamviewer i would aprecciat it
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
|
#51
|
elite*gold: 0
Join Date: Jan 2008
Posts: 22
Received Thanks: 1
|
@abdelfattah
I downloaded clean DB from here:
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
|
#52
|
elite*gold: 0
Join Date: Nov 2008
Posts: 20
Received Thanks: 7
|
Quote:
Originally Posted by Dr.Abdelfattah
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
|
#53
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,374
|
Quote:
Originally Posted by badji
my firewall is off on both machines here is smc running
if you can help me in teamviewer i would aprecciat it
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
@abdelfattah
I downloaded clean DB from here:
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  and use my guides to make it clean 
Quote:
Originally Posted by pezant
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
|
#54
|
elite*gold: 0
Join Date: Nov 2010
Posts: 516
Received Thanks: 117
|
Quote:
Originally Posted by Dr.Abdelfattah
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
|
#55
|
elite*gold: 20
Join Date: Jan 2009
Posts: 3,560
Received Thanks: 2,814
|
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
|
#56
|
elite*gold: 0
Join Date: Nov 2008
Posts: 20
Received Thanks: 7
|
Quote:
Originally Posted by Dropdead*
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
|
#57
|
elite*gold: 0
Join Date: Jan 2008
Posts: 22
Received Thanks: 1
|
@abdelfattah
But in your guide from here:
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
|
#58
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,374
|
Quote:
Originally Posted by bibi_fr
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
@abdelfattah
But in your guide from here:
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
|
#59
|
elite*gold: 0
Join Date: Jun 2011
Posts: 11
Received Thanks: 0
|
what is problem?
|
|
|
|
|
09/21/2011, 19:42
|
#60
|
elite*gold: 7
Join Date: May 2010
Posts: 2,115
Received Thanks: 2,374
|
Quote:
Originally Posted by Honnor
what is problem?
|
check ur db info
|
|
|
|
Similar Threads
|
[Guide + Request Help ] Vsro Server Files Setup ..
03/26/2012 - SRO Private Server - 55 Replies
http://img10.imageshack.us/img10/7995/22941482.jpg
srGlobalOperation.ini
count=1
id=20
operation_type=22
name=SRO_Vietnam_TestLocal 0
|
[Release]PoPNetwork-Server Files Configuration
10/12/2010 - Flyff PServer Guides & Releases - 8 Replies
Hallo leute habe mal wieder was gebastelt und zwar einen Server Files Configurator. Da könnt ihr alles einstellen was ihr wollt.
DLink: HIER
Virustotal: HIER
Ich hoffe euch gefällt das Tool bei neuen Updates könnt ihr einfach per Check Update, Updaten!
|
All times are GMT +1. The time now is 22:58.
|
|
