dyld: lazy symbol binding failed (was MAC OS 10.6 upgrade breaks DBD:mysql)

[finhagen]

I did some additional research and I believe the source of the problems above is a 64 bit MySQL database and 32 bit Perl - at least in the past I recall having to deinstall the 64 bit mysql program and install the 23 bit version for DBD to work. The fact that Perl 5.10 is supposed to support 64 bit now muddies those waters but, nevertheless, I did perform the 32 bit reinstall. I also was able to get DBD:mysql to compile properly. However, I am still getting errors when I run my script:

finhagens-macbook-pro:perl finhagen$ ./tme_ext_full.pl 
dyld: lazy symbol binding failed: Symbol not found: _mysql_init
  Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/aut
+o/DBD/mysql/mysql.bundle
  Expected in: flat namespace

dyld: Symbol not found: _mysql_init
  Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/aut
+o/DBD/mysql/mysql.bundle
  Expected in: flat namespace

Trace/BPT trap

I googled this error but I didn't find any references that explained how to fix this problem. Any suggestions?

Hagen

I recently upgraded my MAC OS to the latest Snow Leopard 10.6 release. Among other things it broke DBD:mysql. I tried reinstalling perl 5.10 and the DBD::mysql module using CPAN. When I try to install DBD::mysql I get the following error:

cpan[10]> install DBD:mysql
Running install for module 'DBD::mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz
  Has already been unwrapped into directory /Users/finhagen/.cpan/buil
+d/DBD-mysql-4.012-TzlSls
  Has already been made
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_h
+arness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base....................ok 1/6                                    
+       
#   Failed test 'use DBD::mysql;'
#   at t/00base.t line 21.
#     Tried to use 'DBD::mysql'.
#     Error:  Can't load '/Users/finhagen/.cpan/build/DBD-mysql-4.012-
+TzlSls/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: 
+dlopen(/Users/finhagen/.cpan/build/DBD-mysql-4.012-TzlSls/blib/arch/a
+uto/DBD/mysql/mysql.bundle, 2): Symbol not found: _is_prefix
#   Referenced from: /Users/finhagen/.cpan/build/DBD-mysql-4.012-TzlSl
+s/blib/arch/auto/DBD/mysql/mysql.bundle
#   Expected in: flat namespace
#  in /Users/finhagen/.cpan/build/DBD-mysql-4.012-TzlSls/blib/arch/aut
+o/DBD/mysql/mysql.bundle at /System/Library/Perl/5.10.0/darwin-thread
+-multi-2level/DynaLoader.pm line 207.
#  at (eval 6) line 2
# Compilation failed in require at (eval 6) line 2.
# BEGIN failed--compilation aborted at t/00base.t line 21.
t/00base....................NOK 2/6FAILED--Further testing stopped: Un
+able to load DBD::mysql
make: *** [test_dynamic] Error 9
  CAPTTOFU/DBD-mysql-4.012.tar.gz
  /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, t
+ry:
  reports CAPTTOFU/DBD-mysql-4.012.tar.gz
Running make install
  make test had returned bad status, won't install without force
Failed during this command:
 CAPTTOFU/DBD-mysql-4.012.tar.gz              : make_test NO

When I try and run the script that calls the DBD module I get this error:

finhagens-macbook-pro:perl finhagen$ ./tme_ext_full.pl 
Can't locate DBD/mysql.pm in @INC (@INC contains: /Library/Perl/Update
+s/5.10.0/darwin-thread-multi-2level /Library/Perl/Updates/5.10.0 /Sys
+tem/Library/Perl/5.10.0/darwin-thread-multi-2level /System/Library/Pe
+rl/5.10.0 /Library/Perl/5.10.0/darwin-thread-multi-2level /Library/Pe
+rl/5.10.0 /Network/Library/Perl/5.10.0/darwin-thread-multi-2level /Ne
+twork/Library/Perl/5.10.0 /Network/Library/Perl /System/Library/Perl/
+Extras/5.10.0/darwin-thread-multi-2level /System/Library/Perl/Extras/
+5.10.0 .) at ./tme_ext_full.pl line 31.
BEGIN failed--compilation aborted at ./tme_ext_full.pl line 31.

I seem to recall an issue like this in the past but I can't remember what I did to address it. Any help would be greatly appreciated. Thanks!