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) _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
