<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="Street"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="State"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="address"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Mincho";
panose-1:2 2 6 9 4 2 5 8 3 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>So it seems the build I’m using may not <st1:PersonName
w:st="on">support</st1:PersonName> ssl, I run ogrinfo with sslmode=prefer I
connect ok, but when I set sslmode=require I get this error:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>---------------------------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Details...<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>---------------------------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>call to ogrinfo failed: ERROR 1:
PQconnectdb failed.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>sslmode value "require" invalid
when SSL <st1:PersonName w:st="on">support</st1:PersonName> is not compiled in<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
gdal-dev-bounces@lists.osgeo.org [mailto:gdal-dev-bounces@lists.osgeo.org] <b><span
style='font-weight:bold'>On Behalf Of </span></b>Mike Axelrod<br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, January 27, 2011
3:21 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Chaitanya kumar CH<br>
<b><span style='font-weight:bold'>Cc:</span></b> <st1:PersonName w:st="on">gdal-dev@lists.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> RE: [gdal-dev] Can I use
ogr2ogr to postgresql with security?</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>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 </span></font><span
class=apple-style-span><font size=1 color=black face="Courier New"><span
style='font-size:9.0pt;font-family:"Courier New";color:black'>~/.postgresql/postgresql.key</span></font></span><span
class=apple-style-span><font size=1 color=black face="Courier New"><span
style='font-size:7.5pt;font-family:"Courier New";color:black'> being available
to the client. But I’m not clear if this is required or an option.</span></font></span><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>BTW I’m currently using the win32 SDK
version of ogr2ogr that is distributed here => </span></font><a
href="http://vbkto.dyndns.org/sdk/">http://vbkto.dyndns.org/sdk/</a><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>, I’m hoping these builds <st1:PersonName w:st="on">support</st1:PersonName>
SSL. Can anybody confirm? <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Mike<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Chaitanya kumar
CH [mailto:chaitanya.ch@gmail.com] <br>
<b><span style='font-weight:bold'>Sent:</span></b> Thursday, January 27, 2011
2:56 PM<br>
<b><span style='font-weight:bold'>To:</span></b> Mike Axelrod<br>
<b><span style='font-weight:bold'>Cc:</span></b> <st1:PersonName w:st="on">gdal-dev@lists.osgeo.org</st1:PersonName><br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [gdal-dev] Can I use
ogr2ogr to postgresql with security?</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>Mike,<br>
<br>
OGR's postgresql/postgis driver makes the connection using PQconnectdb() method
from the libpq library.<br>
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.<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On Fri, Jan 28, 2011 at 12:13 AM, Mike Axelrod <<a
href="mailto:mike.axelrod@pictometry.com">mike.axelrod@pictometry.com</a>>
wrote:<o:p></o:p></span></font></p>
<div link=blue vlink=purple>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Does ogr2ogr
(and ogrinfo) natively <st1:PersonName w:st="on">support</st1:PersonName>
secure connections to postgresql? </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>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.</span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'> </span></font><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Mike</span></font><o:p></o:p></p>
<p><font size=3 face="Times New Roman"><span lang=EN style='font-size:12.0pt'>Mike
Axelrod, Software Engineer<br>
Pictometry International Corp.<br>
Suite A, <st1:address w:st="on"><st1:Street w:st="on">100 Town Centre Drive</st1:Street>,
<st1:City w:st="on">Rochester</st1:City>, <st1:State w:st="on">NY</st1:State> <st1:PostalCode
w:st="on">14623</st1:PostalCode></st1:address><br>
Phone: 585-775-7711<br>
E-mail: <a href="mailto:mike.axelrod@pictometry.com" target="_blank">mike.axelrod@pictometry.com</a>
Web: </span><a href="http://www.pictometry.com/" target="_blank"><font size=2><span
lang=EN style='font-size:10.0pt'>http://www.Pictometry.com/</span></font></a><o:p></o:p></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=3 face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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. <o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
<br clear=all>
<br>
-- <br>
Best regards,<br>
Chaitanya kumar <st1:place w:st="on"><st1:country-region w:st="on">CH.</st1:country-region></st1:place><br>
/t</span></font><font face="MS Mincho"><span style='font-family:"MS Mincho"'>ʃ</span></font>a<font
face="MS Mincho"><span style='font-family:"MS Mincho"'>ɪ</span></font>θənjə/ /k<font
face="MS Mincho"><span style='font-family:"MS Mincho"'>ʊ</span></font>m<font
face="MS Mincho"><span style='font-family:"MS Mincho"'>ɑ</span></font>r/ <br>
+91-9494447584<br>
17.2416N 80.1426E<o:p></o:p></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>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. <o:p></o:p></span></font></p>
</div>
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.
</body>
</html>