[pgpool-general: 4007] Connection bug

James Sewell james.sewell at lisasoft.com
Thu Aug 27 16:23:46 JST 2015


Hey all,

I think I may have found a bug, I have the following setup:


   - pgpool-II version 3.3.6 (tokakiboshi)
   - Centos 6.4
   - Master / slave mode, streaming


pg_hba.confpool_hba.confpool_passwdresultmd5md5yesmd5 auth

I see the following behavior:

-bash-4.1$ psql -h 192.168.3.193 -U replication postgres
psql.bin (9.4.1.4)
Type "help" for help.

postgres=>


Which is fine, but if I get the database name wrong I see:

-bash-4.1$ psql -h 192.168.3.193 -U replication postgress
psql.bin: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.


And in the PGPool logs I see this:

2015-08-27 17:19:22 LOG:   pid 21711: pool_do_auth: maybe protocol version
mismatch (current version 3)

I was expecting this (direct connection to PostgreSQL):


-bash-4.1$ psql -h 192.168.3.190 -U replication postgress
psql.bin: FATAL:  no pg_hba.conf entry for host "192.168.3.190", user
"replication", database "postgress", SSL on
FATAL:  no pg_hba.conf entry for host "192.168.3.190", user "replication",
database "postgress", SSL off

When I look at the logs for PostgreSQL (for the PGPool connection) it seems
like it's doing the right thing:

2015-08-27 17:21:47 EST [25254]: [1-1]
user=replication,db=postgress,client=192.168.3.193 192.168.3.193(51321)
(0:28000)FATAL:  no pg_hba.conf entry for host "192.168.3.193", user
"replication", database "postgress", SSL off



Cheers,

James Sewell,
PostgreSQL Team Lead / Solutions Architect
______________________________________


Level 2, 50 Queen St, Melbourne VIC 3000

*P *(+61) 3 8370 8000  *W* www.lisasoft.com  *F *(+61) 3 8370 8099

-- 


------------------------------
The contents of this email are confidential and may be subject to legal or 
professional privilege and copyright. No representation is made that this 
email is free of viruses or other defects. If you have received this 
communication in error, you may not copy or distribute any part of it or 
otherwise disclose its contents to anyone. Please advise the sender of your 
incorrect receipt of this correspondence.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150827/ffb25e48/attachment.html>


More information about the pgpool-general mailing list