[pgpool-general: 1364] Re: md5 auth only works when I start pgpool with "-n"
Tatsuo Ishii
ishii at postgresql.org
Sat Feb 2 17:57:53 JST 2013
> Howdy,
>
> I believe I ran into this a few months ago and didn't get a resolution. Now I'm back at it and I hope
> that there's an answer.
>
> Basically, if i start pgpool (streaming replication / pooling mode) with:
> pgpool -nf pgpool.conf
>
> I can log in just fine via md5 authentication.
>
> However, If i start it with
> pgpool -f pgpool.conf
>
> I get: psql: ERROR: "MD5" authentication with pgpool failed for user "postgres"
>
> Since it works fine when i don't background it, I have to assume that my
> configuration is correct.
>
> I can strace the various processes. (attached)
> master is: pgpool -f pgpool.conf
> worker is: pgpool: worker process
> waiter is: pgpool: wait for connection request
>
> I'm on pgpool 3.2.1, CentOS.
>
> Hopefully this one's already been covered quite a bit (although no luck with
> google and reading back mailing list messages).
Did not reproduce with master here. However we have fixed
pool_password problem in last October.
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=8e18fee1663fba81d1e56a77bc6702c6930692a8
And this may related to your problem.
Can you please try with this patch or the latest 3.2-stable snapshot?
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=snapshot;h=45c08c8349f72f72d05775ad58889b46ce8b4cf7;sf=tgz
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
More information about the pgpool-general
mailing list