Mac Forum / Programming / Perl / January 2008

Good afternoon,

I'm having trouble installing DBD::mysql on OS X Leopard, and I
can't get any answers from Google that help.

I've got a fresh Leopard install so there shouldn't be any
legacy issues. I've tried compiling DBD::mysql against package
version of mySQL
(mysql-max-4.1.22-apple-darwin8.6.0-powerpc-64bit) as well as
against mySQL compiled from source. I was getting errors caused
by architecture mis-match which I fixed by setting
ARCHFLAGS='-arch i386 -arch ppc -arch ppc64 -arch x86_64' before
running perl Makefile.PL. I also tried setting it as
ARCHFLAGS='-arch ppc64'.

I get a few warnings during make, such as:

cc -c  -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI
-arch i386 -arch ppc -arch ppc64 -arch x86_64
-I/usr/local/mysql/include -Os -fno-common
-DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -arch i386 -arch ppc -arch
ppc64 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN
-no-cpp-precomp -fno-strict-aliasing
-Wdeclaration-after-statement -I/usr/local/include -O3  
-DVERSION=\"4.006\" -DXS_VERSION=\"4.006\"  
"-I/System/Library/Perl/5.8.8/darwin-thread-multi-2level/CORE"   dbdimp.c
dbdimp.c: In function ‘alloc_param’:
dbdimp.c:112: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘alloc_bind’:
dbdimp.c:130: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘alloc_fbind’:
dbdimp.c:146: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘alloc_fbuffer’:
dbdimp.c:161: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘mysql_describe’:
dbdimp.c:3252: warning: assignment from incompatible pointer type
dbdimp.c: In function ‘mysql_describe’:
dbdimp.c:3252: warning: assignment from incompatible pointer type
dbdimp.c: In function ‘alloc_param’:
dbdimp.c:112: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘alloc_bind’:
dbdimp.c:130: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘alloc_fbind’:
dbdimp.c:146: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘alloc_fbuffer’:
dbdimp.c:161: warning: comparison is always false due to limited
range of data type
dbdimp.c: In function ‘mysql_describe’:
dbdimp.c:3252: warning: assignment from incompatible pointer type
dbdimp.c: In function ‘mysql_describe’:
dbdimp.c:3252: warning: assignment from incompatible pointer type
cc -c  -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI
-arch i386 -arch ppc -arch ppc64 -arch x86_64
-I/usr/local/mysql/include -Os -fno-common
-DDBD_MYSQL_INSERT_ID_IS_GOOD -g  -arch i386 -arch ppc -arch
ppc64 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN
-no-cpp-precomp -fno-strict-aliasing
-Wdeclaration-after-statement -I/usr/local/include -O3  
-DVERSION=\"4.006\" -DXS_VERSION=\"4.006\"  
"-I/System/Library/Perl/5.8.8/darwin-thread-multi-2level/CORE"   mysql.c
mysql.xs: In function ‘XS_DBD__mysql__db_do’:
mysql.xs:315: warning: comparison is always false due to limited
range of data type
mysql.xs:316: warning: comparison is always false due to limited
range of data type
mysql.xs: In function ‘XS_DBD__mysql__db_do’:
mysql.xs:315: warning: comparison is always false due to limited
range of data type
mysql.xs:316: warning: comparison is always false due to limited
range of data type

I think those are just warnings though and not related the
problems I'm having.

The show-stopper is the make test stage when I get errors such as:

PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00base................1/5 install_driver(mysql) failed: Can't
load
'/Users/charlie/.cpan/build/DBD-mysql-4.006-Pcd0BT/blib/arch/auto/DBD/mysql/mysql.bundle'
for module DBD::mysql:
dlopen(/Users/charlie/.cpan/build/DBD-mysql-4.006-Pcd0BT/blib/arch/auto/DBD/mysql/mysql.bundle,
2): Symbol not found: _is_prefix
  Referenced from: /Users/charlie/.cpan/build/DBD-mysql-4.006-Pcd0BT/blib/arch/auto/DBD/mysql/mysql.bundle
  Expected in: dynamic lookup
 at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
 at t/00base.t line 38
t/00base................ Dubious, test returned 2 (wstat 512, 0x200)
 Failed 2/5 subtests

I am wanting to go with 64-bit installs of perl modules based on
comments I've read about compatibility issues with the default
32-bit module installs and the 64-bit apache (& mod_perl) that
comes with Leopard. I'm happy to roll my own
perl/mod_perl/apache if needed. But I'd prefer to use the OS
versions if possible.

Suggestions on getting a successful install of DBD::mysql on
Leopard would be much appreciated.

Thanks,
Charlie