Opened 15 years ago

Closed 15 years ago

#22380 closed defect (invalid)

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

Reported by: bjezyk@… Owned by: ryandesign (Ryan Carsten Schmidt)
Priority: Normal Milestone:
Component: ports Version: 1.8.1
Keywords: Cc:
Port: php5-mysql

Description (last modified by jmroot (Joshua Root))

[ ~ ]$ 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

Change History (3)

comment:1 in reply to:  description Changed 15 years ago by 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.

comment:2 Changed 15 years ago by jmroot (Joshua Root)

Cc: ryandesign removed
Description: modified (diff)
Keywords: php 5.3 mysql 5.1 extension not load removed
Owner: changed from macports-tickets@… to ryandesign@…

comment:3 Changed 15 years ago by ryandesign (Ryan Carsten Schmidt)

Resolution: invalid
Status: newclosed

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.

Note: See TracTickets for help on using tickets.