Followed this very helpful thread on transferring my history from my old library (Mac OS) to my new one on a Raspberry Pi Transfer settings watched status added date etc from Windows Server to Linux?
However, when I try to import that settings.sql file into the target new database, I have a permissions issue. Essentially error messages like this:-
Error: near line 6415: attempt to write a readonly database
Indeed when I look at the permissions and owners of the settings.sql file versus the database, they are different owners.
-rw-r--r-- 1 plex plex 38094848 Feb 11 14:51 com.plexapp.plugins.library.db
-rw-r--r-- 1 plex plex 327680 Feb 11 15:02 com.plexapp.plugins.library.db-shm
-rw-r--r-- 1 plex plex 39091480 Feb 11 15:02 com.plexapp.plugins.library.db-wal
-rwxr-xr-x 1 root root 1213689 Feb 11 13:18 settings.sql
I’m logged in as user “pi” and running the commands using “sudo”.
I guess I need to run the commands as the “Plex” user but when I ran a simple test using the syntax I thought was correct for doing this, I get an error:-
$sudo su plex -c touch temp2
This account is currently not available.
Can someone guide me on how to resolve this?
Server Version#: 1.18.6.2368
