[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