ports/177610: maia makefile check for mysql-client does not work on 64-bit platform

[Patrick Oonk]

>Number:         177610
>Category:       ports
>Synopsis:       maia makefile check for mysql-client does not work on 64-bit platform
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          maintainer-update
>Submitter-Id:   current-users
>Arrival-Date:   Wed Apr 03 11:50:00 UTC 2013
>Closed-Date:
>Last-Modified:
>Originator:     Patrick Oonk
>Release:        9.1
>Organization:
pine digital security
>Environment:
9.1-RELEASE FreeBSD 9.1-RELEASE #0 r243825: Tue Dec  4 09:23:10 UTC 2012     root at farrell.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  amd64
>Description:
Hi,

When I try to install maia, it determines mysql55-client is not
installed, though it IS installed.
It then tries to install mysql55-client which of course fails, and
subsequently maia fails also.

I think the key line here is

  maia-1.0.3.r1575_3 depends on shared library: mysqlclient.18 - not found

# ls -al /usr/local/lib/mysql/*
-rw-r--r--  1 root  wheel   4844118 Apr  2 17:04
/usr/local/lib/mysql/libmysqlclient.a
lrwxr-xr-x  1 root  wheel        20 Apr  2 17:04
/usr/local/lib/mysql/libmysqlclient.so -> libmysqlclient.so.18
-rwxr-xr-x  1 root  wheel   3364688 Apr  2 17:04
/usr/local/lib/mysql/libmysqlclient.so.18
lrwxr-xr-x  1 root  wheel        16 Apr  2 17:04
/usr/local/lib/mysql/libmysqlclient_r.a -> libmysqlclient.a
lrwxr-xr-x  1 root  wheel        17 Apr  2 17:04
/usr/local/lib/mysql/libmysqlclient_r.so -> libmysqlclient.so
lrwxr-xr-x  1 root  wheel        17 Apr  2 17:04
/usr/local/lib/mysql/libmysqlclient_r.so.18 -> libmysqlclient.so
-rw-r--r--  1 root  wheel  20037118 Mar 29 17:02
/usr/local/lib/mysql/libmysqld.a
-rw-r--r--  1 root  wheel      4598 Apr  2 17:04
/usr/local/lib/mysql/libmysqlservices.a


# ldconfig -r | grep mysql
        search directories:
/lib:/usr/lib:/usr/lib/compat:/usr/local/lib:/usr/local/lib/compat/pkg:/usr/local/lib/dovecot:/usr/local/lib/dovecot/imap:/usr/local/lib/dovecot/pop3:/usr/local/lib/dovecot/lda:/usr/local/lib/mysql
        152:-lmysqlclient.18 => /usr/local/lib/mysql/libmysqlclient.so.18
        153:-lmysqlclient_r.18 =>
/usr/local/lib/mysql/libmysqlclient_r.so.18




--->  Installing 'maia-1.0.3.r1575_3' from a port (security/maia)
--->  Building '/usr/ports/security/maia'
===>  Cleaning for mysql-client-5.5.30
===>  Cleaning for maia-1.0.3.r1575_3
===>  Found saved configuration for maia-1.0.3.r1575_3
===> Fetching all distfiles required by maia-1.0.3.r1575_3 for building
===>  Extracting for maia-1.0.3.r1575_3
=> SHA256 Checksum OK for maia-1.0.3-r1575.tar.gz.
===>  Patching for maia-1.0.3.r1575_3
===>   maia-1.0.3.r1575_3 depends on shared library: mysqlclient.18 -
not found
===>    Verifying install for mysqlclient.18 in
/usr/ports/databases/mysql55-client
===>  Found saved configuration for mysql-client-5.5.30
===> Fetching all distfiles required by mysql-client-5.5.30 for building
===>  Extracting for mysql-client-5.5.30
=> SHA256 Checksum OK for mysql-5.5.30.tar.gz.

(...)

===>  Installing for mysql-client-5.5.30
===>   Generating temporary packing list
===>  Checking if databases/mysql55-client already installed
===>   mysql-client-5.5.30 is already installed
      You may wish to ``make deinstall'' and install this port again
      by ``make reinstall'' to upgrade it properly.
      If you really wish to overwrite the old port of
databases/mysql55-client
      without deleting it first, set the variable "FORCE_PKG_REGISTER"
      in your environment or the "make install" command line.
*** [check-already-installed] Error code 1

Stop in /usr/ports/databases/mysql55-client.
*** [install] Error code 1

Stop in /usr/ports/databases/mysql55-client.
*** [lib-depends] Error code 1

Stop in /usr/ports/security/maia.
*** [configure] Error code 1

Stop in /usr/ports/security/maia.
** Command failed [exit code 1]: /usr/bin/script -qa
/tmp/portinstall20130403-48248-8nugs5-0 env make
** Fix the problem and try again.
** Listing the failed packages (-:ignored / *:skipped / !:failed)
        ! security/maia (unknown build error)

>How-To-Repeat:
/usr/ports/security/maia # make -n lib-depends | sh -x

(...)

+ echo -n '===>   maia-1.0.3.r1575_3 depends on shared library:
mysqlclient.18'
===>   maia-1.0.3.r1575_3 depends on shared library: mysqlclient.18+
/sbin/ldconfig -32 -r
+ /usr/bin/grep -vwF -e /usr/local/lib/compat/pkg
+ /usr/bin/grep -qwE -e '-lmysqlclient\.18'
+ echo ' - not found'
 - not found
+ notfound=1
+ [ 1 != 0 ]

The '/sbin/ldconfig -32 -r' seems to be the problem, this is a 64-bit
system...

# ldconfig -r | grep mysql
        search directories:
/lib:/usr/lib:/usr/lib/compat:/usr/local/lib:/usr/local/lib/compat/pkg:/usr/local/lib/dovecot:/usr/local/lib/dovecot/imap:/usr/local/lib/dovecot/pop3:/usr/local/lib/dovecot/lda:/usr/local/lib/mysql
        152:-lmysqlclient.18 => /usr/local/lib/mysql/libmysqlclient.so.18
        153:-lmysqlclient_r.18 =>
/usr/local/lib/mysql/libmysqlclient_r.so.18

# ldconfig -32 -r | grep mysql
>Fix:
remove the -32 might help

>Release-Note:
>Audit-Trail:
>Unformatted: