[Request] Ep4 Public Connection Trouble

blackhatjoe · 04/06/2010, 04:48

Fixed this issue

Possum09 · 04/06/2010, 18:20

Check your DBAgent logs in "PSM_Client\Bin\Log\PS_DBAGENT__system.log__[DATE]_[TIME].log" to see if it's throwing any errors.

blackhatjoe · 04/06/2010, 19:48

Quote:

Originally Posted by Possum09

Check your DBAgent logs in "PSM_Client\Bin\Log\PS_DBAGENT__system.log__[DATE]_[TIME].log" to see if it's throwing any errors.

This is all it says in that log file :

Spoiler

I then have to replace ALL of the INI files and exe files to get the server to run again, so wtf? lol

blackhatjoe · 04/06/2010, 20:07

After I replace ps_game.exe start it and it stabilizes I can login , create and delete characters, but when I select a character and hit Game Start I immediately get disconnected from game server error 0 and then this is in PS_DBAGENT_log :

2010-04-06 11:53:03 Error Packet : 0x209, CConnection::PacketSystemConnect

2010-04-06 11:58:53 ::LoadCharacter 10 [GM]charactername qerr=-1, EXEC usp_Read_Char_QuickSlots_R 10

2010-04-06 12:00:40 ::LoadCharacter 10 [GM]charactername qerr=-1, EXEC usp_Read_Char_QuickSlots_R 10

EDIT :

Here is a video of all that I am describing incase some of it isn't clear:

Has to be viewed with VLC

Possum09 · 04/08/2010, 00:53

That stored procedure needs to be fixed. usp_Read_Char_QuickSlots_R which is in PS_GameData.

Run the stored proc in SQL Query Analyzer and see if it generates any error.

If it does not it most likely a column that does not have the correct data type which is common when you use an Ep3 Database and Ep4 Server Executable.

blackhatjoe · 04/08/2010, 05:14

Quote:

Originally Posted by Possum09

That stored procedure needs to be fixed. usp_Read_Char_QuickSlots_R which is in PS_GameData.

Run the stored proc in SQL Query Analyzer and see if it generates any error.

If it does not it most likely a column that does not have the correct data type which is common when you use an Ep3 Database and Ep4 Server Executable.

I queried the procedure from local and WAN connection and all completed successfully, I don't know where to go from here.

Are there any PURE EP4 Server files and DB around?

I would really like to get this online, I have put alot of hours into this.

ProfNerwosol · 04/08/2010, 12:21

There is. Try ... How to: Shaiya Server with EP4

However, it will need few fixes which are available on this forum.

blackhatjoe · 04/08/2010, 21:23

Quote:

Originally Posted by ProfNerwosol

There is. Try ... How to: Shaiya Server with EP4

However, it will need few fixes which are available on this forum.

Unfortunately that is the guide I am/was following.

There is nothing more I can do with my limited knowledge on this subject.

I can put up a video of me completely reinstalling from EP3 to EP4 if you think that could help.

ProfNerwosol · 04/09/2010, 00:16

That tutorial has EP4 databases and executables. You only need the EP3 files to have the services installed properly.

blackhatjoe · 04/09/2010, 03:01

Fixed this issue

ProfNerwosol · 04/09/2010, 20:56

Ok, I re-read through all your posts. I have little experience with pserver going public, I'm just playing with configs

, so whatever is here is my best guess.

Error 0 after selecting character, you say? Do you turn /nprotectoff every time you start the server? If you get an error after typing it, close the console and try again. I got that error once when I starter my test server and after few tries it went through.

2010-04-06 11:25:25 error mob item drop info load error
Did you change any of the IP's in DB section? I mean when you chose GameGroups01 on the right there is a whole section with Title 'DB' which should be set to your local IP under which MSSQL is available. Looks like GameDefs..MobItems is not available, but it's my best guess.

blackhatjoe · 04/11/2010, 22:26

I just did it all manually the PSM kept corrupting all of the files.

Quote:

Originally Posted by ProfNerwosol

Ok, I re-read through all your posts. I have little experience with pserver going public, I'm just playing with configs , so whatever is here is my best guess.

Error 0 after selecting character, you say? Do you turn /nprotectoff every time you start the server? If you get an error after typing it, close the console and try again. I got that error once when I starter my test server and after few tries it went through.

2010-04-06 11:25:25 error mob item drop info load error
Did you change any of the IP's in DB section? I mean when you chose GameGroups01 on the right there is a whole section with Title 'DB' which should be set to your local IP under which MSSQL is available. Looks like GameDefs..MobItems is not available, but it's my best guess.