[How To]*All Incl. Shaiya Server Setup Deutsch / English

das heißt im klartext ?

folge dem tutorial von peripher step by step und lass nichn paar sachen aus. du hast nach dem sql newinstalltion script nicht mehr richtig aufgepasst.

Gute Anleitung. Doch langsam reicht es mit den PServer die einfach aus der Erde spriessen, wenn andere Guides halt nicht mehr Aktuell sind, probiert man selbst ein wenig rum und bekommt es dann auch hin. Klar jeder hat mal klein angefangen, aber trz ist es langsam unnötig immer wieder die gleichen Fragen zubeantworten. Wenn man auch nur ein bisschen seine brain.exe anstrengt bekommt man das meiste selbst gelöst.

Congratulations for the initiative.
Tutorial very well explained.
Surely with all that will be able to create a server.

Hi,
which client works with this server? Anyone can provide a link?

Quote:

Originally Posted by peripher Shaiya Episode of your Choice!

You have to learn reading..

Language version is important? I tried with this client: "http://pl.shaiya.aeriagames.com/," but I couldn't find the server addresses in game.exe file , so I used this game.exe: "http://www.elitepvpers.com/forum/shaiya-pserver-development/2257246-release-official-episode-5-4-client.html", should it work?

Thank you in advance for your help.

Yes because different IP Addresses. Use English-game.exe you can connect with PL Client.

You should also be able to use the PL game.exe if you run the game as normal with a firewall running as most Firewall programs will give you a pop up asking if the connection from xx IP is safe etc. Then you just search for that IP in hex and change it.

Works all the time for me, but I've never tried with another game.exe than English/US

An addition.. If your firewall doesn't do this. I have Avast and that always pops up when I use a "new" game.exe, so if you want to try that method, Avast's firewall will work.

Iv'e fallowed this tutorial fully when installing and configuring SQL 2008

But i'm getting an error when Attaching Database (PS_GameData_Data.MDF)
I got the [Release]Full EP6 Shaiya Server Files from [Only registered and activated users can see links. Click Here To Register...]

The error says
"Attach database failed for Server '127.0.0.1' (Microsoft.SqlServer.Smo)

Additional information:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.ConnectionInfo)
The Database 'PS_GameDefs11' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported.
Coud not open new database 'PS_GameDefs11' CREATE DATABASE is aborted (Microsoft SQL Server, Error:948)

Any advice?

Please use SQL 2008 R2.
655 is 2008 and 661 is R2 which is needed.

Quote:

Originally Posted by peripher Please use SQL 2008 R2. 655 is 2008 and 661 is R2 which is needed.

Oh ok..
Will Will SQL Server® 2008 R2 SP2 - Express Edition work??
If so, the DL links should be updated so other's don't have this same issue when fallowing the tutorial exactly

Installed R2 SP2 and the attach worked.. NOW. when i finish up and hit "Start All Services" they load then after a few seconds pause again :(

Please provide logs.
PSM_Client/bin/logs

Express worked but you have to try it over and over.
No, because version 661 is only needed for the new-server files that you have.

All other files working with SQL 2008

Quote:

Originally Posted by peripher Please provide logs. PSM_Client/bin/logs Express worked but you have to try it over and over. No, because version 661 is only needed for the new-server files that you have. All other files working with SQL 2008

I went into my registry and deleted everything and did a fresh start:

1: Installed MSSQL 2008 R2 Express
Selected "Default Instance"
SQL Server Database Engine = "PC User account / Password"
Selected "Mixed mode" then "Add Current User"
entered the passwords = "PC User Password"
--- Success

2: Opened SQL Server Network Configuration
Opened "Protocols for MSSQLSERVER" Then Enabled TCP/IP
Went into Properties and changed and Enabled all IP1 through IP9 adding/replacing IP Address to 127.0.0.1
"NOTE: I AM CURRENTLY ONLINE USING MY WIRELESS EITHERNET ADAPTER..
I AM SHARING INTERNET TO ANOTHER DESKTOP USING ANOTHER EITHERNET CARD W/CABLE SO THAT'S WHY THERE ARE IP1 through IP9"

Enabled and opened "Named Pipes"
Renamed to \\.\pipe\sql\query
Restarted SQL...

3:Installed SQL Management Studio
Selected New SQL Server stand-alone installation
All 6 Passed hit next and All 11 passed
Selected "Perform a new installation of SQL Server 2008"
Selected "Select All" Shared Features
Installed...

4: Opened SQL Management Studio
Change the Server-Name to 127.0.0.1
Selected "Windows Authentication"
Connected successfully..

Created new login name = Shaiya
Selected "SQL Server Authentication" Shaiya123
Unchecked "Enforce password expiration"

Selected "Server Roles"
Checked sysadmin and Public only

5: Extracted [Release]Full EP6 Shaiya Server Files to C:\Users\EcLiPz\Documents\ShaiyaServer

Attached all the .MDF to "Database"
from C:\Users\EcLiPz\Documents\ShaiyaServer\DATABASE

Opened New SQL Installation.sql
Changed 'your-db-username', 'your-db-userpassword' to 'Shaiya', 'Shaiya123'
Executed successfully

6: Opened open ps_passwordENC.exe "As admin"
Typed in "Shaiya123"
Copied Enc and pasted it in every .ini in PSM_Client / bin / config

Opened SM_Client and selected PSM_ServiceMgr and executed it "as admin" and Installed everything

Opened PSM_AgentInstall Ran "as Admin" Installed Successfully then after i hit ok i receive a random pop up
(Apply windows registry (apply only ps_game/war, ps_login, need restart window)
Clicked it.. Nothing happend after waiting a few min so i hit close...

Opened CMD "As Admin"
Ran cd C:\Users\EcLiPz\Documents\ShaiyaServer
Ran shaiya_svc_register.bat successfully

RESTARTED COMPUTER

Opened PSMServer_Mgr "As admin"
Typed in Username = Shaiya
Typed in Password = Shaiya123
Clicked "Apply All DB Account + Passwd(if equal all db)
Clicked "Apply All Account"
Clicked "Apply All Passwd"

Selected "Control Service"
Selected "Start All Services"

All unpaused accept "Game"
Checked the logs
I already have a E6 game.exe that's IP bound to 127.0.0.1
But can't log in with Username=Shaiya PW=Shaiya123

PS_GAME__system log start (Game01) [GERMANY]

I think you're from Germany if not, please forgive me now.

Deine IP 127.0.0.1 in der game.exe wird nicht funktionieren.
Verwende deine Locale IP 192.168.x.x

Shaiya, Shaiya123 sollte funktionieren, jedoch solltest du es mehrmals versuchen.
Der Log oben enthält lediglich Status-Einträge, jedoch keine Fehlermeldungen.
Du kannst es ebenfalls mit SQL 2008 R2 180 Tage test version versuchen.

Das Problem liegt prinzipiell in der SQLCMD.exe die für express versionen nicht vollständig ist.