[pgpool-general: 6384] Re: FATAL: 08P01: expected password response, got message type 88

[Moritz Stürz]

Hi,

do you have any news on this?

Regards,
Moritz

Am 18.12.18, 09:56 schrieb "Tatsuo Ishii" <ishii at sraoss.co.jp>:

    allow_clear_text_frontend_auth is new in 4.0, i.e. it's not in 3.6.
    So I guess there's something wrong with
    allow_clear_text_frontend_auth.  I wanted to track down the problem
    but unfortunately was not able to reproduce your problem using 4.0.2.
    
    Usama,
    
    Do you have any idea on this?
    
    Best regards,
    --
    Tatsuo Ishii
    SRA OSS, Inc. Japan
    English: http://www.sraoss.co.jp/index_en.php
    Japanese:http://www.sraoss.co.jp
    
    > Hi Tatsuo,
    > 
    > for tests we downgraded to 3.6.6. built from source and that works. Seems to be some issue in 4.0.2.. 
    > 
    > Am 11.12.18, 13:05 schrieb "Tatsuo Ishii" <ishii at sraoss.co.jp>:
    > 
    >     Thanks.
    >     
    >     What's Pgpool-II's IP and what's PostgreSQL's IP?
    >     
    >     Best regards,
    >     --
    >     Tatsuo Ishii
    >     SRA OSS, Inc. Japan
    >     English: http://www.sraoss.co.jp/index_en.php
    >     Japanese:http://www.sraoss.co.jp
    >     
    >     > Hi Tatsuo,
    >     > 
    >     > sure! Here you go, the files are attached. pool_passwd is empty.
    >     > Thanks for your help!
    >     > 
    >     > Regards,
    >     > Moritz
    >     > 
    >     > Am 10.12.18, 23:42 schrieb "Tatsuo Ishii" <ishii at sraoss.co.jp>:
    >     > 
    >     >     > Hi,
    >     >     > we are trying to run pgpool 4.0.2 on Ubuntu 18.04..
    >     >     > When trying to login to Postgres 9.5 or 11  via pgpool, Postgres logs the error “FATAL:  08P01: expected password response, got message type 88”
    >     >     > Direct login to the DB with the same user works fine.
    >     >     > Did anymore come across this error or has any hints on what to try?
    >     >     > Thanks a lot in advance!
    >     >     > Regards,
    >     >     > Moritz
    >     >     
    >     >     Hard to say anything without more information.
    >     >     
    >     >     Can you share pgpool.conf, pool_hba.conf, pool_password (of course
    >     >     with the password part masked), pg_hba.conf?
    >     >     
    >     >     Best regards,
    >     >     --
    >     >     Tatsuo Ishii
    >     >     SRA OSS, Inc. Japan
    >     >     English: http://www.sraoss.co.jp/index_en.php
    >     >     Japanese:http://www.sraoss.co.jp
    >     >     
    >     > 
    >     
    >