Re: error message "psql: expected authentication request from server, but received " when using psql to connect remote database

From: "TIAN Justin" <yongjuntian(at)alcatel-lucent(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: error message "psql: expected authentication request from server, but received " when using psql to connect remote database
Date: 2008-05-23 02:22:38
Message-ID: 02AD22EBEBC00940BBB63FEB6AB89BE3207AA9@CNSHGSMBS04.ad4.ad.alcatel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Tom Lane,

Thanks for your response,
Actually, we don't directly use postgre server,we open TCP connection to
support postgre wire protocol, so psql client can connect to our
application,
I found the problem is in the StartupMessage, when psql client version
is 8.1.4, the major and minor version in StartupMessage is 1234 and
5679, not 3 and 0, that is the problem, I want to know whether it is the
bug of 8.1.4, or I can do some configuration?

Thanks again for your answer

Thanks,
Justin

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, May 22, 2008 9:43 PM
To: TIAN Justin
Cc: Heikki Linnakangas; pgsql-bugs(at)postgresql(dot)org
Subject: Re: [BUGS] error message "psql: expected authentication request
from server, but received " when using psql to connect remote database

"TIAN Justin" <yongjuntian(at)alcatel-lucent(dot)com> writes:
> Thanks for your quick response; the server we used is 8.1.4,
> The error when using client 8.1.4,
>> psql -U or -p 2222 -d testdb -h localhost
> Output:
> psql: expected authentication request from server, but received

What is in the server's pg_hba.conf file? I'm particularly wondering
what auth method is being selected ...

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas H. 2008-05-23 02:31:27 Re: BUG #4186: set lc_messages does not work
Previous Message Euler Taveira de Oliveira 2008-05-22 22:37:45 Re: BUG #4186: set lc_messages does not work