[Pgpool-general] what is /usr/local/etc/pool_passwd

[Jose Mendoza]

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: pgpool-general-bounces at pgfoundry.org
[mailto:pgpool-general-bounces at pgfoundry.org] On Behalf Of Tatsuo Ishii
Sent: Monday, April 25, 2011 6:48 PM
To: josh at agliodbs.com
Cc: pgpool-general at pgfoundry.org
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
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general