Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ox1OQ-0002Ef-Pz for pgsql-admin@arkaria.postgresql.org; Mon, 21 Nov 2022 07:39:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ox1OP-0007R0-P1 for pgsql-admin@arkaria.postgresql.org; Mon, 21 Nov 2022 07:39:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ox1OP-0007Qq-9c for pgsql-admin@lists.postgresql.org; Mon, 21 Nov 2022 07:39:01 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ox1OF-00012L-He for pgsql-admin@lists.postgresql.org; Mon, 21 Nov 2022 07:39:00 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id DE26E380EF0; Mon, 21 Nov 2022 08:38:48 +0100 (CET) Received: from rs.plausibolo.de ([127.0.0.1]) by localhost (h2367442.stratoserver.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id lZToNMdnMv7D; Mon, 21 Nov 2022 08:38:48 +0100 (CET) Received: from [192.168.178.28] (ip-037-201-152-231.um10.pools.vodafone-ip.de [37.201.152.231]) by rs.plausibolo.de (Postfix) with ESMTPSA id 866FA3800EF; Mon, 21 Nov 2022 08:38:48 +0100 (CET) Message-ID: Date: Mon, 21 Nov 2022 08:38:47 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.1 To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Subject: Re: user credentials rejected by pgAdmin right after new install In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="------------kgoUW0FE02ncMQqomuXwhDoG" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --------------kgoUW0FE02ncMQqomuXwhDoG Content-Type: multipart/mixed; boundary="------------zk5heXs25cEMAs0SZXQeibwW"; protected-headers="v1" From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Message-ID: Subject: Re: user credentials rejected by pgAdmin right after new install References: In-Reply-To: --------------zk5heXs25cEMAs0SZXQeibwW Content-Type: multipart/alternative; boundary="------------AWMkJ00km0xlbjhu8zaUy6hR" --------------AWMkJ00km0xlbjhu8zaUy6hR Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: base64 SGkgRnJhbmsNCg0KVXNpbmcgcGdBZG1pbiBpcyBnZW5lcmFsbHkgZmluZSwgYnV0IG5vdCBo ZWxwZnVsIGluIGNhc2UgeW91J3JlIHRyeWluZyANCnRvIGZpbmQgYW4gZXJyb3IgcmVnYXJk aW5nIGNvbm5lY3RpbmcgdG8gdGhlIHNlcnZlci4NCg0KQmUgYXdhcmUgdGhhdCB0aGUgcGdB ZG1pbiBtYWlsaW5nIGxpc3QgaXNuJ3QgdGhpcyBvbmUuIHBnQWRtaW4gaXMgYSANCmRpZmZl cmVudCBwcm9qZWN0Lg0KDQpUcnkgdG8gY29ubmVjdCB1c2luZyBwc3FsLCB3aGljaCBpcyB0 aGUgb25seSAib2ZmaWNpYWwiIGZyb250ZW5kLg0KDQpXYXRjaCBvdXQgZm9yIHRoZSBzZXR0 aW5nIGxpc3Rlbl9hZGRyZXNzZXMgaW4gcG9zdGdyZXNxbC5jb25mIGFuZCANCmFwcHJvcHJp YXRlIGVudHJpZXMgaW4gcGdfaGJhLmNvbmYsIGFzIHdpdGhvdXQgY29ycmVjdCB2YWx1ZXMg dGhlcmUgbm8gDQpjb25uZWN0aW9uIGlzIHBvc3NpYmxlLiBPZnRlbiwgbGlzdGVuX2FkZHJl c3NlcyBkb2Vzbid0IGFsbG93IHJlbW90ZSANCmNvbm5lY3Rpb25zIHdpdGggdGhlIGRlZmF1 bHQgc2V0dGluZy4NCg0KSWYgeW91IGFyZSBjb25uZWN0aW5nIHdpdGggcGdBZG1pbiBmcm9t IHRoZSBzYW1lIG1hY2hpbmUgKE5PVCB2aWEgDQpUQ1AvSVApLCB0aGVuIHlvdSBjYW4gdXNl IGEgbG9jYWwgc29ja2V0IChBRl9VTklYKSBhbmQgZW50ZXIgdGhlIHBhdGggb2YgDQp0aGUg c29ja2V0IGZpbGVzIGluc3RlYWQgb2YgdGhlIElQIGFkZHJlc3Mgb3IgdGhlIG5hbWUgb2Yg dGhlIHNlcnZlci4gDQpwZ0FkbWluIGNhbiBoYW5kbGUgdGhpcywgYXMgcHNxbCwgYnV0IERC ZWF2ZXIgZm9yIGluc3RhbmNlIGNhbm5vdC4NCg0KQmVzdCBSZWdhcmRzLA0KDQpIb2xnZXIN Cg0KQW0gMjAuMTEuMjIgdW0gMTk6NTkgc2NocmllYiBGcmFuayBSdWV0ZXI6DQo+IEhpLA0K Pg0KPiBJIGhhdmUgdG8gaW5zdGFsbCBwb3N0Z3JlcyBvbiBteSBRTkFQIFRWUy0xMjcxVS1S UCBidXQgYW0gbm8gcHJvLCBzbyANCj4gaG9wZWZ1bGx5IHRoaXMgaXMgYW4gZWFzeSBiZWdp bm5lcnPCoG1pc3Rha2U6DQo+DQo+ICAgKiB2aWEgRG9ja2VyU3RhdGlvbiBvbiB0aGUgUU5B UCBJIGluc3RhbGxlZCBwb3N0Z3JlcyBhbmQgcGdhZG1pbiB2aWENCj4gICAgIHRoaXMgZG9j a2VyIGNvbXBvc2UgPGh0dHBzOi8vZ2l0aHViLmNvbS9raGV6ZW4vY29tcG9zZS1wb3N0Z3Jl cz4NCj4gICAqIHRoZSBvbmx5IHRoaW5nIEkgY2hhbmdlZCBpbiB0aGUgcHJvY2VzcyB3YXMg dGhlIFBPU1RHUkVTX1BBU1NXT1JEDQo+ICAgICBpbiB0aGUgeW1sLg0KPiAgICogYWZ0ZXIg c3VjY2Vzc2Z1bCBpbnN0YWxsIEkgd2VudCB0byBwZ2FkbWluLCBjbGlja2VkICJhZGQgbmV3 DQo+ICAgICBzZXJ2ZXIiIGFuZCBlbnRlcmVkIHRoZSBzZXJ2ZXIncyBpcCBhZGRyZXNzIGFs b25nIHdpdGggdGhlDQo+ICAgICBQT1NUR1JFU19VU0VSIGFuZCBQT1NUR1JFU19QQVNTV09S RCB2YWx1ZXMgZnJvbSB0aGUgeW1sIGZpbGUuDQo+ICAgKiBIb3dldmVyLCBwZ2FkbWluIHNh eXMgdGhhdCB0aG9zZSBhcmUgdGhlIHdyb25nIHVzZXIgY3JlZGVudGlhbHMuDQo+ICAgKiBJ IGxvZ2dlZCBpbnRvIHRoZSBkb2NrZXIgdGVybWluYWwgZm9yIG15IGRvY2tlciBjb250YWlu ZXIgYW5kDQo+ICAgICBjaGVja2VkIHRoZSBlbnZpcm9ubWVudCB3aGljaCBjb25maXJtcyB0 aGUgYWJvdmUgdmFsdWVzIGFyZSBpbmRlZWQNCj4gICAgIGNvcnJlY3QuDQo+DQo+DQo+IEkg dXNlZCB0byBoYXZlwqB0aGlzIHJ1bm5pbmcgb25jZSBpbiB0aGUgcGFzdCBidXQgZGVjaWRl ZCB0byB1bmluc3RhbGwgDQo+IGV2ZXJ5dGhpbmcgYW5kIHN0YXJ0IGZyb20gc2NyYXRjaCBm b3LCoHNldmVyYWwgcmVhc29ucy4gQWZ0ZXIgc2V2ZXJhbCANCj4gaG91cnMgb2YgdHJ5aW5n IEkganVzdCBjYW5ub3QgZmlndXJlIG91dCB3aGF0IEkgYW0gbWlzc2luZyB0byBnZXQgdGhp cyANCj4gZ29pbmcuDQo+DQo+IElmIHNvbWVvbmUgd291bGQgYmUgYWJsZSB0byBhc3Npc3Qg d2l0aCB0aGlzLCB0aGF0IHdvdWxkIGJlIGFtYXppbmcuDQo+DQo+IENoZWVycywNCj4gZnJh bmsNCg0KLS0gDQpIb2xnZXIgSmFrb2JzLCBCZXJnaXNjaCBHbGFkYmFjaCwgVGVsLiArNDkt MTc4LTk3NTkwMTINCg0K --------------AWMkJ00km0xlbjhu8zaUy6hR Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

Hi Frank

Using pgAdmin is generally fine, but not helpful in case you're trying to find an error regarding connecting to the server.

Be aware that the pgAdmin mailing list isn't this one. pgAdmin is a different project.

Try to connect using psql, which is the only "official" frontend.

Watch out for the setting listen_addresses in postgresql.conf and appropriate entries in pg_hba.conf, as without correct values there no connection is possible. Often, listen_addresses doesn't allow remote connections with the default setting.

If you are connecting with pgAdmin from the same machine (NOT via TCP/IP), then you can use a local socket (AF_UNIX) and enter the path of the socket files instead of the IP address or the name of the server. pgAdmin can handle this, as psql, but DBeaver for instance cannot.

Best Regards,

Holger

Am 20.11.22 um 19:59 schrieb Frank Rueter:
Hi,

I have to install postgres on my QNAP TVS-1271U-RP but am no pro, so hopefully this is an easy beginners=C2=A0mistake:
  • via DockerStation on the QNAP I installed postgres and pgadmin via this docker compose=C2=A0
  • the only thing I changed in the process was the POSTGRES_PASSWORD in the yml.
  • after successful install I went to pgadmin, clicked "add new server" and entered the server's ip address along with the POSTGRES_USER and POSTGRES_PASSWORD values from the yml file.
  • However, pgadmin says that those are the wrong user credentials.
  • I logged into the docker terminal for my docker container and checked the environment which confirms the above values are indeed correct.

I used to have=C2=A0this running once in the past but decide= d to uninstall everything and start from scratch for=C2=A0several reasons. After several hours of trying I just cannot figure out what I am missing to get this going.

If someone would be able to assist with this, that would be amazing.

Cheers,
frank
--=20
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--------------AWMkJ00km0xlbjhu8zaUy6hR-- --------------zk5heXs25cEMAs0SZXQeibwW-- --------------kgoUW0FE02ncMQqomuXwhDoG Content-Type: application/pgp-signature; name="OpenPGP_signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="OpenPGP_signature" -----BEGIN PGP SIGNATURE----- wmMEABEIACMWIQScuJCxWJK1p5BOebGKV5yTsxlhugUCY3srBwUDAAAAAAAKCRCKV5yTsxlhurnS AKDPEhoSODUyMe3t92EBhEwUoC9BMgCgo1Bei0YKxbfJsPs/KoexUPht3po= =Zwkc -----END PGP SIGNATURE----- --------------kgoUW0FE02ncMQqomuXwhDoG--