[pgpool-general: 1219] Re: Can't enable SSL connection

Wed Dec 5 05:36:27 JST 2012

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Le 04/12/2012 20:33, Lazaro Ruben Garcia Martinez a écrit :
> This version (1.3-2) is very old and not maintained by the pgpool
> developers.

Yes, I knew it. But sometimes you have to cope with such antediluvian versions.

BTW, I installed pgpool2 3.1.3-3 on my laptop.

When connecting directly to PG, SSL is enabled.

But, connecting through pgpool, it isn't, and I can see these messages in log :

Dec  4 21:32:32 longway pgpool: 2012-12-04 21:32:32 LOG:   pid 32360:
connection received: host=127.0.0.1 port=52842
Dec  4 21:32:32 longway pgpool: 2012-12-04 21:32:32 DEBUG: pid 32360:
Protocol Major: 1234 Minor: 5679 database:  user:
Dec  4 21:32:32 longway pgpool: 2012-12-04 21:32:32 DEBUG: pid 32360:
SSLRequest from client
Dec  4 21:32:32 longway pgpool: 2012-12-04 21:32:32 DEBUG: pid 32360:
pool_ssl: SSL requested but SSL support is not available
Dec  4 21:32:32 longway pgpool: 2012-12-04 21:32:32 DEBUG: pid 32360:
read_startup_packet: application_name: psql
Dec  4 21:32:32 longway pgpool: 2012-12-04 21:32:32 DEBUG: pid 32360:
Protocol Major: 3 Minor: 0 database: mabase user: useur
Dec  4 21:32:32 longway pgpool: 2012-12-04 21:32:32 DEBUG: pid 32360:
new_connection: connecting 0 backend
Dec  4 21:32:33 longway pgpool: 2012-12-04 21:32:33 DEBUG: pid 32360:
pool_ssl: SSL requested but SSL support is not available
Dec  4 21:32:33 longway pgpool: 2012-12-04 21:32:33 DEBUG: pid 32360:
pool_read_message_length: slot: 0 length: 12
Dec  4 21:32:33 longway pgpool: 2012-12-04 21:32:33 DEBUG: pid 32360:
pool_do_auth: auth kind:5
Dec  4 21:32:33 longway pgpool: 2012-12-04 21:32:33 DEBUG: pid 32360: trying
md5 authentication
Dec  4 21:32:33 longway pgpool: 2012-12-04 21:32:33 DEBUG: pid 32360: DB node
id: 0 salt: 6e26898c

Regards,
- -- 
Stéphane Schildknecht
http://www.Loxodata.com
Contact régional PostgreSQL
http://bistri.me/s
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iEYEARECAAYFAlC+XssACgkQA+REPKWGI0F6eACg1piDZqqeI1qGQKwMRjbIGCtW
RBoAni1sEgFjmxhRptRuDqUSmQmY8dGC
=DyUu
-----END PGP SIGNATURE-----