PSM>Gamegroups>Gamegroups01>Game wont stay started

[Dekodan]

PSM>Gamegroups>Gamegroups01>Game wont stay started what do i need to do please be specific

[George St-Pierre]

Double post?

[Dekodan]

yeah sorry bout that but insteead of complaining about that what about helping?

[treica]

because you mess up the PS_GameData check your database if have this database inside!

[Dekodan]

where can i get the latest database?

it also says that physical file cant be found operating system error when i try to put a database into the SQL can someone give me a detailed explanation as to what i need to do when i download the database?

[treica]

This one is the best for ep5
More explained things only by researching all this forum you may receive, as we did not everything can be so easy just to get everything on your post!
you really have to do it before you start a server, you can't just get it online and do nothing sincerelly!

[Dekodan]

ok thats the one that i have but where do i put the extracted files?
cause i had it attached but it wasnt working so i removed them all but they wont attach now what do i do?

ok PS_GameData is in the SQL yet the PSM still doesnt start Game and stay started what is causing and how to fix it?

[treica]

post your logs ca be founded on
C:\ShaiyaServer\Server\PSM_Client\bin\log there is some text files with the errors you may post them so i can find out an help for you.

[Dekodan]

2012-05-13 16:49:26 error mob item drop info load error

2012-05-13 16:49:28 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_DEFINEDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

2012-05-13 16:49:28 CGameData::LoadItemLimit: err=-1, query=exec usp_Read_ItemCount_ByServer_R

2012-05-13 16:49:28 DB table load error item limit

2012-05-13 16:49:28 3 1 SService::ServiceCtrlDispatcher(): m_pService->Init()

2012-05-13 16:49:28 Call save all waiting...

2012-05-13 16:49:28 Call save all failed dbagent disconnected(user count = 0)...

2012-05-13 16:49:28 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-05-13 16:49:28 Save MobID=1963109

2012-05-13 16:49:28 PS_GAME__system log end (Game01)

2012-05-13 16:49:28 3 1 SService::ServiceCtrlDispatcher(): service shutdown

thats the shortened verserion of it it says service start names a few mobs then repeats2012-05-13 16:49:26 error mob item drop info load error a lot of time then finishes with what i posted

[treica]

I see that you don't have added the linked servers connection
C:\ShaiyaServer\Server\Batch there is a .txt document named Linked Servers open it then copy the content and paste as a new query into database then look at it better because is asking for some credenials and there input at name Shaiya and password Shaiya123 and once you feel up all these informations execute the new query after this will should start all services cuz this is your error

2012-05-13 16:49:28 err=-1, [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find server 'PS_DEFINEDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers., SQL STATE: 42000, NATIVE ERROR: 7202 (0x1C22)

I want you to fix this up read better and do the things right, good luck.

[Dekodan]

ok in the batch folder it says config as a text document im sure it is correct but when i executed it it show up with this "Msg 15405, Level 11, State 1, Procedure sp_addsrvrolemember, Line 45
Cannot use the special principal 'Shaiya'.
"

im sorry for sounding so stupid on this subject lol i am new to it i appreciate ur patience

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

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

--exec PS_UserData.dbo.usp_Create_ShaiyaAccount 1, 'admin', admin123

/* Add to Game User: admin, Password: admin123 */
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, Point, Enpassword, Birth)
VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);
END

this is the text i copied and i clicked on Databases then went to New Query under file then pasted and saved it and executed it came up with "Msg 15405, Level 11, State 1, Procedure sp_addsrvrolemember, Line 45 Cannot use the special principal 'Shaiya'" and PSM Game still didnt stay started

ok in the batch folder it says config as a text document im sure it is correct but when i executed it it show up with this "Msg 15405, Level 11, State 1, Procedure sp_addsrvrolemember, Line 45
Cannot use the special principal 'Shaiya'.
"

im sorry for sounding so stupid on this subject lol i am new to it i appreciate ur patience

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

IF NOT EXISTS (SELECT srvname FROM master..sysservers WHERE srvname='game')
BEGIN
EXEC sp_addlinkedserver 'game','','SQLOLEDB','127.0.0.1';
EXEC sp_addlinkedsrvlogin 'game','false',null,'Shaiya','Shaiya123';
END

exec sp_serveroption @server='game', @optname='rpc', @optvalue='true';
exec sp_serveroption @server='game', @optname='rpc out', @optvalue='true';

--exec PS_UserData.dbo.usp_Create_ShaiyaAccount 1, 'admin', admin123

/* Add to Game User: admin, Password: admin123 */
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, Point, Enpassword, Birth)
VALUES (1,'admin', 'admin123', GETDATE(), 1, 255,'',16,'', DATEADD(year, +10, GETDATE()),'A',NULL,NULL,NULL,0,NULL,NULL);
END

this is the text i copied and i clicked on Databases then went to New Query under file then pasted and saved it and executed it came up with "Msg 15405, Level 11, State 1, Procedure sp_addsrvrolemember, Line 45 Cannot use the special principal 'Shaiya'" and PSM Game still didnt stay started

[treica]

open database go to Linked Servers > Logins there should be 4 5 connectors named game, gamedb01 and so on...click right on each and go to proprieties will open a new window and on left corner is some options choose Security then down on right corner were 2 white lines and there is writen Shaiya and a password retype on the password place Shaiya123 and click ok, this you should do for each connector.

If you are sure you have all databases then it should fix your problem.With anything else i can't help you out if your not able to fix this problem, here on this forum were alot of other topics with services don't start...you have to read!

[Dekodan]

i did read and noone mentioned what you said and what you said helped i got everything working fine except i cant find game.exe i think after this i can get started and wont need anymor help lol

[cypherxxl]

Before u change anything!

Did u update ur server once, before start?

[Dekodan]

ok idk if i did or not what do you mean by update my server? explain how to plz and also i cant hex edit Game.exe because i cant find Game.exe at all in any folders