[Pgpool-general] Segfault when using MD5 auth
Rob Shepherd
rs at datacymru.net
Wed Nov 24 13:16:47 UTC 2010
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
More information about the Pgpool-general
mailing list