Editing nzbdrone.db on Synology

Help & Support
1

Due to another program freaking out over spaces in directories, I moved /volume1/Shared Files/* to /volume1/Share/* on my Synology. Now, I’m having trouble with root folders which I believe is related to this issue: Helping with Sonarr on Synology: Root Issues

I believe I need to delete the old folders from the table mentioned in that thread, but I can’t work out how to edit the db. I’m trying “DiskStation> mysql -u root -p /usr/local/nzbdrone/var/.config/NzbDrone/nzbdrone.db” but get the error “ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)”, even after resetting the password via the mariaDB interface in DSM.

The db is write protected, when I try to change I get
chmod +w nzbdrone.db
chmod: nzbdrone.db: Operation not permitted

2

Sonarr doesn’t use mysql, it uses SQLite, so thats the first issue.
You should only resort to editing SQLite directly if you can’t access the list of root folders, are you not able to access them via the add existing series dialog?

3

If you mean the dialog in Series > Import existing series on disk, it doesn’t load a list of root folders, I just get the moving dots indefinitely. Trying to add the new path, I can browse as far as /volume1/Share but from there on it appears empty, despite the subfolders having full read permissions and belonging to the users group.

4

Yeah, thats the one I meant. In that case, what do the logs say? Depending on the error you may be able to fix it without editing the SQLite DB, but removing the RootFolders in the SQLite DB will solve it as well.

5

Okay, cleared logs, restarted and replicated the error, here’s what the logs show:

http://pastebin.com/8SfxS0RY

6

There are a few errors, which looks to be because some folder in this path /volume1/Shared Files/NZB Downloads/Parks.and.Recreation.S07E12E13.720p.HDTV.X264-DIMENSION.1/Parks.and.Recreation.S07E12E13.720p.HDTV.X264-DIMENSION.mkv doesn’t exist, the actual error is:

System.UnauthorizedAccessException: Access to the path "/volume1/Share" is denied.
at System.IO.Directory.GetFileSystemEntries (string,string,System.IO.FileAttributes,System.IO.FileAttributes) <0x00117>
at System.IO.Directory.GetDirectories (string,string) <0x0001b>
at System.IO.Directory.GetDirectories (string) <0x00017>
at NzbDrone.Common.Disk.DiskProviderBase.GetDirectories (string) <0x000f3>
at NzbDrone.Core.RootFolders.RootFolderService.GetUnmappedFolders (string) <0x001d0>
at NzbDrone.Core.RootFolders.RootFolderService.<AllWithUnmappedFolders>b__0 (NzbDrone.Core.RootFolders.RootFolder) <0x00097>
at System.Collections.Generic.List`1<NzbDrone.Core.RootFolders.RootFolder>.ForEach (System.Action`1<NzbDrone.Core.RootFolders.RootFolder>) <0x0004b>
at NzbDrone.Core.RootFolders.RootFolderService.AllWithUnmappedFolders () <0x000cf>
at NzbDrone.Api.NzbDroneRestModule`1<NzbDrone.Api.RootFolders.RootFolderResource>.ToListResource<NzbDrone.Core.RootFolders.RootFolder> (System.Func`1<System.Collections.Generic.IEnumerable`1<NzbDrone.Core.RootFolders.RootFolder>>) <0x0001e>
at NzbDrone.Api.RootFolders.RootFolderModule.GetRootFolders () <0x0006f>
at NzbDrone.Api.REST.RestModule`1<NzbDrone.Api.RootFolders.RootFolderResource>.<set_GetResourceAll>b__c (object) <0x0001a>
at (wrapper dynamic-method) object.CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,System.Func`2<object, object>,object) <0x000a0>
at Nancy.Routing.Route/<>c__DisplayClass4.<Wrap>b__3 (object,System.Threading.CancellationToken) <0x00137>

So Sonarr does not have read access to /volume1/Share

7

That’s just embarassing, I would have sworn I’d already checked the permissions but they were indeed incorrect. However, I’ve fixed them now but the issue persists; no directories deeper than Share are visible.

New log: http://pastebin.com/astHBaVB

Updated perms:

ls -la /volume1 | grep Share
drw-rw-rw- 9 root users 4096 Feb 25 20:41 Share

ls -la /volume1/Share | grep Video
drw-rw-rw- 6 admin users 4096 Feb 25 20:41 Video

8

Looks like imports are failing now, nothing about the root folders failing to load now.

Either the source or the destination path is unreachable by Sonarr, since the process is attempting to move the file, I suspect the destination.

Did you fix the paths for your series already?