Admin locked out

[IndianaLarry]

Do you have any other accounts on the setup that you can log into? I ran into this problem when I migrated my setup, and solved it by editing the database to give one of my other users admin privileges and utilizing that to fix things. It required some SQL, but it got me back in.

Specifically, I got into the data/jellyfin.db file, and ran the following:

Code:

update permissions set value = 1 where kind = 0;

What this did is find all AdminUser permission records (kind = 0, as per the source code) and set the value to 1, making all users admins. I then used the UI to revoke this once I got everything fixed.

If you want to limit which users you make an administrator, you can find the user ID and limit by that. For example, by running:

Code:

select id, username from users;

You can get all user IDs:

Code:

Id|Username
2E5D96A1-16C7-4DFE-ACCB-CC4A61CA9DDE|larry
1657A98C-3C21-4873-8BEE-37C6D3D34D27|bob
CEBDB97C-7205-49BB-80A8-F19351AE1B3E|junior
00B3D1B5-BDC0-4447-A7B9-007960DEEF0D|guest

You can then run the first query with the additional filter of the user ID. For example, to make just "guest" the admin:

Code:

update permissions set value = 1 where kind = 0 and userid = '00B3D1B5-BDC0-4447-A7B9-007960DEEF0D';

More details can be found in Jellyfin's Troubleshooting documentation. Note that I recommend stopping the server entirely before you edit the jellyfin.db file.