[pgpool-general: 4335] Re: unable to read message kind
Tatsuo Ishii
ishii at postgresql.org
Mon Jan 18 15:17:43 JST 2016
> I'm unable to connect to pgpool from the app hosts. I have all of my entry in pool_hba.conf and pg_hba.conf but keeps give this error in pgpool.log
>
> 2016-01-15 14:11:25: pid 27553: LOG: pool_read_kind: error message from 1 th backend:no pg_hba.conf entry for host "10.11.0.202", user "hosted_dev", database "research_quests", SSL off
> 2016-01-15 14:11:25: pid 27553: ERROR: unable to read message kind
> 2016-01-15 14:11:25: pid 27553: DETAIL: kind does not match between master(52) slot[1] (45)
The master replies with "52" = 'R' in ASCII, while node 1 replies with
"45" = 'E', which means the master succeeded in auth, while node 1
returns Error. Below indicates that you have different pg_hba.conf
setting for hosted_dev/research_quests. This should be responsible for
the failure.
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> I have two pgpool, two postgres master/slave all servers running on Ubuntu 14.4
>
> Ubuntu 14.04.3 LTS
> pgpool-II version 3.4.3 (tataraboshi)
> psql (9.5.0)
>
> postgres at pgtest-db:~$ grep hosted_dev pg_hba.conf
> host research_quests hosted_dev 10.11.0.202/32 trust
>
> root at pgtest-con1:~# grep hosted_dev pool_hba.conf
> host research_quests hosted_dev 10.92.8.60/32 md5
> host research_quests hosted_dev 10.92.7.59/32 md5
>
> Thanks for your help
>
> Wolfgang Schwurack
> Database/System Administrator
> Utah Education Network
> 801-587-9444
> wolf at uen.org
>
>
More information about the pgpool-general
mailing list