LIST

helm plex-media-server

https://github.com/plexinc/pms-docker/tree/master/charts/plex-media-server ➜ helm git:(main) helm repo add plex https://raw.githubusercontent.com/plexinc/pms-docker/gh-pages "plex" already exists with the same configuration, skipping ➜ helm git:(main) helm show values plex/plex-media-server > values.yaml ➜ helm git:(main) helm upgrade --install plex plex/plex-media-server --values values.yaml Release "plex" does not exist. Installing it now. NAME: plex LAST DEPLOYED: Sat May 18 10:41:13 2024 NAMESPACE: default STATUS: deployed REVISION: 1 TEST SUITE: None NOTES: Thank you for installing plex-media-server. Your release is named plex....

May 18, 2024

plex server colima mount volume external drive

(new file) vi ~/.colima/_lima/_config/override.yaml """ mountType: 9p mounts: location: “/Users/tjen” writable: true 9p: securityModel: mapped-xattr cache: mmap location: “~” writable: true 9p: securityModel: mapped-xattr cache: mmap location: /tmp/colima writable: true 9p: securityModel: mapped-xattr cache: mmap location: /Volumes writable: true 9p: securityModel: mapped-xattr cache: mmap """ // don’t forget to replace tjen with your mac’s username // don’t copy the triple quotes === docker-compose.yml """ services: plex: image: lscr.io/linuxserver/plex:latest container_name: plex network_mode: host environment: - PUID=501 - PGID=20 - TZ=Etc/UTC - VERSION=docker...

May 7, 2024

plex server query database

cd “/Users/tjen/Library/Application Support/Plex Media Server/Plug-in Support/Databases” sqlite3 com.plexapp.plugins.library.db SELECT a.name AS “User”, pl.title AS “Playlist Name”, CAST(pqg.order / 1000 AS INT) AS “Order”, (CASE WHEN pqg.metadata_item_id IS NULL THEN “[Smart Playlist]” ELSE pl_items.title END) AS “Item” FROM metadata_items pl INNER JOIN play_queue_generators pqg ON pqg.playlist_id=pl.id LEFT JOIN metadata_items pl_items ON pl_items.id=pqg.metadata_item_id INNER JOIN metadata_item_accounts mia ON mia.metadata_item_id=pl.id INNER JOIN accounts a ON a.id=mia.account_id WHERE pl.metadata_type=15 ORDER BY a.name, pl.title, pqg.order ASC;...

May 7, 2024