Hi,
I am trying to install DBD::mysql (needed for MySQL in combination with OrthoMCL)
I installed a new verison of perl (5.16.2) via perlbrew and gor the cpanminus program working (previous topic).
Then I installed MySQL with .dmg package drive for Mac os x and set the paswords for the accounts according to documentation.
My problem now is: DBD::mysql keeps giving error.
This is what happens:
miya-saiko-no-iMac:mysql arend$ cpanm DBD::mysql
--> Working on DBD::mysql
Fetching http://www.cpan.org/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.022.
+tar.gz ... OK
Configuring DBD-mysql-4.022 ... OK
Building and testing DBD-mysql-4.022 ... FAIL
! Installing DBD::mysql failed. See /Users/arend/.cpanm/build.log for
+details.
The build.log contains:
miya-saiko-no-iMac:mysql arend$ cat /Users/arend/.cpanm/build.log
cpanm (App::cpanminus) 1.5019 on perl 5.016002 built for darwin-2level
Work directory is /Users/arend/.cpanm/work/1357807456.2696
You have make /usr/bin/make
You have LWP 6.04
You have /usr/bin/tar: bsdtar 2.6.2 - libarchive 2.6.2
You have /usr/bin/unzip
Searching DBD::mysql on cpanmetadb ...
--> Working on DBD::mysql
Fetching http://www.cpan.org/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.022.
+tar.gz
-> OK
Unpacking DBD-mysql-4.022.tar.gz
Entering DBD-mysql-4.022
Checking configure dependencies from META.yml
Checking if you have DBI 1.08 ... Yes (1.623)
Configuring DBD-mysql-4.022
Running Makefile.PL
PLEASE NOTE:
For 'make test' to run properly, you must ensure that the
database user 'arend' can connect to your MySQL server
and has the proper privileges that these tests require such
as 'drop table', 'create table', 'drop procedure', 'create procedure'
as well as others.
mysql> grant all privileges on test.* to 'arend'@'localhost' identifie
+d by 's3kr1t';
You can also optionally set the user to run 'make test' with:
perl Makefile.PL --testuser=username
I will use the following settings for compiling and testing:
cflags (mysql_config) = -I/usr/local/mysql/include -Os -g -f
+no-common -fno-strict-aliasing -arch x86_64
embedded (mysql_config) =
ldflags (mysql_config) =
libs (mysql_config) = -L/usr/local/mysql/lib -lmysqlclient
+-lpthread
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 ) = arend
To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.
Checking if your kit is complete...
Looks good
Using DBI 1.623 (for perl 5.016002 on darwin-2level) installed in /Use
+rs/arend/perl5/perlbrew/perls/perl-5.16.2/lib/site_perl/5.16.2/darwin
+-2level/auto/DBI/
Writing Makefile for DBD::mysql
Writing MYMETA.yml and MYMETA.json
-> OK
Checking dependencies from MYMETA.json ...
Checking if you have Test::More 0 ... Yes (0.98)
Checking if you have Data::Dumper 0 ... Yes (2.135_06)
Checking if you have DBI 1.08 ... Yes (1.623)
Building and testing DBD-mysql-4.022
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/Users/arend/perl5/perlbrew/perls/perl-5.16.2/lib/site_perl/5
+.16.2/darwin-2level/auto/DBI -I/usr/local/mysql/include -Os -g -fno-
+common -fno-strict-aliasing -arch x86_64 -DDBD_MYSQL_INSERT_ID_IS_GOO
+D -g -fno-common -DPERL_DARWIN -fno-strict-aliasing -pipe -fstack-pr
+otector -I/usr/local/include -O3 -DVERSION=\"4.022\" -DXS_VERSION=\
+"4.022\" "-I/Users/arend/perl5/perlbrew/perls/perl-5.16.2/lib/5.16.2
+/darwin-2level/CORE" dbdimp.c
dbdimp.c: In function ‘mysql_describe’:
dbdimp.c:3617: warning: assignment from incompatible pointer type
/Users/arend/perl5/perlbrew/perls/perl-5.16.2/bin/perl -p -e "s/~DRIVE
+R~/mysql/g" /Users/arend/perl5/perlbrew/perls/perl-5.16.2/lib/site_pe
+rl/5.16.2/darwin-2level/auto/DBI/Driver.xst > mysql.xsi
/Users/arend/perl5/perlbrew/perls/perl-5.16.2/bin/perl /Users/arend/pe
+rl5/perlbrew/perls/perl-5.16.2/lib/5.16.2/ExtUtils/xsubpp -typemap /
+Users/arend/perl5/perlbrew/perls/perl-5.16.2/lib/5.16.2/ExtUtils/type
+map mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line
+ 242
Warning: duplicate function definition 'rows' detected in mysql.xs, li
+ne 752
cc -c -I/Users/arend/perl5/perlbrew/perls/perl-5.16.2/lib/site_perl/5
+.16.2/darwin-2level/auto/DBI -I/usr/local/mysql/include -Os -g -fno-
+common -fno-strict-aliasing -arch x86_64 -DDBD_MYSQL_INSERT_ID_IS_GOO
+D -g -fno-common -DPERL_DARWIN -fno-strict-aliasing -pipe -fstack-pr
+otector -I/usr/local/include -O3 -DVERSION=\"4.022\" -DXS_VERSION=\
+"4.022\" "-I/Users/arend/perl5/perlbrew/perls/perl-5.16.2/lib/5.16.2
+/darwin-2level/CORE" mysql.c
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/lib" /Users/arend/perl5/perlbre
+w/perls/perl-5.16.2/bin/perl myld env MACOSX_DEPLOYMENT_TARGET=10.3 c
+c -bundle -undefined dynamic_lookup -L/usr/local/lib -fstack-protect
+or dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.bundle \
-L/usr/local/mysql/lib -lmysqlclient -lpthread \
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.3
Manifying blib/man3/DBD::mysql::INSTALL.3
Manifying blib/man3/Bundle::DBD::mysql.3
PERL_DL_NONLAZY=1 /Users/arend/perl5/perlbrew/perls/perl-5.16.2/bin/pe
+rl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/
+arch')" t/*.t
# Failed test 'use DBD::mysql;'
# at t/00base.t line 21.
# Tried to use 'DBD::mysql'.
# Error: Can't find 'boot_DBD__mysql' symbol in /Users/arend/.cpa
+nm/work/1357807456.2696/DBD-mysql-4.022/blib/arch/auto/DBD/mysql/mysq
+l.bundle
# at (eval 7) line 2.
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
Bailout called. Further testing stopped: Unable to load DBD::mysql
FAILED--Further testing stopped: Unable to load DBD::mysql
make: *** [test_dynamic] Error 255
-> FAIL Installing DBD::mysql failed. See /Users/arend/.cpanm/build.lo
+g for details.
I am not familiar with all this, in fact the whole process already took 3 days. Anybody with advice?