mabossert has asked for the wisdom of the Perl Monks concerning the following question:

All, I have been trying to get DBD::mysql installed and have not been able to get the tests to pass even after trying several workarounds noted in the documentation and other posts...Here is my output...can anyone see something I am obviously doing wrong?

*bossert@$#$#$#$#$# DBD-mysql-4.026 $ perl Makefile.PL --testuser=test + --testpassword=password --libs="-L/tmp/mysql-static -lmysqlclient" - +-cflags -I/usr/include/mysql<br> I will use the following settings for compiling and testing:<br> cflags (User's choice) = -I/usr/include/mysql<br> embedded (mysql_config ) = <br> libs (User's choice) = -L/tmp/mysql-static -lmysqlclient<br +> mysql_config (guessed ) = mysql_config<br> nocatchstderr (default ) = 0<br> nofoundrows (default ) = 0<br> ssl (guessed ) = 0<br> testdb (default ) = test<br> testhost (default ) = <br> testpassword (User's choice) = password<br> testport (default ) = <br> testsocket (default ) = <br> testuser (User's choice) = test<br> To change these settings, see 'perl Makefile.PL --help' and 'perldoc DBD::mysql::INSTALL'.<br> Checking if your kit is complete...<br> Warning: the following files are missing in your kit:<br> META.json<br> Please inform the author.<br> Using DBI 1.631 (for perl 5.016003 on x86_64-linux-thread-multi-ld) in +stalled in /tempssd/bossert/perl/lib/site_perl/5.16.3/x86_64-linux-th +read-multi-ld/auto/DBI/<br> Generating a Unix-style Makefile<br> Writing Makefile for DBD::mysql<br> Writing MYMETA.yml and MYMETA.json<br> *bossert@$#$#$#$#$ DBD-mysql-4.026 $ make<br> cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm<br> cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm<br> cp README.pod blib/lib/DBD/README.pod<br> cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod<br> cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm<br> Running Mkbootstrap for DBD::mysql ()<br> chmod 644 mysql.bs<br> cc -c -I/tempssd/bossert/perl/lib/site_perl/5.16.3/x86_64-linux-threa +d-multi-ld/auto/DBI -I/usr/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOO +D -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-p +rotector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS +=64 -O2 -DVERSION=\"4.026\" -DXS_VERSION=\"4.026\" -fPIC "-I/tempss +d/bossert/perl/lib/5.16.3/x86_64-linux-thread-multi-ld/CORE" dbdimp +.c<br> dbdimp.c: In function ‘mysql_describe’:<br> dbdimp.c:3676: warning: assignment from incompatible pointer type<br> /tempssd/bossert/perl/bin/perl -p -e "s/~DRIVER~/mysql/g" /tempssd/bos +sert/perl/lib/site_perl/5.16.3/x86_64-linux-thread-multi-ld/auto/DBI/ +Driver.xst > mysql.xsi<br> /tempssd/bossert/perl/bin/perl /tempssd/bossert/perl/lib/site_perl/5.1 +6.3/ExtUtils/xsubpp -typemap /tempssd/bossert/perl/lib/5.16.3/ExtUti +ls/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c<br> Warning: duplicate function definition 'do' detected in mysql.xs, line + 242<br> Warning: duplicate function definition 'rows' detected in mysql.xs, li +ne 754<br> cc -c -I/tempssd/bossert/perl/lib/site_perl/5.16.3/x86_64-linux-threa +d-multi-ld/auto/DBI -I/usr/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOO +D -g -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-p +rotector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS +=64 -O2 -DVERSION=\"4.026\" -DXS_VERSION=\"4.026\" -fPIC "-I/tempss +d/bossert/perl/lib/5.16.3/x86_64-linux-thread-multi-ld/CORE" mysql. +c<br> rm -f blib/arch/auto/DBD/mysql/mysql.so<br> /tempssd/bossert/perl/bin/perl myld cc -shared -O2 -L/usr/local/lib - +fstack-protector dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql. +so <br> -L/tmp/mysql-static -lmysqlclient \<br> chmod 755 blib/arch/auto/DBD/mysql/mysql.so<br> /tempssd/bossert/perl/bin/perl -MExtUtils::Command::MM -e 'cp_nonempty +' -- mysql.bs blib/arch/auto/DBD/mysql/mysql.bs 644<br> Manifying blib/man3/DBD::README.3<br> Manifying blib/man3/Bundle::DBD::mysql.3<br> Manifying blib/man3/DBD::mysql.3<br> Manifying blib/man3/DBD::mysql::INSTALL.3<br> *bossert@#$#$#$# DBD-mysql-4.026 $ make test<br> Running Mkbootstrap for DBD::mysql ()<br> chmod 644 mysql.bs<br> PERL_DL_NONLAZY=1 /tempssd/bossert/perl/bin/perl "-MExtUtils::Command: +:MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_har +ness(0, 'blib/lib', 'blib/arch')" t/*.t t/00base.t ........................... 1/6 Bailout called. Further te +sting stopped: Unable to load DBD::mysql<br> <strong># Failed test 'use DBD::mysql;'<br> # at t/00base.t line 18.<br> # Tried to use 'DBD::mysql'.<br> # Error: Can't load '/users/bossert/.cpan/authors/id/C/CA/CAPTTOF +U/DBD-mysql-4.026/blib/arch/auto/DBD/mysql/mysql.so' for module DBD:: +mysql: /users/bossert/.cpan/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.026/ +blib/arch/auto/DBD/mysql/mysql.so: undefined symbol: __cxa_pure_virtu +al at /tempssd/bossert/perl/lib/5.16.3/x86_64-linux-thread-multi-ld/D +ynaLoader.pm line 190.</strong><br> # at t/00base.t line 18.<br> # Compilation failed in require at t/00base.t line 18.<br> # BEGIN failed--compilation aborted at t/00base.t line 18.<br> FAILED--Further testing stopped: Unable to load DBD::mysql<br> make: *** [test_dynamic] Error 255<br>

Replies are listed 'Best First'.
Re: DBD::mysql on opens use and having lots of problems...
by karlgoethebier (Abbot) on Jan 22, 2014 at 19:31 UTC

    I found this in a hurry: Bug #91201. Didn't check in depth but perhaps you did nothing wrong :-) Please see ebenda.

    Regards, Karl

    «The Crux of the Biscuit is the Apostrophe»

Re: DBD::mysql on opens use and having lots of problems...
by ww (Archbishop) on Jan 22, 2014 at 19:24 UTC
    Please revisit your node and read the instructions which appear at the text input box. Use <code> ... </code> (or <c>... </c>) around your data and code to make it more readily readable. Doing so improves the odds of a good answer to your problem.

    For your reading pleasure, I recommend Markup in the Monastery.
     

    Come, let us reason together: Spirit of the Monastery

      Tried that, but it does not seem to be more readable to me that way...is it better for you?

        Definitely better: no longer an unintelligble blob of characters; it's actually readable. I'm not sure why it doesn't look better to you. Please elaborate.


        If you didn't program your executable by toggling in binary, it wasn't really programming!

Re: DBD::mysql on opens use and having lots of problems...
by Anonymous Monk on Jan 22, 2014 at 20:28 UTC
    What does ldd /users/bossert/.cpan/authors/id/C/CA/CAPTTOFU/DBD-mysql-4.026/blib/arch/auto/DBD/mysql/mysql.so output?

      As it turns out, my admin was mistaken when he said he had installed all the header files...He went back and installed the rest of the mysql client libraries and all is well. I guess there was still a missing header file somewhere. Thanks to all for the suggestions...I appreciated the help!