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,860 other subscribers

Archive for April, 2021

A USB-C magnetic charge contact that when tripping does not make your computer hit the ground (via Hadi Hariri on Twitter)

Posted by jpluimers on 2021/04/19

Want: [WayBack] Hadi Hariri on Twitter: “You know @Apple I actually liked that feature of not pulling the computer off the desk when tripping over the cable. You removed it, I’m getting an add-on. And thanks @bashorov for the recommendation.… https://t.co/Ju036sqRW4”

–jeroen

Posted in Hardware, Power User, USB, USB-C | Leave a Comment »

Stop FortiClient from auto-starting (as it uses a truckload of Windows resources, often including 2 gigabyte of memory for their logger)

Posted by jpluimers on 2021/04/16

I see lot’s of negative reactions on FortiClient, as it is very closed source, many intermittent issues, and is a product that tries to be a jack of all trades (over a couple of versions, in addition of being a proprietary VPN client, they started doing vulnerability scanning, interfering with anti-virus products, they blocked saving of passwords and allowing password managers to paste them, and I could go on).

Sometimes you have to use it in order to access a FortiGate based VPN server, so the best is to defer starting it until as late as possible.

Here are some links to get that configured correctly:

–jeroen

Posted in FortiGate/FortiClient, Network-and-equipment, Power User, VPN | Leave a Comment »

google chrome – How can I selectively disable paste blockers – Super User

Posted by jpluimers on 2021/04/16

For my link archive: [WayBack] google chrome – How can I selectively disable paste blockers – Super User.

Preliminary testing shows that Chrome Extension [Archive.is] “Don’t Fuck with Paste” works with eendagskentekenbewijsaanvragen.rdw.nl

–jeroen

Posted in Chrome, Chrome, Firefox, Google, Power User, Web Browsers | Leave a Comment »

Dockerfile with Bite Size Networking tools from b0rk

Posted by jpluimers on 2021/04/16

[WayBack] Ryan James Spencer on Twitter:

“I wrote a quick Dockerfile so people who purchase Bite Size Networking from  @b0rk can quickly have access to the tools. You can slim the image down to do debugging on docker networks once you get comfortable with which tools are most useful to you.”

He is planning to do more, so maybe a few of [WayBack] wizard zines get encapsulated into dockerfiles as well.

–jeroen

PS: [WayBack] Dockerfile | Docker Documentation


# N.B. The only tool missing here that is mentioned in the document is `zenmap`
# purely because this image is intended to be run via a CLI and `zenmap` is a GUI
# to `nmap` i.e. one can play around with the tools by running:
#
# $ docker build –name bite_size_networking:latest .
# $ docker run –rm -d –name bsn_test bite_size_networking:latest
# $ docker exec -it bsn_test bash
#
# Alternatively, one can change the `ENTRYPOINT` to `["bash"]` and run:
#
# $ docker run -it –name bsn_test bite_size_networking:latest
#
# then later (after exiting the shell):
#
# $ docker start bsn_test
# $ docker attach bsn_test
#
# One can also run this image on a docker network to capture packets and so
# forth for debugging purposes. Once you've found the tooling that best suits
# your needs, it may make sense to make a slimmed down version of this
# Dockerfile and, if wireguard isn't needed, base this image off
# `debian:stable` instead.
#
# Lastly, you can purchase Bite Size Networking or Julia's other fantastic
# zines over at https://wizardzines.com/
# We use `unstable` here since we install `wireguard` below
FROM debian:unstable
RUN apt update && \
DEBIAN_FRONTEND=noninteractive apt install -y \
dnsutils \
curl \
nmap \
tcpdump \
ngrep \
mitmproxy \
iptables \
ethtool \
stunnel \
hping3 \
lsof \
ipcalc \
p0f \
iperf \
apache2-utils \
wget \
python3 \
iftop \
nethogs \
iptraf \
httpie \
nload \
aria2 \
nftables \
tcpflow \
telnet \
openvpn \
links \
wireguard \
tshark
ENTRYPOINT ["sh", "-c", "while true; do sleep $(( 60 * 60 * 24 )); done"]

Posted in *nix, *nix-tools, Cloud, Containers, Docker, Infrastructure, Power User | Leave a Comment »

Some VMware ESXi 7 download filenames and checksums

Posted by jpluimers on 2021/04/15

The free ESXi 7 download page only get these downloads:

VMware vSphere Hypervisor – Binaries

VMware vSphere Hypervisor (ESXi ISO) image

2020-06-23 | 7.0b | 351.9 MB | iso

Boot your server with this image in order to install or upgrade to ESXi (ESXi requires 64-bit capable servers). This ESXi image includes VMware Tools.

MD5SUM(¹): 6b74910d911cabcd346028071eb83682
SHA1SUM(¹): 9eeff60e4257d763f49d9b39e1dbaee4fe22acbd
SHA256SUM(¹): 7bebfc1bc0794b0964b9ee731860785794fb678d49a1f06d5e62524b805f2b72

VMware vSphere Hypervisor (ESXi) Offline Bundle

2020-06-23 | 7.0b | 346 MB | zip

Contains VIB packages and image profiles for ESXi including VMware Tools. Use the image profiles and the VIB packages with VMware Image Builder and VMware Auto Deploy to create custom image/ISO generation for ESXi deployments.

MD5SUM(¹): d40887d357dd7042d75d1460d70396ca
SHA1SUM(¹): 620bc355af3d23436eedc1ef49a62225a18f862f
SHA256SUM(¹): d26ce8c036cc2a6c1a49a15c2ecfd471f17df80b4b88e9ed4093671be6b0dec5

There have been many more ESXi versions, that some of the time you want for regression, and some of the time because they are better.

Some of the times (like right now) you do also do NOT want a version, like the current ESXi 7.0 update 2 which got retracted on March 13th, but is still available on the free vSphere 7 evaluation.

I started to notice yesterday that a few folks in the community were running into the following error after upgrading their ESXi hosts to latest 7.0 Update 2 release: Failed to load crypto64.efi Fa…

UPDATE (03/13/2021) – It looks like VMware has just pulled the ESXi online/offline depot and has updated KB 83063  to NOT recommend customers upgrade to ESXi 7.0 Update 2. A new patch is actively being developed and customers should hold off upgrading until that is made available.

UPDATE (03/10/2021) – VMware has just published KB 83063 which includes official guidance relating to the issue mentioned in this blog post.

Warning! – Mar 13 2021 Update – Don’t upgrade to 7.0 Update 2 yet.
If you try to upgrade now anyway, you may experience one of these two errors:

1) Using vLCM (Lifecycle Manager)

to update your ESXi host, you see this error:

  Loading /boot.cfg
  Failed to load crypto64.efi
  Fatal error: 15 (Not found)

2) Using ESXCLI

to update your ESXi host, you see this error:

  [root@xd-1541-5028d:~] esxcli software profile update -p ESXi-7.0.2-17630552-standard -d https://hostupdate.vmware.com/software/VUM/PRODUCTION/main/vmw-depot-index.xml
  [NoMatchError]
  No image profile found with name 'ESXi-7.0.2-17630552-standard'
        id = ESXi-7.0.2-17630552-standard
  Please refer to the log file for more details.
  [root@xd-1541-5028d:~]

you’ll want to see this excerpt from VMware KB 83063 published on Mar 12 2021

The vSphere 7 evaluation page is always the one where to get the latest version: [Wayback/Archive.is] How do I download the latest ESXi 7.x .iso? VMWare’s site only lists 7.0.0 : vmware.

Do not get ESXi 7.0 update 2 yet [Wayback] my.vmware.com/en/group/vmware/evalcenter?p=vsphere-eval-7:

The hypervisor should be directly installed on any supported physical server targeted for hosting virtual machines.

VMware vSphere Hypervisor (ESXi ISO) image

2021-03-09 | 7.0U2 | 390.53 MB | iso

Boot your server with this image in order to install or upgrade to ESXi (ESXi requires 64-bit capable servers). This ESXi image includes VMware Tools.

MD5SUM(¹): a085686c3fc8a438a40382118448a846
SHA1SUM(¹): 1ceed7c40b1cd6f97f12eacc027037e202fcb6e9
SHA256SUM(¹): ff20603e4a3e75ab20c7752ca4e3e28d55d28730d6947c849a4cc5beacf9878d

There are many sites outside of VMware where you can get these versions, which you can validate by verifying their checksums.

Luckily, VMware has pages with checksums of the Offline Bundle files, so I have listed them below.

  • [Wayback] VMware ESXi 7.0 Update 2 Release Notes
    Download Filename: VMware-ESXi-7.0U2-17630552-depot.zip
    Build: 17630552
    Download Size: 390.9 MB
    md5sum: 4eae7823678cc7c57785e4539fe89d81
    sha1checksum: 7c6b70a0190bd78bcf118f856cf9c60b4ad7d4b5
    Host Reboot Required: Yes
    Virtual Machine Migration or Shutdown Required: Yes
  • [Wayback] VMware ESXi 7.0 Update 1d Release Notes
    Download Filename: VMware-ESXi-7.0U1d-17551050-depot.zip
    Build: 17551050
    Download Size: 363.0 MB
    md5sum: 2ff3ce7fb83ac1659a9142ad4510bdfe
    sha1checksum: a84b2bcdae56a95609844f3f8dcc46d28e736b39
    Host Reboot Required: Yes
    Virtual Machine Migration or Shutdown Required: Yes
  • [Wayback] VMware ESXi 7.0 Update 1c Release Notes
    Download Filename: VMware-ESXi-7.0U1c-17325551-depot.zip
    Build: 17325551
    Download Size: 523.2 MB
    md5sum: d1410e6c741ada23c3570e07b94bd8c7
    sha1checksum: a70defe8353b39f74339b158697ed1a12df6c55d
    Host Reboot Required: Yes
    Virtual Machine Migration or Shutdown Required: Yes
  • [Wayback] VMware ESXi 7.0 Update 1b Release Notes
    Download Filename: VMware-ESXi-7.0U1b-17168206-depot.zip
    Build: 17168206
    Download Size: 360.6 MB
    md5sum: f6651dba2cf3e28f639b45068760f286
    sha1checksum: 1fa79325cefa5730f1fa6f6e8a958b499051d81a
    Host Reboot Required: Yes
    Virtual Machine Migration or Shutdown Required: Yes
  • [Wayback] VMware ESXi 7.0 Update 1a Release Notes
    Download Filename: VMware-ESXi-7.0U1a-17119627-depot.zip
    Build: 17119627
    Download Size: 360.6 MB
    md5sum: 37209643e5d483f70d82c39d3a0e02c8
    sha1checksum: 19efc144e0bccef65e3e27f815502bfb73a05782
    Host Reboot Required: Yes
    Virtual Machine Migration or Shutdown Required: Yes
  • [Wayback] VMware ESXi 7.0 Update 1 Release Notes
    Download Filename: VMware-ESXi-7.0U1-16850804-depot.zip
    Build: 16850804
    Download Size: 360.6 MB
    md5sum: 3c12872658250d3bd12ed91de0d83109
    sha1checksum: 7cc4e669e3dddd0834487ebc7f90031ae265746c
    Host Reboot Required: Yes
    Virtual Machine Migration or Shutdown Required: Yes
  • [Wayback] VMware ESXi 7.0, Patch Release ESXi 7.0b
    Download Filename: VMware-ESXi-7.0b-16324942-depot.zip
    Build: 16324942
    Download Size: 508.5 MB
    md5sum: 18a8c2243a0bd15286c331092ab028fc
    sha1checksum: d0a02bbf0716364fb3e799501357944c88e17401
    Host Reboot Required: Yes
    Virtual Machine Migration or Shutdown Required: Yes

–jeroen

Posted in ESXi7, Power User, Virtualization, VMware, VMware ESXi | Leave a Comment »

When registering for ESXi 7: “Content Not Available Dear user, the web content you have requested is not available.”

Posted by jpluimers on 2021/04/15

VMware ESXi 7 registration fails on Chrome

VMware ESXi 7 registration fails on Chrome

The “free-esxi#” pages are the only place where you can register for and view your ESXi licenses, as they are not part of my.vmware.com/group/vmware/my-licenses (that would make it easy, but that’s not how VMware is a corporate).

It really is the only place, and the documentation is buried deep in the KB pages: [Archive.is] Downloading and licensing vSphere Hypervisor (ESXi 6.x & 7.x) (2107518).

If you get “content not avaiable” while registering for ESXi 7 [Wayback] maintenance.vmware.com/info4.html?source=dwnp&p=free-esxi7 by clicking on the “Register” button on [Wayback] my.vmware.com/en/web/vmware/evalcenter?p=free-esxi7

The dreaded register button.

The dreaded register button.

 

Content Not Available

Dear user, the web content you have requested is not available.

… then remember that VMware has been as corporate as banks for years, which means that their web-sites only work properly in a limited set of browsers. Chrome is not one of them any more, but Firefox seems to for for me.

I am not alone bumping into this, many have and the site has been working/failing for years, for instance back in 2019: [Wayback] Is there still a free version of ESXI that is not … – VMware Technology Network VMTN

–jeroen

Posted in ESXi7, Power User, Virtualization, VMware, VMware ESXi | Leave a Comment »

Spring4D conference materials

Posted by jpluimers on 2021/04/15

From a while ago, but still very relevant:

Materials

Timeline

twitter.com/search?q=%23Spring4D&src=typd

Read the rest of this entry »

Posted in Delphi, Development, Software Development | Leave a Comment »

MSSQL – searching in DDL metadata comments

Posted by jpluimers on 2021/04/14

Some interesting queries at [WayBack] www.nlaak.com • Просмотр темы – Полезные скрипты (English translation by Google)

I have put them in the [WayBack] gist below, and expect that they should be solvable without depending on deprecated sys.sysobjects.

Related: [WayBack] sql server – Making sense of sys.objects, sys.system_objects, and sys.sysobjects? – Database Administrators Stack Exchange

–jeroen

Read the rest of this entry »

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

Plastic SCM: show the current changeset abstract (without files) on the commandline

Posted by jpluimers on 2021/04/14

I could not find a syntax for “current changeset”, but since cm log accepts the output of cm status as changeset identifier:

for /F "tokens=*" %l in ('call cm status --nochanges') do (call cm log %l --itemformat )

Or in batch file form:

for /F "tokens=*" %%l in ('call cm status --nochanges') do (call cm log %%l --itemformat )

Two important parts of the trick that ensure each command only outputs what is needed:

  1. The empty --itemformat specification for cm log indicates that no details about files should be logged.Without it, cm log will list both the changeset information and information about each item in the changeset.
  2. The other trick is --nochanges for cm status: it only shows the status line, and no other changes.Without it, cm status will emit one line per changed file.

–jeroen

Read the rest of this entry »

Posted in Development, Encoding, PlasticSCM, Software Development, Source Code Management | Leave a Comment »

“F2063 Could not compile used unit” can also mean you have a DCU file of that unit for the wrong compiler version

Posted by jpluimers on 2021/04/14

It took me a file to figure out another cause for “F2063 Could not compile used unit“, this was for a 3rd party library that had parts of the units as source files, but other parts as DCU files.

The offending unit only had DCU files, and those were in the path.

It finally occurred to me that I had a project having a DCU for the wrong Delphi version in the path.

That version check is easy to do: the 4th byte of a unit contains the CompilerVersion value with which the DCU file was compiled, and should be used with:

The first entry is for CompilerVersion value 31 (for hexadecimal value $1F) which corresponds with Delphi 10.2 Tokyo.

The last last is for CompilerVersion value 32 (for hexadecimal value $20) which corresponds with Delphi 10.3 Rio.

All versions are in Delphi version info table: C# Builder, Delphi 8 through 10.3 Rio and Appbuilder.

Related:

On the DCU and TPU file formats:

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »