Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 21 Sep 2011 09:33:39 +0100
From:      Matthew Seaman <m.seaman@infracaninophile.co.uk>
To:        "Van Der Meulen, Mark" <Mark.VanDerMeulen@travelex.com.au>
Cc:        freebsd-questions@freebsd.org
Subject:   Re: Postmap Issue
Message-ID:  <4E79A163.7050309@infracaninophile.co.uk>
In-Reply-To: <CA324096F289D443A2ECAA48CEA5FD1416D5CF8F@AU-SYD-EX-VS1.apac.travelex.net>
References:  <CA324096F289D443A2ECAA48CEA5FD1416D5CF8F@AU-SYD-EX-VS1.apac.travelex.net>

next in thread | previous in thread | raw e-mail | index | archive | help
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--



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4E79A163.7050309>