[Help] Database

getupkid77 · 03/30/2019, 16:54

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

Velocity. · 03/30/2019, 17:33

Quote:

Originally Posted by getupkid77

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

post your logs here, please. also opening up the sql ports are a security risk.

getupkid77 · 03/30/2019, 21:18

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:

isconnect: (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:

isconnect: (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:

isconnect: (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:

isconnect: (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

Velocity. · 03/30/2019, 21:32

Quote:

Originally Posted by getupkid77

PS_Game

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

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?
If you like we could chat on discord or skype to try and find the exact problem.

getupkid77 · 03/30/2019, 21:46

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

Velocity. · 03/30/2019, 22:32

Quote:

Originally Posted by getupkid77

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

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.
The issue could come from multiple things.
add me on skype and I can take a look if you like.

getupkid77 · 03/30/2019, 23:34

okay thank you i gotta do some electrical work on my house today ill add you tonight or tomorrow thanks again