Thank you so much for your quick reply, and my apologies for getting back to you so late after it.
I was super hopeful when you said it was that easy! I found the value and made the changes and then
make'd successfully! However, after then running
$ ./sqlcipher and
PRAGMA key=""; and then
$ .open Encrypted-DB-In-SQLCipher-Folder.db and
$ SELECT * FROM some_table I was greeted with
Error: file is not a database.
Am I building incorrectly? I removed the
-DCIPHER CLFAG when configuring, so the build process looked like:
$ ./configure --enable-tempstore=yes CFLAGS="-DSQLITE_HAS_CODEC" LDFLAGS="-lcrypto"
EDIT: I suppose maybe I need to specify the page size and # of KDF iterations now? The HMAC may have also changed, but I’m not sure which one to use.
EDIT2: I’ve tried to set the KDF iters, etc., but am still unable to open the DB. Am I doing it right?
$ PRAGMA key="some_key";
$ PRAGMA kdf_iter='64000'
$ PRAGMA cipher_page_size=1024
$ select * from widgets
I’ve also tried adding
$ PRAGMA cipher_use_hmac = OFF to no avail (but I think this is unnecessary). For reference, my settings in SQLiteStudio are below. I’ve tried digging through the source for SQLiteStudio to find out what they use for HMAC in this case but haven’t found anything helpful yet.