I recently set up SSL authentication on Ubuntu 13.10 running PostgreSQL 9.1.
I can connect using pgAdmin on another Ubuntu machine. But it will not
connect on when I try to use pgAdmin (v1.16.1) on OS 10.6.
On the OS X machine, I can connect with psql as follows (excuse the
redaction):
PGHOSTADDR=---.---.---.--- \
PGDATABASE=--- \
PGUSER=--- \
PGREQUIRESSL=1 \
PGSSLCERT=~/.postgresql/postgresql.crt \
PGSSLKEY=~/.postgresql/postgresql.key \
PGSSLROOTCERT=~/.postgresql/root.crt \
psql
Using these same settings, pgAdmin will not connect. Each time I retry, it
gives me a different error message. (It's very odd.) These are the error
messages it gives me in the order I get them ('...path...' is the path to
my certificate file):
"Error connecting to the server: SSL error: block type is not 01"
"Could not read certificate file '...path...' padding check failed."
"Could not read certificate file '...path...' EVP lib"
"Could not read certificate file '...path...' certificate verify failed."
"Could not read certificate file '...path...' uninitialized."
After this, it will repeat the "uninitialized" error message when I retry
it. When I restart pgAdmin and try again, the messages start over.
Thanks for your help,
Travis
