VSRO Server Files [v188]

[whhacker93]

Re: Complete VSRO Server Files(Shared from Chern0byl)

In your cert folder you have 2 ini's that need to be correct. One is the srGlobalService (Globalmanager.exe) and the other is the srShard (SRShardManager). The global should point to your account database. The Shard Manager should point to the Shard and Log databases.

It's correct. It just doesn't wanna be nice and connect for me =(

As for the ODBC does it have to be SQL Server Driver or SQL Native Client 10.0 Driver

EDIT: I'm using MSSQL 2008 Express (r2) So i would presume that it would either be sql server or the sql native client (10.0)

 

[kofta01]

Re: Complete VSRO Server Files(Shared from Chern0byl)

guys i am using windows 7 32bit . my problem is much easier than yours . when i setup MSSSQL 2008 express r2 or 2005 or any version it dont want to setup correctly i mean i find no tools or the studio . any idea how can i pass that ?

 

[KunKuTe]

Re: Complete VSRO Server Files(Shared from Chern0byl)

i need use SQL Server version?
plz answer me

 

[whhacker93]

Re: Complete VSRO Server Files(Shared from Chern0byl)

i need use SQL Server version?
plz answer me

It works on all versions as far as we know. So any one it doesn't matter.

EDIT: I'm going to be up all night n day until i get this working. So Cigarettes and coffee should work.

 

[rogan12]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Cert problems remains for me.
I still haven't figured out how to create the node by myself.
Is there anyone who can put a light on this mystery ?

regards
rogan12

 

[whhacker93]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Cert problems remains for me.
I still haven't figured out how to create the node by myself.
Is there anyone who can put a light on this mystery ?

regards
rogan12

I wish i could help bro.

The only thing i don't get is some people ALREADY got this working so why is everyone having problems getting it up. Not to mention every that has isn't helping.

 

[rogan12]

Re: Complete VSRO Server Files(Shared from Chern0byl)

I wish i could help bro.

The only thing i don't get is some people ALREADY got this working so why is everyone having problems getting it up. Not to mention every that has isn't helping.

I am not sure about this but i think it's custom on epvp , to call people who need help for noobs. Phrases like " use your'e brain " is also seen on daily bases there, so my source is telling me. ( In fact we all use our brain's, and we all have skills somehow that others don't have, and there is nobody so perfect to be able to do everything alone )
But i have hope, that those people who join us here on rz, will change their attitude, and begin to be helpful.

Enough said. Back to testing, sort of. I'm stuck now with cert.
regards
rogan12

 

[kofta01]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Someone help me . i just face that problem after it i can do everything on my own :s

 

[whhacker93]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Someone help me . i just face that problem after it i can do everything on my own :s

I would help you right now but I'm working on my own problem at the moment.

 

[kofta01]

Re: Complete VSRO Server Files(Shared from Chern0byl)

i just need a help how can i setup the MMSQL with no mistakes or to download a right version . maybe i can help in those stuff but when i begin to see it :S

 

[rogan12]

Re: Complete VSRO Server Files(Shared from Chern0byl)

i just need a help how can i setup the MMSQL with no mistakes or to download a right version . maybe i can help in those stuff but when i begin to see it :S

I use MSSQL 2008 express. Just download that. If your'e windows is x64 then take the x64 version of it.
About ODBC connection it works both, sql client and server. I use sql server in my odbc connection.

Btw, if you got x64 windows, then you have both a 64 bit ODBC and ODBC32.
I don't know which one the original server is intended to use, so make the connections in both.

regards
rogan12

 

[seppel2k]

Re: Complete VSRO Server Files(Shared from Chern0byl)

you must set the ports correctly in your server.cfg

 

[MaximumSatan]

Re: Complete VSRO Server Files(Shared from Chern0byl)

I did set my ports to the ones in the readme in customcert. Still wont connect.

 

[rogan12]

Re: Complete VSRO Server Files(Shared from Chern0byl)

I fixed cert, so i can open Global Manager but when i try open Gateway Server or Download Server;

cannot certify server body : [GatewayServer][x.xxx.xxx.xxx]

you must set the ports correctly in your server.cfg

How did you add the node, or are you using the old ini files ?
Post solution here.

regards
rogan12

 

[Nah001]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Skellyhand your problem is odbc add this to registry and DSN names add in System Dsn as Sql driver

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_ACCOUNT]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_ACCOUNT"
"LastUser"="sa"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_LOG]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_LOG"
"LastUser"="sa"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_SHARD]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_SHARD"
"LastUser"="sa"
"Trusted_Connection"="Yes"

 

[LegendaryDev]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Missing procedure and table


ShardDB _ExistsServiceOffRentItem Procedure

Spoiler

USE [SRO_VT_SHARD]
GO

/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end


GO

AccountDB SK_gamebang_ip

Spoiler

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[SK_gamebang_ip] Script Date: 09/13/2011 12:05:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SK_gamebang_ip](
[ip] [int] NULL,
[capacity] [int] NULL
) ON [PRIMARY]

GO

 

[rogan12]

Re: Complete VSRO Server Files(Shared from Chern0byl)

@LegendaryDev

Thx for it.
Care to tell how to fix cert ? How do i fix the node thingy ?

regards
rogan12

 

[Y@$$ER LOTFY]

Re: Complete VSRO Server Files(Shared from Chern0byl)

I fixed cert, so i can open Global Manager but when i try open Gateway Server or Download Server;

cannot certify server body : [GatewayServer][x.xxx.xxx.xxx]

Nice
If my .ini files works with you
so here is a link for rogan

You must be registered to see links

​

 

[whhacker93]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Skellyhand your problem is odbc add this to registry and DSN names add in System Dsn as Sql driver

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\ODBC Data Sources]

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_ACCOUNT]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_ACCOUNT"
"LastUser"="sa"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_LOG]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_LOG"
"LastUser"="sa"
"Trusted_Connection"="Yes"

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\SRO_VT_SHARD]
"Driver"="C:\\Windows\\system32\\SQLSRV32.dll"
"Server"="your name"
"Database"="SRO_VT_SHARD"
"LastUser"="sa"
"Trusted_Connection"="Yes"

Already tried that

 

[ekizde]

Re: Complete VSRO Server Files(Shared from Chern0byl)

Missing procedure and table


ShardDB _ExistsServiceOffRentItem Procedure

Spoiler

USE [SRO_VT_SHARD]
GO

/****** Object: StoredProcedure [dbo].[_ExistsServiceOffRentItem] Script Date: 09/13/2011 12:03:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE procedure [dbo].[_ExistsServiceOffRentItem]
as

if( exists (select * from _Items with (nolock) where RefItemID in (select RefItemID from _RefRentItem where Service = 0 ) ) )
begin
return -1
end


GO

AccountDB SK_gamebang_ip

Spoiler

USE [SRO_VT_ACCOUNT]
GO

/****** Object: Table [dbo].[SK_gamebang_ip] Script Date: 09/13/2011 12:05:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SK_gamebang_ip](
[ip] [int] NULL,
[capacity] [int] NULL
) ON [PRIMARY]

GO

did u got the missing procedure "_AddCurrentUserCount"?

btw, thanks for _ExistsServiceOffRentItem sp.


pd: at sk_gamebang_ip, should i change ip - int to ip - varchar(15)?