Ok, mickael@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@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 <[email protected]>wrote: > Le 23/02/2011 22:58, Micka a écrit : > > I tried to test the pcp command myself : > > > > mickael@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@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
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
