| title | description | published | date | tags | editor | dateCreated |
|---|---|---|---|---|---|---|
Useful Tools |
true |
2022-03-16 23:38:21 UTC |
useful-tools |
markdown |
2021-06-05 20:51:53 UTC |
- Table of Contents
- Recovering a Corrupt DB
- Finding Cookies
- Clearing Cookies and Local Storage
- Other Projects and Programs - Request Apps *Arrs
- Other Projects and Programs - *Arr Related
- Other Projects and Programs - Torrents/Downloading
- Other Projects and Programs
- Twitter Connect The following apps are companions to the *Arr Suite of Applications or media hoarding in general. They are not maintained, developed, nor supported by the *Arr Development Team. Please direct any specific support questions to the respective application development team.
Note that the application's database can be found in the Application Data Directory which are linked below. The directory may also be passed as a datadir argument.
- Lidarr Appdata Directory
- Prowlarr Appdata Directory
- Radarr Appdata Directory
- Readarr Appdata Directory
- Sonarr Appdata Directory {.links-list}
There are two options to recover the database which are listed below.{.is-info}
{#windows} {#recovering-a-corrupt-db-ui}
Note this effectively does the same as
.recoverwhich requires Sqlite v3.29 | Please refer to the Sqlite docs for more details on the.recovercommand. The steps to do so are linked below {.is-info}
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. DB4S is for users and developers who want to create, search, and edit databases. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned. {.is-info}
- Stop the application
- Make a copy of your corrupt database (
.db) and copy any.shmand.walfiles with it - Open your corrupt database in DB Browser for SQLite (DB4S)
- File => Export => Export database to SQL file
- Select all tables
- Check/Enable "Keep column names in INSERT INTO"
- Export Everything
- Overwrite old schema
- Save
- Close the database
- New Database => File => Import => import that file from the previous export step
- Any import errors or constraint issues, clean up the problematic insert statement if possible or delete it
- Save the database when prompted.
- Tools => Integrity Check; the result should say OK
- Close the database
- Remove all
wal,shm, anddbfiles from the config folder - Save (or copy, if *Arr is not on the same system as DB4S) the new database in the config folder and point the application at it. All *Arrs name their database as
<appname>.dbe.g.radarr.db - Correct permissions for the recovered database if needed. The owner should be the user and group *Arr is configured to run as.
- Start the application
{#nix}
The below instructions are for *Nix Operating Systems, but the concept will be similar on Windows Command Line.
This uses the sqlite3
.recovercommand is ideal. Note that it requires Sqlite 3.29+ {.is-info}
Given sqlite3 is required by *Arrs it is assumed you have sqlite3 installed on your system {.is-info}
- Stop the application
- SSH into your box or otherwise get a shell up
- Enter
sqlite3 <path to bad database> ".recover" | sqlite3 <output path for recovered database> - Correct permissions for the recovered database if needed. The owner should be the user and group *Arr is configured to run as.
- Remove or move/rename the old corrupt database and any
walorshmin the folder - Rename the covered database. All *Arrs name their database as
<appname>.dbe.g.radarr.db - Start the application
- Some sites cannot be logged into automatically and require you to login manually then give the cookies to to work. The pages below describe how you do that.
-
Go to the torrent tracker website and log in.
-
Hit F12
-
Under the Application tab at the top, there will be "Storage" on the left side. You will see a "Cookies" subsection, and under that you will see your tracker's url. Click on that.
-
Click on "Pass" on that tab or a similar entry, and it will pop up a box that says "Cookie Value" with a string about 25-30 chars long. Copy that and paste it into the application that needs it.
- If the string looks similar to
cid=cid-that-you-got-from-the-browser; sid=sid-that-you-got-from-the-browserthen the entire entry should be used.
- If the string looks similar to
Firefox
- You may also reference Chrome's documents Chrome cookies
- Navigate to
chrome://settings/siteData - Enter the site (or app) name you wish to clear
- Click the trash icon for the site
- Please see Mozilla's Help Article
- Navigate to
edge://settings/siteData - Enter the site (or app) name you wish to clear
- Click the arrow for the site
- Click the trash icon for the site
Notifiarr is a tool created to facilitate more in-depth detailed discord notifications by one of the *Arr Developers. It provides a configurable way to add notifications (including reactions) based on triggers you pick. Website provides a UI or picking what to show in the notification. Includes support for Grab, Import, Upgrade, Health, & Failed notifications in addition to much more.
Highlights
- Application Status
- Requests and Approvals (~Ombi)
- Customizable *ARR application notifications
- Request System with approvals
- Follow system for users to monitor a series or movie and be notified (via @mentions)
- Server Status
- Frequent New Features
Ombi gives users the ability to request movies, tv shows (series, seasons or single episodes) and music albums.
Overseerr is a request management and media discovery tool built to work with your existing Plex ecosystem.
Petio is a third party companion app available to Plex server owners to allow their users to request, review and discover content.
The app is built to appear instantly familiar and intuitive to even the most tech-agnostic users. Petio will help you manage requests from your users, connect to other third party apps such as Sonarr and Radarr, notify users when content is available and track request progress. Petio also allows users to discover media both on and off your server, quickly and easily find related content and review to leave their opinion for other users.
LunaSea is a fully featured, open source self-hosted controller! Focused on giving you a seamless experience between all of your self-hosted media software
Add new movies/shows to your system easily with your phone. App available at Google Play
Automated Music Downloader RandomNinjaAtk/amd is a Lidarr companion script to automatically download music for Lidarr
Automated Music Video Downloader RandomNinjaAtk/amvd is a Lidarr companion script to automatically download and tag Music Videos for use in other video applications (plex/kodi/jellyfin/emby)
Automated Movie Trailer Downloader RandomNinjaAtk/amtd is a Radarr companion script to automatically download movie trailers and extras for use in other video applications (plex/kodi/jellyfin/emby)
Bazarr is a companion application to Sonarr and Radarr that manages and downloads subtitles based on your requirements.
Cross-Seed is an app designed to help you download torrents that you can cross seed based on your existing torrents. It is designed to match conservatively to minimize manual intervention. It supports Jackett and Qbittorrent/rTorrent at this time.
Unpackerr This application runs as a daemon on your download host. It checks for completed downloads and extracts them so *Arr may import them.
There are a handful of options out there for extracting and deleting files after your client downloads them. Captain just didn't care for any of them, so He wrote my own. He wanted a small single-binary with reasonable logging that can extract downloaded archives and clean up the mess after they've been imported.
qBit Management a.k.a. "qbit_manage" is a program used to manage your qBittorrent instance such as:
- Tag torrents based on tracker URL (only tag torrents that have no tags)
- Update categories based on save directory
- Remove unregistered torrents (delete data & torrent if it is not being cross-seeded, otherwise it will just remove the torrent)
- Automatically add cross-seed torrents in paused state (used in conjunction with the cross-seed script)
- Recheck paused torrents sorted by lowest size and resume if completed
- Remove orphaned files from your root directory that are not referenced by qBittorrent
- Tag any torrents that have no hard links and allows optional cleanup to delete these torrents and contents based on maximum ratio and/or time seeded
FileBot is the ultimate tool for organizing and renaming your Movies, TV Shows and Anime as well as fetching subtitles and artwork. It's smart and just works.
Jdupes is a program for identifying and taking actions upon duplicate files.
TRaSH has a guide as well {.is-info}
-
jdupes -M -r "/data/tv/" "/data/tv/.torrents/"<= this would check for double files and print a summary of the results -
jdupes -L -r "/data/tv/" "/data/tv/.torrents/"<= this would recreate them as hardlinks thus reducing the used duplicate space
Plex Meta Manager (PMM) is a Python script to update metadata information for movies, shows, and collections as well as automatically build collections.
Tautulli is a 3rd party application that you can run alongside your Plex Media Server to monitor activity and track various statistics. Most importantly, these statistics include what has been watched, who watched it, when and where they watched it, and how it was watched. The only thing missing is "why they watched it", but who am I to question your 42 plays of Frozen. All statistics are presented in a nice and clean interface with many tables and graphs, which makes it easy to brag about your server to everyone else.
Tdarr is a closed-source self hosted web-app for automating media library transcode/remux management and making sure your files are exactly how you need them to be in terms of codecs/streams/containers etc. Designed to work alongside Sonarr/Radarr and built with the aim of modularization, parallelization and scalability, each library you add has its own transcode settings, filters and schedule. Workers can be fired up and closed down as necessary, and are split into 3 types - 'general', 'transcode' and 'health check'. Worker limits can be managed by the scheduler as well as manually.
Create a Twitter application (if you haven't already) at https://apps.twitter.com/
Fill in the mandatory fields as well as the callback URL, set it to a publicly available URL (not localhost), it doesn't need to exist, but it does need to be set, using https://sonarr.tv/twitter or https://radarr.video is sufficient.