Assistance requesed

[zell_49]

Hello all. I am running the ShaiyaServer 5.3 on a VM (thanks to ). The server / DB appear to be communicating fine from what I can tell by searching through the forums. I have all green arrows with the /vchkoff and /nprotectoff. When I try to connect to the server, I get the 'Please try to reconnect to the server ERROR 0'. I assumed it was due to a client / server version conflict of some kind... I have tried using the OS client with various game.exe files ( among others). I'm all out of ideas though, and cannot figure out my log files very well. I have attached the ps_game and ps_dbagent logs below. Any help or suggestions on how to fix this would be appreciated. Thanks.

PS_GAME_system.log

 Spoiler

2012-06-10 12:45:03 PS_GAME__system log start (Game01) [KR]

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/sorp1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/croco1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/croco2

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Troll1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Spink1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/GoldenPig

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Sorp3

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/SorpNamed1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/SorpNamed2

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Sorp2

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/CrocoNamed1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/CrocoNamed2

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/CrocoNamed3

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/OrcNamed1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/OrcNamed2

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/OrcNamed3

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/TrollNamed1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Deinos

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Parridalis

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Alcarian

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/ZinAlcaria

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Belizabeth

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Kirhiross

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/CrypticOne

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Haruhion

2012-06-10 12:45:03 Loaded Behavior In Factory : data/ai/Freezing

2012-06-10 12:45:03 connect mgr 736

2012-06-10 12:45:03 connect dbagent 744

2012-06-10 12:45:03 connect dbagent2 756

2012-06-10 12:45:03 connect gamelog 788

2012-06-10 12:45:03 Market End -----------------------

2012-06-10 12:45:04 Load Shaiya.SData 0

2012-06-10 12:45:49 <Console input> /nprotectoff

2012-06-10 12:45:49 <Console output> cmd NProtect off ok

2012-06-10 12:46:24 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

2012-06-10 12:50:34 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

2012-06-10 12:55:17 discon client: (104, 64) T=000:00:00:000, RC=1,RCS=1, RB=24,RBS=24, SC=2,SCS=2, SB=31,SBS=31

PS_DBAGENT_system.log

 Spoiler

2012-06-10 12:45:01 PS_DBAGENT__system log start (DBAgent01)

2012-06-10 12:45:03 connect game, Name=



2012-06-10 12:45:03 connect game, Name=



2012-06-10 12:46:24 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-10 12:46:24 ::LoadBillingItem 5 qerr=-1, EXEC usp_Read_Char_Product_Item_E 5

2012-06-10 12:50:34 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-10 12:50:34 ::LoadBillingItem 5 qerr=-1, EXEC usp_Read_Char_Product_Item_E 5

2012-06-10 12:55:17 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_USERDB01' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-06-10 12:55:17 ::LoadBillingItem 5 qerr=-1, EXEC usp_Read_Char_Product_Item_E 5

Edit: I believe I actually pulled the ep 5 DBs from the post by , if that makes any difference.

Resolved:

[.Shaco.]

As you can see on log2 , it says that Linked Server is missing name is: PS_USERDB01

Open up batch folder in server file and click the SQL file and run it.

[JohnHeatz]

As you got an answer on this thread, I will move this to the right section (Shaiya Private Server) and close the one you posted as well in there.

#Moved to the right section

Development section is for releases only.

[orion72956]

The file you're looking for is called New Installation.SQL. Run it and it will install your user account in the database as well as install your Linked Servers ie game, UserDB01, PN_Cash, etc. Without these, the server won't start.

File can also be called config.sql..have seen it as both. If you need any more help feel free to PM me.