Failed to setLocale() when constructing, closing the database net.sqlcipher.database.SQLiteException: file is encrypted or is not a database

sjanardhanan · February 5, 2016, 12:33am

I have a server that sends me a database with 1.x database. I am able to decrypt using 1.x SQLCipher. I would like to use the latest version of SQLCipher. Please let me know how can I decrypt a database which is created using 1.x SQLCipher. Any help will be grealty appreciated.

sjlombardo · February 5, 2016, 1:56pm

Hello @sjanardhanan - there are two options here:

use PRAGMA cipher_migrate to upgrade the database from 1.x to 3.x in place; org
use PRAGMA cipher_use_hmac = OFF in conjunction with PRAGMA kdf_iter = 4000 to open the database using the original SQLCipher 1.x security settings

sjanardhanan · February 5, 2016, 2:56pm

I am new in using SQLCipher. Could you be able to provide me statements in SQLitedatbaseHook so that I can understand. Your help is greatly appreciated.

sjlombardo · February 5, 2016, 4:42pm

Hello @sjanardhanan - here is a concise example from the SQLCipher for Android test application:

github.com

sqlcipher/sqlcipher-android-tests/blob/master/src/main/java/net/zetetic/tests/CipherMigrateTest.java

package net.zetetic.tests;

import android.util.Log;
import net.sqlcipher.database.SQLiteDatabase;
import net.sqlcipher.database.SQLiteDatabaseHook;
import net.zetetic.QueryHelper;
import net.zetetic.ZeteticApplication;

import java.io.File;

public class CipherMigrateTest extends SQLCipherTest {

    File olderFormatDatabase = ZeteticApplication.getInstance().getDatabasePath("2x.db");

    @Override
    public boolean execute(SQLiteDatabase database) {
        database.close();
        final boolean[] status = {false};
        try {
            ZeteticApplication.getInstance().extractAssetToDatabaseDirectory("2x.db");

This file has been truncated. show original

sjanardhanan · February 5, 2016, 4:54pm

Thanks a lot. I found the same example and it worked… thanks a ton

sjanardhanan · February 5, 2016, 4:55pm

One more small question. Will there be slowness due to migration? Does this migration happen everytime or only oncce?

sjlombardo · February 5, 2016, 10:29pm

Hello @sjanardhanan - yes, there is a definite performance impact from the migration. it would be best to track whether the database has been upgraded separately, i.e. in an application preference or something, so that you can selectively run the migration only when necessary.

sjanardhanan · February 10, 2016, 12:31am

HI,

I have another database that needs to be migrated and attached to main database ( both are encrypted). Please let me know if there is a solution for the same

developernotes · February 10, 2016, 2:14pm

Hello @sjanardhanan

You will want to apply the same approach for migrating your database using the PRAGMA cipher_migrate command.

Topic		Replies	Views
CREATE TABLE android_metadata failed ; Failed to setLocale() when constructing, closing the database E/Database ; net.sqlcipher.database.SQLiteException: file is encrypted or is not a database Issues	5	3060	June 3, 2015
Use 'net.zetetic:android-database-sqlcipher:3.5.6@aar' open 1x.db SQLCipher	10	1507	March 21, 2017
File is encrypted or is not a database after upgrade SQLCipher from v.2.2.2.0 to v.3.1.0 SQLCipher	3	7512	July 25, 2016
Net.sqlcipher.database.SQLiteException: file is encrypted or is not a database: create locale table failed in Android SQLCipher	5	3034	March 4, 2016
Upgrading Sqlcipher for Android from 3 to 4 Issues	6	4580	October 7, 2020

Failed to setLocale() when constructing, closing the database net.sqlcipher.database.SQLiteException: file is encrypted or is not a database

Related topics