Fri Nov 22, 2013 1:29 am by atc98092
First, you have to stop the Serviio process. This version of Derby is a single connection only, so if Serviio is running nothing else can connect to it. Next, you need a SQL client that supports Derby. I use squirrel SQL. They have instructions on their web site that explains how to configure Squirrel to connect to a Derby Embedded DB.
As to where the DB is located, I can only tell you where it is on my Windows Server. My guess is once you find the Serviio installation, the file structure should be the same. My Serviio in installed to the C:\Program Files\Serviio folder. The DB is under library\db. If your NAS runs some flavor of Linux, these paths are probably case sensitive. Since your Serviio is on a NAS, you need to be able to browse to the DB file location from the computer running the SQL client, via a mapped drive letter or UNC path. If your NAS doesn't share that path, you may have to create one.
Dan
LG NANO85 4K TV, Samsung JU7100 4K TV, Sony BDP-S3500, Sharp 4K Roku TV, Insignia Roku TV, Roku Ultra, Premiere and Stick, Nvidia Shield, Yamaha RX-V583 AVR.
Primary server: AMD Ryzen 5 5600GT, 32 gig ram, Windows 11 Pro, 22 TB hard drive space | Test server: Intel i5-6400, 16 gig ram, Windows 10 Pro
HOWTO: Enable debug logging HOWTO: Identify media file contents