Problem wih DB connection

Page 1 of 2 1 2
11/04/2015 18:24 Piccoloale099#1
Hi, i am having a problem installing a server Shaiya on my vps.I'm using clean omega files. I've looked everywhere but nothing has been helpful.
Here is my log:

PS_DBAGENT__system

PS_GAME__system

PS_GAMELOG__system

PS_LOGIN__system

PS_SESSION__system

PS_USERLOG__system

If I try to connect with sql server management studio through credentials (Shaiya and Shaiya123) from vps connects but if i try to connect from my pc doesn't connect.
That's all, thanks guys :)
11/04/2015 19:04 Truth1010#2
Error connecting to Database. Double check you have the Shaiya - Shaiya123 user in SQL (security)
Make sure all the encrypted passwords are set in your .ini files as well. There is a tool inside PSM_Server called ps_passwordEnc. Use that with password Shaiya123 for each place you see something like this in your .ini files.
Code:
GameData=127.0.0.1, PS_GameData, shaiya, D0B874C7F08BED32E3B312C1C861AA9F80D2EDE505EB072D98A4EDABC37CE0D734D737B8F8713AD56B6761B24A73545091BF52388E980BDD5AB6B9F3C9D49063547874D6E26C50C663D4DB47FAC20FA671675AA1467999666DB0E61E154E0A7A1E321446A30CEF003A4B55E999345D440E73537A9B3B6EA8EA04182D763E9A24
I usually create a new enc.password for each separate line like that. But I'm not sure if it's needed.
Also, make sure you have your linked servers installed and set properly.
[Only registered and activated users can see links. Click Here To Register...] - Credits to ShaiyaOmega
11/04/2015 19:36 Piccoloale099#3
Quote:
Originally Posted by Truth1010 View Post
Error connecting to Database. Double check you have the Shaiya - Shaiya123 user in SQL (security)
Make sure all the encrypted passwords are set in your .ini files as well. There is a tool inside PSM_Server called ps_passwordEnc. Use that with password Shaiya123 for each place you see something like this in your .ini files.
Code:
GameData=127.0.0.1, PS_GameData, shaiya, D0B874C7F08BED32E3B312C1C861AA9F80D2EDE505EB072D98A4EDABC37CE0D734D737B8F8713AD56B6761B24A73545091BF52388E980BDD5AB6B9F3C9D49063547874D6E26C50C663D4DB47FAC20FA671675AA1467999666DB0E61E154E0A7A1E321446A30CEF003A4B55E999345D440E73537A9B3B6EA8EA04182D763E9A24
I usually create a new enc.password for each separate line like that. But I'm not sure if it's needed.
Also, make sure you have your linked servers installed and set properly.
[Only registered and activated users can see links. Click Here To Register...] - Credits to ShaiyaOmega
Thanks but everything already done, i installed same files on a virtual machine for a test local server and there were no problems but since i'm trying on vps i'm having this problem. I think it is a configuration problem of sql server i already configured the firewall but still nothing
11/04/2015 20:25 SnickQ#4
As log say
Code:
2015-11-04 17:06:54 DB gamedata connect error
Your server files cant connect to your sql database.
Problem is in your sql config.
First you should test connect with Sql Manager "connect Object explorer" with SQL Auth and Server Name =127.0.0.1 Pass Shaiya123
11/04/2015 20:45 Truth1010#5
Have you allowed outside access to the VPS so that you can actually connect with the database from your home PC?
It's been a long time since i used a VPS, but if i remember right, you have to allow some settings depending on your host to allow connections.
11/04/2015 23:59 Piccoloale099#6
Quote:
Originally Posted by SnickQ View Post
As log say
Code:
2015-11-04 17:06:54 DB gamedata connect error
Your server files cant connect to your sql database.
Problem is in your sql config.
First you should test connect with Sql Manager "connect Object explorer" with SQL Auth and Server Name =127.0.0.1 Pass Shaiya123
SnickQ, i already tested it and from the vps sql manager connect but from my pc doesn't connect
Quote:
Originally Posted by Truth1010 View Post
Have you allowed outside access to the VPS so that you can actually connect with the database from your home PC?
It's been a long time since i used a VPS, but if i remember right, you have to allow some settings depending on your host to allow connections.
Truth1010, i've allowed outside access (firewall settings and sql server->properties->connections->allow remote connections)
11/05/2015 00:08 SnickQ#7
Code:
select @@servername
You should have 127.0.0.1

if not

Code:
sp_dropserver 'your sql name'
GO
sp_addserver '127.0.0.1', local
GO
also check your sql config

[Only registered and activated users can see links. Click Here To Register...]
11/05/2015 00:17 Truth1010#8
What exactly are you trying to connect to SSMS with?
the host IP, or 127.0.0.1 (local) ?
The server name needs to be whatever it is on your host PC. If i remember correctly the IP of the VPS should be enough, then use SQL auth for user/pass.

If all else fails, contact your VPS host company. They may be blocking it on their end for some reason. I had the same problem with a webserver being blocked from the host until i messaged them asking about it and they got it fixed right away.
11/05/2015 00:35 SnickQ#9
Quote:
Originally Posted by Truth1010 View Post
What exactly are you trying to connect to SSMS with?
the host IP, or 127.0.0.1 (local) ?
The server name needs to be whatever it is on your host PC. If i remember correctly the IP of the VPS should be enough, then use SQL auth for user/pass.

If all else fails, contact your VPS host company. They may be blocking it on their end for some reason. I had the same problem with a webserver being blocked from the host until i messaged them asking about it and they got it fixed right away.
his server files cant connect to local sql server
11/05/2015 01:04 Truth1010#10
Not entirely sure what OP is actually asking. I thought it was one thing at first, then another. Now i'm starting to think that he has the DB held on his VPS, but the PSM_Client/Server held on his home PC.

So he uses the ServerPatchConfig from his home PC to start the server, and all database entries go to his VPS.

If that is what you are trying to do, Piccoloale. Then in your config .ini files, you need to write like this.
Code:
[SERVER]
ServerName=Game
ServerPort=
MaxConnection=3000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=VPS IP, PS_GameDefs, DB USER, 061F863CE8E7059E75D8BEDB44E1B415BFBFD8579AE47E46A6EC4375E7E6F68E794E3E35C754B3B1F5712C3171A49E94E4787D7ED624F02009B674C6BE5D8852F947D6808BF4518331BC6B3B726E4A6AF9ED4B50FB987C271442E5BE7DD2FE76F4B72360BFA34238C0FB883640B12E103D22C97C8E85D3B3182166828D0084C6
GameData=VPS IP, PS_GameData, DB USER, 6FFB54AFCEB3E77917276E25637656C9E24E13DE462C9855421C67CD29938A5A87371DFA15BD7094CF644EEC2D5E2FF55374891A8325FE76295FEF259FFEC29E66EC1BC73B18FAB2EF391C4FDCA4E1ED983F1CA01240F43DE97DFF7B3E0F2412015B4D5C2BD91D59C976977BC974EE67CD9A85D00D819DBA20CCBE3857085666
[GAMEINFO]
GameName=Server Name
GamePublicIP=HOME IP
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
11/05/2015 07:04 Piccoloale099#11
Quote:
Originally Posted by SnickQ View Post
Code:
select @@servername
You should have 127.0.0.1

if not

Code:
sp_dropserver 'your sql name'
GO
sp_addserver '127.0.0.1', local
GO
also check your sql config

[Only registered and activated users can see links. Click Here To Register...]
SnickQ, i checked and i've 127.0.0.1...All others settings checked and set fine

Quote:
Originally Posted by Truth1010 View Post
Not entirely sure what OP is actually asking. I thought it was one thing at first, then another. Now i'm starting to think that he has the DB held on his VPS, but the PSM_Client/Server held on his home PC.

So he uses the ServerPatchConfig from his home PC to start the server, and all database entries go to his VPS.

If that is what you are trying to do, Piccoloale. Then in your config .ini files, you need to write like this.
Code:
[SERVER]
ServerName=Game
ServerPort=
MaxConnection=3000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
DBAgent=127.0.0.1
GameLog=127.0.0.1
[DB]
GameDef=VPS IP, PS_GameDefs, DB USER, 061F863CE8E7059E75D8BEDB44E1B415BFBFD8579AE47E46A6EC4375E7E6F68E794E3E35C754B3B1F5712C3171A49E94E4787D7ED624F02009B674C6BE5D8852F947D6808BF4518331BC6B3B726E4A6AF9ED4B50FB987C271442E5BE7DD2FE76F4B72360BFA34238C0FB883640B12E103D22C97C8E85D3B3182166828D0084C6
GameData=VPS IP, PS_GameData, DB USER, 6FFB54AFCEB3E77917276E25637656C9E24E13DE462C9855421C67CD29938A5A87371DFA15BD7094CF644EEC2D5E2FF55374891A8325FE76295FEF259FFEC29E66EC1BC73B18FAB2EF391C4FDCA4E1ED983F1CA01240F43DE97DFF7B3E0F2412015B4D5C2BD91D59C976977BC974EE67CD9A85D00D819DBA20CCBE3857085666
[GAMEINFO]
GameName=Server Name
GamePublicIP=HOME IP
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=0
Append=1
[MONITOR]
Enable=0
Port=50000
Truth1010, sorry if i was not clear and for my bad english. I'm not trying to start nothing from my pc, i am working completely on a server, all files are there just i was trying to connect to remote database on my vps with vps remote ip
11/05/2015 08:36 Truth1010#12
Oh i see now. In that case...

Check TCP port 1433. That needs to be open for remote access to SQL. TCP port 1434 may also be needed, that's for the SQL Browser.

And when connecting remotely, if you are set to have named instances, other than default. Then you must connect like
Code:
12.34.56.78\SQLINSTANCENAME
The logs you originally posted show that the server is failing to connect to the DB though, that's why the confusion. It looks like your asking 1 question, but showing problems linked to another :)
11/05/2015 09:28 Piccoloale099#13
Quote:
Originally Posted by Truth1010 View Post
Oh i see now. In that case...

Check TCP port 1433. That needs to be open for remote access to SQL. TCP port 1434 may also be needed, that's for the SQL Browser.

And when connecting remotely, if you are set to have named instances, other than default. Then you must connect like
Code:
12.34.56.78\SQLINSTANCENAME
The logs you originally posted show that the server is failing to connect to the DB though, that's why the confusion. It looks like your asking 1 question, but showing problems linked to another :)
Port 1433 and also 1434 are opened anyway I don't care this problem for now... My priority is to start server...Any ideas?
11/06/2015 10:21 Piccoloale099#14
#up someone?
11/06/2015 11:23 SnickQ#15
Put some screen how you config your SQL because we cant see your sql and cant help you.
Page 1 of 2 1 2