[Pgpool-general] [pgPool]

[Guillaume Lelarge]

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