[Pgpool-general] Error with SSL Consection

[Tatsuo Ishii]

Can you try like this?

1) configure num_init_children to 1.
2) restart pgpool
3) find pgpool child process pid(hint: ps status is "pgpool: wait for connection request")
4) strace -p the_pid
5) connect to pgpool

strace should show where pgpool tried to find ssl cert file. Make sure that
it is /opt/pgpool/ssl/server.cert.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hello everyone in the list, I am proving the connecting SSL through with Pgpool, the pgpool configuration parameters related with SSL are:
> 
> # - SSL Connections -
> 
> ssl = on
> ssl_key = '/opt/pgpool/ssl/server.key'
> ssl_cert = '/opt/pgpool/ssl/server.cert'
> #ssl_ca_cert = ''
> #ssl_ca_cert_dir = ''
> 
> But in pgpool.log file i see this error:
> 
> 2011-11-22 06:42:02 LOG:   pid 14011: connection received: host=10.13.4.201 port=40434
> 2011-11-22 06:42:02 DEBUG: pid 14011: Protocol Major: 1234 Minor: 5679 database:  user:
> 2011-11-22 06:42:02 DEBUG: pid 14011: SSLRequest from client
> 2011-11-22 06:42:02 ERROR: pid 14011: pool_ssl: Loading SSL certificate: No such file or directory
> 
> Nevertheless I can connect to postgreSQL through Pgpool.
> 
> Please can anybody tell me, What could be the reason for this error?
> 
> I am using Pgpool-II V_3.1_stable with PostgreSQL 9.0.5.
> 
> Regards.