sslmode error when adding PostGIS layer

[morisimo]

I am working on Windows XP SP2 and I am running 3 QGIS packages via the OSGEO4W package manager, 1.0, 1.4 and 1.5.

I am trying to add a PostGIS layer from my PostGIS server where I need to connect via SSL in "Require" mode.

I can connect to my database via the pgAdmin console, as well as via the PostGIS Manager plugin.

However, when I try to add a PostGIS layer, I get the following error message:

"The database said: sslmode value "require" invalid when SSL support is not compiled in"

I do not get this error at all when adding a PostGIS layer in the standalone install of QGIS 1.4.0.

Any help on this issue would be much appreciated!

[jef]

I've updated the libpq package from the binaries from the postgres site (postgresql-8.3.10-1-binaries-no-installer.zip) and also updated the SSL DLLs to 0.9.8o (from  http://www.slproweb.com/download/Win32OpenSSL_Light-0_9_8o.exe).

Seems to work fine.

Tested:

• accessing postgresql in SSL mode with the prebuild QGIS 1.5 binaries,
• accessing postgresql in SSL mode rebuilt QGIS 1.6 with the new libpq libraries & includes,
• connecting with psql,
• running ogrinfo on postgresql and exporting from postgres to shape using ogr2ogr.

[morisimo]

Works a treat! Thanks for the quick resolution.