Linux hosted Bazarr working with Windows hosted Radarr fails as a result of path separator issue between disparate environments

[LesKent]

Describe the bug I've had Windows based Radarr and Bazarr working for a long time with no issues. I'm in the process of migrating everything to Linux. I setup a new Bazarr server running under Linux to work with the existing Windows Radarr server. After getting it all configured it would synchronize with Radarr correctly but would not download any subtitles. Digging into the logs and database I was able to determine the issue is with how Windows uses '\' for the path separator and Linux using a '/'.

On Windows the path to the NAS media is : \\xxxx\movies On Linux the path to the NAS media is: /mnt/xxxx/movies

Path mapping configuration was setup in Bazarr to map Windows Radarr '\\xxxx\movies' to Linux Bazarr '/mnt/xxxx/movies" and this appeared to work correctly for scanning the disk and probing files.

An example key debug debug error, Bazarr would log during subtitle update process: bazarr.log.2024-06-25:2024-06-25 02:58:28|DEBUG |root |BAZARR no media with this path have been found in database: \\xxxx\movies\Embryo (1976)\Embryo (1976) - [WEBDL-720P][AAC 2.0][X264][imdbid=tt0074475].mkv

Yet the Path field in the table_movies table for this item has: '\\xxxx\movies\Embryo (1976)/Embryo (1976) - [WEBDL-720P][AAC 2.0][X264][imdbid=tt0074475].mkv'

Where the path separator between the directory and filename is a '/' failing to match the Windows path with the '\' separator.

Software (please complete the following information):

• Bazarr: 1.4.3
• Radarr version 5.7.0.8882
• OS: Windows Server 2019, Ubuntu 23.10