Hi, Do you want to implemant SSL suport? if so, it's need the ssl modules, I think.
Regards, -- original message -- From: Chahyeon Rhee<[EMAIL PROTECTED]> To: <[email protected]> Sent: Wed, 4 Jun 2008 11:30:03 -0600 Subject: [Pgcluster-general] load balance >Hi! there, > >I am still working on load balance. > >I found some. If some can give more with this, please give me. > >I just looked in the source level. > >In my pglb.log: > >Wed Jun 4 11:23:45 2008 >PGRset_status_on_cluster_tbl():host:server1.***.***.*** p\ >ort:5432 max:5 use:0 status1 >Wed Jun 4 11:23:45 2008 >PGRset_status_on_cluster_tbl():host:server2.***.***.*** p\ >ort:5432 max:5 use:0 status1 >Wed Jun 4 11:23:45 2008 init_pglb():Child_Tbl size is[7740] >Wed Jun 4 11:23:45 2008 before load_balance >Wed Jun 4 11:24:16 2008 PGRscan_cluster:2 ClusterDB can be used >Wed Jun 4 11:24:16 2008 PGRscan_cluster:server1.***.***.*** >[5432],useFlag->1 max\ >->5 use_num->0 > >Wed Jun 4 11:24:16 2008 >PGRset_status_on_cluster_tbl():host:server1.***.***.*** p\ >ort:5432 max:5 use:1 status2 >Wed Jun 4 11:24:16 2008 before PGRdo_child >Wed Jun 4 11:24:16 2008 I am 17198 >Wed Jun 4 11:24:16 2008 I am 17198 accept fd 6 >Wed Jun 4 11:24:16 2008 Protocol Major: 1234 Minor: 5679 database: user: >Wed Jun 4 11:24:16 2008 PGRdo_child(): SSLRequest: sent N; retry startup >Wed Jun 4 11:24:16 2008 before return status_error_2 >Wed Jun 4 11:24:16 2008 after PGRdo_child > > >This is related with the souce: > >child.c >int >PGRdo_child(int use_pool) >{ > > >/* SSL? */ > if (sp->major == 1234 && sp->minor == 5679) > { > /* SSL not supported */ > show_debug("%s: SSLRequest: sent N; retry startup",func); > if (ssl_request) > { > pool_close(frontend); > pool_free_startup_packet(sp); > PGRset_status_to_child_tbl(pid,TBL_FREE); > if (use_pool == USE_CONNECTION_POOL ) > { > show_debug("before continue"); > > continue; > } > else > { > show_debug("before return status_error_1"); > > return STATUS_ERROR; > } > } > >} > >So, I tried what happened if continue like >child.c >int >PGRdo_child(int use_pool) >{ > > >/* SSL? */ > if (sp->major == 1234 && sp->minor == 5679) > { > /* SSL not supported */ > show_debug("%s: SSLRequest: sent N; retry startup",func); > if (ssl_request) > { > pool_close(frontend); > pool_free_startup_packet(sp); > PGRset_status_to_child_tbl(pid,TBL_FREE); > //if (use_pool == USE_CONNECTION_POOL ) > //{ > // show_debug("before continue"); > > continue; > //} > //else > //{ > // show_debug("before return status_error_1"); > > // return STATUS_ERROR; > //} > } > >} > > >then load balance is connected and load balance can send request to server1 >or server2. But load balance looks not working correctly. > > >I am thinking at this point. > >If anybody can give some intuition, please give me. > >Thanks in advance. > >_______________________________________________ >Pgcluster-general mailing list >[email protected] >http://pgfoundry.org/mailman/listinfo/pgcluster-general > _______________________________________________ Pgcluster-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgcluster-general
