SQLCipher "sqlite3_key" encrypted database can't be opened using SqliteManger tool

Question

here is my code to create a new encrypted database

sqlite3 *db;

if (sqlite3_open([databasePath UTF8String], &db) == SQLITE_OK) {
    const char* key = "sssri";    //the key to encrypt the database
    sqlite3_key(db, key, strlen(key));    //using the SQLCipher to encrypt database
    if (sqlite3_exec(db, (const char*) "SELECT count(*) FROM sqlite_master;", NULL, NULL, NULL) == SQLITE_OK) {
        NSLog(@"password is correct, or, database has been initialized");  //this step is also successful
        if(sqlite3_exec(db, (const char*)"create Table student (name char(4) primary key,class varchar(50) not null)", NULL, NULL, NULL)== SQLITE_OK)
        {
            NSLog(@"create a table")    //create a table if not the database is empty,and create successfully
            ;            }

    } else {
        NSLog(@"incorrect password!");
  }

    sqlite3_close(db);

but when i try to open the sqlite database in my app documents using the SqliteManger tool ,i input the "sssri" key ,the database can't be opened correctly.

Why?Some help will be appreciated!

Nick Parker · Accepted Answer · 2013-12-26 13:59:54Z

2

The SQLite Manager tool does not support SQLCipher. If you would like to interact with a SQLCipher database, outside of your codebase, consider using the SQLCipher command line shell.

answered Dec 26, 2013 at 13:59

Nick Parker

1,3881 gold badge7 silver badges10 bronze badges

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

Comments

Mark · Accepted Answer · 2014-08-21 10:03:24Z

0

Try using version 4.3.0 (or later): http://www.sqlabs.com/news/sqlitemanager/

answered Aug 21, 2014 at 10:03

Mark

7,7906 gold badges58 silver badges81 bronze badges

Collectives™ on Stack Overflow

SQLCipher "sqlite3_key" encrypted database can't be opened using SqliteManger tool

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related