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

[Marcelo Giesel]

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)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120117/0d0c8225/attachment.html>