Is there a way to grant a different account the owner role in Overseer to match the new owner account of my plex server, or do i have to rebuild overseer from scratch? Since i moved my server claim to a new plex account, Overseer stopped working.
#Changed ownership of my plex to a new account, how do i change the overseer owner role?
pallid sapphire
pallid sapphire
Disregard, found the answer here: https://github.com/sct/overseerr/discussions/3066
- open the docker container's console in sh
- install sqlite with
apk add sqlite - connect to the database with
sqlite3 /app/config/db/db.sqlite3 - list the users with
SELECT * FROM user; - The owner is always ID 1, so change the owner to a number that isn't in use (I had 7 users)
UPDATE "user" SET id = 8 WHERE id = 1; - Change the intended user to the owner (in my case it was user 7)
UPDATE "user" SET id = 1 WHERE id = 7; - Bump the previous owner's ID back down (probably not strictly necessary)
UPDATE "user" SET id = 7 WHERE id = 8;
The drawback of this is that all of the request history stays with the ID, not the actual account. So the new owner now has all the previous owner's history and vice versa.