[Pgpool-general] Problem PGPOOL-II (1.3) with password

SERY Daniel daniel.sery at smatis.fr
Wed Nov 14 16:25:20 UTC 2007


Hi,

I'm working for a french company and we are installing PGPOOL-II (release
1.3 with HA) and 2 backends (postgresql 8.2.4/Debian Etch).
The goal is to have load-balancing and replication between the backends (2
and soon 3).
PGPOOL-II is installed on 2 servers with heartbeat, pgpooladmin and the psql
client 8.2.4 (in fact, we have libpq4 and 5 because apache2 needs libpq4,
but we have libpq5-dev and pgpool was compiled with this version).
All is works great but an authentication problem.

In the backend's pg_hba.conf, we had put "trust" and all is works.
Now, we try to put password and we have this message : 

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

In debug, we have :
"2007-11-14 17:16:12 DEBUG: pid 23054: trying clear text password
authentication
2007-11-14 17:16:12 ERROR: pid 23054: do_clear_text_password: failed to read
password packet "p"
2007-11-14 17:16:12 ERROR: pid 23054: do_clear_text_password failed in slot
0
2007-11-14 17:16:15 DEBUG: pid 23054: I am 23054 accept fd 5
2007-11-14 17:16:15 DEBUG: pid 23054: Protocol Major: 1234 Minor: 5679
database:  user:
2007-11-14 17:16:15 DEBUG: pid 23054: SSLRequest: sent N; retry startup
2007-11-14 17:16:15 DEBUG: pid 23054: Protocol Major: 3 Minor: 0 database:
test_db user: daniel
2007-11-14 17:16:15 DEBUG: pid 23054: new_connection: connecting 0 backend
2007-11-14 17:16:15 DEBUG: pid 23054: new_connection: connecting 1 backend
2007-11-14 17:16:15 DEBUG: pid 23054: new_connection: skipping slot 1
because backend_status = 3
2007-11-14 17:16:15 DEBUG: pid 23054: new_connection: connecting 2 backend
2007-11-14 17:16:15 DEBUG: pid 23054: new_connection: skipping slot 2
because backend_status = 3
2007-11-14 17:16:15 DEBUG: pid 23054: pool_read_message_length: slot: 0
length: 8
2007-11-14 17:16:15 DEBUG: pid 23054: trying clear text password
authentication
2007-11-14 17:16:15 DEBUG: pid 23054: trying clear text password
authentication
2007-11-14 17:16:15 DEBUG: pid 13632: reap_handler called
2007-11-14 17:16:15 DEBUG: pid 13632: reap_handler: call wait3
2007-11-14 17:16:15 DEBUG: pid 13632: child 23054 exits with status 11 by
signal 11"

We see the message "failed to read password packet "p" and after this, I
type the password and I have the first message.

Do you have an idea of this problem ?

Thanks for advance,

Regards
Daniel.

(PS : excuse me, my english is not very good)


More information about the Pgpool-general mailing list