- Notifications
You must be signed in to change notification settings - Fork1
Home
Andrew Dunstan edited this pageOct 1, 2019 ·1 revision
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: 1122019-09-21 18:31:40.344 EDT [11551] LOG listening on 0.0.0.0:65432019-09-21 18:31:40.344 EDT [11551] LOG listening on [::]:65432019-09-21 18:31:40.344 EDT [11551] LOG listening on unix:/tmp/.s.PGSQL.65432019-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 20192019-09-21 18:31:40.403 EDT [11551] LOG C-0x555702465bf0: (nodb)/(nouser)@[::1]:49266 registered new auto-database: db=postgres2019-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=prime256v12019-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_SHA3842019-09-21 18:31:40.485 EDT [11551] ERROR C-0x555702465bf0: postgres/larry@[::1]:49266 unexpected SCRAM channel-binding attribute in client-final-message2019-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 failed2019-09-21 18:31:40.502 EDT [11551] LOG got SIGTERM, fast exit
bounccer.ini
[databases]* = host=localhost port=5678[pgbouncer]listen_port = 6543listen_addr = *auth_type = scram-sha-256auth_file = users.txtlogfile = pgbouncer.logpidfile = pgbouncer.pidadmin_users = pgbouncerclient_tls_sslmode = preferclient_tls_cert_file = server.crtclient_tls_key_file = server.keyclient_tls_ca_file = root.crtclient_tls_protocols = secureserver_tls_sslmode = verify-fullserver_tls_cert_file = pgbouncer.crtserver_tls_key_file = pgbouncer.keyserver_tls_ca_file = root.crtserver_tls_protocols = secureauth_user = pgbouncerauth_query = select * from auth_user_info($1)