[GUIDE] Troubleshooting Common Server Set Up Problems

Post here all your Server logs can be founded on ShaiyaServer > PSM_Client > Bin > Log

PS_DBAGENT__charsave.log
PS_DBAGENT__system.log
PS_GAME__system.log
PS_GAMELOG__system.log
PS_LOGIN__system.log
PS_SESSION__system.log
PS_USERLOG__system.log

that's all
all date is 2012-03-18, but i tried to connect today, yesterday..
This is installation time maybe..

Ok your first error is

Quote:

2012-03-18 15:44:04 PS_DBAGENT__system log start (DBAgent01) 2012-03-18 15:44:05 DB gamedata connect error 2012-03-18 15:44:05 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-03-18 15:44:05 DBKillCountSave db alloc failed 2012-03-18 15:44:05 SAVE kill count ERROR 2012-03-18 15:44:05 CKeepObeliskMgr::DBSave db alloc failed 2012-03-18 15:44:05 SAVE g_KeepObeliskMgr ERROR 2012-03-18 15:44:05 GuildMgrSave::DBSave db alloc failed 2012-03-18 15:44:05 SAVE g_GuildMgrSave ERROR 2012-03-18 15:44:05 PS_DBAGENT__system log end (DBAgent01) 2012-03-18 15:44:05 3 1 SService::ServiceCtrlDispatcher(): service shutdown

You mess up some files like kill count datas.
Clean the guild table database > PS_GameData > dbo.guilds then dbo.guilditems and so on.
Also you need the Guild fix, friends and so on, give a search is all fixes here.

2. You need to go Security > Logins double click on Shaiya and give permissions to access the server.

Quote:

DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=Shaiya123

3.go to Server Objects > Linked Servers double client on all datas from there go Security and rewrite the accout Shaiya and pass Shaiya123.

Restart the server and should work.
Is better to reinstall the server and to run complete the batch.

But tables is empty:
except:
i must to clean them, right?

Also, i'd rewrote passw in:
and here:
Right?
This on russian...

Hi everyone.
I am trying my best to make a server for me and my friends but I got a "character load error" after selecting sides. Currently I don't have OS files and im using it on some pservers [hns shaiya and Extension shaiya... if it helps] and i am using the client [no gg] provided [Only registered and activated users can see links. Click Here To Register...]... can anyone tell me what i am doing wrong?

It would be good if you checked on your logs to see what is happening just before you receive this error message

Quote:

Originally Posted by tlankima Hi everyone. I am trying my best to make a server for me and my friends but I got a "character load error" after selecting sides. Currently I don't have OS files and im using it on some pservers [hns shaiya and Extension shaiya... if it helps] and i am using the client [no gg] provided [Only registered and activated users can see links. Click Here To Register...]... can anyone tell me what i am doing wrong?

The character load error usually comes due to a discrepancy between the server and client. Such as a character with an item equipped that no longer exists in the database.

There are several other reasons it could be, the above is just an example. But the Char Load Error, in my experience, has almost always been due to some form of information mismatch.

Hi everyone, I setup server successful and started all service, it all turn in green arrow, seem to be all right but when i look in

Quote:

D:\SHAIYA_SERVER\SERVER\PSM_Client\Bin\Log\PS_LOGI N__system.log__20120417_111930.log

i found the service isn't start yet. Here's infomation:

Quote:

2012-04-17 11:19:30 PS_LOGIN__system log start (Login01)

just stop there and have no anything else. I think it must be

Quote:

2012-04-17 11:19:30 PS_LOGIN__system connect

but it's not, and result is i can't connect to server when i open game.exe (i've checked all IP, correct all) @__@! Can anypro help me plz!!! Do i miss anything? T_T Sorry about my bad English :(

Hello i have this Problem:

I start the Server, at first i get green arrow but after 10sec`s Game and DBAgent
will be green paused, i log in and i see "Server CLOSED" . :(

What can i do ?
Here my Logs:


PS_DBAGENT_charsave:

Quote:

//PS_DBAGENT__charsave log start (DBAgent01) //PS_DBAGENT__charsave log start (DBAgent01)

PS_DBAGENT_system:

Quote:

2012-04-29 16:57:54 PS_DBAGENT__system log start (DBAgent01) 2012-04-29 16:57:54 DB gamedata connect error 2012-04-29 16:57:54 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-04-29 16:57:54 DBKillCountSave db alloc failed 2012-04-29 16:57:54 SAVE kill count ERROR 2012-04-29 16:57:54 CKeepObeliskMgr::DBSave db alloc failed 2012-04-29 16:57:54 SAVE g_KeepObeliskMgr ERROR 2012-04-29 16:57:54 GuildMgrSave::DBSave db alloc failed 2012-04-29 16:57:54 SAVE g_GuildMgrSave ERROR 2012-04-29 16:57:54 PS_DBAGENT__system log end (DBAgent01) 2012-04-29 16:57:54 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAME_system:

Quote:

2012-04-29 16:57:54 PS_GAME__system log start (Game01) [KR] 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/sorp1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/croco1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/croco2 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Troll1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Spink1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/GoldenPig 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Sorp3 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/SorpNamed1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/SorpNamed2 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Sorp2 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/CrocoNamed1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/CrocoNamed2 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/CrocoNamed3 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/OrcNamed1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/OrcNamed2 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/OrcNamed3 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/TrollNamed1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/HellTouthNamed1 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Deinos 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Parridalis 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Alcarian 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/ZinAlcaria 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Belizabeth 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Kirhiross 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/CrypticOne 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Haruhion 2012-04-29 16:57:56 Loaded Behavior In Factory : data/ai/Freezing 2012-04-29 16:58:01 connect mgr 948 2012-04-29 16:58:02 DB agent connect failed 2012-04-29 16:58:02 1 1 SAgent::Disconnect: (3, 1236) 2012-04-29 16:58:02 1 1 T=000:00:00:000, RC=1,RCS=1, RB=5,RBS=5, SC=2,SCS=2, SB=70,SBS=70 2012-04-29 16:58:02 discon mgr ((3,1236, 5,70) 2012-04-29 16:58:02 mgr Connection Lost INFO : T=000:00:00:000, RC=1,RCS=1, RB=5,RBS=5, SC=2,SCS=2, SB=70,SBS=70 2012-04-29 16:58:02 mgr server disconnection 2012-04-29 16:58:02 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2012-04-29 16:58:02 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init() 2012-04-29 16:58:02 Call save all waiting... 2012-04-29 16:58:02 Call save all failed dbagent disconnected(user count = 0)... 2012-04-29 16:58:02 server shutdown Connection INFO : T=000:00:00:000, NumC=0,CMin=0,CMax=0,CAvg=0.00, CAva=0,CReq=0,CCnt=0,DCCnt=0, CTimeT=000:00:00:000,CTimeAvg=000:00:00:000, RBT=0,RBS=0,RBSC=0,SBT=0,SBS=0,SBSC=0 2012-04-29 16:58:02 Save Shaiya.SData 0 2012-04-29 16:58:02 PS_GAME__system log end (Game01) 2012-04-29 16:58:02 3 1 SService::ServiceCtrlDispatcher(): service shutdown

PS_GAMELOG_system:

Quote:

2012-04-29 16:44:27 PS_GAMELOG__system log start (GameLog01)

PS_LOGIN_system:

Quote:

2012-04-29 16:44:32 PS_LOGIN__system log start (Login01)

PS_Session_system:

Quote:

2012-04-29 16:44:32 PS_LOGIN__system log start (Login01)

PS_USERLOG_system:

Quote:

2012-04-29 16:44:25 PS_USERLOG__system log start (UserLog) 2012-04-29 16:44:27 connect 2012-04-29 16:44:35 connect

pls guys, anyone can help me ? :p

my Distirubuted transaction service not work cant start if any good helpler want to helpme skype: Extra-Bass (its not spamm.. )

2012-08-16 15:29:39 PS_LOGIN__system log start (Login01)

2012-08-16 15:29:56 DB userdata connect error, id=Shaiya, pass=Shaiya123

2012-08-16 15:29:56 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-08-16 15:29:56 PS_LOGIN__system log end (Login01)

2012-08-16 15:29:56 3 1 SService::ServiceCtrlDispatcher(): service shutdown

okay soo it wont connect to my database i got that. and my database opens correctly. but when i try to open using sql authentication with shaiya and shaiya 123 it connects but my server still doesnt stay conected with green arrows so i have no clue what to do

Help me pls Services go to a green arrow, but then back to pause.Help me !!!!!!!!!!!!

Hey , bored so i am trying to set up an offline server and i get the green > for a few seconds then the pause

Looked in Log and i have this message

2012-12-21 04:36:18 PS_USERLOG__system log start (UserLog)

2012-12-21 04:36:34 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=shaiya, Pass=xxxxxxx
2012-12-21 04:36:34 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-12-21 04:36:34 PS_USERLOG__system log end (UserLog)

2012-12-21 04:36:34 3 1 SService::ServiceCtrlDispatcher(): service shutdown

,

anyone help??

2012-12-21 04:36:34 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=shaiya, Pass=xxxxxxx

Check your DataBase Username and Password actually exist and are correct. It's not connecting properly.

Hello fellow devs, today i received an email from my admin with a problem but i dont know where exactly took for a solution.
The problem is that the server is getting a disconnect every 20 hours and we havent found fix, here is the log if it helps


The servers disconnect every 20 hours, these are the commands i use after i open it up again
/nprotectoff /vchkoff i have sql 2008 server ep 5.3
[1:21:34 μμ] [ADM]SWAT: ------------------------------
[1:21:40 μμ] [ADM]SWAT: 2015-01-02 17:35:07 PS_USERLOG__system log start (UserLog)

2015-01-02 17:35:09 connect

2015-01-02 17:35:19 connect

2015-01-02 17:35:22 connect

2015-01-02 19:18:49 1 1 SAgent:: disconnect: (4, 64)

2015-01-02 19:18:49 1 1 T=001:48:00:000, RC=36,RCS=0, RB=462,RBS=0, SC=21,SCS=0, SB=84,SBS=0

2015-01-02 19:18:49 disconnect

2015-01-02 19:21:45 connect
[1:21:48 μμ] [ADM]SWAT: -------------------------------

Can you help me find a solution for this issue? thanks in advance