[HELP] Shaiya Database Secure??

Devine Souls · 12/20/2012, 22:17

Hello Elitepvpers, i have changed my password in database and im able to login with the user and password that I changed and then I put in the Hash code into my ini files but when I did that and start my servers and login and when I select my servers I get Disconnected so not sure what im doing wrong
I did use the search but all the once i tryed it always is the same results here are all my ini files so not sure what im doing wrong.

Quote:

[SERVER]
ServerName=DBAgent01
ServerPort=
MaxConnection=
[DB]
GameData=127.0.0.1, PS_GameData, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
[LOGFILE]
Replace=1
Append=0
[MONITOR]
Enable=0
Port=50000

Quote:

[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, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
GameData=127.0.0.1, PS_GameData, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
[GAMEINFO]
GameName=Shaiya Annihilation
GamePublicIP=127.0.0.1
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=1
Append=0
[MONITOR]
Enable=0
Port=50000

[UNITED_WAR_SERVER]
PublicIP=whatismyip.com

Quote:

[SERVER]
ServerName=GameLog01
ServerPort=
MaxConnection=
[DB]
DBCount=1
DBGame01=127.0.0.1, PS_GameLog, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
DBChat01=127.0.0.1, PS_ChatLog, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
[LOGFILE]
Replace=1
Append=0
[MONITOR]
Enable=0
Port=50001

Quote:

[SERVER]
ServerName=Game254
ServerPort=
MaxConnection=5000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
GameDef=, PS_GameDefs, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
[GAMEINFO]
GameName=ServerName
GamePublicIP=whatismyip.com
GameVersion=0x00000000
GameLogDBID=1
[LOGFILE]
Replace=1
Append=0
[MONITOR]
Enable=0
Port=50000

[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id), GameServer IP, DBAgent IP, GameLog IP
GameServerCount=1
Game01=ServerName, 1, 1, 127.0.0.1, 127.0.0.1, 127.0.0.1

Quote:

[SERVER]
ServerName=Login01
ServerPort=
MaxConnection=5000
[CONNECTION]
Session=127.0.0.1
UserLog=127.0.0.1
[DB]
UserData=127.0.0.1, PS_UserData, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
[GAMESERVERS]
// Game01 = name, Mapping ServerID, Mapping DB ID(use prev server id)
GameServerCount=1
Game01=ServerName, 1, 1

[LOGFILE]
Replace=1
Append=0
[MONITOR]
Enable=0
Port=50000

Quote:

[SERVER]
ServerName=Session
ServerPort=
MaxConnection=

[CONNECTION]
UserLog=127.0.0.1

[GAMESERVERS]
GameServerCount=1
Game01=Shaiya Annihilation

[LOGFILE]
Replace=1
Append=0

[MONITOR]
Enable=0
Port=50000

[BILLING_GUM]
Enable=0
IP=10.10.10.32
Port=1072
ServerName=Shaiya
GroupNumber=1
ServerNumber=1
ZoneNumber=1
GameID=1
CPID=1

[BILLING_GBK]
Enable=0
IP=10.10.10.218
Port=10003

Quote:

[SERVER]
ServerName=UserLog
ServerPort=
MaxConnection=
[DB]
UserLog=127.0.0.1, PS_UserData, Reikeuseu, 1BCDE81DD57C8024F28E81EFDAA4E009A55F4660975693CE5D 8E546CD517BF029ED12D268095F376A00B7C8032FFD8C57214 F0F73370A748D9D8A71F24F4C4D681D0B778CB3DC9801220DE 13E63862C0A934C292DB9FD75BB9B78A57027FF2500B92B395 5B72CFFB646C5CF5DC3726C176DAC6C74DE4D20BAB1917C66C CF6AB2
[LOGFILE]
Replace=1
Append=0
[MONITOR]
Enable=0
Port=50001

ShaiyaOmega · 12/20/2012, 23:45

check if you changed your linked servers to the new username and password.
set your Public IP from whatsmyip.com.

Devine Souls · 12/21/2012, 00:03

Quote:

Originally Posted by ShaiyaOmega

check if you changed your linked servers to the new username and password.
set your Public IP from whatsmyip.com.

Ah ok, thanks I'm going to see if I can but just in case I don't is there a small tutorial of how to do it?

[ADMIN]Cryptic · 12/21/2012, 02:16

When you changed your password you need to recreate the linked server with your new pw.... best way to do that is to delete them and do this.

Code:

/* Add linked servers */

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','yourpassword';
END

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

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

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

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

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

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

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

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

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

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

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

remember to put in your password.

and just for the record. best way to secure your database is to close port 1433

Devine Souls · 12/21/2012, 03:54

Quote:

Originally Posted by [ADMIN]Cryptic

When you changed your password you need to recreate the linked server with your new pw.... best way to do that is to delete them and do this.

Code:

/* Add linked servers */

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','yourpassword';
END

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

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

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

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

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

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

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

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

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

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

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

remember to put in your password.

and just for the record. best way to secure your database is to close port 1433

Yea after I made the post i found a thread about closeing my port of 1433

do i just put in the port into my Router and Firewall? or just the Router?

~~[Sick]Syndicate~~ · 12/21/2012, 04:17

Quote:

Originally Posted by Devine Souls

Yea after I made the post i found a thread about closeing my port of 1433 do i just put in the port into my Router and Firewall? or just the Router?

just block into the firewall or if your hosting is a managed have them block it for you. as well if this is hosted from your house it is easy to open and close through your router.

Dreameh · 12/21/2012, 06:26

Check this link out, i already see something wrong with your hashes.