0

I'm trying to connect on My pgpool install (3 Nodes)

I'm using a virtual IP adress to connect to my master server. If i reach directly Postgresql, it works:

    psql -h *virtual IP* -U postgres -p 5432

but as soon as i try 

    psql -h *virtual IP* -U postgres -p 5433

Server respond back:

    psql: ERROR:  authentication failed
    DÉTAIL : invalid backend response. Response does not replied with "R"

Note that when i type a wrong password, awnser from the serer is different. I tried:

Setup pool_hba
Checking if md5 password is different in pool_passwd than in Postgresql
Restarting services
Trying to connect from a different User
Tried to set pool_passwd owner to postgres

What am i doing wrong ? My latest tests were good with 2 nodes.

Everything is working fine on postgresql, can connect from everywhere with postgres...

pg_hba:

    host    all             all             0.0.0.0/0            md5

Thanks

Rakath
  • 1
  • 3
  • What versions are you using? What authentication method are you using? It says something about md5, but is that what your pg_hba actually says? – jjanes Apr 21 '20 at 15:56
  • And is your stored password stored in md5 format? (md5 in pg_hba really means md5 or scram, not just exactly md5) – jjanes Apr 21 '20 at 16:04
  • @jjanes i'm Using md5 and version 4.0.2, i added pg_hba line on my post – Rakath Apr 21 '20 at 16:09
  • What about version of PostgreSQL? Also, what is your OS? Is it MacOS, which has some known problems with GSS (even if you aren't trying to use GSS)? – jjanes Apr 21 '20 at 16:18
  • I'm currently on a Debian 10 VM, using postgresql 11. Not trying to use GSS :( – Rakath Apr 22 '20 at 07:30
  • What if you use the real IP address? I don't see how that could make a difference, but I don't know what else could cause the problem either. – jjanes Apr 27 '20 at 17:01
  • Using the machine IP instead of the VIP is not working neither ;( – Rakath Apr 28 '20 at 09:47
  • It works for me (postgres and pgpool2 both installed from Debian's apt repo, both on the same machine), so I think there is something peculiar about either your installation method, or your configuration. – jjanes Apr 28 '20 at 13:56
  • Will look deeper into it so. Thx for the awnser anyway – Rakath Apr 28 '20 at 14:51

1 Answers1

0

Try to login through psql on the master replica first without using pgpool. In my case the postgres password was set to null/undefined. Therefore I got the same error message as you.

Hope that helps.

Tobias Ernst
  • 4,214
  • 1
  • 32
  • 30