I’m using SQLCipher 3.4.0 to encrypt a database file that’s in WAL journal_mode. It seems that the .wal and .shm files are not being encrypted along with the database file itself. When I open the database file up after calling SELECT sqlcipher_export(‘rekeyed_db’), I get a ‘disk image malformed’. But if I simply delete the .shm and .wal files, I can open the database file up again and it seems like it’s properly encrypted. This issue does not occur when using DELETE journal_mode.
Is this a known issue with 3.4.0?
I am also doing all this encrypting and decrypting using Couchbase Lite, so I’ve also posted on their forum to see if it’s a bug in their code. However, I looked at their source code and it seems to be doing it correctly with the sqlcipher_export() call.