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-----
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. |