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

[Marcelo Giesel]

Tatsuo, I have it working now. I just changed some permitions and installed
PostgreSQL support for PHP.

Thanks again and sorry to bother you with this silly problem.

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

> 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)
>



-- 
--
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/20120118/e8970c04/attachment.html>