Bug? PgAdmin3, SSL certificate connections refused

From: "Gabriel E(dot) Sánchez Martínez" <gabrielesanchez(at)gmail(dot)com>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Bug? PgAdmin3, SSL certificate connections refused
Date: 2015-08-03 20:37:12
Message-ID: 55BFD0F8.2030501@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Hi,

I am having an issue with pgAdmin3 that may be a bug, and wanted to
share it with you to see what you think. I am running pgAdmin3 1.18.1
on Ubuntu 14.04. There are several server connections configured: one
to the local database, and three others to remote servers. All the
remote servers require client certificate authentication.

Right after opening pgAdmin, I can connect to any of the databases and
use them as expected. If I connect to the second server (i.e. the first
remote one), I can use that server without issues, but I cannot
establish a connection to the third or fourth servers: I get an error
saying "SSL Error: certificate verify failed". I can connect to the
local database without problems. In order to connect to the third and
fourth servers, I have to restart pgAdmin.

After restarting pgAdmin, I can connect to the third and fourth servers
in any order. (The third and fourth servers share the same root
certificate server.) I can also connect to the first (local) and second
(first remote) servers. However, once I've connected to the second
server, no new connections to the third and fourth servers can be
established. This includes clicking on a disconnected database in those
servers, trying to open a query editor, or connecting after
disconnecting. The error dialog has the same message.

The symptoms suggest that something related to the root certificate is
being stored by pgAdmin once a connection is established. It is strange
that the order of the servers seems to matter. Possibly the CA
certificate of the first server is the one that blocks connections to
servers requiring SSL appearing later on the list if they use a
different CA certificate, but that has yet to be verified.

Any ideas?

Thanks and regards,
Gabriel

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Gabriel E. Sánchez Martínez 2015-08-04 18:59:48 Re: Bug? PgAdmin3, SSL certificate connections refused
Previous Message Ashesh Vashi 2015-08-03 12:38:53 pgAdmin III commit: Bumped version for alpha-2 release (version: 1.22.0

Browse pgadmin-support by date

  From Date Subject
Next Message Matt Dobrowolny 2015-08-04 18:08:22 Re: PgAdmin crash on windows 8.1
Previous Message Carlos Medina 2015-07-23 16:04:04 Crash on Mac