Fox’s Projects – Failed and working projects, notes etc.

Adminer Installation

Super light DataBase managing thingy:

INSTALL:

sudo mkdir /usr/share/adminer
sudo wget -O /usr/share/adminer/adminer.php https://www.adminer.org/latest.php

SYMLINK NGINX

sudo ln -s /usr/share/adminer/adminer.php /usr/share/nginx/html/adminer.php

SYMLINK APACHE:

sudo ln -s /usr/share/adminer/adminer.php /var/www/html/adminer.php

Sidenote: If you have your web root anwhere else, you need to link it to that specific point. Also, this has been a install for Debian 11.

Backing up an OpenSim region

1. show regions

2. Write down the regions

3. change region REGIONNAME

4. save oars/REGIONNAME.oar

I have already made an “oars” folder in the bin folder and looking for a way to automate this process as I have 16 regions. The region names are CaPs SeNsItIvE.

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.

Installing FFMPEG on a Windows system

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

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
Buy this dude a coffee: https://www.buymeacoffee.com/gyan
Unpack your downloaded software
Create a folder in your root, like C:\ffmpeg
Move the three folders BIN, DOCS, PRESETS into the ffmpeg folder
Open CMD with admin rights
Paste the following into the command terminal and hit enter:
```
setx /m PATH "C:\ffmpeg\bin;%PATH%"
```
Type “ffmpeg” in the terminal and you should see a reply from the software.
Done.

WireGuard – Allow Local Network

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:

Open the WireGuard control panel.
Click once on the vpn you want to change
Click the EDIT button on the bottom right
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.

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

The joy of FIND

Find a folder:

find FOLDER -type d -iname FOLDERNAME

Find a file:

find FOLDER -type f -iname FILENAME

Find a symbolic link:

find FOLDER -type l -iname FILENAME

Quickly change directory permissions:

find . -type d -print0 | xargs -0 chmod 755

Quickly change file permissions:

find . -type f -print0 | xargs -0 chmod 644

Quick PostgreSQL user/pass commands

myusername = the username you want to give access to the database
mypassword = the password you want to assign to the user

sudo -u postgres psql
create database mydb;
create user myusername with encrypted password 'mypassword';
grant all privileges on database mydb to myusername;

Done.

[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.

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