나는 당신을 실패 - unbuffered stdout & stderr

New tidbits post

Forgotten stuff - when did I forget how to read man pages?

Convert a unix timestamp to a date string

date -d "@1234567"
Thu Jan 15 12:56:07 AM CST 1970

Getting phantom users / stuck ssh sessions that have long since ended?
systemd logind seems to get confused under high load.

Try resetting things with:
systemctl restart systemd-logind.service

To verify what / who it was before the restart:
loginctl list-sessions
loginctl show-session xxxx

Aw, snap!

Did a snap update ruin your day by breaking a package with a version that had a bunk release?
How can fix it (either quickly and dangerously or slowly and safely)?

Long story short
When you have a working version of the package... keep it!

  snap download packagename
  snap refresh --hold=forever packagename

This ensures you have a copy to re-install as it seems snaps "dissapear" quickly when new versions are released!

Slow and safe:

revert using snap info packagename
this assumes an old stable release - probably not the case...

snap install (look it up seems the cli install has breakage and I won't keep chasing it here)

Quick and dangerously:

If the prior version is not available via snap info packagename -- most likely it won't be!
Grab a copy of the old .snap and .assert files

snap remove packagename
snap ack packagename_version.assert
snap install packagename_version.snap (--dangerous)
(dangerous needed if there is no assert file to ack)

Hint - grab from another installation with that version via:

snap download packagename
look in /var/lib/snapd/snaps/packagename_version.snap

This will break updates however

Oops. Did it again.

Forgot to enable mod cgi. Makes for interesting reading though.

Magic 8 balls and artificial intelligence

I don't think shaking more Magic 8 balls at the same time in order to arrive at consensus will make them more human.

Works on my machine / buy a subscription today!

Looks like Elasticsearch releases are tested internally on Docker.
Testing the release on customers infra and post hoc updating release notes is efficient.
Just ask Microsoft who constitutes the beta tester group.
What is a little reputation burn going to do to the brand over time anyway?

Nginx tidbits

Just a spot to drop easily forgotten stuff due to my under use.

Config test:
nginx -t

Server alias names:
Just add the aliases on the server_name line. The first one is the canonical name
(don't forget the semicolon).

In the default (alpha-numerically) config the default_server can be useful.

Processing order for Nginx:
https://nginx.org/en/docs/http/request_processing.html

Antiquated web

Google says anybody using current RFC's that they don't care for is using the "antiquated and inconsistent web".
It is probably harder to exert power over a decentralized system like that given their need for dominance.
Such a shame that they are forced to play in the sandbox with others.
A sandbox built by a collaborative effort of many of others.
A sandbox which was designed and built prior to Googles arrival.
I wonder what became of CompuServe?

Other stuff I forget

Check for http/2 support using curl:

curl -Iks https://websi.te

Only have Python 3 in your docker image and want to resolve a host?

import socket

socket.getaddrinfo("host.na.me", 80, proto=socket.IPPROTO_TCP)

OpenSSL - silent all these years...

Were you enjoying the OpenSSL relatively quiet reprieve since Heartbleed?
https://isc.sans.edu/forums/diary/Upcoming+Critical+OpenSSL+Vulnerability+What+will+be+Affected/29192
Probably time to clear your schedule on Monday and Tuesday (or heck just clear the weekend) 10/29/2022 - 11/1/2022
The OpenSSL 3.0.x versions should be updated/patched - OpenSSL 1.1.1 need not apply
Happy fall patching season to you all!

Slow queries after importing an older MySQL dump to MariaDB?

The problem might be a big table (many rows) but 0 Cardinality...

use dbname;
show index in tablename;

| Table... | Cardinality |
| tablename|           0 |

Fix the table(s):

use dbname;
ANALYZE TABLE tablename;

Alteratively:

mysqlcheck -a dbname

show index in tablename;
| Table... | Cardinality |
| tablename|       12345 |