Problem wih DB connection

Piccoloale099 · 11/04/2015, 18:24

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

Spoiler

PS_GAME__system

Spoiler

PS_GAMELOG__system

Spoiler

PS_LOGIN__system

Spoiler

PS_SESSION__system

Spoiler

PS_USERLOG__system

Spoiler

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

Truth1010 · 11/04/2015, 19:04

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.

- Credits to ShaiyaOmega

Piccoloale099 · 11/04/2015, 19:36

Quote:
Originally Posted by Truth1010
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.
- 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

SnickQ · 11/04/2015, 20:25

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

Truth1010 · 11/04/2015, 20:45

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.

Piccoloale099 · 11/04/2015, 23:59

Quote:
Originally Posted by SnickQ
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

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)

SnickQ · 11/05/2015, 00:08

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

Truth1010 · 11/05/2015, 00:17

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.

SnickQ · 11/05/2015, 00:35

Quote:

Originally Posted by Truth1010

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

Truth1010 · 11/05/2015, 01:04

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

Piccoloale099 · 11/05/2015, 07:04

Quote:
Originally Posted by SnickQ
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

SnickQ, i checked and i've 127.0.0.1...All others settings checked and set fine

Quote:
Originally Posted by Truth1010
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

Truth1010 · 11/05/2015, 08:36

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

Piccoloale099 · 11/05/2015, 09:28

Quote:
Originally Posted by Truth1010
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?

Piccoloale099 · 11/06/2015, 10:21

#up someone?

SnickQ · 11/06/2015, 11:23

Put some screen how you config your SQL because we cant see your sql and cant help you.