downloading – I want to download torrent files to a fashdrive attached to modem or router (local server ) by initiating the download from the mobile device

I want to download torrent files from my mobile but since I don’t have enough storage I want the files to be downloaded to my local server (the flashdrive/pendrive attached to my modem which can be accessed wirelessly), Is there a way to do this?

I don’t want my laptop running continuously for downloading torrent files, instead I would like to use my mobile phone but the problem is that I have very limited storage in my android device. Is there a way to download to a remote Pendrive or storage device attached to my modem or router?
Thanks in advance.

sharepoint server – Site on https starts working only after refreshing page on http page

I have a SharePoint server with sp name which I can access by http://sp.

I’ve

  1. added this server to some domain and could access it by http://sp.domain.local;
  2. created and added certificate to this server, so I could access it by https://sp.domain.local and by https://sp;
  3. allowed access to it from Internet by https://external.domain.com

Issue:

When I try to access the server by http://sp.domain.local, https://sp.domain.local, https://external.domain.com after some time, for example, in a day, it allows me to be logged in, but does not display the Documents list content and search does not work.

When I refresh http://sp page, then Documents List content becomes visible and search starts to work here on http and https protocols and with sp.domain.local and external.domain.com names.

Question:

Which settings on SP or IIS side could be the cause of such behavior?

Windows Server 2019 hacking case

A strange case occurred recently on our Windows Server 2019.

It runs some Hyper-V VMs,
Apache+PHP7 via mod_fcgid (as a service logged in as a restricted user www),
Nginx (as a service logged in as a restricted user www-front),
A nodejs server and stunnel (which was working as local system, it’s obviously a mistake, now corrected)

So the firewall was on with only necessary ports open to public.

One day I noticed that an extra Administrator account named ht was added and security log cleared.

From what I can tell from logs, it all started with a request to the file on an old legacy website. The whole site was ionCube encoded, except this file:

<?PHP
$current_memory = ini_get('memory_limit');
$current_memory = preg_replace('/D/', '', $current_memory);
if ($current_memory <= '512') { ini_set('memory_limit','1024M'); }

ini_set('max_execution_time','120');

phpinfo();
?>

Then, somehow this file was appended with code that saves uploaded file, though www user has no write permissions on this directory altogether. I even tried to append something myself as www and got “Access Denied”, as expected.

Something even more weird happens, local system disables the firewall

A Windows Defender Firewall setting in the Public profile has changed.
New Setting:
Type:   Enable Windows Defender Firewall
Value:  No
Modifying User: SYSTEM
Modifying Application:  C:WindowsSystem32netsh.exe

A new user gets created and added to admins group.
That user connects via RDP which is now available as the Firewall is down, makes a web shell under that website root directory (which was not writeable for the www user), makes a couple of requests to it, then does nothing more.

So the question is, how did he manage to do things using the Local System account? Could it be a vulnerability in stunnel? Any similar cases known?

sql server – Check if contract conflict with another contract query

I have a database with these tables as the bellow picture showed:

enter image description here

The user can create a new contract each contract may have one or more shops and these shops status changes depending on the contracts, everything works perfectly until now.
my problem in renewing the contract, I have a feature that allows the user to renew a contract, in this case, I get all the original contract info and make the new contract start from the end date of the original contract + 1 day with the same original contract info.

my question here is how to check if this renewal contract does not conflict with other contracts for the same customer and the same shops (customer can have many contracts)

E.G.:

I have contracts like this:

con_id    shop_id   start_date    end_date
--------------------------------------------
  1         1       14-04-2021    14-04-2022
  2         1       15-04-2022    15-04-2023

If the user clicked on contract number 1 and tried to renew it, I want a query to check if the new contract start date does not conflict with another contract for this user and these shops.

Like in my above data I want to prevent the user from renewing contract number 1 again because there is already a contract renewed before in that period.

This is what I tried:

--IF EXISTS (SELECT * FROM contracts_view where cust_id=123456789 and @date_start >= date_start and @date_start <= date_end and shop_id in (select shop_id from contracts_shops where contract_id =@old_contract_id)) 
--BEGIN
--    SELECT @ErrorMessage = ERROR_MESSAGE()
--  RAISERROR ('asdasd', 10, 1)
--  ROLLBACK TRAN
--   return
--END

and here is my stored procedure for renewing a contract:

ALTER PROCEDURE (dbo).(contract_renew)
-- Add the parameters for the stored procedure here
@cust_id int,
@duration int,
@price decimal(10,2),
@tax decimal(10,2),
@usage nvarchar(20),
@rent_type nvarchar(10),
@price2 decimal(10,2),
@note2 nvarchar(max),
@date_start date,
@date_end date,
@note nvarchar(max),
@app_user nvarchar(20),
@old_contract_id int
AS
BEGIN

DECLARE @ErrorMessage NVARCHAR(MAX)
DECLARE @ID int

BEGIN TRAN
BEGIN TRY

-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

--insert data
INSERT INTO (dbo).(contracts)
       ((cust_id)
       ,(duration)
       ,(price)
       ,(tax)
       ,(usage)
       ,(rent_type)
       ,(price2)
       ,(note2)
       ,(date_start)
       ,(date_end)
       ,(note)
       ,(app_user))
 VALUES
       (@cust_id,
       @duration,
       @price,
       @tax,
       @usage,
       @rent_type,
       @price2,
       @note2,
       @date_start,
       @date_end,
       @note,
       @app_user) SELECT SCOPE_IDENTITY();

       SET @ID = SCOPE_IDENTITY();


insert into contracts_shops (contract_id, shop_id)
select @ID, shop_id
FROM contracts_shops WHERE contract_id = @old_contract_id;

COMMIT

END TRY
BEGIN CATCH
    SELECT @ErrorMessage = ERROR_MESSAGE()
    RAISERROR (@ErrorMessage, 10, 1)
    ROLLBACK TRAN
END CATCH
END

subquery – Subqueries in SQL Server

I am taking a SQL course and am completely stumped on this question.

Using a subquery have a query that returns:
CustomerID, EmailAddress, FirstName, LastName, ‘#3: Customers who have ordered than 1 product’ as
queryInfo
The subquery from this query will be: All customers with who have ordered more than 1 product

Note: More than one Product, not Quantity > 1 So a customer who ordered 10 of the same
product is NOT what I’m looking for.

Here is the full query I used:

SELECT c.CustomerID
     , c.EmailAddress
     , c.FirstName
     , c.LastName
     , '#3: Customers who have ordered more than 1 product' AS queryInfo
  FROM Customers c
 WHERE c.CustomerID IN (
           SELECT p.ProductID 
             FROM Customers c 
             JOIN Orders o
                  ON c.CustomerID = o.CustomerID
             JOIN OrderItems oi
                  ON o.OrderID = oi.OrderID
             JOIN Products p
                  ON oi.ProductID = p.ProductID 
         GROUP BY p.ProductID 
           HAVING COUNT(*) > 1
         )
     ;

Not sure what I am doing wrong, but any input is greatly appreciated. Thanks!

squid – Something updating /run/systemd/resolve/stub-resolv.conf on Ubuntu 20.04 LTS server

I’ve got 2 server. 1 is Ubuntu 18.04 LTE, the other is Ubuntu 20.04 LTE. With the 18.04 version, my /etc/resolve.conf file is fine , I can edit it (I have disabled auto-network configuration on Linodes end, so that it doesn’t get overwritten on reboot).

The issue is with the 20.04 version.

ls -lh /etc/resolv.conf                                                                                                                             lrwxrwxrwx 1 root root 39 Feb 19  2020 /etc/resolv.conf -> ../run/systemd/resolve/stub-resolv.conf

If I go to: /run/systemd/resolve , I can see the stub-resolv.conf file. When I reload that folder 10-20 seconds in the future, the timestamp has changed. So something is causing it to update. I only bothered to check that folder, as I was getting an error when trying to save the file in pico:

enter image description here

I’m not really sure what else to try to debug what is changing the file / network config? We have unbound installed as Squid Proxy. Could one of those be interfering with it? (that exists on both servers)

AD server rebuild but no backups available

We have a AD server in our premises in which OS has crashed. No backups where configured on this. I have a different machine where I can install the same OS, is there any ways to restore the AD to the new one with all the settings, users and computer details and DNS server record ? This was the only AD server which was there in the site.

sql server – How to Cast today data as bigint to Data – 202104171830


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




development – Query sharepoint list data in sql server


Your privacy


By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.




What's changed in 10yrs: one "big" server or multiple "smaller" servers?

I was googling and came across this question "one "big" server or multiple "smaller" servers?" which was originally asked here: [url]https:/… | Read the rest of https://www.webhostingtalk.com/showthread.php?t=1843456&goto=newpost