Server Version#: 1.23.2.4656-85f0adf5b The new Plex SQLite utility fails on a TrueNAS-12.0-U4 system, in a 12.2, 11.4, or 11.2 jail. root@plex:/usr/local/share/plexmediaserver # ./Plex\ SQLite /path/to/com.plexapp.plugins.library.db Initial sysctl failed: 22 18232 Plex SQLite CALL __sysctl(0x10…

Nice, and thanks much for the assistance with this! We’ll get this fix pushed out in an upcoming PMS release. Some random extra facts: Plex SQLite is really just a helper stub that re-execs Plex Media Server with the same argv it was passed. The PMS code that checks for the --sqlite argument in arg…

You might need to export LD_LIBRARY_PATH, but unsure if it’s enough, it. might not be properly built for FreeBSD too. Usually I just install sqlite locally if I need it

Thanks! LD_LIBRARY_PATH doesn’t change anything. I should have mentioned that ./Plex\ Media\ Server --sqlite works. I’m not having an actual problem. I saw Plex SQLite mentioned in another thread, and was nosing around. It looks like a wrapper utility anyway? I figure the “How to Repair a Corrupt …

I just noticed that the Repair a Corrupted Database documentation has been updated. (Yay!) For anybody searching - as of 1.23.3, the issue with Plex\ SQLite still exists on FreeBSD (or TrueNAS). ./Plex\ Media\ Server --sqlite works fine as an alternative.

[image] Volts: Server Version#: 1.23.2.4656-85f0adf5b The new Plex SQLite utility fails on a TrueNAS-12.0-U4 system, in a 12.2, 11.4, or 11.2 jail. root@plex:/usr/local/share/plexmediaserver # ./Plex\ SQLite /path/to/com.plexapp.plugins.library.db Initial sysctl failed: 22 18232 Plex SQLite …

It changes the error, does that count? :slight_smile: root@plex:/usr/local/src/PlexMediaServer-1.23.5.4701-aca01509d # ktrace ./Plex\ SQLite Final sysctl failed: 12 root@plex:/usr/local/src/PlexMediaServer-1.23.5.4701-aca01509d # kdump | tail -n 15 34310 Plex SQLite RET mmap 34389278720/0x801c2c…

[image] Volts: It changes the error, does that count? :slight_smile: Yes! That’s progress! Try this one .

root@plex:/usr/local/src/PlexMediaServer-1.23.5.4702-efe9a58fb # ./Plex\ SQLite SQLite version 3.35.5 2021-04-19 18:32:05 Enter ".help" for usage hints. Connected to a transient in-memory database. Use ".open FILENAME" to reopen on a persistent database. sqlite> .open /tmp/com.plexapp.plugins.librar…

That’s clever, and thanks for sharing the details!

`Plex SQLite` utility on FreeBSD fails

Plex Media Server

Volts July 6, 2021, 3:14pm 11

Resolved in 1.23.4.4712.

Plex Media Server - #441 by janoskk

Thanks!

Topic		Replies	Views
Using Plex SQLite on FreeBSD Plex Media Server server-truenas	7	178	August 22, 2022
Unable to open Database Dev/API Corner other-dev	10	908	July 10, 2014
New install in TrueNAS jail. plexmediaserver service unable to start Plex Media Server server-truenas	10	266	February 11, 2025
Update database: "Result: unknown tokenizer: collating" Plex Media Server server-terramaster	5	1381	August 2, 2021
Tried running "PLEX SQLite.exe" "PRAGMA integrity_check" Plex Media Server server-windows	1	130	October 4, 2021

`Plex SQLite` utility on FreeBSD fails

Related topics