3

Apologies if the solution is buried somewhere in another thread or post. I could not find anything specific to this. I’m getting [Error: file is not a database].

My scenario:

  • Downloaded sqlcipher to a PopOS installation. (3.15.2 //sqlcipher --version)
  • Was successful in creating a new encrypted database. Could open, close and see results.
  • Downloaded that database fie to MacOS (Catalina). (3.31.0 //sqlcipher --version)
  • I opened the database and entered the “PRAGMA key” statement as the first input. (Confirmation: “ok”.) However, anything I do after that results in [Error: file is not a database].

Is this different versions that is causing the issue?

Improve this question
1
  • FYI, you can get this if your encryption key doesn't match. Double check that to confirm first. Commented Jul 22, 2024 at 15:26

1 Answer 1

Reset to default
0

Had posted the above question at the following link as well: https://discuss.zetetic.net/t/error-file-is-not-a-database/4434 (copied the response below)

"This discussion forum post should point you in the correct direction: Upgrading to SQLCipher 4 1 (https://discuss.zetetic.net/t/upgrading-to-sqlcipher-4/3283). It sounds like your database was created using SQLCipher v3 and you’re attempting to open it using SQLCipher v4. To verify this assumption is correct, you can run PRAGMA cipher_version on each side."

The above was helpful to convert a 3.4 encrypted file into a 4.x version. However, to upgrade my Linux install to 4.x, these instructions were super helpful: https://github.com/sqlitebrowser/sqlitebrowser/wiki/SQLCipher:-Build-from-Source-on-Debian-Stretch---Newbie-Instructions

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.