pg.ddx.io  pgbouncer/pgbouncer GitHub issues and pull requests  
help / color / mirror / Atom feed
[pgbouncer/pgbouncer] issue #410: [users] section setup not working properly with auth_query
4+ messages / 3 participants
[nested] [flat]

* [pgbouncer/pgbouncer] issue #410: [users] section setup not working properly with auth_query
@ 2019-08-27 21:55 "jbaanus (@jbaanus)" <noreply+jbaanus@github.com>
  0 siblings, 0 replies; 4+ messages in thread

From: jbaanus (@jbaanus) @ 2019-08-27 21:55 UTC (permalink / raw)
  To: pgbouncer/pgbouncer <noreply+pgbouncer-pgbouncer@github.com>

I have configured pgbouncer 1.9.0 accordingly in Debian (short version):
```
[databases]
db1 = db1.myhost.com

[users]
user2 = pool_mode=session

[pgbouncer]
auth_type = md5
auth_file = /etc/pgbouncer/userlist.txt
auth_user = pgbouncer
auth_query = SELECT p_user, p_password FROM public.pgbouncer_lookup($1)

pool_mode = transaction
```

When I connect using `user1` then everything is working as expected, but when I connect using `user2` the custom `pool_mode=session` is not applied as defined in `[users]` section.

Also seems like I need to add `auth_user=pgbouncer` in users section as well to get it working.

Did some more digging as well:

1) I set pool_mode=session auth_user=pgbouncer in [users] section => I can log in, but default pool_mode=transaction will be used and authenticated using auth_query
2) I set pool_mode=session in [users] section and configure user in auth_file => pool_mode=session would be used and authenticated from auth_file
3) I set pool_mode=session auth_user=pgbouncer in [users] section + configure user in auth_file => I can log in, but default pool_mode=transaction will be used and auth_query will be used for authentication

^ permalink  raw  [nested|flat] 4+ messages in thread

* Re: [pgbouncer/pgbouncer] issue #410: [users] section setup not working properly with auth_query
@ 2019-09-05 14:21 ` "mickegustavsson (@mickegustavsson)" <noreply+mickegustavsson@github.com>
  2 siblings, 0 replies; 4+ messages in thread

From: mickegustavsson (@mickegustavsson) @ 2019-09-05 14:21 UTC (permalink / raw)
  To: pgbouncer/pgbouncer <noreply+pgbouncer-pgbouncer@github.com>

I have a similar problem but with auth_type pam.
pool_mode set on user have no effect.

^ permalink  raw  [nested|flat] 4+ messages in thread

* Re: [pgbouncer/pgbouncer] issue #410: [users] section setup not working properly with auth_query
@ 2026-11-08 13:25 ` "eulerto (@eulerto)" <noreply+eulerto@github.com>
  2 siblings, 0 replies; 4+ messages in thread

From: eulerto (@eulerto) @ 2026-11-08 13:25 UTC (permalink / raw)
  To: pgbouncer/pgbouncer <noreply+pgbouncer-pgbouncer@github.com>

This is a really old issue. Due to the various improvements in this area (specially PR #1052 that refactored user management and was introduced in version 1.23.0), I don't think there is any issues with the scenarios you described. For future reference, see `test_auth_query_works_with_configured_users` (`test/test_auth.py`).

^ permalink  raw  [nested|flat] 4+ messages in thread

* Re: [pgbouncer/pgbouncer] issue #410: [users] section setup not working properly with auth_query
@ 2026-11-08 13:25 ` "eulerto (@eulerto)" <noreply+eulerto@github.com>
  2 siblings, 0 replies; 4+ messages in thread

From: eulerto (@eulerto) @ 2026-11-08 13:25 UTC (permalink / raw)
  To: pgbouncer/pgbouncer <noreply+pgbouncer-pgbouncer@github.com>

@eulerto closed this.

^ permalink  raw  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2026-11-08 13:25 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-08-27 21:55 [pgbouncer/pgbouncer] issue #410: [users] section setup not working properly with auth_query "jbaanus (@jbaanus)" <noreply+jbaanus@github.com>
2019-09-05 14:21 ` "mickegustavsson (@mickegustavsson)" <noreply+mickegustavsson@github.com>
2026-11-08 13:25 ` "eulerto (@eulerto)" <noreply+eulerto@github.com>
2026-11-08 13:25 ` "eulerto (@eulerto)" <noreply+eulerto@github.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox