SQLITE_NOTADB: Some Linux users cannot use SQLCIPHER

[MrPrimate]

Some linux users (notably fast moving distros like Arch and manjaro - @BenjaminPrice ) have reported the following error.

[2021-10-17 18:58:08.766] [error] Error: SQLITE_NOTADB: file is not a database
--> in Database#each('\n' +
  'SELECT ID as id, CobaltID as cobaltId, ParentID as parentId, Slug as slug, Title as title, RenderedHTML as html\n' +
  'FROM Content\n', [Function: rowGenerate], [AsyncFunction: collectionFinished])
    at Database.<anonymous> (/tmp/.mount_ddb-aduIneDx/resources/app.asar/munch/book.js:1506:8)
    at Object.getData (/tmp/.mount_ddb-aduIneDx/resources/app.asar/munch/book.js:1497:6)
    at /tmp/.mount_ddb-aduIneDx/resources/app.asar/main.js:232:14
    at runMicrotasks (<anonymous>)
    at processTicksAndRejections (internal/process/task_queues.js:93:5)
    

I believe this is due to journeyapps/node-sqlcipher#81, sqlcipher/sqlcipher#385 as GTK3 now bundles SQLite (https://gitlab.gnome.org/GNOME/tracker/-/issues/289) and this is used instead of the sqlcipher.

[MrPrimate]

Possible workaround: matrix-org/seshat#102 (comment)

[HLennart]

I have the problem on arch, installing sqlcipher and running the appimage via

LD_PRELOAD=/usr/lib/libsqlcipher.so ./ddb-adventure-muncher-0.4.5-linux-x86_64.AppImage

seems to solve it

[veedubb65]

I have the problem on arch, installing sqlcipher and running the appimage via

LD_PRELOAD=/usr/lib/libsqlcipher.so ./ddb-adventure-muncher-0.4.5-linux-x86_64.AppImage

seems to solve it

Nothing but issues on Ubuntu until I installed sqlcipher. Thank you!!!!!

[ArktinenSieni]

I have the problem on arch, installing sqlcipher and running the appimage via

LD_PRELOAD=/usr/lib/libsqlcipher.so ./ddb-adventure-muncher-0.4.5-linux-x86_64.AppImage

seems to solve it

Worked like a charm.

[Mojo9]

im not sure if I do something wrong but the workaround did not solve the error for me. im running on manjaro

[MrPrimate]

This should be resolved in v0.6.0