From: "Gadling, Prashant" <PrashantAmrutrao.Gadling@anz.com>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: PostGreSQL ODBC driver support AIX Kerberos authentication
Thread-Topic: PostGreSQL ODBC driver support AIX Kerberos authentication
Thread-Index: AdmthexKP7nGwnA+SXOgJ4fvwaPIbA==
Date: Mon, 3 Jul 2023 08:11:14 +0000
Message-ID: 
 <MEYPR01MB7920816BAADFB53BBC2A07698029A@MEYPR01MB7920.ausprd01.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?v7KbN/S3aiXYL232mWJYx9IW0qhbjUphuAMV4F+rhLl6ElLPwnT7aTDoXPmN?=
 =?us-ascii?Q?P7/06RJ016pS8HNVRhOvgt+1V8lbYY67E0FiTRsSVU20LXLpzMfy769RddaD?=
 =?us-ascii?Q?RqZ4qcoF1d6dXMG3F/iJs+1Qt20jvq606K//HNoBuxG2+Y3znE3gho+a2Ssg?=
 =?us-ascii?Q?RXP3nNiTVcjl+Dha17F7CB/kt1niysQr0tuKUpglGFx7mDG0YAhkmvDtnq5x?=
 =?us-ascii?Q?bSeqp7yfkWoZENj8/hOHfrgRoSUR1FpbiRdD3gzkrtamFAwYTRUdayBDBARi?=
 =?us-ascii?Q?dZXzj6bHbuVx1aik/ttYEe/Ahnv8elAn+9y/zavO5ikzYJC7cT07Pt+HpAjj?=
 =?us-ascii?Q?sjHt773Dy2NE7MsSFRmn9zYPROpakJ0Y9jVdBvFkbMskZi/KrzWxEN0+uQW+?=
 =?us-ascii?Q?OqhpprPSdRZqCqqw+mInCE8Ns1IhukKYXzIhDKsHVJREP6e2d3v48tlSyZg0?=
 =?us-ascii?Q?+HPPJwXcXy9/HWulNph7gsWIuc35y9saejHrjyO8fl3IDROfWsJSdccVAibs?=
 =?us-ascii?Q?JXrQSKQn+gwiuprLrYVetXj6bSzs+t8BqouYPjjgANVw/F7V8i9FDqIn2EJe?=
 =?us-ascii?Q?rL9XJ/0nLwKNYfbM8NAKkp6jsdbplAU4UZYzvmndfnXrCdbLZ3uTvW2tBU++?=
 =?us-ascii?Q?4WBA5kbXUgF29VgZn3SU6F1lEiX8cncDFooRMTwdnvsS0VjVeBkBXAGJ6a4U?=
 =?us-ascii?Q?D8vfpeAI1m/JB0fkvVKlEc6cBoA6aLk8SotVuAbfxEy91MaTpAPIK9pH/02X?=
 =?us-ascii?Q?7eJTijvgLXk74CMQShp3pQwgNyVMuvAh03d+oSjzL4NBdN6TOTCZ9SKx5CAS?=
 =?us-ascii?Q?9irS9qhQjfvKR0qyzGkMZ0rGvxYH34gDNVNGEFD5KVp5FFz4eUAb+eF7f3VC?=
 =?us-ascii?Q?UdjVAJLcyiA35lkpEoCYlwMle+T0pY1EwPnfLZFzCHIT5gzbqzDNxNJXs+dy?=
 =?us-ascii?Q?GZtPrXBL6ZZkmt75yEY5p2Hfw3xyniiiichPNFp3H7xxo4kkppceYP9igpPF?=
 =?us-ascii?Q?cYEMgywigGT947uFaewq87hpUTFYXzQBJ6VImG2J041NjHP/Nbl7mm6Pk+zi?=
 =?us-ascii?Q?w7ViM3NZzDrJo8mospxYb3hB5ftObV1B93OyHUQ/ue7UcQVcHK/fAG8FWxsH?=
 =?us-ascii?Q?mPGV79uBlJaZGzTKVP6GIzNabQLgvq45aJ866loCkWEDsVj7nb4sQXXPIuIQ?=
 =?us-ascii?Q?kB1AdqZ31gb50dkmxqFYBU4h6FgxCe44GrGFWvNcYXD8Z+Z6lSRds8iZQetn?=
 =?us-ascii?Q?6w3jdrv2VsemxsdHnaMUduSWhwpeYnRj+0l8gBq1kTrc5fvc1GmsR1D1/iY0?=
 =?us-ascii?Q?BRgHVyyb0AnzZx4hPTGRwJAT1OBXOAkAK6DM7cuaqvVCwLKXQlU4DWHtuKx6?=
 =?us-ascii?Q?1W/H96f5CdGGbNcEC4HCDC7Iny9gHS1Gw36d0UKOXMsK/MtwFlO1KRcYa7KL?=
 =?us-ascii?Q?ydQDHCepbWwluquUN0Q/s7+o600JTVl1RJtE1KnuwwLvB+RQf+nLuAcnGpc2?=
 =?us-ascii?Q?UaMhudOUR5cqb89almdYLmueAOcgGM1L9QVUOQ6zJdcb6PGGLKf+XuFQzaTF?=
 =?us-ascii?Q?+pZjlnSCKAyz8lX3Ph9FNphe0pi8rAOQpCqqqe1MshpBT/Wc+k8xgSN+R6M6?=
 =?us-ascii?Q?fg=3D=3D?=
arc-seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none;
 b=aHL+5T0Rg123EDMHqG86CZcNntTWNwvzwEc+XhvzeVJZJ5Vv/UGbNWYTSZ5cP3/0hOiidqJDrsMVFuD3vk3dMLenm54LT+xHGf9vEsG6j1nhT1RPbyfWkkEDCGY59j2poVfyQ05NRM6nsfKgLuS8b7lIzWRj389lxtJXcfUUYv6W5VeAvXizJt86h3J0zPwODfiFPMXF3qhIQES1Q/kfPs5kIijzeNpea8d6GDOM1S8pHX7ZrIXMTwuyOFQeFvW7NAysBfcOiOUlUM8v0HrHulSRgTKM5q/TWveTlibZekp/bTz1DeE00MG9CptJLBAXsTQlE6jzWpGZRy0d2O/s5Q==
arc-message-signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
 s=arcselector9901;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
 bh=6/e0KWYWVGiXeAMkGRMHqZ1CMPqD9E/+WH4gxN/J34U=;
 b=JaAwYAw0ZkRso8a+tRdiaQ1i2UWR4wtC/OWEB9r1lhPYDNI0Cit17XrBppojV2NbF+idJ/A1H9lLa7Nld/ggxg7Q2k5xvO0x+ss9vcHFSo1vl4mifvnNU+kPYqTZBEtjJsrNzVawigr3YISx0A/RmPrLDYH99CwZGo3J38IlYympUsKpBP6GDSVsSHl2yEaphi2xbrHQ2zhxIqD9z63I99VYTk1qmxiXfXLhhKRuGNo5U9fJBRvAarkQevpL1lYraPNpXoGkgEkGRZotB12UXthPtzou9GBX8tUUiR2yOQyStlWMBOu87hg7AVkr7jX2i3Ex2AmH2U1H2p/LqoBRug==
arc-authentication-results: i=1; mx.microsoft.com 1; spf=pass
 smtp.mailfrom=anz.com; dmarc=pass action=none header.from=anz.com; dkim=pass
 header.d=anz.com; arc=none
dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=anz.onmicrosoft.com;
 s=selector2-anz-onmicrosoft-com;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=6/e0KWYWVGiXeAMkGRMHqZ1CMPqD9E/+WH4gxN/J34U=;
 b=bcuY4/kXebrnTaKL3Jm6TVkapF9Sq+ApiW7USK8UFZsmXjh6SEpj98foJpL0khnzUDCoxvy1Nmj9Y96CIDvVxoluj2hx6eEWb6r9paKbcAGkE0CalOuTEcSx+ngkGCH9vHqHTel7Nt1PZIo2F6i7MrY5JP7db5z59fOBvdXYlxU=
x-ms-exchange-antispam-externalhop-messagedata-chunkcount: 1
x-ms-exchange-antispam-externalhop-messagedata-0: 
 S1Q3n62KyQ7AV0XBvomRA4OXm/EhSscm4lT8+LV2tdRKyMHlYtUnLQdgUCGsgTG467vqrX0M443M4Wt8g7k616d9jRKcJDOy+5ZU3E6XP7feoxc8luP2uVMcuvwgDieDeq9TQXjebJJrTyuSOFCz5RXwS9L5r0amQ0oRi7Silz4kDmO8KosznP80unuyvo3xZ3dRaeXNiJR64kPR5Cc0J+jzaNlkFQyJtNcv1GwSMGyv8cnz/jzYKAaWFplZ7iIO17oUM/2l2b2KHJer6B59XzYYY5q5C0H6q3+QONTIESswO5mWOJUlvm3K6v29NQ+Ks1X0FuhYGyJ00w1hHa2nGzu5YfZ6yS2TRmq6ATA/lwdtQ9OkZNX7754vofHDxB/qIXjs7i3vrHHx54DsxecDVLUdIOhXKkHu6Mj7gDkbAeu8wydHZqXI8ZSwKKF7aZpx4ZVb7j+xVW7Jd7CQNL3kYEgUXaRrPBFnaxxBF48F+3Ax9TAFD0UuJozU/gYDI3NBfKNKuGnOEyBeREXPIoahzGvKDUbZg3rOSh302bre/cYHtpQJd3AXo75t5lAGq6xvI266MBGgxVhtnsoPtMdN271yzJC+HlSFCfCnrlUafV0P5qsJ5kSfSCXshUw7lfBvTpweWoPWvzPyzCYTbJ0tay9XN5G0Npu6FQhEGL0xaAUliL2em+tl1hF2XBA8VKO0iDHO8WSrjzO6xBGU5NiYfx1xrOYrsIQRouXl3pzU9XiCO3dFRip9rOQzIO69Zel2JPqjBZoxajtrmFNZNbMtHFccoawpBx3KWHG982Z/N+FHP4MPtZp+jAkRQYkR41bEVDKH1BrWWxn23guJ9/ErX7GQeT1DeiJ4wvz8QD0R/yHKFdYnqu2GGEC6xdYYwQhS
x-ms-exchange-crosstenant-authas: Internal
x-ms-exchange-crosstenant-authsource: MEYPR01MB7920.ausprd01.prod.outlook.com
x-ms-exchange-crosstenant-network-message-id: 
 0fc22b9e-986e-4d40-7630-08db7b9d1210
x-ms-exchange-crosstenant-originalarrivaltime: 03 Jul 2023 08:11:14.6176 (UTC)
x-ms-exchange-crosstenant-fromentityheader: Hosted
x-ms-exchange-crosstenant-id: 1f4f7eda-6e51-425e-a0f9-4c2fcef58a52
x-ms-exchange-crosstenant-mailboxtype: HOSTED
x-ms-exchange-crosstenant-userprincipalname: 
 ey3OQYaDyS5aV3U92VK6bQEX1ZiLFjCWPOsZz456j78jor+Lx6z+udZ9Ybp4dynBxjsFsEsW8IxLrLo+pNQtBRMBNctJeZYVckZMQBZjJmDPqdoNRnx7dd6UZWFHg1CJ
x-ms-exchange-transport-crosstenantheadersstamped: SY4PR01MB6009
Content-Type: multipart/alternative;
	boundary="_000_MEYPR01MB7920816BAADFB53BBC2A07698029AMEYPR01MB7920ausp_"
MIME-Version: 1.0
X-RCIS-Action: ALLOW
Received-SPF: Fail (EXIAU001MELP003.ecorp.anz.com: domain of
 PrashantAmrutrao.Gadling@anz.com does not designate 172.31.224.9 as permitted
 sender) receiver=EXIAU001MELP003.ecorp.anz.com; client-ip=172.31.224.9;
 helo=EXIAU001MELA001.ecorp.anz.com;
Received-SPF: None (EXIAU001MELA001.ecorp.anz.com:
 PrashantAmrutrao.Gadling@anz.com does not designate permitted sender hosts)
X-DKIM-Signer: DkimX (v3.20.320)
X-FE-ETP-METADATA: 
 eyAidGlkIjogIjN5UGhHcFotMC0wODQxQUMxMzQ4OTNCMjgyQTQ2OTc2OWY0NTEiLCAiYWNjZXB0
 ZWRfdGltZXN0YW1wIjogIjIwMjMwNzAzMDgxMTMxIiwgImFjY2VwdGVkX3RpbWVzdGFtcF9lcG9j
 aCI6ICIxNjg4MzcxODkxIiwgImRvbWFpbl9uYW1lIjogImFuei5jb20iLCAiYXR0X2NvdW50Ijog
 LTIsICJzcmNfaXAiOiAiMjAzLjExMC4yMzUuMjEyIiB9
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/MEYPR01MB7920816BAADFB53BBC2A07698029A%40MEYPR01MB7920.ausprd01.prod.outlook.com>
Precedence: bulk

--_000_MEYPR01MB7920816BAADFB53BBC2A07698029AMEYPR01MB7920ausp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi @pgsql-odbc@postgresql.org<mailto:pgsql-odbc@postgresql.org>,


I have installed psqlodbc-15.00.0000 ODBC driver on client server (AIX v7.2=
 64 bit) to achieve ODBC connection from client OS AIX v7.2 to PostGreSQL v=
14.8.0 DB server using AIX v7.2(unixODBC v2.3.9) ODBC driver which internal=
ly uses psqlodbc-15.00.0000 ODBC driver and the authentication mode should =
be AIX Kerberos.

Could you please verify, whether PostGreSQL ODBC driver support AIX Kerbero=
s authentication while connecting from client AIX v7.2 to PostGreSQL v14.8.=
0 DB server using AIX v7.2(unixODBC v2.3.9) ODBC driver ?

Thanks
Prashant G
+91 9970266886
This e-mail and any attachments to it (the "Communication") is, unless othe=
rwise stated, confidential, may contain copyright material and is for the u=
se only of the intended recipient. If you receive the Communication in erro=
r, please notify the sender immediately by return e-mail, delete the Commun=
ication and the return e-mail, and do not read, copy, retransmit or otherwi=
se deal with it. Any views expressed in the Communication are those of the =
individual sender only, unless expressly stated to be those of Australia an=
d New Zealand Banking Group Limited ABN 11 005 357 522, or any of its relat=
ed entities including ANZ Bank New Zealand Limited (together "ANZ"). ANZ do=
es not accept liability in connection with the integrity of or errors in th=
e Communication, computer virus, data corruption, interference or delay ari=
sing from or in respect of the Communication.

--_000_MEYPR01MB7920816BAADFB53BBC2A07698029AMEYPR01MB7920ausp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"=
>
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
	{font-family:Verdana;
	panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Verdana",sans-serif;
	color:windowtext;
	font-weight:normal;
	font-style:normal;}
.MsoChpDefault
	{mso-style-type:export-only;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-AU" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif">Hi
<a id=3D"OWAAM5A270183DE5B4CF7944FDB745F14C347" href=3D"mailto:pgsql-odbc@p=
ostgresql.org">
<span style=3D"font-family:&quot;Verdana&quot;,sans-serif;text-decoration:n=
one">@pgsql-odbc@postgresql.org</span></a>,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif">I have installed psqlodbc-15.00.0000 ODBC driver on=
 client server
<i>(AIX v7.2 64 bit) </i>to achieve ODBC connection from client OS AIX v7.2=
 to PostGreSQL v14.8.0 DB server using AIX v7.2(unixODBC v2.3.9) ODBC drive=
r which internally uses psqlodbc-15.00.0000 ODBC driver and the authenticat=
ion mode should be AIX Kerberos.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif">Could you please verify, whether PostGreSQL ODBC dr=
iver support AIX Kerberos authentication while connecting from client AIX v=
7.2 to PostGreSQL v14.8.0 DB server using AIX
 v7.2(unixODBC v2.3.9) ODBC driver ? <o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif">Thanks<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif">Prashant G<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:10.0pt;font-family:&quot;Ve=
rdana&quot;,sans-serif">&#43;91 9970266886<o:p></o:p></span></p>
</div>
This e-mail and any attachments to it (the &quot;Communication&quot;) is, u=
nless otherwise stated, confidential, may contain copyright material and is=
 for the use only of the intended recipient. If you receive the Communicati=
on in error, please notify the sender immediately
 by return e-mail, delete the Communication and the return e-mail, and do n=
ot read, copy, retransmit or otherwise deal with it. Any views expressed in=
 the Communication are those of the individual sender only, unless expressl=
y stated to be those of Australia
 and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its re=
lated entities including ANZ Bank New Zealand Limited (together &quot;ANZ&q=
uot;). ANZ does not accept liability in connection with the integrity of or=
 errors in the Communication, computer virus,
 data corruption, interference or delay arising from or in respect of the C=
ommunication.
</body>
</html>

--_000_MEYPR01MB7920816BAADFB53BBC2A07698029AMEYPR01MB7920ausp_--