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. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
