@ how did you get hacked?
your end unproctected or maybe backdoor in files?anyone checked?
SQL Server 2014.. fresh install from microsoft.. if you don't disable the port 1433 to be accessible from the outside.. then some hacker can hack you somehow.. idk what exploit he uses but ya.. he gets full root access to your RDP and installs some kind i forgot already but it looks like a java icon to make it look legitimate taking all your CPU resources.. if you End Task it it will come back in about a minute.. you need to go into safe mode and delete the whole folder it creates to get rid of it.. I probably had this virus
Server files are not backdoored dont worry its not that it was 100% SQL Server 2014 that was compromised. The crypto miner was running on username MSSQL$INSTANCE or whatever in the task manager.. meaning it was started by SQL Server 2014.
I run a server with only 8 GB it has little lag.. but still has lag.. but ya its the cheapest I could get.. 7.99$/month for 8 GB ram.. and its always at 90-99% Memory and 80-90% CPU.. i burn the server like crazy but it still pulls through online for a month without crashes.
I been running a SQL Profiler to find out why my server gets the game blackscreen.. even though it was working fine for a month.. and i found out these problems on it.
These 4 queries it does have a semicolon for no reason.. probably some faulty procedures or functions
this select above is most likely generated by a SQL exploit that hijacks your server.. and is probably responsible for the black screen.. I can't figure out where it comes from I will update this post after I dump my whole database to SQL.
I found a google answers page that says 0x0904D00034 and collationname has something to do with xp_cmdshell which is used to run files on your computer to install trojans/viruses etc..
I can't see which scripts are ran on SQL Server Profiler when I restart the SQL Server because i'm not fast enough to start a new trace after a connection is lost.. so i cant find it that way.
I also recommend everyone start using SQL Server 2018 or newer.. and install
SSMS-Setup-ENU.exe (534 MB)
What occurred. Procedure [dbo]. [rasp_OneTimeKeyAuth] is waiting for an incoming parameter 'ID' that was not passed in the procedure input. The variable '@p5' returns a result, this variable refers to an external application and is declared in it.
Your incoming settings are:
Quote:
@ID nvarchar(64) = N'' <- is null
@IDNum int = 16104
@OneTimeKey nvarchar(10) = N'69365227'
@AddTime int = 0
@Result int OUTPUT = '@p5' <- is an external server variable. This is the output of the procedure. Output data value '1' or '-1'. We leave an exit empty.
@isInit bit = 1
If you perform the procedure with these incoming parameters, you get the result of this error:
"Procedure or function 'rasp_OneTimeKeyAuth' expects parameter '@ID', which was not supplied."
It is enough to change the incoming parameters, such as the incoming parameter '@ID' set to a default value (not null) because it is not used in this procedure.
In general, this procedure is doubtful, here it is:
ALTER PROCEDURE [dbo].[rasp_OneTimeKeyAuth]
@ID nvarchar(64)
, @IDNum int
, @OneTimeKey nvarchar(10)
, @AddTime int
, @Result int OUTPUT
, @isInit bit = 0
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
DECLARE
@ExpireTime smalldatetime
SET @ExpireTime = DATEADD(second, -@AddTime, GETDATE())
IF EXISTS (SELECT * FROM dbo.tbl_OneTimeKey WHERE IDNum = @IDNum and ExpireTime >= @ExpireTime and OneTimeKey = @OneTimeKey and OneTimeKey <> N'')
SET @Result = 1
ELSE
SET @Result = -1
IF @isInit = 1
begin
UPDATE dbo.tbl_OneTimeKey SET OneTimeKey = N'' WHERE IDNum = @IDNum
end
ID - don`t use. Is UserID (client game login).
The first condition is not met: ...and OneTimeKey <> N''... <- The OneTimeKey record is empty in the table.
[dbo].[tbl_OneTimeKey]:
Quote:
IDNum
ExpireTime
OneTimeKey
16106
2020-01-25 00:31:00
16107
2020-01-24 01:29:00
The second condition works by flag "1" of incoming parameter "@isInit". It clears the OneTimeKey entry in the table.
any idea why it has a semicolon ? ; I can't find that semicolon anywhere in that function ? but anyways I got it all working.. its still got the black screen but it goes away in 5-10 seconds.. and loads game.. just laggy SQL Server/Server in general. I ran a SQL fragmentation indexes rebuild query I found on google which made it a little faster.
do it without script it looks like this.. very time consuming
I ran this script.. it runs like 20 different scripts to optimize your SQL Databases.
main script is you will need it's about 500 KB.. very big script
if you get errors you may also need to run these below
you can find all the files you need at github too
after the script is installed into master database run these
When the level rises above 150 (through the database), the experience in the database ceases to be recorded. I understand this restriction at the exe file level. Has anyone managed to get around this?
------------------------------------------------
seems to be a limitation at the server exе
say in TextMgr_CharInfo_ENG file you find the npc/mob Artillerywoman which is listed as 2194. But her real Id is 2316? where can I find this 2316 which links to 2194 which file is that do you know?
say in TextMgr_CharInfo_ENG file you find the npc/mob Artillerywoman which is listed as 2194. But her real Id is 2316? where can I find this 2316 which links to 2194 which file is that do you know?
All pc\npc can be found in ..Atlantica\CharInfo\CharAttackInfo.ndt file.
In the "NameTextNum" field, their text name number.
The value "Char" contains the system name.
VipSrO Hapy New Year Surprise Start Acc 120 Lvl 01/30/2020 - SRO PServer Advertising - 8 Replies VipSrO PvP serverimiz adı üstünde PvP serverdir.. Bu amaçla 110 olan başlangıç charları yılbaşı eventi olarak 120 ye yükseltilmiştir.. Bundan böyle yeni oyuncularımız 120 level ve 5m sp + Full nova set ile başlayacaktır..
VipSrO Online Silkroad PvP Server 120 Start + 5m SP + Full Nova Set + Max Level 120 + All Map Open
Max Level 120
Client version: v1.404
ServerFiles: Vietnam Silkroad
Start 120 Level + 5m SP + nova full set Gift
ScriptVessel (surprise, surprise) 12/31/2006 - Conquer Online 2 - 3 Replies Hi,
Before I purchase ScriptVessel can people please post any feedback on stability, ease of use, features, developer support, etc.
Just wandering as it appears to be mixed reception upto now.
thx in advance
how did you get hacked?
online for a month without crashes.
