tech and other interesting stuff
We’re using OCR to extract game metadata from Deep Rock Galactic videos. We’re now at the point where if we give our script two images – one of the loading screen, one of the end screen – it does a pretty good job of pulling out the information. Now we need a way to pull […]
Continue ReadingMy path in the woods diverged, and I took them all We’ve been seeing if we can apply OCR to the loading screen of Deep Rock Galactic to generate metadata for YouTube uploads for automation. Last time, we got a quick-and-dirty script that would pull out the various parts of one image successfully. Now we’d […]
Continue Reading
What a tangled web we weave… I was confused. Staring at a console window, wondering how I’d installed a program†. The system package manager knew nothing about it, pip pretended like it never heard of it, and I hadn’t downloaded and compiled the source. I’ve never really had what anyone would call a sane management […]
Continue Readingtl;dr If you’re seeing this and the table does exist- check (and fix) permissions! I was searching my backups for a database file which contained the entries for an old ranty blog I used to have before I cancelled the domain. Lo and behold I had a named, dated .tgz file. Unusually, it contained a […]
Continue Readingtl;dr: run myisamchk on the problematic table I’ve run into the following error in my Apache error.log recently: Table ‘database.tablename’ is marked as crashed and last (automatic?) repair failed Fortunately the fix is simple: run myisamchk on the table which is marked as crashed: $ sudo su # service mysql stop # cd /var/lib/mysql/databasename # […]
Continue Readingtl;dr: use jdupes I was merging some fileserver content, and realised I would inevitably end up with duplicates. “Aha”, I thought “time to use good old fdupes“. Well yes, except a few hours later, fdupes was still only at a few percent. Turns out running it on a collected merged mélange of files which are […]
Continue Readingtl;dr: Loop through the files in bash, sox them to FLAC Success! I’ve been combining fileserver contents recently, and I came across a little archive of Teamspeak 3 recordings: $ du -sh . 483G /home/robert/storage/media/ts_recordings/ Eep. I wrote a quick-and-dirty script to convert the files: #!/bin/bash n=0 total=$(ls *.wav|wc) ls *.wav | while read file; […]
Continue Readingtl;dr: use dmsetup remove before trying lvremove Note: Volume group and logical volume names have been substituted here. I’m not entirely sure it’s necessary, but better safe than sorry. If following this, please use the names of your volume group[s] and logical volume[s] I am in the process of combining fileserver information, and so I […]
Continue Readingtl;dr: if you’re sure you did everything right, use lsblk or parted (etc) to see if a partition table is present on your logical volume. So I am in the process of merging the content of two fileservers, and had the need to extend a logical volume to accommodate some additional data. No problem- that’s […]
Continue Readingtl;dr: Seems the quickest way of doing this was to fire up a VM, install mysql-server and mysql-client and browse that way. I have backups of things. This is important, because as the old adage goes: running without backups is data loss waiting to happen. I’m not sure if that’s the adage, but it’s something […]
Continue Reading