4.8.0.80 Bug: Library Folder Access Permissions Ignored

[pearmaster 1]

I'm still having the problem even after running the sql.  I'm currently running 4.8.7.0. This is what I did, with pictures to show exactly what I've tried.

I first ran the SQL.

sqlite> delete from ancestorids2 where AncestorId in (select id from mediaitems where type=4) and itemid <> AncestorId  ;
sqlite> select count(*) from ancestorids2 where AncestorId in (select id from mediaitems where type=4) and itemid <> AncestorId;
0
sqlite> 

Then I moved my files into a new directory (in case the database was keeping track of old paths)
Then I created a new library:

 

Then I added a new user with no access permissions:

 

Then I gave the new user access to only one of the folders:

 

 

But then when I look at the library as that user, I see content from both of the folders (including the /mnt/usbdisk2/media/discs/by-age/PG/14 folder).

Edited May 24, 2024 by pearmaster

[Luke 42077]

Hi @pearmasteryou don't need to be running that sql anymore. That was only for the initial 4.8 release. Can you please provide an example of what is showing that you think shouldn't? 

Thanks.

[Happy2Play 9780]

I think this issue is resolved in beta channel as I think the only current issue relates to multi-versioning across folders.  

 

Edited May 24, 2024 by Happy2Play

[pearmaster 1]

So you saw in my screenshots (that I posted previously) that my "Disks" library has 2 folders:

• /mnt/usbdisk2/media/discs/by-age/PG/9
• /mnt/usbdisk2/media/discs/by-age/PG/14

and that I've only granted the "Bobby" user access to /mnt/usbdisk2/media/discs/by-age/PG/9

However, when I'm browsing the "Disks" library as the "Bobby" user, I'm seeing movies from both directories:

 

My expectation is that "Dead Poets Society" and "Remains of the Day" would not show up because they are only in the "/mnt/usbdisk2/media/discs/by-age/PG/14" which is unchecked for the "Bobby" user.

And just to be extra verbose, here are the contents of those directories:

❯ ls /mnt/usbdisk2/media/discs/by-age/PG/9/  /mnt/usbdisk2/media/discs/by-age/PG/14/
/mnt/usbdisk2/media/discs/by-age/PG/14/:
'Dead Poets Society-clearlogo.png'  'Dead Poets Society.mkv'         'Remains of the Day.mkv'
'Dead Poets Society-fanart.jpg'     'Dead Poets Society-poster.jpg'  'Remains of the Day-poster.jpg'

/mnt/usbdisk2/media/discs/by-age/PG/9/:
'Finding Neverland.mkv'            'Star Wars Episode II Attack Of The Clones.mkv'
'Finding Neverland-poster.jpg'     'Star Wars Episode II Attack Of The Clones.nfo'
'Freaky Friday 2003.mkv'           'Star Wars Episode II Attack Of The Clones-poster.jpg'
'Freaky Friday 2003-poster.jpg'    'Star Wars Episode VI Return Of The Jedi.mkv'
'Its a Wonderful Life.mkv'         'Star Wars Episode VI Return Of The Jedi.nfo'
'Its a Wonderful Life.nfo'         'Star Wars Episode VI Return Of The Jedi-poster.jpg'
'Its a Wonderful Life-poster.jpg'  'White Fang.mkv'
'Short Circuit 2.mkv'              'White Fang-poster.jpg'
'Short Circuit 2-poster.jpg'

I'm happy to try out a beta version if we think it is fixed there.

[Happy2Play 9780]

6 minutes ago, pearmaster said:

I'm happy to try out a beta version if we think it is fixed there.

Unless there is a platform variable, I am not sure.  Personally, unless you wish to stay on beta cycle until released, I would wait.

But I am currently unable to reproduce a library folder access issue in 4.8.7.0 but am on a Windows install.

[pearmaster 1]

Hmm.  I did a fresh install on a different Linux computer and could not reproduce the issue.  I'll try a few more things on the install which is having problems to see if I can't figure out more about what is going on.  (I'm a software engineer by profession, so debugging issues comes natural).

I guess worst case is that I re-install (on my media server) and start fresh.

Edited May 26, 2024 by pearmaster

[pearmaster 1]

So one difference that I've noticed in the database in cases where things work correctly versus when they don't....

When things work correctly, the directories show up in the database with parent_id=1.

In cases where I see access issues, the directories show up in the database a parent_id pointing to the parent directory. 

I'm also noticing that directories that I've deleted and are not presently included in any library are still present in the database.  I've been running emby for several years now, so I'm wondering if the user access issues are because it is granting permissions based on parent directories, even though those parent directories are no longer directly part of a library.

[Luke 42077]

Quote

In cases where I see access issues, the directories show up in the database a parent_id pointing to the parent directory. 

Hi, what do you mean by this exactly? can you please give an example?