model-writtenrun 9672 - may be wrong, links go to the source messages. Commit-by-commit LLM analysis is in the Commits dialog.
- Hugh Ranalli reported that SCRAM password authentication failed with a channel-binding error in both psycopg2 and psql #1; after Bruce Momjian cited limitations in enforcing channel binding #2, Hugh clarified that he only wanted ordinary SCRAM authentication #3.
- Michael Paquier suspected incompatible OpenSSL capabilities #4, and Hugh confirmed that the server used OpenSSL 1.1.0 while application clients used 1.0.1, initially planning to postpone SCRAM adoption until upgrading those clients #5.
- Peter Eisentraut identified that pg_SASL_init() selected SCRAM-SHA-256-PLUS without checking whether the client could hash the peer certificate #6, prompting Michael to attach a patch guarding that selection with HAVE_PGTLS_GET_PEER_CERTIFICATE_HASH #7.
- Peter questioned whether the guard would leave no mechanism selected #8; Michael explained that a channel-binding-capable server advertises both mechanisms, allowing unsupported clients to select ordinary SCRAM #9, and Peter accepted the logic after rereading the patch #10.
- Tom Lane offered access to older OpenSSL installations for testing #11, Michael described the mixed-version test cases #12, and Peter confirmed successful testing with a custom-built OpenSSL #13.
- Michael committed the patch as 87c346a35e with only comment reflow and backpatched it to PostgreSQL 11, closing the thread with confirmation that the fix had landed #14.