I wanted to build an awesome place for people to discuss module specific issues, but I don't have any more time for this, and there are much better places to discuss Perl-related issues. I'd recommend asking your question on Stack Overflow or on Perl Monks.
If you are looking for a Perl tutorial or Perl-related news, I hope these links will serve you well.
Posted on 2009-11-21 00:17:19-08 by gmburton
Trouble installing DBD::mysql on Mac OS X 10.6
Trying to get my website scripts up and running on my new mac. From my searching, I've seen that the 64-bit version of mysql is a problem with the perl modules, and I have confirmed that I definitely have the 32 bit version. I'm really at a loss here, any help would be greatly appreciated. Here is a copy of the make test install log. PERL_DL_NONLAZY=1 /usr/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/00base.t line 21. # Tried to use 'DBD::mysql'. # Error: Can't load '/Users/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _is_prefix # Referenced from: /Users/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/DBD/mysql/mysql.bundle # Expected in: flat namespace # in /Users/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/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: Unable to load DBD::mysql make: *** [test_dynamic] Error 9 If I make install anyway and try to run a script, the following appears in my apache error log: [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] dyld: lazy symbol binding failed: Symbol not found: _mysql_init [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Expected in: flat namespace [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] dyld: Symbol not found: _mysql_init [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Referenced from: /Library/Perl/5.10.0/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Expected in: flat namespace
Direct Responses: 11792 | Write a response
Posted on 2009-11-21 00:20:56-08 by gmburton in response to 11791
Re: Trouble installing DBD::mysql on Mac OS X 10.6
Fixing my line breaks so it is readable :(

Trying to get my website scripts up and running on my new mac. From my searching, I've seen that the 64-bit version of mysql is a problem with the perl modules, and I have confirmed that I definitely have the 32 bit version. I'm really at a loss here, any help would be greatly appreciated. Here is a copy of the make test install log.
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/a +rch')" 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/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/DBD/mysql/mysql.bu +ndle' for module DBD::mysql: dlopen(/Users/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/DBD/mys +ql/mysql.bundle, 2): Symbol not found: _is_prefix # Referenced from: /Users/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/DBD/mysql/mysql.bundle # Expected in: flat namespace # in /Users/burton/Downloads/DBD-mysql-4.013/blib/arch/auto/DBD/mysql/mysql.bundle at /System/Libr +ary/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: Unable to load DBD::mysql make: *** [test_dynamic] Error 9

If I make install anyway and try to run a script, the following appears in my apache error log:
[Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] dyld: lazy symbol binding failed: Symbol not +found: _mysql_init [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Referenced from: /Library/Perl/5.10.0/darwi +n-thread-multi-2level/auto/DBD/mysql/mysql.bundle [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Expected in: flat namespace [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] dyld: Symbol not found: _mysql_init [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Referenced from: /Library/Perl/5.10.0/darwi +n-thread-multi-2level/auto/DBD/mysql/mysql.bundle [Fri Nov 20 19:46:09 2009] [error] [client 127.0.0.1] Expected in: flat namespace
Direct Responses: 12051 | Write a response
Posted on 2009-12-31 05:37:58-08 by climber in response to 11792
Re: Trouble installing DBD::mysql on Mac OS X 10.6
Were you able to resolve this problem ultimately? I seem to have the exact error message currently. Thanks in advance for any advice. Best, Ed
Direct Responses: 12095 | 12132 | Write a response
Posted on 2010-01-04 17:45:04-08 by drb in response to 12051
Re: Trouble installing DBD::mysql on Mac OS X 10.6
Hi, Ed: The problem was caused by the different architectures for perl (32-bit) and MySQL(64-bit). Leopard only had 32-bit perl and most of the modules I wanted were also only in 32-bit. Since installing a new perl was strongly discouraged in the perl MacOSX manual, I uninstalled the 64-bit MySQL and installed a 32-bit MySQL. I was able to get DBD::mysql to work by installing the fink version of DBD::mysql v. 4.005-11. There is a problem with MySQL v 5.0.41 for Leopard. MySQL looks for its libraries at /usr/local/mysql/lib/mysql/ when they really are in /usr/local/mysql/lib. The best workaround I found is to go to /usr/local/mysql/lib, create a mysql directory (sudo mkdir mysql) and then make a soft link to all the files in /usr/local/mysql/lib (sudo ln -s /usr/local/mysql/lib/lib* ../mysql). Also, when I uninstalled DBD::mysql, it took parts of Mysql perlmod with it so I had to reinstall Mysql perlmod with CPANPLUS. The real pain is that my other programs (mostly numerical models) are all 64-bit so I have to change my paths in cshcrs when I want to run the program using the perl modules and reinitialize UNIX. I also had to load a 32-bit netCDF and other stuff too. I don't know if these same problems arise in Snow Leopard but I am upgrading so I'm about to find out!I may just go with 32-bit for everything this time. Deb
Direct Responses: Write a response
Posted on 2010-01-07 01:25:25-08 by davidhmco2 in response to 12051
Re: Trouble installing DBD::mysql on Mac OS X 10.6
With 10.6 it seems they included an 64 bit Perl, and therefore it wouldn't work with the 32 bit MySQL. Once I removed the 32 bit MySQL and installed the 64 bit version it installed perfectly.
Direct Responses: Write a response