Skip to content

Encrypted SQLite Database Cipher Issue in HeidiSQL #2079

@netinial

Description

@netinial

Description

I'm creating an encrypted SQLite database through HeidiSQL with the following credentials:

Cipher: aes256cbc
Key: x
However, regardless of the cipher I select, HeidiSQL always creates the database with the chacha20 cipher.
Running PRAGMA cipher; returns chacha20.

Additionally, when I try to connect to an AES-256-CBC encrypted database, I receive the error: "file is not a database".

It seems that the cipher dropdown menu is not functioning properly.

Image

Additionally, assuming it might be possible to change the cipher manually via the command line, I attempted the following command but was unsuccessful:

.\heidisql.exe -n=10 -l="sqlite3mc.dll" -h="C:\DB.Browser.for.SQLite-X.db" -u="sqlcipher" -p="d" -d="legacy=4;"

Could you please provide the correct way to connect to an encrypted SQLite database via the command line?

HeidiSQL version

HeidiSQL_12.10_64

Database server version

SQLite

Reproduction recipe

Open App
Create News Database
Select Cipher
Does not change anything

Error/Backtrace

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project membernettype-sqliteSQLite specific issue

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions