public inbox for [email protected]  

help / color / mirror / Atom feed

From: Gaisford, Phillip <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Issue with configuration parameter "require_auth"
Date: Wed, 17 Jul 2024 18:58:10 +0000
Message-ID: <DM4PR84MB151709CC219E9ABDA4506EAF8DA32@DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM> (raw)
In-Reply-To: <[email protected]>
References: <DM4PR84MB15172CC4665076AB1248F3CC8DDF2@DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM>
	<[email protected]>
	<DM4PR84MB15178765743B35906D9F380D8DA32@DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM>
	<[email protected]>

I think Tom is right.

I am using v5.6 of https://github.com/jackc/pgx

I quick read of the code reveals no awareness of require_auth, so I have filed an issue with the project.

From: Tom Lane <[email protected]>
Date: Wednesday, July 17, 2024 at 1:11 PM
To: Gaisford, Phillip <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Issue with configuration parameter "require_auth"
"Gaisford, Phillip" <[email protected]> writes:
> So what would a connection URI using require_auth properly look like? Here’s what I have been trying:

> url: "postgres://postgres:postgres@localhost:5432/aioli?require_auth=password&application_name=aioli-controller&sslmode=disable&sslrootcert=",

Hm, that looks right (and behaves as-expected here).

What version of what client-side stack are you using?  For me, libpq 16
and up recognize this parameter, while older versions fail with

psql: error: invalid URI query parameter: "require_auth"

If you're using some other client driver, maybe it doesn't know this
parameter and guesses that it should be passed to the server.

                        regards, tom lane

view thread (5+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Issue with configuration parameter "require_auth"
  In-Reply-To: <DM4PR84MB151709CC219E9ABDA4506EAF8DA32@DM4PR84MB1517.NAMPRD84.PROD.OUTLOOK.COM>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox