FATAL: server login failed: wrong password type

[kerren]

Hi everyone,

When I tried to put pgbouncer between my containers and started it up, I saw the following error when querying the database:

SQLSTATE[08006] [7] connection to server at "pgbouncer" (x.x.x.x), port 5432 failed: FATAL:  server login failed: wrong password type (SQL: select * from "user" where "user"."deleted_at" is null limit 1).

---

SOLUTION:
When looking through the issues, there were some comments about the AUTH_TYPE so I looked at the entrypoint.sh file and I see that if you set it to plain or scram-sha-256 it'll use those, otherwise it'll use md5.

So to fix the problem (specifically for me), I set the AUTH_TYPE environment variable to scram-sha-256 and that worked.

I see that there is a PR to add a comment for postgres >= 14 where it adds this in the docker-compose.yaml file https://github.com/edoburu/docker-pgbouncer/pull/90/files. However, this would have to be updated for standard docker and kubernetes as well.

[jflambert]

I'll merge the other PR thanks for the bump.

What did you mean by docker and kubernetes?

[kerren]

Thanks @jflambert !

I just mean that this would be applicable on all setups, not just the docker-compose.yaml file. For docker people would have to use the -e flag and for kubernetes, people would have to set it in the env: key in the deployment yaml file.