[pgpool-general: 176] Re: Error while loading shared libraries

[Marcelo Giesel]

Nope, installed PostgreSQL support for PHP and nothing changed. I have the
error:
Error code 1002
Error Message pcp_node_count command error occurred




2012/1/17 Marcelo Giesel <marcelo.giesel at lupa.inf.ufg.br>

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



-- 
--
Best regards,
Marcelo Giesel
Laboratory for Ubiquitous and Pervasive Applications (LUPA)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120117/39fd10a9/attachment-0001.html>