Connect to server silently fails with no error message

From: Devon Oslund <devon(dot)oslund(at)trustcommerce(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Connect to server silently fails with no error message
Date: 2014-01-22 21:51:25
Message-ID: 52E03D5D.4080007@trustcommerce.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

devonerik(at)shalebridge:~$ /usr/lib/postgresql/9.3/bin/postgres -V
postgres (PostgreSQL) 9.3.2
devonerik(at)shalebridge:~$ pgadmin3 -v
pgAdmin III 1.18.1

devonerik(at)shalebridge:~$ psql -U postgres -W
Password for user postgres:
psql (9.3.2)
Type "help" for help.

postgres=# select * from pg_user
postgres-# ;
usename | usesysid | usecreatedb | usesuper | usecatupd | userepl | passwd | valuntil | useconfig
- ----------+----------+-------------+----------+-----------+---------+----------+----------+-----------
postgres | 10 | t | t | t | t | ******** | infinity |
(1 row)

postgres=# \q
devonerik(at)shalebridge:~$

devonerik(at)shalebridge:~$ sudo cat /etc/postgresql/9.3/main/pg_hba.conf | grep -v '\#'

local all postgres md5

local all all md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5

Given all this, PGadmin silently fails to connect to the server with no error message, simply a repeat of the prompt for
server info.

The password IS correct, I just authenticated through psql with it.

Changing any or all of the lines in pg_hba.conf from md5, to peer, to trust, and restarting the server does nothing.

PGadmin connect attempts create no entries in /var/log/postgresql/postgresql-9.3-main.log. There are some

Purging and reinstalling PGadmin has no effect.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQEcBAEBAgAGBQJS4D1SAAoJEAy07rHw4yiv4xMIAKFfkqweZCxkYBjKO9EhvTBy
eRlXQQIC4yPGbwPks1zfuaVEAzwu9PsgPgqWRvXseHWZXdWONMMXrYe15TzUXgY6
zR7jBdp3sl25COJbZRFtziR213UloKIajOGDffaU73/qCUI74XuGrIJAVIwqCOYv
eDT07c1qiac8WCAXQ+Qix5YIjUaU0VqdB8BF+ihTheB/6GdD+ZF3H3/8lYakc4Fg
xJy5x4/3NyQgyEPeAGGhHyX2+MjiOLJ5zK66c1J0WOsc27Ib/PutQFSntVFflaeJ
Q07wo6+R5q5DjAKAmsCQe5hGkr1Svy30revAzvB8h1dLqMYIjjT1JumyfPvts/I=
=XW2d
-----END PGP SIGNATURE-----

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dinesh Kumar 2014-01-23 02:18:17 Re: CTE error for F6 (execute pgScript), F5 (execute query) is OK
Previous Message David Harel 2014-01-22 13:21:45 pgAdmin, I love it but, hints are driving me crazy.