From c2fc260fd2f84fd438b7eaa88b69c46489b93c98 Mon Sep 17 00:00:00 2001 From: Tatsuo Ishii Date: Thu, 13 Sep 2018 15:02:03 +0900 Subject: [PATCH] Downgrade warning to debug5 when AES/PLAIN password not found in pool_passwd. When health_check_password etc. is an empty string, Pgpool-II tries to fetch AES/PLAIN password in pool_passwd. If other type of password entry (actually it must be MD5), it warned it. However this is normal setting till 3.7. Moreover, every time health check or streaming replication delay check run, it emits the waring and the log file was filled up with the message. Solution is, downgrade the message to DEBUG5. Also add password type to the message. --- src/auth/pool_passwd.c | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/src/auth/pool_passwd.c b/src/auth/pool_passwd.c index d9033290d..bbc33b9a0 100644 --- a/src/auth/pool_passwd.c +++ b/src/auth/pool_passwd.c @@ -512,9 +512,13 @@ get_pgpool_config_user_password(char *username, char *password_in_config) if (password && strlen(password) && passwordType != PASSWORD_TYPE_PLAINTEXT) { - ereport(WARNING, + /* + * Could not find plain text password in pool_passwd corresponding to the user. + * This is normal. Just use empty password in pgpool.conf. + */ + ereport(DEBUG5, (errmsg("could not get the password for user:%s", username), - errdetail("username \"%s\" has invalid password type", username))); + errdetail("username \"%s\" has invalid password type: %d", username, passwordType))); password = NULL; } if (password) -- 2.39.5