Why do I get a message like “Failed to authenticate client as Postgres user using unknown authentication type:be_recvauth: unrecognized message type: 65536” when I try to connect to a datasource?
This message comes from the PostgreSQL backend, most likely when there is a protocol mismatch between the ODBC driver and the backend. For example, if you are using PostgreSQL 6.2 as the backend and try to use the ODBC driver without correctly setting the protocol, this error will occur. You must check the “6.2 protocol” advanced datasource option in the ODBC driver configuration dialog. Note: If you’re still running 6.x these days, you really, really, really should upgrade to 8.x as soon as possible!!
Related Questions
- Why do I get a message like "Failed to authenticate client as Postgres user using unknown authentication type:be_recvauth: unrecognized message type: 65536" when I try to connect to a datasource?
- Why is the agent showing an error in my PostgreSQL discovery about authentication failed for user "postgres"?
- Why is the agent showing an error in my postgres discovery about authentication failed for user "postgres"?