Sorry Adrian, Below is the full error message.
2023-06-27 05:01:27.385 CDT| XXXXXXXXXXXXXXXXXXXXXXX (60930)| APPNAME=[unknown]| DB=postgres| USER=grafana| PID=9061| 1| authentication| PGE-28P01: FATAL: password authentication failed for user "grafana" 2023-06-27 05:01:27.385 CDT| XXXXXXXXXXXXXXXXXXXXXXX (60930)| APPNAME=[unknown]| DB=postgres| USER=grafana| PID=9061| 2| authentication| PGE-28P01: DETAIL: Connection matched pg_hba.conf line 113: "host all all 0.0.0.0/0 md5" On Mon, Jul 10, 2023 at 6:36 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 7/10/23 13:20, Johnathan Tiamoh wrote: > > > >> Ok Adrian, > >> > >> Postgres 9.5 > >> > >> postgresql.conf > >> > >> password_encryption = ? md5 ====> wish is the default for 9.5 > >> > >> pg_hba.conf -----------------> md5 > >> > >> Provide the relevant lines > >> > >> Postgres 14.8 > >> > >> postgresql.conf > >> > >> password_encryption = ? scram-sha-256 ====> which is the > >> default for 14.8 > >> > >> pg_hba.conf md5 > > > > You have not answered: > > > > 2) Provide the error messages received when trying to connect. > > [XXXXXXXXXXXXXXXXXXXXXXX| APPNAME=[unknown]| DB=proftpd| USER=proftpd| > > PID=9053| 2| authentication| PGE-28P01: DETAIL: Connection matched > > pg_hba.conf line 113: "host all all 0.0.0.0/0 > > <http://0.0.0.0/0> md5" > > > > The above is not showing any actual error. There should a part that says > what failed when connecting. > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
