Re: Resetting the pgadmin4 web user credentials - Mailing list pgadmin-support

From richard coleman
Subject Re: Resetting the pgadmin4 web user credentials
Date
Msg-id CAGA3vBvniDYGf_B_c40MEiYCp4zrfKCr0=gFy++wmstNa5RrAA@mail.gmail.com
Whole thread Raw
In response to Re: Resetting the pgadmin4 web user credentials  (Kevin Struckhoff <kevinstruckhoff@yahoo.com>)
Responses Re: Resetting the pgadmin4 web user credentials  (Kevin Struckhoff <kevinstruckhoff@yahoo.com>)
List pgadmin-support
Kevin, 
I don't think that the pgAdmin user and the database user are necessarily the same thing (though I could be wrong) [see: https://www.pgadmin.org/docs/pgadmin4/5.4/user_management.html ].  The pg_hba.conf file defines what users/machines/methods are allowed to connect to a postgresql server.  So for the first line in your example:

host    all             all             my.dbserver.ip.addr/32 trust  

this would mean; host  == connections made over TCP/IP, the first all == which databases, the second all == which users, the my.dbserver.ip.addr/32 == means only allow connections originating from that exact ip address, and trust == allow connections without a password or any other form of authentication [see: https://www.postgresql.org/docs/13/auth-pg-hba-conf.html ].  I am guessing that you have gotten the pgAdmin users confused with the postgresql database users.  

I would imagine that the pgAdmin server would need an entry in the pg_hba.conf file for whatever machine pgAdmin is running on and I would be amazed if it was using trust (or no authentication) to connect with.  I use pgAdmin exclusively in desktop mode, so hopefully someone else who's more familiar with server mode will chime in.

I hope that helps, 

rik.




On Tue, Jul 27, 2021 at 6:28 PM Kevin Struckhoff <kevinstruckhoff@yahoo.com> wrote:
Sorry re-posting with a corrected subject.

Thanks. Kevin


On Tuesday, July 27, 2021, 3:20:39 PM PDT, Kevin Struckhoff <kevinstruckhoff@yahoo.com> wrote:


After getting pgadmin4 installed and configured, I've found out that the user credentials I specified during the setup don't work very well. I've added the user to the postgres db using the adduser command. I updated the pg_hba.conf file with an entry just for the user but I get this error when trying to connect for the 1st time:

FATAL: no pg_hba.conf entry for host " my.dbserver.ip.addr", user "p@p.com", database "postgres", SSL off

psql postgres
postgres-# adduser p@p.com
postgres-#\q

pg_hba.conf entries (actual ip number hidden):

host    all             all             my.dbserver.ip.addr/32 trust   
host    all             p@p.com         my.dbserver.ip.addr /32 trust    # for pgadmin4 web

So I would have thought the 1st entry would cover all users. I can't create a linux user because the user name is invalid:

useradd: invalid user name 'p@p.com'

So to make it work, I'd just like to set the username/password to the postgres user. Where can I do that? I don't see a .py or .conf file other than pg_hba.conf where the user is defined.

Thanks. Kevin

pgadmin-support by date:

Previous
From: Kevin Struckhoff
Date:
Subject: Re: Resetting the pgadmin4 web user credentials
Next
From: Kevin Struckhoff
Date:
Subject: Re: Resetting the pgadmin4 web user credentials