[pgpool-general: 2098] ssl connection issue #2 ( ignore first mail )

[Nathan Brennan]

Sorry I hit the shortcut to send email by accident.

I am trying to connect from a webserver with pgpool on it to postgres over
ssl, but it is failing and I have no good error message to work with :(.

My setup is as follows:

I have a webserver ( 10.0.0.101 ) that has pgpool locally on it setup for
master/slave streaming replication. pgpool is built with openssl support
and I have create a key/cert for the settings.

My postgresl (10.0.1.20) pg_hba.conf file has the following:
hostssl all             all             10.0.0.0/24             md5

This is my pgpool log when I try to connect

2013-08-30 09:05:04 DEBUG: pid 17639: I am 17639 accept fd 6
2013-08-30 09:05:04 DEBUG: pid 17639: Protocol Major: 1234 Minor: 5679
database:  user:
2013-08-30 09:05:04 DEBUG: pid 17639: SSLRequest from client
2013-08-30 09:05:04 DEBUG: pid 17639: Protocol Major: 3 Minor: 0 database:
db1 user: user1
2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 0 backend
2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 1 backend
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL
request
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL
response: S
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL
request
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL
response: S
2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 0
length: 12
2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 1
length: 12
2013-08-30 09:05:04 DEBUG: pid 17639: pool_do_auth: auth kind:5
2013-08-30 09:05:04 DEBUG: pid 17639: I am 17639 accept fd 6
2013-08-30 09:05:04 DEBUG: pid 17639: Protocol Major: 3 Minor: 0 database:
db1 user: user1
2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 0 backend
2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 1 backend
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL
request
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL
response: S
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL
request
2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL
response: S
2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 0
length: 12
2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 1
length: 12
2013-08-30 09:05:04 DEBUG: pid 17639: pool_do_auth: auth kind:5

postgresql log when I try to connect:

2013-08-30 09:12:41 UTC [29970]: [1-1] LOG:  could not receive data from
client: Connection reset by peer
2013-08-30 09:12:41 UTC [29971]: [1-1] LOG:  could not receive data from
client: Connection reset by peer


any ideas ?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130830/f80e7b04/attachment.html>