Admin accounts cannot log in, despite SQL edit

[loopy]

Hi everyone,

tl;dr Jellyfin on Yunohost shows does not have admin dashboard, and will only show “you are not authorized” on admin login after changing jellyfin.db to 1s for Permissions. 

I have Jellyfin installed on a Yunohost server, installed on a Raspberry Pi 4 (8GB RAM). I had Jellyfin successfully working, but Yunohost recommended the upgrade to Jellyfin 10.11.10. I followed the instructions and upgraded to 10.10.7 first, and then to 10.11.10. After a few hiccups, Jellyfin was working successfully again. I decided to try a plugin for OpenSubtitles, and I’m not sure if this is related, but Jellyfin was not loading after that. After troubleshooting many things, one user said uninstalling and reinstalling worked for them, so I did and chose the option for “remove associated files,” as I had not added any myself and thought it could hell with a “fresh install.” 

So I uninstalled and reinstalled, and Jellyfin was connecting and allowing logins. The main issue was then that no admin accounts for Jellyfin were allowed. First it was “unable to connect to server.” So I checked the jellyfin.db file and my admin account showed a “0” for admin access. So I updated that while Jellyfin was stopped and rebooted Jellyfin. Admin account still says “account not allowed.” Checked the Yunohost logs, and it shows “account disabled,” I’m guessing from the attempted logins. So I stopped Jellyfin again and updated the Jellyfin.db value for InvalidAttemptCount (name might be different), and set it back to 0. Still saying account not allowed. 

Then I tried changing the Yunohost settings for Jellyfin to allow All_users, visitors, and the specific usernames for admin access, just to try. I can still log in just fine with regular accounts, but not admin accounts. I created a new admin account, same result. I at one point was able to log into my admin account, but neither my main admin nor the newly created one has the admin dashboard. 

In desperation, I stopped Jellyfin, uninstalled it, and manually deleted the app, db, and backup file via ssh. I was able to reinstall just fine but still at the point of getting the “you are not authorized” with an admin account, even after changing the SQL file to 1 for all 23 items on the Permissions. 

I’m pretty desperate and ready to wipe my Yunohost and start all over. Any ideas or leads for me? I’m very new to Linux, but I’m trying to learn as I go.

[TheDreadPirate]

Why do they disable admin accounts by default, wtf?

Also make sure you clear our browser cache between reinstalls.

Otherwise, not sure how to help you since Yunohost is modifying Jellyfin. This is not the default behavior.

[loopy]

I’ll try clearing cache between installs.

I’m not really sure what to make of the admin access. Yunohost shows my admin user as the admin account for Jellyfin, and in permissions has the user specifically for “Jellyfin (admin)”. I also tried enabling the regular “Jellyfin” access in addition to the Jellyfin (admin), but I think that’s when I could successfully log in but did not have the Jellyfin dashboard.

Defaults aside, shouldn’t the access be fixed when I manually switch the /home/yunohost.app/jellyfin/data/jellyfin.db? I used:

BEGIN TRANSACTION;
UPDATE Permissions
SET Value = 1
WHERE UserId = ‘myadminuserid’;
COMMIT;

And I would check it:

SELECT Id, Username FROM Users WHERE Username = ‘myadminusername’;

It would show all “1”s in the sixth column, so it looks like it worked. But then I start Jellyfin and it tells me “you are not authorized” only for the admin account. Am I missing something? Would it be easier to start from scratch and install Jellyfin 10.11.10 from the beginning? I can’t help but think the update or plug install contributed.

[TheDreadPirate]

Without knowing what all Yunohost has done, I can't recommend anything besides starting over. I vaguely recall another Yunohost user had this issue a year or two ago, but I can't remember what their solution was.

[loopy]

I ended up reinstalling Yunohost from scratch and reinstalling Jellyfin to the latest version. It’s been a few weeks now and the permissions issue on Yunohost seem to be resolved.

I’m feverishly trying to learn Docker, because it seems to be much more controlled, once a person gets through the initial learning curve. For now, Yunohost works and I’m making backups before I upgrade the OS, so I can at least roll back if I need to.