Playlist import AND/OR Database access issue

General Discussions
1

My issue: When I attempt to open the plex db file in DB Browser for SQ Lite I get the error “Invalid File Format”

which I need to do because…

I need to find the account_id of my different users

which I need because…

I am manually importing playlists using the playlist importer tool located here -> https://github.com/dakusan/PlexPlaylistImporter

which I need to do because…

I moved my plex install from a windows machine to an ubuntu server and plex has no clean way to export and import playlists.

I’ve used this tool on a my windows machine before and I was able to open the db to find the account_id without issue. I’m not sure why I am having an issue here. The plex server appears to be running fine otherwise.

Any advice on:

  1. How to deal with the database error I am receiving
  2. -OR- An alternate method to find the account_id
  3. -OR- An alternate method to import playlists

Thanks

2

I’m still not sure why I cannot open the database file, but I was able to solve my problem in another manner. Apparently, the “Plex Media Server.log” file contains authentication details, such as “DEBUG - Auth: authenticated user XXXXXX as Username”. I was able to find the account_id via this log.

3

I’m not sure about that tool, but are you sure you were opening the DB file and not one of the -wal or -shm files?