[Pgpool-general] SSL support
Kashyap Jani
kjani at cognitronics.com
Tue Nov 8 19:23:19 GMT 2005
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
More information about the Pgpool-general
mailing list