Re: MySQL 4.0.18 libmysqlclient error

[Paul Bingman <paulobsd_(_at_)_edgewood_(_dot_)_net>]

On Fri, 11 Jun 2004, OpenBSD :: JGM wrote:

> hi bob, I have the same problem with mysql 4.0.18/20 and obsd 3.4 and
> 3.5, you find a solution?
>
> thanks in advance
>
> On Mon, May 17, 2004 at 10:27:00AM -0600, Bob DeBolt wrote:
> > Greets
> >
> >
> > ># mysql
> > >mysql: can't load library '../libmysql/.libs/libmysqlclient.so.12.0'
> > >
> > >I've trying searching google for a fix, but I can't seem to find
> > >anything.  I compiled mysql from /var/work/compile/mysql-4.0.18, and if
> > >I cd to a sub directory of that path, the mysql client starts without
> > >any problems.  If I try from any other path, I get the error.  Let me
> > >know if you need any additional information from me, and thanks in
> > >advance for your help.
> >
> > >
> > I have the same issue on a 3.4 machine, same mysql version etc.
> >
> > Have you resolved this? If so what did you do. I can run the client from
> > the directory /var/work/compile/mysql-4.0.18/libmysql with no problems.
> >
> > I have the libs linked etc., it shows up in the hints file etc. I have the
> > pathing
> > correct and on and on. I have been through the docs multiple times and still
> > this one issue remains. The server starts and run fine.

This is a build problem in MySQL.  The library path ends up being
hard-coded in the binary.  You can run strings or ldd on the binary and
see it there.  It's only the mysql client binary that has this problem;
the rest of MySQL builds and works correctly.

The mysql-client-4.0.18.tgz and mysql-server-4.0.18.tgz packages are
built correctly and work just fine.  Use pkg_add on them and you'll have
a working mysql.

paul