Unable to open SQLite Database from Windows on Ubuntu

Unable to open SQLite Database from Windows on Ubuntu

avatar

I have Remote Desktop Manager installed on a few Windows machines and working fine.

The database I use is SQLite and I have encryption enabled on it. I then sync this between my computers via Nextcloud.

I just moved one of my machines to Ubuntu 24.04, installed RDM and attempted to add my SQLite datatabase to it and got the following:

EntryPointNotFoundException - Unable to find entry point named 'sqlite3_key' in shared library 'SQLite.Interop.dll'.

Details:

   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_key(IntPtr db, Byte[] key, Int32 keylen)
   at System.Data.SQLite.SQLite3.SetPassword(Byte[] passwordBytes, Boolean asText)
   at System.Data.SQLite.SQLiteConnection.Open()
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.OpenConnection(IDbConnection dbConnection)
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteScalar[T](String sql, IDbDataParameter[] parameters)
   at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.GetConnectionCacheID()
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.HasSecurityChanged()
   at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.HasSecurityChanged(BaseConnectionDataSource dataSource)
   at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)



Some quick Googling leads me to believe the issue might be that the library used for SQLite on Linux doesn't support encryption?

All Comments (3)

avatar

Hello,

Thank you for reporting this issue.

Our developer will look at this problem and get back to you.

Thank you for being so patient.

Best regards,

Érica Poirier

avatar

Hello Eric,

Exactly. If your SQLite datasource was created before version 2022.2, it is using the platform-specific database encryption, and this encryption is not supported on Linux.

Can you please export your entries and then create a new SQLite datasource (you can set a master key). By default, the new one uses our new cross-platform encryption system and should work without issues with RDM Linux.

Let me know if that helps.

Regards,

Gabriel Dubois

avatar

Exported my database, created a new SQLite database, re-imported my database, sync'd it over Nextcloud, problem solved. Thanks!