如何使用 Windows/MinGW 平台使用 SQLCipher 扩展为 SQLite-DB 构建 Qt-SQL-driver-plugin 'QSQLCIPHER'?

How to build the Qt-SQL-driver-plugin #39;QSQLCIPHER#39; for SQLite-DB with SQLCipher-extension using the Windows/MinGW-platform?(如何使用 Windows/MinGW 平台使用 SQLCipher 扩展为 SQLite-DB 构建 Qt-SQL-driver-plugin QSQLCIPHER?)

问题描述

这通常不是在哪里可以找到分步指南的问题，而是指南本身的问题.
我写这篇文章的目的是给其他人一个提示，他们在编译驱动程序插件时遇到了和我最近一样的问题.

This is not typically a question where to find a step-by-step guide, but rather the guide itself.
My intention with this post is to give others a hint, who have the same problems in compiling the driver-plugin as I just had recently.

推荐答案

如何使用 Windows/MinGW 平台为 SQLite-DB 和 SQLCipher-extension 构建 Qt-SQL-driver-plugin 'QSQLCIPHER':

1. 适用于 Windows/MinGW 的 Qt 5.4.0

1. Qt 5.4.0 for Windows/MinGW

• 下载 Qt
• 安装包括源代码，例如C:QtQt5.4.0

• 下载 Win32 OpenSSL v1.0.2a
• 下载 Visual C++ 2008 Redistributable
• 通过执行vcredist_x86.exe"安装 Visual C++ 2008 Redistributable
• 通过执行Win32OpenSSL-1_0_2.exe"安装 OpenSSL v1.0.2a
  • 目标目录，例如C:OpenSSL-Win32
  • 在安装过程中，选择将库安装到 Windows 系统目录 (C:WindowsSysWOW64) 的选项

  MinGW - 适用于 Windows 的极简主义 GNU

  MinGW - Minimalist GNU for Windows

  • 下载并安装mingw-get-setup.exe"
  • MinGW 安装程序的启动
    • 安装MSYS基础系统
      • 选择:所有包 -> MSYS -> MSYS 基础系统
      • 选择 msys-base (Class 'bin') 进行安装
      • 菜单:安装 -> 应用更改
      • 默认安装文件到目录C:MinGW
      • 选择:所有包 -> MinGW -> MinGW 贡献
      • 选择mingw32-tcl"和mingw32-tk"(类bin")进行安装
      • 菜单:安装 -> 应用更改
      • 默认安装文件到目录C:MinGW

      在C:QtQt5.4.0Toolsmingw491_32msys1.0etc

      • 插入内容如下:

      • Insert content as follows:

      #Win32_Path                        Mount_Point
      C:/Qt/Qt5.4.0/Tools/mingw491_32    /mingw
      C:/Qt/Qt5.4.0/5.4                  /qt
      C:/                                /c
      

    zlib 库

    • 下载 zlib-dll-二进制文件
    • 解压并复制文件 'zlib1.dll' 到 Qt-MinGW 目录 C:QtQt5.4.0Toolsmingw491_32msys1.0in

    SQLCipher

    • 下载 SQLCipher 压缩文件
    • 提取 zip 文件，例如C: empsqlcipher-master
    • 复制 OpenSSL-Win32-libraries
      • 将C:OpenSSL-Win32inlibeay32.dll复制到C: empsqlcipher-master
      • 将C:OpenSSL-Win32liblibeay32.lib复制到C: empsqlcipher-master
      • Download the SQLCipher-zip-file
      • Extract the zip-file e.g. to C: empsqlcipher-master
      • Copy OpenSSL-Win32-libraries
        • Copy C:OpenSSL-Win32inlibeay32.dll to C: empsqlcipher-master
        • Copy C:OpenSSL-Win32liblibeay32.lib to C: empsqlcipher-master

        构建 SQLCipher.exe

        Build SQLCipher.exe

        • 执行 MSYS:C:QtQt5.4.0Toolsmingw491_32msys1.0msys.bat

        $ cd /c/temp/sqlcipher-master
        $ ./configure --prefix=$(pwd)/dist --with-crypto-lib=none --disable-tcl CFLAGS="-DSQLITE_HAS_CODEC -DSQLCIPHER_CRYPTO_OPENSSL -I/c/openssl-win32/include /c/temp/sqlcipher-master/libeay32.dll -L/c/temp/sqlcipher-master/ -static-libgcc" LDFLAGS="-leay32"
        $ make clean
        $ make sqlite3.c
        $ make
        $ make dll
        $ make install
        

      保存可执行的 SQLite/SQLCipher 数据库，例如C:sqlcipher

      Save the executable SQLite/SQLCipher-database e.g. to C:sqlcipher

      • 将C: empsqlcipher-masterdistinsqlcipher.exe复制到C:sqlcipher.
        文件sqlcipher.exe"是与非加密原始命令行界面sqlite3.exe"的加密等效项.
      • 将C: empsqlcipher-mastersqlite3.dll复制到C:sqlcipher.
        该文件是加密扩展的 SQLite 库.

      构建 Qt-QSQLCIPHER-driver-plugin

      Build Qt-QSQLCIPHER-driver-plugin

      • 创建目录:
        C:QtQt5.4.05.4Srcqtbasesrcpluginssqldriverssqlcipher

      • 在新目录中创建以下三个文件:

      • Create directory:
        C:QtQt5.4.05.4Srcqtbasesrcpluginssqldriverssqlcipher

      • Create the following three files within the new directory:

      • 文件 1:smain.cpp:

      • File 1: smain.cpp:

      #include <qsqldriverplugin.h>
      #include <qstringlist.h>
      #include "../../../../src/sql/drivers/sqlite/qsql_sqlite_p.h" // There was a missing " at the end of this line
      QT_BEGIN_NAMESPACE
      class QSQLcipherDriverPlugin : public QSqlDriverPlugin
      {
          Q_OBJECT
          Q_PLUGIN_METADATA(IID "org.qt-project.Qt.QSqlDriverFactoryInterface" FILE "sqlcipher.json")
      public:
          QSQLcipherDriverPlugin();
      
          QSqlDriver* create(const QString &);
      };
      QSQLcipherDriverPlugin::QSQLcipherDriverPlugin()
          : QSqlDriverPlugin()
      {
      }
      QSqlDriver* QSQLcipherDriverPlugin::create(const QString &name)
      {
          if (name == QLatin1String("QSQLCIPHER")) {
              QSQLiteDriver* driver = new QSQLiteDriver();
              return driver;
          }
          return 0;
      }
      QT_END_NAMESPACE
      #include "smain.moc"
      

      • 文件 2:sqlcipher.pro

      • File 2: sqlcipher.pro

        TARGET = qsqlcipher
        SOURCES = smain.cpp
        OTHER_FILES += sqlcipher.json
        include(../../../sql/drivers/sqlcipher/qsql_sqlite.pri)
        wince*: DEFINES += HAVE_LOCALTIME_S=0
        PLUGIN_CLASS_NAME = QSQLcipherDriverPlugin
        include(../qsqldriverbase.pri)
        

      • 文件 3:sqlcipher.json

      • File 3: sqlcipher.json

        {
            "Keys": [ "QSQLCIPHER" ]
        }
        

      自定义文件C:QtQt5.4.05.4Srcqtbasesrcsqldriverssqlcipherqsql_sqlite.pri
      文件内容如下:

      Customize file C:QtQt5.4.05.4Srcqtbasesrcsqldriverssqlcipherqsql_sqlite.pri
      The content of the file shall be like:

      HEADERS += $$PWD/qsql_sqlite_p.h
      SOURCES += $$PWD/qsql_sqlite.cpp
      !system-sqlite:!contains(LIBS, .*sqlite3.*) {
          include($$PWD/../../../3rdparty/sqlcipher.pri)     #<-- change path of sqlite.pri to sqlcipher.pri here !
      } else {
          LIBS += $$QT_LFLAGS_SQLITE
          QMAKE_CXXFLAGS *= $$QT_CFLAGS_SQLITE
      }
      

      • 此目录中的其余两个文件无需更改.

      • 在目录C:QtQt5.4.05.4Srcqtbasesrc3rdparty中创建文件'sqlcipher.pri'，内容如下:

      • The remaining two files in this directory need not to be changed.

      • Create file 'sqlcipher.pri' in directory C:QtQt5.4.05.4Srcqtbasesrc3rdparty with following content:

        CONFIG(release, debug|release):DEFINES *= NDEBUG
        DEFINES += SQLITE_OMIT_LOAD_EXTENSION SQLITE_OMIT_COMPLETE SQLITE_ENABLE_FTS3 SQLITE_ENABLE_FTS3_PARENTHESIS SQLITE_ENABLE_RTREE SQLITE_HAS_CODEC
        !contains(CONFIG, largefile):DEFINES += SQLITE_DISABLE_LFS
        contains(QT_CONFIG, posix_fallocate):DEFINES += HAVE_POSIX_FALLOCATE=1
        winrt: DEFINES += SQLITE_OS_WINRT
        winphone: DEFINES += SQLITE_WIN32_FILEMAPPING_API=1
        qnx: DEFINES += _QNX_SOURCE
        INCLUDEPATH +=  $$PWD/sqlcipher c:/openssl-win32/include
        SOURCES +=      $$PWD/sqlcipher/sqlite3.c
        LIBS += -L$$PWD/sqlcipher/lib -lsqlcipher -leay32 -lsqlite3
        TR_EXCLUDE += $$PWD/*
        

      • 创建并填充C:QtQt5.4.05.4Srcqtbasesrc3rdpartysqlcipher

        • 创建两个目录:

        • Create the two directories:

        C:QtQt5.4.05.4Srcqtbasesrc3rdpartysqlcipher
        C:QtQt5.4.05.4Srcqtbasesrc3rdpartysqlcipherlib
        

      • 将以下文件复制到C:QtQt5.4.05.4Srcqtbasesrc3rdpartysqlcipher:

        C:	empsqlcipher-mastershell.c
        C:	empsqlcipher-mastersqlite3.c
        C:	empsqlcipher-mastersqlite3.h
        C:	empsqlcipher-mastersqlite3ext.h
        

      • 将以下文件/目录复制到C:QtQt5.4.05.4Srcqtbasesrc3rdpartysqlcipherlib:

        C:	empsqlcipher-masterdistlib
        C:	empsqlcipher-mastersqlite3.dll
        C:OpenSSL-Win32inlibeay32.dll
        

      • 该目录现在包含以下文件和目录:

      • The directory now consists of the following files and directories:

        C:QTQT5.4.05.4SRCQTBASESRC3RDPARTYSQLCIPHER
        |   shell.c
        |   sqlite3.c
        |   sqlite3.h
        |   sqlite3ext.h
        |
        ---lib
            |   libeay32.dll
            |   libsqlcipher.a
            |   libsqlcipher.la
            |   sqlite3.dll
            |
            ---pkgconfig
                    sqlcipher.pc
        

      为 Qt 编译 QSQLCIPHER-driver-plugin:

      Compile the QSQLCIPHER-driver-plugin for Qt:

      • 打开Qt命令行C:WindowsSystem32cmd.exe/A/Q/KC:QtQt5.4.05.4mingw491_32inqtenv2.bat

      • 执行以下命令:

      • Open Qt-command line C:WindowsSystem32cmd.exe /A /Q /K C:QtQt5.4.05.4mingw491_32inqtenv2.bat

      • Execute the following commands:

      cd C:QtQt5.4.05.4Srcqtbasesrcpluinssqldriverssqlcipher
      qmake
      mingw32-make
      

      • 这会在以下目录中构建 QSQLCIPHER-driver-plugin:

      • This builds the QSQLCIPHER-driver-plugin within the following directory:

        C:QTQT5.4.05.4SRCQTBASEPLUGINSSQLDRIVERS
            libqsqlcipher.a
            libqsqlcipherd.a
            qsqlcipher.dll
            qsqlcipherd.dll
        

      • 将qsqlcipher.dll"和qsqlcipherd.dll"复制到SQL-driver-plugin-directory C:QtQt5.4.05.4mingw491_32pluginssqldrivers.莉>

        创建一个新的加密 SQLite/SQLCipher 数据库

        Create a new encrypted SQLite/SQLCipher-database

        • 使用测试表和一些测试数据创建新的 SQLite-Plaintext-database 'plaintext.db'

        • Create new SQLite-Plaintext-database 'plaintext.db' with a test table and some test data

        • 将目录更改为 C:sqlcipher，其中包含sqlcipher.exe"和sqlite3.dll"(见上文).

        • Change directory to C:sqlcipher, which contains 'sqlcipher.exe' and 'sqlite3.dll' (see above).

        C:sqlcipher>sqlcpher.exe plaintext.db
          SQLCipher version 3.8.6 2014-08-15 11:46:33
          Enter ".help" for instructions
          Enter SQL statements terminated with a ";"
          sqlite> create table testtable (id integer, name text);
          sqlite> insert into testtable (id,name) values(1,'Bob');
          sqlite> insert into testtable (id,name) values(2,'Charlie');
          sqlite> insert into testtable (id,name) values(3,'Daphne');
          sqlite> select * from testtable;
          1|Bob
          2|Charlie
          3|Daphne
          sqlite> .exit
        

      加密明文数据库
      这将使用密钥testkey"创建数据库 C:sqlcipherencrypted.db.

      C:sqlcipher>sqlcipher.exe plaintext.db
          SQLCipher version 3.8.6 2014-08-15 11:46:33
          Enter ".help" for instructions
          Enter SQL statements terminated with a ";"
          sqlite> ATTACH DATABASE 'encrypted.db' AS encrypted KEY 'testkey';
          sqlite> SELECT sqlcipher_export('encrypted');
          sqlite> DETACH DATABASE encrypted;
          sqlite> .exit
      

      • 使用标准文本编辑器打开C:sqlcipherencrypted.db:
        数据现已加密.
      • 有关更多有用信息，请访问:
        https://www.zetetic.net/sqlcipher/sqlcipher-api/莉>

        使用 SQLite 数据库和 SQLCipher 扩展并通过 Qt 访问

        Usage of the SQLite-database with SQLCipher-extension and access via Qt

        • 创建一个新的 Qt 命令行项目，例如'qsqlcipher'

        • 项目文件

        • Create a new Qt-command-line-project e.g. 'qsqlcipher'

        • Project file

        QT       += core sql
        QT       -= gui
        TARGET = qsqlcipher
        CONFIG   += console
        CONFIG   -= app_bundle
        TEMPLATE = app
        SOURCES += main.cpp
        

      • 测试程序'main.cpp'

      • Test-program 'main.cpp'

        #include <QCoreApplication>
        #include <QSqlDatabase>
        #include <QSqlQuery>
        #include <QDebug>
        #include <QString>
        int main(int argc, char *argv[]) {
            QCoreApplication a(argc, argv);
            qDebug() << QSqlDatabase::drivers();
            QSqlDatabase db = QSqlDatabase::addDatabase("QSQLCIPHER");
            db.setDatabaseName("C:/sqlcipher/encrypted.db");
            db.open();
            QSqlQuery q;
            q.exec("PRAGMA key = 'testkey';");
            q.exec("insert into testtable (id,name) values(4,'dummy')");
            q.exec("SELECT id,name anz FROM testtable");
            while (q.next()) {
                QString id = q.value(0).toString();
                QString name = q.value(1).toString();
                qDebug() << "id=" << id << ",  name=" << name;
            }
            db.close();
            return 0;
        }
        

      • 编译执行

      • Compile and execute

        ("QSQLCIPHER", "QSQLITE", "QMYSQL", "QMYSQL3", "QODBC", "QODBC3", "QPSQL", "QPSQL7")
        id= "1" ,  name= "Bob"
        id= "2" ,  name= "Charlie"
        id= "3" ,  name= "Daphne"
        id= "4" ,  name= "dummy"
        

      • 在交付 Qt 程序时，不要忘记 Qt 库、平台库、SQL 驱动程序插件qsqlcipher.dll"和 OpenSSL 库libeay32.dll".
        上面测试程序的例子:

      • When delivering a Qt-program do not forget the Qt-libraries, the platforms-libraries, SQL-driver-plugin 'qsqlcipher.dll' and the OpenSSL-library 'libeay32.dll'.
        Example for the test program above:

        C:TEMPQSQLCIPHER-TEST
        |   icudt53.dll
        |   icuin53.dll
        |   icuuc53.dll
        |   libeay32.dll
        |   libgcc_s_dw2-1.dll
        |   libstdc++-6.dll
        |   libwinpthread-1.dll
        |   qsqlcipher.exe
        |   Qt5Core.dll
        |   Qt5Sql.dll
        |
        +---platforms
        |       qminimal.dll
        |       qoffscreen.dll
        |       qwindows.dll
        |
        ---sqldrivers
                qsqlcipher.dll
        

      • 注意:测试程序包含密钥:

      • Caution: The test program contains the key:

        ...
        q.exec("PRAGMA key = 'testkey';");
        ...
        

        测试程序的二进制文件中的这个关键字符串可以使用十六进制编辑器轻松读取，在我看来，这缺乏安全性:

        This key string in the binary file of the test program can easiliy be read using a hex-editor, which is, to my opinion, a lack in security:

        ...
        00002C90  70 68 65 72 2F 65 6E 63 72 79 70 74 65 64 2E 64  pher/encrypted.d
        00002CA0  62 00 50 52 41 47 4D 41 20 6B 65 79 20 3D 20 27  b.PRAGMA key = '
        00002CB0  74 65 73 74 6B 65 79 27 3B 00 00 00 69 6E 73 65  testkey';...inse
        00002CC0  72 74 20 69 6E 74 6F 20 74 65 73 74 74 61 62 6C  rt into testtabl
        ...
        

        有关如何解决此问题的方法，请咨询您自己选择的搜索引擎.;-)
        例如.搜索:在可执行文件中隐藏字符串

        For approaches how to solve this problem, ask the search engine of your own choice. ;-)
        E.g. search for: hide string in executable

        这篇关于如何使用 Windows/MinGW 平台使用 SQLCipher 扩展为 SQLite-DB 构建 Qt-SQL-driver-plugin 'QSQLCIPHER'?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！