macosx  

Can't Install DBD:::mysql

Lola J. Lee Beno
Fri, 24 Jul 2009 08:45:33 -0700

Running 10.5.7 on MacBookPro; standard Apple Perl install. I got this following error messages when I tried to install DBD::mysql. How to get this to work? 


perl Makefile.pl --testuser=username

I will use the following settings for compiling and testing:
cflags (mysql_config) = -I/usr/local/mysql/include -g -Os -arch x86_64 -fno-common -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL 
 embedded      (mysql_config) =
libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient -lz -lm -lmygcc 
 mysql_config  (guessed     ) = mysql_config
 nocatchstderr (default     ) = 0
 nofoundrows   (default     ) = 0
 ssl           (guessed     ) = 0
 testdb        (default     ) = test
 testhost      (default     ) =
 testpassword  (default     ) =
 testsocket    (default     ) =
 testuser      (guessed     ) = root

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Checking if your kit is complete...
Looks good
Multiple copies of Driver.xst found in: /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/ /System/Library/Perl/Extras/5.8.8/darwin-thread-multi-2level/auto/DBI/ at Makefile.PL line 902 Using DBI 1.609 (for perl 5.008008 on darwin-thread-multi-2level) installed in /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/ 
Writing Makefile for DBD::mysql
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cc -c -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI -I/usr/local/mysql/include -g -Os -arch x86_64 -fno-common -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch ppc -arch i386 -g -pipe -fno-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -Wdeclaration-after-statement -I/usr/local/include -O3 -DVERSION=\"4.012\" -DXS_VERSION=\"4.012\" "-I/System/Library/Perl/5.8.8/darwin-thread-multi-2level/CORE" dbdimp.c 
dbdimp.c: In function 'alloc_param':
dbdimp.c:113: warning: comparison is always false due to limited range of data type 
dbdimp.c: In function 'alloc_bind':
dbdimp.c:131: warning: comparison is always false due to limited range of data type 
dbdimp.c: In function 'alloc_fbind':
dbdimp.c:147: warning: comparison is always false due to limited range of data type 
dbdimp.c: In function 'alloc_fbuffer':
dbdimp.c:162: warning: comparison is always false due to limited range of data type 
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3309: warning: assignment from incompatible pointer type
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3309: warning: assignment from incompatible pointer type
dbdimp.c: In function 'mysql_describe':
dbdimp.c:3309: warning: assignment from incompatible pointer type
/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/Driver.xst > mysql.xsi /usr/bin/perl /System/Library/Perl/5.8.8/ExtUtils/xsubpp -typemap /System/Library/Perl/5.8.8/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c 
Warning: duplicate function definition 'do' detected in mysql.xs, line 225
Warning: duplicate function definition 'rows' detected in mysql.xs, line 650
cc -c -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI -I/usr/local/mysql/include -g -Os -arch x86_64 -fno-common -D_P1003_1B_VISIBLE -DSIGNAL_WITH_VIO_CLOSE -DSIGNALS_DONT_BREAK_READ -DIGNORE_SIGHUP_SIGQUIT -DDONT_DECLARE_CXA_PURE_VIRTUAL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch ppc -arch i386 -g -pipe -fno-common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing -Wdeclaration-after-statement -I/usr/local/include -O3 -DVERSION=\"4.012\" -DXS_VERSION=\"4.012\" "-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:330: warning: comparison is always false due to limited range of data type mysql.xs:331: warning: comparison is always false due to limited range of data type 
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.bundle
LD_RUN_PATH="/usr/local/mysql/lib" /usr/bin/perl myld cc -mmacosx-version-min=10.5.6 -arch ppc -arch i386 -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.bundle \ 
      -L/usr/local/mysql/lib -lmysqlclient -lz -lm -lmygcc      \
chmod 755 blib/arch/auto/DBD/mysql/mysql.bundle 
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
Manifying blib/man3/DBD::mysql.3pm
Manifying blib/man3/DBD::mysql::INSTALL.3pm
Manifying blib/man3/Bundle::DBD::mysql.3pm
 CAPTTOFU/DBD-mysql-4.012.tar.gz
 /usr/bin/make -- OK
Running make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/00base.t .................. 2/6 Bailout called. Further testing stopped: Unable to load DBD::mysql 

#   Failed test 'use DBD::mysql;'
#   at t/00base.t line 21.
#     Tried to use 'DBD::mysql'.
# Error: Can't load '/Users/lolajl/.cpan/build/DBD-mysql-4.012-UiqDpa/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/lolajl/.cpan/build/DBD-mysql-4.012-UiqDpa/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _is_prefix # Referenced from: /Users/lolajl/.cpan/build/DBD-mysql-4.012-UiqDpa/blib/arch/auto/DBD/mysql/mysql.bundle 
#   Expected in: dynamic lookup
#  at (eval 7) line 2
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
FAILED--Further testing stopped: Unable to load DBD::mysql
make: *** [test_dynamic] Error 255
 CAPTTOFU/DBD-mysql-4.012.tar.gz
 /usr/bin/make test -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
 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
cpan[7]> reports CAPTTOFU/DBD-mysql-4.012.tar.gz 
Distribution: C/CA/CAPTTOFU/DBD-mysql-4.012.tar.gz
CPAN::DistnameInfo not installed; cannot continue
cpan[8]> install DBD::mysql 
--
Lola J. Lee Beno LinkedIn: http://www.linkedin.com/in/lolajleebeno 
Facebook: http://www.facebook.com/profile.php?id=714355583
Blog: http://www.lolajl.net/blog/
  • Can't Install DBD:::mysql Lola J. Lee Beno