Hi all i have setup EP5.4 with sql2012 everything works except game and gamelog goes to green arrow and back i have made a 5.3 server before but i cannot figure out what is wrong here opened ports 1433 and 1434 changed .inis did all the setup and still cant figure it out
[Help] Database
03/30/2019 16:54
getupkid77#1
03/30/2019 17:33
Velocity.#2
post your logs here, please. also opening up the sql ports are a security risk.Quote:
Hi all i have setup EP5.4 with sql2012 everything works except game and gamelog goes to green arrow and back i have made a 5.3 server before but i cannot figure out what is wrong here opened ports 1433 and 1434 changed .inis did all the setup and still cant figure it out
03/30/2019 21:18
getupkid77#3
PS_Game
2019-03-30 11:46:45 PS_GAME__system log start (Game01) [KR]
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/sorp1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/croco1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/croco2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Troll1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Spink1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/GoldenPig
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Sorp3
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/SorpNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/SorpNamed2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Sorp2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrocoNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrocoNamed2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrocoNamed3
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/OrcNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/OrcNamed2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/OrcNamed3
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/TrollNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Deinos
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Parridalis
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Alcarian
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/ZinAlcaria
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Belizabeth
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Kirhiross
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrypticOne
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Haruhion
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Freezing
2019-03-30 11:46:45 RandomOption Error : ItemID=23060, byServer=1, Wis=0
2019-03-30 11:46:45 RandomOption Error : ItemID=40253, byServer=4, Wis=0
2019-03-30 11:47:48 connect mgr 1280
2019-03-30 11:47:49 connect dbagent 1288
2019-03-30 11:47:49 connect dbagent2 1292
2019-03-30 11:47:49 Market End -----------------------
2019-03-30 11:47:50 gamelog connect failed
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=1,RCS=1, RB=5,RBS=5, SC=2,SCS=2, SB=70,SBS=70
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=5,RCS=5, RB=2252,RBS=2252, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=3,RCS=3, RB=2064,RBS=2064, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 discon dbagent2 ((3,1236, 2064,37)
2019-03-30 11:47:50 dbagent2 Connection Lost INFO : T=000:00:00:000, RC=3,RCS=3, RB=2064,RBS=2064, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 db agent2 server disconnected...
2019-03-30 11:47:50 discon dbagent ((3,1236, 2252,37)
2019-03-30 11:47:50 dbagent Connection Lost INFO : T=000:00:00:000, RC=5,RCS=5, RB=2252,RBS=2252, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 db agent server disconnected...
2019-03-30 11:47:50 call disconnectAll...
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=2,SCS=2, SB=105,SBS=105
2019-03-30 11:47:50 discon userlog ((3,1236, 0,105)
2019-03-30 11:47:50 userlog Connection Lost INFO : T=000:00:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=2,SCS=2, SB=105,SBS=105
2019-03-30 11:47:50 userlog log server disconnection
2019-03-30 11:47:50 discon mgr ((3,1236, 5,70)
2019-03-30 11:47:50 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
2019-03-30 11:47:50 mgr server disconnection
2019-03-30 11:47:50 server shutdown Connection INFO : T=000:01: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
2019-03-30 11:47:50 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2019-03-30 11:47:50 Call save all waiting...
2019-03-30 11:47:50 Call save all failed dbagent disconnected(user count = 0)...
2019-03-30 11:47:50 server shutdown Connection INFO : T=000:01: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
2019-03-30 11:47:50 Save Shaiya.SData 0
2019-03-30 11:47:50 PS_GAME__system log end (Game01)
2019-03-30 11:47:50 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GameLog
2019-03-30 11:46:52 PS_GAMELOG__system log start (GameLog01)
2019-03-30 11:46:52 DB gamelog connect error
2019-03-30 11:46:52 init db error
2019-03-30 11:46:52 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2019-03-30 11:46:52 PS_GAMELOG__system log end (GameLog01)
2019-03-30 11:46:52 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_Login
2019-03-30 11:46:47 PS_LOGIN__system log start (Login01)
2019-03-30 12:46:57 cmd_auto server info log
user = 0 (0/5000)
2019-03-30 12:46:57 T=001: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
2019-03-30 12:46:57 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)
SSyncQueueStatus::SQueueStatusNode=0(0/0)
2019-03-30 13:46:58 cmd_auto server info log
user = 0 (0/5000)
2019-03-30 13:46:58 T=002: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
2019-03-30 13:46:58 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)
SSyncQueueStatus::SQueueStatusNode=0(0/0)
2019-03-30 14:46:58 cmd_auto server info log
user = 0 (0/5000)
sorry for the delay got alot going on but looks like something with the game cant connect and im not sure why i looked at other similar posts but havent found a solution thanks in advance :)
2019-03-30 11:46:45 PS_GAME__system log start (Game01) [KR]
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/sorp1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/croco1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/croco2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Troll1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Spink1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/GoldenPig
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Sorp3
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/SorpNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/SorpNamed2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Sorp2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrocoNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrocoNamed2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrocoNamed3
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/OrcNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/OrcNamed2
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/OrcNamed3
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/TrollNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/HellTouthNamed1
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Deinos
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Parridalis
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Alcarian
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/ZinAlcaria
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Belizabeth
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Kirhiross
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/CrypticOne
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Haruhion
2019-03-30 11:46:45 Loaded Behavior In Factory : data/ai/Freezing
2019-03-30 11:46:45 RandomOption Error : ItemID=23060, byServer=1, Wis=0
2019-03-30 11:46:45 RandomOption Error : ItemID=40253, byServer=4, Wis=0
2019-03-30 11:47:48 connect mgr 1280
2019-03-30 11:47:49 connect dbagent 1288
2019-03-30 11:47:49 connect dbagent2 1292
2019-03-30 11:47:49 Market End -----------------------
2019-03-30 11:47:50 gamelog connect failed
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=1,RCS=1, RB=5,RBS=5, SC=2,SCS=2, SB=70,SBS=70
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=5,RCS=5, RB=2252,RBS=2252, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=3,RCS=3, RB=2064,RBS=2064, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 discon dbagent2 ((3,1236, 2064,37)
2019-03-30 11:47:50 dbagent2 Connection Lost INFO : T=000:00:00:000, RC=3,RCS=3, RB=2064,RBS=2064, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 db agent2 server disconnected...
2019-03-30 11:47:50 discon dbagent ((3,1236, 2252,37)
2019-03-30 11:47:50 dbagent Connection Lost INFO : T=000:00:00:000, RC=5,RCS=5, RB=2252,RBS=2252, SC=1,SCS=1, SB=37,SBS=37
2019-03-30 11:47:50 db agent server disconnected...
2019-03-30 11:47:50 call disconnectAll...
2019-03-30 11:47:50 1 1 SAgent::Disconnect: (3, 1236)
2019-03-30 11:47:50 1 1 T=000:00:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=2,SCS=2, SB=105,SBS=105
2019-03-30 11:47:50 discon userlog ((3,1236, 0,105)
2019-03-30 11:47:50 userlog Connection Lost INFO : T=000:00:00:000, RC=0,RCS=0, RB=0,RBS=0, SC=2,SCS=2, SB=105,SBS=105
2019-03-30 11:47:50 userlog log server disconnection
2019-03-30 11:47:50 discon mgr ((3,1236, 5,70)
2019-03-30 11:47:50 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
2019-03-30 11:47:50 mgr server disconnection
2019-03-30 11:47:50 server shutdown Connection INFO : T=000:01: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
2019-03-30 11:47:50 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2019-03-30 11:47:50 Call save all waiting...
2019-03-30 11:47:50 Call save all failed dbagent disconnected(user count = 0)...
2019-03-30 11:47:50 server shutdown Connection INFO : T=000:01: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
2019-03-30 11:47:50 Save Shaiya.SData 0
2019-03-30 11:47:50 PS_GAME__system log end (Game01)
2019-03-30 11:47:50 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_GameLog
2019-03-30 11:46:52 PS_GAMELOG__system log start (GameLog01)
2019-03-30 11:46:52 DB gamelog connect error
2019-03-30 11:46:52 init db error
2019-03-30 11:46:52 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()
2019-03-30 11:46:52 PS_GAMELOG__system log end (GameLog01)
2019-03-30 11:46:52 3 1 SService::ServiceCtrlDispatcher(): service shutdown
PS_Login
2019-03-30 11:46:47 PS_LOGIN__system log start (Login01)
2019-03-30 12:46:57 cmd_auto server info log
user = 0 (0/5000)
2019-03-30 12:46:57 T=001: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
2019-03-30 12:46:57 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)
SSyncQueueStatus::SQueueStatusNode=0(0/0)
2019-03-30 13:46:58 cmd_auto server info log
user = 0 (0/5000)
2019-03-30 13:46:58 T=002: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
2019-03-30 13:46:58 SContext=2(1022/1024)
SContextSend=0(1024/1024)
SContextAccept=0(0/0)
SPacketBufferSendS=1(1023/1024)
SPacketBufferSendM=0(1024/1024)
SPacketBufferSendB=2(1022/1024)
SSyncQueueBufferSend::SQueueSendNode=1(1023/1024)
SSyncQueueBufferPriority::SQueuePrioritySendNode=0 (0/0)
SSyncQueueStatus::SQueueStatusNode=0(0/0)
2019-03-30 14:46:58 cmd_auto server info log
user = 0 (0/5000)
sorry for the delay got alot going on but looks like something with the game cant connect and im not sure why i looked at other similar posts but havent found a solution thanks in advance :)
03/30/2019 21:32
Velocity.#4
Its hard to say what the exact problem is, one thing is for sure as you can see is the gamelog doesn't want to connect. are you sure you installed sql correctly? all databases are there? all login info is correct with the correct perms?Quote:
2019-03-30 11:47:50 gamelog connect failed
2019-03-30 11:46:52 DB gamelog connect error
2019-03-30 11:46:52 init db error
If you like we could chat on discord or skype to try and find the exact problem.
03/30/2019 21:46
getupkid77#5
must be something in gamelog every time i start it it goes back to puase this is the current set up
[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 09A07C38DFD7AC300A1E444D370ADA77B63EA67397C4815612 B762094B0E16BE2CAD257516659815CE5AAED195FEF8C55C9F C2898984C15E13988AC432B70E08D013430DC2A4A212C87FBA DEDC9FB34F4BA5E31FECD734A9BC0DE553CF7621AD3F3C255E D4068B09625E96774AC8BF8AF13399BBE618FF8CD9EEA14945 6A59E5
DBChat01=127.0.0.1, PS_ChatLog, Shaiya, 09A07C38DFD7AC300A1E444D370ADA77B63EA67397C4815612 B762094B0E16BE2CAD257516659815CE5AAED195FEF8C55C9F C2898984C15E13988AC432B70E08D013430DC2A4A212C87FBA DEDC9FB34F4BA5E31FECD734A9BC0DE553CF7621AD3F3C255E D4068B09625E96774AC8BF8AF13399BBE618FF8CD9EEA14945 6A59E5
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 09A07C38DFD7AC300A1E444D370ADA77B63EA67397C4815612 B762094B0E16BE2CAD257516659815CE5AAED195FEF8C55C9F C2898984C15E13988AC432B70E08D013430DC2A4A212C87FBA DEDC9FB34F4BA5E31FECD734A9BC0DE553CF7621AD3F3C255E D4068B09625E96774AC8BF8AF13399BBE618FF8CD9EEA14945 6A59E5
DBChat01=127.0.0.1, PS_ChatLog, Shaiya, 09A07C38DFD7AC300A1E444D370ADA77B63EA67397C4815612 B762094B0E16BE2CAD257516659815CE5AAED195FEF8C55C9F C2898984C15E13988AC432B70E08D013430DC2A4A212C87FBA DEDC9FB34F4BA5E31FECD734A9BC0DE553CF7621AD3F3C255E D4068B09625E96774AC8BF8AF13399BBE618FF8CD9EEA14945 6A59E5
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
03/30/2019 22:32
Velocity.#6
Ok, but this doesn't tell me anything. I don't know how you setup the sv so I would need to take a look at it to see exactly.Quote:
[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 09A07C38DFD7AC300A1E444D370ADA77B63EA67397C4815612 B762094B0E16BE2CAD257516659815CE5AAED195FEF8C55C9F C2898984C15E13988AC432B70E08D013430DC2A4A212C87FBA DEDC9FB34F4BA5E31FECD734A9BC0DE553CF7621AD3F3C255E D4068B09625E96774AC8BF8AF13399BBE618FF8CD9EEA14945 6A59E5
DBChat01=127.0.0.1, PS_ChatLog, Shaiya, 09A07C38DFD7AC300A1E444D370ADA77B63EA67397C4815612 B762094B0E16BE2CAD257516659815CE5AAED195FEF8C55C9F C2898984C15E13988AC432B70E08D013430DC2A4A212C87FBA DEDC9FB34F4BA5E31FECD734A9BC0DE553CF7621AD3F3C255E D4068B09625E96774AC8BF8AF13399BBE618FF8CD9EEA14945 6A59E5
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001
The issue could come from multiple things.
add me on skype and I can take a look if you like.
03/30/2019 23:34
getupkid77#7
okay thank you i gotta do some electrical work on my house today ill add you tonight or tomorrow thanks again