Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings
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)
Clone this wiki locally

[8]ページ先頭

©2009-2025 Movatter.jp