[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