From owner-freebsd-current@FreeBSD.ORG Thu Mar 29 08:38:22 2012 Return-Path: Delivered-To: freebsd-current@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 11A1E106564A for ; Thu, 29 Mar 2012 08:38:22 +0000 (UTC) (envelope-from ohartman@zedat.fu-berlin.de) Received: from outpost1.zedat.fu-berlin.de (outpost1.zedat.fu-berlin.de [130.133.4.66]) by mx1.freebsd.org (Postfix) with ESMTP id B6B328FC17 for ; Thu, 29 Mar 2012 08:38:21 +0000 (UTC) Received: from inpost2.zedat.fu-berlin.de ([130.133.4.69]) by outpost1.zedat.fu-berlin.de (Exim 4.69) with esmtp (envelope-from ) id <1SDAs8-0008Vl-De>; Thu, 29 Mar 2012 10:38:20 +0200 Received: from e178026171.adsl.alicedsl.de ([85.178.26.171] helo=thor.walstatt.dyndns.org) by inpost2.zedat.fu-berlin.de (Exim 4.69) with esmtpsa (envelope-from ) id <1SDAs8-0007bJ-7y>; Thu, 29 Mar 2012 10:38:20 +0200 Message-ID: <4F741F70.1010305@zedat.fu-berlin.de> Date: Thu, 29 Mar 2012 10:38:08 +0200 From: "O. Hartmann" User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:10.0.3) Gecko/20120314 Thunderbird/10.0.3 MIME-Version: 1.0 To: Eduardo Morras References: <4F718034.8090501@mail.zedat.fu-berlin.de> <4EFDA80601439209@> (added by postmaster@resmaa14.ono.com) In-Reply-To: <4EFDA80601439209@> (added by postmaster@resmaa14.ono.com) X-Enigmail-Version: 1.4 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig22EAA3101F8539A609C15117" X-Originating-IP: 85.178.26.171 Cc: freebsd-current@freebsd.org Subject: Re: PostgreSQL server 9.1.3 rejects connections after update: Error connection to the server: FATAL: frontend-protocol 1234.5887 not supported: server supports 1.0 through 3.0 X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 29 Mar 2012 08:38:22 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig22EAA3101F8539A609C15117 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 03/27/12 15:20, schrieb Eduardo Morras: > At 10:54 27/03/2012, you wrote: >> Since the last PostgreSQL port update, server and client are version >> 9.1.3 and a newly build of the FreeBSD OS (both 9.0-STABLE and >> 10.0-CURRENT, amd64), clients like pgadmin3 or webinterfaces like thos= e >> from refdb reject connection to the PostgreSQL server with the error >> message: >> >> Error connection to the server: FATAL: frontend-protocol 1234.5887 not= >> supported: server supports 1.0 through 3.0 >> >> All users, execept a local admin and the psql user, are kept in >> OpenLDAP. It seems, that the LDAP connection got messed up somehow. >> >> I tried to recompile everything required by OpenLDAP, PostgreSQL via >> >> portmaster -f, since I realized changes in Heimdal on FreeBSD 10.0-CUR= >> and I deleted the old libs via delete-old-libs/files. >> >> Does anyone see this problem, too? >=20 > No sorry, i use 8.2 for Postgresql server. >=20 > Have you touched the pg_hba.conf file? Perhaps it has been reinstalled > and setted with default values, so pg don't know what a ldap server is.= As I figured out, this problem occurs only with clients running on FreeBSD 10.0-CURRENT. A notebook, FreeBSD 9.0/amd64, but with most recent ports, also postgresql-9.1.3 clients, recompiled textproc/refdb clients, recompiled openldap clients, recompiled pgadmin3 (and all the dependencies) does not sho this weird error and behaviour. As I wrote, the configs of the server hasn't been touched, ran perfectly since approx. a week ago even with the FreeBSD 10 clients and now, after a recent update (do not know whether a port or OS triggers the problem) I receive this weird behaviour which is really boring. As far as I know, there was a Kerberos5/Heimdal update recently on FreeBSD 10. I did a "make delete-old-*" in /usr/src and deleted those old files/libs/dirs et cetera. After that, I had to recompile a bunch of ports, even all dependencies of openldap, postgresql, pgadmin and even subversion to make them work again, since the were compiled against those deleted outdated libs in some parts. I can not exactly say that since then the problem occured, but I think it might be that way. Regards, Oliver --------------enig22EAA3101F8539A609C15117 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (FreeBSD) iQEcBAEBAgAGBQJPdB97AAoJEOgBcD7A/5N8RyMH/35qQLxvY0dMl4Z4NcgsKdj8 QbCvvf8iHAHVOzikm57EA1LQGHyS+gR5nGemllIoVhb8e8/ZKfTifXM5bgp+bzpj Mra3Ht8KWaMgSwnVDUr/qBq2OABL+wAAjoPBW9iKZK+AvvYjc5EmdehKzRWiZIrM Cdylbm9sGF3VxTVjawriVPuvMRF3VHaHiOctx2oC0K6lDUCpgS2jPTE5yYeQ0h9g aKJi6PGk0LvuUMVzloKoSEZiGDJQPnadIAx4kkeCJs9PiqZ+8aBLKj0jUnrfA2Gd Sxp+I1wU/T1tRk5T1FJ+jaWUKj4gJ1+FMIZT3bxCUTVXHcrpXldNKWKbNecA7rs= =6nUs -----END PGP SIGNATURE----- --------------enig22EAA3101F8539A609C15117--