.pQd

ideas: TLS-aware firewall for outgoing traffic

by .pQd
i’d love to have linux-based strict firewall for outgoing traffic. one that can allow for traffic to specific domain name [behind CDN], rather than fixed IP addresses. i did not find yet something that would tick all my check boxes, nevertheless – few links to related projects and discussions:

matching sshd’s log ‘Accepted publickey for’ to specific public key

by .pQd
journalctl -f or tail -f /var/log/auth.log shows on successful login something like this: that GDF…….somehash………………k is a fingerprint of publish ssh key and matches one of the entries in authorized_keys. which one? will show you fingerprints for all of the existing authorized keys, now you can match it with the log trace of successful login.

logging from ipad/linux or windows to windows PC which has local account associated with hotmail.com or outlook.com

by .pQd
task: get remote desktop to work from ipad or linux. connection is done to windows 10/11 pro pc which has local account associated with hotmail or outlook and uses pin to log in. i’ve found a solution at https://superuser.com/questions/1618530/rdp-to-home-pc-with-windows-hello-pin and had to: then use rdp client and log in with login: MicrosoftAccount\something@hotmail.com, as password – ... Read More

Oracle cloud

by .pQd
Oracle is has quite generous Always Free Tier, so i’ve registered and set up a VM there. so i ended up on VM.Standard.E2.1.Micro with AMD CPU underneath i could not get ARM instance – looks like ‘Out of capacity for shape VM.Standard.A1.Flex in availability domain AD-1. Create the instance in a different availability domain or ... Read More

audiobooki i sluchowiska ktore lubi moja corka

by .pQd
corka od wieku ~5 lat korzysta z glosnika odtwarzajacego mp3’jki – byl to strzal w dziesiatke. mam nadzieje ze jeszcze dlugo wytrzyma bez ‘migajacego ekranu’. co jej przypadlo do gustu w wieku 5-7 lat? biblioteki publiczne ftw – znalazlem tam mase ksiazek nie obarczonych DRM’em, na youtube tez mozna duzo znalezc, przydaje sie yt-dlp.

manticore search available via ClickHouse

by .pQd
i’m a big fan of ClickHouse; over time it became central hub for any sort of business intelligence analytics. at work we replicate data to it, use dictionaries loaded over http and mysql, recently – we’re also using MySQL table or database functions to be able to run queries with joins across data from various ... Read More

rsync without retransmitting moved files

by .pQd
i’m using rsync a lot; both at work [ backups, replication of content to various servers, ad-hoc copying ] and privately. it’s smart enough to avoid re-sending the whole file if it has grown a bit [ like logs like to do ] or only few bytes changed in source or destination. out-of-the-box rsync is ... Read More

Ideas: rsync-like tool parallelizing transfer of large files

by .pQd
i use rsync heavily for backups, batch jobs and one-off tasks. every day it moves around terabytes of data for me. while it’s great – saves time and bandwidth, it could make even better use of modern hardware – multicore, and often with plenty of unused storage IOps: one day, when i’ll have some spare ... Read More

splitting ebook in one mp3 into multiple files

by .pQd
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

Hong Kong, again

by .pQd
i got yet another chance to travel to Hong Kong. i’ve spent there 9 days in October this year. what did change since my previous visit in 2018? what did not change: few places that i’ve hiked around for the first time: Lamma Island – i got there with a ferry from Central. concrete path ... Read More

beko dishwasher showing e01 code

by .pQd
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

random things that inspire me

by .pQd
SQLite’s code of ethics: https://www.sqlite.org/codeofethics.html altamira’s ten investment commandments

New supermicro server does not ‘see’ some of NVMe drives

by .pQd
i got 3 identical new servers from supermicro – SYS-121C-TN10R. all three have the same disk setup – 2+4 NVMe drives, but Debian 12 just see 5 of them instead of 6. when i run dmesg on newly installed system i can see those errors: to solve it i had to change PCIe bifurcation in ... Read More

charging Amazfit Band 5

by .pQd
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