PS_Game: DB gamedef connect error (Ep 5.4)

AngelDeadly · 09/25/2021, 00:17

Hello,

I began to create my own local server, eventually extend it in the future to play with some friends.

My client 5.4 was taken from

.

And SHAIYA_SERVER files from

.

I managed to start all the services excepting game and gamegroups01, I'll comment every step I've made so far.

LOGS of ps_game

Spoiler

Service Account (Or the account that's linked to the Server has the basic credentials: Username:Shaiya, Psswd: Shaiya123). The account also has all of the SQL server roles over the Shaiya DB files.
I used the password encrypt found in the Server folder to encrypt the password and use it for the .ini files in the following path D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Config

Ports 30800 and 30810 (for Game) & Ports 1433 and 1434 (SQL DB) are open for Inbound in Firewall.
IP address was changed for game.exe using HxD.
SQL Server Configuration Manager has all the protocols enable and IP addresses are 127.0.0.1 for TCP/IP and Named Pipes.

PS_GAME.INI

Spoiler

========= ============ =========== ========= ========

UPDATE

Changed my server files and client. However I'm seeing a new error.
Decrypted my NpcQuest.sdata with LPH and added it to /bin/data.
Older NpcQuest file had wrong characters. Tho there are other files that can't be decrypted even with LPH like KillStatus.sdata. Still having the same issue even after adding new NPCQuest.sdata file to the above path.
I even tried to add .sdata files into SQL Database (thinking that it could be caused by the fact that there's a conflict between values of similar/identical files)
Not even after injecting .sdata files from data.saf into SQL Database, the Game and GameGroup01 didn't start. Services are still on pause. Please check the error below.

Spoiler

Visual Studio Debugger:
The thread tried to read from or write to a virtual address for which it does not have the appropriate access. ExceptionCode: 0xC0000005

============== ============= =========== ==========

P.S. I believe this could be related to OS as there are many dll files found in System32 folder.

TO BE MENTIONED:

SQL DB: SQL 2008 R2 (Using 2008 as I didn't had time to attach and detach DB to use a newer version and these .mdf server files are only compatible with 2008 R2)
SQL SSM: Latest in 24/09/2021
OS: Windows Server 2019 Datacenter
Hosted on a virtual machine (using Hyper-V)

I appreciate any help. Thank you in advance!

AngelDeadly · 09/26/2021, 23:19

Issue Fixed. Please close the topic.

For the first error. I had to use the public IP address to fix the game service. I was using my local IP address which was stopping my game service to start.
Steps: Go to your Bin folder in PSM_Client and edit your psgame.ini and edit the GamePublic to your Game IP Address. Mine was 127.0.0.1

For the second issue. I had to reinstall my SQL, redo the entire process, encrypt psswd, etc.. which made my game service start.

Best of luck, hope my resolution helps you in the future.

Dopeeeassd · 10/05/2021, 17:12

Can you show step by step how you did it ? im haveing issues startingt the Gamegroups01 and Game, all other services are running

almayfelipe12 · 04/29/2023, 07:02

Quote:

Originally Posted by Dopeeeassd

Can you show step by step how you did it ? im haveing issues startingt the Gamegroups01 and Game, all other services are running

Lo solucionaste ?