[pgpool-general: 1365] Re: md5 auth only works when I start pgpool with "-n"
web at mr-paradox.net
Sun Feb 3 13:33:58 JST 2013
On Feb 2, 2013, at 12:57 AM, Tatsuo Ishii <ishii at postgresql.org> wrote:
>> 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.
> And this may related to your problem.
> Can you please try with this patch or the latest 3.2-stable snapshot?
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
Should I not be starting pgpool as root? would that make any difference?
More information about the pgpool-general