SqfliteDatabaseException DatabaseException(open_failed /var/mobile/Containers/Data/Application/.../Documents/database_name.db)

[amrLLSE]

I'm facing this on the latest version
SqfliteDatabaseException DatabaseException(open_failed/var/mobile/Containers/Data/Application/.../Documents/database_name.db)

[davidmartos96]

That can happen when you are providing the wrong password to an encrypted database. Are you opening a database bundled in the app assets or are you encrypting a fresh database?

[amrLLSE]

@davidmartos96 Fresh database, but I'm sure 100% that the password is correct. Now I'm also investigating in this and if I have reached to the root cause I will mention it here. But if you have any other ideas why this may happen just let me know.

[davidmartos96]

I would double check if you have sqlcipher correctly installed. You can open a memory database with sqflite without password and then run "PRAGMA cipher_version" on the database. You should see SQLCipher and the version number. If you don't, it means that something is not correctly configured

[amrLLSE]

@davidmartos96 Actually I have run "PRAGMA cipher_version" and it prints successfully "SQLCipher Version: 4.5.7 community".

[davidmartos96]

In that case I can only think the following:

• Password is incorrect
• The database was previously encrypted with SQLCipher 3.x, which is not directly compatible with 4.x

I'd try deleting the file in the device and try fresh with your latest code. Maybe it was previously encrypted with a different password.

You can also check the SQLCipher related tests (in the lib folder) in the example app in the repository

[amrLLSE]

@davidmartos96 Okay will check, but this plugin is always using 4x version and I didn't use anything else to open the database.

Thanks for you quick replies and support

[marijam26]

I'm encountering the same error.

[davidmartos96]

@marijam26 would you be able to create a reproduction demo app?

[amrLLSE]

@davidmartos96 Also still facing it, this is totally random so unfortunately I can't show a demo for it. Nearly I have tried everything to catch the scenario for this but as mentioned, it is random.

[nrsimha]

I have same issue.

Using this code:

        _db = await sqflite_cipher.openDatabase(
          filename,
          password: GDATABASE_PASSWORD,
        );

When running same Flutter app on Macos it runs properly I can open passworded sqlite file.

When running on Android with same code (same password) and same sqlite file it crashes on above function.

I/flutter (10789): DatabaseException(open_failed /file/path/to/sqlite/file)
Application finished.

[davidmartos96]

@nrsimha What iOS version has the device that fails?

[nrsimha]

@davidmartos96 It has not iOS version as it is Android 13 device. Didn't try on iOS yet.

[davidmartos96]

@nrsimha Sorry, I thought this was iOS only.

What do you get after running this? #99 (comment)

Without a reproduction example/project I cannot see what could be wrong.

[nrsimha]

What do you get after running this? #99 (comment)

Running on both Android and Macos I am getting this result:

SQLCipher is installed. Version: 4.5.7 community

I run this code to test it:

import 'package:sqflite_sqlcipher/sqflite.dart';

// Open an in-memory database (without encryption)
Database db = await openDatabase(':memory:');

// Run the PRAGMA cipher_version query
List<Map<String, dynamic>> result = await db.rawQuery(
  "PRAGMA cipher_version;",
);

// Close the database
await db.close();

// Print the result
if (result.isNotEmpty && result.first.containsKey('cipher_version')) {
  print(
    "SQLCipher is installed. Version: ${result.first['cipher_version']}",
  );
} else {
  print("SQLCipher is NOT installed or not configured correctly.");
}