[pgpool-general: 4917] Re: invalid authentication

Tatsuo Ishii ishii at sraoss.co.jp
Wed Aug 17 17:21:25 JST 2016


What's yor pgpool.conf pg_hba.conf?

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Update to this. I tail pgpool.log until I see the ERROR massage then I breakout of the tail. I get this on the command line
> 
> root at pgtest-con1:~# root at pgtest-rep's password:
> root at pgtest-rep's password:
> root at pgtest-rep's password:
> 
> For each “failed to authenticate” in pgpool.log I getting a request for the password to the replication host. Why?
> 
> From: "pgpool-general-bounces at pgpool.net" <pgpool-general-bounces at pgpool.net> on behalf of Wolfgang Schwurack <wolf at uen.org>
> Date: Tuesday, August 16, 2016 at 7:46 AM
> To: "'pgpool-general at pgpool.net'" <pgpool-general at pgpool.net>
> Subject: [pgpool-general: 4914] invalid authentication
> 
> I’m getting this error after applying updates to Ubuntu 14.04.5 and upgrade to pgpool-II version 3.4.7. I also applied version 5.3.2 to see if that would fix the problem but it doesn’t matter which version of pgpool I use I get the same error.
> 
> 2016-08-16 07:38:43: pid 29444: LOG:  health checking retry count 1
> 2016-08-16 07:38:43: pid 29444: ERROR:  failed to authenticate
> 2016-08-16 07:38:43: pid 29444: DETAIL:  invalid authentication message response type, Expecting 'R' and received 'E'
> 
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> 801-587-9444
> wolf at uen.org<mailto:wolf at uen.org>
> 


More information about the pgpool-general mailing list