[esp-r] Re: The native Windows copy of ESP-r

[Jon Hand]

The SQLite option is one that I have never used. Build fails are usually because
of missing sql libraries and development headers.  I say no to the option and the build is ok.  

And perhaps someone out there could illuminate how they use the SQL facilities in their work?
It might be really useful - but I have not had time to explore it....  -Jon Hand
________________________________________
From: lolcocks lolcocks [lolcocks123 at yandex.com]
Sent: 22 April 2016 16:39
To: Jon Hand; Raghuram Kalyanam
Cc: esp-r at lists.strath.ac.uk
Subject: Re: [esp-r] Re: The native Windows copy of ESP-r

Thank you so much, I have been trying this whole day, I fixed most of the errors that I got, I am having only one final error which I am unable to fix.
While compiling I get an error where I am unable to build enableSQLite or disableSQLite depending upon if I choose to use experimental SQLite or not.



Error:

 Installing ESP-r system. This may take some time.
 Moving to /home/Administrator/Src/ESP-rCentral/src...
    - gathering version information (git)...
    - building enableSQLite...
 ERROR: could not build executable enableSQLite!
 ERROR: result /home/Administrator/Src/ESP-rCentral/src/lib/libSQLite.a!
 Compilation messages follow:
 -----------------------------------------
Compilation of enableSQLite on Fri, Apr 22, 2016  9:00:21 PM
 Make command:
 -------------
   make MCTYPE=mingw MCC=gcc MCPL=g++ MFC=gfortran DESTdir=C:/ESRU ESPdir=C:/ESRU/esp-r WWLINK=unshared EXE=.exe XINSTALLDIR=-mms-bitfields -pthread -mms-bitfields -IC:/msys64/mingw64/include/gtk-2.0 -IC:/msys64/mingw64/lib/gtk-2.0/include -IC:/msys64/mingw64/include/pango-1.0 -IC:/msys64/mingw64/include/cairo -IC:/msys64/mingw64/include/atk-1.0 -IC:/msys64/mingw64/include/cairo -IC:/msys64/mingw64/include/pixman-1 -IC:/msys64/mingw64/include -IC:/msys64/mingw64/include/freetype2 -IC:/msys64/mingw64/include/libpng16 -IC:/msys64/mingw64/include/harfbuzz -IC:/msys64/mingw64/include/glib-2.0 -IC:/msys64/mingw64/lib/glib-2.0/include -IC:/msys64/mingw64/include -IC:/msys64/mingw64/include/freetype2 -IC:/msys64/mingw64/include -IC:/msys64/mingw64/include/harfbuzz -IC:/msys64/mingw64/include/libpng16 -IC:/msys64/mingw64/include/gdk-pixbuf-2.0 -IC:/msys64/mingw64/include/libpng16 -IC:/msys64/mingw64/include/glib-2.0 -IC:/msys64/mingw64/lib/glib-2.0/include -IC:/msys64/mingw64/include -LC:/msys64/mingw64/lib -lgtk-win32-2.0 -lgdk-win32-2.0 -lgdi32 -limm32 -lshell32 -lole32 -Wl,-luuid -lpangowin32-1.0 -lpangocairo-1.0 -lpango-1.0 -latk-1.0 -lcairo -lgdk_pixbuf-2.0 -lgio-2.0 -lgobject-2.0 -lglib-2.0 -lintl CFLAGS=-I../include -I../shocc -I/usr/local/include -I../cetc/h3kreports -I/usr/include -I/usr/include/libxml2 -I/usr/local/include/libxml2 -I/usr/include/libxslt -I/local/include/libxslt -DMINGW -DGTK -DXSL -DSQLITE -g -mwindows -mms-bitfields FFLAGS=-I../include -I../shocc -I/usr/local/include -I../cetc/h3kreports -DMINGW -DGTK -g -fno-automatic -DGCC4 -mwindows -mms-bitfields LD_FLAGS=-DMINGW -Wl,--reduce-memory-overheads ULIBS=-L/home/Administrator/Src/ESP-rCentral/src/lib -L/usr/local/lib -L/local/lib -L/usr/lib -lversion -lgtkesru -L-mms-bitfields -pthread -mms-bitfields -IC:/msys64/mingw64/include/gtk-2.0 -IC:/msys64/mingw64/lib/gtk-2.0/include -IC:/msys64/mingw64/include/pango-1.0 -IC:/msys64/mingw64/include/cairo -IC:/msys64/mingw64/include/atk-1.0 -IC:/msys64/mingw64/include/cairo -IC:/msys64/mingw64/include/pixman-1 -IC:/msys64/mingw64/include -IC:/msys64/mingw64/include/freetype2 -IC:/msys64/mingw64/include/libpng16 -IC:/msys64/mingw64/include/harfbuzz -IC:/msys64/mingw64/include/glib-2.0 -IC:/msys64/mingw64/lib/glib-2.0/include -IC:/msys64/mingw64/include -IC:/msys64/mingw64/include/freetype2 -IC:/msys64/mingw64/include -IC:/msys64/mingw64/include/harfbuzz -IC:/msys64/mingw64/include/libpng16 -IC:/msys64/mingw64/include/gdk-pixbuf-2.0 -IC:/msys64/mingw64/include/libpng16 -IC:/msys64/mingw64/include/glib-2.0 -IC:/msys64/mingw64/lib/glib-2.0/include -IC:/msys64/mingw64/include -LC:/msys64/mingw64/lib -lgtk-win32-2.0 -lgdk-win32-2.0 -lgdi32 -limm32 -lshell32 -lole32 -Wl,-luuid -lpangowin32-1.0 -lpangocairo-1.0 -lpango-1.0 -latk-1.0 -lcairo -lgdk_pixbuf-2.0 -lgio-2.0 -lgobject-2.0 -lglib-2.0 -lintl -lXML -lstdc++ -lxslt -lxml2 -lws2_32 -L/usr/local/lib -lSQLite -lsqlite3 -lstdc++ -lws2_32 xml_status= SQLite_status= -f Makefile  enableSQLite >>.make_msg 2>&1

 Make output:
 ------------
cd `pwd`/lib; \
make the_libSQLite
make[1]: Entering directory '/home/Administrator/Src/ESP-rCentral/src/lib'
rm -f DBManager.cpp ;
ln -s `pwd`/../cetc/h3kreports/DBManager.cpp .;
g++ -DMINGW -Wl,--reduce-memory-overheads -I../include -I../shocc -I/usr/local/include -I../cetc/h3kreports -I/usr/include -I/usr/include/libxml2 -I/usr/local/include/libxml2 -I/usr/include/libxslt -I/local/include/libxslt  -DMINGW -DGTK -DXSL -DSQLITE -g  -mwindows -mms-bitfields -c DBManager.cpp
In file included from DBManager.cpp:1:0:
../cetc/h3kreports/DBManager.h:9:21: fatal error: sqlite3.h: No such file or directory
compilation terminated.
Makefile:181: recipe for target 'DBManager.o' failed
make[1]: *** [DBManager.o] Error 1
make[1]: Leaving directory '/home/Administrator/Src/ESP-rCentral/src/lib'
Makefile:38: recipe for target 'enableSQLite' failed
make: *** [enableSQLite] Error 2
 -----------------------------------------
 Install: Fatal error.
 Executable enableSQLite could not be built!
 Installation aborted.



I found this:
http://lists.strath.ac.uk/archives/esp-r/2014/003148.html

But it wasn't of much help, I already have got the source from GitHub.

I have no idea why this is happening.
Can any of you folks help me out with this one?

Thank you.







22.04.2016, 02:11, "Jon Hand" <jon at esru.strath.ac.uk>:
> Here are some detailed instructions for doing the build-from-source of ESP-r on Windows.
>
> -Jon
>
> ________________________________________
> From: esp-r-bounces at lists.strath.ac.uk [esp-r-bounces at lists.strath.ac.uk] on behalf of Raghuram Kalyanam [kalyanam at rhrk.uni-kl.de]
> Sent: 21 April 2016 18:18
> To: lolcocks lolcocks
> Cc: esp-r at lists.strath.ac.uk
> Subject: [esp-r] Re: The native Windows copy of ESP-r
>
> Try it with Msys2 it will work. Install gcc, gfortran & make with pacman.
>
> Best Regards,
> Raghu
>
>>  On Apr 21, 2016, at 6:52 PM, lolcocks lolcocks <lolcocks123 at yandex.com> wrote:
>>
>>  Does anyone have the working native Windows copy of the ESP-r software?
>>
>>  I tried building it from source for Cygwin but that didn't workout quite well for me.
>>
>>  Thank you.
>>
>>  _______________________________________________
>>  esp-r mailing list
>>  esp-r at lists.strath.ac.uk
>>  http://lists.strath.ac.uk/mailman/listinfo/esp-r
>
> _______________________________________________
> esp-r mailing list
> esp-r at lists.strath.ac.uk
> http://lists.strath.ac.uk/mailman/listinfo/esp-r