Diassembling Xiaomi Robot Vacuum C1
Vids: Vacuum motor: 1118MJT 20N704R500 in my case it was enough to remove the dust from the motor and filters for it, but i expect it’ll die in a few months; so i’m ordering a new one – just in case.
.pQd
qcow2 snapshots leading to data corruption in KVM + libvirt coming from Debian Trixie?
i don’t have any reproducible scenario, but i want to leave this one out in the open. maybe someone else experiences similar issue? after upgrading both OS on the physical servers and under VMs to Debian Trixie i’ve experienced 4 database corruptions – both under MySQL 5.8.4 and PostgreSQL 17, on different physical servers. it’s ... Read More
decoder for MySQL 8.4 row-level binlogs
i’ve run into a problem – i had mysql 8.4 binlogs in row format generated with binlog_rows_query_log_events =OFF; i needed to see how exactly certain rows looked like before / after particular updates. problem was – those rows contained blobs and output from mysqlbinlog -v was a mess: i needed to find a way to ... Read More
placki ziemniaczane
ja to robie z 3kg ziemniakow proporcje: przygotowanie:
kiszone buraki
z ~3kg burakow wychodzi ~5 sloikow 1L. sloiki schowac do ciemnego miejsca z teperatura pokojowa. ja trzymam je w duzym garku, w szafie – moze z nich cieknac. po 1-2 tygodniach otworzyc, zebrac ewentualna plesn z gory i wlozyc do lodowki. sa gotowe do jedzenia / picia.
using vector.dev to get haproxy, nginx logs into ClickHouse
at work we have few reverse proxies exposing some APIs. ClickHouse turned out to be great tool for analyzing logs, running ad-hoc research or gathering stats cyclically. below – configs that allow me to get HTTP requests passing via those proxies, including POST bodies, into ClickHouse. i’m using vector.dev to fetch, transform and ship logs. ... Read More
forcing rewrite of one of mdadm raid1 disks
on not so important server i got an alert about SMART errors and failing weekly surface test [ smartctl -d sat -t long /dev/sdb ]. i wanted to force the drive to re-allocate bad sectors; i could not read it anymore – cat /dev/sdb > /dev/null would fail with read errors. i remember reading somewhere ... Read More
rsync to/from synology failing
i was asked to copy some data from a Linux server to Synology NAS. SSH keys have been exchanged, i was able to ssh root@ipOfSynology. but trying to ssh something to it was failing: i’ve googled and i’ve found https://community.synology.com/enu/forum/1/post/121078 – i had to go to Synology’s admin page > Control Panel > Users & ... Read More
using transparent compression in btrfs
to compress any newly added file/directory – mount the file system with option compression=algorithm:compressionLevel e.g.: to compress individual file or folder, without compressing everything else stored on given file system: to check compression ratio: to check compression property for an existing folder: for more details – see https://btrfs.readthedocs.io/en/latest/Compression.html
ideas: TLS-aware firewall for outgoing traffic
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
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
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
455GB data SIM from orange.pl, 2 years validity – 34 PLN
what i’ve done to pile up bonus offers to get a data SIM that has long validity and does not cost arm and a leg: my findings are based on: EDITS:
Oracle cloud
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
putting manticore’s query.log, mysql’s slow query log into single lines
sometimes i’m dealing with large manticore logs where queries include line breaks. this helps me to get them into form that grep can work with: for mysql’s slow query log:
audiobooki i sluchowiska ktore lubi moja corka
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
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
ansible playbook increasing 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:
rsync without retransmitting moved files
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
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