Home

pgbouncer log from failure

2019-09-21 18:31:40.344 EDT [11551] LOG kernel file descriptor limit: 1024 (hard: 524288); max_client_conn: 100, max expected fd use: 112
2019-09-21 18:31:40.344 EDT [11551] LOG listening on 0.0.0.0:6543
2019-09-21 18:31:40.344 EDT [11551] LOG listening on [::]:6543
2019-09-21 18:31:40.344 EDT [11551] LOG listening on unix:/tmp/.s.PGSQL.6543
2019-09-21 18:31:40.345 EDT [11551] LOG process up: PgBouncer 1.11.0, libevent 2.1.8-stable (epoll), adns: libc-2.29, tls: OpenSSL 1.1.1c FIPS  28 May 2019
2019-09-21 18:31:40.403 EDT [11551] LOG C-0x555702465bf0: (nodb)/(nouser)@[::1]:49266 registered new auto-database: db=postgres
2019-09-21 18:31:40.405 EDT [11551] LOG S-0x55570247dd40: postgres/pgbouncer@[::1]:5678 new connection to server (from [::1]:49760)
2019-09-21 18:31:40.443 EDT [11551] LOG S-0x55570247dd40: postgres/pgbouncer@[::1]:5678 SSL established: TLSv1.3/TLS_AES_256_GCM_SHA384/ECDH=prime256v1
2019-09-21 18:31:40.458 EDT [11551] LOG C-0x555702465bf0: postgres/larry@[::1]:49266 login attempt: db=postgres user=larry tls=TLSv1.3/TLS_AES_256_GCM_SHA384
2019-09-21 18:31:40.485 EDT [11551] ERROR C-0x555702465bf0: postgres/larry@[::1]:49266 unexpected SCRAM channel-binding attribute in client-final-message
2019-09-21 18:31:40.485 EDT [11551] LOG C-0x555702465bf0: postgres/larry@[::1]:49266 closing because: SASL authentication failed (age=0s)
2019-09-21 18:31:40.485 EDT [11551] WARNING C-0x555702465bf0: postgres/larry@[::1]:49266 pooler error: SASL authentication failed
2019-09-21 18:31:40.502 EDT [11551] LOG got SIGTERM, fast exit

bounccer.ini

[databases]
* = host=localhost port=5678
[pgbouncer]
listen_port = 6543
listen_addr = *
auth_type = scram-sha-256
auth_file = users.txt
logfile = pgbouncer.log
pidfile = pgbouncer.pid
admin_users = pgbouncer
client_tls_sslmode = prefer
client_tls_cert_file = server.crt
client_tls_key_file = server.key
client_tls_ca_file = root.crt
client_tls_protocols = secure
server_tls_sslmode = verify-full
server_tls_cert_file = pgbouncer.crt
server_tls_key_file = pgbouncer.key
server_tls_ca_file = root.crt
server_tls_protocols = secure

auth_user = pgbouncer
auth_query = select * from auth_user_info($1)