[pgpool-general: 4627] Re: md5 authentication with pgpool

[Tatsuo Ishii]

>>> *DETALLE:  message length (12) in slot 1 does not match with slot 0(8)*

Probably a configuration mismatch in PostgreSQL server #0 and
PostgreSQL server #1. From reading the message above, server #0 asks
trust authentication (no password), while server #1 requires certain
authentication (possibly md5). Showing full pgpool.conf and
pg_hba.conf from both PostgreSQL servers will reveal this.

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

> Lucas is the same error!!!!
> 
> 
> Apr 7 16:14:24 localhost pgpool[14839]: [40-1] 2016-04-07 16:14:24: pid
> 14839: # printf-style string to output at beginning of each log line.ERROR:
> unable to read message length
> Apr 7 16:14:24 localhost pgpool[14839]: [40-2] 2016-04-07 16:14:24: pid
> 14839: # printf-style string to output at beginning of each log
> line.DETAIL: message length (12) in slot 1 does not match with slot 0
> 
> 2016-04-07 15:52 GMT-03:00 Lucas Luengas <lucasluengas at gmail.com>:
> 
>> Hello
>> You can check pgpool log and postgresql log when you run that psql command.
>> Regards.
>> On Apr 6, 2016 8:30 PM, "Daniel Gallo" <danielito.gallo at gmail.com> wrote:
>>
>>> Dear I'm trying to run the following and I get the following error and I
>>> can not figure out what the problem is , I could help ?
>>>
>>>
>>> Any information that need be notified me and sent them
>>>
>>>
>>>
>>> Thanks a lots!!!!!
>>>
>>>
>>>
>>>
>>>
>>> -bash-4.2$ psql -h localhost -U postgres -p 5432
>>>
>>> psql (9.4.4)
>>>
>>> Digite «help» para obtener ayuda.
>>>
>>>
>>>
>>> postgres=#
>>>
>>>
>>>
>>>
>>>
>>> *-bash-4.2$ psql -h localhost -U postgres -p 9999*
>>>
>>> *psql: ERROR:  unable to read message length*
>>>
>>> *DETALLE:  message length (12) in slot 1 does not match with slot 0(8)*
>>>
>>>
>>>
>>> Any idea?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> *pg_hba.conf*
>>>
>>>
>>>
>>> # TYPE  DATABASE        USER            ADDRESS                 METHOD
>>>
>>>
>>>
>>> # "local" is for Unix domain socket connections only
>>>
>>> local   all             all                                     md5
>>>
>>> # IPv4 local connections:
>>>
>>> host    all             all             127.0.0.1/32            md5
>>>
>>> host    all             all             0.0.0.0/0               md5
>>>
>>> # IPv6 local connections:
>>>
>>> # Allow replication connections from localhost, by a user with the
>>>
>>> # replication privilege.
>>>
>>> local   replication     postgres                                trust
>>>
>>> host    replication     replication        0.0.0.0/0            trust
>>>
>>> #host    replication     postgres        ::1/128                 trust
>>>
>>>
>>>
>>> -rwxrw-r--. 1 apache apache 33283 abr  1 15:49 pgpool.conf
>>>
>>>
>>>
>>> *pgpool.conf*
>>>
>>>
>>>
>>> # - Authentication -
>>>
>>>
>>>
>>> enable_pool_hba = on
>>>
>>>                                    # Use pool_hba.conf for client
>>> authentication
>>>
>>> pool_passwd = 'pool_passwd'
>>>
>>>                                    # File name of pool_passwd for md5
>>> authentication.
>>>
>>>                                    # "" disables pool_passwd.
>>>
>>>                                    # (change requires restart)
>>>
>>> authentication_timeout = 60
>>>
>>>                                    # Delay in seconds to complete client
>>> authentication
>>>
>>>                                    # 0 means no timeout.
>>>
>>>
>>>
>>>
>>>
>>>
>>> -rw-r--r--. 1 apache root      42 feb 29 18:28 pool_passwd
>>>
>>>
>>>
>>> postgres:5c0435eee0f211f150e980e459151xxx
>>>
>>>
>>>
>>>
>>>
>>> -rwxrw-r--. 1 root   root    3295 mar  3 18:19 pool_hba.conf
>>>
>>>
>>>
>>> # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
>>>
>>>
>>>
>>> # "local" is for Unix domain socket connections only
>>>
>>> local   all         all                               md5
>>>
>>> # IPv4 local connections:
>>>
>>> host    all         all         127.0.0.1/32          md5
>>>
>>> host    all         all         0.0.0.0/0             md5
>>>
>>> #host    all         all         ::1/128               trust
>>>
>>> _______________________________________________
>>> pgpool-general mailing list
>>> pgpool-general at pgpool.net
>>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>>
>>>