Adam thespad

So you hate SQLite

This document will go over the key items for migrating and setting up Postgres support in Prowlarr.

Creation of initial database

We do this also when migrating, this is to ensure Prowlarr sets up the required schema.

Setting up Postgres

Exporting your 2FA tokens from Authy to transfer them into another 2FA application

IMPORTANT - Update regarding deprecation of Authy desktop apps

Past August 2024, Authy stopped supported the desktop version of their apps:
See Authy is shutting down its desktop app | The 2FA app Authy will only be available on Android and iOS starting in August for details.

And indeed, after a while, Authy changed something in their backend which now prevents the old desktop app from logging in. If you are already logged in, then you are in luck, and you can follow the instructions below to export your tokens.

If you are not logged in anymore, but can find a backup of the necessary files, then restore those files, and re-install Authy 2.2.3 following the instructions below, and it should work as expected.

The Scoping Rules of Bash

There are 5 types of scopes in Bash:

Environment Scope - export x=1; echo "$x"; command
Shell Scope - x=1; echo "$x"
Function Scope - f () { local x=1; echo "$x"; }; f
Command Scope - x=1 command
Subshell Scope - x=1; (echo "$x"; y=2); echo $y

	select setval('public."AutoTagging_Id_seq"', (SELECT MAX("Id")+1 FROM "AutoTagging"));
	select setval('public."Commands_Id_seq"', (SELECT MAX("Id")+1 FROM "Commands"));
	select setval('public."Config_Id_seq"', (SELECT MAX("Id")+1 FROM "Config"));
	select setval('public."CustomFilters_Id_seq"', (SELECT MAX("Id")+1 FROM "CustomFilters"));
	select setval('public."CustomFormats_Id_seq"', (SELECT MAX("Id")+1 FROM "CustomFormats"));
	select setval('public."DelayProfiles_Id_seq"', (SELECT MAX("Id")+1 FROM "DelayProfiles"));
	select setval('public."DownloadClientStatus_Id_seq"', (SELECT MAX("Id")+1 FROM "DownloadClientStatus"));
	select setval('public."DownloadClients_Id_seq"', (SELECT MAX("Id")+1 FROM "DownloadClients"));
	select setval('public."DownloadHistory_Id_seq"', (SELECT MAX("Id")+1 FROM "DownloadHistory"));
	select setval('public."EpisodeFiles_Id_seq"', (SELECT MAX("Id")+1 FROM "EpisodeFiles"));

	#!/usr/bin/env python3
	import os
	import bencode
	import re
	import sys

	# Inspired by https://github.com/ctminime/QB_Migrate_to_Linux
	# Need `pip3 install bencode.py`.
	# Run in folder like "/home/user/.local/share/data/qBittorrent/BT_backup/" (configured in qBitTorrent).
	# Takes 2 parameters:

	#! /bin/bash

	# NEWLY ADDED BACKUP FUNCTIONALITY IS NOT FULLY TESTED YET, USE WITH CARE, ESPECIALLY DELETION
	# Developed for DSM 6 - 7.0.1. Not tested on other versions.
	# Steps to install
	# Save this script in one of your shares
	# Edit it according to your requirements
	# Backup /usr/syno/share/nginx/ as follows:
	# # cd /usr/syno/share/
	# # tar cvf ~/nginx.tar nginx

	#!/usr/bin/python3
	# reads a list of IP subnets in CIDR notation from stdin and collapses it

	import sys
	import ipaddress

	subnets6 = []
	subnets4 = []

	input_list = sys.stdin.readlines()

	import urllib
	import json
	import string
	import sys
	import ConfigParser
	import tweepy

	def craftTweet(match_id, level, hero, kills, deaths, assists):
	unformatted = 'Just played a match: Hero: Lvl. {} {} K/D/A: {}/{}/{}\nDotabuff: {}'

	# Credit http://stackoverflow.com/a/2514279
	for branch in `git branch -r \| grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch \| head -n 1` \\t$branch; done \| sort -r