SQLCipher ported to Harbour (Windows)

Moderator: Rathinagiri

User avatar
Hazael
Posts: 109
Joined: Thu Jun 24, 2010 11:37 am
Location: France

Re: SQLCipher ported to Harbour (Windows)

Post 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.
Harbour | GTWVT | MingW | Visual Studio Code
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post 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;
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Hazael
Posts: 109
Joined: Thu Jun 24, 2010 11:37 am
Location: France

Re: SQLCipher ported to Harbour (Windows)

Post 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;
Harbour | GTWVT | MingW | Visual Studio Code
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: SQLCipher ported to Harbour (Windows)

Post 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.
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post 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;
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post 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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: SQLCipher ported to Harbour (Windows)

Post 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
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post 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.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
mol
Posts: 3720
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: SQLCipher ported to Harbour (Windows)

Post by mol »

I had a problem with SQLCipher and windows xp.
Is it working OK?
Can sb. test it?
User avatar
Hazael
Posts: 109
Joined: Thu Jun 24, 2010 11:37 am
Location: France

Re: SQLCipher ported to Harbour (Windows)

Post 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?
Harbour | GTWVT | MingW | Visual Studio Code
Post Reply