Pgpooladmin 3.5.2 error code e1014 could not read the .pcppass file

Question

What the error looks like

Right

Anyone have to solve the problem?

Answer 1

The .pcppass file is not in the specified directory.

To solve the problem, you should do this:

http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_comand_password

Make sure that the .pcppass file has permission 0600. You may also need to change the owner / group to apache / www-data, depending on your system.

Answer 2

The page in the link ( http://www.pgpool.net/docs/latest/pgpool-en.html#pcp_comand_password ) is no longer present in the published solution.

, .pcppass postgres /var/www/ apache.

sudo cp /home/postgres/.pcppass /var/www/

sudo chown apache /var/www/.pcppass

sudo chmod 600 /var/www/.pcppass

Answer 3

Hello everyone)

• check and determine the home directory / var / www for www-data (or apache) in / etc / passwd

www-data:x:33:33:www-data:/var/www:/usr/sbin/nologin

2. check owner and rights

chown www-data /var/www/.pcppass

chmod 0600 /var/www/.pcppass

3. check .pcppass format

host:port:user:password in plain text

Each of the first three fields can be a literal value or *, which matches any