Plz help

[GM]Tinkerbell · 02/20/2012, 07:59

I had server up and rnning now i am getting this error

2012-02-20 06:54:07 RandomOption Error : ItemID=23060, byServer=1, Wis=0

2012-02-20 06:54:11 connect mgr 928

2012-02-20 06:54:12 DB agent connect failed

2012-02-20 06:54:12 1 1 SAgent:

isconnect: (3, 64)

2012-02-20 06:54:12 1 1 T=000:00:00:000, RC=1,RCS=0, RB=5,RBS=0, SC=3,SCS=0, SB=74,SBS=0

2012-02-20 06:54:12 discon mgr ((3,64, 5,74)

2012-02-20 06:54:12 mgr Connection Lost INFO : T=000:00:00:000, RC=1,RCS=0, RB=5,RBS=0, SC=3,SCS=0, SB=74,SBS=0

2012-02-20 06:54:12 mgr server disconnection

2012-02-20 06:54:12 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-02-20 06:54:12 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-02-20 06:54:12 Call save all waiting...

2012-02-20 06:54:12 Call save all failed dbagent disconnected(user count = 0)...

2012-02-20 06:54:12 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-02-20 06:54:12 Save Shaiya.SData 0

2012-02-20 06:54:12 PS_GAME__system log end (Game01)

2012-02-20 06:54:12 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Can anyone help me ?

RebeccaBlack · 02/20/2012, 12:47

Quote:

Originally Posted by [GM]Tinkerbell

RandomOption Error : ItemID=23060, byServer=1, Wis=0

Check out that ItemID. Seems there was a problem with it.

[GM]Tinkerbell · 02/21/2012, 02:42

Ok now i have fixed the item thing I am still getting an error

2012-02-21 01:36:20 DB gamedef connect error

2012-02-21 01:36:20 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-02-21 01:36:20 Call save all waiting...

2012-02-21 01:36:20 Call save all failed dbagent disconnected(user count = 0)...

2012-02-21 01:36:20 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-02-21 01:36:20 Save Shaiya.SData 0

2012-02-21 01:36:20 PS_GAME__system log end (Game01)

2012-02-21 01:36:20 3 1 SService::ServiceCtrlDispatcher(): service shutdown

012-02-21 01:37:13 PS_SESSION__system log start (Session)

2012-02-21 01:37:14 userlog connect failed

2012-02-21 01:37:14 initserver() failed

2012-02-21 01:37:14 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-02-21 01:37:14 PS_SESSION__system log end (Session)

2012-02-21 01:37:14 3 1 SService::ServiceCtrlDispatcher(): service shutdown

RebeccaBlack · 02/21/2012, 05:43

The errors are in the logs. Session is failing to connect to "userlog" and game is failing to connect to the Database "gamedef" (PS_GameDefs").

Start the services manually, in this order: UserLog -> Session -> GameLog -> DBAgent -> Game -> Login

If they crash again, check the logs. Session should stay up, unless UserLog crashes, since it relies on UserLog. If UserLog crashes, Session will crash, then Game and Login will too as they rely on Session.

If they all stay on, but Game goes off again, check the logs. If it still says something about your DB gamedefs, check the config and make sure the password is correct, check your SQL database, make sure PS_GameDefs is there etc.

The errors are in the logs. Session is failing to connect to "userlog" and game is failing to connect to the Database "gamedef" (PS_GameDefs").

Start the services manually, in this order: UserLog -> Session -> GameLog -> DBAgent -> Game -> Login

If they crash again, check the logs. Session should stay up, unless UserLog crashes, since it relies on UserLog. If UserLog crashes, Session will crash, then Game and Login will too as they rely on Session.

If they all stay on, but Game goes off again, check the logs. If it still says something about your DB gamedefs, check the config and make sure the password is correct, check your SQL database, make sure PS_GameDefs is there etc.

[GM]Tinkerbell · 02/21/2012, 23:41

Session and Userlog now start...
But the rest do not. I have tested Linked servers all pass. All DB objects are there billing, chatlog, gamedata, gamedefs, Gamelog, Statdata, Statistics and userdata. Now i seem to have this issue only after my 2 other team members access The database remotely.

i am totally lost I have rebooted my whole computer and reinstalled all about 3times now I just dont know where i am going wrong or what the issue is.

LOGS:-

DBAgent_System ....
2012-02-21 22:30:02 PS_DBAGENT__system log start (DBAgent01)

2012-02-21 22:30:03 DB gamedata connect error

2012-02-21 22:30:03 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-02-21 22:30:03 DBKillCountSave db alloc failed

2012-02-21 22:30:03 SAVE kill count ERROR

2012-02-21 22:30:03 CKeepObeliskMgr:

BSave db alloc failed

2012-02-21 22:30:03 SAVE g_KeepObeliskMgr ERROR

2012-02-21 22:30:03 GuildMgrSave:

BSave db alloc failed

2012-02-21 22:30:03 SAVE g_GuildMgrSave ERROR

2012-02-21 22:30:03 PS_DBAGENT__system log end (DBAgent01)

2012-02-21 22:30:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown

GAME_System...(after the AI bit which is fine)..

2012-02-21 22:30:14 connect mgr 928

2012-02-21 22:30:15 DB agent connect failed

2012-02-21 22:30:15 1 1 SAgent:

isconnect: (3, 64)

2012-02-21 22:30:15 1 1 T=000:00:00:000, RC=1,RCS=1, RB=5,RBS=5, SC=3,SCS=3, SB=74,SBS=74

2012-02-21 22:30:15 discon mgr ((3,64, 5,74)

2012-02-21 22:30:15 mgr Connection Lost INFO : T=000:00:00:000, RC=1,RCS=1, RB=5,RBS=5, SC=3,SCS=3, SB=74,SBS=74

2012-02-21 22:30:15 mgr server disconnection

2012-02-21 22:30:15 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-02-21 22:30:15 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-02-21 22:30:15 Call save all waiting...

2012-02-21 22:30:15 Call save all failed dbagent disconnected(user count = 0)...

2012-02-21 22:30:15 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-02-21 22:30:15 Save Shaiya.SData 0

2012-02-21 22:30:15 PS_GAME__system log end (Game01)

2012-02-21 22:30:15 3 1 SService::ServiceCtrlDispatcher(): service shutdown

GAMELOG....

2012-02-21 22:29:02 PS_GAMELOG__system log start (GameLog01)

2012-02-21 22:29:03 DB gamelog connect error

2012-02-21 22:29:03 init db error

2012-02-21 22:29:03 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-02-21 22:29:03 PS_GAMELOG__system log end (GameLog01)

2012-02-21 22:29:03 3 1 SService::ServiceCtrlDispatcher(): service shutdown

LOGIN...

2012-02-21 22:30:15 PS_LOGIN__system log start (Login01)

2012-02-21 22:30:16 DB userdata connect error, id=Shaiya, pass=Mypassword

2012-02-21 22:30:16 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-02-21 22:30:16 PS_LOGIN__system log end (Login01)

2012-02-21 22:30:16 3 1 SService::ServiceCtrlDispatcher(): service shutdown

RebeccaBlack · 02/22/2012, 06:03

The problem is with the databases, it's having trouble connecting.. You say it works until two users connect to the database?

Are they using the same login as the server uses, or a different one?

[GM]Tinkerbell · 02/22/2012, 17:04

Same hunny we both using the 'Shaiya''Mypassword" buti have allowed in MSSQL to have 3 concurrent users
We have gone back to Teamveiwer for the moment but I would prefer if i could getthis workig as i hate my curser being stolen lol

[DEV]xXDASHXx · 02/24/2012, 08:23

Quote:

Originally Posted by [GM]Tinkerbell

Same hunny we both using the 'Shaiya''Mypassword" buti have allowed in MSSQL to have 3 concurrent users
We have gone back to Teamveiwer for the moment but I would prefer if i could getthis workig as i hate my curser being stolen lol

If it is doing it when you are connected in mssql and not when you are not connected I would suggest simply creat another account with all rights for sql