[HELP] Session will not stay active

[[Legend]]

Whenever I go to start the server, everything goes to green arrow, but then session will return back to pause which eventually causes everything to slowly return to green pause.
I read everything on here and have had no luck.
Can anyone help me?
Logs:

 Spoiler

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Shaiya, 981109D80F1736CF686EA961CA0A991E8C098EACF2FD8161AC 14C3EF1CD59C02529BBD946FF9193E1CD3E4A28AB9E375C20E CAEA663CD089C851842DC62C9DCD9EA9AA8F16F67009C6D78E BFBF52F1B2464E35BB982360502A4D5624A4DC43AE5FDB47F0 4DE5E5AE9C5473EA55A77E773A0AF5B620B7694F54D3E07FD6 837F4E
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

 Spoiler

[SERVER]
ServerName=Game01
ServerPort=
MaxConnection=5000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=127.0.0.1, PS_GameDefs, Shaiya, 981109D80F1736CF686EA961CA0A991E8C098EACF2FD8161AC 14C3EF1CD59C02529BBD946FF9193E1CD3E4A28AB9E375C20E CAEA663CD089C851842DC62C9DCD9EA9AA8F16F67009C6D78E BFBF52F1B2464E35BB982360502A4D5624A4DC43AE5FDB47F0 4DE5E5AE9C5473EA55A77E773A0AF5B620B7694F54D3E07FD6 837F4E
GameData=127.0.0.1, PS_GameData, Shaiya, 981109D80F1736CF686EA961CA0A991E8C098EACF2FD8161AC 14C3EF1CD59C02529BBD946FF9193E1CD3E4A28AB9E375C20E CAEA663CD089C851842DC62C9DCD9EA9AA8F16F67009C6D78E BFBF52F1B2464E35BB982360502A4D5624A4DC43AE5FDB47F0 4DE5E5AE9C5473EA55A77E773A0AF5B620B7694F54D3E07FD6 837F4E
[GAMEINFO]
GameName=Shaiya
GamePublicIP=127.0.0.1
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

 Spoiler

[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Shaiya, 981109D80F1736CF686EA961CA0A991E8C098EACF2FD8161AC 14C3EF1CD59C02529BBD946FF9193E1CD3E4A28AB9E375C20E CAEA663CD089C851842DC62C9DCD9EA9AA8F16F67009C6D78E BFBF52F1B2464E35BB982360502A4D5624A4DC43AE5FDB47F0 4DE5E5AE9C5473EA55A77E773A0AF5B620B7694F54D3E07FD6 837F4E
DBChat01=127.0.0.1, PS_ChatLog, Shaiya, 981109D80F1736CF686EA961CA0A991E8C098EACF2FD8161AC 14C3EF1CD59C02529BBD946FF9193E1CD3E4A28AB9E375C20E CAEA663CD089C851842DC62C9DCD9EA9AA8F16F67009C6D78E BFBF52F1B2464E35BB982360502A4D5624A4DC43AE5FDB47F0 4DE5E5AE9C5473EA55A77E773A0AF5B620B7694F54D3E07FD6 837F4E
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

 Spoiler

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=500
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, SHaiya, 981109D80F1736CF686EA961CA0A991E8C098EACF2FD8161AC 14C3EF1CD59C02529BBD946FF9193E1CD3E4A28AB9E375C20E CAEA663CD089C851842DC62C9DCD9EA9AA8F16F67009C6D78E BFBF52F1B2464E35BB982360502A4D5624A4DC43AE5FDB47F0 4DE5E5AE9C5473EA55A77E773A0AF5B620B7694F54D3E07FD6 837F4E
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

 Spoiler

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=
[CONNECTION]
UserLog=127.0.0.1
[GAMESERVERS]
GameServerCount=1
Game01=Shaiya
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

 Spoiler

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, Shaiya, 981109D80F1736CF686EA961CA0A991E8C098EACF2FD8161AC 14C3EF1CD59C02529BBD946FF9193E1CD3E4A28AB9E375C20E CAEA663CD089C851842DC62C9DCD9EA9AA8F16F67009C6D78E BFBF52F1B2464E35BB982360502A4D5624A4DC43AE5FDB47F0 4DE5E5AE9C5473EA55A77E773A0AF5B620B7694F54D3E07FD6 837F4E
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50001

Errors

 Spoiler

2018-03-22 09:49:52 PS_GAME__system log start (PS_GAME) [KR]

2018-03-22 09:49:52 Game server count is 0

2018-03-22 09:49:52 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-03-22 09:49:52 Call save all waiting...

2018-03-22 09:49:52 Call save all failed dbagent disconnected(user count = 0)...

2018-03-22 09:49:52 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

2018-03-22 09:49:52 PS_GAME__system log end (PS_GAME)

2018-03-22 09:49:52 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2018-03-22 09:41:27 PS_SESSION__system log start (Session)

2018-03-22 09:41:28 userlog connect failed

2018-03-22 09:41:28 initserver() failed

2018-03-22 09:41:28 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-03-22 09:41:28 PS_SESSION__system log end (Session)

2018-03-22 09:41:28 3 1 SService::ServiceCtrlDispatcher(): service shutdown

 Spoiler

2018-03-22 10:36:56 PS_DBAGENT__system log start (DBAgent01)

2018-03-22 10:37:13 DB gamedata connect error

2018-03-22 10:37:13 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2018-03-22 10:37:13 DBKillCountSave db alloc failed

2018-03-22 10:37:13 SAVE kill count ERROR

2018-03-22 10:37:13 CKeepObeliskMgr:BSave db alloc failed

2018-03-22 10:37:13 SAVE g_KeepObeliskMgr ERROR

2018-03-22 10:37:13 GuildMgrSave:BSave db alloc failed

2018-03-22 10:37:13 SAVE g_GuildMgrSave ERROR

2018-03-22 10:37:13 PS_DBAGENT__system log end (DBAgent01)


2018-03-22 10:37:13 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Legend

[{Skrillex}]

Whassup,
Please check you LinkedServer in MSSQL Management Studio.

Regards

[[Legend]]

Originally Posted by .:Skrillex:.

Whassup,
Please check you LinkedServer in MSSQL Management Studio.

Regards

This was the link command I ran. I obviously changed all the username and PW spots to my DB info when I ran it. The links show up under linked servers but still getting errors when I try to start the server.

 Spoiler

/* Add server link, and Shaiya username */
IF NOT EXISTS (SELECT [name] FROM master.dbo.syslogins WHERE name = 'Shaiya')
BEGIN
EXEC sp_addlogin 'your-db-username', 'your-db-userpassword', 'PS_GameDefs';
END
EXEC sp_addsrvrolemember 'your-db-username', 'sysadmin';

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

if exists(select *
from master..sysservers
where isremote=1 and srvname='game')
begin
exec sp_dropserver 'game','droplogins'
end
exec sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'game','false',null,'your-db-username','your-db-userpassword'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_NCASH')
begin
exec sp_dropserver 'PS_NCASH','droplogins'
end
exec sp_addlinkedserver 'PS_NCASH','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_NCASH','false',null,'your-db-username','your-db-userpassword'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB')
begin
exec sp_dropserver 'PS_USERDB','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB','false',null,'your-db-username','your-db-userpassword'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_USERDB01')
begin
exec sp_dropserver 'PS_USERDB01','droplogins'
end
exec sp_addlinkedserver 'PS_USERDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_USERDB01','false',null,'your-db-username','your-db-userpassword'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_DEFINEDB')
begin
exec sp_dropserver 'PS_DEFINEDB','droplogins'
end
exec sp_addlinkedserver 'PS_DEFINEDB','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_DEFINEDB','false',null,'your-db-username','your-db-userpassword'

if exists(select *
from master..sysservers
where isremote=1 and srvname='PS_GAMEDB01')
begin
exec sp_dropserver 'PS_GAMEDB01','droplogins'
end
exec sp_addlinkedserver 'PS_GAMEDB01','','SQLOLEDB','127.0.0.1'
exec sp_addlinkedsrvlogin 'PS_GAMEDB01','false',null,'your-db-username','your-db-userpassword'

/* Add to Game User: admin, Password: admin123 and user information*/

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Master WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Master
(UserUID, UserID, Pw, JoinDate, Admin, AdminLevel, UseQueue, Status, Leave, LeaveDate, UserType, UserIp, ModiIp, ModiDate, Enpassword, Point)
VALUES (1,'gmlight', 'gmlight123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,NULL,0);
END


IF NOT EXISTS (SELECT UserUID FROM OMG_GameWEB.dbo.GameAccountTBL WHERE UserUID=1)
BEGIN
INSERT INTO OMG_GameWEB.dbo.GameAccountTBL
(UserUID,GameAccount,OneTimePassword,OTPExpireDate ,DelCharPWD,CreateDate)
VALUES (1,'gmlight','gmlight123',DATEADD(year, +20, GETDATE()),'ff',GETDATE())
END

IF NOT EXISTS (SELECT UserUID FROM PS_UserData.dbo.Users_Detail WHERE UserUID=1)
BEGIN
INSERT INTO PS_UserData.dbo.Users_Detail
(UserID,UserUID,UserName,SocialNo1,SocialNo2,PwQue stion,PwAnswer,Email,PostNo,Addr1,Addr2,Phone1,
Phone2,Phone3,Mobile1,Mobile2,Mobile3,NewsLetter,S ms,AdultAuth,AdultAuthDate,EmailAuth,EmailAuthKey,
Job,JobNo,LocalNo,PwQuNo)
VALUES ('gmlight',1,'Light',NULL,NULL,'question','answer' ,'email@somewhere',NULL,NULL,NULL,NULL,NULL,NULL,N ULL,NULL,NULL,'0','0',
'0',NULL,'0',NULL,NULL,NULL,NULL,NULL)
END

If you would, PM me your skype so we can team view. I cannot figure it out.

[dorado1234]

1-Please, check if your sql config have all protocols in "yes" and enabled.

SQL Server Configuration Manager.

[arjulie]

PLEASE GUYS THIS PROBLEM IS ALREADY FIX USE SEARCH BUTTON PLEASE THIS SHAIYA COMMUNITY HAS GOT TO MUCH OLD QUESTION THAT ALREADY ANSWER WE REPEAT AGAIN AND AGAIN

USE SEARCH.

TO ALL NEW ON THIS COMMUNITY WHO HAVE PLANING TO MAKE SHAIYA SERVER PLEASE PLEASE USE YOUR HEAD AND THE SEARCH BUTTON IS FREE.

[[Legend]]

Originally Posted by arjulie

PLEASE GUYS THIS PROBLEM IS ALREADY FIX USE SEARCH BUTTON PLEASE THIS SHAIYA COMMUNITY HAS GOT TO MUCH OLD QUESTION THAT ALREADY ANSWER WE REPEAT AGAIN AND AGAIN

USE SEARCH.

TO ALL NEW ON THIS COMMUNITY WHO HAVE PLANING TO MAKE SHAIYA SERVER PLEASE PLEASE USE YOUR HEAD AND THE SEARCH BUTTON IS FREE.

Like I stated in the post, I have searched the forums for hours and attempted to fix my issues. This is not my first server and I have never had this issue before. The resolution is not on the forums.

Originally Posted by dorado1234

1-Please, check if your sql config have all protocols in "yes" and enabled.

SQL Server Configuration Manager.

All protocols are enabled and my TCP/UDP is all set to yes and IP "127.0.0.1"
Ports are set to 1433.
Am I suppose to place something special under the Named Pipes?


I believe my error is somewhere here, but I do not understand where it is. Session is the only thing giving me a hard time. The error from the logs files is "userlog connect failed" "initserver() failed"
All people say about this is check ini's and I have far to many times.

 Spoiler

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=
[CONNECTION]
UserLog=127.0.0.1
[GAMESERVERS]
GameServerCount=1
Game01=game
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

[AnimuNazi]

Use latest SQL and what server/client files are you using, the problem is on PS_Session i recommend do a roll back delete and add it again

[arjulie]

Originally Posted by [Legend]

Like I stated in the post, I have searched the forums for hours and attempted to fix my issues. This is not my first server and I have never had this issue before. The resolution is not on the forums.



All protocols are enabled and my TCP/UDP is all set to yes and IP "127.0.0.1"
Ports are set to 1433.
Am I suppose to place something special under the Named Pipes?


I believe my error is somewhere here, but I do not understand where it is. Session is the only thing giving me a hard time. The error from the logs files is "userlog connect failed" "initserver() failed"
All people say about this is check ini's and I have far to many times.

 Spoiler

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=
[CONNECTION]
UserLog=127.0.0.1
[GAMESERVERS]
GameServerCount=1
Game01=game
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000

if you search on this forum this question already answered i'm active on this forum since 2009 and every day checking and see what latest post and question here some of new comers post that already answer the issue on that problem search before post you cannot learn if every error you cannot find solution for your part shaiya game and shaiya server have many bugs and if you cannot find solution in your 1st attempt of making server please i will tell you stop doing server.

[dorado1234]

2018-03-22 10:37:13 DB gamedata connect error

first, you have reason

you're right. He need search first before that make a thread, but i think that give him a answers can be fast before make a big post about "use search button"
Please guys, search and later make a thread. This forum have a big information about shaiya private server.

[[Legend]]

Originally Posted by dorado1234

2018-03-22 10:37:13 DB gamedata connect error

first, you have reason

you're right. He need search first before that make a thread, but i think that give him a answers can be fast before make a big post about "use search button"
Please guys, search and later make a thread. This forum have a big information about shaiya private server.

Again, for the second time, I have ALREADY SEARCHED. None of the current threads offer a solution to my problem. Maybe you should read the entire thread before commenting arrogant and unhelpful things.
I still have no found the solution and multiple people have looked at it. The files are used were released here and no one else had these issues with them.

Originally Posted by PerfectlyImperfection

Use latest SQL and what server/client files are you using, the problem is on PS_Session i recommend do a roll back delete and add it again

I am using ProfNerwosol's EP4 files and instructions.

[momocruz]

this is the most current problem , delete and reset all linked server , and do it again with easy pass and username, like shaiya and shaiya123 , and if you close port no-one can enter on db or host ,that was i always used for my servers,

[arjulie]

if i see the solution on your problem in this forum ?

your problem is in your database see this error : Call save all failed dbagent disconnected(user count = 0