pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeduser credentials rejected by pgAdmin right after new install
5+ messages / 3 participants
[nested] [flat]
* user credentials rejected by pgAdmin right after new install
@ 2022-11-20 18:59 Frank Rueter <frank@ohufx.com>
0 siblings, 1 reply; 5+ messages in thread
From: Frank Rueter @ 2022-11-20 18:59 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
I have to install postgres on my QNAP TVS-1271U-RP but am no pro, so
hopefully this is an easy beginners mistake:
- via DockerStation on the QNAP I installed postgres and pgadmin via this
docker compose <https://github.com/khezen/compose-postgres;
- 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 this running once in the past but decided to uninstall
everything and start from scratch for several 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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: user credentials rejected by pgAdmin right after new install
@ 2022-11-21 07:38 Holger Jakobs <holger@jakobs.com>
parent: Frank Rueter <frank@ohufx.com>
0 siblings, 2 replies; 5+ messages in thread
From: Holger Jakobs @ 2022-11-21 07:38 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 mistake:
>
> * via DockerStation on the QNAP I installed postgres and pgadmin via
> this docker compose <https://github.com/khezen/compose-postgres;
> * 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 this running once in the past but decided to uninstall
> everything and start from scratch for several 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
--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachments:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: user credentials rejected by pgAdmin right after new install
@ 2022-11-21 08:04 Frank Rueter <frank@ohufx.com>
parent: Holger Jakobs <holger@jakobs.com>
1 sibling, 0 replies; 5+ messages in thread
From: Frank Rueter @ 2022-11-21 08:04 UTC (permalink / raw)
To: Holger Jakobs <holger@jakobs.com>; +Cc: pgsql-admin@lists.postgresql.org
Thank you very much, I will look into your suggestions. Hopefully it's as
simple as tweaking the config.
Cheers,
frank
On Mon, Nov 21, 2022 at 8:39 PM Holger Jakobs <holger@jakobs.com> wrote:
> 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 mistake:
>
> - via DockerStation on the QNAP I installed postgres and pgadmin via this
> docker compose <https://github.com/khezen/compose-postgres;
> - 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 this running once in the past but decided to uninstall
> everything and start from scratch for several 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
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: user credentials rejected by pgAdmin right after new install
@ 2022-11-21 14:08 Ron <ronljohnsonjr@gmail.com>
parent: Holger Jakobs <holger@jakobs.com>
1 sibling, 1 reply; 5+ messages in thread
From: Ron @ 2022-11-21 14:08 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
"Wrong credentials" means that pgAdmin successfully connected to the
Postgresql server. OP just couldn't log in.
On 11/21/22 01:38, Holger Jakobs wrote:
>
> 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 mistake:
>>
>> * via DockerStation on the QNAP I installed postgres and pgadmin via
>> this docker compose <https://github.com/khezen/compose-postgres;
>> * 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 this running once in the past but decided to uninstall
>> everything and start from scratch for several 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
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: user credentials rejected by pgAdmin right after new install
@ 2022-11-21 22:16 Frank Rueter <frank@ohufx.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 5+ messages in thread
From: Frank Rueter @ 2022-11-21 22:16 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
Turns out the docker compose install ignores the custom password in the yml
file during install and always uses the default one regardless.
On Tue, Nov 22, 2022 at 3:08 AM Ron <ronljohnsonjr@gmail.com> wrote:
> "Wrong credentials" means that pgAdmin successfully connected to the
> Postgresql server. OP just couldn't log in.
>
> On 11/21/22 01:38, Holger Jakobs wrote:
>
> 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 mistake:
>
> - via DockerStation on the QNAP I installed postgres and pgadmin via this
> docker compose <https://github.com/khezen/compose-postgres;
> - 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 this running once in the past but decided to uninstall
> everything and start from scratch for several 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
>
> --
> Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
>
>
> --
> Angular momentum makes the world go 'round.
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2022-11-21 22:16 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-11-20 18:59 user credentials rejected by pgAdmin right after new install Frank Rueter <frank@ohufx.com>
2022-11-21 07:38 ` Holger Jakobs <holger@jakobs.com>
2022-11-21 08:04 ` Frank Rueter <frank@ohufx.com>
2022-11-21 14:08 ` Ron <ronljohnsonjr@gmail.com>
2022-11-21 22:16 ` Frank Rueter <frank@ohufx.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox