SQLCipher Loadlibs and db password change

Question

SQLCipher website mentions

"Init the database in onCreate() using SQLiteDatabase.loadLibs(this); //first init the db libraries with the context"

I am calling this loadlibs only once in my first activity (seems to be working). I want to make sure I do not need to call this function for every activity that might access the database. Is this correct?
How do I change the database password? I tried rekey but that does not work. It still takes the old password.

Any help would be appreciated.

Thank you.

boiledwater · Accepted Answer · 2014-10-10 05:57:45Z

6

SQLiteDatabase.rawExecSQL("PRAGMA key = 'old_password';");
SQLiteDatabase.rawExecSQL("PRAGMA rekey = 'new_password';");

answered Oct 10, 2014 at 5:57

boiledwater

10.5k4 gold badges39 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nick Parker · Accepted Answer · 2012-10-16 12:47:36Z

4

Yes, that is correct - you only need to call SQLiteDatabase.loadLibs(...); once as that is responsible for loading the various native libraries SQLCipher for Android uses at runtime into the process. To change the password, you must first have a reference to a SQLiteDatabase object where you have provided the original password. Once you have that you can issue PRAGMA rekey = 'some new password'; using execSQL(...);. More information regarding the rekey command can be found here.

answered Oct 16, 2012 at 12:47

Nick Parker

1,3881 gold badge7 silver badges10 bronze badges

1 Comment

Michael Over a year ago

Are there any circumstances in which it would hurt anything to call SQLiteDatabase.loadLibs more than once?

Collectives™ on Stack Overflow

SQLCipher Loadlibs and db password change

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related