QPSQL Plugin on Windows

TheBadger

what is the exact command that you executed? Something like the following should work:
@

qmake "INCLUDEPATH+=C:/psql/include" "LIBS+=C:/psql/lib/ms/libpq.lib" psql.pro
@

Or

@

qmake "INCLUDEPATH+=C:\psql\include" "LIBS+=C:\psql\lib\ms\libpq.lib" psql.pro
@

I have been using the second one for my PostgreSQL plugin for long now without any problems.

angelicaP

thanks for helping me with your precious comments;
please have a look below on my input and my output:

C:\Qt\Qt5.0.2\5.0.2>cd src\qtbase\src\plugins\sqldrivers\psql

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>qmake "INCLUDEPATH+=C
:\program files\postgresql\9.2\include" "LIBS+=C:\program files\postgresql
\9.2\lib\libpq.lib" psql.pro

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>mingw32-make

mingw32-make -f Makefile.Release all
mingw32-make[1]: Entering directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/
sqldrivers/psql'
g++ -c -pipe -fno-keep-inline-dllexport -O2 -std=c++0x -fno-exceptions -frtti -W
all -Wextra -DUNICODE -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCE
PTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -I"C:\program" -
I"files\postgresql\9.2\include" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include" -I"C:
\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\in
clude\QtSql\5.0.2" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql\5.0.2\QtSql"
-I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtCore" -I".moc\release_shared" -I"..
......\mkspecs\win32-g++" -o .obj\release_shared\qsql_psql.o ......\sql\driv
ers\psql\qsql_psql.cpp
......\sql\drivers\psql\qsql_psql.cpp:58:22: fatal error: libpq-fe.h: No such
file or directory
compilation terminated.
Makefile.Release:483: recipe for target '.obj/release_shared/qsql_psql.o' failed

mingw32-make[1]: *** [.obj/release_shared/qsql_psql.o] Error 1
mingw32-make[1]: Leaving directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/s
qldrivers/psql'
makefile:38: recipe for target 'release-all' failed
mingw32-make: *** [release-all] Error 2

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>

i think this is not much different from my previous post. SGaist suggested:
"Search where is libqp-fe.h located and add that path either in INCLUDEPATH in psql.pro or when running qmake"

and i said that "i couldn’t find any libqp-fe.h neither in the postgresql directory, nor in QT. "
i don't have this file.

i think worth to mentioned is the path ....C:\psql\lib\ms\libpq.lib" psql.pro. this folder "ms" is missing. the file libpq.lib is located directly in folder "lib". so i skipped this folder in my command.

any idea how to continue, and install this psql driver for QT?
thanks for your input.

SGaist

If possible, reinstall postgresql in a path without spaces, that will make you life easier. Otherwise you have to give the old 8.3 name to avoid the space problem.

TheBadger

Here is your problem:
[quote author="avpro" date="1370459887"]
C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>qmake "INCLUDEPATH+=C
:\program files\postgresql\9.2\include" "LIBS+=C:\program files\postgresql
\9.2\lib\libpq.lib" psql.pro
...

-I"C:\program" -I"files\postgresql\9.2\include"

[/quote]
Because there is spaces in the path to your PostgreSQL install and you did not escape it properly (a user commented on how to handle spaces) the compiler splits your include path at the space and include the above 2 paths, instead of the one that you wanted.

So the solution is to either use this comment (read up on the "$$quote()":http://qt-project.org/doc/qt-4.8/qmake-function-reference.html#quote-string command):
[quote author="Hostel" date="1370131524"]You have a spaces in includepath to pg(Program Files for example). From command line try this:
@
qmake "INCLUDEPATH+=$$quote("path to include") ...
@
[/quote]

Or the one that I would follow, and the easiest one for future:

[quote author="SGaist" date="1370460739"]If possible, reinstall postgresql in a path without spaces, that will make you life easier. Otherwise you have to give the old 8.3 name to avoid the space problem.[/quote]

angelicaP

I come back with more details:

bq.
If possible, reinstall postgresql in a path without spaces, that will make you life easier. Otherwise you have to give the old 8.3 name to avoid the space problem.

I reinstalled Posgresql in a folder without spaces.

i run the qmake command once again, and after the mingw32-make.
this is what it resulted:

C:\Qt\Qt5.0.2\5.0.2>cd src\qtbase\src\plugins\sqldrivers\psql

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>qmake "INCLUDEPATH+=c
:\postgresql\9.2\include" "LIBS+=c:\postgresql\9.2\lib\libpq.lib" psql.pro

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>mingw32-make
mingw32-make -f Makefile.Release all
mingw32-make[1]: Entering directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/
sqldrivers/psql'
g++ -c -pipe -fno-keep-inline-dllexport -O2 -std=c++0x -fno-exceptions -frtti -W
all -Wextra -DUNICODE -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCE
PTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -I"C:\postgresql
\9.2\include" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include" -I"C:\Qt\Qt5.0.2\5.0.2
mingw47_32\include\QtSql" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql\5.0.2"
-I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql\5.0.2\QtSql" -I"C:\Qt\Qt5.0.2\5
.0.2\mingw47_32\include\QtCore" -I".moc\release_shared" -I"........\mkspecs\w
in32-g++" -o .obj\release_shared\qsql_psql.o ......\sql\drivers\psql\qsql_psql
.cpp
In file included from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/i686-w64-mingw32/bits/gthr-default.h:41:0,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/i686-w64-mingw32/bits/gthr.h:150,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/ext/atomicity.h:34,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/bits/basic_string.h:41,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/string:54,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/random:41,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/bits/stl_algo.h:67,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/algorithm:63,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtCore/qglobal.h:80
,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtCore/qatomic.h:42
,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtCore/qvariant.h:4
5,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtSql/qsqlresult.h:
45,
from ......\sql\drivers\psql\qsql_psql.h:45,
from ......\sql\drivers\psql\qsql_psql.cpp:42:
C:\postgresql\9.2\include/pthread.h:307:8: error: redefinition of 'struct timesp
ec'
In file included from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/../../../../i686-w64-mingw32/include/time.h:277:0,
from C:\postgresql\9.2\include/pthread.h:218,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/i686-w64-mingw32/bits/gthr-default.h:41,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/i686-w64-mingw32/bits/gthr.h:150,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/ext/atomicity.h:34,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/bits/basic_string.h:41,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/string:54,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/random:41,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/bits/stl_algo.h:67,
from c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/
4.7.2/include/c++/algorithm:63,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtCore/qglobal.h:80
,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtCore/qatomic.h:42
,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtCore/qvariant.h:4
5,
from C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include/QtSql/qsqlresult.h:
45,
from ......\sql\drivers\psql\qsql_psql.h:45,
from ......\sql\drivers\psql\qsql_psql.cpp:42:
c:\qt\qt5.0.2\tools\mingw\bin../lib/gcc/i686-w64-mingw32/4.7.2/../../../../i686
-w64-mingw32/include/sys/timeb.h:90:8: error: previous definition of 'struct tim
espec'
Makefile.Release:486: recipe for target '.obj/release_shared/qsql_psql.o' failed

mingw32-make[1]: *** [.obj/release_shared/qsql_psql.o] Error 1
mingw32-make[1]: Leaving directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/s
qldrivers/psql'
makefile:38: recipe for target 'release-all' failed
mingw32-make: *** [release-all] Error 2

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>

the error is: error: previous definition of 'struct timespec'

any idea how this could be resolved?

i found "here":https://bugreports.qt-project.org/browse/QTBUG-9032?actionOrder=desc this report, but i think is for linux.
any experience how to step over this error?

thank you all.

angelicaP

hi,

i would like to restart the thread. in this moment i'm in the following point:

i reinstalled PostgreSQL in "C:\psql" to avoid any problems which might come up if Postgresql is installed in "space" separated path, like "C:\Program Files".
i copied libpq-fe.h, pg_config.h and postgres_ext.h from "c:\psql\include" to "C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql"
i followed the procedure described "here":http://qt-project.org/doc/qt-4.8/sql-driver.html#qpsql to create the QPSQL plugin
i replaced "nmake" with "mingw32-make" because i have the MinGw compiler.

Note: the commands are run from Qt's command line prepared by Qt installer.

this is the output:

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>mingw32-make
mingw32-make
-f Makefile.Release all
mingw32-make[1]:
Entering directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/
sqldrivers/psql'
g++ -Wl,-s
-shared -Wl,--out-implib,C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\plugins\sqldr
ivers\libqsqlpsql.a
-o ........\plugins\sqldrivers\qsqlpsql.dll .obj/release_
shared/main.o
.obj/release_shared/qsql_psql.o .obj/release_shared/moc_qsql_psql.
o -lpq -LC:\Qt\Qt5.0.2\5.0.2\mingw47_32\lib
-lQt5Sql -lQt5Core
c:/qt/qt5.0.2/tools/mingw/bin/../lib/gcc/i686-w64-mingw32/4.7.2/../../../../i686
-w64-mingw32/bin/ld.exe:
cannot find -lpq
collect2.exe:
error: ld returned 1 exit status
Makefile.Release:80:
recipe for target '........\plugins\sqldrivers\qsqlpsql.
dll' failed
mingw32-make[1]:
[........\plugins\sqldrivers\qsqlpsql.dll] Error 1
mingw32-make[1]:
Leaving directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/s
qldrivers/psql'
makefile:38:
recipe for target 'release-all' failed
mingw32-make:
[release-all] Error 2

any idea what is wrong?
thank you.

SGaist

Did you put somewhere the path to libpq ?

angelicaP

you mean if I set up the user Environmental Variables?
yes, i did that too, for c:\psql\lib

angelicaP

are you referring to your previous post
bq. Search where is libqp-fe.h located and add that path either in INCLUDEPATH in psql.pro or when running qmake

sorry, i'm not sure if i understand correctly: bq. Did you put somewhere the path to libpq ?
could you please try once again?
thanks.

SGaist

Sorry,
Did you also do something like:
@LIBS+=-LC:/psql/folder_where_libqp_can_be_found@

in your pro file ?

angelicaP

not yet, but i will give a try

angelicaP

i integrated the LIBS+=-LC:/psql/folder_where_libqp_can_be_found
in my psql.pro file like this:

TARGET = qsqlpsql

SOURCES = main.cpp
OTHER_FILES += psql.json
include(../../../sql/drivers/psql/qsql_psql.pri)

PLUGIN_CLASS_NAME = QPSQLDriverPlugin
include(../qsqldriverbase.pri)
LIBS+=-LC:/psql/lib

and got this output, surprisingly without errors; but the "driver not loaded" error still comes as soon as I test with
@qDebug() << "Error = " << db.lastError().text();@

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>mingw32-make
C:\Qt\Qt5.0.2\5.0.2\mingw47_32\bin\qmake.exe "INCLUDEPATH+=C:\psql\includeö ôL
IBS+=c:\psql\lib\libpq.libö psql.pro" -o Makefile psql.pro
mingw32-make -f Makefile.Release all
mingw32-make[1]: Entering directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/
sqldrivers/psql'
g++ -Wl,-s -shared -Wl,--out-implib,C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\plugins\sqldr
ivers\libqsqlpsql.a -o ........\plugins\sqldrivers\qsqlpsql.dll .obj/release_
shared/main.o .obj/release_shared/qsql_psql.o .obj/release_shared/moc_qsql_psql.
o -Lc:\psql\lib -lpq -LC:/psql/lib -LC:\Qt\Qt5.0.2\5.0.2\mingw47_32\lib -lQt5Sq
l -lQt5Core
mingw32-make[1]: Leaving directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/s
qldrivers/psql'
mingw32-make -f Makefile.Debug all
mingw32-make[1]: Entering directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/
sqldrivers/psql'
g++ -c -pipe -fno-keep-inline-dllexport -g -std=c++0x -fno-exceptions -frtti -Wa
ll -Wextra -DUNICODE -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEP
TIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -I"C:\psql\includeö" -I"ôLIBS+=
c:\psql\lib\libpq.libö" -I"psql.pro" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include"
-I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_
32\include\QtSql\5.0.2" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql\5.0.2\Qt
Sql" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtCore" -I".moc\debug_shared" -I"
........\mkspecs\win32-g++" -o .obj\debug_shared\qsql_psql.o ......\sql\dri
vers\psql\qsql_psql.cpp
cc1plus.exe: warning: psql.pro: not a directory [enabled by default]
C:\Qt\Qt5.0.2\5.0.2\mingw47_32\bin\moc.exe -DUNICODE -DQT_NO_CAST_TO_ASCII -DQT_
NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I.
-I"C:\psql\includeö" -I"ôLIBS+=c:\psql\lib\libpq.libö" -I"psql.pro" -I"C:\Qt\Qt
5.0.2\5.0.2\mingw47_32\include" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql"
-I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql\5.0.2" -I"C:\Qt\Qt5.0.2\5.0.2\m
ingw47_32\include\QtSql\5.0.2\QtSql" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\Q
tCore" -I".moc\debug_shared" -I"........\mkspecs\win32-g++" -D__GNUC__ -DWIN3
2 ......\sql\drivers\psql\qsql_psql.h -o .moc\debug_shared\moc_qsql_psql.cpp
g++ -c -pipe -fno-keep-inline-dllexport -g -std=c++0x -fno-exceptions -frtti -Wa
ll -Wextra -DUNICODE -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEP
TIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -I"C:\psql\includeö" -I"ôLIBS+=
c:\psql\lib\libpq.libö" -I"psql.pro" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include"
-I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_
32\include\QtSql\5.0.2" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtSql\5.0.2\Qt
Sql" -I"C:\Qt\Qt5.0.2\5.0.2\mingw47_32\include\QtCore" -I".moc\debug_shared" -I"
........\mkspecs\win32-g++" -o .obj\debug_shared\moc_qsql_psql.o .moc\debug_s
hared\moc_qsql_psql.cpp
cc1plus.exe: warning: psql.pro: not a directory [enabled by default]
g++ -shared -Wl,--out-implib,C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\plugins\sqldrivers\l
ibqsqlpsqld.a -o ........\plugins\sqldrivers\qsqlpsqld.dll .obj/debug_shared/
main.o .obj/debug_shared/qsql_psql.o .obj/debug_shared/moc_qsql_psql.o -Lc:\psq
l\lib -lpq -LC:/psql/lib -LC:\Qt\Qt5.0.2\5.0.2\mingw47_32\lib -lQt5Sqld -lQt5Cor
ed
mingw32-make[1]: Leaving directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/s
qldrivers/psql'

after that i put the LIBS+=-LC:/psql/folder_where_libqp_can_be_found
in my psql.pro file like this:

TARGET = qsqlpsql

SOURCES = main.cpp
OTHER_FILES += psql.json
include(../../../sql/drivers/psql/qsql_psql.pri)
LIBS+=-LC:/psql/lib

PLUGIN_CLASS_NAME = QPSQLDriverPlugin
include(../qsqldriverbase.pri)

and got this output,

C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\psql>mingw32-make
C:\Qt\Qt5.0.2\5.0.2\mingw47_32\bin\qmake.exe "INCLUDEPATH+=C:\psql\includeö ôL
IBS+=c:\psql\lib\libpq.libö psql.pro" -o Makefile psql.pro
mingw32-make -f Makefile.Release all
mingw32-make[1]: Entering directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/
sqldrivers/psql'
mingw32-make[1]: Nothing to be done for 'all'.
mingw32-make[1]: Leaving directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/s
qldrivers/psql'
mingw32-make -f Makefile.Debug all
mingw32-make[1]: Entering directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/
sqldrivers/psql'
mingw32-make[1]: Nothing to be done for 'all'.
mingw32-make[1]: Leaving directory 'C:/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/s
qldrivers/psql'

but the "driver not loaded" error still comes as soon as I test with
@qDebug() << "Error = " << db.lastError().text();@

which is the correct output?
i think i should obtain the qsqlpsql.dll file after this is correctly created, which should be copied to c:[Qt]\mingw47_32\plugins\sqldrivers\

what's wrong?
thanks for your input

SGaist

I don't know if it's the copy/paste or something else, but you are having a lot of strange char in your mignw32-make output.

And this line:
@cc1plus.exe: warning: psql.pro: not a directory [enabled by default]@

looks suspicious