Postmap Issue

[Matthew Seaman]

On 21/09/2011 07:17, Van Der Meulen, Mark wrote:
> mail# postmap /usr/local/etc/postfix/transport
> 
> /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

-- 
Dr Matthew J Seaman MA, D.Phil.                   7 Priory Courtyard
                                                  Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey     Ramsgate
JID: matthew at infracaninophile.co.uk               Kent, CT11 9PW

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 267 bytes
Desc: OpenPGP digital signature
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20110921/4f5e3645/signature.pgp