Content-Type: multipart/alternative;
 boundary="------------EKBxC09xAOJM4vpRkZIN5OGb"
Message-ID: <79a5a7cf-ad30-6b22-70d2-c9092074a1f1@gmail.com>
Date: Mon, 21 Nov 2022 08:08:36 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.2.2
Subject: Re: user credentials rejected by pgAdmin right after new install
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAB3gnPXv3ai4gPaT9VzvPwxub9FxxsPY+ZY15Si=EJ1hhvK4dg@mail.gmail.com>
 <adc05758-d860-a4e6-914d-348c0953ed6f@jakobs.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: <adc05758-d860-a4e6-914d-348c0953ed6f@jakobs.com>
Archived-At: 
 <https://www.postgresql.org/message-id/79a5a7cf-ad30-6b22-70d2-c9092074a1f1%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------EKBxC09xAOJM4vpRkZIN5OGb
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

"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.
--------------EKBxC09xAOJM4vpRkZIN5OGb
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    "Wrong credentials" means that pgAdmin successfully connected to the
    Postgresql server.  OP just couldn't log in.<br>
    <br>
    <div class="moz-cite-prefix">On 11/21/22 01:38, Holger Jakobs wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:adc05758-d860-a4e6-914d-348c0953ed6f@jakobs.com">
      <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
      <p>Hi Frank</p>
      <p>Using pgAdmin is generally fine, but not helpful in case you're
        trying to find an error regarding connecting to the server.</p>
      <p>Be aware that the pgAdmin mailing list isn't this one. pgAdmin
        is a different project.</p>
      <p>Try to connect using psql, which is the only "official"
        frontend. <br>
      </p>
      <p>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.</p>
      <p>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.<br>
      </p>
      <p>Best Regards,</p>
      <p>Holger<br>
      </p>
      <div class="moz-cite-prefix">Am 20.11.22 um 19:59 schrieb Frank
        Rueter:<br>
      </div>
      <blockquote type="cite"
cite="mid:CAB3gnPXv3ai4gPaT9VzvPwxub9FxxsPY+ZY15Si=EJ1hhvK4dg@mail.gmail.com">
        <meta http-equiv="content-type" content="text/html;
          charset=UTF-8">
        <div dir="ltr">Hi,
          <div><br>
          </div>
          <div>I have to install postgres on my QNAP TVS-1271U-RP but am
            no pro, so hopefully this is an easy beginners mistake:</div>
          <div>
            <ul>
              <li>via DockerStation on the QNAP I installed postgres and
                pgadmin via <a
                  href="https://github.com/khezen/compose-postgres"
                  moz-do-not-send="true">this docker compose</a> </li>
              <li>the only thing I changed in the process was the
                POSTGRES_PASSWORD in the yml.</li>
              <li>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.</li>
              <li>However, pgadmin says that those are the wrong user
                credentials.</li>
              <li>I logged into the docker terminal for my docker
                container and checked the environment which confirms the
                above values are indeed correct.</li>
            </ul>
          </div>
          <div><br>
          </div>
          <div>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.</div>
          <div><br>
          </div>
          <div>If someone would be able to assist with this, that would
            be amazing.</div>
          <div><br>
          </div>
          <div>Cheers,</div>
          <div>frank</div>
        </div>
      </blockquote>
      <pre class="moz-signature" cols="72">-- 
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012</pre>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Angular momentum makes the world go 'round.</div>
  </body>
</html>

--------------EKBxC09xAOJM4vpRkZIN5OGb--