Обсуждение: error message "psql: expected authentication request from server, but received " when using psql to connect remote database
Hi, =20 I met an error, when psql client version is 8.1.4, I use it to connect to remote database or local database, such as "psql -U name -p <port> -d <database> -h <ip>", it will prompt error message "psql: expected authentication request from server, but received ", but if the client version is 8.0.3, there is no problem, I don't know why, does it the configuration problem? =20 Thanks Justin
TIAN Justin wrote: > I met an error, when psql client version is 8.1.4, I use it to connect > to remote database or local database, such as "psql -U name -p <port> -d > <database> -h <ip>", it will prompt error message "psql: expected > authentication request from server, but received ", but if the client > version is 8.0.3, there is no problem, I don't know why, does it the > configuration problem? Please post the exact output you're getting in both cases. What version is the server? You should upgrade to the latest minor version, which is 8.1.11 for the 8.1 series, and 8.0.15 for the 8.0 series -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Heikki Linnakangas, Thanks for your quick response; the server we used is 8.1.4, The error when using client 8.1.4,=20 > psql -U or -p 2222 -d testdb -h localhost Output: psql: expected authentication request from server, but received when used 8.0.3, no problem, > psql -U or -p 2222 -d testdb -h localhost Output: Password: Then enter password, it can log in and do all operation. Thanks, Justin -----Original Message----- From: Heikki Linnakangas [mailto:heikki@enterprisedb.com]=20 Sent: Wednesday, May 21, 2008 8:14 PM To: TIAN Justin Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database TIAN Justin wrote: > I met an error, when psql client version is 8.1.4, I use it to connect > to remote database or local database, such as "psql -U name -p <port> -d > <database> -h <ip>", it will prompt error message "psql: expected > authentication request from server, but received ", but if the client > version is 8.0.3, there is no problem, I don't know why, does it the > configuration problem? Please post the exact output you're getting in both cases. What version is the server? You should upgrade to the latest minor version, which is 8.1.11 for the=20 8.1 series, and 8.0.15 for the 8.0 series --=20 Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
"TIAN Justin" <yongjuntian@alcatel-lucent.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
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@sss.pgh.pa.us]=20
Sent: Thursday, May 22, 2008 9:43 PM
To: TIAN Justin
Cc: Heikki Linnakangas; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] error message "psql: expected authentication request
from server, but received " when using psql to connect remote database=20
"TIAN Justin" <yongjuntian@alcatel-lucent.com> writes:
> Thanks for your quick response; the server we used is 8.1.4,
> The error when using client 8.1.4,=20
>> 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
"TIAN Justin" <yongjuntian@alcatel-lucent.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
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@sss.pgh.pa.us]=20
Sent: Monday, May 26, 2008 6:54 AM
To: TIAN Justin
Cc: Heikki Linnakangas; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] error message "psql: expected authentication request
from server, but received " when using psql to connect remote database=20
"TIAN Justin" <yongjuntian@alcatel-lucent.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