[Request] Ep4 Public Connection Trouble

04/06/2010 04:48 blackhatjoe#1
Fixed this issue :D
04/06/2010 18:20 Possum09#2
Check your DBAgent logs in "PSM_Client\Bin\Log\PS_DBAGENT__system.log__[DATE]_[TIME].log" to see if it's throwing any errors.
04/06/2010 19:48 blackhatjoe#3
Quote:
Originally Posted by Possum09 View Post
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 :




I then have to replace ALL of the INI files and exe files to get the server to run again, so wtf? lol
04/06/2010 20:07 blackhatjoe#4
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:
[Only registered and activated users can see links. Click Here To Register...]

Has to be viewed with VLC
04/08/2010 00:53 Possum09#5
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.
04/08/2010 05:14 blackhatjoe#6
Quote:
Originally Posted by Possum09 View Post
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.
04/08/2010 12:21 ProfNerwosol#7
There is. Try ... How to: Shaiya Server with EP4

However, it will need few fixes which are available on this forum.
04/08/2010 21:23 blackhatjoe#8
Quote:
Originally Posted by ProfNerwosol View Post
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.
04/09/2010 00:16 ProfNerwosol#9
That tutorial has EP4 databases and executables. You only need the EP3 files to have the services installed properly.
04/09/2010 03:01 blackhatjoe#10
Fixed this issue :D
04/09/2010 20:56 ProfNerwosol#11
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.
04/11/2010 22:26 blackhatjoe#12
I just did it all manually the PSM kept corrupting all of the files.

Quote:
Originally Posted by ProfNerwosol View Post
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.