Micka | 21 Feb 18:36 2011
Picon

pcp authentification doesn't work

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.


Thanks,

_______________________________________________
Pgpool-general mailing list
Pgpool-general@...
http://pgfoundry.org/mailman/listinfo/pgpool-general
Guillaume Lelarge | 21 Feb 23:17 2011

Re: pcp authentification doesn't work

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
_______________________________________________
Pgpool-general mailing list
Pgpool-general <at> pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
Micka | 22 Feb 04:20 2011
Picon

Re: pcp authentification doesn't work

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 Error Message
e1002
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-Dk/QjmpjrnCZuzBka8ofvg@public.gmane.org> 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

_______________________________________________
Pgpool-general mailing list
Pgpool-general@...
http://pgfoundry.org/mailman/listinfo/pgpool-general
Micka | 22 Feb 09:52 2011
Picon

Re: pcp authentification doesn't work

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-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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 Error Message
e1002
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

_______________________________________________
Pgpool-general mailing list
Pgpool-general@...
http://pgfoundry.org/mailman/listinfo/pgpool-general
Guillaume Lelarge | 22 Feb 10:45 2011

Re: pcp authentification doesn't work

Le 22/02/2011 09:52, Micka a écrit :
> 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....
> 

Depends if you told pgpool where to find it. How did you launch pgPool?

Oh, and stop top-posting, it makes it hard to answer to you.

--

-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com
_______________________________________________
Pgpool-general mailing list
Pgpool-general <at> pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
Micka | 22 Feb 10:58 2011
Picon

Re: pcp authentification doesn't work

Thanks,

" Depends if you told pgpool where to find it. How did you launch pgPool? "

pgPool is not launching yet.

Because i'm following this tutorial :

http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html

I should have this screen :

http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/operation_images/01.png


but i've got in the pgpool status :

Error Code Error Message
e1002
pcp_node_count command error occurred.


Instead of "stop pgpool" as referenced in the picture.



Thanks,



On Tue, Feb 22, 2011 at 10:45 AM, Guillaume Lelarge <guillaume-Dk/QjmpjrnCZuzBka8ofvg@public.gmane.org> wrote:
Le 22/02/2011 09:52, Micka a écrit :
> 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....
>

Depends if you told pgpool where to find it. How did you launch pgPool?

Oh, and stop top-posting, it makes it hard to answer to you.


--



_______________________________________________
Pgpool-general mailing list
Pgpool-general@...
http://pgfoundry.org/mailman/listinfo/pgpool-general
Guillaume Lelarge | 22 Feb 21:54 2011

Re: pcp authentification doesn't work

Le 22/02/2011 10:58, Micka a écrit :
> Thanks,
> 
> " Depends if you told pgpool where to find it. How did you launch pgPool? "
> 
> pgPool is not launching yet.
> 
> Because i'm following this tutorial :
> 
> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/index.html
> 
> I should have this screen :
> 
> http://pgpool.projects.postgresql.org/contrib_docs/simple_sr_setting/operation_images/01.png
> 
> 
> but i've got in the pgpool status :
> 
> Error Code e1002  Error Message pcp_node_count command error occurred.
> 
> Instead of "stop pgpool" as referenced in the picture.
> 

And what do you have in this screen instead of /usr/local/etc/pcp.conf?

--

-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com
_______________________________________________
Pgpool-general mailing list
Pgpool-general <at> pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
Tatsuo Ishii | 23 Feb 00:29 2011
Picon

Re: pcp authentification 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 (_(,

There is a process which is managing pcp commands:

23566 ?        S      0:02 pgpool: PCP: wait for connection request

The process is the work horse of PCP commands (pcp_* is just a client
interface for the process).

You would want to use strace to see what it is doing while processing
pcp_node_count request. You can do something like:

strace -p 23566
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
Micka | 23 Feb 10:00 2011
Picon

Re: pcp authentification doesn't work

Hey,

It seems that after restarting the server, it works well now ....

Thx,

On Wed, Feb 23, 2011 at 12:29 AM, Tatsuo Ishii <ishii-r5vX20e9KLfqq2nvvmkE/A@public.gmane.org> wrote:
> 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 (_(,

There is a process which is managing pcp commands:

23566 ?        S      0:02 pgpool: PCP: wait for connection request

The process is the work horse of PCP commands (pcp_* is just a client
interface for the process).

You would want to use strace to see what it is doing while processing
pcp_node_count request. You can do something like:

strace -p 23566
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp



--
Michael Musset,
Tel: 06 26 06 29 89

_______________________________________________
Pgpool-general mailing list
Pgpool-general@...
http://pgfoundry.org/mailman/listinfo/pgpool-general

Gmane