mysql5 5.0.41 fails to install

[ldeck]

I'm on a Powerbook (G4 1.67Ghz).

First tried upgrading mysql5 from a previous version. That failed for the same reason. So I uninstalled the old one and then attempting installing fresh. That failed also.

It seems to have something to do with the updated libz library not having certain definitions.

Any ideas?

lds-mac:~ ldeck$ sudo port install mysql5 +server
--->  Fetching mysql5
--->  Verifying checksum(s) for mysql5
--->  Extracting mysql5
--->  Applying patches to mysql5
--->  Configuring mysql5
--->  Building mysql5 with target all
Error: Target com.apple.build returned: shell command " cd "/opt/local/var/db/dports/build/_opt_local_var_db_dports_sources_rsync.rsync.darwinports.org_dpupdate_dports_databases_mysql5/work/mysql-5.0.41" && make all " returned error 2
Command output: then mv -f ".deps/parse_file.Tpo" ".deps/parse_file.Po"; else rm -f ".deps/parse_file.Tpo"; exit 1; fi
if /usr/bin/g++-4.0 -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/opt/local\"" -DDATADIR="\"/opt/local/var/db/mysql5\"" -DSHAREDIR="\"/opt/local/share/mysql5/mysql\"" -DHAVE_CONFIG_H -I. -I. -I.. -I/opt/local/include -I../innobase/include -I../innobase/include -I../include -I../include -I../regex -I. -I/opt/local/include  -I/opt/local/include  -DDBUG_OFF -O2   -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -MT sql_trigger.o -MD -MP -MF ".deps/sql_trigger.Tpo" -c -o sql_trigger.o sql_trigger.cc; \
then mv -f ".deps/sql_trigger.Tpo" ".deps/sql_trigger.Po"; else rm -f ".deps/sql_trigger.Tpo"; exit 1; fi
if /usr/bin/g++-4.0 -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/opt/local\"" -DDATADIR="\"/opt/local/var/db/mysql5\"" -DSHAREDIR="\"/opt/local/share/mysql5/mysql\"" -DHAVE_CONFIG_H -I. -I. -I.. -I/opt/local/include -I../innobase/include -I../innobase/include -I../include -I../include -I../regex -I. -I/opt/local/include  -I/opt/local/include  -DDBUG_OFF -O2   -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -MT ha_example.o -MD -MP -MF ".deps/ha_example.Tpo" -c -o ha_example.o `test -f 'examples/ha_example.cc' || echo './'`examples/ha_example.cc; \
then mv -f ".deps/ha_example.Tpo" ".deps/ha_example.Po"; else rm -f ".deps/ha_example.Tpo"; exit 1; fi
if /usr/bin/g++-4.0 -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/opt/local\"" -DDATADIR="\"/opt/local/var/db/mysql5\"" -DSHAREDIR="\"/opt/local/share/mysql5/mysql\"" -DHAVE_CONFIG_H -I. -I. -I.. -I/opt/local/include -I../innobase/include -I../innobase/include -I../include -I../include -I../regex -I. -I/opt/local/include  -I/opt/local/include  -DDBUG_OFF -O2   -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -MT ha_archive.o -MD -MP -MF ".deps/ha_archive.Tpo" -c -o ha_archive.o ha_archive.cc; \
then mv -f ".deps/ha_archive.Tpo" ".deps/ha_archive.Po"; else rm -f ".deps/ha_archive.Tpo"; exit 1; fi
if /usr/bin/g++-4.0 -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/opt/local\"" -DDATADIR="\"/opt/local/var/db/mysql5\"" -DSHAREDIR="\"/opt/local/share/mysql5/mysql\"" -DHAVE_CONFIG_H -I. -I. -I.. -I/opt/local/include -I../innobase/include -I../innobase/include -I../include -I../include -I../regex -I. -I/opt/local/include  -I/opt/local/include  -DDBUG_OFF -O2   -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -MT ha_tina.o -MD -MP -MF ".deps/ha_tina.Tpo" -c -o ha_tina.o `test -f 'examples/ha_tina.cc' || echo './'`examples/ha_tina.cc; \
then mv -f ".deps/ha_tina.Tpo" ".deps/ha_tina.Po"; else rm -f ".deps/ha_tina.Tpo"; exit 1; fi
if /usr/bin/g++-4.0 -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/opt/local\"" -DDATADIR="\"/opt/local/var/db/mysql5\"" -DSHAREDIR="\"/opt/local/share/mysql5/mysql\"" -DHAVE_CONFIG_H -I. -I. -I.. -I/opt/local/include -I../innobase/include -I../innobase/include -I../include -I../include -I../regex -I. -I/opt/local/include  -I/opt/local/include  -DDBUG_OFF -O2   -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -MT ha_blackhole.o -MD -MP -MF ".deps/ha_blackhole.Tpo" -c -o ha_blackhole.o ha_blackhole.cc; \
then mv -f ".deps/ha_blackhole.Tpo" ".deps/ha_blackhole.Po"; else rm -f ".deps/ha_blackhole.Tpo"; exit 1; fi
if /usr/bin/g++-4.0 -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/opt/local\"" -DDATADIR="\"/opt/local/var/db/mysql5\"" -DSHAREDIR="\"/opt/local/share/mysql5/mysql\"" -DHAVE_CONFIG_H -I. -I. -I.. -I/opt/local/include -I../innobase/include -I../innobase/include -I../include -I../include -I../regex -I. -I/opt/local/include  -I/opt/local/include  -DDBUG_OFF -O2   -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -MT ha_federated.o -MD -MP -MF ".deps/ha_federated.Tpo" -c -o ha_federated.o ha_federated.cc; \
then mv -f ".deps/ha_federated.Tpo" ".deps/ha_federated.Po"; else rm -f ".deps/ha_federated.Tpo"; exit 1; fi
/bin/sh ../libtool --preserve-dup-deps --tag=CXX --mode=link /usr/bin/g++-4.0  -DDBUG_OFF -O2   -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT  -L/opt/local/lib  -o mysqld  sql_lex.o sql_handler.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o item_subselect.o item_row.o item_geofunc.o field.o strfunc.o key.o sql_class.o sql_list.o net_serv.o protocol.o sql_state.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o set_var.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_prepare.o sql_error.o sql_locale.o sql_profile.o sql_update.o sql_delete.o uniques.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o des_key_file.o discover.o time.o opt_range.o opt_sum.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innodb.o ha_ndbcluster.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o sql_union.o sql_derived.o client.o sql_client.o mini_client_errors.o pack.o stacktrace.o repl_failsafe.o sql_olap.o sql_view.o gstream.o spatial.o sql_help.o sql_cursor.o tztime.o my_time.o my_user.o my_decimal.o sp_head.o sp_pcontext.o sp_rcontext.o sp.o sp_cache.o parse_file.o sql_trigger.o ha_example.o ha_archive.o ha_tina.o ha_blackhole.o ha_federated.o ../innobase/usr/libusr.a ../innobase/srv/libsrv.a ../innobase/dict/libdict.a ../innobase/que/libque.a ../innobase/srv/libsrv.a ../innobase/ibuf/libibuf.a ../innobase/row/librow.a ../innobase/pars/libpars.a ../innobase/btr/libbtr.a ../innobase/trx/libtrx.a ../innobase/read/libread.a ../innobase/usr/libusr.a ../innobase/buf/libbuf.a ../innobase/ibuf/libibuf.a ../innobase/eval/libeval.a ../innobase/log/liblog.a ../innobase/fsp/libfsp.a ../innobase/fut/libfut.a ../innobase/fil/libfil.a ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/libut.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../vio/libvio.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -L/opt/local/lib -lz     -ldl  -L/opt/local/lib -lssl -lcrypto -lm  
/usr/bin/g++-4.0 -DDBUG_OFF -O2 -fno-implicit-templates -fno-exceptions -fno-rtti -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -o mysqld sql_lex.o sql_handler.o item.o item_sum.o item_buff.o item_func.o item_cmpfunc.o item_strfunc.o item_timefunc.o thr_malloc.o item_create.o item_subselect.o item_row.o item_geofunc.o field.o strfunc.o key.o sql_class.o sql_list.o net_serv.o protocol.o sql_state.o lock.o my_lock.o sql_string.o sql_manager.o sql_map.o mysqld.o password.o hash_filo.o hostname.o set_var.o sql_parse.o sql_yacc.o sql_base.o table.o sql_select.o sql_insert.o sql_prepare.o sql_error.o sql_locale.o sql_profile.o sql_update.o sql_delete.o uniques.o sql_do.o procedure.o item_uniq.o sql_test.o log.o log_event.o init.o derror.o sql_acl.o unireg.o des_key_file.o discover.o time.o opt_range.o opt_sum.o records.o filesort.o handler.o ha_heap.o ha_myisam.o ha_myisammrg.o ha_berkeley.o ha_innodb.o ha_ndbcluster.o sql_db.o sql_table.o sql_rename.o sql_crypt.o sql_load.o mf_iocache.o field_conv.o sql_show.o sql_udf.o sql_analyse.o sql_cache.o slave.o sql_repl.o sql_union.o sql_derived.o client.o sql_client.o mini_client_errors.o pack.o stacktrace.o repl_failsafe.o sql_olap.o sql_view.o gstream.o spatial.o sql_help.o sql_cursor.o tztime.o my_time.o my_user.o my_decimal.o sp_head.o sp_pcontext.o sp_rcontext.o sp.o sp_cache.o parse_file.o sql_trigger.o ha_example.o ha_archive.o ha_tina.o ha_blackhole.o ha_federated.o -Wl,-bind_at_load  -L/opt/local/lib ../innobase/usr/libusr.a ../innobase/srv/libsrv.a ../innobase/dict/libdict.a ../innobase/que/libque.a ../innobase/srv/libsrv.a ../innobase/ibuf/libibuf.a ../innobase/row/librow.a ../innobase/pars/libpars.a ../innobase/btr/libbtr.a ../innobase/trx/libtrx.a ../innobase/read/libread.a ../innobase/usr/libusr.a ../innobase/buf/libbuf.a ../innobase/ibuf/libibuf.a ../innobase/eval/libeval.a ../innobase/log/liblog.a ../innobase/fsp/libfsp.a ../innobase/fut/libfut.a ../innobase/fil/libfil.a ../innobase/lock/liblock.a ../innobase/mtr/libmtr.a ../innobase/page/libpage.a ../innobase/rem/librem.a ../innobase/thr/libthr.a ../innobase/sync/libsync.a ../innobase/data/libdata.a ../innobase/mach/libmach.a ../innobase/ha/libha.a ../innobase/dyn/libdyn.a ../innobase/mem/libmem.a ../innobase/sync/libsync.a ../innobase/ut/libut.a ../innobase/os/libos.a ../innobase/ut/libut.a ../myisam/libmyisam.a ../myisammrg/libmyisammrg.a ../heap/libheap.a ../vio/libvio.a ../mysys/libmysys.a ../dbug/libdbug.a ../regex/libregex.a ../strings/libmystrings.a -lz -ldl -lssl -lcrypto -lm
/usr/bin/ld: warning can't open dynamic library: /opt/local/lib/libz.1.dylib referenced from: /opt/local/lib/libssl.dylib (checking for undefined symbols may be affected) (No such file or directory, errno = 2)
/usr/bin/ld: warning prebinding disabled because dependent library: /opt/local/lib/libz.1.dylib can't be searched
/usr/bin/ld: Undefined symbols:
_deflate referenced from libcrypto.0 expected to be defined in /opt/local/lib/libz.1.dylib
_deflateEnd referenced from libcrypto.0 expected to be defined in /opt/local/lib/libz.1.dylib
_deflateInit_ referenced from libcrypto.0 expected to be defined in /opt/local/lib/libz.1.dylib
_inflate referenced from libcrypto.0 expected to be defined in /opt/local/lib/libz.1.dylib
_inflateEnd referenced from libcrypto.0 expected to be defined in /opt/local/lib/libz.1.dylib
_inflateInit_ referenced from libcrypto.0 expected to be defined in /opt/local/lib/libz.1.dylib
collect2: ld returned 1 exit status
make[4]: *** [mysqld] Error 1
make[3]: *** [all-recursive] Error 1
make[2]: *** [all] Error 2
make[1]: *** [all-recursive] Error 1
make: *** [all] Error 2

Error: Status 1 encountered during processing.
lds-mac:~ ldeck$ 

[markd@…]

I can only say that it just installed on a fresh Intel Mac. I know that doesn't help much, but I don't have a PPC that I can use to check any further.

[ldeck]

I think somehow my zlib installation got corrupted when upgrading MacPorts from 1.4.x to 1.4.42 as I was unable to install other ports that depended on it. Doing a clean of openssl and zlib and then reinstalling seems to have resolved that problem.

[markd@…]

Thanks for the feedback. Closing.