[Pgpool-general] [pgPool]

[Micka]

Ok,

mickael at PTI2:~$ sudo nano /usr/local/etc/pcp.conf

# USERID:MD5PASSWD

# postgres: test
postgres:098f6bcd4621d373cade4e832627b4f6

postgres1:6b9883ad2fdc7256b95cfafbbe8e455b
micka:098f6bcd4621d373cade4e832627b4f6

----
With pgpool Admin, in the Login screen, when I enter:
Login: postgres
password: test

and click on login, it works.

With :

mickael at PTI2:~$ pcp_recovery_node -d 10 localhost 9898 postgres test 1
DEBUG: send: tos="R", len=46
DEBUG: recv: tos="r", len=21, data=AuthenticationOK
DEBUG: send: tos="D", len=6
DEBUG: recv: tos="e", len=20, data=recovery failed
DEBUG: command failed. reason=recovery failed
BackendError
DEBUG: send: tos="X", len=4

What does it mean ?




On Wed, Feb 23, 2011 at 11:13 PM, Guillaume Lelarge
<guillaume at lelarge.info>wrote:

> Le 23/02/2011 22:58, Micka a écrit :
> > I tried to test the pcp command myself :
> >
> > mickael at PTI2:/usr/local/bin$ psql -U postgres
> > psql (9.0.3)
> > Type "help" for help.
> >
> > postgres=# ALTER USER postgres WITH PASSWORD 'toto';
> > ALTER ROLE
> > postgres=# \q
> > mickael at PTI2:/usr/local/bin$ pcp_recovery_node -d 10 localhost 9898
> postgres
> > toto 1
> > DEBUG: send: tos="R", len=46
> > DEBUG: recv: tos="r", len=63, data=AuthenticationFailed
> > DEBUG: authentication failed. reason=AuthenticationFailed
> > AuthorizationError
> >
> > But nothing more, I don't understand why I got the AuthorizationError.
> >
>
> PCP authorization has nothing to do with PostgreSQL users and passwords.
> You set user and password in pcp.conf (user in clear text, password in
> md5). You need to use pg_md5 to hash the password.
>
>
> --
> 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://pgfoundry.org/pipermail/pgpool-general/attachments/20110223/df4f881e/attachment.html>