[As Requested] Video Tutorial for Setting up the Shaiya Private Server

Disabled must be default for windows, I never messed with it & already it was disabled.

Still the same issue, I have read every thread about this issue and nothing has worked. I even went through the liberty of partitioning my hard drive & putting XP sp3 on it. Same results x.x

Quote:

Originally Posted by 13latrix Self explanatory. Using windows vista or higher you got to give permissions or exceptions. ~Phish

i get this problem too.

how do i fix it

This File the file isnt avaible anymore so i cant download it

Quote:

Originally Posted by nick-877 This File the file isnt avaible anymore so i cant download it

Still works perfectly.

Everything work great except for when I choose the game and then click OK. I get the disconect error or the time out error. I am Running Windows 7 with SQL2005. I have been working on this for about 2 weeks and keep coming across similar problems. I have tested SQL and server patch config. They seem to be communicating just fine. Here are the log files. Could someone look at them and point me in the direction to fix the issue.

SQL Log
2010-06-30 12:26:33.93 spid52 Starting up database 'PS_userdata'.
2010-06-30 12:26:36.00 spid60 Starting up database 'PS_GameLog'.
2010-06-30 12:26:36.01 spid61 Starting up database 'PS_GameData'.
2010-06-30 12:26:38.18 spid96 Starting up database 'PS_gamedefs'.
2010-06-30 12:26:48.11 spid19s SQL Server has encountered 5 occurrence(s) of cachestore flush for the 'Object Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2010-06-30 12:26:48.11 spid19s SQL Server has encountered 5 occurrence(s) of cachestore flush for the 'SQL Plans' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2010-06-30 12:26:48.11 spid19s SQL Server has encountered 5 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.
2010-06-30 12:27:38.00 spid97 Starting up database 'OMG_GameWEB'.
2010-06-30 12:27:41.36 Logon Error: 18456, Severity: 14, State: 5.
2010-06-30 12:27:41.36 Logon Login failed for user 'USER_SQL_SERVER'. [CLIENT: 127.0.0.1]

Game - log
2010-06-30 12:26:38 PS_GAME__system log start (Game) [KR]

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/sorp1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/croco1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/croco2

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Troll1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Spink1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/GoldenPig

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Sorp3

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/SorpNamed1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/SorpNamed2

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Sorp2

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/CrocoNamed1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/CrocoNamed2

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/CrocoNamed3

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/OrcNamed1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/OrcNamed2

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/OrcNamed3

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/TrollNamed1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Deinos

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Parridalis

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Alcarian

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/ZinAlcaria

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Belizabeth

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/Kirhiross

2010-06-30 12:26:38 Loaded Behavior In Factory : data/ai/CrypticOne

2010-06-30 12:26:48 connect mgr 936

2010-06-30 12:26:48 connect dbagent 940

2010-06-30 12:26:48 connect dbagent2 944

2010-06-30 12:26:48 connect gamelog 960

2010-06-30 12:26:49 Market End -----------------------

2010-06-30 12:26:49 Load Shaiya.SData 0

2010-06-30 12:26:50 <Console input> /nprotectoff

2010-06-30 12:26:50 <Console output> cmd NProtect off ok

2010-06-30 12:27:41 discon client: (104, 64) T=000:00:00:000, RC=1,RCS=0, RB=24,RBS=0, SC=2,SCS=0, SB=31,SBS=0

DBAGENT - Log
2010-06-30 12:26:35 PS_DBAGENT__system log start (DBAgent)

2010-06-30 12:26:48 connect game, Name=



2010-06-30 12:26:48 connect game, Name=



2010-06-30 12:27:41 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'USER_SQL_SERVER'., SQL STATE: 28000, NATIVE ERROR: 18456 (0x4818)

2010-06-30 12:27:41 ::LoadBillingItem 2 qerr=-1, EXEC usp_Read_Char_Product_Item_E 2

pleas don't think I am lazy and dont look or try to find answers. I have just run out of ideas. Thanks in advance for any advice you can share. I will continue to look for an answer.

Edit...
Ok so I feel a little stupid. I completely missed the part of my log that said User_sql_server. So for those who have this same issue. The easiest way to fix this is to modify the login information under the linked server itself.

can someone help me with this error, when im trying to write command /nprotectoff the game and gamegroup getting in pause...

tony...what does the game log say?

Quote:

Originally Posted by tony1414 can someone help me with this error, when im trying to write command /nprotectoff the game and gamegroup getting in pause...

Simple you "CAN NOT" enter command to a paused component.
Start the Service then once it is showing PLAY = > type in your command.

kk. guys i have everything working and done...now how did you create a server with admin username and password...:o

TYVM for the few people that Contacted me we alrdy have a server in Proces with a Couple of friends actually if anything pops up i will contact the same ppl that contacted me :D ty for your time

this is perfect.
but could u explain how to connect to the server and log to play a bit with GM commands?
maybe another video :P

Quote:

Originally Posted by sven.heyens hello , when you install the SQL server , It doesnt matter what the SA pasword is ??

No the SA password can be anything. also you will want to change the server pass to something besides Shaiya123 or anybody can acces it. maybe i will make a VT on how to change the pass for the EP4 Server.:mofo:

Quote:

Originally Posted by sven.heyens Error Message : checking server. Please check Notice Board. idk what i do wrong ... i only need to change all the IP adresses (127.0.0.1) with my IP private adress on the *Ini files and in the server patch config. btw... my private IP adress begins with 169.254....... is this correct ?

The error is caused by the client not being able to find the serving running at the specified address.

First make sure all services are running ">".

Second
If the server and the client are running on the same machine. Use IP 127.0.0.1

If The Server and client are on local network but not on the same machine. Use the local Network Address. Example " 192.168.#.# ".

If the server and the client are not on a local netowrk or on the same computer use the external IP Example "169.254......."

Make sure your firewall and or router are configured to allow connections.

Make sure this is the IP used both in the game.exe and in the server ini files
located @ "SERVER\PSM_Client\Bin\Config\ps_game.ini"

Example for ini File

[GAMEINFO]
GameName=Your Server Name
GamePublicIP=Your Selected IP
;)

Quote:

Thnks a lot sniper , okay my server is up now i can login , choose my server and then its freezing ... its says : character load error ...

I had the same issue. I had to fully update the US client, Then I edited the game.exe in HxD, Not 100% this will solve your problem but, it did for me. GL!

Not sure whats going on here but, I have followed ever step to the T, Everything is running and operational but, when in game all my skills are FUBAR can't buy them or anything. I have /set [player] skillpoint 500 & I still couldn't buy them. The skills are like this on the EP3 & EP4 files. I have tried restoring the DB & same results.
None of the GM list codes are the same, Codes not such a worry right now.

Has anyone else ran into this problem with the skills being completely jacked? If so, could you help me out on how to fix this issue? Thanks in advance!

Here are a couple SS of the skill tree.

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

The US client now runs EP5 so you have to install shaiya and update to no higher that about v108. Check your client version.ini file to see the current version if it higher than 108 edit it to read v 50 and run updater again and stop it when version reaches 108.

to see the current version watch the client folder as it updates it will show patch00## that number is the number right after what is currently installed.
So when it reads Patch 109 click the x on the updater to stop the updating.