Re: Fwd: pgadmin says "SSL error: tlsv1 alert no application protocol"

From: Markus KARG <markus(at)headcrashing(dot)eu>
To: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Cc: pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: Fwd: pgadmin says "SSL error: tlsv1 alert no application protocol"
Date: 2024-12-16 19:01:52
Message-ID: 4e1b0b49-802e-4762-8a58-5be1ed434e1f@headcrashing.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support pgsql-advocacy

I have not selected the OS and Python version. I am using this image:
https://hub.docker.com/layers/dpage/pgadmin4/8.14/images/sha256-1053696a89c887a2a3ee6b24a7e2614cf68227d30ff8304e61da20bc71d4dd50

Am 16.12.2024 um 14:39 schrieb Khushboo Vashi:
>
>
> On Mon, Dec 16, 2024 at 6:16 PM Markus KARG <markus(at)headcrashing(dot)eu>
> wrote:
>
> Thank you for your kind help!
>
> The good news first: I downgraded PGAdmin from 8.14 to *8.12 and
> everything is working well* then with the exact same configuration
> in the exact same environment!
>
> Can you please share the OS details? If it is Linux, please share the
> details of the Python version as well.
>
> The bad news: 8.13 and 8.14 both do have the described problem.
> Apparently something in PGAdmin changed from 8.12 to 8.13 that is
> causing this issue. As I could not find something in the release
> notes
> https://www.pgadmin.org/docs/pgadmin4/8.13/release_notes_8_13.html
> that would explain the observed behavior, I would say this is a bug.
>
> Regarding your question: When switching "SSL mode" from "require"
> (which causes the message "SSL error: tlsv1 alert no application
> protocol") to "prefer" or "disabled", then PGAdmin is running into
> a connection timeout. That is no surprise, as the Traefik 3.2
> proxy guards PostgreSQL 17.2 server from all non-TLS traffic.
>
> Any ideas? Shall I author a bug report? Do you like to perform
> tests in my environment?
>
> -Markus
>
>
> Am 16.12.2024 um 05:55 schrieb Yogesh Mahajan:
>>
>> Hi,
>>
>> I guess an error is occurring while connecting to the server. Can
>> you please check and change SSL mode for server which is giving
>> error to 'prefer'/'disabled'
>>
>> Screenshot 2024-12-16 at 10.23.59 AM.png
>>
>> Thanks,
>> Yogesh Mahajan
>> EnterpriseDB
>>
>>
>> On Fri, Dec 13, 2024 at 9:01 PM Markus KARG
>> <markus(at)headcrashing(dot)eu> wrote:
>>
>> Could anybody please be so kind and help me with this issue?
>> Thanks! :-)
>>
>> Am 12.12.2024 um 22:18 schrieb Markus KARG:
>> > I was using PGAdmin with PostgreSQL 17 via Traefik 3
>> successfully
>> > since many months, but since I recently moved on to
>> PostgresSQL 17 the
>> > UI of PGAdmin always tells me "SSL error: tlsv1 alert no
>> application
>> > protocol". All other applications connect successfully.
>> >
>> > I do not want to use TLSv1, and neither PostgreSQL 17 nor
>> Traefik 3 is
>> > explicitly configured to use TLS v1. In PGAdmin I
>> explicitly have set
>> > the min and max SSL versions to 1.3.
>> >
>> > So I do wonder who in this game is using TLSv1 and how to
>> get rid of it?
>> >
>> > Thanks!
>> >
>> > -Markus
>> >
>> >
>> >
>>
>>

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Khushboo Vashi 2024-12-18 03:37:34 Re: Loading the Clinical Trials Transformation Initiative AACT databse into pgAdmin4 v8.13
Previous Message Surya Widyanto 2024-12-16 14:22:43 Re: Fwd: pgadmin says "SSL error: tlsv1 alert no application protocol"

Browse pgsql-advocacy by date

  From Date Subject
Next Message Markus KARG 2024-12-18 09:18:08 Re: Fwd: pgadmin says "SSL error: tlsv1 alert no application protocol"
Previous Message Surya Widyanto 2024-12-16 14:22:43 Re: Fwd: pgadmin says "SSL error: tlsv1 alert no application protocol"