Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to connect to pgpool, auth return type not support #5

Open
nbhatti opened this issue Feb 17, 2015 · 3 comments
Open

Unable to connect to pgpool, auth return type not support #5

nbhatti opened this issue Feb 17, 2015 · 3 comments

Comments

@nbhatti
Copy link

nbhatti commented Feb 17, 2015

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
Copy link
Owner

please check nginx error_log

@azurewang
Copy link
Owner

what about pgpool configure

@azurewang
Copy link
Owner

mabe you pgpool config is incorrect

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants