Sonarr Tips and Tricks
TRaSH's Custom Formats
Converting DB paths from Windows to Linux with SQL commands
This document is to provide a guide for users who want to move their Sonarr from Windows to Linux, while maintaining all data from the Windows setup.
DISCLAIMER
I am by no means an expert when it comes to SQL or databases. This guide is a use at your own risk, and I recommend making a copy of sonarr.db with a backup or two.
This process can likely be scripted via Python, or some other language, however I do not posses that skill.
This is the process that I went through during my configuration change, your mileage may vary.
Conversion guide
Make sure Sonarr is not running on the Linux Machine prior to copying the Database over.
The first thing that you will need to download is a copy of SQLite here is the link to the one that I used(SQLiteStudio-3.2.1.zip (portable))
Generally the Sonarr DB file is located at: C:\ProgramData\Sonarr (Or you can find the path in Sonarr by going to System > Status > About
Once you have SQLite open you will be met with a screen similar to the one below. You will click to "Add a Database", and add the **COPY** of your sonarr.db file. The database should then show up in the list as it does in the image below, from there you will need to click on "Connect to the Database"
Now that you have the database added and connected you should see the same as the image below. I have highlighted the main areas that I had to go through to remove "Windows paths" to make it "Linux compatible" (Series, EpisodeFiles, ExtraFiles, SubtitleFiles, and RootFolders)
If you double click on any of the following Series, EpisodeFiles, ExtraFiles, SubtitleFiles, and RootFolders, you can see what is in the database for that section (This will be important for later). In the example below "Path" is the identifier in the table "Series" this is where you will see the path where all of your Sonarr shows are listed, and is what we will be modifying.
If you go to "Tools" at the top > "Open SQL editor" (ALT+E shortcut) you will see the following screen. The SQL editor is where we will be making most of the changes. I'd advise on scrolling through "Series" > "Path" to compare changes and see if anything was missed after running the command.
The command you will edit and run to change the path of where all shows are listed are as follows between START and END (Do not include the words START and END).
Replace the following sections as follows (the path typed out is case sensitve, and you may have to run this command with minor changes to get everything updated correctly:
\\169.254.0.1\Media\Download Complete\TV Shows\ - Both sections as listed below will need to be changed to the main location of all of your shows. You will edit the section in between the single quotes. Make sure you leave the \ at the end of your path.
%\\169.254.0.1\Media\Download Complete\TV Shows\% - You will replace all data in between the single quotes and % with your main location of all of your shows as you did in the step prior to this (both and %% are needed in this section.) Make sure you leave the \ at the end of your path.
/home/username/mnt/share/media/DownloadComplete/tv/shows/ - This section will be the new path where all of your shows will be listed after the migration. You will replace everything inside of the single quotes, but make sure you leave the / at the end.
---START---
update Series set Path = replace(Path, '\\169.254.0.1\Media\Download Complete\TV Shows\', '/home/username/mnt/share/media/DownloadComplete/tv/shows/')
where Path like '%\\169.254.0.1\Media\Download Complete\TV Shows\%'
---END---
So in this example, my shows were listed on a NAS device but this will be wherever your show paths are listed ie. C:\Users\USERNAME\Documents\... if storage is on the same device as Sonarr.
So in this example my path for shows was \\169.254.0.1\Media\Download Complete\TV Shows\Name Of Show
So what this command will do will replace \\169.254.0.1\Media\Download Complete\TV Shows\ to /home/username/mnt/share/media/DownloadComplete/tv/shows/
This will only replace up to Name of Show so the end result would be home/username/mnt/share/media/DownloadComplete/tv/shows/Name Of Show
The hard should be mostly over. Now we just have to clean up any Windows file path \'s to Linux file path /'s
You will clear out the code where you made the changes in the last step, and enter these one by one.
(NOTE) I did not include screenshots of this process as it is just a matter of running the commands one by one, then opening the EpisodeFiles Table, selecting Data, and seeing if there are any \'s listed in the data or if they have been changed to /'s (END NOTE)
---START---
update EpisodeFiles set RelativePath = replace(RelativePath, '\', '/')
update ExtraFiles set RelativePath = replace(RelativePath, '\', '/')
update SubtitleFiles set RelativePath = replace(RelativePath, '\', '/')
---END---
In my case Episodefiles, ExtraFiles, and SubtitleFiles the only changes I had to make was to replace \'s with /'s.
All that is left now is RootFolders which I just edited manually as I did not have many RootFolders.
To change the Path of RootFolders, you will right click and select "Edit value in editor" This you will just enter your new path. (be sure to include the / at the end of your path, as this will be needed for future shows added to Sonarr.))
Once you have made all of the changes you will click "Commit Changes" (the green checkbox)
Finally the end....
After you have finished your last changes and committed the changes, you are done, just click "Disconnect from this Database" (Unplug symbol next to where we connected to the Database)
Make sure Sonarr is not running on the Linux Machine prior to copying the Database over.
Then you just copy Sonarr.db to it's new home, and start Sonarr.
====
Accreditation
Walkthough Guide created and provided by Justin(BitHawkGaming) Update/change as needed
Custom Post Processing Scripts
If you’re looking to trigger a custom script in your download client to tell Sonarr when to update, you can find more details here. Scripts are added to Sonarr via the Connect Settings page.
Overview
Sonarr can execute a custom script when an episode is newly imported or renamed and depending on the action, different parameters are supplied. They are passed to the script through environment variables which allows for more flexibility in what is sent to the script and in no particular order.
Environment Variables
On Grab
| Environment Variable | Details |
|---|---|
| sonarr_eventtype | Grab |
| sonarr_series_id | Internal ID of the series |
| sonarr_series_title | Title of the series |
| sonarr_series_tvdbid | TVDB ID for the series |
| sonarr_series_tvmazeid | TVMaze ID for the series |
| sonarr_series_imdbid | IMDB ID for the series |
| sonarr_series_type | Type of the series, Anime, Daily or Standard |
| sonarr_release_episodecount | Number of episodes in the release |
| sonarr_release_seasonnumber | Season number from release |
| sonarr_release_episodenumbers | , separated list of episode numbers |
| sonarr_release_absoluteepisodenumbers | , separated list of absolute episode numbers |
| sonarr_release_episodeairdates | , separated list of Air date from original network |
| sonarr_release_episodeairdatesutc | , separated list of Air Date with Time in UTC |
| sonarr_release_episodetitles | | separated list of episode titles |
| sonarr_release_title | NZB/Torrent title |
| sonarr_release_indexer | Indexer where the release was grabbed |
| sonarr_release_size | Size of the release reported by the indexer |
| sonarr_release_quality | Quality name of the release as detected by Sonarr |
| sonarr_release_qualityversion | 1 is the default, 2 for proper, 3+ could be used for anime versions |
| sonarr_release_releasegroup | Release Group, will be empty if it is unknown |
| sonarr_download_client | download client, will be empty if it is unknown |
| sonarr_download_id | The hash of the torrent/NZB file downloaded (used to uniquely identify the download in the download client) |
On Download/On Upgrade
| Environment Variable | Details |
|---|---|
| sonarr_eventtype | Download |
| sonarr_isupgrade | True when an an existing file is upgraded, otherwise False
|
| sonarr_series_id | Internal ID of the series |
| sonarr_series_title | Title of the series |
| sonarr_series_path | Full path to the series |
| sonarr_series_tvdbid | TVDB ID for the series |
| sonarr_series_tvmazeid | TVMaze ID for the series |
| sonarr_series_imdbid | IMDB ID for the series, empty if not available |
| sonarr_series_type | Type of the series, Anime, Daily or Standard |
| sonarr_episodefile_id | Internal ID of the episode file |
| sonarr_episodefile_episodecount | Number of episodes in the file |
| sonarr_episodefile_relativepath | Path to the episode file relative to the series’ path |
| sonarr_episodefile_path | Full path to the episode file |
| sonarr_episodefile_episodeIDs | Internal ID(s) of the episode file |
| sonarr_episodefile_seasonnumber | Season number of episode file |
| sonarr_episodefile_episodenumbers | , separated list of episode numbers |
| sonarr_episodefile_episodeairdates | , seperated list of Air dates from original network |
| sonarr_episodefile_episodeairdatesutc | , seperated list of Air Date with Time in UTC |
| sonarr_episodefile_episodetitles | | separated list of episode titles |
| sonarr_episodefile_quality | Quality name of the Episode from Sonarr |
| sonarr_episodefile_qualityversion | 1 is the default, 2 for proper, 3+ could be used for anime versions |
| sonarr_episodefile_releasegroup | Release group, will be empty if unknown |
| sonarr_episodefile_scenename | Original release name, will be empty if unknown |
| sonarr_episodefile_sourcepath | Full path to the episode file that was imported from |
| sonarr_episodefile_sourcefolder | Full path to the folder the episode file was imported from |
| sonarr_download_client | download client, will be empty if it is unknown |
| sonarr_download_id | The hash of the torrent/NZB file downloaded (used to uniquely identify the download in the download client) |
| sonarr_deletedrelativepaths | | separated list of files that were deleted to import this file |
| sonarr_deletedpaths | | separated list of full paths for files that were deleted to import this file |
On Rename
| Environment Variable | Details |
|---|---|
| sonarr_eventtype | Rename |
| sonarr_series_id | Internal ID of the series |
| sonarr_series_title | Title of the series |
| sonarr_series_path | Full path to the series |
| sonarr_series_tvdbid | TVDB ID for the series |
| sonarr_series_tvmazeid | TVMaze ID for the series |
| sonarr_series_imdbid | IMDB ID for the series, empty if not available |
| sonarr_series_type | Type of the series, Anime, Daily or Standard |
On Delete Episode File
On Delete Series
| Environment Variable | Details |
|---|---|
| sonarr_eventtype | SeriesDeleted |
| sonarr_series_id | Internal ID of the series |
| sonarr_series_title | Title of the series |
| sonarr_series_path | Full path to the series |
| sonarr_series_tvdbid | TVDB ID for the series |
| sonarr_series_imdbid | IMDB ID for the series |
| sonarr_series_type | Type of the series, Anime, Daily or Standard |
| sonarr_series_deletedfiles | Boolean for if the files have actually been deleted or not |
On Test
When adding the script to Sonarr and run ‘Test’ the script will be invoked with the following parameters. The script should be able to gracefully ignore any other eventtype
| Environment Variable | Details |
|---|---|
| sonarr_eventtype | Test |
Arguments
(Warning: Adding arguments is no longer supported in Sonarr v3, point to the script directly.)
Additional command line line arguments that are passed to your script, such as running your script through cmd.exe you would set the path to cmd.exe and the arguments to /c C:\Path\to\script.bat.
Specific usage tips
PHP
The information from Sonarr will not be added to <math display="inline">_ENV as one might expect but should be included in the </math>_SERVER variable. A sample script to use this information to convert a file can be found here. PowerShell Sample script using the Sonarr environment variables to create EDL files for all episodes is here.
Reverse Symlinking For those moving from Medusa this seems to work well
