Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

DBD::mysql trouble

by PerlPeer (Novice)
on Jan 10, 2013 at 08:51 UTC ( #1012613=perlquestion: print w/replies, xml ) Need Help??
PerlPeer has asked for the wisdom of the Perl Monks concerning the following question:

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 +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 +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/ blib/lib/DBD/ cp lib/DBD/mysql/ blib/lib/DBD/mysql/ cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Bundle/DBD/ blib/lib/Bundle/DBD/ 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 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 blib/arch/auto/DBD/mysql/ chmod 644 blib/arch/auto/DBD/mysql/ 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?

Replies are listed 'Best First'.
Re: DBD::mysql trouble
by Anonymous Monk on Jan 10, 2013 at 09:11 UTC
      Hi, your links let me to several other pages, all together I managed to run make, make test and make install for DBD::mysql

      The most important information was found in:

      Ps. bury me when I give up..........
      Giving up is not an option (for now at least).
      There should be a way to run this analysis.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1012613]
Approved by vinoth.ree
[LanX]: hm just read an article on claiming that RPerl is 250 times faster. ... it's that even possible?

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (8)
As of 2017-05-22 20:08 GMT
Find Nodes?
    Voting Booth?