[Pgpool-general] SSL support
Tatsuo Ishii
ishii at sraoss.co.jp
Wed Nov 9 14:14:27 GMT 2005
pgpool does not support SSL (yet). However if SSL request arrives,
pgpool returns error, which in turn applications fall back to non SSL
mode. You mean, pgpool does not work like this?
--
SRA OSS, Inc. Japan
Tatsuo Ishii
> Hi,
> I am using pgpool version 2.6.4 with postgres 8.0.3 running on two
> separate machines.
> I was wondering if pgpool supports SSL. My application uses libpq to
> connect to the database and I am getting server does not support SSL
> when I try to use pgpool. It works fine if I remove pgpool from the
> picture and connect to the server just using libpq.
>
> I would appreciate any help any one can provide.
>
>
> Here's what I see in pgpool log.
>
> cx101011:/export/home/kashyap> sudo /usr/local/bin/pgpool -n -d
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: listen_addresses
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: '*' kind: 4
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: port
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 9999 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: socket_dir
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: '/tmp' kind: 4
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: backend_host_name
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: '89.101.0.11' kind: 4
> 2005-11-08 11:22:27 DEBUG: pid 24638: :89.101.0.11:
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: backend_port
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 5432 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: backend_socket_dir
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: '/tmp' kind: 4
> 2005-11-08 11:22:27 DEBUG: pid 24638: key:
> secondary_backend_host_n ame
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: '89.1.0.46' kind: 4
> 2005-11-08 11:22:27 DEBUG: pid 24638: :89.1.0.46:
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: secondary_backend_port
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 5432 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: num_init_children
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 32 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: max_pool
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 4 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: child_life_time
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 300 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: connection_life_time
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 0 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: logdir
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: '/tmp' kind: 4
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: replication_mode
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: true kind: 1
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: replication_strict
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: true kind: 1
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: replication_timeout
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 5000 kind: 2
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: load_balance_mode
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: true kind: 1
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: weight_master
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 0.5 kind: 3
> 2005-11-08 11:22:27 DEBUG: pid 24638: weight_master: 0.500000
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: weight_secondary
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 0.5 kind: 3
> 2005-11-08 11:22:27 DEBUG: pid 24638: weight_secondary: 0.500000
> 2005-11-08 11:22:27 DEBUG: pid 24638: key:
> replication_stop_on_mism atch
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: false kind: 1
> 2005-11-08 11:22:27 DEBUG: pid 24638:
> replication_stop_on_mismatch: 0
> 2005-11-08 11:22:27 DEBUG: pid 24638: key: reset_query_list
> 2005-11-08 11:22:27 DEBUG: pid 24638: value: 'ABORT; RESET ALL;
> SET SESSION AUTHORIZATION DEFAULT'
> kind: 4
> 2005-11-08 11:22:28 DEBUG: pid 24638: extract_string_tokens:
> token: ABORT
> 2005-11-08 11:22:28 DEBUG: pid 24638: extract_string_tokens:
> token: RESET ALL
> 2005-11-08 11:22:28 DEBUG: pid 24638: extract_string_tokens:
> token: SET SESSION AUTHORIZATION
> DEFAULT
> 2005-11-08 11:22:28 DEBUG: pid 24638: key: print_timestamp
> 2005-11-08 11:22:28 DEBUG: pid 24638: value: true kind: 1
> 2005-11-08 11:22:28 DEBUG: pid 24638: key: master_slave_mode
> 2005-11-08 11:22:28 DEBUG: pid 24638: value: false kind: 1
> 2005-11-08 11:22:28 DEBUG: pid 24638: key: connection_cache
> 2005-11-08 11:22:28 DEBUG: pid 24638: value: true kind: 1
> 2005-11-08 11:22:28 DEBUG: pid 24638: key: health_check_timeout
> 2005-11-08 11:22:28 DEBUG: pid 24638: value: 20 kind: 2
> 2005-11-08 11:22:28 DEBUG: pid 24638: key: health_check_period
> 2005-11-08 11:22:28 DEBUG: pid 24638: value: 0 kind: 2
> 2005-11-08 11:22:28 DEBUG: pid 24638: key: health_check_user
> 2005-11-08 11:22:28 DEBUG: pid 24638: value: 'nobody' kind: 4
> 2005-11-08 11:22:28 DEBUG: pid 24638: key: insert_lock
> 2005-11-08 11:22:28 DEBUG: pid 24638: value: true kind: 1
> 2005-11-08 11:22:28 DEBUG: pid 24638: weight: 16383
> 2005-11-08 11:22:28 DEBUG: pid 24639: I am 24639
> 2005-11-08 11:22:28 DEBUG: pid 24640: I am 24640
> 2005-11-08 11:22:28 DEBUG: pid 24641: I am 24641
> 2005-11-08 11:22:28 DEBUG: pid 24642: I am 24642
> 2005-11-08 11:22:28 DEBUG: pid 24643: I am 24643
> 2005-11-08 11:22:28 LOG: pid 24638: pgpool successfully started
> 2005-11-08 11:22:28 DEBUG: pid 24644: I am 24644
> 2005-11-08 11:22:28 DEBUG: pid 24645: I am 24645
> 2005-11-08 11:22:28 DEBUG: pid 24646: I am 24646
> 2005-11-08 11:22:28 DEBUG: pid 24647: I am 24647
> 2005-11-08 11:22:28 DEBUG: pid 24661: I am 24661
> 2005-11-08 11:22:28 DEBUG: pid 24649: I am 24649
> 2005-11-08 11:22:28 DEBUG: pid 24668: I am 24668
> 2005-11-08 11:22:28 DEBUG: pid 24664: I am 24664
> 2005-11-08 11:22:28 DEBUG: pid 24655: I am 24655
> 2005-11-08 11:22:28 DEBUG: pid 24654: I am 24654
> 2005-11-08 11:22:28 DEBUG: pid 24648: I am 24648
> 2005-11-08 11:22:28 DEBUG: pid 24665: I am 24665
> 2005-11-08 11:22:28 DEBUG: pid 24669: I am 24669
> 2005-11-08 11:22:28 DEBUG: pid 24657: I am 24657
> 2005-11-08 11:22:28 DEBUG: pid 24656: I am 24656
> 2005-11-08 11:22:28 DEBUG: pid 24651: I am 24651
> 2005-11-08 11:22:28 DEBUG: pid 24667: I am 24667
> 2005-11-08 11:22:28 DEBUG: pid 24659: I am 24659
> 2005-11-08 11:22:28 DEBUG: pid 24652: I am 24652
> 2005-11-08 11:22:28 DEBUG: pid 24650: I am 24650
> 2005-11-08 11:22:28 DEBUG: pid 24666: I am 24666
> 2005-11-08 11:22:28 DEBUG: pid 24653: I am 24653
> 2005-11-08 11:22:28 DEBUG: pid 24662: I am 24662
> 2005-11-08 11:22:28 DEBUG: pid 24660: I am 24660
> 2005-11-08 11:22:28 DEBUG: pid 24663: I am 24663
> 2005-11-08 11:22:28 DEBUG: pid 24670: I am 24670
> 2005-11-08 11:22:28 DEBUG: pid 24658: I am 24658
> 2005-11-08 11:23:33 DEBUG: pid 24658: I am 24658 accept fd 7
> 2005-11-08 11:23:33 DEBUG: pid 24658: Protocol Major: 1234 Minor:
> 5 679 database: user:
> 2005-11-08 11:23:33 DEBUG: pid 24658: SSLRequest: sent N; retry
> sta rtup
> 2005-11-08 11:23:33 DEBUG: pid 24670: I am 24670 accept fd 7
> 2005-11-08 11:23:33 DEBUG: pid 24670: Protocol Major: 1234 Minor:
> 5 679 database: user:
> 2005-11-08 11:23:33 DEBUG: pid 24670: SSLRequest: sent N; retry
> sta rtup
> 2005-11-08 11:23:33 DEBUG: pid 24663: I am 24663 accept fd 7
> 2005-11-08 11:23:33 DEBUG: pid 24663: Protocol Major: 1234 Minor:
> 5 679 database: user:
> 2005-11-08 11:23:33 DEBUG: pid 24663: SSLRequest: sent N; retry
> sta rtup
> 2005-11-08 11:23:33 DEBUG: pid 24660: I am 24660 accept fd 7
> 2005-11-08 11:23:33 DEBUG: pid 24660: Protocol Major: 1234 Minor:
> 5 679 database: user:
> 2005-11-08 11:23:33 DEBUG: pid 24660: SSLRequest: sent N; retry
> sta rtup
> 2005-11-08 11:25:05 DEBUG: pid 24662: I am 24662 accept fd 7
> 2005-11-08 11:25:05 DEBUG: pid 24662: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:25:05 DEBUG: pid 24662: SSLRequest: sent N; retry startup
> 2005-11-08 11:25:06 DEBUG: pid 24653: I am 24653 accept fd 7
> 2005-11-08 11:25:06 DEBUG: pid 24653: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:25:06 DEBUG: pid 24653: SSLRequest: sent N; retry startup
> 2005-11-08 11:25:06 DEBUG: pid 24666: I am 24666 accept fd 7
> 2005-11-08 11:25:06 DEBUG: pid 24666: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:25:06 DEBUG: pid 24666: SSLRequest: sent N; retry startup
> 2005-11-08 11:25:12 DEBUG: pid 24650: I am 24650 accept fd 7
> 2005-11-08 11:25:12 DEBUG: pid 24650: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:25:12 DEBUG: pid 24650: SSLRequest: sent N; retry startup
> 2005-11-08 11:30:22 DEBUG: pid 24654: I am 24654 accept fd 7
> 2005-11-08 11:30:22 DEBUG: pid 24654: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:30:22 DEBUG: pid 24654: SSLRequest: sent N; retry startup
> 2005-11-08 11:31:20 DEBUG: pid 24646: I am 24646 accept fd 7
> 2005-11-08 11:31:20 DEBUG: pid 24646: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:31:20 DEBUG: pid 24646: SSLRequest: sent N; retry startup
> 2005-11-08 11:31:20 DEBUG: pid 24645: I am 24645 accept fd 7
> 2005-11-08 11:31:20 DEBUG: pid 24645: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:31:20 DEBUG: pid 24645: SSLRequest: sent N; retry startup
> 2005-11-08 11:31:21 DEBUG: pid 24652: I am 24652 accept fd 7
> 2005-11-08 11:31:21 DEBUG: pid 24652: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:31:21 DEBUG: pid 24652: SSLRequest: sent N; retry startup
> 2005-11-08 11:35:13 DEBUG: pid 24659: I am 24659 accept fd 7
> 2005-11-08 11:35:13 DEBUG: pid 24659: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:35:13 DEBUG: pid 24659: SSLRequest: sent N; retry startup
> 2005-11-08 11:35:13 DEBUG: pid 24667: I am 24667 accept fd 7
> 2005-11-08 11:35:13 DEBUG: pid 24667: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:35:13 DEBUG: pid 24667: SSLRequest: sent N; retry startup
> 2005-11-08 11:35:14 DEBUG: pid 24651: I am 24651 accept fd 7
> 2005-11-08 11:35:14 DEBUG: pid 24651: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:35:14 DEBUG: pid 24651: SSLRequest: sent N; retry startup
> 2005-11-08 11:35:22 DEBUG: pid 24656: I am 24656 accept fd 7
> 2005-11-08 11:35:22 DEBUG: pid 24656: Protocol Major: 1234 Minor: 5679
> databas e: user:
> 2005-11-08 11:35:22 DEBUG: pid 24656: SSLRequest: sent N; retry startup
> 2005-11-08 12:37:02 DEBUG: pid 24654: I am 24654 accept fd 7
> 2005-11-08 12:37:02 DEBUG: pid 24654: Protocol Major: 1234 Minor: 5679
> database: user:
> 2005-11-08 12:37:02 DEBUG: pid 24654: SSLRequest: sent N; retry startup
> 2005-11-08 12:37:02 DEBUG: pid 24646: I am 24646 accept fd 7
> 2005-11-08 12:37:02 DEBUG: pid 24646: Protocol Major: 1234 Minor: 5679
> database: user:
> 2005-11-08 12:37:02 DEBUG: pid 24646: SSLRequest: sent N; retry startup
> 2005-11-08 12:37:02 DEBUG: pid 24645: I am 24645 accept fd 7
> 2005-11-08 12:37:02 DEBUG: pid 24645: Protocol Major: 1234 Minor: 5679
> database: user:
> 2005-11-08 12:37:02 DEBUG: pid 24645: SSLRequest: sent N; retry startup
> 2005-11-08 12:37:02 DEBUG: pid 24658: I am 24658 accept fd 7
> 2005-11-08 12:37:02 DEBUG: pid 24658: Protocol Major: 1234 Minor: 5679
> database: user:
> 2005-11-08 12:37:02 DEBUG: pid 24658: SSLRequest: sent N; retry startup
> ^C2005-11-08 12:37:27 DEBUG: pid 24654: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24646: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24645: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24670: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24669: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24668: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24667: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24666: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24665: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24664: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24663: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24662: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24661: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24660: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24659: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24658: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24657: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24656: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24655: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24653: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24652: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24651: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24650: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24649: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24648: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24647: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24644: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24643: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24642: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24641: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24640: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 DEBUG: pid 24639: child receives shutdown request
> signal 2
> 2005-11-08 12:37:27 LOG: pid 24638: received fast shutdown request
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
> 2005-11-08 12:37:27 DEBUG: pid 24638: reap_handler called
>
>
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>
More information about the Pgpool-general
mailing list