search

rieck / perplex

A Movie Renamer for Plex Metadata
39 stars 17 forks source link

Is this sill working? #6

Closed rikibez closed 1 year ago

rikibez commented 2 years ago

I've just tried it and I've got this error:

Analyzing Plex database: Traceback (most recent call last): File "./perplex.py", line 125, in movies = build_db(args.plex) File "./perplex.py", line 34, in build_db db = sqlite3.connect(dbfile) ValueError: database parameter must be string or APSW Connection object

So I guess if is this project still in place or not working with latest Plex DBs.

Thanks

rieck commented 2 years ago

Ouch. I haven't looked at the code in years. From your snippet, it looks like opening the database failed. I would guess that dbfile is None, which means that the database file was not found. The filename is com.plexapp.plugins.library.db. Maybe Plex changed the name ...

Best regards, Konrad

rikibez commented 2 years ago

Thanks for your reply.

I'm using Plex with docker and I suppose the issue would be the path "plex_dir" but I haven't found where is declared into your code.

I found the db here, with a lot more dbs:

@.:/opt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases$ ls -lhtotal 332M-rw-r--r-- 1 anatra anatra 356K May 4 11:13 com.plexapp.plugins.library.blobs.db-rw-r--r-- 1 anatra anatra 3.9M Apr 29 02:03 com.plexapp.plugins.library.blobs.db-2022-04-29-rw-r--r-- 1 anatra anatra 356K May 2 02:03 com.plexapp.plugins.library.blobs.db-2022-05-02-rw-r--r-- 1 anatra anatra 356K May 5 02:04 com.plexapp.plugins.library.blobs.db-2022-05-05-rw-r--r-- 1 anatra anatra 356K May 8 02:04 com.plexapp.plugins.library.blobs.db-2022-05-08-rw-r--r-- 1 anatra anatra 32K May 6 02:03 com.plexapp.plugins.library.blobs.db-shm-rw-r--r-- 1 anatra anatra 366K May 6 02:03 com.plexapp.plugins.library.blobs.db-wal-rw-r--r-- 1 anatra anatra 57M May 9 13:15 com.plexapp.plugins.library.db-rw-r--r-- 1 anatra anatra 55M Apr 29 02:03 com.plexapp.plugins.library.db-2022-04-29-rw-r--r-- 1 anatra anatra 50M May 2 02:03 com.plexapp.plugins.library.db-2022-05-02-rw-r--r-- 1 anatra anatra 52M May 5 02:04 com.plexapp.plugins.library.db-2022-05-05-rw-r--r-- 1 anatra anatra 57M May 8 02:04 com.plexapp.plugins.library.db-2022-05-08-rw-r--r-- 1 anatra anatra 416K May 9 13:20 com.plexapp.plugins.library.db-shm-rw-r--r-- 1 anatra anatra 53M May 9 13:20 com.plexapp.plugins.library.db-wal-rw-r--r-- 1 anatra anatra 276K May 4 11:13 com.plexapp.plugins.trakttv.db-rw-r--r-- 1 anatra anatra 32K May 9 03:00 com.plexapp.plugins.trakttv.db-shm-rw-r--r-- 1 anatra anatra 4.0M May 9 03:00 @.:/opt/plex/Library/Application Support/Plex Media Server/Plug-in Support/Databases$*

Regards, Riccardo

Il giorno lun 9 mag 2022 alle ore 10:06 Konrad Rieck < @.***> ha scritto:

Ouch. I haven't looked at the code in years. From your snippet, it looks like opening the database failed. I would guess that dbfile is None, which means that the database file was not found. The filename is com.plexapp.plugins.library.db. Maybe Plex changed the name ...

Best regards, Konrad

— Reply to this email directly, view it on GitHub https://github.com/rieck/perplex/issues/6#issuecomment-1120777366, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARALKVX4W5K6XHK3L3BFDDTVJDBQXANCNFSM5VMN7K6Q . You are receiving this because you authored the thread.Message ID: @.***>

rieck commented 2 years ago

Okay, let me try to give some tips (Disclaimer: I haven't looked at Plex for years!)

  1. I assume that one of the database files in your directory is the correct one. You could try adding a movie and see if the timestamp changes in the listing.

  2. If you found the right file, you can copy (not move) it to another directory and point my tool to this directory. Maybe you will have luck then.

Best regards, Konrad

rikibez commented 2 years ago

I'm sorry Konrad. I didn't reply to you.

I checked what you suggested and now I have another problem

Loading metadata from movies.dbTraceback (most recent call last): File "./perplex.py", line 129, in movies = json.load(gzip.open(args.load)) File "/usr/lib/python2.7/gzip.py", line 34, in open return GzipFile(filename, mode, compresslevel) File "/usr/lib/python2.7/gzip.py", line 94, in init fileobj = self.myfileobj = builtin.open(filename, mode or 'rb')IOError: [Errno 2] No such file or directory: 'movies.db'

I used this command: ./perplex.py --load movies.db --dest /mnt/remote/test --dry

Thanks Riccardo

Il giorno lun 9 mag 2022 alle ore 13:30 Konrad Rieck < @.***> ha scritto:

Okay, let me try to give some tips (Disclaimer: I haven't looked at Plex for years!)

1.

I assume that one of the database files in your directory is the correct one. You could try adding a movie and see if the timestamp changes in the listing. 2.

If you found the right file, you can copy (not move) it to another directory and point my tool to this directory. Maybe you will have luck then.

Best regards, Konrad

— Reply to this email directly, view it on GitHub https://github.com/rieck/perplex/issues/6#issuecomment-1120980459, or unsubscribe https://github.com/notifications/unsubscribe-auth/ARALKVQ3MNHXJWXWK5NXXXDVJDZO7ANCNFSM5VMN7K6Q . You are receiving this because you authored the thread.Message ID: @.***>

rieck commented 2 years ago

It looks like 'movies.db' has not been saved before. Did you run something like

./perplex.py --save movies.db --plex /tmp/copy-of-your-db-file-in-here/

Best regards, Konrad