Error on iOS: file is encrypted or is not a database

1,533 views

Skip to first unread message

Ron Cox

unread,

May 14, 2013, 7:51:15 PM5/14/13

to sqlc...@googlegroups.com

I'm using the community edition of SQLCipher on an iPad project. I'm using iOS 6.1, Xcode 4.6.2, openssl-1.0.1e, SQLCipher version 3.7.14.1.

My app communicates with a server. It downloads a bunch of records, the user edits the records, and then each modified record is sent back to the server for processing. Because the app has to still work when there is no internet connection, I have a SQLite database file I use to store the data locally. When the user first starts a "work session" I copy the (unencrypted) db file from the app resources to the documents directory. So... it's an existing db file that has tables and indexes and so forth in it, but initially has no data.

I have an #ifdef that allows me to turn the encryption off or on at compile time. With encryption off, everything works fine. With encryption on, opening the db and calling sqlite3_key works fine, but everything after that returns the error "file is encrypted or is not a database."

To troubleshoot this, I used the following code from the tutorial.

In the following code, the sqlite3_key call returns 0, which I understand indicates success. However, the sqlite3_exec does not execute successfully.

sqlite3 *db;

if (sqlite3_open([self.datastorePath UTF8String], &db) == SQLITE_OK) {

const char* key = [@"BIGSecret" UTF8String];

sqlite3_key(db, key, strlen(key));

if (sqlite3_exec(db, (const char*) "SELECT count(*) FROM sqlite_master;", NULL, NULL, NULL) == SQLITE_OK) {

DLog(@"password is correct, or, database has been initialized");

} else {

DLog(@"password is NOT correct, or, database has NOT been initialized");

}

sqlite3_close(db);

}

I have -DSQLITE_HAS_CODEC in the "Other C Flags" for both debug and release.

I'm stuck. Any help would be greatly appreciated.

Ron

Stephen Lombardo

unread,

May 15, 2013, 12:14:22 AM5/15/13

to sqlc...@googlegroups.com

Hi Ron,

I sounds like you are trying encrypt an existing standard SQLite database by calling sqlite3_key, but SQLCIpher doesn't work that way. Instead, you'd want to open your template database with no key, then attach a new encrypted database, and then export the data between the two using the sqlcipher_export convenience function. There are some good examples of the procedure here:

http://sqlcipher.net/sqlcipher-api/#sqlcipher_export

Once your data is exported to an encrypted database can call sqlite3_key as the first operation before using it.

Cheers,

Stephen

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Ron Cox

unread,

May 15, 2013, 11:08:42 AM5/15/13

to sqlc...@googlegroups.com

Oh, okay. I guess I got off track because I misunderstood the instructions on http://sqlcipher.net/ios-tutorial/.

"Telling SQLCipher to encrypt a database is as easy as opening a database and using the sqlite3_key function."

It appears I need to use the sqlcipher version of sqlite at the command line. I'll use sqlcipher_export() to created an encrypted version of the template database.

In order for me to use the sqlcipher version of sqlite at the command line so I can use sqlcipher_export(), it looks like I need to do a build in addition to what I did for iOS. Is that correct? I don't see that the iOS project creates an OS X executable as an artifact of the build process. The only info on building from source I've seen is on http://sqlcipher.net/introduction/. Am I on the right track?

Ron

Nick Parker

unread,

May 15, 2013, 12:40:25 PM5/15/13

to sqlc...@googlegroups.com

Hi Ron,

In order for you to encrypt a database from the command line you would need to have a SQLCipher command line shell which can be helpful as you work on your mobile application. You can follow the manual build instructions here [1], or since you are on a Mac, if you are using the Homebrew [2] packaging manager for OS X you can install SQLCipher through that method as well [3].

1. http://sqlcipher.net/introduction/

2. http://mxcl.github.com/homebrew/

3. http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html

Nick Parker

Ron Cox

unread,

May 15, 2013, 1:20:55 PM5/15/13

to sqlc...@googlegroups.com

Thank you, Nick. I'll give it a try. --Ron

Billy Gray

unread,

May 15, 2013, 1:51:37 PM5/15/13

to sqlc...@googlegroups.com

Hi Ron,

I may have misunderstood you, but in case I didn't: you don't need to use the command line in order to call sqlcipher_export(), your software can do that as part of its initialization process, something like this would do the trick:

ATTACH DATABASE 'path_to_template.db' AS template;

SELECT sqlcipher_export('template');

Hope that helps!

Billy

Team Zetetic
http://zetetic.net

Rogister Alain

unread,

May 16, 2013, 4:54:24 AM5/16/13

to sqlc...@googlegroups.com

Hi,

I have the same problem.

I installed http://mxcl.github.com/homebrew/ and http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html. That's OK.

I have access to Sqlite. I attach my database (That's OK) and I ask sqlcipher_export , i have a error : sqlcipher_export not found.

I installed SQLCipher-master with the source. I compiled that, but not SqlCipher_export.

Where can i found this function to encrypt my database ?

Thanks

Alain

De : Billy Gray <wg...@zetetic.net<mailto:wg...@zetetic.net>>
Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>
Date : mercredi 15 mai 2013 19:51
À : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>
Objet : Re: Error on iOS: file is encrypted or is not a database

Hi Ron,

I may have misunderstood you, but in case I didn't: you don't need to use the command line in order to call sqlcipher_export(), your software can do that as part of its initialization process, something like this would do the trick:

ATTACH DATABASE 'path_to_template.db' AS template;
SELECT sqlcipher_export('template');

Hope that helps!
Billy

On Wed, May 15, 2013 at 12:40 PM, Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net>> wrote:
Hi Ron,

In order for you to encrypt a database from the command line you would need to have a SQLCipher command line shell which can be helpful as you work on your mobile application. You can follow the manual build instructions here [1], or since you are on a Mac, if you are using the Homebrew [2] packaging manager for OS X you can install SQLCipher through that method as well [3].

1. http://sqlcipher.net/introduction/
2. http://mxcl.github.com/homebrew/
3. http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html

Nick Parker

On Wed, May 15, 2013 at 10:08 AM, Ron Cox <firs...@gmail.com<mailto:firs...@gmail.com>> wrote:
Oh, okay. I guess I got off track because I misunderstood the instructions on http://sqlcipher.net/ios-tutorial/.

"Telling SQLCipher to encrypt a database is as easy as opening a database and using the sqlite3_key function."

It appears I need to use the sqlcipher version of sqlite at the command line. I'll use sqlcipher_export() to created an encrypted version of the template database.

In order for me to use the sqlcipher version of sqlite at the command line so I can use sqlcipher_export(), it looks like I need to do a build in addition to what I did for iOS. Is that correct? I don't see that the iOS project creates an OS X executable as an artifact of the build process. The only info on building from source I've seen is on http://sqlcipher.net/introduction/. Am I on the right track?

Ron

On Tuesday, May 14, 2013 11:14:22 PM UTC-5, Stephen Lombardo wrote:
Hi Ron,

I sounds like you are trying encrypt an existing standard SQLite database by calling sqlite3_key, but SQLCIpher doesn't work that way. Instead, you'd want to open your template database with no key, then attach a new encrypted database, and then export the data between the two using the sqlcipher_export convenience function. There are some good examples of the procedure here:

http://sqlcipher.net/sqlcipher-api/#sqlcipher_export

Once your data is exported to an encrypted database can call sqlite3_key as the first operation before using it.

Cheers,
Stephen

On Tue, May 14, 2013 at 7:51 PM, Ron Cox <firs...@gmail.com> wrote:
I'm using the community edition of SQLCipher on an iPad project. I'm using iOS 6.1, Xcode 4.6.2, openssl-1.0.1e, SQLCipher version 3.7.14.1.

My app communicates with a server. It downloads a bunch of records, the user edits the records, and then each modified record is sent back to the server for processing. Because the app has to still work when there is no internet connection, I have a SQLite database file I use to store the data locally. When the user first starts a "work session" I copy the (unencrypted) db file from the app resources to the documents directory. So... it's an existing db file that has tables and indexes and so forth in it, but initially has no data.

I have an #ifdef that allows me to turn the encryption off or on at compile time. With encryption off, everything works fine. With encryption on, opening the db and calling sqlite3_key works fine, but everything after that returns the error "file is encrypted or is not a database."

To troubleshoot this, I used the following code from the tutorial.

In the following code, the sqlite3_key call returns 0, which I understand indicates success. However, the sqlite3_exec does not execute successfully.

sqlite3 *db;

if (sqlite3_open([self.datastorePathUTF8String], &db) == SQLITE_OK) {

const char* key = [@"BIGSecret"UTF8String];

sqlite3_key(db, key, strlen(key));

if (sqlite3_exec(db, (constchar*) "SELECT count(*) FROM sqlite_master;", NULL, NULL, NULL) == SQLITE_OK) {

DLog(@"password is correct, or, database has been initialized");

} else {

DLog(@"password is NOT correct, or, database has NOT been initialized");

}

sqlite3_close(db);

}

I have -DSQLITE_HAS_CODEC in the "Other C Flags" for both debug and release.

I'm stuck. Any help would be greatly appreciated.

Ron

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com>.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com>.

For more options, visit https://groups.google.com/groups/opt_out.

--
Team Zetetic
http://zetetic.net

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher+...@googlegroups.com>.

Nick Parker

unread,

May 16, 2013, 9:09:33 AM5/16/13

to sqlc...@googlegroups.com

Hi Rogister,

You need to make sure that the sqlite3 command line shell you are invoking is the one installed from homebrew and not the system provided sqlite3 as it will not contain the sqlcipher_export function. Also, you need to run `brew link sqlcipher`. Finally, execute `which sqlite3` to identify the path of the executable as configured by your PATH environment variable, this should point to your homebrew install.

Nick Parker

Rogister Alain

unread,

May 16, 2013, 9:26:50 AM5/16/13

to sqlc...@googlegroups.com

Hi Nick,

I'm in the directory : /usr/local/opt/sqlcipher/bin and i execute sqlite3 !

Is it correct ?

I maked : brew link sqlcipher and i have a warning :

Sqlcipher is keg-only and must be linked with —force
Note that doing so can interfere with building software

De : Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net>>

Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>

Date : jeudi 16 mai 2013 15:09

À : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>
Objet : Re: Error on iOS: file is encrypted or is not a database

Hi Rogister,

You need to make sure that the sqlite3 command line shell you are invoking is the one installed from homebrew and not the system provided sqlite3 as it will not contain the sqlcipher_export function. Also, you need to run `brew link sqlcipher`. Finally, execute `which sqlite3` to identify the path of the executable as configured by your PATH environment variable, this should point to your homebrew install.

Nick Parker

On Thu, May 16, 2013 at 3:54 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be>> wrote:
Hi,

I have the same problem.

I installed http://mxcl.github.com/homebrew/ and http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html. That's OK.

I have access to Sqlite. I attach my database (That's OK) and I ask sqlcipher_export , i have a error : sqlcipher_export not found.

I installed SQLCipher-master with the source. I compiled that, but not SqlCipher_export.

Where can i found this function to encrypt my database ?

Thanks

Alain

De : Billy Gray <wg...@zetetic.net<mailto:wg...@zetetic.net><mailto:wg...@zetetic.net<mailto:wg...@zetetic.net>>>
Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>>

Date : mercredi 15 mai 2013 19:51

À : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>>

Objet : Re: Error on iOS: file is encrypted or is not a database

Hi Ron,

I may have misunderstood you, but in case I didn't: you don't need to use the command line in order to call sqlcipher_export(), your software can do that as part of its initialization process, something like this would do the trick:

ATTACH DATABASE 'path_to_template.db' AS template;
SELECT sqlcipher_export('template');

Hope that helps!
Billy

On Wed, May 15, 2013 at 12:40 PM, Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>> wrote:
Hi Ron,

In order for you to encrypt a database from the command line you would need to have a SQLCipher command line shell which can be helpful as you work on your mobile application. You can follow the manual build instructions here [1], or since you are on a Mac, if you are using the Homebrew [2] packaging manager for OS X you can install SQLCipher through that method as well [3].

1. http://sqlcipher.net/introduction/
2. http://mxcl.github.com/homebrew/
3. http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html

Nick Parker

On Wed, May 15, 2013 at 10:08 AM, Ron Cox <firs...@gmail.com<mailto:firs...@gmail.com><mailto:firs...@gmail.com<mailto:firs...@gmail.com>>> wrote:
Oh, okay. I guess I got off track because I misunderstood the instructions on http://sqlcipher.net/ios-tutorial/.

"Telling SQLCipher to encrypt a database is as easy as opening a database and using the sqlite3_key function."

It appears I need to use the sqlcipher version of sqlite at the command line. I'll use sqlcipher_export() to created an encrypted version of the template database.

In order for me to use the sqlcipher version of sqlite at the command line so I can use sqlcipher_export(), it looks like I need to do a build in addition to what I did for iOS. Is that correct? I don't see that the iOS project creates an OS X executable as an artifact of the build process. The only info on building from source I've seen is on http://sqlcipher.net/introduction/. Am I on the right track?

Ron

On Tuesday, May 14, 2013 11:14:22 PM UTC-5, Stephen Lombardo wrote:
Hi Ron,

I sounds like you are trying encrypt an existing standard SQLite database by calling sqlite3_key, but SQLCIpher doesn't work that way. Instead, you'd want to open your template database with no key, then attach a new encrypted database, and then export the data between the two using the sqlcipher_export convenience function. There are some good examples of the procedure here:

http://sqlcipher.net/sqlcipher-api/#sqlcipher_export

Once your data is exported to an encrypted database can call sqlite3_key as the first operation before using it.

Cheers,
Stephen

On Tue, May 14, 2013 at 7:51 PM, Ron Cox <firs...@gmail.com<mailto:firs...@gmail.com>> wrote:
I'm using the community edition of SQLCipher on an iPad project. I'm using iOS 6.1, Xcode 4.6.2, openssl-1.0.1e, SQLCipher version 3.7.14.1.

My app communicates with a server. It downloads a bunch of records, the user edits the records, and then each modified record is sent back to the server for processing. Because the app has to still work when there is no internet connection, I have a SQLite database file I use to store the data locally. When the user first starts a "work session" I copy the (unencrypted) db file from the app resources to the documents directory. So... it's an existing db file that has tables and indexes and so forth in it, but initially has no data.

I have an #ifdef that allows me to turn the encryption off or on at compile time. With encryption off, everything works fine. With encryption on, opening the db and calling sqlite3_key works fine, but everything after that returns the error "file is encrypted or is not a database."

To troubleshoot this, I used the following code from the tutorial.

In the following code, the sqlite3_key call returns 0, which I understand indicates success. However, the sqlite3_exec does not execute successfully.

sqlite3 *db;

if (sqlite3_open([self.datastorePathUTF8String], &db) == SQLITE_OK) {

const char* key = [@"BIGSecret"UTF8String];

sqlite3_key(db, key, strlen(key));

if (sqlite3_exec(db, (constchar*) "SELECT count(*) FROM sqlite_master;", NULL, NULL, NULL) == SQLITE_OK) {

DLog(@"password is correct, or, database has been initialized");

} else {

DLog(@"password is NOT correct, or, database has NOT been initialized");

}

sqlite3_close(db);

}

I have -DSQLITE_HAS_CODEC in the "Other C Flags" for both debug and release.

I'm stuck. Any help would be greatly appreciated.

Ron

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2B...@googlegroups.com>.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

For more options, visit https://groups.google.com/groups/opt_out.

--
Team Zetetic
http://zetetic.net

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com>.
For more options, visit https://groups.google.com/groups/opt_out.

--

Rogister Alain

unread,

May 16, 2013, 9:42:40 AM5/16/13

to sqlc...@googlegroups.com

Nick,

I executed 'which sqite3' and i have : /usr/bin/sqlite3

I execute in this directory my command

Attach database Š => OK

Select sqlcipher_export('sfsfs'); => sqlciphher_export not foundŠ

Le 16/05/13 15:26, « Rogister Alain » <alain.r...@appl.be> a écrit :

>ip...@googlegroups.com<mailto:sqlc...@googlegroups.com>>"

><sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc

>ip...@googlegroups.com<mailto:sqlc...@googlegroups.com>>>

>Date : mercredi 15 mai 2013 19:51
>À :
>"sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc

>ip...@googlegroups.com<mailto:sqlc...@googlegroups.com>>"

><sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc

>ip...@googlegroups.com<mailto:sqlc...@googlegroups.com>>>

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsubscribe@goog
>legroups.com><mailto:sqlcipher%2Bunsu...@googlegroups.com<mailto:sqlci
>pher%252Buns...@googlegroups.com>>.

>For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>--
>
>---
>You received this message because you are subscribed to the Google Groups
>"SQLCipher Users" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsubscribe@goog
>legroups.com><mailto:sqlcipher%2Bunsu...@googlegroups.com<mailto:sqlci

>pher%252Buns...@googlegroups.com>>.
>For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>
>--
>Team Zetetic
>http://zetetic.net
>
>--
>
>---
>You received this message because you are subscribed to the Google Groups
>"SQLCipher Users" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsubscribe@goog
>legroups.com><mailto:sqlcipher+...@googlegroups.com<mailto:sqlciph
>er%2Bunsu...@googlegroups.com>>.

>For more options, visit https://groups.google.com/groups/opt_out.
>
>
>--
>
>---
>You received this message because you are subscribed to the Google Groups
>"SQLCipher Users" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsubscribe@goog

>legroups.com>.
>For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>--
>
>---
>You received this message because you are subscribed to the Google Groups
>"SQLCipher Users" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to

>sqlcipher+...@googlegroups.com<mailto:sqlcipher+unsubscribe@google

>groups.com>.
>For more options, visit https://groups.google.com/groups/opt_out.
>
>
>--
>
>---
>You received this message because you are subscribed to the Google Groups
>"SQLCipher Users" group.
>To unsubscribe from this group and stop receiving emails from it, send an

>email to sqlcipher+...@googlegroups.com.

Nick Parker

unread,

May 16, 2013, 9:59:05 AM5/16/13

to sqlc...@googlegroups.com

Hi Rogister,

export PATH=/usr/local/bin:$PATH

It appears that --force is required now, this wasn't when we published the SQLCipher recipe with Homebrew. So your syntax for linking will be:

brew link sqlcipher --force

Nick Parker

Rogister Alain

unread,

May 16, 2013, 10:15:13 AM5/16/13

to sqlc...@googlegroups.com

Hi Nick,

Ok, now, i make the link and i have /usr/local/bin in the PATH

Now, I execute sqlite3

sqlite> ATTACH database '/Users/Rogister/Test.db' as Test KEY 'Pass';

And I have : Error : file is encrypted or is not a database => The database file is not encrypted and that's a database …

De : Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net>>
Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>

Date : jeudi 16 mai 2013 15:59

À : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>
Objet : Re: Error on iOS: file is encrypted or is not a database

Hi Rogister,

Homebrew usually creates its Cellar within /usr/local, if this is how you have your machine configured you will want to prepend /usr/local/bin before /usr/bin in your PATH. Something like the following in your shell initialization script:

export PATH=/usr/local/bin:$PATH

It appears that --force is required now, this wasn't when we published the SQLCipher recipe with Homebrew. So your syntax for linking will be:

brew link sqlcipher --force

Nick Parker

On Thu, May 16, 2013 at 8:42 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be>> wrote:
Nick,

I executed 'which sqite3' and i have : /usr/bin/sqlite3

I execute in this directory my command

Attach database Š => OK

Select sqlcipher_export('sfsfs'); => sqlciphher_export not foundŠ

Le 16/05/13 15:26, « Rogister Alain » <alain.r...@appl.be<mailto:alain.r...@appl.be>> a écrit :

>Hi Nick,
>
>I'm in the directory : /usr/local/opt/sqlcipher/bin and i execute sqlite3
>!
>
>Is it correct ?
>
>I maked : brew link sqlcipher and i have a warning :
>
>Sqlcipher is keg-only and must be linked with ‹force
>Note that doing so can interfere with building software
>
>
>

>De : Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>>
>Répondre à :
>"sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>"
><sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>>

>Date : jeudi 16 mai 2013 15:09

>À : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>"
><sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>>

>Date : mercredi 15 mai 2013 19:51
>À :

>Objet : Re: Error on iOS: file is encrypted or is not a database
>

>Hi Ron,
>
>I may have misunderstood you, but in case I didn't: you don't need to use
>the command line in order to call sqlcipher_export(), your software can
>do that as part of its initialization process, something like this would
>do the trick:
>
>ATTACH DATABASE 'path_to_template.db' AS template;
>SELECT sqlcipher_export('template');
>
>Hope that helps!
>Billy
>
>
>On Wed, May 15, 2013 at 12:40 PM, Nick Parker

><npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>><mailto:npa...@zetetic.ne<mailto:npa...@zetetic.ne>

>t<mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>>> wrote:
>Hi Ron,
>
>In order for you to encrypt a database from the command line you would
>need to have a SQLCipher command line shell which can be helpful as you
>work on your mobile application. You can follow the manual build
>instructions here [1], or since you are on a Mac, if you are using the
>Homebrew [2] packaging manager for OS X you can install SQLCipher through
>that method as well [3].
>
>1. http://sqlcipher.net/introduction/
>2. http://mxcl.github.com/homebrew/
>3.
>http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html
>
>Nick Parker
>
>
>On Wed, May 15, 2013 at 10:08 AM, Ron Cox

><firs...@gmail.com<mailto:firs...@gmail.com><mailto:firs...@gmail.com<mailto:firs...@gmail.com>><mailto:firs...@gmail.com<mailto:firs...@gmail.com><m

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2B...@googlegroups.com><mailto:sqlcipher%2B...@googlegroups.com<mailto:sqlcipher%252B...@googlegroups.com>>.

>
>For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>--
>
>---
>You received this message because you are subscribed to the Google Groups
>"SQLCipher Users" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com><mailto:sqlcipher%2Bunsubscribe@goog<mailto:sqlcipher%252Bunsubscribe@goog>
>legroups.com<http://legroups.com>><mailto:sqlcipher%2Bunsu...@googlegroups.com<mailto:sqlcipher%252Buns...@googlegroups.com><mailto:sqlci<mailto:sqlci>
>pher%252Buns...@googlegroups.com<mailto:pher%25252Bun...@googlegroups.com>>>.

>For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>
>--
>Team Zetetic
>http://zetetic.net
>
>--
>
>---
>You received this message because you are subscribed to the Google Groups
>"SQLCipher Users" group.
>To unsubscribe from this group and stop receiving emails from it, send an
>email to

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com><mailto:sqlcipher%2Bunsubscribe@goog<mailto:sqlcipher%252Bunsubscribe@goog>
>legroups.com<http://legroups.com>><mailto:sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com><mailto:sqlciph<mailto:sqlciph>
>er%2Bunsu...@googlegroups.com<mailto:er%252Buns...@googlegroups.com>>>.

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com><mailto:sqlcipher%2Bunsubscribe@goog<mailto:sqlcipher%252Bunsubscribe@goog>
>legroups.com<http://legroups.com>>.

>sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com><mailto:sqlcipher+unsubscribe@google<mailto:sqlcipher%2Bunsubscribe@google>
>groups.com<http://groups.com>>.

>email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com>.

>For more options, visit https://groups.google.com/groups/opt_out.
>
>

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com>.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher+...@googlegroups.com>.

Nick Parker

unread,

May 16, 2013, 10:45:57 AM5/16/13

to sqlc...@googlegroups.com

Hi Rogister,

Could you provide a little context around what you are trying to do? Does that database exist, is it currently encrypted, etc. If it is unrelated to this current threaded discussion it maybe helpful for you to create a new mailing list thread detailing your specific issue. Thanks!

Nick Parker

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.

Rogister Alain

unread,

May 16, 2013, 10:56:41 AM5/16/13

to sqlc...@googlegroups.com

Nick,

I want to encrypt an existing SQLite database for use with an iPhone application.

My database is not encrypted and I have this message.

sqlite> ATTACH database '/Users/Rogister/Test.db' as Test KEY 'Pass';

And I have : Error : file is encrypted or is not a database => The database file is not encrypted and that's a database …

De : Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net>>
Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>

Date : jeudi 16 mai 2013 16:45

On Thu, May 16, 2013 at 9:15 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be>> wrote:
Hi Nick,

Ok, now, i make the link and i have /usr/local/bin in the PATH

Now, I execute sqlite3

sqlite> ATTACH database '/Users/Rogister/Test.db' as Test KEY 'Pass';

And I have : Error : file is encrypted or is not a database => The database file is not encrypted and that's a database …

De : Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>>
Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com><mailto:sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>>

Date : jeudi 16 mai 2013 15:59

On Thu, May 16, 2013 at 8:42 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>> wrote:
Nick,

I executed 'which sqite3' and i have : /usr/bin/sqlite3

I execute in this directory my command

Attach database Š => OK

Select sqlcipher_export('sfsfs'); => sqlciphher_export not foundŠ

Le 16/05/13 15:26, « Rogister Alain » <alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>> a écrit :

>Date : jeudi 16 mai 2013 15:09

>Date : mercredi 15 mai 2013 19:51
>À :

>Objet : Re: Error on iOS: file is encrypted or is not a database
>
>Hi Ron,
>
>I may have misunderstood you, but in case I didn't: you don't need to use
>the command line in order to call sqlcipher_export(), your software can
>do that as part of its initialization process, something like this would
>do the trick:
>
>ATTACH DATABASE 'path_to_template.db' AS template;
>SELECT sqlcipher_export('template');
>
>Hope that helps!
>Billy
>
>
>On Wed, May 15, 2013 at 12:40 PM, Nick Parker

>t<mailto:npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>>>> wrote:
>Hi Ron,
>
>In order for you to encrypt a database from the command line you would
>need to have a SQLCipher command line shell which can be helpful as you
>work on your mobile application. You can follow the manual build
>instructions here [1], or since you are on a Mac, if you are using the
>Homebrew [2] packaging manager for OS X you can install SQLCipher through
>that method as well [3].
>
>1. http://sqlcipher.net/introduction/
>2. http://mxcl.github.com/homebrew/
>3.
>http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html
>
>Nick Parker
>
>
>On Wed, May 15, 2013 at 10:08 AM, Ron Cox

>email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com><mailto:sqlcipher%2Bunsu...@googlegroups.com<mailto:sqlcipher%252Buns...@googlegroups.com>>.

>For more options, visit https://groups.google.com/groups/opt_out.
>
>

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

Nick Parker

unread,

May 16, 2013, 11:02:51 AM5/16/13

to sqlc...@googlegroups.com

Hi Rogister,

Just to verify you are executing a SQLCipher version of the sqlite3 command shell, please launch sqlite3 and execute the following command:

PRAGMA cipher_version;

You should get a value printed to your screen. If that does not work, your PATH configuration is still the issue as sqlcipher_export does not exist within the standard system distributed sqlite3 shell. If you do get a value printed, the exact scenario you attempting to accomplish is detailed in example 1 of the sqlcipher_export function documentation found here [1].

1. http://sqlcipher.net/sqlcipher-api/#sqlcipher_export

Nick Parker

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.

Rogister Alain

unread,

May 16, 2013, 11:11:09 AM5/16/13

to sqlc...@googlegroups.com

Hi,

This is my screen terminal :

[cid:7CB7E5B5-1F7A-48FA-B39D-F6544637664A]

De : Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net>>
Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>

Date : jeudi 16 mai 2013 17:02

Just to verify you are executing a SQLCipher version of the sqlite3 command shell, please launch sqlite3 and execute the following command:

PRAGMA cipher_version;

You should get a value printed to your screen. If that does not work, your PATH configuration is still the issue as sqlcipher_export does not exist within the standard system distributed sqlite3 shell. If you do get a value printed, the exact scenario you attempting to accomplish is detailed in example 1 of the sqlcipher_export function documentation found here [1].

1. http://sqlcipher.net/sqlcipher-api/#sqlcipher_export

Nick Parker

Nick Parker

On Thu, May 16, 2013 at 9:56 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be>> wrote:
Nick,

I want to encrypt an existing SQLite database for use with an iPhone application.

My database is not encrypted and I have this message.

sqlite> ATTACH database '/Users/Rogister/Test.db' as Test KEY 'Pass';

And I have : Error : file is encrypted or is not a database => The database file is not encrypted and that's a database …

Date : jeudi 16 mai 2013 16:45

On Thu, May 16, 2013 at 9:15 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>> wrote:
Hi Nick,

Ok, now, i make the link and i have /usr/local/bin in the PATH

Now, I execute sqlite3

sqlite> ATTACH database '/Users/Rogister/Test.db' as Test KEY 'Pass';

And I have : Error : file is encrypted or is not a database => The database file is not encrypted and that's a database …

Date : jeudi 16 mai 2013 15:59

>Date : jeudi 16 mai 2013 15:09

>Objet : Re: Error on iOS: file is encrypted or is not a database
>
>Hi Rogister,
>
>You need to make sure that the sqlite3 command line shell you are
>invoking is the one installed from homebrew and not the system provided
>sqlite3 as it will not contain the sqlcipher_export function. Also, you
>need to run `brew link sqlcipher`. Finally, execute `which sqlite3` to
>identify the path of the executable as configured by your PATH
>environment variable, this should point to your homebrew install.
>
>Nick Parker
>
>
>On Thu, May 16, 2013 at 3:54 AM, Rogister Alain
><alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>>>> wrote:
>Hi,
>
>I have the same problem.
>
>I installed http://mxcl.github.com/homebrew/ and
>http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html.
>That's OK.
>
>I have access to Sqlite. I attach my database (That's OK) and I ask
>sqlcipher_export , i have a error : sqlcipher_export not found.
>
>I installed SQLCipher-master with the source. I compiled that, but not
>SqlCipher_export.
>
>Where can i found this function to encrypt my database ?
>
>Thanks
>
>Alain
>
>
>
>De : Billy Gray

>Date : mercredi 15 mai 2013 19:51
>À :

>t<mailto:npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>>>>> wrote:
>Hi Ron,
>
>In order for you to encrypt a database from the command line you would
>need to have a SQLCipher command line shell which can be helpful as you
>work on your mobile application. You can follow the manual build
>instructions here [1], or since you are on a Mac, if you are using the
>Homebrew [2] packaging manager for OS X you can install SQLCipher through
>that method as well [3].
>
>1. http://sqlcipher.net/introduction/
>2. http://mxcl.github.com/homebrew/
>3.
>http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html
>
>Nick Parker
>
>
>On Wed, May 15, 2013 at 10:08 AM, Ron Cox

>For more options, visit https://groups.google.com/groups/opt_out.
>
>

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

Nick Parker

unread,

May 16, 2013, 11:28:13 AM5/16/13

to sqlc...@googlegroups.com

Hi Rogister,

If the database already exists that you are attempting to attach I believe you have your steps out of order. Please try the following instead:

sqlite3 /Users/RogisterMAC/Medinect.db

attach database '/Users/RogisterMAC/encrypted.db' as encrypted KEY 'Joshua007Action';

select sqlcipher_export('encrypted');

detach database encrypted

This should generate a file called encrypted.db with the schema and data from your Medinect.db. You would need to do the following to access it's contents:

sqlite3 /Users/RogisterMAC/encrypted.db

PRAGMA key = 'Joshua007Action';

select * from [YourTableHere];

Nick Parker

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.

Rogister Alain

unread,

May 16, 2013, 11:52:12 AM5/16/13

to sqlc...@googlegroups.com

Ok Nick,

That's run now. I have my database encrypted.

Is it normal that the size is small that the original database ?

Tomorrow, i try to acces with my project MonoTouch.

Thanks

Alain

De : Nick Parker <npa...@zetetic.net<mailto:npa...@zetetic.net>>
Répondre à : "sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>" <sqlc...@googlegroups.com<mailto:sqlc...@googlegroups.com>>

Date : jeudi 16 mai 2013 17:28

If the database already exists that you are attempting to attach I believe you have your steps out of order. Please try the following instead:

sqlite3 /Users/RogisterMAC/Medinect.db
attach database '/Users/RogisterMAC/encrypted.db' as encrypted KEY 'Joshua007Action';
select sqlcipher_export('encrypted');
detach database encrypted

This should generate a file called encrypted.db with the schema and data from your Medinect.db. You would need to do the following to access it's contents:

sqlite3 /Users/RogisterMAC/encrypted.db
PRAGMA key = 'Joshua007Action';
select * from [YourTableHere];

Nick Parker

Nick Parker

On Thu, May 16, 2013 at 10:11 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be>> wrote:
Hi,

This is my screen terminal :

[cid:7CB7E5B5-1F7A-48FA-B39D-F6544637664A]

Date : jeudi 16 mai 2013 17:02

On Thu, May 16, 2013 at 9:56 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>> wrote:
Nick,

Date : jeudi 16 mai 2013 16:45

On Thu, May 16, 2013 at 9:15 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>>> wrote:
Hi Nick,

Ok, now, i make the link and i have /usr/local/bin in the PATH

Now, I execute sqlite3

sqlite> ATTACH database '/Users/Rogister/Test.db' as Test KEY 'Pass';

And I have : Error : file is encrypted or is not a database => The database file is not encrypted and that's a database …

Date : jeudi 16 mai 2013 15:59

On Thu, May 16, 2013 at 8:42 AM, Rogister Alain <alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>>>> wrote:
Nick,

I executed 'which sqite3' and i have : /usr/bin/sqlite3

I execute in this directory my command

Attach database Š => OK

Select sqlcipher_export('sfsfs'); => sqlciphher_export not foundŠ

Le 16/05/13 15:26, « Rogister Alain » <alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>>>> a écrit :

>Date : jeudi 16 mai 2013 15:09

>Objet : Re: Error on iOS: file is encrypted or is not a database
>
>Hi Rogister,
>
>You need to make sure that the sqlite3 command line shell you are
>invoking is the one installed from homebrew and not the system provided
>sqlite3 as it will not contain the sqlcipher_export function. Also, you
>need to run `brew link sqlcipher`. Finally, execute `which sqlite3` to
>identify the path of the executable as configured by your PATH
>environment variable, this should point to your homebrew install.
>
>Nick Parker
>
>
>On Thu, May 16, 2013 at 3:54 AM, Rogister Alain
><alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be><mailto:alain.r...@appl.be<mailto:alain.r...@appl.be>>>>>> wrote:
>Hi,
>
>I have the same problem.
>
>I installed http://mxcl.github.com/homebrew/ and
>http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html.
>That's OK.
>
>I have access to Sqlite. I attach my database (That's OK) and I ask
>sqlcipher_export , i have a error : sqlcipher_export not found.
>
>I installed SQLCipher-master with the source. I compiled that, but not
>SqlCipher_export.
>
>Where can i found this function to encrypt my database ?
>
>Thanks
>
>Alain
>
>
>
>De : Billy Gray

>Date : mercredi 15 mai 2013 19:51
>À :

>t<mailto:npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net><mailto:npa...@zetetic.net<mailto:npa...@zetetic.net>>>>>>> wrote:
>Hi Ron,
>
>In order for you to encrypt a database from the command line you would
>need to have a SQLCipher command line shell which can be helpful as you
>work on your mobile application. You can follow the manual build
>instructions here [1], or since you are on a Mac, if you are using the
>Homebrew [2] packaging manager for OS X you can install SQLCipher through
>that method as well [3].
>
>1. http://sqlcipher.net/introduction/
>2. http://mxcl.github.com/homebrew/
>3.
>http://sqlcipher.net/blog/2013/1/21/sqlcipher-available-on-homebrew.html
>
>Nick Parker
>
>
>On Wed, May 15, 2013 at 10:08 AM, Ron Cox

>For more options, visit https://groups.google.com/groups/opt_out.
>
>

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com<mailto:sqlcipher%2Bunsu...@googlegroups.com><mailto:sqlcipher%2Bunsu...@googlegroups.com<mailto:sqlcipher%252Buns...@googlegroups.com>><mailto:sqlcipher%2Bunsu...@googlegroups.com<mailto:sqlcipher%252Buns...@googlegroups.com><mailto:sqlcipher%252Buns...@googlegroups.com<mailto:sqlcipher%25252Bun...@googlegroups.com>>><mailto:sqlcipher%2Bunsu...@googlegroups.com<mailto:sqlcipher%252Buns...@googlegroups.com><mailto:sqlcipher%252Buns...@googlegroups.com<mailto:sqlcipher%25252Bun...@googlegroups.com>><mailto:sqlcipher%252Buns...@googlegroups.com<mailto:sqlcipher%25252Bun...@googlegroups.com><mailto:sqlcipher%25252Bun...@googlegroups.com<mailto:sqlcipher%2525252Bu...@googlegroups.com>>>>.

For more options, visit https://groups.google.com/groups/opt_out.

--

---
You received this message because you are subscribed to the Google Groups "SQLCipher Users" group.

Nick Parker

unread,

May 16, 2013, 11:54:46 AM5/16/13

to sqlc...@googlegroups.com

Hi Rogister,

Glad to hear you were able to successfully encrypt the database. The file size will likely differ from the non-encrypted format.

Nick Parker

To unsubscribe from this group and stop receiving emails from it, send an email to sqlcipher+...@googlegroups.com.

Ron Cox

unread,

May 16, 2013, 3:59:05 PM5/16/13

to sqlc...@googlegroups.com

I now have everything working. What I ended up doing is compiling from source, following the instructions here:

http://sqlcipher.net/introduction/

Note that I tried static linking first and got errors. Dynamic linking worked for me.

I then created an encrypted version of my "template" database following the instructions here:

http://sqlcipher.net/sqlcipher-api/#sqlcipher_export

Note that I used the sqlcipher version of sqlite3 at the command line.

Thank you everyone for your assistance.

Ron

Nick Parker

unread,

May 16, 2013, 4:32:01 PM5/16/13

to sqlc...@googlegroups.com

Hi Ron,

Glad to hear you got everything working on your end, thanks for letting us know!

Nick Parker

Ron

--

Reply all

Reply to author

Forward

0 new messages