Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working

From: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
To: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Date: 2010-09-21 16:55:38
Message-ID: AANLkTikqP6+mLR2uyEUrLJkx-9JAVW-WHONmqMAciqxE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Sep 21, 2010 at 10:45 AM, Bryan Murphy <bmurphy1976(at)gmail(dot)com>wrote:

> I'm sorry, when I went back over to double check my steps I realized I ran
> the wrong command. I am *still* having the problem. It appears that the
> MD5 hashes now match, but it's still failing. I have postgres and pgpool
> installed in /opt/postgresql, but I have the same problem when I put
> pool_passwd in /etc and /opt/postgresql/etc.
>

Here is a gdb backtrace from the child process when it sigsegs after I enter
the correct password. I'm digging in a little deeper now and I thought this
might be useful.

(gdb) bt
#0 0xefcbf24f in ?? ()
#1 0x08052ac5 in do_md5 (backend=0xefcbf24f, frontend=0x9dfc5c0,
reauth=<value optimized out>, protoMajor=3)
at /usr/include/bits/string3.h:52
#2 0x08052e7b in pool_do_auth (frontend=0x9df97c0, cp=0x9df8fa8) at
pool_auth.c:222
#3 0x080509a9 in connect_backend (unix_fd=4, inet_fd=5) at child.c:1143
#4 do_child (unix_fd=4, inet_fd=5) at child.c:293
#5 0x0804bbdf in fork_a_child (unix_fd=4, inet_fd=5, id=<value optimized
out>) at main.c:1024
#6 0x0804ddef in main (argc=3, argv=0xbfab6754) at main.c:514

>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Nelson 2010-09-21 16:57:46 Re: Memory Errors
Previous Message Lincoln Yeoh 2010-09-21 16:23:00 How about synchronous notifications?