Unable to connect to pgpool, auth return type not support

[nbhatti]

Even though md5 is configured on pgpool, I am unable to connect. It looks like resty.postgres is not sending md5 auth type to pgpool.

Here is what I see on pgpool debug output

2015-02-17 11:11:59 DEBUG: pid 8423: I am 8423 accept fd 6 2015-02-17 11:11:59 DEBUG: pid 8423: Protocol Major: 3 Minor: 0 database: v user: postgres 2015-02-17 11:11:59 DEBUG: pid 8423: new_connection: connecting 0 backend 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length: slot: 0 length: 8 2015-02-17 11:11:59 DEBUG: pid 8423: pool_do_auth: auth kind:0 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 22 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: application_name value: 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 25 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: client_encoding value: UTF8 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 23 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: DateStyle value: ISO, MDY 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 25 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: integer_datetimes value: on 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 27 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: IntervalStyle value: postgres 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 20 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: is_superuser value: on 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 25 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: server_encoding value: UTF8 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 25 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: server_version value: 9.4.0 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 35 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: session_authorization value: postgres 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 35 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: standard_conforming_strings value: on 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length2: master slot: 0 length: 23 2015-02-17 11:11:59 DEBUG: pid 8423: 0 th backend: name: TimeZone value: localtime 2015-02-17 11:11:59 DEBUG: pid 8423: pool_flush_it: write failed to frontend. reason: Connection reset by peer offset: 0 wlen: 24 2015-02-17 11:11:59 DEBUG: pid 8423: pool_read_message_length: slot: 0 length: 12 2015-02-17 11:11:59 DEBUG: pid 8423: pool_do_auth: cp->info[i]:0x7f42503c0000 pid:9290 2015-02-17 11:11:59 DEBUG: pid 8423: pool_send_auth_ok: send pid 9290 to frontend 2015-02-17 11:11:59 DEBUG: pid 8423: pool_flush_it: write failed to frontend. reason: Broken pipe offset: 0 wlen: 13

[azurewang]

please check nginx error_log

[azurewang]

what about pgpool configure

[azurewang]

mabe you pgpool config is incorrect