The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,854 other subscribers

Archive for 2024

Great tip by Jen Gentleman on Twitter: “Colour coding all my meetings – seriously I don’t know why I held off for so long, it made my calendar so much easier to read

Posted by jpluimers on 2024/07/22

Reminder to check out the tools I use so I can go [Wayback/Archive] Jen Gentleman on Twitter: “Colour coding all my meetings – seriously I don’t know why I held off for so long, it made my calendar so much easier to read”

This is the scheme that Jen uses:ย [Wayback/Archive] Jen Gentleman on Twitter: “@melvinjoosten Yeah – I have a lot of recurring meetings, so I use one colour for 1-1s, one colour for big team meetings, and one colour for office hours. It makes it a lot easier to spot the one off meetings which have been added to my calendar (which I leave the default colour)”

or in list form, differentiate between:

  • one-on-one
  • big team
  • office hours
  • default (for events added by others)

–jeroen

Posted in Google, GoogleCalendar, LifeHacker, Office, Outlook, Power User | Leave a Comment »

IKEA ESCHER play table and chair (700ร—906)

Posted by jpluimers on 2024/07/19

Via [Wayback/Archive] โ˜… govertschilling on X: “die linksonder is het leukst ๐Ÿ™‚”: IKEA ESCHER play table and chair

[Wayback/Archive] GQ7TPlKW4AAFE_M (700ร—906)

Read the rest of this entry »

Posted in Fun | Leave a Comment »

Automated CrowdStrike BSOD Workaround in Safe Mode using Group Policy ยท GitHub

Posted by jpluimers on 2024/07/19

Most affected organisations have found out the hard way why out of band management is important.

Automated Workaround in Safe Mode using Group Policy

You can set up a GPO to run a script during Safe Mode. Hereโ€™s how you can do this:

  1. Create the PowerShell Script

    Create a PowerShell script that deletes the problematic CrowdStrike driver file causing BSODs and handles the Safe Mode boot and revert:

    # CrowdStrikeFix.ps1
    # This script deletes the problematic CrowdStrike driver file causing BSODs and reverts Safe Mode
    
    $filePath = "C:\Windows\System32\drivers\C-00000291*.sys"
    $files = Get-ChildItem -Path $filePath -ErrorAction SilentlyContinue
    
    foreach ($file in $files) {
        try {
            Remove-Item -Path $file.FullName -Force
            Write-Output "Deleted: $($file.FullName)"
        } catch {
            Write-Output "Failed to delete: $($file.FullName)"
        }
    }
    
    # Revert Safe Mode Boot after Fix
    bcdedit /deletevalue {current} safeboot
    
  2. Create a GPO for Safe Mode

    • Open the Group Policy Management Console (GPMC).
    • Right-click on the appropriate Organizational Unit (OU) and select Create a GPO in this domain, and Link it here....
    • Name the GPO, for example, CrowdStrike Fix Safe Mode.
  3. Edit the GPO

    • Right-click the new GPO and select Edit.
    • Navigate to Computer Configuration -> Policies -> Windows Settings -> Scripts (Startup/Shutdown).
    • Double-click Startup, then click Add.
    • In the Script Name field, browse to the location where you saved CrowdStrikeFix.ps1 and select it.
    • Click OK to close all dialog boxes.
  4. Force Safe Mode Boot Using a Script

    Create another PowerShell script to force Safe Mode boot and link it to a GPO for immediate application:

    # ForceSafeMode.ps1
    # This script forces the computer to boot into Safe Mode
    
    bcdedit /set {current} safeboot minimal
    Restart-Computer
    
  5. Create a GPO to Apply the Safe Mode Script

    • Open the Group Policy Management Console (GPMC).
    • Right-click on the appropriate Organizational Unit (OU) and select Create a GPO in this domain, and Link it here....
    • Name the GPO, for example, Force Safe Mode.
    • Right-click the new GPO and select Edit.
    • Navigate to Computer Configuration -> Policies -> Windows Settings -> Scripts (Startup/Shutdown).
    • Double-click Startup, then click Add.
    • In the Script Name field, browse to the location where you saved ForceSafeMode.ps1 and select it.
    • Click OK to close all dialog boxes.
  6. Apply the GPOs

    • Make sure the Force Safe Mode GPO is applied to the affected computers first.
    • The computer will boot into Safe Mode and execute the CrowdStrikeFix.ps1 script.
    • Once the issue is fixed, the script will revert the boot settings to normal mode.
view raw CRWD-GPO.md hosted with ❤ by GitHub

It started on a Thursday USA time

The potential attack surfaces for 3rd party windows kernel drivers is massive

Posted in Uncategorized | Leave a Comment »

SIEMENS – HB86P575 – Compacte bakoven met magnetron

Posted by jpluimers on 2024/07/19

Voor mijn ling archief wanneer er link root gaat plaatsvinden: [Wayback/Archive] SIEMENS – HB86P575 – Compacte bakoven met magnetron

Handleidingen:

Bekende problemen onder:

Read the rest of this entry »

Posted in Hardware, LifeHacker, Power User | Leave a Comment »

@BritisAirwaySup: a parody account on Webcare teams always wanting to directly move to private DM conversation and sharing full privacy details

Posted by jpluimers on 2024/07/18

Too bad many webcare / social media corporate accounts respond to every question (even ones of importance to the general public) along these lines:

we extremely apologize for the challenge encountered, customer relations haven’t forgotten about you, it wasn’t our intention, kindly follow back, share full names, reachable WhatsApp number via DM, so we can assist further

[Wayback/Archive] Thread by @BritisAirwaySup on Thread Reader App

Via a quote tweet ofย [Wayback/Archive] Thread by @mysk_co on Thread Reader App

When you join a Wi-Fi network that shows a captive portal on the iPhone, iOS opens the captive portal in a Safari web view regardless of which default browser you’ve chosen.

This little experiment implements a captive portal that detects the browser. Brave was the default browser, but iOS opened the captive portal in Safari. The second screenshot shows what this sample website displays if opened with Brave.

Read the rest of this entry »

Posted in LifeHacker, Power User, SocialMedia | Leave a Comment »

MySQL function result reuse in expressions?

Posted by jpluimers on 2024/07/18

I love how Kris answers with these concise bits of SQL query results, this time about the sleep function and expression reuse of function results:

Read the rest of this entry »

Posted in Database Development, Development, MySQL, SQL Server | Leave a Comment »

fail2ban is yet another “A project some โ€ฆ person โ€ฆ has been thanklessly maintaining since โ€ฆ”; ensure it does not become yet another XZ Utils debacle

Posted by jpluimers on 2024/07/17

https://i0.wp.com/web.archive.org/web/20240711133830if_/https%3A//www.explainxkcd.com/wiki/images/d/d7/dependency.pngEarlier this week there were only three sponsors for [Wayback/Archive] sebres (Sergey G. Brester) ยท GitHub.

You might think “Why is this important?”.

Sergey is the single maintainer of fail2ban, the open source project that protects countless (likely a majority) ofย  public facing servers facing on the Internet.

Please don’t let fail2ban become another XZ Utils and support Sergey: we don’t want the project to become unmaintained, or worse: being backdoored like XZ was.

[Wayback/Archive] Sponsor @sebres on GitHub Sponsors ยท GitHub

The fail2ban repository is at [Wayback/Archive] GitHub – fail2ban/fail2ban: Daemon to ban hosts that cause multiple authentication errors

Via [Wayback/Archive] dee ๐Ÿณ๏ธโ€โšง๏ธ: “fail2ban has one core maintainโ€ฆ” – Grafana Social

fail2ban has one core maintainer github.com/fail2ban/fail2ban and he has only 3 Github sponsors github.com/sebres

WTF

I can’t even comprehend how many servers are protected by fail2ban, how many compromises are avoided, how many people who run hobby things all the way up to major sites that get to sleep soundly every night… because of this single project.

Related: XZ 5.6.x are backdoored and present in many systems: downgrade to 5.4.x or earlier now; consider libarchive compromised until proven otherwise

--jeroen

Read the rest of this entry »

Posted in Development, Python, Scripting, Software Development | Leave a Comment »

On my list of tools to try: zhot and tweetzhot (both by Rop Gongrijp and based on puppeteer) to create browser screenshots from the terminal

Posted by jpluimers on 2024/07/17

The feature reminds me on how archive.today saves content.

Both the zhot and tweetzhot repositories are on my list of tools to try. They might make writing blog posts easier.

They are both based onย [Wayback/Archive] puppeteer/puppeteer: Headless Chrome Node.js API

Puppeteer is a Node library which provides a high-level API to control Chrome or Chromium over theย DevTools Protocol. Puppeteer runsย headlessย by default, but can be configured to run full (non-headless) Chrome or Chromium.

It demonstrates headless browser usage and canย for instance:

  • Generate screenshots and PDFs of pages.
  • Crawl a SPA (Single-Page Application) and generate pre-rendered content (i.e. “SSR” (Server-Side Rendering)).
  • Automate form submission, UI testing, keyboard input, etc.
  • Create an up-to-date, automated testing environment. Run your tests directly in the latest version of Chrome using the latest JavaScript and browser features.
  • Capture aย timeline traceย of your site to help diagnose performance issues.
  • Test Chrome Extensions.

Note any headless browser will have some trouble rendering single-page applications.

Repositories:

Read the rest of this entry »

Posted in Chrome, Chrome, Development, Google, JavaScript/ECMAScript, Power User, Puppeteer, Scripting, Software Development, Web Browsers | Leave a Comment »

DigiD backend code: GitHub – MinBZK/woo-besluit-broncode-digid

Posted by jpluimers on 2024/07/16

From a few months back: [Wayback/Archive] GitHub – MinBZK/woo-besluit-broncode-digid

Via Bugblauw [Wayback/Archive] Lord Mendel Mobach ๐Ÿ’‰๐Ÿ’‰๐Ÿ’‰๐Ÿ’‰๐Ÿฆ ๐Ÿ’‰ on X: “DigiD Backend is openbaar โ€ฆ met dank aan @Logius_minbzk @MinBZK @DigiDwebcare” / X

Comments (on why parts of it is obfuscated):

  1. [Wayback/Archive] Arian van Putten on X: “@bugblauw @Logius_minbzk @MinBZK @DigiDwebcare sorry hoor maar dit is echt een aanfluiting. Ze hebben een soort Regex Search en Replace gedaan en alle URLs verandert met SSSSSSSSSS. Waaronder ook alle XML namespaces dus helemaal niks hieraan werkt. Waarom is dit zo extreem weggelakt allemaal? โ€ฆ”

    [Wayback/Archive] Code search results ยท GitHub

  2. [Wayback/Archive] Lord Mendel Mobach ๐Ÿ’‰๐Ÿ’‰๐Ÿ’‰๐Ÿ’‰๐Ÿฆ ๐Ÿ’‰ on X: “@ProgrammerDude @Logius_minbzk @MinBZK @DigiDwebcare Technisch werkt het wel als je maar consistent bent. Hooguit krijg je een warning dat het niet absolute is. Even praktisch: hierin zaten bijvoorbeeld bedrijfsnamen, en men heeft besloten dat per string aan te pakken. Over keuzes die in 2006 of eerder zijn gemaakt …… tjsae..”

--jeroen

Posted in Development, Java, Java Platform, Ruby, Software Development | Leave a Comment »

s3-ocr: Extract text from PDF files stored in an S3 bucket

Posted by jpluimers on 2024/07/16

For my link archive: [Wayback/Archive] s3-ocr: Extract text from PDF files stored in an S3 bucket

One reason is archival of books. Even (or maybe especially) in IT, books already have historic meaning especially in narrower fields where they often are not available in the Internet Archive or have been scanned by Google Books.

Via/related:

Read the rest of this entry »

Posted in Amazon S3, AWS Amazon Web Services, Cloud, Cloud Apps, Development, Infrastructure, Internet, Power User, Python, Scripting, Software Development | Leave a Comment »