Plurrrr

a tumblelog
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!

Blush

Pepijn Janssen commented on my "An update of my resume is available" post on Linked In:

I can highly recommend him! Very good programmer who also writes perfect documentation.

CSS position

Reading up on CSS position. I might want to use fixed on this blog to keep the topmost header in view at all times.

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.