public inbox for [email protected]
help / color / mirror / Atom feedFrom: Surya Widyanto <[email protected]>
To: [email protected]
Subject: Re: Fwd: pgadmin says "SSL error: tlsv1 alert no application protocol"
Date: Mon, 16 Dec 2024 21:22:43 +0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<CAMa=N=PxEuXgxwZuekb1FAXh8+zK785oVf98nNab3K4qQHpXEA@mail.gmail.com>
<[email protected]>
Hi,
Recently I've had the same problem when upgrading to v8.13 or v8.14 from
v8.12, it broke my PgAdmin4 on windows and linux, on linux I run as
Server Mode with Apache HTTPD, and on windows I also run local WebServer
mode that I run on command prompt to be able to access it from
http://localhost:5050/.
Basically what I've been identified the problem are with the library
libpq that being used by PgAdmin4, in my case, I install several major
version within the same machine, so I have difficulties identifying
which version of libpq being used by PgAdmin4, and for the linux
instance, the problem so severe that the instance cannot be accessed
from web server and always give HTTP Errpr 500. But on windows instance,
my problem is I cannot connect to a server with SSL Mode turned on
(required or prefer)
But I found the way to overcome this problem by installing the pip
package of psycopg_binary within the virtual environment of the PgAdmin4
Python.
On Linux I run this command:
# Activate Virtual Environment
source <path_to_activate_script>
# e.g
source /usr/pgadmin4/venv/bin/activate
# Install PIP Package
pip install "psycopg[binary]"
# Deactivate/Exit Virtual Environment
deactivate
On Windows I run this command:
cd C:\Program Files\pgAdmin 4\python
python
>>> import pip
>>> [CTRL-Z + Enter] # to exit python prompt
python -m pip install "psycopg[binary]"
And that's it, I can run my PgAdmin4 v8.13 or v8.14 instance without
having to depend on external or system installed libpq library again.
Regards,
-ayrus02
On 16-12-2024 19:46, Markus KARG 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!
>
> 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 <[email protected]>
>> 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
>> >
>> >
>> >
>>
>>
Attachments:
[image/png] Screenshot 2024-12-16 at 10.23.59 AM.png (126.9K, 3-Screenshot%202024-12-16%20at%2010.23.59%E2%80%AFAM.png)
download | view image
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: Fwd: pgadmin says "SSL error: tlsv1 alert no application protocol"
In-Reply-To: <[email protected]>
* 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