Plz help

02/20/2012 07:59 [GM]Tinkerbell#1
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::Disconnect: (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 ?
02/20/2012 12:47 RebeccaBlack#2
Quote:
Originally Posted by [GM]Tinkerbell View Post
RandomOption Error : ItemID=23060, byServer=1, Wis=0
Check out that ItemID. Seems there was a problem with it.
02/21/2012 02:42 [GM]Tinkerbell#3
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
02/21/2012 05:43 RebeccaBlack#4
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.
02/21/2012 23:41 [GM]Tinkerbell#5
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::DBSave db alloc failed

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

2012-02-21 22:30:03 GuildMgrSave::DBSave 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::Disconnect: (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
02/22/2012 06:03 RebeccaBlack#6
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?
02/22/2012 17:04 [GM]Tinkerbell#7
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
02/24/2012 08:23 [DEV]xXDASHXx#8
Quote:
Originally Posted by [GM]Tinkerbell View Post
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