<div dir="ltr">Sorry I hit the shortcut to send email by accident.<div><br></div><div>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 :(.</div>
<div><br></div><div>My setup is as follows:<br>
<div><br></div><div><span style="font-family:arial,sans-serif;font-size:13px">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.</span><div style="font-family:arial,sans-serif;font-size:13px">
<br></div><div style="font-family:arial,sans-serif;font-size:13px"><div>My postgresl (10.0.1.20) pg_hba.conf file has the following:<br></div><div>hostssl all all <a href="http://10.0.0.0/24" target="_blank">10.0.0.0/24</a> md5</div>
<div><br></div><div>This is my pgpool log when I try to connect</div><div><br></div><div><div>2013-08-30 09:05:04 DEBUG: pid 17639: I am 17639 accept fd 6</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: Protocol Major: 1234 Minor: 5679 database: user:</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: SSLRequest from client</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: Protocol Major: 3 Minor: 0 database: db1 user: user1</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 0 backend</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 1 backend</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL request</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL response: S</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL request</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL response: S</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 0 length: 12</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 1 length: 12</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_do_auth: auth kind:5</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: I am 17639 accept fd 6</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: Protocol Major: 3 Minor: 0 database: db1 user: user1</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 0 backend</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: new_connection: connecting 1 backend</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL request</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL response: S</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: sending client->server SSL request</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_ssl: client->server SSL response: S</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 0 length: 12</div><div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_read_message_length: slot: 1 length: 12</div>
<div>2013-08-30 09:05:04 DEBUG: pid 17639: pool_do_auth: auth kind:5</div></div><div><br></div><div>postgresql log when I try to connect:</div><div><br></div><div><div>2013-08-30 09:12:41 UTC [29970]: [1-1] LOG: could not receive data from client: Connection reset by peer</div>
<div>2013-08-30 09:12:41 UTC [29971]: [1-1] LOG: could not receive data from client: Connection reset by peer</div></div><div><br></div><div><br></div><div>any ideas ?</div></div></div></div></div>