#Table of Contents

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.

#Recovering a Corrupt DB

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.

There are two options to recover the database which are listed below.{.is-info}

#Recovering a Corrupt DB (UI) (Windows)

{#windows} {#recovering-a-corrupt-db-ui}

Note this effectively does the same as .recover which requires Sqlite v3.29 | Please refer to the Sqlite docs for more details on the .recover command. 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}

  1. Stop the application
  2. Make a copy of your corrupt database (.db) and copy any .shm and .wal files with it
  3. Open your corrupt database in DB Browser for SQLite (DB4S)
  4. File => Export => Export database to SQL file
  5. Select all tables
  6. Check/Enable "Keep column names in INSERT INTO"
  7. Export Everything
  8. Overwrite old schema
  9. Save
  10. Close the database
  11. New Database => File => Import => import that file from the previous export step
  12. Any import errors or constraint issues, clean up the problematic insert statement if possible or delete it
  13. In the Execute SQL tab, execute the following SQL VACUUM;
  14. Save the database when prompted.
  15. Tools => Integrity Check; the result should say OK
  16. Close the database
  17. Remove all wal, shm, and db files from the config folder
  18. 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>.db e.g. radarr.db
  19. Correct permissions for the recovered database if needed. The owner should be the user and group *Arr is configured to run as.
  20. Start the application

Please note that the gif does not cover the VACUUM; command

The original upstream wiki included an animated recovery screenshot here. This ReadAIrr docs copy keeps the command steps below as the source of truth.

#Command Line DB Recovery

{#nix}

The below instructions are for *Nix Operating Systems, but the concept will be similar on Windows Command Line.

This uses the sqlite3 .recover command 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}

  1. Stop the application
  2. SSH into your box or otherwise get a shell up
  3. Enter sqlite3 <path to bad database> ".recover" | sqlite3 <output path for recovered database>
  4. Correct permissions for the recovered database if needed. The owner should be the user and group *Arr is configured to run as.
  5. Remove or move/rename the old corrupt database and any wal or shm in the folder
  6. Rename the covered database. All *Arrs name their database as <appname>.db e.g. radarr.db
  7. Start the application

#Finding Cookies

#General Instructions

  1. Login to the Web Site with your browser using the Site Link address you have chosen to use from the Prowlarr indexer config
  2. Open the DevTools panel by pressing F12
  3. Select the Network tab
  4. Click on the Doc button (Chrome Browser) or HTML button (Firefox Browser)
  5. Refresh the page by pressing F5
  6. Click on the first row entry
  7. Select the Headers tab on the right panel
  8. Find 'cookie:' in the Request Headers section. Refer to the helptext within the UI for your tracker for details
  9. Select and Copy the whole cookie string (everything after the cookie: )
  10. Delete anything already in the Prowlarr indexer config cookie box
  11. Paste your copied cookie string to that box
  12. Click Save

If user agent is required for your tracker, it can be found in the Request Headers {.is-info}

#Notes

#Chrome

cookie_chrome.png

#Firefox

faq_3_cookies.png

#Clearing Cookies and Local Storage

#Chrome

  1. Navigate to chrome://settings/siteData
  2. Enter the site (or app) name you wish to clear
  3. Click the trash icon for the site

#Firefox

#Microsoft Edge (Chromium)

  1. Navigate to edge://settings/siteData
  2. Enter the site (or app) name you wish to clear
  3. Click the arrow for the site
  4. Click the trash icon for the site

#Using Environment Variables for Config

All of the *arrs now have the ability to use environment variables to override entries in config.xml. The pattern for variable naming is predictable and can be used to set any config entry. In general the environment variables are comprised of 3 parts, delimited by two underscores.

APPNAME__CONFIGNAMESPACE__CONFIGITEM

For detailed environment variable documentation for each app, see:

The app name that should be used is simply the app name that the environment variable is passed to: RADARR, SONARR, PROWLARR, etc.

The config namespaces are currently predictable and shared between all apps. It is simply the option types for the options files in the project, located in the src/NzbDrone.Common/Options directory. The namespaces are currently:

#Other Projects and Programs - Request Apps *Arrs

#Notifiarr (fka Discord Notifier)

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.

Wiki

Highlights

#Ombi

Ombi gives users the ability to request movies, tv shows (series, seasons or single episodes) and music albums.

#Seerr

Seer is a media discovery and request management tool for Jellyfin, Plex, and Emby.

#Petio

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.

#Other Projects and Programs - *Arr Related

#Remote Control

#LunaSea

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. Manage new media content fetched via Lidarr, Radarr, and Sonarr.

#Radarr & Sonarr Companion - Android App

Add new movies/shows to your system easily with your phone. App available at Google Play

#nzb360 - Android App

nzb360 provides management of Sonarr, Radarr, Lidarr, torrents, usenet, and other services. App available at Google Play Check official website for more info.

#Lidarr

#AMD

Automated Music Downloader RandomNinjaAtk/amd is a Lidarr companion script to automatically download music for Lidarr

#AMVD

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)

#Radarr

#AMTD

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)

#Subtitles

#Bazarr

Bazarr is a companion application to Sonarr and Radarr that manages and downloads subtitles based on your requirements.

#Other Projects and Programs - Torrents/Downloading

#Cross-Seed

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.

#Toolbarr

Toolbarr provides a suite of utilities to fix problems with Starr applications. Toolbarr allows you to perform various actions against your Starr apps and their SQLite3 databases. The most useful feature is being able to convert paths from linux to windows and windows to linux.

#Unpackerr

Unpackerr This application runs as a daemon on your download host. It checks for completed downloads and extracts them so *Arr may import them.

#qBit Management

qBit Management a.k.a. "qbit_manage" is a program used to manage your qBittorrent instance such as:

#Other Projects and Programs

#Filebot

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

Jdupes is a program for identifying and taking actions upon duplicate files.

TRaSH has a guide as well {.is-info}

#Drazzilb's UserScripts

#Just A Bunch Of Starr Scripts

#Just A Bunch Of Plex Scripts

#Kometa

Kometa (FKA Meta Manager (PMM)) is a Python script to update metadata information for movies, shows, and collections as well as automatically build collections.

Kometa (formerly known as Plex Meta Manager) is a powerful tool designed to give you complete control over your media libraries. With Kometa, you can take your customization to the next level, with granular control over metadata, collections, overlays, and much more.

#Tautulli

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

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.

#tdarr_inform

tdarr_inform is a custom script for Sonarr and Radarr to inform Tdarr of new/changed/deleted files without relying on filesystem events or frequent disk scanning.

#Deleterr

Deleterr is a tool to delete stale and inactive media from Plex/Sonarr/Radarr. It helps managing limited space when you allow users to request shows via Seerr/Ombi but don't want to manually monitor available disk space. It's configurable to support only deleting media meeting your defined criteria.

#Twitter Connect

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.