Add encryption support

Question

Add encryption support

Closed this issue 7 years ago · 18 comments

Can Orma get encryption support in the future?
Integrate protect can get best experience for Orma (such as Realm, that support encryption on low level)

Lib for sql encryption
https://github.com/sqlcipher/android-database-sqlcipher

Answer 1 · 2017-01-12T13:27:34.000Z

Currently I have no plan for encryption, but it might be in a future because the feature of changing SQLite engine is useful.

Answer 2 · 2017-05-08T19:35:11.000Z

any news on this? would be great

Answer 3 · 2017-05-08T19:36:17.000Z

does Android Orma use anything special/non standard? otherwise it should be easy to just switch to sqlcipher transparently

Answer 4 · 2017-05-09T00:08:39.000Z

@zoff99 Not in progress but if someone needs I'll start working for it.

Answer 5 · 2017-05-13T13:39:59.000Z

is this released already on maven? can i use it?

Answer 6 · 2017-05-14T04:10:26.000Z

@zoff99 Not yet. Wait a minute!

Answer 7 · 2017-05-15T01:41:05.000Z

Published Orma v5.0.0-rc1 to jcenter with encryption support, thanks to @k-kagurazaka (#402).

However, orma-encryption and orma-core are not linked to jcenter:

I have requested them to linked to jcenter, so it will be done in a day.

Answer 8 · 2017-05-15T04:12:34.000Z

Now they are linked and become available via jcenter().

Please give it a try and issue feedbacks if something's wrong.

Answer 9 · 2017-05-15T08:28:59.000Z

is there an example how to use this? it crashes on startup when i try it.

this works:

     OrmaDatabase.Builder builder = OrmaDatabase.builder(this);
     TrifaToxService.orma = builder.name(MAIN_DB_NAME).
       readOnMainThread(AccessThreadConstraint.WARNING).
       writeOnMainThread(AccessThreadConstraint.WARNING).
       build();

this crashes:

     OrmaDatabase.Builder builder = OrmaDatabase.builder(this);
     builder = builder.provider(new EncryptedDatabase.Provider("password"));
     TrifaToxService.orma = builder.name(MAIN_DB_NAME).
       readOnMainThread(AccessThreadConstraint.WARNING).
       writeOnMainThread(AccessThreadConstraint.WARNING).
       build();

Answer 10 · 2017-05-15T09:03:47.000Z

@zoff99
Do you have a pre-existing database?
There are no compatibility between encrypted and un-encrypted database, so SQLCipher throw an exception when it try to open un-encrypted (SQLite's) database.

If no, please create a new issue with stack trace.

Answer 11 · 2017-05-15T09:16:53.000Z

@k-kagurazaka no, cleared all data of the app.
is my syntax correct? do you have a working example?

Answer 12 · 2017-05-15T09:23:51.000Z

Example app of Orma already uses encryption in encrypted flavor and it works.

Answer 13 · 2017-05-15T12:43:12.000Z

@zoff99 It seems correct syntax.

Can you tell us more details?

Error messages including stacktraces
Android OS version

Answer 14 · 2017-05-15T12:44:48.000Z

both on android 6.0 and 7.1
error 14 can not open database ...

will post more details later. dont have them now

Answer 15 · 2017-05-15T13:52:26.000Z

Hmm... error 14 is a native error that occurred when SQLCipher failed to open database file.
Please check context.getDatabasePath(MAIN_DB_NAME) return a valid value.

Answer 16 · 2017-05-15T15:33:47.000Z

does it have to be a full pathname? strange that it works without encryption

Answer 17 · 2017-05-15T15:34:10.000Z

maybe sqlcipher native lib not loaded correctly?

Answer 18 · 2017-05-15T18:56:01.000Z

thanks seems to work now. for some reason i have to delete the DB first.
but the DB should be removed if i clear all app data.
well, ok :-)