php 5.3 mysql & mysqli extensions not loading due to pointer error

[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

[bjezyk@…]

Replying to 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.

[ryandesign@…]

When you upgraded mysql5 from 5.0.x to 5.1.x recently, the version of the libmysqlclient.dylib library changed. You must therefore rebuild any port that uses that library, such as (since you used the +mysql5 variant) the php5-mysql port.

You should also remove the libmysqlclient.15.dylib symlink you created. I assume the MySQL developers changed the library version number for a reason; I assume the new library is not interchangeable with the old library, necessitating the filename to change.