|
You last visited: Today at 13:30
Advertisement
[HELP] Shaiya Database Secure??
Discussion on [HELP] Shaiya Database Secure?? within the Shaiya Private Server forum part of the Shaiya category.
12/20/2012, 22:17
|
#1
|
elite*gold: 0
Join Date: Mar 2011
Posts: 62
Received Thanks: 1
|
[HELP] Shaiya Database Secure??
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
|
|
|
|
12/20/2012, 23:45
|
#2
|
elite*gold: 0
Join Date: Jan 2011
Posts: 238
Received Thanks: 901
|
check if you changed your linked servers to the new username and password.
set your Public IP from whatsmyip.com.
|
|
|
12/21/2012, 00:03
|
#3
|
elite*gold: 0
Join Date: Mar 2011
Posts: 62
Received Thanks: 1
|
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?
|
|
|
12/21/2012, 02:16
|
#4
|
elite*gold: 0
Join Date: Sep 2011
Posts: 140
Received Thanks: 147
|
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
|
|
|
12/21/2012, 03:54
|
#5
|
elite*gold: 0
Join Date: Mar 2011
Posts: 62
Received Thanks: 1
|
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?
|
|
|
12/21/2012, 04:17
|
#6
|
elite*gold: 0
Join Date: Nov 2012
Posts: 142
Received Thanks: 153
|
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.
|
|
|
12/21/2012, 06:26
|
#7
|
elite*gold: 360
Join Date: Jul 2012
Posts: 143
Received Thanks: 228
|
Check this link out, i already see something wrong with your hashes.
|
|
|
Similar Threads
|
WTS Slayers Of Shaiya/Draconia Shaiya DataBase.
11/27/2012 - Shaiya Trading - 1 Replies
This includes
database
server files
ap coins in server
drops done
scripts
maps
all to do with server side if anyone wants a full episode 5.5 server files, has everything in it still.
|
Shaiya Secure Register Script error
04/07/2012 - Shaiya Private Server - 1 Replies
Hallo Leute kann mir einer was zu diesem error sagen?
"Failed to create a new account, please try again later"
Oder mir sagen wieso der keinen Account erstellen kann
Danke im vorraus :)
|
All times are GMT +2. The time now is 13:30.
|
|