Opened 12 years ago

Closed 12 years ago

#172 closed enhancement (fixed)

sslmode error when adding PostGIS layer

Reported by: morisimo Owned by: jef
Priority: critical Component: Package
Version: Alpha Keywords: PostGIS, SSLmode
Cc: timlinux

Description

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!

Change History (3)

comment:1 by timlinux, 12 years ago

Cc: timlinux added

comment:2 by jef, 12 years ago

Owner: changed from osgeo4w-dev@… to jef
Type: defectenhancement

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.

comment:3 by morisimo, 12 years ago

Resolution: fixed
Status: newclosed

Works a treat! Thanks for the quick resolution.

Note: See TracTickets for help on using tickets.