View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000478Pgpool-IIBugpublic2019-03-23 00:232019-05-21 16:18
Reporterfiury Assigned Tot-ishii  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionopen 
Product Version4.0.1 
Summary0000478: pcp_proc_count authentication failed
DescriptionHi,

I'm stucked trying to make the pcp_proc_count works. I already checked these two incidents
https://www.pgpool.net/mantisbt/view.php?id=298
https://www.pgpool.net/mantisbt/view.php?id=187

SO: Centos 07

The .pcppass file has
*:*pgpool:pgool

Running pcp_proc_count -W -h localhost -p 9898 -U pgpool
Password:
FATAL: authentication failed for user "pgpool"
DETAIL: username and/or password does not match

The The port number where pcp is running on 9898 (pgpool.conf)

Why the authentication is failing? I'm trying with localhost and 9898 and it has *:* so it should work.

The user and password are plain text as the previous incidents said.

Thanks for any help
Steps To Reproduce1) Open pgpoolAdmin web interface
Then click on any of 'Process Info', 'Node Info' buttons or 'Node Status' tab and check "Backend info:
  pcp_node_count command error occurred,
  pcp_proc_count command error occurred
  etc...
2) Check web server error.log (/var/log/httpd/error.log in my case) for error message(s):
ERROR: connection to host "localhost" failed with error "Permission denied"
ERROR: connection to host "localhost" failed with error "Permission denied"
ERROR: connection to host "localhost" failed with error "Permission denied"
3) invoke
$pcp_proc_count -W -h localhost -p 9898 -U pgpool
Check that result is:
FATAL: authentication failed for user "pgpool"
DETAIL: username and/or password does not match
TagsNo tags attached.

Activities

fiury

2019-03-23 00:23

reporter  

pgpool settings.png (50,417 bytes)   
pgpool settings.png (50,417 bytes)   
pgpool version.png (19,545 bytes)   
pgpool version.png (19,545 bytes)   

fiury

2019-03-25 22:55

reporter   ~0002457

I had a blackout and I don't why but that solved the problem. Just to be sure I tested it again and rebooting the pc solves the problem.

fiury

2019-03-25 23:24

reporter   ~0002458

Now I have
pcp_proc_count -W -h localhost -p 9898 -U pgpool
Password:
13439 13440 13441 13445 13446 13447 13448 13449 13450 13451 13452 13453 13454 13455 13456 13457 13458 13459 13460 13461 13462 13463 13464 13465 13466 13467 13468 13469 13470 13471 13472 13473

But for
pcp_proc_count -w -h localhost -p 9898 -U pgpool
FATAL: authentication failed for user "pgpool"
DETAIL: username and/or password does not match

There is a problem with the password for sure, the .pcppass remains the same *:*pgpool:pgool

t-ishii

2019-03-26 08:16

developer   ~0002460

I guess your .pcppass is in wrong format. That should be "*:*:pgpool:pgpool", rather than "*:*pgpool:pgool".

fiury

2019-03-26 11:15

reporter   ~0002461

@t-ishii, mistyped here, the file has *:*:pgpool:pgpool. Another question, why the nodes are visible when pgpool is not running?

I tried also with Pgpool 3.5 but the same result (see picture)
Pgpool 3.5.png (28,960 bytes)   
Pgpool 3.5.png (28,960 bytes)   

t-ishii

2019-03-26 17:41

developer   ~0002463

Doesn't reproduce here. (I am using 4.0.3).

> why the nodes are visible when pgpool is not running?
PgpoolAdmin does not rely on Pgpool-II to show the window.

fiury

2019-03-27 00:24

reporter   ~0002464

Well, I found something, at the installation (/pgpool/install/checkParameter.php) the path of the ,pcppass says /usr/share/httpd. If I change the owner of /usr/share/httpd/.pcppass to root there is a new error message that says "Invalid ownership".

The curious thing is that I copied and pasted the same file to ~/.pcppass with owner apache and now the pcp_proc_count -w -h localhost -p 9898 -U pgpool is working.

I can't understand how it works.... Pgpool takes the file from ~/.pcpass and PgpoolAdmin from /usr/share/httpd/.pcppass?

Even if the command is working now, the message of the pgpoolAdmin stills e1004, I thought that fixing the "pcp_proc_count -w" command will solve everything but no.

pengbo

2019-03-31 22:13

developer   ~0002487

If you start apache using "apache" user, you have set owner of "/usr/share/httpd/.pcppass" to "apache" user,
and set the path of the ".pcppass" in /pgpool/install/checkParameter.php.

Issue History

Date Modified Username Field Change
2019-03-23 00:23 fiury New Issue
2019-03-23 00:23 fiury File Added: pgpool settings.png
2019-03-23 00:23 fiury File Added: pgpool version.png
2019-03-25 22:55 fiury Note Added: 0002457
2019-03-25 23:24 fiury Note Added: 0002458
2019-03-26 08:16 t-ishii Note Added: 0002460
2019-03-26 11:15 fiury File Added: Pgpool 3.5.png
2019-03-26 11:15 fiury Note Added: 0002461
2019-03-26 17:41 t-ishii Note Added: 0002463
2019-03-26 17:41 t-ishii Assigned To => t-ishii
2019-03-26 17:41 t-ishii Status new => assigned
2019-03-26 17:41 t-ishii Description Updated
2019-03-26 17:41 t-ishii Steps to Reproduce Updated
2019-03-26 17:41 t-ishii Status assigned => feedback
2019-03-27 00:24 fiury Note Added: 0002464
2019-03-27 00:24 fiury Status feedback => assigned
2019-03-31 22:13 pengbo Note Added: 0002487
2019-04-04 08:09 t-ishii Status assigned => feedback
2019-05-21 16:18 administrator Status feedback => closed