[MacPorts] #22380: php 5.3 mysql & mysqli extensions not loading due to pointer error

[MacPorts]

#22380: php 5.3 mysql & mysqli extensions not loading due to pointer error
--------------------------------------------------+-------------------------
 Reporter:  bjezyk@…                              |       Owner:  macports-tickets@…                   
     Type:  defect                                |      Status:  new                                  
 Priority:  Normal                                |   Milestone:                                       
Component:  ports                                 |     Version:  1.8.1                                
 Keywords:  php 5.3 mysql 5.1 extension not load  |        Port:  php5-mysql                           
--------------------------------------------------+-------------------------

Comment(by bjezyk@…):

 Replying to [ticket:22380 bjezyk@…]:
 > [ ~ ]$ php -v
 > PHP Warning:  PHP Startup: Unable to load dynamic library
 '/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysql.so' -
 dlopen(/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysql.so,
 9): Library not loaded:
 /opt/local/lib/mysql5/mysql/libmysqlclient.15.dylib
 >   Referenced from: /opt/local/lib/php/extensions/no-debug-non-
 zts-20090626/mysql.so
 >   Reason: image not found in Unknown on line 0
 >
 > Warning: PHP Startup: Unable to load dynamic library
 '/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysql.so' -
 dlopen(/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysql.so,
 9): Library not loaded:
 /opt/local/lib/mysql5/mysql/libmysqlclient.15.dylib
 >   Referenced from: /opt/local/lib/php/extensions/no-debug-non-
 zts-20090626/mysql.so
 >   Reason: image not found in Unknown on line 0
 > PHP Warning:  PHP Startup: Unable to load dynamic library
 '/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysqli.so' -
 dlopen(/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysqli.so,
 9): Library not loaded:
 /opt/local/lib/mysql5/mysql/libmysqlclient.15.dylib
 >   Referenced from: /opt/local/lib/php/extensions/no-debug-non-
 zts-20090626/mysqli.so
 >   Reason: image not found in Unknown on line 0
 >
 > Warning: PHP Startup: Unable to load dynamic library
 '/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysqli.so' -
 dlopen(/opt/local/lib/php/extensions/no-debug-non-zts-20090626/mysqli.so,
 9): Library not loaded:
 /opt/local/lib/mysql5/mysql/libmysqlclient.15.dylib
 >   Referenced from: /opt/local/lib/php/extensions/no-debug-non-
 zts-20090626/mysqli.so
 >   Reason: image not found in Unknown on line 0
 > PHP 5.3.0 (cli) (built: Nov  4 2009 11:56:53)
 > Copyright (c) 1997-2009 The PHP Group
 > Zend Engine v2.3.0, Copyright (c) 1998-2009 Zend Technologies
 >
 > [ ~ ]$ mysql --version
 > mysql  Ver 14.14 Distrib 5.1.40, for apple-darwin9.5.0 (i386) using
 readline 6.0
 >
 > [ ~ ]$ ls -l /opt/local/lib/mysql5/mysql/
 > total 42824
 > Oct 28 15:17 libdbug.a
 > Oct 28 15:17 libheap.a
 > Oct 28 15:17 libmyisam.a
 > Oct 28 15:17 libmyisammrg.a
 > Oct 28 15:18 libmysqlclient.16.dylib
 > Oct 28 15:18 libmysqlclient.a
 > Oct 28 15:18 libmysqlclient.dylib -> libmysqlclient.16.dylib
 > Oct 28 15:18 libmysqlclient.la
 > Oct 28 15:18 libmysqlclient_r.16.dylib
 > Oct 28 15:18 libmysqlclient_r.a
 > Oct 28 15:18 libmysqlclient_r.dylib -> libmysqlclient_r.16.dylib
 > Oct 28 15:18 libmysqlclient_r.la
 > Oct 28 15:18 libmysqld.a
 > Oct 28 15:17 libmystrings.a
 > Oct 28 15:17 libmysys.a
 > Oct 28 15:17 libndbclient.3.dylib
 > Oct 28 15:17 libndbclient.a
 > Oct 28 15:18 libndbclient.dylib -> libndbclient.3.dylib
 > Oct 28 15:17 libndbclient.la
 > Oct 28 15:18 libvio.a
 > Oct 28 15:18 plugin
 >
 >
 > #### temp workaround to get some php mysql functionality - yet complaint
 about client server version mismatch exists
 >
 > [ ~ ]$ cd /opt/local/lib/mysql5/mysql/ ; sudo ln -s libmysqlclient.dylib
 libmysqlclient.15.dylib


 sudo port uninstall -f php5-mysql @5.3.0_0+mysql5 ; sudo port clean
 php5-mysql ; sudo port -v install php5-mysql +mysql5

 resolved the mismatch complaint
 maybe would have the whole thing if i had tried it before submitting this
 ticket.  well maybe its good to know nonetheless.

-- 
Ticket URL: <http://trac.macports.org/ticket/22380#comment:1>
MacPorts <http://www.macports.org/>
Ports system for Mac OS