[Pgcluster-general] pglb problems

[A. Mitani]

Hi Serge,

According to your log of pglb, start-up packet requests SSL connection.
The load balancer is not supported SSL connection.
Therefore, please re-configure without "--with-openssl" option.
("make distclean" is required before re-configure)

Regards,
----------------
At.Mitani
 

----- Original Message -----
From: "Serge A. Ribalchenko" <fisher at netstyle.com.ua>
To: pgcluster-general at pgfoundry.org
Sent: 2008年3月22日 22時26分10秒 (GMT+0900) Asia/Tokyo
Subject: [Pgcluster-general] pglb problems

Hi there,

first of all I think I must say sorry for my language skill.
Recently I had built pgcluster-1.9.0rc2 from sources and it works just
fine; some days ago however I gave a try for 1.9.0rc5 and found that
pglb isn't working at all. I made a diff between these versions for
src/pgcluster/pglb and saw a big redesign, it just scared me, and so I
decided to ask here for help.

So, I've setup two nodes with similar configurations (see attach for
explicit config files).
I've found that clusters is up and running, replication between them
seems to work fine, but when I connect to pglb port it says

[fisher at rabbit lib]# psql -h 192.168.8.89 -p 5432 -U postgres postgres
psql: server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.

In log file (pglb.log) I see these lines:

Sat Mar 22 15:09:27 2008
PGRset_status_on_cluster_tbl():host:192.168.8.89 port:5433 max:32 use:0
status1
Sat Mar 22 15:09:27 2008
PGRset_status_on_cluster_tbl():host:192.168.8.90 port:5433 max:32 use:0
status1
Sat Mar 22 15:09:27 2008  init_pglb():Child_Tbl size is[49536]
Sat Mar 22 15:09:39 2008  PGRscan_cluster:2 ClusterDB can be used
Sat Mar 22 15:09:39 2008  PGRscan_cluster:192.168.8.89 [5433],useFlag->1
max->32 use_num->0

Sat Mar 22 15:09:39 2008
PGRset_status_on_cluster_tbl():host:192.168.8.89 port:5433 max:32 use:1
status2
Sat Mar 22 15:09:39 2008  I am 24111
Sat Mar 22 15:09:39 2008  I am 24111 accept fd 6
Sat Mar 22 15:09:39 2008  Protocol Major: 1234 Minor: 5679 database:
user: 
Sat Mar 22 15:09:39 2008  PGRdo_child(): SSLRequest: sent N; retry
startup

...and that's all. Connection is closed.

I feel like I forgot something or doing something wrong, but I am stuck
here and need some advice. Please help me =)


-- 
Best wishes,
~       Serge.           pubkeys: http://uch.net/~fisher/keys.asc
~fingerprint : 4346 2766 BC96 E77F 5BFF  1E7C 12C2 3852 E5FD DC34