pgpool2.git / summary / log / commit / refs

commit    c2fc260fd2f84fd438b7eaa88b69c46489b93c98
Author:   Tatsuo Ishii <ishii@sraoss.co.jp>
Date:     Thu Sep 13 06:02:03 2018 +0000

    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)


[parent: c070e09a4446]