SQLiteCipher plugin for iOS/Android. How?

[bogong]

Hello all!

I am using devbean/QtCipherSqlitePlugin. It's working perfectly for desktop. I've got failed on attempts of building for iOS and Android. There are Wiki - I've done everything mentioned. It's not working. What am I missing?

*.pro

ios {

    LIBS += -L$$PWD/addons/ssl/ios/lib/ -lssl -lcrypto
    INCLUDEPATH += $$PWD/addons/ssl/ios/include
    DEPENDPATH += $$PWD/addons/ssl/ios/include
    PRE_TARGETDEPS += $$PWD/addons/ssl/ios/lib/libssl.a
    PRE_TARGETDEPS += $$PWD/addons/ssl/ios/lib/libcrypto.a

    CONFIG(debug, debug|release) {
	LIBS += -lsqlitecipher_debug
    } else {
	LIBS += -lsqlitecipher
    }
}

main.cpp

#ifdef Q_OS_IOS
#include <QtPlugin>
Q_IMPORT_PLUGIN(SqliteCipherDriverPlugin)
#endif

[bogong]

Found related issue. It's solving building troubles. But it's still not working in iOS/Android. Is there any suggestions of why?

[bogong]

Does anyone knows any step-by-step QtSqliteCipherPlugin installation manuals?

[bogong]

The diagnosis changed ... The QSqlDatabase::drivers() showing me in log this:

1554392864465 StartDB() (Database->open()) true
1554392864524 QSqlDatabase::drivers():  ("SQLITECIPHER", "QSQLITE")

It seems that driver loaded now after previous plugin recompilations, but data not reading/writing only on iOS/Android. Why could it be? On desktop all is reading and writing.

[SGaist]

Hi,

In the Run part of the Project panel, set the QT_DEBUG_PLUGINS to 1 and run your application. This will give you more information about what is happening.

[bogong]

@SGaist Already done it yesterday. There are

QSqlQuery::prepare: database not open

The question why it's happening only on iOS/Android but not on Desktop?

[SGaist]

Likely because you are trying to open your database somewhere you can't.

What path are you using ? If using QStandardPaths, then check that the folder you get exists otherwise create it. Why ? Because the value you get comes from the system and is valid however, it's not guaranteed that the folder already exists. That's not a bug.

If you are not using QStandardPaths then you should start doing it at least for the mobile platforms because they severely restrict where you can write data to.

[bogong]

It was about OpenSSL. it's not working if there no OpenSSL. Make sure that OpenSSL is working properly in Qt Project.