Merrrp

I just stumbled by this thread from Google fixing my own corrupt Plex DB on the binhex plexpass image. I thought I'd drop my findings here since I used this thread to solve my issue. My original error in the container logs for anyone searching for similar: Error: Unable to set up server: sqlite3_statement_backend::prepare: no such table: metadata_agent_providers for SQL: update metadata_agent_providers set online = 0 (N4soci10soci_errorE) I fixed my DB using the tool linked above by running the following commands from the container console: cd / pacman -S wget --noconfirm wget https://github.com/ChuckPa/PlexDBRepair/archive/refs/tags/v1.0.4.tar.gz tar xf v1.0.4.tar.gz rm v1.0.4.tar.gz cd PlexDBRepair-1.0.4 chmod +x DBRepair.sh ./DBRepair.sh Then running automatic repair when the tool's menu appears. You'll ideally need to have stopped Plex running somehow before running a repair, mine was stuck in a crash loop so I got it to run in between starts following a crash, and that apparently worked.

@writablevulture You're welcome, glad it helped! I've checked my configuration and I see the same paths showing in the SSMS server properties window, but when I check the contents of the paths I've configured I can see things appear to be going in the correct places on disk. After some digging I've realised I think it's just the naming of things being confusing. The two settings in the template are for the container paths whereas it sounds like you want to configure the server DB defaults within the container? If so I suspect what you want might be these docs: MSSQL_BACKUP_DIR Set the Default backup directory location. MSSQL_DATA_DIR Change the directory where the new SQL Server database data files (.mdf) are created. MSSQL_LOG_DIR Change the directory where the new SQL Server database log (.ldf) files are created. MSSQL_DUMP_DIR Change the directory where SQL Server will deposit the memory dumps and other troubleshooting files by default. It's a little while since I looked at this so I'll sort out updating my template in due course, hopefully it helps folks get started.

I've been attempting to set up MS SQL Server too, I seem to get it up and running fine pointing the paths at /mnt/cache etc. (I'm using my own template repo here if it helps anyone, I'd also welcome any feedback on cleaning that template up a bit). I haven't given it any serious work to do yet so I may still run in to more issues. The only issue I'm having currently is getting Unraid to detect available updates, I currently always get 'Not Available' - is anyone aware of a workaround for that other than an occasional force update? I'm guessing it's to do with MS using the mcr.* repo but I'm quite new to tinkering with Docker and these Unraid templates.