Re: [INTERFACES] Authentication problem

eric(at)gateway(dot)ctlno(dot)com wrote:

> I am writing a program to interface with the pgsql backend in c on a
> linux box.
> When I try to connect, it gives me the following error message:
>
> Failed to authenticate client as Postgres user 'root' using <unknown
> authentication type>:be_recvauth: unrecognized message type: 65536
>
> I think maybe I should use the fe_setauthsvc function to change the
> authentication type, but the manual doesn't help on that function.
>
> User 'root' is a valid user for the database, and i've also tried other
> valid users to connect, with the same error message.
>
> Your help is greatly appreciated.

It looks like the protocol between the frontend and backend do not match.
If the backend is Postgres 6.2, you must use the 6.2 protocol. If you are
writing your own connection functions, then you must use the correct
startup packet.

Byron