Building QSQLCipher trouble on MacOS.

bogong

Hello all!
I am trying to build this SQLCipher plugin on Qt 5.12.2 on MacOS. Got error like this:

$ make
cd qsqlcipher/ && ( test -e Makefile || /Users/alexandr/Applications/Qt5.12/5.12.2/ios/bin/qmake -o Makefile /mobile_libs/qsqlcipher-qt5/qsqlcipher/qsqlcipher.pro ) && /Applications/Xcode.app/Contents/Developer/usr/bin/make -f Makefile
Info: creating stash file /mobile_libs/qsqlcipher-qt5/build/qsqlcipher/.qmake.stash
Project WARNING: Cross compiling without sysroot. Disabling pkg-config.
Project WARNING: Cross compiling without sysroot. Disabling pkg-config.
sh: --exists: command not found
Project ERROR: sqlcipher development package not found
make: *** [sub-qsqlcipher-make_first] Error 3

The question is where to get sqlcipher development package?
Before it I've been installing all requirements from reference.

SQLCiher itself built via homebrew and it's working.

*.pro

TARGET = qsqlcipher

QT_FOR_CONFIG += sqldrivers-private

HEADERS += $$PWD/qsql_sqlite_p.h \
    ../../../../../../../usr/local/Cellar/sqlcipher/HEAD-162b061/include/sqlcipher/sqlite3.h \
    ../../../../../../../usr/local/Cellar/sqlcipher/HEAD-162b061/include/sqlcipher/sqlite3ext.h
SOURCES += $$PWD/qsql_sqlite.cpp $$PWD/smain.cpp

CONFIG += link_pkgconfig
PKGCONFIG += sqlcipher
# or if pkg-config is not available

OTHER_FILES += sqlcipher.json

PLUGIN_CLASS_NAME = QSQLCipherDriverPlugin

# follows contents of include(../qsqldriverbase.pri)
QT  = core core-private sql-private

PLUGIN_TYPE = sqldrivers
load(qt_plugin)

DEFINES += QT_NO_CAST_TO_ASCII QT_NO_CAST_FROM_ASCII

INCLUDEPATH += $$PWD/../../../../../../../usr/include
DEPENDPATH += $$PWD/../../../../../../../usr/include
LIBS += -L$$PWD/../../../../../../../usr/lib/ -lcrypto.0.9.7

INCLUDEPATH += $$PWD/../../../../../../../usr/local/Cellar/sqlcipher/HEAD-162b061/include
DEPENDPATH += $$PWD/../../../../../../../usr/local/Cellar/sqlcipher/HEAD-162b061/include
LIBS += -L$$PWD/../../../../../../../usr/local/Cellar/sqlcipher/HEAD-162b061/lib/ -lsqlcipher.0

bogong

Found another plugin QtCipherSqlitePlugin. It built perfectly (with huge list of unused var warnings). For now in my application I have this:

QML debugging is enabled. Only use this in a safe environment.
QSqlDatabase: SQLITECIPHER driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7
Failed to restore the database
QSqlQuery::exec: database not open

How to install this plugin? In reference for this plugin mentioned to copy it somewhere? Where should it be copied?

bogong

Solved. Need to copy result of compilation to [QT_HOME]/5.12.2/clang_64/plugins/sqldrivers

Andy Pelawi

@bogong Thanx :)
Whould you give me a simple code, how to use this plugin?

Christian Ehrlicher

@Andy-Pelawi said in Building QSQLCipher trouble on MacOS.:

Whould you give me a simple code, how to use this plugin?

https://doc.qt.io/qt-5/qsqldatabase.html#details

Andy Pelawi

@Christian-Ehrlicher Thanx :)

I testing my code using this : https://github.com/devbean/QtCipherSqlitePlugin/blob/master/testapp/main.cpp
and success.

And how to access the encrypted this db using a database manager like dbeaver? Do you have any suggestions?
Sorry for my English :)

Christian Ehrlicher

I don't know dbeaver but since it looks like it can open all kinds of databases it should also have a plugin for sqlcipher