Re: postgres 12 password failure port 5433
Zahid Rahman <[email protected]> Sun, 15 Dec 2019 16:10:08 +0000
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <CAPGSW3QFh2GcKUAfL68YZ80vh28COeykGtdDdDdr3sFh+9YDOg@mail.gmail.com> |
--000000000000d255360599c05428 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable This is my ubuntu terminal prompt with root username. kub18@UB18:~ I then types *kub18@UB18:~$ su - postgresPassword:postgres@UB18:~$ * As you can see the password for user 'postgres' have been accepted and the prompt has changed. I then typed: postgres@UB18:~$ psql -p 5433 -h localhost i am then prompted for postgres password *Password for user postgres:* I then typed password the error message *psql: error: could not connect to server: FATAL: password authentication failed for user "postgres"FATAL: password authentication failed for user "postgres"* result of sudo cat /etc/postgresql/12/main/pg_hba.conf I have not included the comment header. # Database administrative login by Unix domain socket local all postgres peer # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 # Allow replication connections from localhost, by a user with the # replication privilege. local replication all peer host replication all 127.0.0.1/32 md5 host replication all ::1/128 md5 On Sun, 15 Dec 2019, 15:34 Arlindo Neto, <[email protected]> wrote: > Are you lagged in as postgres user or root? You need to be logged in as > postgres in order to use psql. > > Just =E2=80=98su - postgres=E2=80=99 as root and try to use psql again. > If it still doesn't work, send us your /etc/postgresql/11/main/pg_hba.con= f > > On Sun, 15 Dec 2019 at 12:19 Zahid Rahman <[email protected]> wrote: > >> Hi, >> I have postgres 10 running on 5432 and pgadmin is connecting ok. >> >> I have just installed postgres 12 on ubuntu 18.04 using apt-get instal= l >> I have the following success messages (see below) >> I have verified that I have a database running at 5433 programmatically. >> The PGADMIN4 "postgres admin tool" is giving an error "UNAUTHORISED >> message (see below) >> WHEN i TRY TO LOGIN USING PSQL CONSOLE using command line >> psql -U postgres -p 5433 -h localhostI get an password error message >> psql: error: could not connect to server: FATAL: password authenticatio= n >> failed for user "postgres" >> FATAL: password authentication failed for user "postgres" >> >> Unauthorized >> >> The server could not verify that you are authorized to access the URL >> requested. You either supplied the wrong credentials (e.g. a bad passwor= d), >> or your browser doesn't understand how to supply the credentials require= d. >> >> >> >> >> >> >> Success. You can now start the database server using: >> pg_ctlcluster 12 main start >> >> Ver Cluster Port Status Owner Data directory Log file >> 12 main 5433 down postgres /var/lib/postgresql/12/main >> /var/log/postgresql/postgresql-12-main.log >> >> >> >> >> >> >> --000000000000d255360599c05428 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable <div dir=3D"ltr"><div dir=3D"auto"><div style=3D"font-family:sans-serif;fon= t-size:12.8px" dir=3D"auto">This is my ubuntu terminal prompt with root use= rname.</div><div style=3D"font-family:sans-serif;font-size:12.8px" dir=3D"a= uto"><br></div><div style=3D"font-family:sans-serif;font-size:12.8px" dir= =3D"auto">kub18@UB18:~</div><div style=3D"font-family:sans-serif;font-size:= 12.8px" dir=3D"auto"><br></div><div style=3D"font-family:sans-serif;font-si= ze:12.8px" dir=3D"auto">I then types=C2=A0</div><div style=3D"font-family:s= ans-serif;font-size:12.8px" dir=3D"auto"><i>kub18@UB18:~$ su - postgres<br>= Password:<br>postgres@UB18:~$=C2=A0</i></div><div style=3D"font-family:sans= -serif;font-size:12.8px" dir=3D"auto">As you can see the password for user = 'postgres' have been accepted and the prompt has changed.</div><div= style=3D"font-family:sans-serif;font-size:12.8px" dir=3D"auto"><br></div><= div style=3D"font-family:sans-serif;font-size:12.8px" dir=3D"auto">I then t= yped:</div><div style=3D"font-family:sans-serif;font-size:12.8px" dir=3D"au= to">postgres@UB18:~$ psql -p 5433 -h localhost</div><div style=3D"font-fami= ly:sans-serif;font-size:12.8px" dir=3D"auto">i am then prompted for postgre= s password</div><div style=3D"font-family:sans-serif;font-size:12.8px" dir= =3D"auto"><br></div><div style=3D"font-family:sans-serif;font-size:12.8px" = dir=3D"auto"><i>Password for user postgres:</i></div><div style=3D"font-fam= ily:sans-serif;font-size:12.8px" dir=3D"auto"><br></div><div style=3D"font-= family:sans-serif;font-size:12.8px" dir=3D"auto">I then typed password<br><= /div><div style=3D"font-family:sans-serif;font-size:12.8px" dir=3D"auto">th= e error message=C2=A0<br></div><div style=3D"font-family:sans-serif;font-si= ze:12.8px" dir=3D"auto"><i>psql: error: could not connect to server: FATAL:= =C2=A0password authentication failed for user "postgres"<br>FATA= L: =C2=A0password authentication failed for user "postgres"</i></= div><div style=3D"font-family:sans-serif;font-size:12.8px"><br></div><div s= tyle=3D"font-family:sans-serif;font-size:12.8px">result of=C2=A0 sudo cat /= etc/postgresql/12/main/pg_hba.conf</div><div style=3D"font-family:sans-seri= f;font-size:12.8px">I have not included the comment header.</div><div style= =3D"font-family:sans-serif;font-size:12.8px"><br></div><div style=3D"font-f= amily:sans-serif;font-size:12.8px" dir=3D"auto"># Database administrative l= ogin by Unix domain socket<br>local =C2=A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 postgres =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0peer<br><br># TY= PE =C2=A0DATABASE =C2=A0 =C2=A0 =C2=A0 =C2=A0USER =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0ADDRESS =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 METHOD<br><br># "local" is for Unix domain socket connecti= ons only<br>local =C2=A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 all = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 peer<br># IPv4 local c= onnections:<br>host =C2=A0 =C2=A0all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a href=3D"http://127.0.0= .1/32" target=3D"_blank">127.0.0.1/32</a> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0md5<br># IPv6 local connections:<br>host =C2=A0 =C2=A0all =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 ::1/128 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 md5<= br># Allow replication connections from localhost, by a user with the<br># = replication privilege.<br>local =C2=A0 replication =C2=A0 =C2=A0 all =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 peer<br>host =C2=A0 =C2=A0rep= lication =C2=A0 =C2=A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 <a hre= f=3D"http://127.0.0.1/32" target=3D"_blank">127.0.0.1/32</a> =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0md5<br>host =C2=A0 =C2=A0replication =C2=A0 =C2= =A0 all =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ::1/128 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 md5<br></div><div style=3D"font-fami= ly:sans-serif;font-size:12.8px" dir=3D"auto"><br></div></div></div><br><div= class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, 15 Dec= 2019, 15:34 Arlindo Neto, <<a href=3D"mailto:[email protected]" target= =3D"_blank">[email protected]</a>> wrote:<br></div><blockquote class=3D= "gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(2= 04,204,204);padding-left:1ex"><div><div dir=3D"auto">Are you lagged in as p= ostgres user or root? You need to be logged in as postgres in order to use = psql.</div></div><div dir=3D"auto"><br></div><div dir=3D"auto">Just =E2=80= =98su - postgres=E2=80=99 as root and try to use psql again.</div><div dir= =3D"auto">If it still doesn't work, send us your /etc/postgresql/11/mai= n/pg_hba.conf=C2=A0</div><div><br><div class=3D"gmail_quote"><div dir=3D"lt= r" class=3D"gmail_attr">On Sun, 15 Dec 2019 at 12:19 Zahid Rahman <<a hr= ef=3D"mailto:[email protected]" rel=3D"noreferrer" target=3D"_blank">zah= [email protected]</a>> wrote:<br></div><blockquote class=3D"gmail_quote"= style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p= adding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr"><div>Hi,</div><div>I hav= e postgres 10 running on 5432 and pgadmin is connecting=C2=A0 ok.</div><div= ><br></div><div>=C2=A0I have just installed postgres 12 on ubuntu 18.04=C2= =A0 using apt-get install<br></div><div>I have the following=C2=A0 success = messages (see below)</div><div>I have verified that I have a database runni= ng at 5433 programmatically.</div><div>The PGADMIN4 "postgres admin to= ol" is giving an error "UNAUTHORISED message (see below)<br></div= ><div><h1><span style=3D"font-weight:normal"><font size=3D"2">WHEN i TRY TO= LOGIN USING=C2=A0 PSQL CONSOLE using command line <br></font></span></h1><= h1><span style=3D"font-weight:normal"><font size=3D"2">psql -U postgres =C2= =A0-p 5433 -h localhost</font></span></h1><h1><span style=3D"font-weight:no= rmal"><font size=3D"2">I get an password=C2=A0 error message</font></span><= font size=3D"1"> psql: error: could not connect to server: FATAL: =C2=A0pas= sword authentication failed for user "postgres"</font><br></h1><d= iv>FATAL: =C2=A0password authentication failed for user "postgres"= ;<br></div><div><br></div><h1>Unauthorized</h1> <p>The server could not verify that you are authorized to access the URL requested. You either supplied the wrong credentials (e.g. a bad=20 password), or your browser doesn't understand how to supply the=20 credentials required.</p></div><div> <br></div><div><br></div><div><br></di= v><div> <br></div><div><br></div><div><br></div><div>Success. You can now s= tart the database server using: <br>pg_ctlcluster 12 main start<br><br>Ver = Cluster Port Status Owner =C2=A0 =C2=A0Data directory =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0Log file<br>12 =C2=A0main =C2=A0 =C2=A05433 down= =C2=A0 postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql= -12-main.log</div><div><br></div><div><br></div><div><br></div><div> <br></= div><div><br></div><div><br></div></div></div> </blockquote></div></div> </blockquote></div> --000000000000d255360599c05428--