ansible playbook increasing log log retention period
i needed to adjust local log retention period on bunch of servers. rules: with some help from chatgpt and grog3 i’ve cobbled this one:
unimportant
splitting ebook in one mp3 into multiple files
my daughter likes to listen to audiobooks; some of them come from youtube, some are multi-hour long. it’s easier to listen, re-listen if book is chopped into shorter chapter-alike files. how do i do it? yt-dlp is a swiss army knife for downloading audio/video from multiple hosting services mp3splt allows to split mp3 files in ... Read More
beko dishwasher showing e01 code
our dishwasher stopped working, displayed E01 code and whenever closed was running drain pump all the time. i’ve called their support and learned it’s a known anti-flood feature and is caused by water that leaked gradually out of dishwasher and stayed in its base. solution? makes you wonder why does the water leak out of ... Read More
Using mitmproxy to allow closed-source application to communicate with licensing server with expired TLS cert
we’re using a 3rd party library that shall remain nameless. vendor provides this library to us in form of few .so files, few headers and sample code. we have a small custom c++ wrapper for it. whenever library is initialized – it makes a call to licensing server and does some challenge/response verification. on one ... Read More
Sound-generating online apps
list of few online apps that my daughter likes: longer lists of tools:
random things that inspire me
SQLite’s code of ethics: https://www.sqlite.org/codeofethics.html altamira’s ten investment commandments
charging Amazfit Band 5
i’m a happy user of Amazfit Band 5. it’s dirt cheap, paired with gadgetbridge – works fine without sharing any data with cloud-hosted big brother, all in all – it helps to keep me moving around each day. i had few occasions when i needed to charge it [ every ~2 weeks ] and did ... Read More
cheescake recipe
ingredients: procedure:
Fastly returning “Requested host does not match any Subject Alternative Names (SANs) on TLS certificate”, HTTP/421
due to $reasons we have an nginx-proxy that is a reverse proxy forwarding to Fastly CDN which, in turn, forwards back to our infrastructure. starting from the 2024-02-27 this stopped working, for some HTTP queries. most notably those using OPTION verb. response that nginx was getting from Fastly had HTTP/421 status code and payload: colleague ... Read More
KVM – listing VMs with their memory allocation
i needed to list all VMs on given KVM server and sort them by amount of RAM allocated to each. ugly but does the trick.
Ohook – activating MS office
this might be useful, especially for environments where automated tests of MS-office-dependent applications are done: https://massgrave.dev/ohook.html + https://github.com/asdcorp/ohook
podcast about evolution of mysql at booking.com
very interesting, content-heavy, interview with Kristian Köhntopp about his work at booking.com: 1, 2 [ alternatively on youtube: 1, 2 ].
freecad – editing STL file
for 0.21.2 based on this yt video: https://www.youtube.com/watch?v=dr1qtaURrvI
parallel rsync
rsync remains my main tool for transferring backups or just moving data between servers. but it has some pain points – e.g. rsync’s checksum calculation or ssh over which data is piped can easily saturate single CPU core before i run out of storage I/O or network bandwidth. how to parallelize it – based on ... Read More
resources for learning SQL
SQL basics: indexes: https://use-the-index-luke.com/ ‘modern’ SQL: fiddles – web-based sandboxes:
bug in postgresql’s GIN index
it’s a story without happy end. i’m absolutely sure there’s an index-corruption bug in PostgreSQL 13; since i have not seen any mention of it being fixed – it’s likely in the following releases as well. i’ve tried to get attention to it on the pgsql-bugs mailing list but i failed. likely because i’ve never ... Read More
WSL installation fails with “A specified logon session does not exist. It may already have been terminated.”
i’ve tried to install wsl on Win 11 PRO PC and got this: solution: try again based on this comment.
Apache2: url-based exception for ProxyPass
i have apache2 reverse proxy which passes traffic to some application server. everything going to /server/ is handled by http://localhost:8000. i had to do one exception – serve content for /server/something.txt from a static file. here’s what i did:
rsync to exfat mount
exfat does not carry information about user/group ownership of files/directories, has less precise timestamps. to make rsync stop complaining about it i’m using:
userauth_pubkey: signature algorithm ssh-rsa not in PubkeyAcceptedAlgorithms [preauth]
colleague reported that he cannot anymore log-in using putty, via ssh to server that was recently upgraded to Debian Bookworm. /var/log/auth.log showed: putty log it turned out that it was pretty old putty – 0.74, just upgrading it to the more recent one [ 0.78 at the time of writing ] solved it. alternatively i ... Read More