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

[Araujo Manuel Emilio]

OK.. Good Job !

I recommend check it out this tutorial as a plus for your current Knowledge:
https://www.itenlight.com/blog/2016/05/18/PostgreSQL+HA+with+pgpool-II+-+Part+1

The guy explain very well the concepts. It is for ubuntu, but you can adapt
it for RedHat, like I did it for Centos7.

Good Luck!



2017-01-19 0:08 GMT-04:00 Dylan Luong <Dylan.Luong at unisa.edu.au>:

> Hi
>
> After setting the health check parameters, it now reporting postgres is up.
>
>
>
> *From:* pgpool-general-bounces at pgpool.net [mailto:pgpool-general-
> bounces at pgpool.net] *On Behalf Of *Dylan Luong
> *Sent:* Thursday, 19 January 2017 9:10 AM
> *To:* Araujo Manuel Emilio <emilio.araujo at gmail.com>
> *Cc:* pgpool-general at pgpool.net
> *Subject:* [pgpool-general: 5270] Re: pgpoolAdmin install - check
> parameter failed
>
>
>
> 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.
>
>
>
> 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
> <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
>
> 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>:
>
> 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)
>
> 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
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170119/5376ecc3/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 21637 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170119/5376ecc3/attachment-0003.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 12447 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170119/5376ecc3/attachment-0004.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 16031 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170119/5376ecc3/attachment-0005.png>