Install problems with DBD::mysql on 64-bit Mac

Debra

I'm come across the same problem although I'm using ActivePerl 5.8.8 version of Perl on my MacBook Pro running Leopard. I had used PPM that comes with that Perl to install my missing modules, and was offered the 3.008 version of DBD::mysql, which gave me a similar error. I was just about to post something about this on the ActivePerl mailing list when I came across the following at KNOWN PROBLEMS:

"There are known problems with shared versions of libmysqlclient, at least on some Linux boxes. If you receive an error message similar to install_driver(mysql) failed: Can't load '/usr/lib/perl5/site_perl/i586-linux/auto/DBD/mysql/mysql.so' for module DBD::mysql: File not found at /usr/lib/perl5/i586-linux/5.00404/DynaLoader.pm line 166<br><br> then this error message can be misleading: It's not mysql.so that fails being loaded, but libmysqlclient.so! The usual problem is that this file is located in a directory like /usr/lib/mysql where the linker doesn't look for it. The best workaround is using a statically linked mysqlclient library, for example /usr/lib/mysql/libmysqlclient.a You force linking against this file by replacing -L/usr/lib/mysql -lmysqlclient with /usr/lib/mysql/libmysqlclient.a in the list of linker flags. <A HREF="http://aspn.activestate.com/ASPN/CodeDoc/DBD-mysql/DBD/mysql/ +INSTALL.html#Configuration">/Configuration</A>. <A HREF="http://aspn.activestate.com/ASPN/CodeDoc/ +DBD-mysql/DBD/mysql/INSTALL.html#Linker%20flags">/Linker flags</A>."

Although this was for DBD::mysql v2.1004 and the error message is not quite the same as the ones you and I are getting I wonder if perhaps this is our problem. I've not yet checked up on this yet. I'm very new to the Mac having just started to use this recently having used Windows up until now so it will take me a bit longer to try this solution out. I'll be very interested to learn if you think this might be the answer, and if so whether it worked when you tried it. Eric Robertson