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.
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
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.
.db) and copy any
.walfiles with it
dbfiles from the config folder
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+
Given sqlite3 is required by *Arrs it is assumed you have sqlite3 installed on your system
sqlite3 <path to bad database> ".recover" | sqlite3 <output path for recovered database>
shmin the folder
Go to the torrent tracker website and log in.
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.
cid=cid-that-you-got-from-the-browser; sid=sid-that-you-got-from-the-browserthen the entire entry should be used.
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.
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:
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
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.