[pgpool-general: 4527] Re: pgpoolAdmin 3.5 errors

Nozomi Anzai anzai at sraoss.co.jp
Mon Mar 7 15:01:34 JST 2016


Hi,

Is there ".pcppass" in apache's home directory?
It seems /root/.pcppass exists, but ~apache/.pcppass doesn't.

Pgpool-II 3.5 needs .pcppass to execute pcp commands, and pcp commands in
pgpoolAdmin are executed by Apache process user.


> I have installed the latest version of pgpool and pgpoolAdmin 3.5.
> 
> But cannot get pgpoolAdmin to run. After I login getting error on Backend info - Process info, Watchdog and Node info
> Process info - Error Code e1004 Error Message pgp_proc_count command error occurred.
> Watchdog - Error Code e1013 Error Message pcp_watchdog_info command error occurred
> Node info - Error Code e1002 Error Message pcp_node_count command error occurred.
> 
> I checked the apache error.log getting this
> Process info:
> FATAL:  authentication failed for user "apache"
> DETAIL:  username and/or password does not match
> 
> Watchdog
> [Fri Mar 04 13:06:32.948246 2016] [:error] [pid 7906] [client 140.197.231.20:48223] PHP Notice:  Undefined offset: 2 in /var/www/html/admin-tool/command.php on line 156, referer: http://pgtest-con1/html/admin-tool/status.php
> 
> Node info:
> FATAL:  authentication failed for user "apache"
> DETAIL:  username and/or password does not match
> 
> But when I run the command from the command line it works
> root ¡÷ pgtest-con1:~# pcp_proc_count -U apache
> Password:
> 7663 7664 7665 7666 7667 7668 7669 7670 7671 7672 7673 7674 7675 7676 7677 7678 7679 7680 7681 7684 7685 7686 7687 7688 7689 7690 7691 7692 7693 7694 7695 7696 7697 7698 7699 7700 7701 7702 7703 7704 7705 7706 7707 7708 7709 7710 7711 7712 7713 7714 7715 7716 7717 7718 7719 7720 7721 7722 7723 7724 7725 7726 7727 7728 7729 7730 7731 7732 7733 7734 7735 7736 7737 7738 7739 7740 7741 7742 7743 7744 7745 7746 7747 7748 7749 7750 7751 7752 7753 7754 7755 7756 7757 7758 7759 7760 7761 7762 7763 7764 7765 7766 7767 7768 7769 7770 7771 7772 7773 7774 7775 7776 7777 7778 7779 7780 7781 7782 7783 7784 7785 7786 7787 7788 7789 7790 7791 7792
> 
> root ¡÷ pgtest-con1:~# pcp_watchdog_info -U apache
> Password:
> 2 YES Linux_pgtest-con1_9999 pgtest-con1
> 
> Linux_pgtest-con1_9999 pgtest-con1 9999 9000 4 MASTER
> Linux_pgtest-con2_9999 pgtest-con2 9999 9000 7 STANDBY
> 
> root ¡÷ pgtest-con1:~$ pcp_node_count -U apache
> Password:
> 2
> 
> I have user:password in pcp.conf file
> # USERID:MD5PASSWD
> apache:c1d10d0db9c99fa6d3361639269141fd
> 
> Where else would pgpoolAdmin be looking for a password?
> 
> 
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> 801-587-9444
> wolf ¡÷ uen.org
> 
> 
> 


-- 
Nozomi Anzai


More information about the pgpool-general mailing list