Thread: user credentials rejected by pgAdmin right after new install
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
- 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
On Mon, Nov 21, 2022 at 12:44 AM Frank Rueter <frank@ohufx.com> wrote:
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
- 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.
It is difficult to guess from this message what could be the issue.
To start with - you can check the pg_hba.conf and listen_address of PostgreSQL to allow connection from the pgAdmin docker.
-- Ashesh
- 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
Turns out the docker compose install ignores the custom password in the yml file during install and always uses the default one regardless.
On Mon, Nov 21, 2022 at 5:55 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
On Mon, Nov 21, 2022 at 12:44 AM Frank Rueter <frank@ohufx.com> wrote: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
- 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.
It is difficult to guess from this message what could be the issue.To start with - you can check the pg_hba.conf and listen_address of PostgreSQL to allow connection from the pgAdmin docker.-- Ashesh
- 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
On Tue, Nov 22, 2022 at 3:46 AM Frank Rueter <frank@ohufx.com> wrote:
Turns out the docker compose install ignores the custom password in the yml file during install and always uses the default one regardless.
I am glad that you were able to figure out the root cause of the issue.
-- Ashesh
On Mon, Nov 21, 2022 at 5:55 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:On Mon, Nov 21, 2022 at 12:44 AM Frank Rueter <frank@ohufx.com> wrote: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
- 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.
It is difficult to guess from this message what could be the issue.To start with - you can check the pg_hba.conf and listen_address of PostgreSQL to allow connection from the pgAdmin docker.-- Ashesh
- 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
Thanks. Had a colleague look at it who knows way more than I do and he spotted it.
On Tue, Nov 22, 2022 at 5:37 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
On Tue, Nov 22, 2022 at 3:46 AM Frank Rueter <frank@ohufx.com> wrote:Turns out the docker compose install ignores the custom password in the yml file during install and always uses the default one regardless.I am glad that you were able to figure out the root cause of the issue.-- AsheshOn Mon, Nov 21, 2022 at 5:55 PM Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:On Mon, Nov 21, 2022 at 12:44 AM Frank Rueter <frank@ohufx.com> wrote: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
- 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.
It is difficult to guess from this message what could be the issue.To start with - you can check the pg_hba.conf and listen_address of PostgreSQL to allow connection from the pgAdmin docker.-- Ashesh
- 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