Обсуждение: Connect to server silently fails with no error message
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 devonerik@shalebridge:~$ /usr/lib/postgresql/9.3/bin/postgres -V postgres (PostgreSQL) 9.3.2 devonerik@shalebridge:~$ pgadmin3 -v pgAdmin III 1.18.1 devonerik@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@shalebridge:~$ devonerik@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-----
<tt><font size="2"><br /><br /> > Given all this, PGadmin silently fails to connect to the server with<br /> > no errormessage, simply a repeat of the prompt for<br /> > server info.<br /> > <br /> > The password IS correct, Ijust authenticated through psql with it.<br /> > <br /> > Changing any or all of the lines in pg_hba.conf from md5,to peer, <br /> > to trust, and restarting the server does nothing.<br /> > <br /> > PGadmin connect attemptscreate no entries in /var/log/postgresql/<br /> > postgresql-9.3-main.log. There are some<br /> > <br /></font></tt><br/><font face="sans-serif" size="2">Reset your Guru Hints and it should show you the message. File->Options->ResetGuru Hints</font><tt><font size="2">.</font></tt><br /><br /><tt><font size="2">cheers</font></tt><fontface="sans-serif" size="2"><br /> =============================================<br /><br/> Romax Technology Limited <br /> A limited company registered in England and Wales.<br /> Registered office:<br />Rutherford House <br /> Nottingham Science and Technology Park <br /> Nottingham <br /> NG7 2PZ <br /> England<br /> RegistrationNumber: 2345696<br /> VAT Number: 526 246 746<br /><br /> Telephone numbers:<br /> +44 (0)115 951 88 00 (main)<br/><br /> For other office locations see:<br /></font><a href="http://www.romaxtech.com/Contact"><font face="sans-serif"size="2">http://www.romaxtech.com/Contact</font></a><font face="sans-serif" size="2"><br /> =================================<br/> ===============<br /> E-mail: info@romaxtech.com<br /> Website: </font><a href="www.romaxtech.com"><fontface="sans-serif" size="2">www.romaxtech.com</font></a><font face="sans-serif" size="2"><br/> =================================<br /><br /> ================<br /> Confidentiality Statement<br /> Thistransmission is for the addressee only and contains information that is confidential and privileged.<br /> Unless youare the named addressee, or authorised to receive it on behalf of the addressee <br /> you may not copy or use it, ordisclose it to anyone else. <br /> If you have received this transmission in error please delete from your system and contactthe sender. Thank you for your cooperation.<br /> =================================================</font>
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have managed to fix this by ripping out and reinstalling *everything* (postgres, pgadmin, libraries, etc), but I stillhave no idea why it happened. On 01/22/2014 11:20 PM, Martin French wrote: >> 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 >> > > Reset your Guru Hints and it should show you the message. File->Options->Reset Guru Hints. > > cheers ============================================= > > Romax Technology Limited A limited company registered in England and Wales. Registered office: Rutherford House Nottingham > Science and Technology Park Nottingham NG7 2PZ England Registration Number: 2345696 VAT Number: 526 246 746 > > Telephone numbers: +44 (0)115 951 88 00 (main) > > For other office locations see: http://www.romaxtech.com/Contact ================================= =============== E-mail: > info@romaxtech.com Website: www.romaxtech.com ================================= > > ================ Confidentiality Statement This transmission is for the addressee only and contains information that is > confidential and privileged. Unless you are the named addressee, or authorised to receive it on behalf of the addresseeyou > may not copy or use it, or disclose it to anyone else. If you have received this transmission in error please delete from > your system and contact the sender. Thank you for your cooperation. ================================================= > -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJS4WiJAAoJEAy07rHw4yivwNUH/iLMJX40eJzZEHeMBbUAmFYV +sNNbNc/7u8qkOQ8hhR/RjlnkdqmfqSCend0NVWP9phEvAtJWPjQOS8y6hSIRoL8 5Up4NUia63Gcr35P+4yCPN8NNLH0IcUvz6ovKBHPXMRVlS5WRJfXDM+bYy34Qp7Y qMdIeBHxG3cCuhKTu5yrmTTa6d+sWi1DTypaO8F5ZaO+gwxt9OnZi4lHwCtbItMw jX4C3Fy4eAlMboYkzYK31Ji5i2jeWU9HLof0BbLkgwAQskFMCqDGlN6Tjxib8pxB 2qn9Q9K2ceg21qgmA7SG3q/5B2LAF23nFDoC1Ps7cCvXADI/x+4+WUL4IzuZnpo= =xem8 -----END PGP SIGNATURE-----