net.sqlcihper.database.SQLiteException:file is not a database:, while compiling:select count(*) from sqlite_master;

[mmoore]

@krishan_kumar_Varshn

Step 1: sqlite3_open
Step2 : sqlite3_exec(db, (const char*)“PRAGMA cipher_plaintext_header_size=32”, NULL, NULL, NULL)
Step 3: sqlite3_exec(db, (const char*) [@“databaseKey” UTF8String], NULL, NULL, NULL)
Step 4: sqlite3_exec(db, (const char*) “SELECT count(*) FROM sqlite_master;”, NULL, NULL, NULL)
Step 5: sqlite3_prepare_v2(db, “PRAGMA cipher_version;”, -1, &stmt, NULL)
Step 6: sqlite3_step(stmt)

You should be setting they key on the database (if it’s encrypted) prior to running any operations on it (i.e. cipher_plaintext_header_size).

Step 3: sqlite3_exec(db, (const char*) [@“databaseKey” UTF8String], NULL, NULL, NULL)

There are examples here of how to set the key, the syntax above doesn’t look like you’re using one of those (i.e. PRAGMA key = "x'2DD29CA851E7B56E4697B0E1F08507293D761A05CE4D1B628663F411A8086D99'";)

You may want to review the cipher_plaintext_header_size documentation. As noted there, the application is responsible for providing the salt as well when using cipher_plaintext_header.