DBD::mysql problem WITH universal Perl bin (x86_64 & i386) and MySQL i386

Posted on 2010-04-18 16:59:38.133751-07 by jmb

Uggh... the dreaded DBD-mysql plugin problem. First, about my system:

Mac OS X 10.6.3

Architectures:

$ which perl /opt/local/bin/perl $ file /opt/local/bin/perl /opt/local/bin/perl: Mach-O universal binary with 2 architectures /opt/local/bin/perl (for architec +ture x86_64): Mach-O 64-bit executable x86_64 /opt/local/bin/perl (for architecture i386): Mach-O +executable i386 $ which mysql /usr/local/mysql/bin/mysql $ file /usr/local/mysql/bin/mysql /usr/local/mysql/bin/mysql: Mach-O executable i386

MySQL and PERL run just fine. DBI works just fine. Here is the output after running intro2.pl from DuBois "MySQL and Perl for the Web"

intro2.pl:

#! /usr/bin/perl #intro2.pl - verify availability of CGI.pm and DBI modules use CGI; use DBI; $cgi = new CGI; print "The CGI object was created successfully\n"; @driver_names = DBI->available_d +rivers (); print "These DBI drivers are available: @driver_names\n"; exit (0);

After running the program:

$ ./intro2.pl The CGI object was created successfully These DBI drivers are available: DBM ExampleP + File Gofer Proxy SQLite Sponge

In the DBD::mysql dir:

DBD-mysql-4.014$ perl Makefile.pl --testuser='root' --testpassword='secret'

Finally, after running....

DBD-mysql-4.014$ make test PERL_DL_NONLAZY=1 /opt/local/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', ' +blib/arch')" t/*.t t/00base....................ok 1/6 # Failed test 'use DBD::mysql;' # at t/00bas +e.t line 21. # Tried to use 'DBD::mysql'. # Error: Can't load '/Users/james/Downloads/DBD-mysql-4. +014/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/james/Downloads/DB +D-mysql-4.014/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _is_prefix # Referenced + from: /Users/james/Downloads/DBD-mysql-4.014/blib/arch/auto/DBD/mysql/mysql.bundle # Expected in: + dynamic lookup # at (eval 5) line 2 # Compilation failed in require at (eval 5) line 2. # BEGIN f +ailed--compilation aborted at (eval 5) line 2. t/00base....................NOK 2/6FAILED--Further +testing stopped: Unable to load DBD::mysql make: *** [test_dynamic] Error 255

...I get the above output. I did try to make sure that mysql knew where to look for its libraries:

$ sudo ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql $ sudo ln -s /usr/local/mysql/include /usr/local/mysql/include/mysql

... not that I think that has ANYTHING to do with this fail.

I would appreciate any assistance and positive feedback... or even just a link where this specific issue is addressed. So far.. everything that I have read seems to be with respect to having MySQL compiled for x86_64 but this does not seem to be my issue. Regardless, my Perl is a universal library. I have had 0 problems installing other perl modules or using them. Thanks!

Direct Responses: 12650 | 12651 | Write a response

Posted on 2010-04-19 11:27:02.28161-07 by jmb in response to 12646

Re: DBD::mysql problem WITH universal Perl bin (x86_64 & i386) and MySQL i386

Fixed this issue. Apparently, the dual x86_64 / i386 Perl bin does not like to talk to the MySQL i386 bin. Following the instructions here, I installed the 64-bit x86 MySQL server using the .dmg available at the MySQL website.

make test works perfectly now. thanks for everybody's help!

Direct Responses: Write a response

Posted on 2010-04-19 11:28:33.805144-07 by jmb in response to 12646

Re: DBD::mysql problem WITH universal Perl bin (x86_64 & i386) and MySQL i386

make test works perfectly now. Thanks to everyone who responded!

Direct Responses: Write a response