search

devbean / QtCipherSqlitePlugin

A Qt plugin for cipher SQLite.
http://qtciphersqliteplugin.galaxyworld.org
GNU Lesser General Public License v2.1
380 stars 155 forks source link

Database encrypted by this plugin can't open by wxsqlite3_shell #34

Open trigchen opened 4 years ago

trigchen commented 4 years ago

Datbases: created with Qt 5.9.9 32bit + QtCipherSqlitePlugin 1.2, Cipher method: chacha20 , sqlcipher Password length: 5 database created and encrypted using the following source codes:


QSqlDatabase dbconn = QSqlDatabase::addDatabase("SQLITECIPHER");
dbconn.setDatabaseName("test.db");
dbconn.setPassword("12345");
dbconn.setConnectOptions("QSQLITE_USE_CIPHER=sqlcipher");
//dbconn.setConnectOptions("QSQLITE_USE_CIPHER=chacha20");
``

`
The generated test.db can't be open in wxsqlite3 shell (version: 4.0.4, 4.1.0, 4.5.1）
 [https://github.com/utelle/wxsqlite3/releases](https://github.com/utelle/wxsqlite3/releases) .
trigchen commented 4 years ago

Tried QtCipherSqlitePlugin release/v1.3 to encrypt test.db, then opened test.db with wxsqlite3_shell 4.5.1, failed with "Error: file is not a database". Cipher method: sqlcipher OS: Windows 10 Qt: 5.9.9, MinGW 32-bit