@philipag

What did you do?

If I create a DB with cipher_use_hmac = ON, DB Browser can open it fine, but with a DB with cipher_use_hmac = OFF, DB Browser just keeps on asking for the key/password.

What did you expect to see?

DB Browser should be able to open database files with cipher_use_hmac = OFF.

There are 3 options for supporting such database files:

1. If it fails to open it, DB Browser automatically tries to use the same key/password and add the cipher_use_hmac = OFF pragma and re-try.
2. There could be a checkbox to disable HMAC in the password/key dialog under the custom options.
3. There could be a text box for entering pragma commands which are executed before DB Browser sens the key to sqlcipher.

I think #2 is good since this option goes with the other "custom" options presented in the popup. Additionally, #3 is nice because it is generic and can be used for other things as well. So I think really both should be supported.

What did you see instead?

With cipher_use_hmac = OFF files, the "SQLCipher encryption" dialog just repeatedly pops up.

DB4S Version

3.13.1

What OS are you seeing the problem on?

Windows

OS version

Win 11

Relevant log output

Prevention against duplicate issues

• I have searched for similar issues