Re: postgres 12 password failure port 5433
Zahid Rahman <[email protected]> Sun, 15 Dec 2019 16:24:08 +0000
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <CAPGSW3Sy_gsOK0Y-CGEhSz1f8BzRRm41ZhmfL_kuL2kPm__D8g@mail.gmail.com> |
--000000000000e897820599c086eb
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
programmatically :
try {
System.out.println("Opening database ....");
Start =3D System.currentTimeMillis();
Connection conn =3D null;
Class.forName("org.postgresql.Driver");
conn =3D DriverManager
.getConnection("jdbc:postgresql://localhost:5433/events",
"postgres", "postgres");
conn.close();
} catch (Exception e) {
Opening database ....
org.postgresql.util.PSQLException: FATAL: password authentication failed
for user "postgres"
at
org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFac=
toryImpl.java:520)
at
org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryIm=
pl.java:141)
at
org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionF=
actoryImpl.java:192)
at
org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java=
:49)
at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:211)
at org.postgresql.Driver.makeConnection(Driver.java:458)
at org.postgresql.Driver.connect(Driver.java:260)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at PostgresJdbc.main(PostgresJdbc.java:15)
org.postgresql.util.PSQLException: FATAL: password authentication failed
for user "postgres"
On Sun, 15 Dec 2019 at 16:10, Zahid Rahman <[email protected]> wrote:
> 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 th=
e
> 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 authenticatio=
n
> 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.conf
>>
>> 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 insta=
ll
>>> 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 authenticati=
on
>>> 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 passwo=
rd),
>>> or your browser doesn't understand how to supply the credentials requir=
ed.
>>>
>>>
>>>
>>>
>>>
>>>
>>> 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
>>>
>>>
>>>
>>>
>>>
>>>
>>>
--000000000000e897820599c086eb
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div>programmatically :</div><div><br></div><div>=C2=A0try=
{<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0System.out.println("O=
pening database ....");<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
Start =3D System.currentTimeMillis();<br> =C2=A0 =C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0 Connection conn =3D null;<br> =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0Class.forName("org.postgresql.Driver")=
;<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0conn =3D DriverManager<br> =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0.getConnection("jdbc:postgre=
sql://localhost:5433/events",<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0"postgres", "postgres");<br> =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0conn.close();<br> =C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>=
=C2=A0 =C2=A0 =C2=A0} catch (Exception e) {</div><div><br></div><div>Open=
ing database ....<br>org.postgresql.util.PSQLException: FATAL: password aut=
hentication failed for user "postgres"<br> at org.postgresql.core=
.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:520)<=
br> at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFa=
ctoryImpl.java:141)<br> at org.postgresql.core.v3.ConnectionFactoryImpl.ope=
nConnectionImpl(ConnectionFactoryImpl.java:192)<br> at org.postgresql.core.=
ConnectionFactory.openConnection(ConnectionFactory.java:49)<br> at org.post=
gresql.jdbc.PgConnection.<init>(PgConnection.java:211)<br> at org.pos=
tgresql.Driver.makeConnection(Driver.java:458)<br> at org.postgresql.Driver=
.connect(Driver.java:260)<br> at java.sql.DriverManager.getConnection(Drive=
rManager.java:664)<br> at java.sql.DriverManager.getConnection(DriverManage=
r.java:247)<br> at PostgresJdbc.main(PostgresJdbc.java:15)<br>org.postgresq=
l.util.PSQLException: FATAL: password authentication failed for user "=
postgres"</div><div><br></div></div><br><div class=3D"gmail_quote"><di=
v dir=3D"ltr" class=3D"gmail_attr">On Sun, 15 Dec 2019 at 16:10, Zahid Rahm=
an <<a href=3D"mailto:[email protected]">[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);padding-left:1ex"><div dir=
=3D"ltr"><div dir=3D"auto"><div style=3D"font-family:sans-serif;font-size:1=
2.8px" dir=3D"auto">This is my ubuntu terminal prompt with root username.</=
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">=
kub18@UB18:~</div><div style=3D"font-family:sans-serif;font-size:12.8px" di=
r=3D"auto"><br></div><div style=3D"font-family:sans-serif;font-size:12.8px"=
dir=3D"auto">I then types=C2=A0</div><div style=3D"font-family:sans-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;fon=
t-size:12.8px" dir=3D"auto">As you can see the password for user 'postg=
res' 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 typed:</di=
v><div style=3D"font-family:sans-serif;font-size:12.8px" dir=3D"auto">postg=
res@UB18:~$ psql -p 5433 -h localhost</div><div style=3D"font-family:sans-s=
erif;font-size:12.8px" dir=3D"auto">i am then prompted for postgres passwor=
d</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"aut=
o"><i>Password for user postgres:</i></div><div style=3D"font-family:sans-s=
erif;font-size:12.8px" dir=3D"auto"><br></div><div style=3D"font-family:san=
s-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">the error me=
ssage=C2=A0<br></div><div style=3D"font-family:sans-serif;font-size:12.8px"=
dir=3D"auto"><i>psql: error: could not connect to server: FATAL: =C2=A0pas=
sword authentication failed for user "postgres"<br>FATAL: =C2=A0p=
assword authentication failed for user "postgres"</i></div><div s=
tyle=3D"font-family:sans-serif;font-size:12.8px"><br></div><div style=3D"fo=
nt-family:sans-serif;font-size:12.8px">result of=C2=A0 sudo cat /etc/postgr=
esql/12/main/pg_hba.conf</div><div style=3D"font-family:sans-serif;font-siz=
e:12.8px">I have not included the comment header.</div><div style=3D"font-f=
amily:sans-serif;font-size:12.8px"><br></div><div style=3D"font-family:sans=
-serif;font-size:12.8px" dir=3D"auto"># Database administrative login by Un=
ix 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># TYPE =C2=A0D=
ATABASE =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 METHO=
D<br><br># "local" is for Unix domain socket connections 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 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 <a href=3D"http://127.0.0.1/32" targ=
et=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 rep=
lication connections from localhost, by a user with the<br># replication pr=
ivilege.<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=A0replication =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>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-family:sans-ser=
if;font-size:12.8px" dir=3D"auto"><br></div></div></div><br><div class=3D"g=
mail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sun, 15 Dec 2019, 15:3=
4 Arlindo Neto, <<a href=3D"mailto:[email protected]" target=3D"_blank"=
>[email protected]</a>> wrote:<br></div><blockquote class=3D"gmail_quot=
e" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204)=
;padding-left:1ex"><div><div dir=3D"auto">Are you lagged in as postgres use=
r 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 - post=
gres=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/main/pg_hba.conf=
=C2=A0</div><div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"g=
mail_attr">On Sun, 15 Dec 2019 at 12:19 Zahid Rahman <<a href=3D"mailto:=
[email protected]" rel=3D"noreferrer" target=3D"_blank">zahidr1000@gmail=
.com</a>> wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"mar=
gin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1=
ex"><div dir=3D"ltr"><div dir=3D"ltr"><div>Hi,</div><div>I have postgres 10=
running on 5432 and pgadmin is connecting=C2=A0 ok.</div><div><br></div><d=
iv>=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 running at 5433 pro=
grammatically.</div><div>The PGADMIN4 "postgres admin tool" is gi=
ving an error "UNAUTHORISED message (see below)<br></div><div><h1><spa=
n 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 sty=
le=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:normal"><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=A0password authen=
tication failed for user "postgres"</font><br></h1><div>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>
</blockquote></div>
--000000000000e897820599c086eb--