Need help, i have a problems with server

Oyuba · 08/01/2015, 16:07

Hello everyone, I have a problem with the server. When I try to connect to open the game client. I can not open the game.exe because the server does not work, can you help me please?

P.S If there is already a debate like this, sorry I have not seen.

[ADM]Lightning · 08/02/2015, 00:34

Well start of with telling us about your test server. Is it episode 4 or 5. What exactly does the error say if one pops up. You can screenshot what it does or doesn't do.

So lets assume you installed the right SQL server example 2008R2 or 2012. Then lets assume you properly enabled the the named pipes and etc in the SQL configuration tool and changed the IPs to 127.0.0.1, we will then assume that you changed the IP addresses properly in the PSM_Client/Bin/Config to 127.0.0.01. We will then assume that you changed the IP in the game.exe using a hex editor and saved that.

So if that is all done and your using the right db, serverfiles and client. What do your logs show?

Oyuba · 08/02/2015, 02:51

When I open PSMServer_Mgr and go to "Start All Service Server" nothing happens, do not turn on the server, I ritentanto many times with SQL 2008 and 2012, but nothing.They do not activate it "Server Service".

[ADM]Lightning · 08/02/2015, 03:08

you have to install them to get them to start.

Are they red X's or green II?

Oyuba · 08/02/2015, 10:55

II are green, but even if I try to turn back immediately so II sometimes not activated

P.s Sorry, My english is not good

[Alcatraz] · 08/02/2015, 19:21

there a lot of things that could be wrong but if you followed the guide release here to a T you shouldn't have any problems if your having problems that usually means you missed something or over looked something ill post my guide here maybe it will help

this is my guide for my server files that work with sql 2014 and ep5 youll have to use what ever sql your server was built to be ran for.

Spoiler

hope this was helpful to you I spent a little time running into problems myself and this was the best way I found so far to install a server and pretty much get it right the first time installing it.

Oyuba · 08/02/2015, 22:51

Thank you for guidance, let you know if everything is okay. But, it works on Windows 8.1?

SnickQ · 08/02/2015, 22:57

Can you connect to your sql server with sql auth?

Big_ · 08/03/2015, 00:13

He needs to add privligas for the database account

Oyuba · 08/03/2015, 00:54

Quote:

Originally Posted by Big_

He needs to add privligas for the database account

privligas ??

Quote:

Originally Posted by [Alcatraz]

there a lot of things that could be wrong but if you followed the guide release here to a T you shouldn't have any problems if your having problems that usually means you missed something or over looked something ill post my guide here maybe it will help

this is my guide for my server files that work with sql 2014 and ep5 youll have to use what ever sql your server was built to be ran for.

Spoiler

Step 1: Extracting ShaiyaServer Folder
- Extract the Folder from the zipped C:\ (C:\ShaiyaServer) ok

Step 2: Attaching Database Files to your SQL Server
You Must have sql 2014 installed before beginning this there are How To on how to properly install the sql on elite pvpers just do a search for it but after you have all that installed you want to open Microsoft SQL Server Management Studio as a ADM from there you need to click on databases right click then goto attach and attach all databases in the "c:/shaiyaserver/database/" folder

- inside Server Management studios you want to right click on "logins" then select new login then add a login name that you will later add into the server files, then click on SQL Server Authentication and add the passwords you used on the sql install make sure only the "Enforce Password Policy" box is checked and no others on the General Tab then click the Server Roles Tab and only have checked "Public" and "Sysadmn" the click ok

- Now go to your ShaiyaServer main folder, inside there is a file called "SQL New Installation.sql". Please open this file (if you install SMSS, it will open the file automatically in the SMSS, or else just manually open this files in notepad or something then copy and paste it on a new query ). From here please edit any text with 'your-db-username' to your db admin name and 'your-db-userpassword' to your db Admin password. Once you done that, just excute the query.

Step 3: Adding your DataBase Username, Password, and Game Name
- now you want to go and check each ini file in every folder you want to Change Shaiya to your Username and the long numbers after it need to be your encrypted password you can make a encrypted password by opening the ps_passwordEnc.exe in the PSM_Server folder just add your password and copy the numbers it creates also you want to change the Name of "Game" to your server name this will be shown after you login to the client and dont forget to save each ini file.

Step 4: Running your ShaiyaServer
- Go to your ShaiyaServer folder. Run the shaiya_svc_register.bat as A Admn
- now goto The psm_client folder inside the shaiyaserver folder and run as admn "PSM_AgentInstall.exe" that will open a new window click Apply windows Registry and close it
- ok that is done now goto PSM_Server and open as admn PSMServer_ServiceMgr.exe once that is open click install and then click start
- next go back to PSM_Client folder and Open as admn PSM_ServiceMgr.exe and install everything with a (X) by it but not the ps_gamewar and close it
- now go back to PSM_Server folder and open up the PSMServer_Mgr.exe you should see All Green Pause icons by all services we installed if you dont then you did something wrong and need to go back and rework the steps again

Next is:
- go to Control Service > and Select Start All Server Service.

Finally is:
Related version of the verification
now click on Login01 then right click on it and then click command now a new window will open here you want to type "/vchkoff" and then hit enter
Next you want to click on Game then right click goto command then type "/nprotectoff" and hit enter

Finally your server should be up and running but 1 last think you need to get cheat engine and get lilprohacker's skills +3 fix and follow the instructions on how to do it otherwise your skills will bug at lvl 3

hope this was helpful to you I spent a little time running into problems myself and this was the best way I found so far to install a server and pretty much get it right the first time installing it.

No, I did not succeed. The service servers are all so II
Maybe I'm wrong procedure? There is a video of this guide?

wallerus · 08/03/2015, 03:46

It's more than likely the server can't connect to your database.

Quote:

Originally Posted by abrasive

Services go to a green arrow, but then back to pause
This usually means the services were unable to connect to the database. Check your logs in D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Log and D:\SHAIYA_SERVER\SERVER\PSM_Client\Log. These logs help tell you of problems with services starting, so keep that in mind for future problems.

Quote:

Originally Posted by SnickQ

Can you connect to your sql server with sql auth?

See SnickQ's post and see if you can log into the database using:
Login: Shaiya
Password: Shaiya123

Let us know if you are successful at doing that.

[Alcatraz] · 08/03/2015, 07:14

big is talking about when you go and create the account in the security folder for example if your using Shaiya as the account name and Shaiya123 as the password you also have to goto the server roles and check the sysadmn box

like so some screen shots off my home test server

double click to open the settings

treica · 08/03/2015, 09:42

It looks more like you're not having the linked servers try running this query :

Code:

if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'USER_SQL_SERVER','PASSWORD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'USER_SQL_SERVER','PASSWORD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'USER_SQL_SERVER','PASSWORD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'USER_SQL_SERVER','PASSWORD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_DEFINEDB')
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'USER_SQL_SERVER','PASS WORD_SQL_SERVER'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_GAMEDB01')
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'USER_SQL_SERVER','PASSWORD_SQL_SERVER'

Make sure to change where USER_SQL_SERVER and PASSWORD_SQL_SERVER with your database login credenials.

Oyuba · 08/03/2015, 11:26

Quote:

Originally Posted by wallerus

It's more than likely the server can't connect to your database.

See SnickQ's post and see if you can log into the database using:
Login: Shaiya
Password: Shaiya123

Let us know if you are successful at doing that.

how do I enter them of access? me error

momocruz · 08/03/2015, 15:01

Quote:

Originally Posted by Oyuba

how do I enter them of access? me error

this is an Example with this acces log , you have to use log you put when you have instaled SQL

and when you enter on your SQL use Linked Server From Treica