Mike, To use SSL mode with OGR, your pqlib should be built with SSL support.
On Fri, Jan 28, 2011 at 2:09 AM, Mike Axelrod <mike.axel...@pictometry.com>wrote: > So it seems the build I’m using may not support ssl, I run ogrinfo with > sslmode=prefer I connect ok, but when I set sslmode=require I get this > error: > > > > --------------------------- > > Details... > > --------------------------- > > call to ogrinfo failed: ERROR 1: PQconnectdb failed. > > sslmode value "require" invalid when SSL support is not compiled in > > > ------------------------------ > > *From:* gdal-dev-boun...@lists.osgeo.org [mailto: > gdal-dev-boun...@lists.osgeo.org] *On Behalf Of *Mike Axelrod > *Sent:* Thursday, January 27, 2011 3:21 PM > *To:* Chaitanya kumar CH > > *Cc:* gdal-dev@lists.osgeo.org > *Subject:* RE: [gdal-dev] Can I use ogr2ogr to postgresql with security? > > > > Thank you, I’ll be trying that out as soon as I get our postgresql server > configured with ssl. Do you know if the postgresql public key is required > on the client side? I see references to a ~/.postgresql/postgresql.keybeing > available to the client. But I’m not clear if this is required or an > option. > > > > BTW I’m currently using the win32 SDK version of ogr2ogr that is > distributed here => http://vbkto.dyndns.org/sdk/, I’m hoping these builds > support SSL. Can anybody confirm? > > > > Mike > > > ------------------------------ > > *From:* Chaitanya kumar CH [mailto:chaitanya...@gmail.com] > *Sent:* Thursday, January 27, 2011 2:56 PM > *To:* Mike Axelrod > *Cc:* gdal-dev@lists.osgeo.org > *Subject:* Re: [gdal-dev] Can I use ogr2ogr to postgresql with security? > > > > Mike, > > OGR's postgresql/postgis driver makes the connection using PQconnectdb() > method from the libpq library. > You can set the option 'sslmode' to 'require', 'verify-ca' or 'verify-full' > for a secure connection. Look for the documentation of PQconnectdb() for > further details. > > On Fri, Jan 28, 2011 at 12:13 AM, Mike Axelrod < > mike.axel...@pictometry.com> wrote: > > Does ogr2ogr (and ogrinfo) natively support secure connections to > postgresql? > > > > I need to run ogrinfo and ogr2ogr where the target is a postgresql server > elsewhere on the network (in a different domain) and secure the > communication. > > > > Mike > > Mike Axelrod, Software Engineer > Pictometry International Corp. > Suite A, 100 Town Centre Drive, Rochester, NY 14623 > Phone: 585-775-7711 > E-mail: mike.axel...@pictometry.com Web: > http://www.Pictometry.com/<http://www.pictometry.com/> > > > > NOTICE: This message is covered by the Electronic Communications Privacy > Act, Title 18, United States Code, Sections 2510-2521. This e-mail and any > attached files are the exclusive property of Pictometry International Corp., > are deemed privileged and confidential, and are intended solely for the use > of the individual(s) or entity to whom this e-mail is addressed. If you are > not one of the named recipient(s) or believe that you have received this > message in error, please delete this e-mail and any attachments and notify > the sender immediately. Any other use, re-creation, dissemination, > forwarding or copying of this e-mail is strictly prohibited and may be > unlawful. > > > _______________________________________________ > gdal-dev mailing list > gdal-dev@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/gdal-dev > > > > > -- > Best regards, > Chaitanya kumar CH. > /tʃaɪθənjə/ /kʊmɑr/ > +91-9494447584 > 17.2416N 80.1426E > > NOTICE: This message is covered by the Electronic Communications Privacy > Act, Title 18, United States Code, Sections 2510-2521. This e-mail and any > attached files are the exclusive property of Pictometry International Corp., > are deemed privileged and confidential, and are intended solely for the use > of the individual(s) or entity to whom this e-mail is addressed. If you are > not one of the named recipient(s) or believe that you have received this > message in error, please delete this e-mail and any attachments and notify > the sender immediately. Any other use, re-creation, dissemination, > forwarding or copying of this e-mail is strictly prohibited and may be > unlawful. > NOTICE: This message is covered by the Electronic Communications Privacy > Act, Title 18, United States Code, Sections 2510-2521. This e-mail and any > attached files are the exclusive property of Pictometry International Corp., > are deemed privileged and confidential, and are intended solely for the use > of the individual(s) or entity to whom this e-mail is addressed. If you are > not one of the named recipient(s) or believe that you have received this > message in error, please delete this e-mail and any attachments and notify > the sender immediately. Any other use, re-creation, dissemination, > forwarding or copying of this e-mail is strictly prohibited and may be > unlawful. > -- Best regards, Chaitanya kumar CH. /tʃaɪθənjə/ /kʊmɑr/ +91-9494447584 17.2416N 80.1426E
_______________________________________________ gdal-dev mailing list gdal-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/gdal-dev
