[Video Tutorials] Shaiya EP4 Private Server By Omega

Page 48 of 53

12/15/2011 04:23 ShaiyaOmega#706

Read through this thread and you will probably find that your linked servers are not correctly installed.

Because PS_USERDB01 is a linked server and it is called by a stored procedure so either correctly install the linked servers or use Abrasives Fix Here

Quote:
Originally Posted by abrasive
Disconnect after selecting game server and clicking ok

I've ran into this specific cause of the above many times now, and it always happens to me when I set up a fresh server. Never have I seen anyone else mention it before though. I decided to add it here just in case it would be useful to someone.

Inside of PS_GameData.dbo.usp_Read_Char_Product_Item_E there is this query:
Code:
SELECT Slot,ItemID,ItemCount FROM PS_USERDB01.PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID
Since PS_USERDB01 does not exist, it causes my client to disconnect after selected the server and clicking ok.

To fix it, I remove PS_USERDB01 from the stored procedure so the query looks like this:
Code:
SELECT Slot,ItemID,ItemCount FROM PS_Billing.dbo.Users_Product WHERE UserUID=@UserUID

To check if the linked servers exist open MSSQL Management Studio.
Expand Server Objects Then Linked Servers. and there should be A PS_USERDB01 listed there.

12/16/2011 19:36 rohanhoare#707

Ok, client now works, I added the IP: 127.0.0.1, but now I just got 2 questions. If everybody use this ip, the server will have everybody else that created it aswell ? And aslo I can't login, I don't know what are my login I.Ds.. If someone can help me it would be nice thank you :)

12/16/2011 19:44 JohnHeatz#708

Just go to the PS_UserData.dbo.Users_Master and create an account for yourself.

As for the IP it is LOCAL IP, so just will work for your computer

12/16/2011 19:51 rohanhoare#709

When I want to open PS_UserData etc.. it says: La base de donn�es PS_UserData est inaccessible. (Microsoft.SqlServer.Express.ObjectExplorer)

12/16/2011 19:54 JohnHeatz#710

You need to be logged with an full administrative user of your SQL DataBase

12/16/2011 19:56 rohanhoare#711

How do I login with a full admin ? I have no ID's ? :/ Where do I create an account and is it free ? Isn't there a default account for the server ?

Ok.. Before, my Microsoft SQL Windows Login was working, but now everytime I want to connect it says:

Impossible d'ouvrir la base de donn�es par d�faut de l'utilisateur. �chec de la connexion.
�chec de l'ouverture de session de l'utilisateur*'Rohan-PC\Rohan'. (Microsoft SQL Server, Erreur*: 4064) Please someone help me :(

12/17/2011 21:24 RadiantChild#712

Ello guys, I have successfully installed this server and runs brilliantly on local.
I then decided to go forth and make it public so me and my friend could actually begin messing around and start making changes to drops and so on.
I followed this [Only registered and activated users can see links. Click Here To Register...] and it fails to connecto server.

I have searched around alot on google and on other forums for help but decided to try here. Any and all help will be greatly appreciated thank you.

12/17/2011 21:45 JohnHeatz#713

Check on your logs, they will tell you exactly what is failing in there; also a more accurate and detailed description of your issue would help us to help you as it has been -possibly- asked already

12/17/2011 21:47 rohanhoare#714

But how do I make a full admin account for MySQL ? Wasn't there a default account created when I done the server ?

12/17/2011 22:04 RadiantChild#715

My appologies if I fail to provide the right log but here is PS_LOGIN_system log

Code:

2011-12-17 18:23:38 PS_LOGIN__system log start (Login01)

2011-12-17 18:23:57 <Console input> /vchkoff

2011-12-17 18:23:57 <Console output> cmd version chk off ok

2011-12-17 19:23:49 cmd_auto server info log

 user = 0 (0/5000)

2011-12-17 19:23:49 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

2011-12-17 19:23:49 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)

2011-12-17 19:41:06 3 1 SERVICE_CONTROL_STOP

2011-12-17 19:41:06 1 1 SAgent::Disconnect: (3, 1236)

2011-12-17 19:41:06 1 1 SAgent::Disconnect: (3, 1236)

2011-12-17 19:41:06 1 1 T=001:17:00:000, RC=14,RCS=0, RB=155,RBS=0, SC=480,SCS=0, SB=3833,SBS=0

2011-12-17 19:41:06 1 1 T=001:17:00:000, RC=10,RCS=0, RB=40,RBS=0, SC=15,SCS=0, SB=93,SBS=0

2011-12-17 19:41:06 mgr server disconnection

2011-12-17 19:41:06 log system server disconnection

2011-12-17 19:41:06 PS_LOGIN__system log end (Login01)

2011-12-17 19:41:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown

12/17/2011 22:09 rohanhoare#716

RadiantChild, Do you know how I make a full administrator account for MSQL ? And what is the game logins (the default ones) ?

If it is possible to use Navicat SQL for this server please tell me how someone

12/17/2011 22:16 RadiantChild#717

Rohan, did you patch the game.exe using LPH's tool? if so then I had the same problem as you but I did it manually and got it to run. Just use HxD in this tutorial's 'useful links' and patch it manually. This tutorial is by AriezOMG:

and you should be able to login easily.

[EDIT:woops forgot to mention my own problem lol. John I followed the tutorial by blackhatjoe and changed the PublicIP= in the game exe and PS_game.ini along with the port forwards. I get a 'cannot conect to server. Check notice board' error

12/17/2011 22:22 rohanhoare#718

I've already patched the game.exe with the I.P 127.0.0.1 etc.. But I got a problem, I have no ID's to connect and I can't create one with SQL because I can't access to the database. So I don't know what to do now. I must know if there is a default account already created and if there is anyway to access the database or use another SQL system.

12/17/2011 22:29 RadiantChild#719

Idk mate, I wouldn't say there is no acct data on the DB as you can't access to confirm it. However I'd recommend reinstall the entire server from scratch and follow the tutorial to the dot. Use Shaiya123 as your password whilst installing the server, where it asks you about the 'mix mode authentication' and later on when you're all stable and running change it to whatever you like there's plenty of tuts on here for that.

12/18/2011 05:23 Shaiya Aqua#720

Quote:

Originally Posted by RadiantChild

My appologies if I fail to provide the right log but here is PS_LOGIN_system log

Code:

2011-12-17 18:23:38 PS_LOGIN__system log start (Login01)

2011-12-17 18:23:57 <Console input> /vchkoff

2011-12-17 18:23:57 <Console output> cmd version chk off ok

2011-12-17 19:23:49 cmd_auto server info log

 user = 0 (0/5000)

2011-12-17 19:23:49 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

2011-12-17 19:23:49 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)

2011-12-17 19:41:06 3 1 SERVICE_CONTROL_STOP

2011-12-17 19:41:06 1 1 SAgent::Disconnect: (3, 1236)

2011-12-17 19:41:06 1 1 SAgent::Disconnect: (3, 1236)

2011-12-17 19:41:06 1 1 T=001:17:00:000, RC=14,RCS=0, RB=155,RBS=0, SC=480,SCS=0, SB=3833,SBS=0

2011-12-17 19:41:06 1 1 T=001:17:00:000, RC=10,RCS=0, RB=40,RBS=0, SC=15,SCS=0, SB=93,SBS=0

2011-12-17 19:41:06 mgr server disconnection

2011-12-17 19:41:06 log system server disconnection

2011-12-17 19:41:06 PS_LOGIN__system log end (Login01)

2011-12-17 19:41:06 3 1 SService::ServiceCtrlDispatcher(): service shutdown

Hello , Make sure you are putting in both commands /vchkoff /nprotect before trying to log into game , if still having problems PM me and ill send you my skype and help past this matter

Page 48 of 53

« First

Last »