php5-mysql: Symbol not found: _mysqlnd_allocator

[pgoergler@…]

I've done today on my macbook snowleopard 10.6.4 (i386 not x86_64)

port install apache2 php5 php5-mysql

When i use php in command line, i haven't any errors but with apache :

[16-Nov-2010 20:42:41] PHP Warning:  PHP Startup: Unable to load dynamic library '/opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so' - dlopen(/opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so, 9): Symbol not found: _mysqlnd_allocator
  Referenced from: /opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so
  Expected in: flat namespace
 in /opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so in Unknown on line 0

[ryandesign (Ryan Carsten Schmidt)]

I don't know why this is happening. Have you already tried rebuilding php5-mysql?

[pgoergler@…]

yes, after a

port clean all
port upgrade --force php5-mysql

same probleme

The probleme seems to happen when apache starts and not when processing a php file, but apache crash when processing...

When apache start, in php error log

[22-Nov-2010 16:47:53] PHP Warning:  PHP Startup: Unable to load dynamic library '/opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so' - dlopen(/opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so, 9): Symbol not found: _mysqlnd_allocator
  Referenced from: /opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so
  Expected in: flat namespace
 in /opt/local/lib/php/extensions/no-debug-non-zts-20090626/pdo_mysql.so in Unknown on line 0

but when processing php file, no error in php error log but in apache error log:

[Mon Nov 22 16:48:33 2010] [notice] child pid 80934 exit signal Bus error (10)

here my macports.conf (without comments)

prefix			/opt/local
portdbpath		/opt/local/var/macports
applications_dir	/Applications/MacPorts
frameworks_dir		/opt/local/Library/Frameworks
sources_conf		/opt/local/etc/macports/sources.conf
variants_conf		/opt/local/etc/macports/variants.conf
build_arch			i386
universal_archs 		i386 i386

here my php.ini:

[PHP]
engine = On
zend.ze1_compatibility_mode = Off
short_open_tag = Off
asp_tags = Off
precision    =  12
y2k_compliance = On
output_buffering = Off
zlib.output_compression = Off
implicit_flush = Off
unserialize_callback_func=
serialize_precision = 100
allow_call_time_pass_reference = On
safe_mode = Off
safe_mode_gid = Off
safe_mode_include_dir =
safe_mode_exec_dir =
safe_mode_allowed_env_vars = PHP_
safe_mode_protected_env_vars = LD_LIBRARY_PATH
disable_functions =
disable_classes =
expose_php = On
max_execution_time = 30     ; Maximum execution time of each script, in seconds
max_input_time = 60	; Maximum amount of time each script may spend parsing request data
memory_limit = 128M      ; Maximum amount of memory a script may consume (128MB)
error_reporting  =  E_ALL & ~E_NOTICE
display_errors = On
display_startup_errors = On
log_errors = On
log_errors_max_len = 1024
ignore_repeated_errors = Off
ignore_repeated_source = Off
report_memleaks = On
track_errors = Off
error_log = /var/log/php5.log
variables_order = "EGPCS"
register_globals = Off
register_argc_argv = On
auto_globals_jit = On
post_max_size = 8M
magic_quotes_gpc = Off
magic_quotes_runtime = Off
magic_quotes_sybase = Off
auto_prepend_file =
auto_append_file =
default_mimetype = "text/html"
doc_root =
user_dir =
enable_dl = On
file_uploads = On
upload_max_filesize = 2M
allow_url_fopen = On
allow_url_include = Off
default_socket_timeout = 60
[Date]
date.timezone = "Indian/Mauritius"
[filter]
[iconv]
[sqlite]
[Pcre]
[Syslog]
define_syslog_variables  = Off
[mail function]
SMTP = localhost
smtp_port = 25
[SQL]
sql.safe_mode = Off
[ODBC]
odbc.allow_persistent = On
odbc.check_persistent = On
odbc.max_persistent = -1
odbc.max_links = -1
odbc.defaultlrl = 4096
odbc.defaultbinmode = 1
[MySQL]
mysql.allow_persistent = On
mysql.max_persistent = -1
mysql.max_links = -1
mysql.default_port =
mysql.default_socket = /private/var/mysql/mysql.sock
pdo_mysql.default_socket = /private/var/mysql/mysql.sock
mysql.default_host =
mysql.default_user =
mysql.default_password =
mysql.connect_timeout = 60
mysql.trace_mode = Off
[MySQLi]
mysqli.max_links = -1
mysqli.default_port = 3306
mysqli.default_socket =
mysqli.default_host =
mysqli.default_user =
mysqli.default_pw =
mysqli.reconnect = Off
[mSQL]
msql.allow_persistent = On
msql.max_persistent = -1
msql.max_links = -1
[OCI8]
[PostgresSQL]
pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
pgsql.log_notice = 0
[Sybase]
sybase.allow_persistent = On
sybase.max_persistent = -1
sybase.max_links = -1
sybase.min_error_severity = 10
sybase.min_message_severity = 10
sybase.compatability_mode = Off
[Sybase-CT]
sybct.allow_persistent = On
sybct.max_persistent = -1
sybct.max_links = -1
sybct.min_server_severity = 10
sybct.min_client_severity = 10
[bcmath]
bcmath.scale = 0
[browscap]
[Informix]
ifx.default_host =
ifx.default_user =
ifx.default_password =
ifx.allow_persistent = On
ifx.max_persistent = -1
ifx.max_links = -1
ifx.textasvarchar = 0
ifx.byteasvarchar = 0
ifx.charasvarchar = 0
ifx.blobinfile = 0
ifx.nullformat = 0
[Session]
session.save_handler = files
session.save_path = "/opt/www_sessions"
session.use_cookies = 1
session.name = PHPSESSID
session.auto_start = 0
session.cookie_lifetime = 0
session.cookie_path = /
session.cookie_domain =
session.cookie_httponly = 
session.serialize_handler = php
session.gc_probability = 1
session.gc_divisor     = 100
session.gc_maxlifetime = 1440
session.bug_compat_42 = 1
session.bug_compat_warn = 1
session.referer_check =
session.entropy_length = 0
session.entropy_file =
session.cache_limiter = nocache
session.cache_expire = 180
session.use_trans_sid = 0
session.hash_function = 0
session.hash_bits_per_character = 4
url_rewriter.tags = "a=href,area=href,frame=src,input=src,form=,fieldset="
[MSSQL]
mssql.allow_persistent = On
mssql.max_persistent = -1
mssql.max_links = -1
mssql.min_error_severity = 10
mssql.min_message_severity = 10
mssql.compatability_mode = Off
mssql.secure_connection = Off
[Assertion]
[COM]
[mbstring]
[FrontBase]
[gd]
[exif]
[Tidy]
tidy.clean_output = Off
[soap]
soap.wsdl_cache_enabled=1
soap.wsdl_cache_dir="/tmp"
soap.wsdl_cache_ttl=86400

[ryandesign (Ryan Carsten Schmidt)]

Replying to pgoergler@…:

universal_archs i386 i386

Have you built anything with the +universal variant? If so, your strange universal_archs setting in macports.conf may cause problems. universal_archs is supposed to be set to the two or more architectures for which you want to build universal; repeating the same architecture twice is an error and I have no idea what will happen as a result.

[pgoergler@…]

i never used +universal

[ryandesign (Ryan Carsten Schmidt)]

This problem still puzzles me.

If you "sudo port selfupdate" and "sudo port upgrade outdated" to get the latest versions of everything, do you still see this problem?

Do you have anything in /usr/local (which might be interfering)?

[pgoergler@…]

Ow, i gave up few weeks ago. But i try this morning and it works good again. Thanks !

[jmroot (Joshua Root)]

Closing as per comment:8.