Not logical problem with green arrow...

[minichien]

Hey, i have follow the tutorial of nephren point per point but when i want start "green arrow" in the server patch config they back paused after some second :/ i have this error in PSM_Client => Bin => Log :

 Spoiler

2014-02-01 23:17:58 PS_DBAGENT__system log start (DBAgent01)

2014-02-01 23:18:15 DB gamedata connect error

2014-02-01 23:18:15 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2014-02-01 23:18:15 DBKillCountSave db alloc failed

2014-02-01 23:18:15 SAVE kill count ERROR

2014-02-01 23:18:15 CKeepObeliskMgr:BSave db alloc failed

2014-02-01 23:18:15 SAVE g_KeepObeliskMgr ERROR

2014-02-01 23:18:15 GuildMgrSave:BSave db alloc failed

2014-02-01 23:18:15 SAVE g_GuildMgrSave ERROR

2014-02-01 23:18:15 PS_DBAGENT__system log end (DBAgent01)


2014-02-01 23:18:15 3 1 SService::ServiceCtrlDispatcher(): service shutdown

-----

 Spoiler

2014-02-01 23:18:00 PS_GAME__system log start (Game01) [KR]

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/sorp1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/croco1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/croco2

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Troll1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Spink1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/GoldenPig

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Sorp3

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/SorpNamed1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/SorpNamed2

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Sorp2

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/CrocoNamed1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/CrocoNamed2

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/CrocoNamed3

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/OrcNamed1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/OrcNamed2

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/OrcNamed3

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/TrollNamed1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/HellTouthNamed1

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Deinos

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Parridalis

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Alcarian

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/ZinAlcaria

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Belizabeth

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Kirhiross

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/CrypticOne

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Haruhion

2014-02-01 23:18:00 Loaded Behavior In Factory : data/ai/Freezing

2014-02-01 23:18:17 DB gamedef connect error

2014-02-01 23:18:17 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2014-02-01 23:18:17 Call save all waiting...

2014-02-01 23:18:17 Call save all failed dbagent disconnected(user count = 0)...

2014-02-01 23:18:17 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

2014-02-01 23:18:17 Save Shaiya.SData 0

2014-02-01 23:18:17 PS_GAME__system log end (Game01)

2014-02-01 23:18:17 3 1 SService::ServiceCtrlDispatcher(): service shutdown

------

 Spoiler

2014-02-01 23:17:56 PS_GAMELOG__system log start (GameLog01)

2014-02-01 23:18:13 DB gamelog connect error

2014-02-01 23:18:13 init db error

2014-02-01 23:18:13 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2014-02-01 23:18:13 PS_GAMELOG__system log end (GameLog01)

2014-02-01 23:18:13 3 1 SService::ServiceCtrlDispatcher(): service shutdown

-----

 Spoiler

2014-02-01 23:18:00 PS_LOGIN__system log start (Login01)

2014-02-01 23:18:17 DB userdata connect error, id=Shaiya, pass=******

2014-02-01 23:18:17 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2014-02-01 23:18:17 PS_LOGIN__system log end (Login01)

2014-02-01 23:18:17 3 1 SService::ServiceCtrlDispatcher(): service shutdown

-----

 Spoiler

2014-02-01 23:17:53 PS_SESSION__system log start (Session)

2014-02-01 23:17:54 userlog connect failed

2014-02-01 23:17:54 initserver() failed

2014-02-01 23:17:54 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2014-02-01 23:17:54 PS_SESSION__system log end (Session)

2014-02-01 23:17:54 3 1 SService::ServiceCtrlDispatcher(): service shutdown

------

 Spoiler

2014-02-01 23:17:51 PS_USERLOG__system log start (UserLog)

2014-02-01 23:18:08 DB userlog connect error, Server=127.0.0.1, DBName=PS_UserData, User=Shaiya, Pass=******

2014-02-01 23:18:08 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2014-02-01 23:18:08 PS_USERLOG__system log end (UserLog)

2014-02-01 23:18:08 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Anyone can said me where i need to see if i have do a error or if i have forgot something...

Nephren answer:

 Spoiler

"That means your Password is wrong and it cannot connect. (Using different Password in database and config files)
Yes. You copy the Output-String and do it in every INI as your Password."

But i have whrite "******" for don't said my password for more secure ^^ i have check in the "new SQL installation" and in each .ini but my password is good everywhere :/

Finally i have uninstall all and try again ur tutorial but the problem of green arrow is again here... All username and password are good everywhere... Anyone can explain why i have again this problem?

P.S: sorry for the very bad english :/

P.S.2: And PSMServer_Config don't need to be change?

Thank

[AxelMac]

2013-06-29 20:17:24 DB gamedef connect error <---- Check linked servers needs same login info

[minichien]

This line in "New SQL installation"?
BEGIN
EXEC sp_addlogin 'Shaiya', '******', 'PS_GameDefs';
END

And i have found that:

 Spoiler

TRUNCATE TABLE PS_UserData.dbo.Users_Master;
TRUNCATE TABLE OMG_GameWEB.dbo.GameAccountTBL;
TRUNCATE TABLE PS_UserData.dbo.Users_Detail;

It's normaly? I don't think

[minichien]

#UP
Anyone can help me please? :/

[Autrux]

#moved