[Guide]How to Create 9.4 Server !

[ThunderNikk]

MD5 account passwords with MD5 Key + Password in your hash.

[ppse]

HI GUYS I have a problem signing in HE SAID THE USER NAME OR PASS IS UN CORRECT

[ThunderNikk]

Well the user name or password is probably incorrect.

Passwords for the database are entered MD5 hashed with the MD5 Key

So you hash Key+password MD5 and put it in the account table.

[StormPhoenix3]

Why does it say that after I download the SQL Server 2014 off of the media fire, it'll start to download in WinRAR, and then comes up in WinRAR and says that it was corrupt or that it had ended unexpectedly? Is this a me problem? lol

[ThunderNikk]

You should just download the latest SQL developer edition from Microsoft.

If you are downloading SQL server from media fire I am going to say it is a "You" issue.

[thefear511]

Originally Posted by StormPhoenix3

Why does it say that after I download the SQL Server 2014 off of the media fire, it'll start to download in WinRAR, and then comes up in WinRAR and says that it was corrupt or that it had ended unexpectedly? Is this a me problem? lol

its a winrar problem , get 7zip my friend. problem solved.

[Ginlace76]

Okay guys/gals, I followed everything in the video, and everything works great, However, when I get to step 6- running the game(client sided), I don't know how to build the folder, nor do I see the acc.sql shown in the video. Could someone guide me what folder I use for my files to be pasted into, and explain in simple terms the steps following? I would greatly appreciate it.

[MichaelPerro299]

Okay so i can get everything running but there is 1 problem,everytime i press m it crashes the game..can i possibly get help fixing it

[waahaha]

who have the multi client sframe.exe for 9.4?

[ThunderNikk]

Sframes are included in the release. You can allow multi clients with a command in the launcher.

[Ginlace76]

I will just start from the very beginning again I guess. 9.4 official folder to paste the files into and know which ones would be helpful. I know it says client, launcher, DLLs, and SFrame, but not knowing where the client is and launcher kind of creates an issue for me. I tried using a 9.4 from an existing pserver, but no matter what I did I failed. I read everything from this topic and from the other one labeled, [Release]9.4 Official Files, troubleshot everything, but nothing worked. So, back to the start, and maybe I will get lucky. Thanks for the help anyway.

[ThunderNikk]

Sorry Ginlace76 my answer was directed at waahaha who asked specifically about the sframe.

There really isn't anything special to building the client that isn't in the guide and that retail doesn't already do. We just do the same thing.

If you are looking for a client to run the most important thing is if you are going to run the game in English then use the ascii US client if you are going to run it in any other language then use the KTS client.

You can find the links to both clients in the collection thread...



Put the sframe from the server file release in the client replacing the one that is in there. US sframe for any other language aside from Arabic or Russian. Arabic sframe for Arabic. Russian sframe for Russian you will have to steal from another Russian private server.

Create a .bat file launcher with the game launch arguments just like the guide instructs you to do. This gets placed in the client folder and executed from there. Do not run the retail launcher in fact if the folder has one you should delete it right away to keep the game from updating.

You only need the DLL files provided if you are using the Arabic sframe. Those you place in the client folder as well. They would already exist in an Arabic client but I really haven't seen one of those shared around here.

[Ginlace76]

Thank you, that clears a lot up for me. I can see where I made a few mistakes trying to battle the task by myself. Very much appreciated.

Ok everything was setup, and all is well with the server connecting. When I try to log into the game it just stays there in idle. This is what I am seeing in netstat:

TCP 0.0.0.0:1433 LAPTOP-M909LAL6:0 LISTENING
[sqlservr.exe]
TCP 127.0.0.1:50007 LAPTOP-M909LAL6:0 LISTENING
[sqlservr.exe]
TCP 127.0.0.1:50007 LAPTOP-M909LAL6:54208 FIN_WAIT_2
[sqlservr.exe]
TCP 127.0.0.1:54208 LAPTOP-M909LAL6:50007 CLOSE_WAIT
[Sframe.exe]
TCP [::]:1433 LAPTOP-M909LAL6:0 LISTENING
[sqlservr.exe]
TCP [::]:2382 LAPTOP-M909LAL6:0 LISTENING
[sqlbrowser.exe]
TCP [::1]:50007 LAPTOP-M909LAL6:0 LISTENING
[sqlservr.exe]

Upon further investigation, I am getting an error from SQL Server - Management - SQL Server Logs - Current:

Date,Source,Severity,Message
08/06/2018 20:05:50,Logon,Unknown,Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library. [CLIENT: 127.0.0.1]
08/06/2018 20:05:50,Logon,Unknown,Error: 17836<c/> Severity: 20<c/> State: 17.

Any idea how to fix so I am able to get into my server?

[ThunderNikk]

You are using the sframe from the server files right?

[Ginlace76]

No, I received a stop responding error from both arabic and english sframes. SO I am using the volcanoSFrame.