[Dbbalancer-users] WG: Please help ! Connection troubles

[Alexander G. <xe...@fr...>]

Hi Daniel,

first of all, thank you very much for this wonderful peace of software =
!!!
Now about our problem - we have tried to integrate DBBalancer, =
everything is fine, the balancer and replicator can be started, connects =
themselves to the databases located on 2 different servers, simply =
great, BUT we can not connect neither to balancer nor to replicator at =
all :(...

We have the following system:

Debian 3 (2.4.22 kernel)
PostgreSQL 7.4
DBBalancer 0.4.4 - fetched per apt-get, because of compiling troubles
connect through PHP4 and psql

Now to our dbbalancer.conf -=20
------
daemon.user =3D balancer
daemon.host =3D <IP> (we have tried localhost too, with the same =
"success")
daemon.auth-method =3D trust (password was tried too)

2 machines with successful connects
-------

Now our debug log if we trying to connect to user "balancer" on the =
reader port (in our case 5442):

(32771, 16:39:44.736893) (01::01) Handling connection.
(32771, 16:39:44.736960) Processing new conection. Receiving login data. =
(socket: 28)
(32771, 16:39:44.737045) Starting client connection process.
(32771) Error reading startup packet: Success
(32771, 16:39:44.737228) Login process failed.
(32771, 16:39:44.737296) DBPostgresPooledConnection: Login process =
failed.

psql says:=20
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

in the postgresql.conf we can find the following:
LOG: unexpected EOF on client connection

:( So what could it be ? The replicator/balancer itself can connect to =
all databases perfectly, but no connects to balancer in any case :( ...

Thank you very much in advance !!! This topic is really important for =
us, I would be very grateful if you could answer to this email as soon =
as possible. Thank you !!


Kind regards,
Alexander Goldybin