Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
Larkon
Cherno i will post what I have for billing and srShard.ini database connection/odbc
If i put this in my browser "
http://192.168.x.x:8080/ " of course with my ip. It will show this
Code:
HTTP Error 403.14 - Forbidden
The Web server is configured to not list the contents of this directory.
Is my first time using IIS so , if the site is not supposed to show that than im doing something wrong.
Shar.ini
Code:
[global]
count=1
[entry0]
id=64
global_operation_id=20
operation_type=22
name=SRO
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARD;UID=ihavemyusernamehere;PWD=andmypasswordhere;DATABASE=SRO_VT_SHARD
query=DRIVER={SQL Server};SERVER=DAYAN-PC\SQLEXPRESS;DSN=SRO_VT_SHARDLOG;UID=myusernamehere;PWD=andmypasswordhere;DATABASE=SRO_VT_SHARDLOG
capacity=1000
shard_manager_node_id=705
u1=240
u2=208
u3=17
u4=1
u5=0
u6=0
u7=0
When it comes to ODBC. I have setup all 3 odbc with " SQL SERVER" each to its individual database.
I just cant seem to figure out whats the problem.
For DBCONNECT.ASP
Code:
<%
Dim DBConnA, strConnectA
Set DBConnA = Server.CreateObject("ADODB.Connection")
strConnectA = "Provider=DAYAN-PC\SQLEXPRESS;Data Source=192.168.x.x;Initial Catalog=SRO_VT_ACCOUNT;user ID=mydatabaseusername;password=mydatabasepassword;"
DBConnA.Open strConnectA
%>
of course with my ip again.
Leave data provider as it was, change Source to DAYAN-PC\SQLEXPRESS.
Re: [Guide] Setting up a server based on VSRO server files
Temple : Reputation Check Faild ! - CShardSJ_TempleOfAnubisAndIsisGate
And SR_ShardManager crash...=\
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
stemale
Temple : Reputation Check Faild ! - CShardSJ_TempleOfAnubisAndIsisGate
And SR_ShardManager crash...=\
Full log, please.
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
Chern0byl
Full log, please.
can u answer my questions ?:blush:
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
Chern0byl
Full log, please.
Quote:
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:39 [FarmManager] server cord established : 21
2011-09-13 22:56:39 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] Schedule Manager : g_pServerBodyOfMyself is NULL !!
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 1
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 2
2011-09-13 22:56:40 [SR_GameServer] server cord established : 15 (
2011-09-13 22:56:40 [SR_ShardManager] server cord established : 3
2011-09-13 22:56:40 [AgentServer] server cord established : 15
2011-09-13 22:57:29 [SR_ShardManager] SR_ShardManager is initialized successfully
2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!
2011-09-13 22:57:30 [AgentServer] 705:SR_ShardManager is blind : 0 users are banned
2011-09-13 22:57:30 [SR_GameServer] server cord closed : 15
2011-09-13 22:57:30 [FarmManager] server cord closed : 21
i think this is it
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
Chern0byl
Leave data provider as it was, change Source to DAYAN-PC\SQLEXPRESS.
I did that , this shardmanager sure really does not want to open at all.. :grr: . Just instantly closes.
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
stemale
i think this is it
2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!
Re: [Guide] Setting up a server based on VSRO server files
Re: [Guide] Setting up a server based on VSRO server files
Chern when u have a chance , come to teamviewer pretty quick and take a look at this shard. I've done all that you've told me. yet it wont open.
Am i missing a "billing.ini" or "billin.cfg" file that im supposed to have ? Cause I dont have it.
Anyways Teamviewer ID : 912 180 783 PAss: 2110
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
saxz
Change shard state to Operating, and yep, then you will be able to log in.
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'CREATE'.
this query giving me this error
Quote:
USE [Silkroad]
GO
/****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
drop table_PrivilegedIP
CREATE TABLE [dbo].[_PrivilegedIP](
[IP1] [tinyint] NOT NULL,
[IP2] [tinyint] NOT NULL,
[IP3] [tinyint] NOT NULL,
[IP4] [tinyint] NOT NULL,
[IP5] [tinyint] NOT NULL,
[IP6] [tinyint] NOT NULL,
[IP7] [tinyint] NOT NULL,
[IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
Chern0byl
Change shard state to Operating, and yep, then you will be able to log in.
sorry for noob Q
BUT HOW I DO IT!
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
Chern0byl
2011-09-13 22:57:29 [SR_ShardManager] BillingServer is Dead!!
Yea but how now i can know what a problem ?
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
saxz
sorry for noob Q
BUT HOW I DO IT!
Right click shard service, and search for "Change Service Type -> Operating".
Re: [Guide] Setting up a server based on VSRO server files
Quote:
Originally Posted by
Chern0byl
Right click shard service, and search for "Change Service Type -> Operating".
Thx!...........
