Posted by jpluimers on 2022/01/07
[Archive.is1/Archive.is2] Alexander Klöpping. Juist nu. on Twitter: “Is er een voice recorder app waarbij je met een druk op de knop tijdcodes kunt markeren omdat vlak voordat moment iets belangrijks gezegd werd? Zodat je achteraf makkelijk de belangrijke momenten kunt terugzoeken?” / Twitter
https://twitter.com/AlexanderNL/status/1277519084117164032
Selectie voor Android / Windows / MacOS:
Posted in Android Devices, Audacity, Audio, Media, Power User, Windows | Leave a Comment »
Posted by jpluimers on 2022/01/07
Ik had dus gemist dat in oktober 2021 de spelregels rondom een corona herstelbewijs.
De reden is dat de communicatie rondom corona in Nederland niet echt top is.
Het laatste voorbeeld: terwijl boosters voor iedereen van 18 jaar en ouder beschikbaar zijn en sommige vaccinatielocaties inmiddels weer vrije inloop hebben, hebben velen dat in mijn omgeving nog niet aangevraagd, want “ik heb nog geen uitnodiging ontvangen”, en/of “ik wist niet dat het al kon”. Anderen ervaren hetzelfde, dus dit soort berichten zijn belangrijk:
- [Archive] WheelieNick on Twitter: “Die communicatie over de booster moet ECHT beter, Mijn huishoudhulp is hier en vertelt ik heb nog geen booster want nog geen oproep gehad. Ik vertel dat ze op geboortejaar gewoon al mag en ze kijkt me echt verbaasd aan, echt?” / Twitter
- [Archive] Kirsten Verdel on Twitter: “Let op: veel mensen hebben VANDAAG pas hun boosteruitnodigingsbrief ontvangen, terwijl ze uit bijvoorbeeld 1948 of 1949 komen. Die jaren waren rond 10 dec (!) al aan de beurt voor een afspraak. WACHT NIET OP DE BRIEF: plan je afspraak op planjeprik.nl of bel 08007070.” / Twitter
- Boosteren: via [Wayback/Archive] planjeprik.nl of
Terug naar herstelbewijs: de meeste linkjes hieronder zijn namelijk niet van GGDGHOR, RIVM of Rijksoverheid.
De enige GGD website die de communicatie rondom herstelbewijs qua volledigheid en duidelijkheid op orde heeft is GGD zhz (Zuid-Holland Zuid). Complimenten!
Hier de linkjes (via [Wayback/Archive] herstelbewijs corona aanvragen – Google Search):
Herstelbewijs voor als u bij de GGD bent getest
Een herstelbewijs is een bewijs dat u ooit positief getest bent op aanwezigheid van het coronavirus. U vindt op de website van de Rijksoverheid alle eisen voor het aanmaken van een herstelbewijs.Bent u bij de GGD in Nederland positief getest op corona? Dan kunt u uw herstelbewijs in de CoronaCheck-app ophalen. Meer informatie over het ophalen van een herstelbewijs via CoronaCheck.
Herstelbewijs als u niet bij de GGD bent getest
Bent u niet bij de GGD getest en lukt het niet om een herstelbewijs op te halen? Dan kan het zijn dat uw persoonsgegevens niet juist aan de GGD zijn doorgegeven. Vul dan het volgende aanvraagformulier ”Aanvraagformulier corona herstelbewijs voor mensen die niet bij de GGD getest zijn”.
15 okt. 2021
Corona
Ben je positief getest op corona? En was dat niet bij de GGD? Dan kun je nu ook een QR-code op basis van een herstelbewijs ophalen in de CoronaCheck-app.
Elke testaanbieder in Nederland is, sinds we op 1 juni 2020 grootschaliger zijn gaan testen op Covid-19, verplicht om een positieve uitslag aan de GGD door te geven. Tot voor kort was het om technische redenen echter niet mogelijk om een QR-code op te halen als je niet bij de GGD getest was. Dat is het nu wel. De test moet wel tussen de 11 en 180 dagen geleden zijn afgenomen en de positieve uitslag moet op de juiste wijze, door de betrokken arts van de testaanbieder, aan de GGD zijn doorgegeven.
–jeroen
Posted in Covid-19/SARS-CoV-2/Coronavirus, Health, Power User, Vaccinations | Leave a Comment »
Posted by jpluimers on 2022/01/07
Removing yourself from a list has been possible for a long time (since at least 2013) by blocking the list owner, then unblocking, but was only documented late 2019 in [WayBack] How to use Twitter Lists:
A Twitter List is a curated group of Twitter accounts. Create your own or subscribe to a List created by someone else to view a streamlined timeline.
…
How to remove yourself from a List
You can view which Lists you are a member of through your Lists tab. To remove yourself from a List you will need to block the creator of that List.
It was public knowledge though, for instance documented at [WayBack] How journalists can remove themselves from Twitter lists – & why it matters – Poynter, which also documents this:
How can I find out which Twitter lists I’m on?
When using Twitter on the web, click on lists. You will arrive at “Subscribed To.” Next to that heading, you’ll see “Member Of.” Click on it to see the Twitter lists that include you as a member. This list of lists is chronological starting at the bottom — the first list you see at the top will be the one that most recently added you.
For me this is twitter.com/jpluimers/lists/memberships
The same trick also works when you want to have someone un-follow you:
Posted in Power User, SocialMedia, Twitter | Leave a Comment »
Posted by jpluimers on 2022/01/06
Contrary to what many believe is that MySQL utf8 is not always full blown UTF-8 support, but actually utf8mb3, which has been deprecated for a while now.
Only utf8mb4 will give you full blown UTF-8 support.
This when someone reminded me of this in a Delphi application:
When I insert :joy: emoji into mysql varchar filed I got an error :
#22007 Incorrect string value: '\xF0\x9F\x98\x82' for column 'remarks' at row 1database charset is
utf8
Note that the :joy: emoji is 😂 and has Unicode code point U+1F602 which is outside the basic multilingual plane.
See:
- Kristian Köhntopp
»Where does PostgreSQL’s collation logic come from?
PostgreSQL relies on external libraries to order strings.
– libc, meaning the operating system locale facility (POSIX or Windows)
– icu, meaning the ICU project (if PostgreSQL was built with ICU support)«- MySQL does things differently:
MySQL binary data files are independent of the host operating system in byte order, number representation (as long as the host fulfils MySQLs basic requirements), collation and even time zone handling.- So MySQL implements collations internally, also to guarantee stability across OS updates.
If it didn’t, a libc update changing collations would mean you have to recreate a lot of indexes. Also, you would not be able to safely move data files from host to host.- MySQL also, for quite some time now, no longer updates its own charsets and collations internally, for the same reason.
So utf8 in MySQL is utf8mb3, the three byte variant of Unicode UTF-8 implementation that covers only the BMP (unicode up to U+FFFF).- When moving to fuller (multiplane) UTF-8 support, a new name was needed, and utf8mb4 was chosen.
So when you actually want modern utf8 in MySQL, you have to use utf8mb4, and now you know why.- utf8 is deprecated and will be upgraded to utf8mb4 in some future MySQL release. This will be a breaking upgrade, and I wonder if it will require dropping and recreating all indexes affected by the change.
That will be painful.- https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8mb3.html …
utf8mb3 page in the MySQL 8.0 manual, with deprecation notice.
What will change is the meaning of the alias utf8 (currently an alias for utf8mb3).
utf8mb3 Character Set (3-Byte UTF-8 Unicode Encoding)
utf8is an alias forutf8mb3; the character limit is implicit, rather than explicit in the name.NoteThe
utf8mb3character set is deprecated and you should expect it to be removed in a future MySQL release. Please useutf8mb4instead. Althoughutf8is currently an alias forutf8mb3, at some pointutf8is expected to become a reference toutf8mb4. To avoid ambiguity about the meaning ofutf8, consider specifyingutf8mb4explicitly for character set references instead ofutf8.
utf8mb4contrasts with theutf8mb3character set, which supports only BMP characters and uses a maximum of three bytes per character:
- For a BMP character,
utf8mb4andutf8mb3have identical storage characteristics: same code values, same encoding, same length.- For a supplementary character,
utf8mb4requires four bytes to store it, whereasutf8mb3cannot store the character at all. When convertingutf8mb3columns toutf8mb4, you need not worry about converting supplementary characters because there are none.
–jeroen
Posted in Conference Topics, Conferences, Database Development, Delphi, Development, Encoding, Event, MySQL, Software Development, UTF-8, UTF8 | Leave a Comment »
Posted by jpluimers on 2022/01/06
As promised in “Solution” on ESXi 6.7 smartinfo throwing error Cannot open device, here are a few links in capping throttling disk speeds by ESXi followed by a few graphs of my own:
dd: [Wayback] datastore – How can I speed up file tranfers on local storage in vSphere 5? – Server FaultI never got any official confirmation for this, but I believe the I/O is capped (or at least de-prioritized) for datastore copy/move operations from the GUI as I have seen rather similar behaviour in different ESXi environments on from version 3.5.
Question:
When I copy a 3GB ISO file from the raid set to the sata disk, the average disk transfer is 50MB/sec. This puzzles me, because the SATA disk can do 100MB/sec easy. When I start a second copy, the average disk transfer doubles to 100MB/sec.
…
Answer:
File transfer speeds are capped in the console so you will not be able to get maximum speeds
My own observations on ESXi 6.7 update 3:
1 rsync from 860 EVO SSD to 960 PRO NVMe
2 rsync from 860 EVO SSD to 960 PRO NVM
Resume action
Start of suspend action
Finish of suspend action
For each rsync operation, I had a separate SSH session going, and the speed doubled.
The resume action of all Virtual Machines was almost a flat speed curve.
The suspend action of all Virtual Machines started fast (when all machines were suspending) and finished slower (when only the largest virtual machines were still suspending)
–jeroen
Posted in ESXi5, ESXi5.1, ESXi5.5, ESXi6, ESXi6.5, ESXi6.7, ESXi7, Power User, Virtualization, VMware, VMware ESXi | Leave a Comment »
Posted by jpluimers on 2022/01/06
Model 100489-14-01 wall clock
Just in case I need it again.
The signal quality fluctuates during the day (it is a lot better at night when there is less inionisation in the atmosphere), and is worsened by concrete walls (like our home).
Best way to get prolonged reception is at night, on the top floor behind a window or outside.
The clock usually needs between 3 and 10 minutes to pick up the DCF77 signal from the transmitter.
Wall clock manual: [Wayback] 100489_EN.pdf of which this abstract:
DCF77 HD-1688 clock mechanism
Numbers:
- M.SET button
- Press and keep pressed the M.SET button 1 at least 3 seconds. The wall clock switches into manual mode.
- Press and keep pressed the M.SET button again until the hands reach the correct position for you to set the time.
- Briefly pressing the M.SET button moves the hands forward in one minute steps to enable you to set the current time manually.
Note: After 8 seconds without pressing the M.SET button, the wall clock switches out of manual mode and keeps the time as normal. The manually set value is overwritten as soon as reception of the DCF radio time signal is successful.- RESET button
- Press the RESET button 2 to reset the radio clock settings. Alternatively, remove the batteries from the device and insert them again.
- The product now automatically starts to search for the DCF radio time signal.
- REC button
- Press and keep pressed the REC button 3 at least 5 seconds. The wall clock attempts to receive the DCF radio time signal. This process takes a few minutes to complete.
- Battery compartment
- Battery type: 1 x 1.5 V ⎓ AA, LR6
More on the signal, transmitter and encoding: DCF77 – Wikipedia, where the below images are from:
DCF77 reception area from Mainflingen
DCF77 signal strength over a 24-hour period measured in Nerja, on the south coast of Spain 1,801 km (1,119 mi) from the transmitter. Around 1 AM it peaks at ≈ 100 µV/m signal strength. During the day, the signal is weakened by ionization of the ionosphere due to solar activity.
Another DCF77 clock I have: CSL Bearware 302658 DCF clock manual
–jeroen
Posted in Development, Encoding, Hardware Development, LifeHacker, Power User, Software Development | 2 Comments »
Posted by jpluimers on 2022/01/05
TL;DR: recurrence in Google Calendar can be tough.
Adding a yearly repeating event on a last weekday (where weekday is any day of the week: sunday, monday, etc) of a month in Google Calendar was a lot less obvious than I hoped for.
The easiest path “Custom Event” by default does not show last/#th/first, only a fixed date when selecting yearly or monthly repeating events, which is contrary to the suggested answer at [Wayback/Archive.is] Google calendar question: How to set an event to repeat on the first Monday of a specific Month : google:
Create an event on September 3rd. Choose custom recurrence. Repeat every 12 months monthly on the first Monday. I just tested that out on the browser version of Google calendar
The trick is to first select a normally repeating monthly event on the last#th/first weekday day of a month.
Note that for the 5th week, you cannot do this in the Google Calendar UI as per [Wayback] google calendar – Schedule an event for last Sunday (or another day of week) of each month – Web Applications Stack Exchange:
If you actually want a day on the 5th week of every month (versus the last week), the Google Calendar UI does not support this, but you can do it by importing an .ics file
Below is an example while writing this: adding a yearly recurring event on the last Sunday of May (which in 2021 was Sunday the 30th of May).
These are the steps:
Posted in Google, GoogleCalendar, LifeHacker, Power User | Leave a Comment »
Posted by jpluimers on 2022/01/05
After writing Some notes on ESXi smartinfo throwing error Cannot open device, I bit the bullet and experimented with disabling the vmw_ahci driver (shown as ahci in the storage adapters view), which forces the sata_ahci driver to be used (shown as ahci in the storage adapters view).
Poof! All problems were gone.
All? Not all: on the console and terminal, there seems to be some throttling going on, as I observed the read or write speed limit to be capped somewhere close to 60 MB/s. More on that in a future post.
Basically, the smartinfo trouble tripped me into thinking the device was bad, where I should have understood that the latency warnings in the vmkernel.log file indicated the vmw_ahci driver was the culprit. Oh well: never too old to learn.
I’m not alone on this; these posts also discuss latency issued:
Seeing latency spikes in excess of 100ms on my 2 samsung 860 evo SSDs. The throughput is fine getting 500Mbps+ on them but the vmkwarning.log has “performance has deteriorated. I/O latency increased from average value” warnings. This is a home server that’s why I’m using regular samsung SSDs.
…
I’ve seen similar issues (high latency spikes of 200ms ) with even the latest 6.7U3 as of September 2020. This in combination with Samsung EVO 860 SSD.
Which driver is your sata-port using?
Have you tried disabling the vmware ahci driver? (below command and a reboot will make ESXi use the ahci driver instead of the vmw_ahci driver).
you can check this under storage adapters through the host ui. When using the ahci driver you should be seeing ALL your sata ports. (the vmw_ahci only showed me 1 or 2).
This is more or less want I am trying right now. I found the info on : ESXi 6.5 vmw_ahci SSD extreme high latency and vm freeze issues – vDrone.
My server is running with this config since 12 hours now. Too soon to make any conclusion but at least your info makes me believe that I might be in the right direction.
Since the upgrade to ESXi 6.5 on my homelab i got bugged with a strange issue.
All my SATA SSD got really high latency and my VM’s randomly froze when i generated a big file copy actions. Latencies in the 5000/15000ms! Yes IEW!
This is different from the transfer speed issues that were part of ESXi 4, though I have a gut feeling there is some correlation:
On AHCI: Advanced Host Controller Interface – Wikipedia
On native drivers versus legacy drivers:
A new native driver model feature is introduced in VMware ESXi 5.5 that replaces an older model that employs a Linux compatibility layer.
In this article:
- Drivers using the new model are referred to as native drivers
- Drivers using the old model are referred to as legacy VMKLinux drivers
This article provides troubleshooting information for the native driver model.
The following inbox Native Drivers are included in default installation of ESXi 5.5: – See more at: http://www.virtuallyghetto.com/2013/11/esxi-55-introduces-new-native-device.html
…
A new concept of driver priority loading is introduced with the Native Device Driver model and the diagram below provides the current ordering of how device drivers are loaded.
As you can see OEM drivers will have the highest priority and by default Native Drivers will be loaded before “legacy” vmklinux drivers. On a clean installation of ESXi 5.5 you should see at least two of these directories: /etc/vmware/default.map.d/ and /etc/vmware/driver.map.d/ which contains driver map files pertaining to Native Device and “legacy” vmklinux drivers.
…
This is how you disable the native vmware_ahci driver:
esxcli system maintenanceMode set --enable true# esxcli system module set --enabled=false --module=vmw_ahci # reboot
esxcli system maintenanceMode set --enable falseTo re-enable the native vmware_ahci driver (in case not all your SATA devices are recognised):
esxcli system maintenanceMode set --enable true# esxcli system module set --enabled=true --module=vmw_ahci # reboot
esxcli system maintenanceMode set --enable falseSuspending and unsuspending all virtual machines can be done on the console/terminal, see Source: VMware ESXi console: viewing all VMs, suspending and waking them up: part 5 how.
With native vmware_ahci, the storage adapters are these:
Storage adapters with
vmw_ahcienabled
With legacy ahci, the storage adapters are these:
Storage adapters with
vmw_ahcidisabled
What you see is that the Patsburg 6 Port SATA AHCI Controller has been split from a single vmw_ahci adapter in six separate ahci adapters.
With vmware_ahci, the storage adapters are these:
Latency issues after resume/suspend cycle of all virtual machines: the latency stays up in the 15 millisecond region
With ahci, the storage adapters are these:
Latency after resume/suspend cycle of all virtual machines: the latency goes down to the 2 millisecond region
For both cases, the read and write rates are roughly the same (and OK for an EVO 860 SATA device). The latency drops a lot (and with prolonged vmw_ahci use goes up to like 15+ seconds, that is 15000+ milliseconds):
[Wayback] SSD 860 EVO 2.5″ SATA III 500GB Memory & Storage – MZ-76E500B/AM | Samsung US
Speeds are consistent, even under heavy workloads and multi-tasking allowing for faster file transfer. The 860 EVO performs at sequential read speeds up to 550 MB/s* with Intelligent TurboWrite technology, and sequential write speeds up to 520 MB/s. The TurboWrite buffer size* is upgraded from 12 GB to 78 GB.
* Performance may vary based on SSD’s firmware version and system hardware & configuration. Sequential write performance measurements are based on Intelligent TurboWrite technology. Sequential performance measurements based on CrystalDiskMark v.5.0.2 and I0meter 1.1.0. The sequential write performances are Intelligent TurboWrite region are 300 MB/s for 250/500 GB and 500 MB/s for 1 TB.
* Test system configuration: Intel Core i5-3550 CPU @ 3.3 GHz, 4 GB, OS – Windows 7 Ultimate x64, Chipset: ASUS P8H77-V .
* The TurboWrite buffer size varies based on the capacity of the SSD; 12 GB model, 22 GB for 500 GB model, 42 GB for 1 TB model and 2/4 TB for 78 GB. For more information on the TurboWrite, please visit http://www.samsungssd.com.
–jeroen
Posted in ESXi6, ESXi6.5, ESXi6.7, ESXi7, Power User, Virtualization, VMware, VMware ESXi | Leave a Comment »
Posted by jpluimers on 2022/01/05
Even when young, this transcript should raise all the red flags:
- Recruiter: At this job, you will get to work at a fast paced environment.
- Recruiter: You will get to thrive under pressure.
- Recruiter: And you will be part of a dynamic team.
- Applicant: Great, new that you’ve outlined the cons, what are the pros?
[Archive.is] Work Chronicles | Comics about Work on Twitter: “Fast-paced Environment… “ and [Wayback] Fast-paced Environment | Work Chronicles:
–jeroen
Posted in About, Development, LifeHacker, Personal, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2022/01/04
Coming from a Windows and Linux background, I was used that mass renaming files was a non-stock feature and getting it right usually a pain in the butt.
How glad I was to find out [Wayback] How to rename multiple files at once on Mac | iMore
Believe it or not, it used to be a real pain to batch-rename files on Mac. Times have changed and so have the names of those 15 files.
…
Prior to OS X Yosemite, there was no simple way to rename multiple files at the same time on the Mac. Some people set up Automator rules. Others tried workarounds to rename files in third-party apps. Finally, Apple realized our heartache and created a much simpler way to rename multiple files at once, and it’s only gotten easier as macOS updates continue. Here’s how to batch-rename files on your Mac.
The only mass-rename I regularly need is fixing typos or OCR errors in filenames: this means replacing certain text with another piece of text.
That’s this easy:
Posted in Apple, Mac OS X / OS X / MacOS, macOS 10.12 Sierra, macOS 10.13 High Sierra, OS X 10.10 Yosemite, OS X 10.11 El Capitan, Power User | Leave a Comment »
The Wiert Corner - irregular stream of stuff 