[SOLVED]can't find the "src" directory to build my QPSQL driver

clochydd

Hi k_arnaud,

I wrote a small tutorial for setting up Qt5.2.1/mingw + PostgreSQL 32-Bit on Win7 - hope it will help:

Prepare compiling of the plugin (Lets assume we install Qt + Sources to C:\Qt, PostgresSQL to C:\Programs(86x)):
Download Qt 5.2.1 32-bit: http://download.qt-project.org/official_releases/qt/5.2/5.2.1/qt-opensource-windows-x86-mingw48_opengl-5.2.1.exe
Run the .exe, install to C:\Qt\Qt5.2.1
Download sources: http://download.qt-project.org/official_releases/qt/5.2/5.2.1/single/qt-everywhere-opensource-src-5.2.1.zip
Extract zip to C:\Qt\Qt5.2.1
Download PostGreSQL 32-bit: http://www.enterprisedb.com/postgresql-932-1-installers-win32?ls=Crossover&type=Crossover
Modify PATH:
set QTSDK_SQLDRIVERS_PATH=C:\Qt\Qt5.2.1\5.2.1\mingw48_32\plugins\sqldrivers
set QT_SRC_PATH=C:\Qt\Qt5.2.1\5.2.1\Src\qtbase
set POSTGRES32=C:\Progra~2\PostgreSQL\9.3 (USE Progra~2 FOR Programs(86x)!)
cd QT_SRC_PATH\src\plugins\sqldrivers\psql
add permanently to PATH (Control Panel): C:\Qt\Qt5.2.1\Tools\mingw48_32\bin
modify C:\Progra~2\PostgreSQL\9.3\include\pthread.h (multiple definitions of struct timespec):
replace: #ifndef HAVE_STRUCT_TIMESPEC
with: #if ((!defined(_TIMESPEC_DEFINED)) && (!defined(HAVE_STRUCT_TIMESPEC)))
start building the plugins:
C:\Qt\Qt5.2.1\5.2.1\mingw48_32\bin\qmake “INCLUDEPATH+=%POSTGRES32%\include” “LIBS+=%POSTGRES32%\lib\libpq.lib” psql.pro
mingw32-make debug
mingw32-make release
copy the newly created plugins to C:\Qt\Qt5.2.1\5.2.1\mingw48_32\plugins\sqldrivers:
copy release\libqsqlpsql.a QTSDK_SQLDRIVERS_PATH
copy release\qsqlpsql.dll QTSDK_SQLDRIVERS_PATH
copy debug\libqsqlpsqld.a QTSDK_SQLDRIVERS_PATH
copy debug\qsqlpsqld.dll QTSDK_SQLDRIVERS_PATH

k_arnaud

ok thank Clochydd Clochydd i'll try, but i've a Windows 8 64 bit and PostgreSQL9.3 64 bits. I do hope it will work.
thank !

clochydd

Then you can only use this tutorial as a very rough guide as you do not work with the 32-Bit mingw, too.

k_arnaud

Hi Clochydd Clochydd
i downloaded PostgreSQL 32 bit and i tried to follow what you've written. but i can't undersdands the #7, when you say . " Modify PATH:
set QTSDK_SQLDRIVERS_PATH=C:\Qt\Qt5.2.0\5.2.1\mingw48_32\plugins\sqldrivers
set QT_SRC_PATH=C:\Qt\Qt5.2.1\5.2.1\Src\qtbase
set POSTGRES32=C:\Progra~2\PostgreSQL\9.3 (USE Progra~2 FOR Programs(86x)!)" and more of the following

when you asked me to run the .exe installed in Qt installed dir, did you mean Qt creator ? if not which .exe i should run ? thanks

clochydd

Hi k_arnaud,
sorry, I made a mistake: It should read "Modify environment" as the variables have to be added. You should set these entries in the CMD-window and have a look at the correct paths - relating to your system.

k_arnaud

ok, but when you said run the .exe, do you mean Qt creator ?

clochydd

I'm sorry but I do not understand. What do you mean with run the .exe?

k_arnaud

about the #11 i've installed Qt with msvc2010 not mingw32

clochydd

If you have installed with msvc2010 you cannot work with the 32-Bit postgres. I never worked with msvc2010.

k_arnaud

ok i'll try with mingw32. thanks

k_arnaud

Hi Clochydd, i've downloaded Qt with mingw32...
About the #11 here is the error message i get: "cannot find file psql.pro"

clochydd

Hi k_arnaud, the message says that the project file for building the plugin cannot be found.
Did you go to the plugins directory:
8. cd QT_SRC_PATH\src\plugins\sqldrivers\psql
If so, does the psql.pro exist here?

k_arnaud

after entering mingw32-make debug , in the unreadable message i get, i can see makefile:48: recipe for target 'debug' failed and i get the same with release

clochydd

You should check your pathnames again - it seems that dependencies cannot be found. If you cannot find a fault: What is the unreadable message?

k_arnaud

may be the problem is from here QTSDK_SQLDRIVERS_PATH=C:\Qt\Qt5.2.0\5.2.1\mingw48_32\plugins\sqldrivers i don't know wehter i should replace "QTSDK_SQLDRIVERS_PATH" with anything

clochydd

Hi k_arnaud, with "set QTSDK_SQLDRIVERS_PATH=C:\Qt\Qt5.2.0\5.2.1\mingw48_32\plugins\sqldrivers" you create the environment-variable QTSDK_SQLDRIVERS_PATH, which you need later (#12.). Where appropriate you must modify the path itself - according to your system.
These variables are for your comfort - you may use the complete pathname instead.

k_arnaud

that is what i did, i entered QTSDK_SQLDRIVERS_PATH=C:\Qt\Qt5.2.0\5.2.1\mingw48_32\plugins\sqldrivers in the CMD-windows without any change

clochydd

maybe a silly question: did you enter "set QTSDK..." and is that visible in your environment if you type SET in the cmd?

k_arnaud

No, i ca'nt see that

clochydd

But - do you use SET to bring it to the environment?