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

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: bmurphy1976(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pgpool-II 3.0 + postgres 9rc1 + md5 authentication not working
Date: 2010-09-22 01:08:46
Message-ID: 20100922.100846.848855634033132251.t-ishii@sraoss.co.jp
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.

Unfortunately the gdb backtrace does not show enough information
because of optimization, I guess. Can you take a backtrace with
optimization disabled binary?

You can obtain this by editing Makefile around line 147.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> (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 Merlin Moncure 2010-09-22 01:10:38 Re: versioned pl/pgsql functions
Previous Message Aleksey Tsalolikhin 2010-09-22 00:47:01 Re: ERROR: cache lookup failed for type 14237017