From: "Gaisford, Phillip" <phillip.gaisford@hpe.com>
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Issue with configuration parameter "require_auth"
Thread-Topic: Issue with configuration parameter "require_auth"
Thread-Index: AQHazxUOVZN7k2D53USBkhN5t3/1NQ==
Date: Wed, 17 Jul 2024 15:09:39 +0000
Message-ID: <DM4PR84MB15172CC4665076AB1248F3CC8DDF2@DM4PR84MB1517.NAMPRD84.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?VQydzVUTeR458eUWbgVBfZSci6m4TI4F/w0ZsjK4gyr2x2DLiXsMmXPjjKbo?=
 =?us-ascii?Q?XdbK+vk0z4o0UD9ZqFU0thUqEvvIxHuRSuZT9Ce5oNne4GmPfwGQe5R9zcpg?=
 =?us-ascii?Q?AMwJKpK92VmeQUEuD8ffsph5R72ILcUxzkJmhlVBMTXHpYs+d6HwSV0e8WEQ?=
 =?us-ascii?Q?WMkMvxcqQDDmhcOl77EZsXhPs/q5Oq70asdpUO78hwpj3nqNpJ2llcbkOVNl?=
 =?us-ascii?Q?SJGT3N6Uit2JmDDafQlP7K78qPKMi/2R3109+cuUUZibIwCHlnl+MJdu03f4?=
 =?us-ascii?Q?FUJU7Eu4yZU5qk8mqFqIgAiTOr0ai1ykA/5D73s+Son/G3nP0W1N4jMm5sWV?=
 =?us-ascii?Q?/6tNCFUVR1qnM1MlB1SwzhaHzPDxVIeAW28J9rUCp0qXAiosTRErrspUpx7s?=
 =?us-ascii?Q?VntWEKMxvOPcl8CROuVN257D/7QskJ+yVge7/AiZnd3cbIduKxKnTGb4T6sF?=
 =?us-ascii?Q?5YELT9IztT/GRt2y0LO/GPXzPzhQS41mRHJK90fhNj8It9c02EYrzW5AxP7x?=
 =?us-ascii?Q?8GE9el5+d8P5Bu7HpbQeuVV13eT2pEuk9NsUczXplwS0+XhNOPcvenTXgmoj?=
 =?us-ascii?Q?44QWY7/5F9Z46MJdguNs77XjDjcrRD1G0dMfpa9HwD94BLqcZOMjwqFdXdDy?=
 =?us-ascii?Q?ztMAqr/VWO98EkRmsaDxFIwpJJhmOIL6Gk+vOH0zU5R95mT33kIjs2cGV0Mz?=
 =?us-ascii?Q?9Ej/8drbsNUIkB3vV9Up21R3JyffSifbdIJVXN792y29Da1fd/yJ/Ml8bxf2?=
 =?us-ascii?Q?oQoEFHB47JkPkl4NdRL/I1e3Lrd9C8x5ssZXhVtHUgP+yEF7ta84CDOXbb1j?=
 =?us-ascii?Q?pIX7lUy12+1nVt+A6j5u53V512JlSqndjriwu27mf2gNzOgKgCTxeAUmEXxD?=
 =?us-ascii?Q?qBDzIzTzVzaMAteLLhtvqWsQfXaphwHIkqTkGDu0Q7VqDudt152cIgB0zP7K?=
 =?us-ascii?Q?XQCT3uqx02rdGd6BoIJsaSVXhO3OKkkE0ubzeRwEhRUBeux7yL2+9YKfkLvD?=
 =?us-ascii?Q?DD/uv9DLrbdX0M93ZpkXORK8w9PTsJoZXCAuF0od0YmtpeHLJuWr18YxrOiP?=
 =?us-ascii?Q?4IV+V7z92gZU40f9hf0JjBenCUglr8+KXNtpb9psTNLnq8+iuzxtAh1Br8iz?=
 =?us-ascii?Q?zMsS8wIjHNYh45m1LmyXCtcUkw/PPTpnplJcrobdc4d8LX9HhSJwqVXFHBkk?=
 =?us-ascii?Q?hiBYDquN6wnpUdAaY/qawpfJ9vYN/ePfcBleLSXFEhP4uFGTsQyHvc32as/4?=
 =?us-ascii?Q?X2hEcwpfmA3/xKS7T+4kEwlVrfmA8MFWb+Regdfs4f8clD893/Dh74ofieTL?=
 =?us-ascii?Q?CZO+U4p04HbOzynFfk+qCho4WORVVz2o+zJ/guEP8Zs0m0rzmmFuoK82IV82?=
 =?us-ascii?Q?eanyRLAR0CJWM9RVLZI8v9n+VY6BjkYlYkW7UsCXAJpeHwYzUMb0i7H7Omg8?=
 =?us-ascii?Q?e7vk+AXt9mIzjZneO0rHcpWzGNqBxCPWeNjBwDUYM8zQUQC51hWK8ss57nET?=
 =?us-ascii?Q?7c162h7xg/Ulvmco5H+/sPnLG8n0fFTPvJFkvE1avJyWoC/LR0E5Rt2wrzG4?=
 =?us-ascii?Q?E3HUb0Vi3utit3FjODVMYCl+ayDQdUAqaku5KbRKlvSsVMKdNrpBroQfzo12?=
 =?us-ascii?Q?oA=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_DM4PR84MB15172CC4665076AB1248F3CC8DDF2DM4PR84MB1517NAMP_"
MIME-Version: 1.0
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-Network-Message-Id: 165ed4ca-3b83-4de4-4db5-08dca6727ad5
X-MS-Exchange-CrossTenant-originalarrivaltime: 17 Jul 2024 15:09:39.6942
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 105b2061-b669-4b31-92ac-24d304d195dc
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: wTeXWrV90jMcYf2t15CXM/2tF/2pSBLPltFBWM/7O5I4fQoe8EGAXH6vKZuSKRssG7FHJ1+1EdUeGnO4kt5VcaGicch+xuju6IgI1kjOUWs=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MN0PR84MB3961
X-OriginatorOrg: hpe.com
X-Proofpoint-GUID: nxObTR8WOmUvdpesfNNY2AKOXRstwyko
X-Proofpoint-ORIG-GUID: nxObTR8WOmUvdpesfNNY2AKOXRstwyko
X-HPE-SCL: -1
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.28.16
 definitions=2024-07-17_11,2024-07-17_02,2024-05-17_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 impostorscore=0
 priorityscore=1501 mlxscore=0 adultscore=0 lowpriorityscore=0 spamscore=0
 bulkscore=0 mlxlogscore=932 phishscore=0 suspectscore=0 malwarescore=0
 clxscore=1011 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.19.0-2407110000 definitions=main-2407170116
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/DM4PR84MB15172CC4665076AB1248F3CC8DDF2%40DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM>
Precedence: bulk

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

I am having trouble using require_auth (https://www.postgresql.org/docs/16/=
libpq-connect.html#LIBPQ-CONNECT-REQUIRE-AUTH).


Using golang sqlx.Connect on the client side, the connection fails and my P=
ostgresql 16 server logs the following:

2024-07-17 14:42:07.285 UTC [115] FATAL:  unrecognized configuration parame=
ter "require_auth"


What could the issue be?


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

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" xmlns:w=3D"urn:sc=
hemas-microsoft-com:office:word" xmlns:m=3D"http://schemas.microsoft.com/of=
fice/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:Aptos;
	panose-1:2 11 0 4 2 2 2 2 2 4;}
@font-face
	{font-family:Menlo;
	panose-1:2 11 6 9 3 8 4 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	font-size:11.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#467886;
	text-decoration:underline;}
p.p1, li.p1, div.p1
	{mso-style-name:p1;
	margin:0in;
	font-size:10.0pt;
	font-family:Menlo;
	color:black;}
span.s1
	{mso-style-name:s1;}
span.apple-converted-space
	{mso-style-name:apple-converted-space;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-size:11.0pt;
	mso-ligatures:none;}
@page WordSection1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
	{page:WordSection1;}
--></style>
</head>
<body lang=3D"EN-US" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal">I am having trouble using require_auth (<a href=3D"h=
ttps://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNECT-REQUIRE-=
AUTH">https://www.postgresql.org/docs/16/libpq-connect.html#LIBPQ-CONNECT-R=
EQUIRE-AUTH</a>).</p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
<p class=3D"p1"><span style=3D"font-size:11.0pt;font-family:&quot;Aptos&quo=
t;,sans-serif">Using golang sqlx.Connect on the client side, the connection=
 fails and my Postgresql 16 server logs the following:<br>
<br>
<span class=3D"s1">2024-07-17 14:42:07.285 UTC [115] FATAL:</span></span><s=
pan class=3D"apple-converted-space"><span style=3D"font-size:11.0pt;font-fa=
mily:&quot;Aptos&quot;,sans-serif">&nbsp;
</span></span><span class=3D"s1"><span style=3D"font-size:11.0pt;font-famil=
y:&quot;Aptos&quot;,sans-serif">unrecognized configuration parameter &quot;=
require_auth&quot;<o:p></o:p></span></span></p>
<p class=3D"p1"><span class=3D"s1"><span style=3D"font-size:11.0pt;font-fam=
ily:&quot;Aptos&quot;,sans-serif"><o:p>&nbsp;</o:p></span></span></p>
<p class=3D"p1"><span class=3D"s1"><span style=3D"font-size:11.0pt;font-fam=
ily:&quot;Aptos&quot;,sans-serif">What could the issue be?</span></span><sp=
an style=3D"font-size:11.0pt;font-family:&quot;Aptos&quot;,sans-serif"><o:p=
></o:p></span></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
</body>
</html>

--_000_DM4PR84MB15172CC4665076AB1248F3CC8DDF2DM4PR84MB1517NAMP_--