what makes no such function: sqlcipher_export

[pzwwei]

here is the infomartion;$ ./sqlite3 aa.db
SQLite version 3.6.23.1
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> ATTACH DATABASE 'dd.db' AS encrypted KEY '';
sqlite> SELECT sqlcipher_export('dd');
Error: no such function: sqlcipher_export
sqlite> DETACH DATABASE dd;
Error: no such database: dd

[developernotes]

Hi pzwwei,

The sqlcipher_export() function [1] was added to the 2.0 release of SQLCipher [2]. You will want upgrade your build of SQLCipher to have access to that function.

1. http://sqlcipher.net/sqlcipher-api/#sqlcipher_export
2. http://sqlcipher.net/blog/2012/1/30/sqlcipher-20-released.html

[developernotes]

Hi @nitin-negi267,

Are you building your own version of the library, using a Community edition, or Commercial edition build of the software? Are you able to run the SQLCipher for Android test suite on your device? What are your results?

[developernotes]

Hi @nitin-negi267,

Additionally, would you please validate the value returned from your application at runtime by invoking the following SQL command:

PRAGMA cipher_version;

[Shruthi125]

\path\to\sqlite3.exe: sqlite3 mydb.db
SQLite version 3.39.2 2022-07-21 15:24:47
Enter ".help" for usage hints.
sqlite> PRAGMA key ='12345';
sqlite> ATTACH DATABASE 'encrypted.db' AS encrypted key '12345';
sqlite> SELECT sqlcipher_export('encrypted');
Parse error: no such function: sqlcipher_export
SELECT sqlcipher_export('encrypted');
^--- error here
Hi, please let me know why this error is shown?

[developernotes]

Hello @Shruthi125

That is because the command line tool you are using has not properly compiled/linked SQLCipher properly. You are likely using a SQLite-only command line shell. You will need to use the SQLCipher command line shell in order to use the sqlcipher_export convenience function.

[Shruthi125]

I have already built sqlcipher source on windows and got sqlite3.exe and sqlite3.dll files. From there did I execute these commands. sqlcipher version is 4.5.4

[developernotes]

Hello @Shruthi125,

What is printed in your SQLCipher command line shell when you execute the following command?

PRAGMA cipher_version;