Migrating from Windows v4.x to Linux v5.x

[LeGrandZombie]

Just the database is fine.  I haven't tested it for a while so I'll give you more info tomorrow.

Martin

Great! Thanks Martin.

[mvallevand]

Ok a day late sorry.  Our first winter storm and planning for a lockdown got in the way.

To install this unzip the files in the NextPVR Install Directory.

To run this on on linux  assuming you are running with the deb installer

1.

sudo service nextvpvr-server stop

backup you npvr.db3 to safe location

sudo service nextvpvr-server start

2. run

Code:

sudo -u nextpvr /opt/dotnet/dotnet  /opt/nextpvr/system/NextImport.dll --merge  /pathto/anothernpvr.db3  /recordings

You can run this again for multiple folders.  You can omit the location (in this example /recordings) and it will prompt you to scan the whole drive.  You can run it multiple times on the same folder it won't re-add files.  

Since you are running as the nextpvr user this will only find files the servers can access.

3. If there are problem zip the logs and restor the backup database from step 1.

Martin

[LeGrandZombie]

Thanks Martin. No problem with the delay.

I extracted the files to /opt/nextpvr/system and got the attached error when I ran the import.

[LeGrandZombie]

For some reason the text file with the error won't upload

sudo -u nextpvr /opt/dotnet/dotnet /opt/nextpvr/system/NextImport.dll --merge /home/mw/Desktop/v4npvr.db3 /recordings
NEXTPVR_INSTALLDIR /opt/nextpvr/system/
NEXTPVR_DATADIR /opt/nextpvr/system/data/
NEXTPVR_DATADIR_USERDATA /var/opt/nextpvr/
/var/opt/nextpvr/
Unhandled exception. System.TypeInitializationException: The type initializer for 'Microsoft.Data.Sqlite.SqliteConnection' threw an exception.
---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.
---> System.DllNotFoundException: Unable to load shared library 'e_sqlite3' or one of its dependencies. In order to help diagnose loading problems, consider setting the LD_DEBUG environment variable: libe_sqlite3: cannot open shared object file: No such file or directory
at System.Runtime.InteropServices.NativeLibrary.LoadByName(String libraryName, QCallAssembly callingAssembly, Boolean hasDllImportSearchPathFlag, UInt32 dllImportSearchPathFlag, Boolean throwOnError)
at System.Runtime.InteropServices.NativeLibrary.LoadLibraryByName(String libraryName, Assembly assembly, Nullable`1 searchPath, Boolean throwOnError)
at System.Runtime.InteropServices.NativeLibrary.Load(String libraryName, Assembly assembly, Nullable`1 searchPath)
at SQLitePCL.NativeLibrary.Load(String libraryName, Assembly assy, Int32 flags)
at SQLitePCL.Batteries_V2.MakeDynamic(String name, Int32 flags)
at SQLitePCL.Batteries_V2.DoDynamic_cdecl(String name, Int32 flags)
at SQLitePCL.Batteries_V2.Init()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor, Boolean wrapExceptions)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)
at Microsoft.Data.Sqlite.Utilities.BundleInitializer.Initialize()
at Microsoft.Data.Sqlite.SqliteConnection..cctor()
--- End of inner exception stack trace ---
at Microsoft.Data.Sqlite.SqliteConnection..ctor(String connectionString)
at NUtility.DatabaseHelper.GetConnection()
at NextImport.Program.Main(String[] args)
Aborted

[sub]

For some reason the text file with the error won't upload

You need to zip any attachments for them to be accepted.

[mvallevand]

Sorry my mistake because I piggyback on sub's install I don't send a full package. On linux you also have to

cd /opt/nextpvr/system
sudo ln -s ./runtimes/linux-x64/native/libe_sqlite3.so

Martin

[LeGrandZombie]

Sorry my mistake because I piggyback on sub's install I don't send a full package.  On linux you also have to

cd /opt/nextpvr/system
sudo ln -s ./runtimes/linux-x64/native/libe_sqlite3.so

Martin

Fantastic Martin! Thanks for the effort doing this. So glad I can see everything together in one place now.

[LeGrandZombie]

For some reason the text file with the error won't upload

You need to zip any attachments for them to be accepted.

Sorry. I must have missed the warning. I think I used to know this.

[mvallevand]

Did the program work or are you trying to upload logs? If you just update the zipped NextPVR logs, NextImport.log is included.

Martin

[LeGrandZombie]

Did the program work or are you trying to upload logs?  If you just update the zipped NextPVR logs, NextImport.log is included.

Martin

That was from my first attempt to run the program. All clear on uploading now. The program ran perfectly after making the symbolic link to SQLlite. Thanks again. I never would have figured that out on my own.