[Pgpool-general] pcp authentification doesn't work

Micka mickamusset at gmail.com
Tue Feb 22 08:52:12 UTC 2011


by the way :

-rwxr-xr-x 1 www-data root  722 2010-11-12 06:45 failover.sh
-rw-r--r-- 1 www-data root  982 2011-02-21 18:31 pcp.conf
-rw-r--r-- 1 root     root  858 2011-02-22 09:08 pcp.conf.sample
-rw-r--r-- 1 www-data root 9532 2011-02-22 04:59 pgpool.conf
-rw-r--r-- 1 root     root 9741 2011-02-22 09:08 pgpool.conf.sample
-rw-r--r-- 1 root     root 9767 2011-02-22 09:08
pgpool.conf.sample-master-slave
-rw-r--r-- 1 root     root 9764 2011-02-22 09:08
pgpool.conf.sample-replication
-rw-r--r-- 1 root     root 9795 2011-02-22 09:08 pgpool.conf.sample-stream
-rw-r--r-- 1 root     root 9542 2011-02-21 23:23 pgpool.conf.save
-rw-r--r-- 1 root     root 3337 2011-02-22 09:08 pool_hba.conf.sample


normally the pcp programme can access to the file pcp.conf , right ? It
shouldn't be the problem....







On Tue, Feb 22, 2011 at 4:20 AM, Micka <mickamusset at gmail.com> wrote:

> hi,
>
> Thx but it doesn't work :
>
> mickael at PTI2:~$ pcp_node_count 10 localhost 9898 postgres1 pgpoolAdmin
> AuthorizationError
>
> is it possible that i'm configuring the wrong file ? but with pgpoolAdmin I
> can connect to the administration page. So why the pcp command it doesn't
> work ?
>
> + when I'm on the main page of pgpoolAdmin, I got :
>
> Error Code e1002  Error Message pcp_node_count command error occurred.
>
> Which means the same thing above, the pcp command doesn't work.....
>
> I don't understand (_(,
>
>
> Thanks,
>
>
> On Mon, Feb 21, 2011 at 11:17 PM, Guillaume Lelarge <
> guillaume at lelarge.info> wrote:
>
>> Le 21/02/2011 18:36, Micka a écrit :
>> > Hi,
>> >
>> > I'm trying to understand on how to use the pcp command, but it doesn't
>> work
>> > .... see :
>> >
>> > mickael at PTI2:/var/log/pgpool$ pcp_node_count 10 localhost 9898 postgres
>> > pgpoolAdmin
>> > AuthorizationError
>> >
>> > And
>> >  sudo nano /usr/local/etc/pcp.conf
>> >
>> >
>> > # USERID:MD5PASSWD
>> > postgres:e8a48653851e28c69d0506508fb27fc5
>> > postgres1:6b9883ad2fdc7256b95cfafbbe8e455b
>> > micka:a97e914ee3a3a8592a0fecd2d77e0c04
>> >
>> > I don't know why i've got AuthorizationError.
>> >
>>
>> pgpoolAdmin is the password of "postgres1" user, not postgres. You
>> should launch:
>>
>> pcp_node_count 10 localhost 9898 postgres1 pgpoolAdmin
>>
>>
>> --
>> Guillaume
>>  http://www.postgresql.fr
>>  http://dalibo.com
>>
>
>


-- 
Michael Musset,
Tel: 06 26 06 29 89
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.pgfoundry.org/pipermail/pgpool-general/attachments/20110222/7c78a913/attachment.html>


More information about the Pgpool-general mailing list