Tastsuo, I am not very well versed but I am troubleshooting ppgool issues as well.
Did you check your pgpool.conf file? If you place a setting for your password there that might be the reason. Also, check your permission on that file. Make sure the user you configured has permission to read the file. Jose Autonomy Ops verificare tua hinc -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tatsuo Ishii Sent: Monday, April 25, 2011 6:48 PM To: [email protected] Cc: [email protected] Subject: Re: [Pgpool-general] what is /usr/local/etc/pool_passwd > Tatsuo, > > Got this error: > > pool_init_pool_passwd: couldn't open /usr/local/etc/pool_passwd. reason: > Permission denied > > What the heck is pgpool_passwd? That file is not in the documentation > anywhere. It's documented: Authentication / Access Controls * In the replication mode or master/slave mode, trust, clear text password, and pam methods are supported. md5 in also supported since pgpool-II 3.0. md5 is supported by using "pool_passwd". Here are the steps to enable md5 authentication: 1. Login as the database's operating system user and type "pg_md5 --md5auth " user name and md5 encrypted password are registered into pool_passwd. If pool_passwd does not exist yet, pg_md5 command will automatically create it for you. 2. The format of pool_passwd is "username:encrypted_passwd". 3. You also need to add an appropriate md5 entry to pool_hba.conf. See Setting up pool_hba.conf for client authentication (HBA) for more details. 4. Please note that the user name and password must be identical to those registered in PostgreSQL. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
