View Issue Details

IDProjectCategoryView StatusLast Update
0000347Pgpool-IIBugpublic2017-10-10 10:52
Reportersobrinho Assigned Tot-ishii  
PriorityimmediateSeverityblockReproducibilityalways
Status closedResolutionopen 
Platformamd64OSUbuntu and OS XOS VersionTrusty & Sierra
Product Version3.6.6 
Summary0000347: backend response with kind 'E' when expecting 'R'
DescriptionHi,

I'm trying to connect to a pgpool configured as that: https://www.pastiebin.com/59d3f08178fdf

The command I'm using is: pgpool -n -f pgpool.conf

When I try to connect using a valid or a invalid password, I see that:

root@desenvolvimento-app:~# psql -p 9999 -h localhost -U [REDACTED] -W [REDACTED]
Password for user [REDACTED]:
psql:
FATAL: no pg_hba.conf entry for host "[REDACTED]", user "[REDACTED]", database "[REDACTED]", SSL off

The output of pgpool is: https://www.pastiebin.com/59d3f14714286

Note that the response is about pg_hba.conf but using the same credentials to connect directly to either databases using psql the connection succeeds, doesn't seem to be a pg_hba.conf issue.

I can reproduce the same problem using a Ubuntu Trusty machine (installed via apt-get) and a OS X Sierra (compiled).

Any ideas?
TagsNo tags attached.

Activities

t-ishii

2017-10-05 15:35

developer   ~0001740

You need to set pool_hba.conf. See the manual.

t-ishii

2017-10-10 10:20

developer   ~0001749

If you need further information, please use our mailing list. If you still believe there's some bug regarding this, you can continue this item of course.

sobrinho

2017-10-10 10:49

reporter   ~0001751

Thanks, I misread the documentation.

t-ishii

2017-10-10 10:51

developer   ~0001752

Thanks for the quick reply. Issue closed.

Issue History

Date Modified Username Field Change
2017-10-04 05:24 sobrinho New Issue
2017-10-05 15:35 t-ishii Note Added: 0001740
2017-10-05 16:12 t-ishii Assigned To => t-ishii
2017-10-05 16:12 t-ishii Status new => assigned
2017-10-05 16:13 t-ishii Status assigned => feedback
2017-10-10 10:20 t-ishii Note Added: 0001749
2017-10-10 10:49 sobrinho Note Added: 0001751
2017-10-10 10:49 sobrinho Status feedback => assigned
2017-10-10 10:51 t-ishii Note Added: 0001752
2017-10-10 10:52 t-ishii Status assigned => closed