View Single Post
  #1   (View Single Post)  
Old 30th October 2019
CiotBSD CiotBSD is offline
c107:b5d::
 
Join Date: Jun 2019
Location: Under /
Posts: 132
Default [6.6] Postresql error on auth

Hi all

I've a problem with postgresql when attemp to auth new user.

FYI: I start completely with Postgresql. Usually I use MySQL*
Postgresql has just been installed.

Error message:
Code:
psql: FATAL:  password authentication failed for user "***"
----

Demo:

Code:
srvr# su - _postgresql
srvr$ psql -U postgres
Password for user postgres:
psql (11.5)
Type "help" for help.

postgres=# CREATE USER ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2 WITH PASSWORD
'6TsrKeqq93KyVtc5yVjU9dfZsJkPPtKKdSyEnjypZDkVdgtW4aVN3YNQd5vKoFNx';
CREATE ROLE
postgres=# \connect template1
You are now connected to database "template1" as user "postgres".
template1=# CREATE DATABASE "A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2" WITH
ENCODING 'UTF-8';"
CREATE DATABASE
template1"# GRANT ALL PRIVILEGES ON DATABASE
"A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2" TO ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2;
template1"# ALTER DATABASE "A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2" OWNER TO
ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2;
template1"# \q
Use control-D to quit.
template1"# \q
srvr$ exit
In fact, I have one created user, named ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2
His password:
6TsrKeqq93KyVtc5yVjU9dfZsJkPPtKKdSyEnjypZDkVdgtW4a VN3YNQd5vKoFNx
One created DB, named:
A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2

And the user ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2 has all rights on DB
A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2

Right?!

But, when I attempt to connect to DB with user, I have the above the error message:
Code:
# psql -U ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2
Password for user ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2:
psql: FATAL:  password authentication failed for user
"ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2"

# psql -U ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2 -d
A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2
Password for user ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2:
psql: FATAL:  password authentication failed for user
"ghiMDQawgogUfFRTikPoWsUFN1xX8bgz2"
Ok I found it's necessary to change informations into file 'pg_hba.conf'. I set as:
Code:
# grep A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2 /var/postgresql/data/pg_hba.conf
local A5mSHO4SamFa2OJmJC81GbDtUhj4wkyU2 all        trust
And restart the service/daemon postgresql.

Despite, I cant connect on!

---

Any idea?

FYI: I posted this issue, today, on list @misc.
Reply With Quote