Re: [Mingw-cross-env-list] Problem cross compiling TOra

[Adam Ward]

On 27/09/15 15:21, Tony Theodore wrote:
> > /usr/src/mxe/usr/bin/x86_64-w64-mingw32.static-ar: /machine:X86: No such file 
> > or directory
> /machine:X86 is an msvc flag. There’s a pull request [1] to fix this.
>
> As a starting point, use the new prefixed cmake with these options:
>
> x86_64-w64-mingw32.static-cmake \
>      -DBOOST_ROOT=/usr/src/mxe/usr/x86_64-w64-mingw32.static/include \
>      -DQT5_BUILD=ON \
>      -DENABLE_PGSQL=ON \
>      -DENABLE_DB2=OFF \
>      -DENABLE_TERADATA=OFF \
>      -DWANT_INTERNAL_LOKI=ON \
>      -DWANT_INTERNAL_QSCINTILLA=OFF
>
> You’ll run into an existing tora issue [2] unless you have specified the 
> correct oracle paths. If you get past those, there will likely be mxe issues 
> with cmake and static Qt linking [3] that will hopefully be resolved soon. 
> Maybe try the shared builds instead in the mean time.
>
> Cheers,
>
> Tony
>
>
> [1] https://github.com/tora-tool/tora/pull/13
> [2] https://github.com/tora-tool/tora/issues/4
> [3] https://github.com/mxe/mxe/issues/852

The pull request is complete.
In my VM, I have done builds for both i686 and x86_64, static and shared 
for both, for qt5, boost, qscintilla2, and db.

The Qt5 libraries are found using your suggested cmake binary path 
without needing to reference the cmake cross build tool chain.

I have also installed the 64bit Oracle client (see file list after the 
cmake output), but it cmake does not find it.
Using these Oracle paths works for the native linux build.

Let me know if I need to provide other information to resolve this.

address@hidden:~/tora3/DBUILD$ 
/usr/src/mxe/usr/bin/x86_64-w64-mingw32.static-cmake 
-DBOOST_ROOT=/usr/src/mxe/usr/x86_64-w64-mingw32.static/include 
-DQT5_BUILD=ON -DORACLE_PATH_LIB=/usr/lib/oracle/11.2/client64/lib 
-DORACLE_PATH_INCLUDES=/usr/include/oracle/11.2/client64 
-DWANT_INTERNAL_LOKI=ON -DENABLE_TERADATA=OFF -DCMAKE_BUILD_TYPE=Debug   ..
-- Could NOT find Subversion (missing:  Subversion_SVN_EXECUTABLE)
-- Found Git: /usr/bin/git (found version "2.1.4")
-- Boost version: 1.57.0
-- The C compiler identification is GNU 5.2.0
-- The CXX compiler identification is GNU 5.2.0
-- Check for working C compiler: 
/usr/src/mxe/usr/bin/x86_64-w64-mingw32.static-gcc
-- Check for working C compiler: 
/usr/src/mxe/usr/bin/x86_64-w64-mingw32.static-gcc -- works
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working CXX compiler: 
/usr/src/mxe/usr/bin/x86_64-w64-mingw32.static-g++
-- Check for working CXX compiler: 
/usr/src/mxe/usr/bin/x86_64-w64-mingw32.static-g++ -- works
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- TOra 3.0.0alpha will be built to install into 
/usr/src/mxe/usr/x86_64-w64-mingw32.static
--
-- LIB_SUFFIX variable is not defined. It will be autodetected now.
-- You can set it manually with -DLIB_SUFFIX=<value> (64 for example)
-- CMAKE_SIZEOF_VOID_P=8
--  LIB_SUFFIX is set to '64'
--
-- non-debug build
-- Using internal loki: /home/toradev/tora3/extlibs/loki/include
Qt Found OK
CMake Warning at cmake/modules/FindQScintilla.cmake:85 (MESSAGE):
  LIBPATH
"/usr/src/mxe/usr/x86_64-w64-mingw32.static/qt5/lib;/usr/lib/;/usr/local/lib"
Call Stack (most recent call first):
  CMakeLists.txt:232 (FIND_PACKAGE)


-- Found QScintilla2: 
/usr/src/mxe/usr/x86_64-w64-mingw32.static/qt5/lib/libqscintilla2.a
--          includes: 
/usr/src/mxe/usr/x86_64-w64-mingw32.static/qt5/include/Qsci
QScintilla2 Found OK
-- ORACLE_LIBRARY_CLNTSH
-- ORACLE_LIBRARY_OCCI
-- ORACLE_LIBRARY_XML
-- ORACLE_LIBRARY_OCIEI
-- Found Oracle:  (ORACLE_HOME='')
--     includes: ORACLE_INCLUDES-NOTFOUND
-- Found XML Oracle:
-- Oracle not found.
-- Oracle: You can specify includes: 
-DORACLE_PATH_INCLUDES=/usr/include/oracle/10.2.0.3/client
--    currently found includes: ORACLE_INCLUDES-NOTFOUND
-- Oracle: You can specify libs: 
-DORACLE_PATH_LIB=/usr/lib/oracle/10.2.0.3/client/lib
--    currently found libs:
-- No Oracle OCI found. TOra will be build without Oracle support
-- Found PostgreSQL: /usr/src/mxe/usr/x86_64-w64-mingw32.static/include
-- PostgreSQL environment found: 
/usr/src/mxe/usr/x86_64-w64-mingw32.static/include 
/usr/src/mxe/usr/x86_64-w64-mingw32.static/lib/libpq.a
-- DB2 not found.
-- DB2: You can specify includes: -DDB2_PATH_INCLUDES=/opt/db2/V9.5/includes
--      currently found includes: DB2_INCLUDES-NOTFOUND
-- DB2: You can specify libs: -DDB2_PATH_LIB=/opt/db2/V9.5/lib64
--      currently found libs: DB2_LIBRARY_LIBDB2-NOTFOUND

--  No DB2 client libraries have been found.
--  TOra can be build without it - without DB2 support.
--  Specify -DDB2_PATH_INCLUDES=path
--      and -DDB2_PATH_LIB=path manually

-- Teradata support disabled (enable with -DENABLE_TERADATA=on)
-- Could NOT find Doxygen (missing:  DOXYGEN_EXECUTABLE)
-- Configuring done
-- Generating done
-- Build files have been written to: /home/toradev/tora3/DBUILD



Oracle client is installed:
/usr/include/oracle
/usr/include/oracle/11.2
/usr/include/oracle/11.2/client64
/usr/include/oracle/11.2/client64/ldap.h
/usr/include/oracle/11.2/client64/nzerror.h
/usr/include/oracle/11.2/client64/nzt.h
/usr/include/oracle/11.2/client64/occi.h
/usr/include/oracle/11.2/client64/occiAQ.h
/usr/include/oracle/11.2/client64/occiCommon.h
/usr/include/oracle/11.2/client64/occiControl.h
/usr/include/oracle/11.2/client64/occiData.h
/usr/include/oracle/11.2/client64/occiObjects.h
/usr/include/oracle/11.2/client64/oci.h
/usr/include/oracle/11.2/client64/oci1.h
/usr/include/oracle/11.2/client64/oci8dp.h
/usr/include/oracle/11.2/client64/ociap.h
/usr/include/oracle/11.2/client64/ociapr.h
/usr/include/oracle/11.2/client64/ocidef.h
/usr/include/oracle/11.2/client64/ocidem.h
/usr/include/oracle/11.2/client64/ocidfn.h
/usr/include/oracle/11.2/client64/ociextp.h
/usr/include/oracle/11.2/client64/ocikpr.h
/usr/include/oracle/11.2/client64/ocixmldb.h
/usr/include/oracle/11.2/client64/ocixstream.h
/usr/include/oracle/11.2/client64/odci.h
/usr/include/oracle/11.2/client64/oratypes.h
/usr/include/oracle/11.2/client64/ori.h
/usr/include/oracle/11.2/client64/orid.h
/usr/include/oracle/11.2/client64/orl.h
/usr/include/oracle/11.2/client64/oro.h
/usr/include/oracle/11.2/client64/ort.h
/usr/include/oracle/11.2/client64/xa.h
/usr/lib/oracle
/usr/lib/oracle/11.2
/usr/lib/oracle/11.2/client64
/usr/lib/oracle/11.2/client64/bin
/usr/lib/oracle/11.2/client64/lib
/usr/lib/oracle/11.2/client64/bin/adrci
/usr/lib/oracle/11.2/client64/bin/genezi
/usr/lib/oracle/11.2/client64/lib/libclntsh.so
/usr/lib/oracle/11.2/client64/lib/libclntsh.so.11.1
/usr/lib/oracle/11.2/client64/lib/libnnz11.so
/usr/lib/oracle/11.2/client64/lib/libocci.so
/usr/lib/oracle/11.2/client64/lib/libocci.so.11.1
/usr/lib/oracle/11.2/client64/lib/libociei.so
/usr/lib/oracle/11.2/client64/lib/libocijdbc11.so
/usr/lib/oracle/11.2/client64/lib/ojdbc5.jar
/usr/lib/oracle/11.2/client64/lib/ojdbc6.jar
/usr/lib/oracle/11.2/client64/lib/ottclasses.zip
/usr/lib/oracle/11.2/client64/lib/xstreams.jar
/usr/share/oracle
/usr/share/doc/oracle-instantclient11.2-basic
/usr/share/doc/oracle-instantclient11.2-devel
/usr/share/doc/oracle-instantclient11.2-basic/changelog.Debian.gz
/usr/share/doc/oracle-instantclient11.2-basic/copyright
/usr/share/doc/oracle-instantclient11.2-devel/changelog.Debian.gz
/usr/share/doc/oracle-instantclient11.2-devel/copyright
/usr/share/nmap/nselib/data/oracle-default-accounts.lst
/usr/share/nmap/nselib/data/oracle-sids
/usr/share/nmap/scripts/oracle-brute-stealth.nse
/usr/share/nmap/scripts/oracle-brute.nse
/usr/share/nmap/scripts/oracle-enum-users.nse
/usr/share/nmap/scripts/oracle-sid-brute.nse
/usr/share/oracle/11.2
/usr/share/oracle/11.2/client64
/usr/share/oracle/11.2/client64/cdemo81.c
/usr/share/oracle/11.2/client64/demo.mk
/usr/share/oracle/11.2/client64/occidemo.sql
/usr/share/oracle/11.2/client64/occidemod.sql
/usr/share/oracle/11.2/client64/occidml.cpp
/usr/share/oracle/11.2/client64/occiobj.cpp
/usr/share/oracle/11.2/client64/occiobj.typ
/usr/share/oracle/11.2/client64/ott
/var/lib/dpkg/info/oracle-instantclient11.2-basic.list
/var/lib/dpkg/info/oracle-instantclient11.2-basic.md5sums
/var/lib/dpkg/info/oracle-instantclient11.2-basic.postinst
/var/lib/dpkg/info/oracle-instantclient11.2-basic.postrm
/var/lib/dpkg/info/oracle-instantclient11.2-basic.shlibs
/var/lib/dpkg/info/oracle-instantclient11.2-devel.list
/var/lib/dpkg/info/oracle-instantclient11.2-devel.md5sums