Page 2 of 2

Re: Fully encrypted SQLite DB with PB 5.71 and SQLCipher.dll

Posted: Mon Jan 04, 2021 5:34 pm
by infratec
loulou2522 wrote: HI Infratec,
Can you explain me what runtime is ? and the utility to decode password in runtime ? Thanks in advance
This means only that you can use an InputRequester() or a StringGadget() to enter the password.

If you don't know the password, you have not really a chance to open the database.

Re: Fully encrypted SQLite DB with PB 5.71 and SQLCipher.dll

Posted: Wed Jan 06, 2021 12:45 pm
by MarkOtt
Yuri_D wrote:Hello!

I'm not sure what's wrong but when I'm trying to use this solution I'm getting an error on OpenDatabase() command (PB v5.72):

[16:55:33] [ERROR] UseODBCDatabase(), UseSQLiteDatase() or UsePostgreSQLDatabase() need to be called before using database commands.

Did anybody try it on later PB releases?
@Yuri_D
@totorcalais

Tested and working on PB 5.73 x32 and x64.

But, with PB x64 also the 64bit version of "sqlcipher.dll" is needed. ;-)
Eg. contained in the "DB Browser for SQLite for 64bit Windows".

Furthermore:
In the current version 3.12.1 of "DB Browser for SQLite" the version of "sqlcipher.dll" has changed to 3.31.0.0 which additionally needs the lib "libcrypto-1_1.dll" (additional 3 MB).

My original test was done with version 3.27.2.0 of "sqlcipher.dll" (eg. included in "DB Browser for SQLite" version 3.11.2), which did not need this additional lib yet.

Regards. Markus

Re: Fully encrypted SQLite DB with PB 5.71 and SQLCipher.dll

Posted: Wed Jan 06, 2021 1:50 pm
by loulou2522
MarkOtt wrote:
Yuri_D wrote:Hello!

I'm not sure what's wrong but when I'm trying to use this solution I'm getting an error on OpenDatabase() command (PB v5.72):

[16:55:33] [ERROR] UseODBCDatabase(), UseSQLiteDatase() or UsePostgreSQLDatabase() need to be called before using database commands.

Did anybody try it on later PB releases?
@Yuri_D
@totorcalais

Tested and working on PB 5.73 x32 and x64.

But, with PB x64 also the 64bit version of "sqlcipher.dll" is needed. ;-)
Eg. contained in the "DB Browser for SQLite for 64bit Windows".

Furthermore:
In the current version 3.12.1 of "DB Browser for SQLite" the version of "sqlcipher.dll" has changed to 3.31.0.0 which additionally needs the lib "libcrypto-1_1.dll" (additional 3 MB).

My original test was done with version 3.27.2.0 of "sqlcipher.dll" (eg. included in "DB Browser for SQLite" version 3.11.2), which did not need this additional lib yet.

Regards. Markott
Hi Markus
Did you know how to decipher a sqlite database when you know the password
THanks

Re: Fully encrypted SQLite DB with PB 5.71 and SQLCipher.dll

Posted: Wed Jan 06, 2021 2:27 pm
by MarkOtt
loulou2522 wrote: Hi Markus
Did you know how to decipher a sqlite database when you know the password
THanks
@loulou2522

You can open and read the database as shown in the program in the first post, then store it unciphered again.

Alternatively you can use the mentioned "DB Browser for SQLite", it is free to use.
https://sqlitebrowser.org/

Regards. Markus