<div dir="ltr"><div>OK.. Good Job !</div><div><br></div><div>I recommend check it out this tutorial as a plus for your current Knowledge:</div><div><a href="https://www.itenlight.com/blog/2016/05/18/PostgreSQL+HA+with+pgpool-II+-+Part+1">https://www.itenlight.com/blog/2016/05/18/PostgreSQL+HA+with+pgpool-II+-+Part+1</a></div><div><br></div><div>The guy explain very well the concepts. It is for ubuntu, but you can adapt it for RedHat, like I did it for Centos7.</div><div><br></div><div>Good Luck!</div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature"><div dir="ltr"><div dir="ltr"><br></div></div></div></div>
<br><div class="gmail_quote">2017-01-19 0:08 GMT-04:00 Dylan Luong <span dir="ltr"><<a href="mailto:Dylan.Luong@unisa.edu.au" target="_blank">Dylan.Luong@unisa.edu.au</a>></span>:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_5716129454357762477WordSection1">
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">Hi
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">After setting the health check parameters, it now reporting postgres is up.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<div>
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:calibri,sans-serif"> <a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.<wbr>net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-<wbr>bounces@pgpool.net</a>]
<b>On Behalf Of </b>Dylan Luong<br>
<b>Sent:</b> Thursday, 19 January 2017 9:10 AM<br>
<b>To:</b> Araujo Manuel Emilio <<a href="mailto:emilio.araujo@gmail.com" target="_blank">emilio.araujo@gmail.com</a>><br>
<b>Cc:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> [pgpool-general: 5270] Re: pgpoolAdmin install - check parameter failed<u></u><u></u></span></p>
</div>
</div><div><div class="gmail-h5">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">Hi
<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">Yes, the posix functions were missing as seen in the apache error log. Installing it resolved the issue. Thanks.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">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. <u></u><u></u></span></p>
<p class="MsoNormal"><img width="866" height="247" id="gmail-m_5716129454357762477Picture_x0020_1" src="cid:image001.png@01D27261.C455FED0"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">Running the command manually shows the status of 2.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">pcp_node_info -h localhost -U pcp_admin -n 1<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">10.68.20.17 5432 2 0.500000<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">Regards<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)">Dylan<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11pt;font-family:calibri,sans-serif;color:rgb(31,73,125)"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11pt;font-family:calibri,sans-serif">From:</span></b><span style="font-size:11pt;font-family:calibri,sans-serif"> Araujo Manuel Emilio [<a href="mailto:emilio.araujo@gmail.com" target="_blank">mailto:emilio.araujo@gmail.<wbr>com</a>]
<br>
<b>Sent:</b> Wednesday, 18 January 2017 5:58 PM<br>
<b>To:</b> Dylan Luong <<a href="mailto:Dylan.Luong@unisa.edu.au" target="_blank">Dylan.Luong@unisa.edu.au</a>><br>
<b>Cc:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> Re: [pgpool-general: 5267] pgpoolAdmin install - check parameter failed<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">Hi !<u></u><u></u></p>
<div>
<p class="MsoNormal">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:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">1- Install the functions: yum install php-process<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">2- Restart apache and try again<u></u><u></u></p>
</div>
</div>
<div>
<p class="MsoNormal"><br clear="all">
<u></u><u></u></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class="MsoNormal" style="margin-bottom:12pt">__________________________<u></u><u></u></p>
</div>
<p class="MsoNormal"><b><span style="font-size:13.5pt;color:rgb(7,55,99)">Manuel Emilio Araujo</span></b><u></u><u></u></p>
<div>
<p class="MsoNormal"><span style="color:rgb(102,102,102)">Desarrollador de Software</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(102,102,102)">640 65 08 29</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(102,102,102)"><a href="mailto:emilio.araujo@gmail.com" target="_blank">emilio.araujo@gmail.com</a></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(102,102,102)"><a href="mailto:emilio.araujo@outlook.com" target="_blank">emilio.araujo@outlook.com</a></span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(56,118,29)">Imprime este documento solo si es necesario... </span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(56,118,29)">Ayudemos el planeta.</span><u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><span style="color:rgb(56,118,29)">Salvemos un árbol !</span><u></u><u></u></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">2017-01-17 3:37 GMT-04:00 Dylan Luong <<a href="mailto:Dylan.Luong@unisa.edu.au" target="_blank">Dylan.Luong@unisa.edu.au</a>>:<u></u><u></u></p>
<blockquote style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid rgb(204,204,204);padding:0cm 0cm 0cm 6pt;margin:5pt 0cm 5pt 4.8pt">
<div>
<div>
<p class="MsoNormal">Hi
<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">I have installed/configured pgpool and apache on my server (linux Red Hat 6.8)<u></u><u></u></p>
<p class="MsoNormal">After installing pgpoolAdmin, (<a href="http://www.pgpool.net/docs/pgpoolAdmin/en/install.html" target="_blank">http://www.pgpool.net/docs/<wbr>pgpoolAdmin/en/install.html</a>) and confirming
php Multibyte Support and PostgreSQL Support is enabled , I can access the URL <a href="http://ServerName:8443/pgpoolAdmin/install/index.php" target="_blank">
http://ServerName:8443/<wbr>pgpoolAdmin/install/index.php</a> ok. (note: I changed apache port to 8443, for security reasons)<u></u><u></u></p>
<p class="MsoNormal"><img border="0" width="603" height="250" id="gmail-m_5716129454357762477m_4545733797299331892Picture_x0020_1" src="cid:image002.png@01D27261.C455FED0"><u></u><u></u></p>
<p class="MsoNormal"><img border="0" width="604" height="318" id="gmail-m_5716129454357762477m_4545733797299331892Picture_x0020_2" src="cid:image003.png@01D27261.C455FED0"><u></u><u></u></p>
<p class="MsoNormal">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.<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">This is the error on my web browser:<u></u><u></u></p>
<p class="MsoNormal" style="margin-bottom:12pt;background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(247,247,247)">
<span style="font-size:19pt;font-family:"segoe ui",sans-serif;color:rgb(51,51,51)">The <ServerName> page isn’t working</span><u></u><u></u></p>
<p class="MsoNormal" style="background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(247,247,247)">
<b><span style="font-size:11.5pt;font-family:"segoe ui",sans-serif;color:rgb(100,100,100)"><Servername></span></b><span style="font-size:11.5pt;font-family:"segoe ui",sans-serif;color:rgb(100,100,100)"> is currently unable to handle this request.</span><u></u><u></u></p>
<p class="MsoNormal" style="background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial;background-color:rgb(247,247,247)">
<span style="font-size:9.5pt;font-family:"segoe ui",sans-serif;color:dimgray;text-transform:uppercase">HTTP ERROR 500</span><u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal">Regards<u></u><u></u></p>
<p class="MsoNormal"><span style="color:rgb(136,136,136)">Dylan<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:rgb(136,136,136)"> <u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12pt"><br>
______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div></div></div>
</div>
</blockquote></div><br></div></div>