Author: foxbox

Mastodon CLI commands

Again a quick not for myself and putting a copy here in case something internets goes poof; https://docs.joinmastodon.org/admin/tootctl/#media

tootctl media remove

Removes locally cached copies of media attachments, avatars or profile headers from other servers. By default, only media attachments are removed.

--days N
How old media attachments have to be before they are removed. In case of avatars and headers, how old the last webfinger request and update to the user has to be before they are removed. Defaults to 7.
--concurrency N
The number of workers to use for this task. Defaults to N=5.
--prune-profiles
Instead of media attachments, remove locally cached copies of avatars and headers from other servers. Cannot be combined with --remove-headers.
--remove-headers
Instead of media attachments, remove locally cached copies of headers from other servers. Cannot be combined with --prune-profiles.
--include-follows
Override the default behavior of --prune-profiles and --remove-headers to remove locally cached copies of avatars (and headers) from other servers, irrespective of follow status (by default, they are only removed from accounts that are not followed by or following anyone locally). Can only be used with --prune-profiles or --remove-headers.
--verbose
Print additional information while task is processing.
--dry-run
Print expected results only, without performing any actions.

tootctl media remove-orphans

Scans for files that do not belong to existing media attachments, and remove them. Please mind that some storage providers charge for the necessary API requests to list objects. Also, this operation requires iterating over every single file individually, so it will be slow.

--start-after
The Paperclip attachment key where the loop will start. Use this option if the command was interrupted before.
--dry-run
Print expected results only, without performing any actions.
--prefix
Traverse only a specific prefix of files in the system.
--fix-permissions
Sets S3 ACL to be default according to environment variables.

tootctl media refresh

Refetch remote media attachments from other servers. You must specify the source of media attachments with either --status, --account, --domain, or --days. If an attachment already exists in the database, it will not be overwritten unless you use --force.

--account ACCT
String username@domain handle of the account
--domain DOMAIN
FQDN string
--status ID
Local numeric ID of the status in the database.
--days N
The number of days to limit this task to.
--concurrency N
The number of workers to use for this task. Defaults to 5.
--verbose
Print additional information while task is processing.
--dry-run
Print expected results only, without performing any actions.
--force
Force redownload the remote resource and overwrite the local attachment.

tootctl media usage

Calculate disk space consumed by Mastodon.

tootctl media lookup

Prompts for a media URL, then looks up the status where the media is displayed.

Loading

Installing FFMPEG on a Windows system

Had to do this, so I make a note of it.

  1. Download the latest ffmpeg build:
    Full: https://www.gyan.dev/ffmpeg/builds/ffmpeg-git-full.7z
    Essentials: https://www.gyan.dev/ffmpeg/builds/ffmpeg-git-essentials.7z
  2. Buy this dude a coffee: https://www.buymeacoffee.com/gyan
  3. Unpack your downloaded software
  4. Create a folder in your root, like C:\ffmpeg
  5. Move the three folders BIN, DOCS, PRESETS into the ffmpeg folder
  6. Open CMD with admin rights
  7. Paste the following into the command terminal and hit enter: 
    setx /m PATH "C:\ffmpeg\bin;%PATH%"
  8. Type “ffmpeg” in the terminal and you should see a reply from the software.
  9. Done.

Loading

WireGuard – Allow Local Network

the logo of a VPN app named WireGuard, depicting a white dragon against a red background

And by Local Network, I mean here on my workstation, not at the peer or VPN docker/server/provider.

I am not very knowledgeable with VPNs but I got to learn something new and when I do, I make a note of it. The problem was that when I have my VPN active to poke things at home, I could not print documents at my workstation at work.

Googled a lot, trid a few things and then realised that adding IP addresses to AllowedIPs in the PEER section, adds an exception for an IP address on the server’s side, NOT my workstation.

“Ooooh, what does this checkmark do?”

Confusingly enough, WireGuard names things differently between the Windows and the iOS app. So here’s what you need to check to gain access to your workstation’s local network:

  1. Open the WireGuard control panel.
  2. Click once on the vpn you want to change
  3. Click the EDIT button on the bottom right
  4. iOS: UN-Tick the box on the bottom left that says: “Exclude private IPs”, then click SAVE
    Windows: UN-Tick the box on the bottom left that says: “Block untunneled traffic (kill-switch)”, then click SAVE

Yes ,this poses a security risc, so I made two VPN profiles. One with and one without so I can easily switch from one to the other.

Loading

Oven temperatures

I found a printout of a website that of course does not exist any more unfortunately. Luckily, there is archive.org. #send_them_money

So, here’s some oven temperature conversion data. It covers conversion from Celcius to Silly and if your oven is old and has only settings, then I have a list for that as well.

TEMPERATURE
ºC
Celcius ->
 ºF
<- Fahrenheit		 ºF
Fahrenheit ->
 ºC
<- Celcius
0 32 32 0
25 77 50 10
50 122 100 38
75 167 150 65
100 212 200 93
125 257 250 121
150 302 300 149
175 347 350 177
200 392 400 204
225 437 450 232
250 482 500 260
275 527 550 288
300 572 600 315
OVEN SETTINGS
Electric oven
10 settings		 Temp Gas oven
8 settings		 Temp Gas oven
10 settings		 Temp
1 50°C 1 140°C 1 140°C
2 – 3 100°C 2 160°C 2 155°C
3 – 4 125°C 3 180°C 3 170°C
4 – 5 150°C 4 200°C 4 185°C
5 – 6 175°C 5 220°C 5 200°C
6 – 7 200°C 6 240°C 6 215°C
7 – 8 225°C 7 260°C 7 230°C
8 – 9 250°C 8 280°C 8 245°C
9 – 10 275°C 9 260°C
10 275°C
Convection oven
8 settings
 Temp Convection oven
10 settings		 Temp
1 125°C 1 40°C
2 140°C 2 – 3 85°C
3 155°C 3 – 4 105°C
4 170°C 4 – 5 130°C
5 185°C 5 – 6 150°C
6 205°C 6 – 7 170°C
7 225°C 7 – 8 190°C
8 240°C 8 – 9 215°C
9 – 10 235°C
WARMTE AANDUIDING (Old dutch ovens, can’t reliably translate this)
Temperatuur Oven Aanduiding
lauw 100-125°C
lauw warm 125-150°C
matig warm 150-175°C
warm 175-200°C
zeer warm 200-225°C
matig heet 225-250°C
heet 250-275°C
zeer heet 275-300°C

 

Loading

[Solved] MySQL docker on Unraid does an unwanted upgrade

the logo of mysql, showing the name and the outline of a dolphin.

I usually do not fear updates, but when it comes to databases, I am getting really careful with updating them. It wouldn’t be the first time when a database goes plonk after this.

So what happened? My MySQL docker got updated becuase I simply misclicked and of course, the thing broke. The update script, which was set to “latest”, performed an upgrade to 9.x instead of sticking to the latest 8.x version.

After some research, I read that one can enter “mysql:8.2.0” in the repository field. After entering this and starting the docker, the software got reinstalled with the proper version and everything worked again. I must’ve been lucky that the database itself was not migrated to v9 already, I guess.

Loading

Fixing a M4A file with a corrupted header

an icon in black and white with the text M4A

I found in my notes from 2017 a method to fix the header of a M4A file. Appartently I needed this back then to repair a file, and then forgot about the note. So here ya go:

ffmpeg -f aac -analyzeduration 100M -probesize 100M -i broken.m4a -c copy fixed.m4a

Loading

OpenSim server issues fixed

I happily run my own OpenSim server that is hooked onto OSGrig.org. My account there dates from 2007 and it got broken after the big crash in 2010.

It took quite a long time for them to restore the data and after a few years I decided to go back and see if i could revive my sims from the backups. And in 2013, I did so, successfully. You have no idea how great it is to see a backup rise from the dust and see, live, a sim being rebuilt. Since then, another 9 sims have been added and more landscaping has been done. Go have a look!

Sometimes though, my server crashes and I think I have now fixed it. Perhaps things got a bit too busy on a few cores, so I reserved 4 specifically for this server. Let’s see how that works! ^^

in-game screenshot of one of the opensim simulators. There is a railroad visible, some brushes and a house with a large waterwheel.

If the link to the grid does not work then open your viewer, log into the OSGrid and look for one of the following sims:

  • RynFox HQ1
  • RynFox HQ2
  • Himalchuli
  • Cho Oyu
  • Pumori
  • Saipal
  • Nuptse
  • Annapurna
  • Makalu
  • Yangra
  • Shishapangma
  • Lhotse
  • Jannu
  • Kangchenjunga
  • Dhaulagiri
  • Manaslu

If you detect a recurring theme in this list, then you are absolutely right 😉

 

Loading

Make your own Togarashi power (and Aioli)

the top view or a kitchen mortar, looking directly at the ground spices.
It’s hard work, I can tell you that.

I’ve used the Aioli for a pokebowl, matches really well with Sashimi Tuna.
You need besides a mortar and a jar the following ingredients:

  1. 3 tsp szechuan pepper
  2. 3 tsp chili flakes
  3. 3 tsp dried orange peel
  4. 2 tsp ginger powder
  5. 2 tsp sesame seed
  6. 2 tsp poppy seed
  7. ½ sheet of Nori

Grind the heck out of everything until everything looks evenly ground and the result should be medium coarse, if that’s any way of indicating it.

a close-up of the togarashi powder, the end product of a many spices ground together

Now put everything in a jar for later use.

The sauce:

  1. 1 cup of good mayo (will make a recipe for that as well, both the fast and slow version)
  2. 2 tsp smoked paprika powder
  3. 1 tsp sesame oil
  4. 1 tbsp soy sauce
  5. 1 tsp lemon juice
  6. 1 tbsp Togarashi powder

Mix everything together so there is an even consistency and let it rest in the refrigerator for 24 hours before use.

the top view of a recently made pokebowl with tuna, sugar snaps, paprika, lemon and cucumber.
See the orange-y blobs? That’s the sauce.

 

Loading