Plurrrr

Wed 03 Apr 2019

Dutch licorice

Dutch licorice close-up
Close-up of Dutch licorice.

When I woke up a package had arrived containing two plastic bags with Dutch licorice. Thanks Paul!

DISTINCT with multipe columns

I wanted to count the number of two columns using DISTINCT in MariaDB but it seems that this is not supported directly. A solution:

SELECT COUNT(*)
FROM (
    SELECT DISTINCT id, session_id
    FROM some_table
) AS rows

Key Trouble Part II

That's still an old-style keypair (brute-forceable password protection). Use either the "-o" option to ssh-keygen or use a more modern algorithm for the type which implies that option. See Upgrade your SSH keys!

Thank you Gert van Dijk for pointing this out to me on Twitter. Fixed my GitHub keypair using

ssh-keygen -o -a 100 -t ed25519 \
  -C "contact@johnbokma.com" \
  -f ~/.ssh/john-bokma-github

And I also updated my blog article Fixing Skipping ssh-dss key ... not in PubkeyAcceptedKeyTypes.

Gert also wrote:

Default is weak because latacora.singles/2018/08/03/the…

Excellent information, thanks.

Edit: the above Latacora link is no longer correct. The article has been moved to a new location: The default OpenSSH key encryption is worse than plaintext.