From owner-freebsd-questions@FreeBSD.ORG Wed Sep 21 08:33:50 2011 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id A43FE1065670 for ; Wed, 21 Sep 2011 08:33:50 +0000 (UTC) (envelope-from m.seaman@infracaninophile.co.uk) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3fd3:cd67:fafa:3d78]) by mx1.freebsd.org (Postfix) with ESMTP id 0C6A08FC0A for ; Wed, 21 Sep 2011 08:33:49 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.187.76.163]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.14.5/8.14.5) with ESMTP id p8L8Xibx065836 (version=TLSv1/SSLv3 cipher=DHE-RSA-CAMELLIA256-SHA bits=256 verify=NO); Wed, 21 Sep 2011 09:33:46 +0100 (BST) (envelope-from m.seaman@infracaninophile.co.uk) X-DKIM: Sendmail DKIM Filter v2.8.3 smtp.infracaninophile.co.uk p8L8Xibx065836 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1316594026; bh=VulMbzjxNtHsV5SPaqdrUgQ98XDTGTwDoYreYaLM+JI=; h=Message-ID:Date:From:MIME-Version:To:CC:Subject:References: In-Reply-To:Content-Type:Cc:Content-Type:Date:From:In-Reply-To: Message-ID:Mime-Version:References:To; z=Message-ID:=20<4E79A163.7050309@infracaninophile.co.uk>|Date:=20W ed,=2021=20Sep=202011=2009:33:39=20+0100|From:=20Matthew=20Seaman= 20|User-Agent:=20Mozilla/5.0=20(M acintosh=3B=20Intel=20Mac=20OS=20X=2010.6=3B=20rv:6.0.2)=20Gecko/2 0110902=20Thunderbird/6.0.2|MIME-Version:=201.0|To:=20"Van=20Der=2 0Meulen,=20Mark"=20|CC:=20freeb sd-questions@freebsd.org|Subject:=20Re:=20Postmap=20Issue|Referenc es:=20|In-Reply-To:=20|X-Enigmail-Version:=201.3.1 |OpenPGP:=20id=3D60AE908C|Content-Type:=20multipart/signed=3B=20mi calg=3Dpgp-sha1=3B=0D=0A=20protocol=3D"application/pgp-signature"= 3B=0D=0A=20boundary=3D"------------enig2C90CD6112C8C625ECF6979B"; b=UCZCpdAZ5Sc6o8HsFLnwYcrC19t0jXKJcqaH2CryehgCnCc+E0uvslbFvMLCGCN08 h/McFcspokHCHuwrRo5464I1Ln3ZNDqxuIWZscy9YAlpt7feyrVm+1+qBRvR3vNlHu dYnM3Fme8LTr9LgiDQlmzaoW3pemJKfxBhXXmYSM= Message-ID: <4E79A163.7050309@infracaninophile.co.uk> Date: Wed, 21 Sep 2011 09:33:39 +0100 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.6; rv:6.0.2) Gecko/20110902 Thunderbird/6.0.2 MIME-Version: 1.0 To: "Van Der Meulen, Mark" References: In-Reply-To: X-Enigmail-Version: 1.3.1 OpenPGP: id=60AE908C Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig2C90CD6112C8C625ECF6979B" X-Virus-Scanned: clamav-milter 0.97.2 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-0.1 required=5.0 tests=BAYES_20,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU autolearn=ham version=3.3.2 X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on lucid-nonsense.infracaninophile.co.uk Cc: freebsd-questions@freebsd.org Subject: Re: Postmap Issue X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 21 Sep 2011 08:33:50 -0000 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig2C90CD6112C8C625ECF6979B Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable On 21/09/2011 07:17, Van Der Meulen, Mark wrote: > mail# postmap /usr/local/etc/postfix/transport >=20 > /libexec/ld-elf.so.1: Shared object "libmysqlclient.so.18" not found, > required by "postmap" What version of mysql client do you have installed? libmysqlclient.so.18 comes from databases/mysql55-client which became the default MySQL version about 6 months ago. There are two ways you can get this problem: 1) Incompatible version of MySQL client installed: If you use binary packages from the FreeBSD ftp servers, they will be compiled against mysql55 shared libs nowadays. If you instal from ports, it will automatically link against whatever version of MySQL client you have installed. However, if you had installed an older version of MySQL it wouldn't automatically get upgraded to MySQL 5.5.x -- that you'ld have to do manually. So updating via pkgs could lead to the situation you see -- except you should have run into it about 6 months ago... As I recall, the MySQL 5.1 to 5.5 upgrade is not particularly onerous, but if you're upgrading MySQL server at the same time, you need to take the DB down while you're doing the updates, and you need to run the 'mysql-after-upgrade' stuff to applie various changes to the standard DB schema. 2) Correct version of mysql-client installed, but ld.so can't find the libmysqlclient shlib So, assuming you've got mysql-client-5.5.x installed -- The MySQL ports install their shlibs into /usr/local/lib/mysql/ and add that to the default list of paths for ld.so to search. That should be automatic, but maybe something went wrong. What does: ldconfig -r | grep 'search directories' return? How about ldconfig -r | grep 'mysql' ? If /usr/local/lib/mysql/libmysqlclient.so.18 is missing from the above, then you can fix things up by: ldconfig -m /usr/local/lib/mysql Cheers Matthew --=20 Dr Matthew J Seaman MA, D.Phil. 7 Priory Courtyard Flat 3 PGP: http://www.infracaninophile.co.uk/pgpkey Ramsgate JID: matthew@infracaninophile.co.uk Kent, CT11 9PW --------------enig2C90CD6112C8C625ECF6979B Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.16 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk55oWgACgkQ8Mjk52CukIz5GACbB8IG/X2L/JCl4k1ux6pQ2ae6 izgAoInR9eDi7uoFWBsaiIRo4T7NvXXx =2ouA -----END PGP SIGNATURE----- --------------enig2C90CD6112C8C625ECF6979B--