[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