It's a known problem with md5 auth. It has been fixed in 3.0.1. Please use 3.0.1. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> Hi All, > > I install pgpool-II-3.0 and find that it doesn't work with my > postgresql 8.1.18. following is my environment. > > postgresql-devel-8.1.18-2.el5_4.1 > postgresql-libs-8.1.18-2.el5_4.1 > postgresql-libs-8.1.18-2.el5_4.1 > postgresql-server-8.1.18-2.el5_4.1 > postgresql-devel-8.1.18-2.el5_4.1 > postgresql-8.1.18-2.el5_4.1 > > the pgpool-II-3.0 is compiled with following parameters. > > ./configure --with-pgsql-libdir=/usr/lib64/ > --with-pgsql-includedir=/usr/include/pgsql/ --with-openssl --with-pam > > when i try to execute sql using psql, it prompt error message. > # psql -h localhost -p 9999 > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > also the log of pgpool shows: > > 2010-11-10 21:59:06 DEBUG: pid 11854: I am 11854 accept fd 6 > 2010-11-10 21:59:06 DEBUG: pid 11854: Protocol Major: 1234 Minor: 5679 > database: user: > 2010-11-10 21:59:06 DEBUG: pid 11854: SSLRequest from client > 2010-11-10 21:59:06 DEBUG: pid 11854: Protocol Major: 3 Minor: 0 > database: kusudb user: postgres > 2010-11-10 21:59:06 DEBUG: pid 11854: new_connection: connecting 0 backend > 2010-11-10 21:59:06 DEBUG: pid 11854: pool_read_message_length: slot: > 0 length: 12 > 2010-11-10 21:59:06 DEBUG: pid 11854: trying md5 authentication > 2010-11-10 21:59:06 DEBUG: pid 11854: DB node id: 0 salt: 1569147 > 2010-11-10 21:59:06 DEBUG: pid 11824: reap_handler called > 2010-11-10 21:59:06 DEBUG: pid 11824: reap_handler: call wait3 > 2010-11-10 21:59:06 ERROR: pid 11824: Child process 11854 was > terminated by segmentation fault > 2010-11-10 21:59:06 DEBUG: pid 11824: child 11854 exits with status 11 > by signal 11 > 2010-11-10 21:59:06 DEBUG: pid 11824: fork a new child pid 11865 > 2010-11-10 21:59:06 DEBUG: pid 11824: reap_handler: normally exited > 2010-11-10 21:59:06 DEBUG: pid 11865: I am 11865 > > BTW, i tried pgpool-II-3.0.1, it has same problems. but > pgpool-II-2.3.3 works well. > > -- > Chunyang Liu > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
