Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uCMQS-00E5hG-CI for pgsql-hackers@arkaria.postgresql.org; Tue, 06 May 2025 17:49:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uCMQQ-009AXj-SF for pgsql-hackers@arkaria.postgresql.org; Tue, 06 May 2025 17:49:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uCMQQ-009AXb-HV for pgsql-hackers@lists.postgresql.org; Tue, 06 May 2025 17:49:50 +0000 Received: from mail-qv1-xf36.google.com ([2607:f8b0:4864:20::f36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uCMQM-000SQU-2Y for pgsql-hackers@postgresql.org; Tue, 06 May 2025 17:49:48 +0000 Received: by mail-qv1-xf36.google.com with SMTP id 6a1803df08f44-6ecf99dd567so80593386d6.0 for ; Tue, 06 May 2025 10:49:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb.com; s=google; t=1746553786; x=1747158586; darn=postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=iOEFEIpY1Xp5riC7ZDXQHLuJBo23Xf6kpx7KG2AngEo=; b=LUhzZtiBIP9VSl2n8aY5TnylIJYN1gBUaqTjGoWwFLgOu7K2+3O1ZL/FIOzY/uB1Zy KNpdgAPbJW4+SuneO5SOlVF5rVMjQ5AfjgEQGd9VX6pGp0g5halhw9vYQgOEIbXEcja6 ApjaZRGdmEWxl6jQ1vquRiO5kxMDGgRYhtIga/TAlTEWbcoEQJARFHZsVagk4WBerDBR 7d+zUjCkvIUdKw38iNCaTyBhMRsDPscvt67GhZlnGrwHs8O/xOMqHjAmK81M8lmFUGJq oYSUWecDvJNurVAbpI9DK6QmYxmCb5Gk/4XCxckMIYtU9eSApUh5DGEkeU993+wvDH/A jlmg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1746553786; x=1747158586; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=iOEFEIpY1Xp5riC7ZDXQHLuJBo23Xf6kpx7KG2AngEo=; b=sw2LDBt4MENQpt3edO05VTnqpO52d+5j1znkDJCAqfTZZioeDv1zr6sGrNjtY2WDVF vL7CM0VKU/lWehS/FUZ4PpJdG2/GEzdrT1h6pRBXTOZv5U/kvzm6m59FEbErrlUO0qhb K38SYcnSW9o9u95alwS1He/DhA8++7y3J+X5eoHT6B5nmbse9K3rSTWv0tKEo/nQiU2W SrvPfiwcc5iQTKkHg5LnaLhAobDDWJw/xUzEF1qNT/d7TllaGqTsoNvXzrx0zuL2xs6+ a424GIl+LtVW9WR6zZICSUvjy4OpbYyEWHmJXZQyemSQzn/C+ejsHAPs5Po7te0Gt9af V9sQ== X-Forwarded-Encrypted: i=1; AJvYcCVvGht5R7hJCJ26HQy+ZifJpB4XnYQmhf1SgSM4Qvl5su3hLOn9NaNEfy6BlfoEii1pnyrxS3M6iFgfV9BY@postgresql.org X-Gm-Message-State: AOJu0YyTYL4DYsO/zq/yaZjqGFCU6cSodWDa2/h1NaraFbbsRBtlP5FT flcii4EfpC/rvbWR0S7RtLnK5uIrPf6GZN8uxQDQ+cjcnhEiBlRUOxnP63qU1bEKGF30IjM9XXl 1secBAVtpjbCRQChJtK11uAb8CiQ6g3wYcuzU X-Gm-Gg: ASbGnctSipixMNs5hYg/X5yGSuBrvAcdyI12Jie650AxAVgW3YuOf+1OzGz2jVkG7T5 Eci6KHXrbraq3FmFAD3Cg+4iSHXCecQz4sHBoUJBggNSwGD2AIszji7xuhkn1mnqr09hMz+tGeY nSel1mQXlDnGk9SHAcvMKM X-Google-Smtp-Source: AGHT+IEdc0A5J+bajqm6RuDenH+NYUKt0sYfiSXnv1K0mkegAFjYT/wsj/WVxt2fF+hoKfgiQ/msd1yZKVT3StUb9WE= X-Received: by 2002:a05:6214:5283:b0:6e8:feae:9291 with SMTP id 6a1803df08f44-6f542a6b1e3mr173546d6.24.1746553782292; Tue, 06 May 2025 10:49:42 -0700 (PDT) MIME-Version: 1.0 References: <8210C830-DDBB-4CD7-AB39-F5F59C36D547@yesql.se> <9badbeeb-a432-48d4-8710-c8254a54d428@technowledgy.de> In-Reply-To: <9badbeeb-a432-48d4-8710-c8254a54d428@technowledgy.de> From: Jacob Champion Date: Tue, 6 May 2025 10:49:31 -0700 X-Gm-Features: ATxdqUFpiO7QZ35LH7v-iPH5x7D76jpCl7jPcb6JAyXMSQAk-je5OgCdl2pt7l0 Message-ID: Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER To: Wolfgang Walther Cc: Nathan Bossart , Daniel Gustafsson , Christoph Berg , Jelte Fennema-Nio , Peter Eisentraut , Andres Freund , Tom Lane , Bruce Momjian , PostgreSQL Hackers , Thomas Munro , Nazir Bilal Yavuz , Antonin Houska , =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, May 4, 2025 at 5:58=E2=80=AFAM Wolfgang Walther wrote: > The only inconsistency I was able to find is the autoconf-generated > libpq.pc file, which has this: > > Requires.private: libssl, libcrypto libcurl Oh, I see what I did. Will fix, thanks. > I was only able to test the latter in an end-to-end fully static build > of a downstream dependency - works great. The final executable has all > the expected oauth strings in it. Thank you so much for all the detailed testing! --Jacob