[Kmymoney-devel] Review Request 116819: SQLCipher as database driver for encrypted SQLite databeses

[Christian David]

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://git.reviewboard.kde.org/r/116819/
-----------------------------------------------------------

(Updated March 15, 2014, 7:46 p.m.)


Review request for KMymoney.


Repository: kmymoney


Description (updated)
-------

Added support for SQLCipher database driver in KMyMoney

Database backend supports SQLCipher driver. Added a new method to
KMyMoney's SQL driver which stores information if a password is
supported.

Also a new QSQLDriver for SQLCipher was introduced.

This is still work in progress as some features are missing (e.g. encrypt not encrypted database and vice versa, change password). But install is hard so only sophisticated users and engaged package maintainer can do that. I do not think this will be useful in near future. However I wanted to shared my code.

How to install/use this patch:

1) You need SQLCipher, http://sqlcipher.net , build and install it (to my knowledge it is not packed in any major distribution).
2) Get the qt source code (or just the one for QSQLiteDriver) and build it (needed as this will create the necessary folder hierarchy).

3) If you do not install to default location, enable CMake to find these folders (SQLCipher install folders, Qt source folder, Qt build folder).

4) Create KMyMoney with ENABLE_SQLCIPHER=ON (default is off)


Forgot: I have no clue how secure SQLCipher is! Just wanted to see if I can get it running.


Diffs
-----

  kmymoney/plugins/sqlcipher/tests/sqlcipherdrivertest.cpp PRE-CREATION 
  kmymoney/plugins/sqlcipher/tests/sqlcipherdrivertest.h PRE-CREATION 
  CMakeLists.txt 83a699b960b568f44e04b5801511da91dbda188e 
  kmymoney/dialogs/kgeneratesqldlg.cpp 856b457f3bc862ccd376a0f6bb43f02d92128fc8 
  kmymoney/dialogs/kselectdatabasedlg.cpp a43dfc7c2494d025a4c48082cfd30b6394585dd4 
  kmymoney/mymoney/storage/mymoneydbdriver.h 8c8f84b5dcaca124fd3a59a59ac1e2e9637c6eba 
  kmymoney/mymoney/storage/mymoneydbdriver.cpp c2219ef4c239ba350e3e7767c607afc9d7b41254 
  kmymoney/plugins/CMakeLists.txt 4e5e0740d54c8ba8db7587accb2a3c2fe565dc89 
  kmymoney/plugins/sqlcipher/CMakeLists.txt PRE-CREATION 
  kmymoney/plugins/sqlcipher/cmake/modules/FindQSQLiteSource.cmake PRE-CREATION 
  kmymoney/plugins/sqlcipher/cmake/modules/FindSQLCipher.cmake PRE-CREATION 
  kmymoney/plugins/sqlcipher/qsqlcipherdriverplugin.h PRE-CREATION 
  kmymoney/plugins/sqlcipher/qsqlcipherdriverplugin.cpp PRE-CREATION 
  kmymoney/plugins/sqlcipher/sqlcipherdriver.h PRE-CREATION 
  kmymoney/plugins/sqlcipher/sqlcipherdriver.cpp PRE-CREATION 
  kmymoney/plugins/sqlcipher/tests/CMakeLists.txt PRE-CREATION 
  kmymoney/plugins/sqlcipher/tests/sqlcipherdriverinstalltest.h PRE-CREATION 
  kmymoney/plugins/sqlcipher/tests/sqlcipherdriverinstalltest.cpp PRE-CREATION 

Diff: https://git.reviewboard.kde.org/r/116819/diff/


Testing
-------

Opened, changed, closed and reopend a (manualy created) encrypted database file.

Performance to be tested...


Thanks,

Christian David

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/kmymoney-devel/attachments/20140315/9658cd82/attachment.html>