Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id PAA20547 for ; Fri, 12 Jun 1998 15:11:26 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.9.0/8.9.0) with UUCP id OAA18699 for pgsql-interfaces@postgreSQL.org; Fri, 12 Jun 1998 14:57:44 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA38769; Fri, 12 Jun 1998 14:41:32 -0400 Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03) id AA27590; Fri, 12 Jun 1998 14:41:31 -0400 Message-Id: <3581761E.81EC3557@insightdist.com> Date: Fri, 12 Jun 1998 14:40:30 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: eric@gateway.ctlno.com Cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Authentication problem References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit eric@gateway.ctlno.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 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