Hi ,
for people who still asking about how to start server files without errors -not all but most- (except shop + SBServer)
here is the steps i followed
1. go to ODBC then at file DSN select the servers folder then click set Directory
2.download the attached DSN files and put it in the previously selected folder.
3. on each file named config.json change 192.168.1.3 to your ip or set your ip static to 192.168.1.3
4.in login server and cache server in config.json at SBLog line change port from 11000 to 12900
also change sblog port
****
for relay server
config.json
PHP:
// My SBRelay ID. "relay_server_id" : 2
relayInterConnect.json
PHP:
{"root" :{ "relay_server_list" : [ { "try_to_connect" : true, "relay_server_id" : 2, "relay_host" : "192.168.1.3", "relay_port" : 12777 } ]}}
****
PHP:
// Remote address to connect to the SBLog.
"remote_address" : "192.168.168.1.3:12900"
5. for local setting you don't need smtp settings to you may disable it
PHP:
// Whether to enable smtp reporting on crash.
"enable_smtp_report" : false
6. you need to use SQL Native v 10.0 not 11.0 (looks like 11.0 does not support bcp connection idk) , download it from here:
You must be registered to see links
choose "sqlncli_x86.msi then install it
7.there are few missing procedure in eos_common_report ( i assume it here
tt1: )
here is it's structure at least to prevent error from showing recursively.
btw there will be another error about bulk insertion object not found like this
PHP:
ERROR: SQLSTATE=[42S02], Native error=[208], msg=[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'L2017_03_14_CHAT'.
ERROR: SQLSTATE=[42S02], Native error=[208], msg=[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name 'L2017_03_14_GAME'.
but at least it will not exhaust the CPU
anyway here are the procedures
STRUCTURE ONLY
PHP:
USE [eos_common_report]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SB_InsertTextLog]
@a int, @b nvarchar, @c nvarchar, @d nvarchar
AS
BEGIN
SET NOCOUNT ON;
END
PHP:
USE [eos_common_report]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SB_CreateChatLogTable]
@a nvarchar
AS
BEGIN
SET NOCOUNT ON;
END
PHP:
USE [eos_common_report]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SB_CreateFormattedLogTable]
@a nvarchar
AS
BEGIN
SET NOCOUNT ON;
END
PHP:
USE [eos_common_report]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[SB_CreateTextLogTable]
@a nvarchar
AS
BEGIN
SET NOCOUNT ON;
END
8. now before start splog server delete crashreport and log folder (it's some how related to some errors appears at sblog)
9.delete the config.ini (it will be auto configured and created) then start server , when it ask for dsn enter the appropriate dsn file name , for the chat server you need two dsn files so in first dialog enter EOS_CHAT_SERVER and in the second dialog enter EOS_CHAT2_SERVER
about SBMobile there are some missing settings under Root.Server if someone could provide it ...
btw when you close servers make sure its really closed not works as hidden process (kill it from task manager)
thats all for now ^_^
---
need a solution for SB Server
cache & relay are properly configured only this server does not connect , also where to change 0.0.0.0 ip for cache server at sbserver config !!!