Building QMYSQL Plugin with nmake for msvc2017: module machine type 'x86' conflicts with target machine type 'x64'

obradley

Hi, running "qmake -version" in the x64 vs 2017 command prompt from the C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\mysql directory returns:

    QMake version 3.1
    Using Qt version 5.14.2 in C:/Qt/Qt5.14.2/5.14.2/msvc2017/lib

This is the build I'm trying to make the plugin for.

jsulm

@obradley It looks like you MySQL libs are x86, but you're building for x86_64. Make sure you have x86_64 MySQL client libs build.

obradley

According to MySQL installer the version of the MySql Connector/C that I have is for a x64 architecture. The version of Qt that I downloaded is for a x86 architecture. Is there some way I can build for x86?

jsulm

@obradley Do you really want/need to use x86 Qt build? If not simply install x86_64 Qt version.
QtCompany does not provide recent Qt versions as x86 builds as far as I know, so if you would need a recent Qt version you would need to build it by yourself.

obradley

@jsulm said in Building QMYSQL Plugin with nmake for msvc2017: module machine type 'x86' conflicts with target machine type 'x64':

x86_64 Qt

I am using Qt version 5.14.2. As far as I can see from the page http://download.qt.io/archive/qt/5.14/5.14.2/ the only version available for Windows is for x86, at least for the installer. Should I change to a more recent version?

obradley

@jsulm said in Building QMYSQL Plugin with nmake for msvc2017: module machine type 'x86' conflicts with target machine type 'x64':

If not simply install x86_64 Qt version.

Update: I just ran qtdiag in the command prompt and it returned the following:

qt.network.ssl: QSslSocket: cannot resolve SSL_CTX_set_ciphersuites
qt.network.ssl: QSslSocket: cannot resolve SSL_set_psk_use_session_callback
Qt 5.14.2 (i386-little_endian-ilp32 shared (dynamic) release build; by MSVC 2017) on "windows"
OS: Windows 10 Version 1909 [winnt version 10.0.18363]

Architecture: x86_64; features: SSE2 SSE3 SSSE3 SSE4.1 SSE4.2 AVX AVX2

Environment:
  QtMsBuild="C:\Users\OBradley\AppData\Local\QtMsBuild"

Features: QT_NO_EXCEPTIONS

Library info:
  PrefixPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017
  DocumentationPath: C:\Qt\Qt5.14.2\Docs\Qt-5.14.2
  HeadersPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\include
  LibrariesPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\lib
  LibraryExecutablesPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\bin
  BinariesPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\bin
  PluginsPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\plugins
  ImportsPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\imports
  Qml2ImportsPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\qml
  ArchDataPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017
  DataPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017
  TranslationsPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\translations
  ExamplesPath: C:\Qt\Qt5.14.2\Examples\Qt-5.14.2
  TestsPath: C:\Qt\Qt5.14.2\5.14.2\msvc2017\tests
  SettingsPath:

which seems to suggest that I am already using the x86_64 build. Is this not compatible with the x64 build I have for the MySQL C connector?

jsulm

@obradley QtCreator does not matter at all here. What matters is Qt.

Try to start from a clean source tree (without any build artefacts from your previous builds) with "x86 Native Tools Command Prompt for VS2017 and in x64_x86 Cross Tools Command Prompt".

obradley

In order to be sure that there's no lingering dependency issues and a clean build environment I've uninstalled and re-installed both MySQL and Qt. My current SQL server version is 5.6.19 for an x64 architecture, and the C connector is 6.1.3 for x64. I'm reinstalling Qt 5.14.2 for x86_64. I'm then going to rerun the qmake process in x64_x86 Cross Tools Command Prompt. Is that correct?

jsulm

@obradley said in Building QMYSQL Plugin with nmake for msvc2017: module machine type 'x86' conflicts with target machine type 'x64':

Cross Tools Command Prompt

Not sure what you mean by "Cross Command"? Do you mean the Visual Studio command prompt? If so, then yes, that's what you should do.

obradley

@obradley said in Building QMYSQL Plugin with nmake for msvc2017: module machine type 'x86' conflicts with target machine type 'x64':

x64_x86 Cross Tools Command Prompt for VS2017

Ok I've reinstalled both MySQL and Qt and have just repeated steps 1 and 2 in my original question but now inside x64_x86 Cross Tools Command Prompt for VS2017 only for the output to be:

Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
Checking for OCI (Oracle)... no
Checking for ODBC... yes
Checking for PostgreSQL... no
Checking for SQLite (version 2)... no
Checking for TDS (Sybase)... no
Done running configuration tests.

[...]

Should I try a different VS command prompt since it worked in x64 Native Tools Command Prompt for VS2017, or will that just cause the issue to repeat itself?

jsulm

@obradley What does the config.log file says now?

obradley

I've pasted the contents of the log file below:

Command line: "MYSQL_INCDIR=C:/Program Files/MySQL/MySQL Connector C 6.1.3/include" "MYSQL_LIBDIR=C:/Program Files/MySQL/MySQL Connector C 6.1.3/lib"
Global lib dirs: [C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.7.25-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib] ["C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\Community\\VC\\Tools\\MSVC\\14.16.27023\\ATLMFC\\lib\\x86" "C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\Community\\VC\\Tools\\MSVC\\14.16.27023\\lib\\x86" "C:\\Program Files (x86)\\Windows Kits\\NETFXSDK\\4.6.1\\lib\\um\\x86" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.17763.0\\ucrt\\x86" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.17763.0\\um\\x86"]
Global inc dirs: [C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.7.25-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include] ["C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\Community\\VC\\Tools\\MSVC\\14.16.27023\\ATLMFC\\include" "C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\Community\\VC\\Tools\\MSVC\\14.16.27023\\include" "C:\\Program Files (x86)\\Windows Kits\\NETFXSDK\\4.6.1\\include\\um" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.17763.0\\ucrt" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.17763.0\\shared" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.17763.0\\um" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.17763.0\\winrt" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.17763.0\\cppwinrt"]
looking for library db2
Trying source 0 (type inline) of library db2 ...
sqlcli.h not found in [] and global paths.
sqlcli1.h not found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library db2 ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.db2 FAILED
looking for library ibase
Trying source 0 (type inline) of library ibase ...
ibase.h not found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library ibase ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.ibase FAILED
looking for library mysql
Trying source 0 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 1 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 2 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 3 (type mysqlConfig) of library mysql ...
mysql_config not found.
  => source produced no result.
Trying source 4 (type inline) of library mysql ...
  => source failed condition '!config.win32'.
Trying source 5 (type inline) of library mysql ...
+ cd /d C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Qt\Qt5.14.2\5.14.2\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.7.25-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.7.25-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"-LC:/Program Files/MySQL/MySQL Connector C 6.1.3/lib\" -llibmysql" "QMAKE_INCDIR_MYSQL = \"C:/Program Files/MySQL/MySQL Connector C 6.1.3/include\"" C:/Qt/Qt5.14.2/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
> Info: creating stash file C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
+ cd /d C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& nmake
> Microsoft (R) Program Maintenance Utility Version 14.16.27044.0
> Copyright (C) Microsoft Corporation.  All rights reserved.
> 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresqlx86\pgsql\include -I"C:\Program Files\MySQL\MySQL Connector C 6.1.3\include" -IC:\Qt\Qt5.14.2\5.14.2\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\OLIVER~1\AppData\Local\Temp\nm9D9C.tmp
> main.cpp
> 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /OPT:REF /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:mysql.exe @C:\Users\OLIVER~1\AppData\Local\Temp\nmA08B.tmp
> main.obj : error LNK2019: unresolved external symbol _mysql_get_client_version@0 referenced in function _main
> C:\Program Files\MySQL\MySQL Connector C 6.1.3\lib\libmysql.lib : warning LNK4272: library machine type 'x64' conflicts with target machine type 'x86'
> mysql.exe : fatal error LNK1120: 1 unresolved externals
> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.16.27023\bin\HostX64\x86\link.EXE"' : return code '0x460'
> Stop.
 => source failed verification.
Trying source 6 (type inline) of library mysql ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.mysql FAILED
looking for library oci
Trying source 0 (type inline) of library oci ...
oci.h not found in [] and global paths.
  => source produced no result.
Trying source 1 (type inline) of library oci ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.oci FAILED
looking for library odbc
Trying source 0 (type inline) of library odbc ...
+ cd /d C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && C:\Qt\Qt5.14.2\5.14.2\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.7.25-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.7.25-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = -lodbc32" C:/Qt/Qt5.14.2/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
+ cd /d C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& nmake
> Microsoft (R) Program Maintenance Utility Version 14.16.27044.0
> Copyright (C) Microsoft Corporation.  All rights reserved.
> 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\Qt5.14.2\5.14.2\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\OLIVER~1\AppData\Local\Temp\nmA4D0.tmp
> main.cpp
> 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /OPT:REF /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:odbc.exe @C:\Users\OLIVER~1\AppData\Local\Temp\nmA84B.tmp
 => source accepted.
test config.sqldrivers.libraries.odbc succeeded
looking for library psql
Trying source 0 (type pkgConfig) of library psql ...
pkg-config use disabled globally.
  => source produced no result.
Trying source 1 (type psqlConfig) of library psql ...
pg_config not found.
  => source produced no result.
Trying source 2 (type psqlEnv) of library psql ...
libpq-fe.h not found in [] and global paths.
  => source produced no result.
Trying source 3 (type psqlEnv) of library psql ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.psql FAILED
looking for library sqlite2
Trying source 0 (type inline) of library sqlite2 ...
sqlite.h not found in [] and global paths.
  => source produced no result.
test config.sqldrivers.libraries.sqlite2 FAILED
looking for library tds
Trying source 0 (type sybaseEnv) of library tds ...
+ cd /d C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && C:\Qt\Qt5.14.2\5.14.2\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.7.25-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.7.25-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += tds" "QMAKE_LIBS_TDS = -lNTWDBLIB" C:/Qt/Qt5.14.2/5.14.2/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
+ cd /d C:\Qt\Qt5.14.2\5.14.2\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && set MAKEFLAGS=& nmake
> Microsoft (R) Program Maintenance Utility Version 14.16.27044.0
> Copyright (C) Microsoft Corporation.  All rights reserved.
> 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.7.25-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\Qt5.14.2\5.14.2\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\OLIVER~1\AppData\Local\Temp\nmAB87.tmp
> main.cpp
> .\main.cpp(2): fatal error C1083: Cannot open include file: 'sybfront.h': No such file or directory
> NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\VC\Tools\MSVC\14.16.27023\bin\HostX64\x86\cl.EXE"' : return code '0x2'
> Stop.
 => source failed verification.
Trying source 1 (type sybaseEnv) of library tds ...
  => source failed condition '!config.win32'.
test config.sqldrivers.libraries.tds FAILED

jsulm

@obradley said in Building QMYSQL Plugin with nmake for msvc2017: module machine type 'x86' conflicts with target machine type 'x64':

C:\Program Files\MySQL\MySQL Connector C 6.1.3\lib\libmysql.lib : warning LNK4272: library machine type 'x64' conflicts with target machine type 'x86'

You're still mixing x86 and x86_64. I think C:\Program Files\MySQL\MySQL Connector C 6.1.3\lib\libmysql.lib is x86 and not x86_64.

obradley

So I should build with the 86 bit VS command prompt? Apologies for the confusion it's my first time encountering these types of issues

jsulm

@obradley You should build what you want to have. If you need x86_64 build then install x86_64 MySQL Connector version.

SGaist

Hi,

No, you should have your dependencies built for the same architecture are Qt. If you have a 64bit Qt then you need the 64bit version of the connector. There's no way to mix and match libraries built for different architectures.

obradley

Sorry I'm still confused about. The connector I have is x64 according to MySQL installer. The installer which I have for Qt is an x86 installer. Running Qt diag returns that the architechture is x86_64. So does this mean I can use the 64 bit MySQL connector? So instead of running the x64_x86 Cross Tools Command Prompt for VS2017 should I run the x86_x64 Cross Tools Command Prompt for VS2017? This would be an environment initialised for x86_x64? Or do I instead need to find an x86 version of the C connector?

Apologies again for the confusion.

SGaist

The architecture of the installer has nothing to do with the architecture of the Qt versions you installed. The same goes for Qt Creator, it can be x86 or x86_64, it does not matter when it comes to the architecture of the libraries you are using to build your application.

There's no cross-compilation going on: if you have everything as x86_64, just use the 64bit compiler.

obradley

@SGaist said in Building QMYSQL Plugin with nmake for msvc2017: module machine type 'x86' conflicts with target machine type 'x64':

just use the 64bit compiler.

Ok I'm now getting an error : NMAKE : fatal error U1073: don't know how to make 'install'

jsulm

@obradley Did you call nmake before? Please provide more information.