[pgpool-general: 21] About pgpool-HA with md5 authentication method

Lazaro Rubén García Martinez lgarciam at vnz.uci.cu
Fri Dec 2 11:35:53 JST 2011


Hello everyone in the list, I am creating a high availability cluster with Pgpool-II, Pgpool-HA and Heartbet. The monitor operation fails if the authentication with the database use md5, but if the authentication method is true, there isn't problem. This is the information logged in PostgreSQL and pgpool log file each one.
The question is:
Allows pgpool-ha the md5 authentication method??

Postgres's log

LOG:  connection received: host=pg_01.vnz.uci.cu port=60224
LOG:  could not receive data from client: Connection reset by peer
LOG:  connection received: host=pg_01.vnz.uci.cu port=60226
LOG:  could not receive data from client: Connection reset by peer
LOG:  connection received: host=pg_01.vnz.uci.cu port=60228
LOG:  could not receive data from client: Connection reset by peer
LOG:  connection received: host=pg_01.vnz.uci.cu port=60230
LOG:  could not receive data from client: Connection reset by peer
LOG:  connection received: host=pg_01.vnz.uci.cu port=60232
LOG:  could not receive data from client: Connection reset by peer
LOG:  connection received: host=pg_01.vnz.uci.cu port=60234
LOG:  could not receive data from client: Connection reset by peer

Pgpool's log

2011-12-01 17:16:47 LOG:   pid 4636: connection received: host=localhost port=42143
2011-12-01 17:16:47 DEBUG: pid 4636: Protocol Major: 1234 Minor: 5679 database:  user:
2011-12-01 17:16:47 DEBUG: pid 4636: SSLRequest from client
2011-12-01 17:16:47 DEBUG: pid 4636: read_startup_packet: application_name: psql
2011-12-01 17:16:47 DEBUG: pid 4636: Protocol Major: 3 Minor: 0 database: pgpool user: pgpool
2011-12-01 17:16:47 DEBUG: pid 4636: new_connection: connecting 0 backend
2011-12-01 17:16:47 DEBUG: pid 4636: new_connection: connecting 1 backend
2011-12-01 17:16:47 DEBUG: pid 4636: new_connection: skipping slot 1 because backend_status = 3
2011-12-01 17:16:47 DEBUG: pid 4636: pool_ssl: sending client->server SSL request
2011-12-01 17:16:47 DEBUG: pid 4636: pool_ssl: client->server SSL response: S
2011-12-01 17:16:47 DEBUG: pid 4636: pool_read_message_length: slot: 0 length: 12
2011-12-01 17:16:47 DEBUG: pid 4636: pool_do_auth: auth kind:5
2011-12-01 17:16:47 DEBUG: pid 4636: trying md5 authentication
2011-12-01 17:16:47 ERROR: pid 4636: pool_ssl: SSL_read: no SSL error reported
2011-12-01 17:16:47 ERROR: pid 4636: pool_read: read failed (Success)
2011-12-01 17:16:47 DEBUG: pid 4636: read_password_packet_password: failed to read password packet "p"
2011-12-01 17:16:47 DEBUG: pid 4636: do_md5: read_password_packet failed
2011-12-01 17:16:47 DEBUG: pid 4636: do_md5failed in slot 0

Thank you very much for your time.
Regards.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20111201/a1bd75a1/attachment.html>


More information about the pgpool-general mailing list