Tatsuo, I have it working now. I just changed some permitions and installed PostgreSQL support for PHP.<br><br>Thanks again and sorry to bother you with this silly problem.<br><br><div class="gmail_quote">2012/1/17 Marcelo Giesel <span dir="ltr"><<a href="mailto:marcelo.giesel@lupa.inf.ufg.br">marcelo.giesel@lupa.inf.ufg.br</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Nope, installed PostgreSQL support for PHP and nothing changed. I have the error:<br>Error code 1002<br>Error Message pcp_node_count command error occurred<div class="HOEnZb">
<div class="h5"><br><table><tbody>
<tr>
<th><br></th>
<td><br></td></tr></tbody></table><br><br><div class="gmail_quote">2012/1/17 Marcelo Giesel <span dir="ltr"><<a href="mailto:marcelo.giesel@lupa.inf.ufg.br" target="_blank">marcelo.giesel@lupa.inf.ufg.br</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Well, I read in the log some problems with authorization and then I changed the ownership of two folders to the apache user (wwwrun):<br>chown wwwrun /var/run/pgpool/<br>chown wwwrun /usr/local/etc/pool_passwd <br><br>Now I can run the pcp commands in the shell, like:<br>
$ pcp_node_count 0 maq88 9898 pgpool pgpool<br>2<br>$ pcp_stop_pgpool 0 maq88 9898 pgpool pgpool f<br><br> but I'm still unable to use the pgpoolAdmin. I found a thread about no nodes being shown in the pgpoolAdmin (<a href="http://pgfoundry.org/pipermail/pgpool-general/2010-November/003075.html" target="_blank">http://pgfoundry.org/pipermail/pgpool-general/2010-November/003075.html</a>) and I will see if this can help me.<div>
<div><br>
<br><br><div class="gmail_quote">2012/1/17 Marcelo Giesel <span dir="ltr"><<a href="mailto:marcelo.giesel@lupa.inf.ufg.br" target="_blank">marcelo.giesel@lupa.inf.ufg.br</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Thanks for the reply!<br><br>I used the configure, make, make install as found in the tutorial <a href="http://www.pgpool.net/pgpool-web/pgpool-II/doc/tutorial-en.html#install" target="_blank">http://www.pgpool.net/pgpool-web/pgpool-II/doc/tutorial-en.html#install</a><br>
The output of the lld is:<br># ldd usr/local/bin/pcp_stop_pgpool<br> linux-gate.so.1 => (0xffffe000)<br> libpcp.so.0 => /usr/local/lib/libpcp.so.0 (0xb76f2000)<br> libcrypt.so.1 => /lib/libcrypt.so.1 (0xb76bd000)<br>
libresolv.so.2 => /lib/libresolv.so.2 (0xb76a6000)<br> libnsl.so.1 => /lib/libnsl.so.1 (0xb768c000)<br> libm.so.6 => /lib/libm.so.6 (0xb7661000)<br> libc.so.6 => /lib/libc.so.6 (0xb74f4000)<br>
/lib/ld-linux.so.2 (0xb771c000)<br><br>And to install pgpoolAdmin I tryed the <a href="http://www.pgpool.net/pgpoolAdmin/doc/en/install.html" target="_blank">http://www.pgpool.net/pgpoolAdmin/doc/en/install.html</a> page. The only difference in this config is that my Apache process user is wwwrun instead of apache.<span><font color="#888888"><br>
<br>--<br>Best regards,<br>Marcelo Giesel<br>Laboratory for Ubiquitous and Pervasive Applications (LUPA)</font></span><div><div><br><br><div class="gmail_quote">2012/1/16 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>> I'm planning to use pgpool with pgpoolAdmin to get load balancing over my<br>
> postgres cluster, but I'm unable to get it working.<br>
> I can start pgpool manually but pgpoolAdmin always give me some error code<br>
> (for instance e1006 - pcp_stop_pgpool command error occurred), and when I<br>
> try to execute the pcp_stop_pgpool (or anyone else) in the shell it gives<br>
> me the message "pcp_stop_pgpool: error while loading shared libraries:<br>
> libpcp.so.0: cannot open shared object file: No such file or directory".<br>
> Looking in the lib folder I can find the "libpcp.so.0" file.<br>
><br>
> I have tryed to change the place of the libraries but nothing changed. How<br>
> can I fix this?<br>
<br>
</div></div>How did you build pgpool including pcp_stop_command? What is the<br>
output of ldd PATH/TO/pcp_stop_pgpool?<br>
<span><font color="#888888">--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</font></span></blockquote></div><br>
</div></div></blockquote></div><br><br clear="all"><br></div></div>-- <br><div><div>
--<br>
Best regards,<br>
Marcelo Giesel<br>
Laboratory for Ubiquitous and Pervasive Applications (LUPA)<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>
--<br>
Best regards,<br>
Marcelo Giesel<br>
Laboratory for Ubiquitous and Pervasive Applications (LUPA)<br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>
--<br>
Best regards,<br>
Marcelo Giesel<br>
Laboratory for Ubiquitous and Pervasive Applications (LUPA)<br>