pg.ddx.io pgbouncer/pgbouncer GitHub issues and pull requestshelp / 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