Re: [BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database
"TIAN Justin" <[EMAIL PROTECTED]> 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database
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:[EMAIL PROTECTED] 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 "TIAN Justin" <[EMAIL PROTECTED]> 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 -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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database
"TIAN Justin" <[EMAIL PROTECTED]> 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 -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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database
Heikki Linnakangas, 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 -d testdb -h localhost Output: psql: expected authentication request from server, but received when used 8.0.3, no problem, > psql -U or -p -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:[EMAIL PROTECTED] 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 -d > -h ", 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
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 -d -h ", 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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] error message "psql: expected authentication request from server, but received " when using psql to connect remote database
Hi, 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 -d -h ", 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? Thanks Justin
