help with sqlcipher
"MK (as mkuuskan at yahoo dot com)" <[email protected]>
| Newsgroups | gmane.lisp.lispworks.general |
|---|---|
| Message-ID | <[email protected]> |
Have you guys used sqlcipher? If I understand correctly it should be a drop in replacement for SQLite. Trying it out in the Terminal (> sqlcipher path/to/database) works as per usual. I can set the password, I can see the db is encrypted, I can unlock it with the correct password. What I did with LW was just to have cl-sqlite cffi:load-foreign-library point to "/opt/local/lib/libsqlcipher.dylib" (libsqlcipher comes from MacPorts). Again, I can work with unencrypted databases as per usual. However, I just can't unlock an encrypted database. I've tried the following methods: (1) sending "PRAGMA key = 'password here';" just does not do it. (2) In sqlcipher there also a function called sqlite3_key which is used to set the encryption key for an encrypted database. Called it through CFFI. It gives me error code 21. Does anybody have any idea what I might be missing? -mika _______________________________________________ Lisp Hug - the mailing list for LispWorks users [email protected] http://www.lispworks.com/support/lisp-hug.html