search

utelle / SQLite3MultipleCiphers

SQLite3 encryption extension with support for multiple ciphers
https://utelle.github.io/SQLite3MultipleCiphers/
MIT License
410 stars 76 forks source link

Compatibility with SQLeet #113

Closed johnfound closed 1 year ago

johnfound commented 1 year ago

I have tried to encrypt a database with SQLite3MC and then decrypt it with SQLeet, but failed.

Tried to read the docs on https://utelle.github.io/SQLite3MultipleCiphers/, but well, they are not very detailed in this very issue.

So, is it possible to configure SQLite3MC to be compatible with the SQLeet format? What options should be set and how?

utelle commented 1 year ago

I have tried to encrypt a database with SQLite3MC and then decrypt it with SQLeet, but failed.

I assume you mean with decrypt with SQLeet that you used the original SQLeet library to decrypt the database file you encrypted with SQLite3MC.

That you failed is actually not surprising. By default SQLite3MC uses the so-called non-legacy mode to encrypt/decrypt database files unless told otherwise, but the original SQLeet library operates in legacy mode. So, you have to tell SQLite3MC that it should use legacy mode, too.

Tried to read the docs on https://utelle.github.io/SQLite3MultipleCiphers/, but well, they are not very detailed in this very issue.

The SQLite3MC documentation has a complete chapter about legacy modes which explains in detail the differences between legacy modes and non-legacy modes.

So, is it possible to configure SQLite3MC to be compatible with the SQLeet format? What options should be set and how?

Yes, of course it is possible to configure SQLite3MC to be compatible with other legacy encryption schemes like SQLeet. Simply use PRAGMA legacy=1; in SQLite3MC to activate legacy mode.

johnfound commented 1 year ago

Thanks. The keyword here was "legacy", while I have searched for "compatibility" or like. Now everything is clear.