Page 10 of 11

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 10:25 am
by Hazael
You are probably right...
Maybe we could do a test. If you agee, right?
Do you have a very small program that uses SQLCipher and it's encrypted database (small also)?
Maybe you could send it to me as a ZIP (do not send the source code).
I will try to open it, if it's possible, of course. I am not a cracker but I will try what I know...
Obviously you shouldn't tell me the KEY since it's a test.

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 11:17 am
by Rathinagiri
You can download an exe file and a sqlite encrypted file. Actually this exe is used to encrypt/decrypt the sqlite database with appropriate password. Source code is elsewhere in this forum. However try to breach this database and findout the key. :)

encrypted.zip" onclick="window.open(this.href);return false;

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 12:03 pm
by Hazael
Thanks for sending the example.
Now I can confirm that it's not possible to open the database without knowing the KEY.
My flaw methods didn't work...
So it's pretty secure at this point: http://zetetic.net/blog/2012/3/16/elcom ... edown.html" onclick="window.open(this.href);return false;

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 1:21 pm
by Amarante
Excuse my ignorance, but from what I understand, this Lib encrypt a SQLite database.
Is there any example of using the lib SQLCipher? Can teach me how to use HMG?
Thanks in advance for your attention.

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 3:07 pm
by Rathinagiri
Here you can find out the source code for the above encrypt utility. With this utility you can encrypt/decrypt a SQLite database. This can also be used as a sample for creating/using/encrypting a SQLite database.

http://hmgforum.com/viewtopic.php?p=21952#p21952" onclick="window.open(this.href);return false;

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 3:11 pm
by Rathinagiri
Thank you Qatan.

That is what makes SQLCipher an unique one. Open source, highest possible security, simple DBMS and most of all easily accessible/managed from HMG.

All my clients are so happy that their databases are highly secured.

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 3:57 pm
by Amarante
Rathinagiri wrote:Here you can find out the source code for the above encrypt utility. With this utility you can encrypt/decrypt a SQLite database. This can also be used as a sample for creating/using/encrypting a SQLite database.

http://hmgforum.com/viewtopic.php?p=21952#p21952" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;
Thank you my friend. :P

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 4:20 pm
by Rathinagiri
Usage of encryption is very simple and easy in the case of SQLCipher.

Once you connect to the database (just like ordinary database), you have to give the following query

Code: Select all

pragma key = 'Password'
If the password is right, you can operate the database... All the data tables are encrypted on the fly. Unencrypted data is never written to the disk! So, if you forgot the password, you can't retrieve.

Re: SQLCipher ported to Harbour (Windows)

Posted: Wed Aug 13, 2014 7:44 pm
by mol
I had a problem with SQLCipher and windows xp.
Is it working OK?
Can sb. test it?

Re: SQLCipher ported to Harbour (Windows)

Posted: Thu Jul 23, 2015 1:41 pm
by Hazael
mol wrote:I had a problem with SQLCipher and windows xp.
Is it working OK?
Can sb. test it?
What problem did you have? Any message? Simply didn't work?