sqlcipher_page_cipher aftre sqlite3_key()... with includet sqlite3 sqlcipher

Question

I integrated sqlite to my project with help library #include <sqlite3.h>... Open and Connect work correct... next example my code:

#include <sqlite3.h>

int callback(void *notUsed, int colCount, char **columns, char **colNames) {
    ///........
}

int main {
    sqlite3 *db;
    int res = sqlite3_open("test.db", &db);
    if (res != SQLITE_OK) {
        printf("Cannot open database\n");
        exit(1);
    }
    sqlite3_exec(db, "SELECT * FROM test_tables;", callback, NULL, NULL);
    if (db != NULL) {
        sqlite3_close(db);
    }
    return 0;
}

After encrypting the database (see screenshot, key type = 'passphrase' page size = '1024') I have connected sqlcipher to the project -lsqlcipher -lsqlite3 -lssl -lcrypto -lcrypt32 -lwsock32 -lws2_32. Set SQLITE_HAS_CODEC 1 and use sqlite_key() after sqlite_open()... example my code:

#include <sqlite3.h>
#define SQLITE_HAS_CODEC 1

int callback(void *notUsed, int colCount, char **columns, char **colNames) {
    ///........
}

int main {
    sqlite3 *db;
    int res = sqlite3_open("test.db", &db);
    res = sqlite3_key(db, "abc", 3); // i trying to write 3 and 4...
    if (res != SQLITE_OK) {
        printf("Cannot open database\n");
        exit(1);
    }
    sqlite3_exec(db, "SELECT * FROM test_tables;", callback, NULL, NULL);
    if (db != NULL) {
        sqlite3_close(db);
    }
    return 0;
}

I trying use pragma key='%password%' and pragma page_size=%page size% but i always get next error:

2025-06-29 22:53:57.796: sqlcipher_page_cipher: hmac check failed for pgno=1
2025-06-29 22:53:57.797: sqlite3Codec: error decrypting page 1 data: 1
2025-06-29 22:53:57.797: sqlcipher_codec_ctx_set_error 1

ALWAYS! No matter what I write, nothing changes. Has anyone come across this? Does anyone know what's going on? Thank all in advance

I was trying to connect to an encrypted database and expected to succeed.

Defining SQLITE_HAS_CODEC after including the header is probably not a good idea. — molbdnilo
– molbdnilo, Commented Jun 30 at 8:42

tdy · Accepted Answer · 2025-06-30 14:21:03Z

0

I just updated sqlite on my computer to the latest version (now 3.13.1), and it fixed this error!

edited Jun 30 at 14:21

tdy

42k42 gold badges124 silver badges125 bronze badges

answered Jun 30 at 10:00

St_rt_la

332 silver badges9 bronze badges

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

Collectives™ on Stack Overflow

sqlcipher_page_cipher aftre sqlite3_key()... with includet sqlite3 sqlcipher

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related