Dear PGPool-II Users,
I am using the binaries from
http://yum.pgrpms.org/reporpms/9.0/pgdg-redhat-9.0-2.noarch.rpm
for PostgreSQL and PgPool-II
I am attempting to get MD5 authentication working but I am seeing a
segfault when correct authentication is performed.
I have seen this error posted on the Internet and I'm wondering if it is
a major problem, or is there a workaround.
My scenario.
pg_hba.conf:
local all postgres md5
host testBD testDBdba,postgres 0.0.0.0/0 md5
pool_hba.conf:
local all all md5
host all all 127.0.0.1/32 md5
I then copied the values from 'pg_shadow' to the pool_passwd file, with
the corresponding user names.
pgpool.conf:
enable_pool_hba = true
If I log into the backend DB directly, then it works fine.
If I go through pgpool, I get a segfault on the client pgpool process
and this error in the log.
2010-11-24 12:50:23 DEBUG: pid 21586: backend 0 weight: 2147483647.000000
2010-11-24 12:50:23 LOG: pid 21586: pgpool-II successfully started.
version 3.0.1 (umiyameboshi)
2010-11-24 12:50:35 ERROR: pid 21619: do_md5: read_password_packet failed
2010-11-24 12:50:54 ERROR: pid 21586: Child process 21619 was
terminated by segmentation fault
If I use the wrong password, I get a typical access denied message.
If I switch all the *_hba entries from 'md5' to 'trust' then it all
works, but that is unacceptable for us.
Is there a fix for this?
Many thanks
Rob
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
