That elusive mysqlclient.16

[Dan Nelson]

In the last episode (Apr 17), Gene said:
> On Sat, 17 Apr 2010 21:11:16 -0500, Dan Nelson wrote
> > In the last episode (Apr 17), Gene said:
> > > On Sat, 17 Apr 2010 20:17:37 -0500, Dan Nelson wrote
> > > > In the last episode (Apr 17), Gene said:
> > > > > Attempts to build databases/mysql55-server or php5-mysql, or
> > > > > php5-mysqli all stop with the following error:
> > > > > 
> > > > > Error: shared library "mysqlclient.16" does not exist
> > > > > 
> > > > > I've tried building and rebuilding mysql55-client, tried
> > > > > portupgrade (after portsnap) all to no avail.  Google searches
> > > > > found one item, and that was in Chinese.
> > > > >
> > > > > Does anyone know what port is supposed to install this shared
> > > > > library?  I'd think the file would be installed by mysql55-client,
> > > > > but apparently not.
> > > > 
> > > > mysql55-client installs it.  Try rebuilding mysql55-client again and
> > > > make sure it installs successfully.
> > > 
> > > Dan - thanks for the reply.
> > > 
> > > I did the following:
> > > cd /usr/ports/databases/mysql55-client
> > > script ../t
> > > make clean
> > > make
> > > make deinstall && make reinstall
> > > exit
> > > 
> > > Installation completed successfully.
> > > 
> > > mysqlclient.16 still cannot be found, nor does the filename occur in
> > > ../t.
> > > 
> > > Any ideas where to go next?  I can put the script output up on the web
> > > if you think it'll help.  It's kinda big for an email.
> > 
> > Script output would be useful.  Did anything at all get installed in
> > /usr/local/lib/mysql/ ?  If there is a libmysqlclient.so.16 file, does
> > "ldconfig -r | grep libmysqlclient.so.16" print anything?
> > 
> > -- 
> > 	Dan Nelson
> > 	dnelson at allantgroup.com
> 
> Hi again...
> script output should be available at:
> 
> http://brightstar.ath.cx/temp/t

This line in your script should have installed that shared object:

  libtool: install: /usr/bin/install -c -o root -g wheel .libs/libmysqlclient.so.16 /usr/local/lib/mysql/libmysqlclient.so.16

, although you seem to have a file ownership problem, which could be
affecting the install:

 ===>   Running ldconfig
 /sbin/ldconfig -m /usr/local/lib/mysql
 ldconfig: /usr/local/lib/mysql: ignoring directory not owned by root

Try fixing that and do a "make deinstall ; make reinstall" (no rebuild
should be necessary).
 
> brightstar2# ls /usr/local/lib/mysql
> libdbug.a               libmysqlclient.a        libmysqlclient_r.a     
> libmysqld.a             libvio.a
> libheap.a               libmysqlclient.la       libmysqlclient_r.la    
> libmysqlservices.a      plugin
> libmyisam.a             libmysqlclient.so       libmysqlclient_r.so    
> libmystrings.a
> libmyisammrg.a  

ls -l please; libmysqlclient.so should be a symlink to libmysqlclient.so.16:

(dan at dan.14) /usr/local/lib/mysql> ls -l libmysqlclient*
-rw-r--r--  1 root  wheel  618618 Apr 17 20:29 libmysqlclient.a
-rwxr-xr-x  1 root  wheel     987 Apr 17 20:29 libmysqlclient.la
lrwxr-xr-x  1 root  wheel      20 Apr 17 20:29 libmysqlclient.so -> libmysqlclient.so.16
-rwxr-xr-x  1 root  wheel  543213 Apr 17 20:29 libmysqlclient.so.16
-rw-r--r--  1 root  wheel  640244 Apr 17 20:29 libmysqlclient_r.a
-rwxr-xr-x  1 root  wheel    1010 Apr 17 20:29 libmysqlclient_r.la
lrwxr-xr-x  1 root  wheel      22 Apr 17 20:29 libmysqlclient_r.so -> libmysqlclient_r.so.16
-rwxr-xr-x  1 root  wheel  561411 Apr 17 20:29 libmysqlclient_r.so.16

-- 
	Dan Nelson
	dnelson at allantgroup.com