[pgpool-general: 5270] Re: pgpoolAdmin install - check parameter failed

[Dylan Luong]

Hi
Yes, the posix functions were missing as seen in the apache error log. Installing it resolved the issue. Thanks.
pgpoolAdmin appears to be working now, however its reporting that the postgres databases are down although the node is up and connected??? But the databases are definitely up.
[cid:image003.png at 01D27233.3C101070]

Running the command manually shows the status of 2.
pcp_node_info -h localhost -U pcp_admin -n 1
10.68.20.17 5432 2 0.500000

Regards
Dylan

From: Araujo Manuel Emilio [mailto:emilio.araujo at gmail.com]
Sent: Wednesday, 18 January 2017 5:58 PM
To: Dylan Luong <Dylan.Luong at unisa.edu.au>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 5267] pgpoolAdmin install - check parameter failed

Hi !
I think that you dont have the php posix functions installed (posix_getpwuid() and posix_geteuid()), used in the checkParameter.php file. To solve it:

1- Install the functions: yum install php-process
2- Restart apache and try again

__________________________
Manuel Emilio Araujo
Desarrollador de Software
640 65 08 29
emilio.araujo at gmail.com<mailto:emilio.araujo at gmail.com>
emilio.araujo at outlook.com<mailto:emilio.araujo at outlook.com>

Imprime este documento solo si es necesario...
Ayudemos el planeta.
Salvemos un árbol !

2017-01-17 3:37 GMT-04:00 Dylan Luong <Dylan.Luong at unisa.edu.au<mailto:Dylan.Luong at unisa.edu.au>>:
Hi

I have installed/configured pgpool and apache on my server (linux Red Hat 6.8)
After installing pgpoolAdmin, (http://www.pgpool.net/docs/pgpoolAdmin/en/install.html) and confirming php Multibyte Support and PostgreSQL Support is enabled , I can access the URL http://ServerName:8443/pgpoolAdmin/install/index.php ok.  (note: I changed apache port to 8443, for security reasons)
[cid:image004.png at 01D27233.3C101070]
[cid:image005.png at 01D27233.3C101070]
However, in the next screen, checking, (parameter check), I am getting an HTTP ERROR 500. I have followed the steps to modified all the file securities as in the installation.

This is the error on my web browser:
The <ServerName> page isn’t working
<Servername> is currently unable to handle this request.
HTTP ERROR 500

Regards
Dylan


_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net<mailto:pgpool-general at pgpool.net>
http://www.pgpool.net/mailman/listinfo/pgpool-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170118/4748844f/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 21637 bytes
Desc: image003.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170118/4748844f/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image004.png
Type: image/png
Size: 12447 bytes
Desc: image004.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170118/4748844f/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image005.png
Type: image/png
Size: 16031 bytes
Desc: image005.png
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170118/4748844f/attachment-0005.png>