Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group