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-26 02:11:00
Message-ID: 02AD22EBEBC00940BBB63FEB6AB89BE3207CEB@CNSHGSMBS04.ad4.ad.alcatel.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Tom Lane,

Sorry, I still can not understand, what does the max/min version number
in startup message, why it is different between different psql version?

Thanks,
Justin

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us] 
Sent: Monday, May 26, 2008 6:54 AM
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:
> 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?

Sounds like you need to fix your "support of the postgres wire
protocol" --- in particular you'd better read up on query cancel,
and it would appear you are unable to send a proper error response
either.

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Thomas H.Date: 2008-05-26 04:54:30
Subject: Re: BUG #4186: set lc_messages does not work
Previous:From: Tom LaneDate: 2008-05-25 22:53:56
Subject: Re: error message "psql: expected authentication request from server, but received " when using psql to connect remote database

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