Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Perl DBI and DBD::mysql

by bluethundr (Pilgrim)
on Sep 26, 2012 at 12:32 UTC ( #995761=perlquestion: print w/replies, xml ) Need Help??
bluethundr has asked for the wisdom of the Perl Monks concerning the following question:

Hello Monks

I know I've been faced with this situation before. And I apologize for having to come to you again for it. I hope that I heave learned enough from my mistakes in providing information that we can arrive at a solution this time.

I am attempting to compile the DBI and DBD::mysql CPAN modules under solaris 10 i386 and not getting very far with it.

I've downloaded the modules from CPAN and am using perlgcc Makefile.PL (the preferred solaris method) as opposed to perl Makefile.PL.

Here is what I get. The configure portion goes fine, but the make portion blows up the process and I can't proceed from there. Forgive the length of the output I hope that it will aid in troubleshooting.

perlgcc Makefile.PL Creating test wrappers for DBD::Gofer: t/zvg_01basics.t t/zvg_02dbidrv.t t/zvg_03handle.t t/zvg_04mods.t t/zvg_05concathash.t t/zvg_06attrs.t t/zvg_07kids.t t/zvg_08keeperr.t t/zvg_09trace.t t/zvg_10examp.t t/zvg_11fetch.t t/zvg_12quote.t t/zvg_13taint.t t/zvg_14utf8.t t/zvg_15array.t t/zvg_16destroy.t t/zvg_19fhtrace.t t/zvg_20meta.t t/zvg_30subclass.t t/zvg_31methcache.t t/zvg_35thrclone.t t/zvg_40profile.t t/zvg_41prof_dump.t t/zvg_42prof_data.t t/zvg_43prof_env.t t/zvg_48dbi_dbd_sqlengine.t t/zvg_49dbd_file.t t/zvg_50dbm_simple.t t/zvg_51dbm_file.t t/zvg_52dbm_complex.t t/zvg_60preparse.t t/zvg_65transact.t t/zvg_70callbacks.t t/zvg_72childhandles.t t/zvg_80proxy.t t/zvg_85gofer.t t/zvg_86gofer_fail.t t/zvg_87gofer_cache.t t/zvg_90sql_type_cast.t Creating test wrappers for DBI::SQL::Nano: t/zvn_48dbi_dbd_sqlengine.t t/zvn_49dbd_file.t t/zvn_50dbm_simple.t t/zvn_51dbm_file.t t/zvn_52dbm_complex.t t/zvn_85gofer.t Creating test wrappers for DBI::PurePerl: t/zvp_01basics.t t/zvp_02dbidrv.t t/zvp_03handle.t t/zvp_04mods.t t/zvp_05concathash.t t/zvp_06attrs.t t/zvp_07kids.t t/zvp_08keeperr.t t/zvp_09trace.t t/zvp_10examp.t t/zvp_11fetch.t t/zvp_12quote.t t/zvp_13taint.t t/zvp_14utf8.t t/zvp_15array.t t/zvp_16destroy.t t/zvp_19fhtrace.t t/zvp_20meta.t t/zvp_30subclass.t t/zvp_31methcache.t t/zvp_35thrclone.t t/zvp_40profile.t t/zvp_41prof_dump.t t/zvp_42prof_data.t t/zvp_43prof_env.t t/zvp_48dbi_dbd_sqlengine.t t/zvp_49dbd_file.t t/zvp_50dbm_simple.t t/zvp_51dbm_file.t t/zvp_52dbm_complex.t t/zvp_60preparse.t t/zvp_65transact.t t/zvp_70callbacks.t t/zvp_72childhandles.t t/zvp_80proxy.t t/zvp_85gofer.t t/zvp_86gofer_fail.t t/zvp_87gofer_cache.t t/zvp_90sql_type_cast.t Creating test wrappers for DBD::Gofer + DBI::SQL::Nano: t/zvxgn_48dbi_dbd_sqlengine.t t/zvxgn_49dbd_file.t t/zvxgn_50dbm_simple.t t/zvxgn_51dbm_file.t t/zvxgn_52dbm_complex.t t/zvxgn_85gofer.t Creating test wrappers for DBD::Gofer + DBI::PurePerl: t/zvxgp_01basics.t t/zvxgp_02dbidrv.t t/zvxgp_03handle.t t/zvxgp_04mods.t t/zvxgp_05concathash.t t/zvxgp_06attrs.t t/zvxgp_07kids.t t/zvxgp_08keeperr.t t/zvxgp_09trace.t t/zvxgp_10examp.t t/zvxgp_11fetch.t t/zvxgp_12quote.t t/zvxgp_13taint.t t/zvxgp_14utf8.t t/zvxgp_15array.t t/zvxgp_16destroy.t t/zvxgp_19fhtrace.t t/zvxgp_20meta.t t/zvxgp_30subclass.t t/zvxgp_31methcache.t t/zvxgp_35thrclone.t t/zvxgp_40profile.t t/zvxgp_41prof_dump.t t/zvxgp_42prof_data.t t/zvxgp_43prof_env.t t/zvxgp_48dbi_dbd_sqlengine.t t/zvxgp_49dbd_file.t t/zvxgp_50dbm_simple.t t/zvxgp_51dbm_file.t t/zvxgp_52dbm_complex.t t/zvxgp_60preparse.t t/zvxgp_65transact.t t/zvxgp_70callbacks.t t/zvxgp_72childhandles.t t/zvxgp_80proxy.t t/zvxgp_85gofer.t t/zvxgp_86gofer_fail.t t/zvxgp_87gofer_cache.t t/zvxgp_90sql_type_cast.t Creating test wrappers for DBI::SQL::Nano + DBI::PurePerl: t/zvxnp_48dbi_dbd_sqlengine.t t/zvxnp_49dbd_file.t t/zvxnp_50dbm_simple.t t/zvxnp_51dbm_file.t t/zvxnp_52dbm_complex.t t/zvxnp_85gofer.t Creating test wrappers for DBD::Gofer + DBI::SQL::Nano + DBI::PurePerl +: t/zvxgnp_48dbi_dbd_sqlengine.t t/zvxgnp_49dbd_file.t t/zvxgnp_50dbm_simple.t t/zvxgnp_51dbm_file.t t/zvxgnp_52dbm_complex.t t/zvxgnp_85gofer.t Checking if your kit is complete... Looks good Have /usr/perl5/5.8.4/lib/Sun/Solaris/PerlGcc Want /usr/perl5/5.8.4/lib/i86pc-solaris-64int Your perl and your seem to have different ideas about the architecture they are running on. Perl thinks: [PerlGcc] Config says: [i86pc-solaris-64int] This may or may not cause problems. Please check your installation of +perl if you have problems building this extension. I see you're using perl 5.008004 on i86pc-solaris-64int, okay. Remember to actually *read* the README file! Use 'make' to build the software (dmake or nmake on Windows). Then 'make test' to execute self tests. Then 'make install' to install the DBI and then delete this workin +g directory before unpacking and building any DBD::* drivers. Writing Makefile for DBI Writing MYMETA.yml and MYMETA.json

OK that seems to go fine. Yet when I run a make I run into the following problem. I think I may be missing some libraries

make /usr/perl5/5.8.4/bin/perl -MExtUtils::Command -e 'mkpath' -- blib/lib/ +DBI rm -f blib/lib/DBI/ cp Changes blib/lib/DBI/ cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h cp lib/DBD/ blib/lib/DBD/ cp lib/DBI/Gofer/ blib/lib/DBI/Gofer/ cp lib/DBI/Util/ blib/lib/DBI/Util/ cp lib/DBI/Gofer/Transport/ blib/lib/DBI/Gofer/Transport/Base.p +m cp lib/DBD/ blib/lib/DBD/ cp DBIXS.h blib/arch/auto/DBI/DBIXS.h cp blib/lib/ cp lib/DBI/Const/ blib/lib/DBI/Const/ cp lib/DBI/Gofer/Serializer/ blib/lib/DBI/Gofer/Serialize +r/ cp lib/DBI/DBD/ blib/lib/DBI/DBD/ cp lib/DBD/Gofer/Transport/ blib/lib/DBD/Gofer/Transport/pip cp lib/DBI/Const/GetInfo/ blib/lib/DBI/Const/GetInfo/ cp lib/DBI/ProfileDumper/ blib/lib/DBI/ProfileDumper/Apache.p +m cp lib/DBD/File/Roadmap.pod blib/lib/DBD/File/Roadmap.pod cp Driver.xst blib/arch/auto/DBI/Driver.xst cp lib/DBD/ blib/lib/DBD/ cp lib/DBI/Util/ blib/lib/DBI/Util/ cp lib/DBD/ blib/lib/DBD/ cp lib/DBI/ blib/lib/DBI/ cp dbi_sql.h blib/arch/auto/DBI/dbi_sql.h cp lib/DBD/File/HowTo.pod blib/lib/DBD/File/HowTo.pod cp lib/DBD/ blib/lib/DBD/ cp dbd_xsh.h blib/arch/auto/DBI/dbd_xsh.h cp dbivport.h blib/arch/auto/DBI/dbivport.h cp lib/DBI/DBD/SqlEngine/HowTo.pod blib/lib/DBI/DBD/SqlEngine/HowTo.po +d cp dbixs_rev.h blib/arch/auto/DBI/dbixs_rev.h cp lib/DBD/Gofer/Transport/ blib/lib/DBD/Gofer/Transport/ cp lib/DBD/Gofer/Transport/ blib/lib/DBD/Gofer/Transport/Base.p +m cp lib/DBI/ blib/lib/DBI/ cp lib/DBD/Gofer/Policy/ blib/lib/DBD/Gofer/Policy/ cp lib/DBI/SQL/ blib/lib/DBI/SQL/ cp lib/DBI/Const/GetInfo/ blib/lib/DBI/Const/GetInfo/ cp lib/DBI/Gofer/ blib/lib/DBI/Gofer/ cp lib/DBD/Gofer/Transport/ blib/lib/DBD/Gofer/Transport/stre cp lib/DBD/Gofer/Policy/ blib/lib/DBD/Gofer/Policy/classic.p +m cp lib/DBD/Gofer/Policy/ blib/lib/DBD/Gofer/Policy/ cp blib/lib/ cp lib/DBI/Const/ blib/lib/DBI/Const/ cp lib/DBI/Gofer/Transport/ blib/lib/DBI/Gofer/Transport/stre cp lib/DBI/Gofer/Serializer/ blib/lib/DBI/Gofer/Serializer/ cp lib/DBD/ blib/lib/DBD/ cp lib/DBD/Gofer/Policy/ blib/lib/DBD/Gofer/Policy/pedantic cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/DBD/SqlEngine/Developers.pod blib/lib/DBI/DBD/SqlEngine/Dev +elopers.pod cp lib/DBI/Gofer/Transport/ blib/lib/DBI/Gofer/Transport/pip cp lib/DBD/Gofer/Transport/ blib/lib/DBD/Gofer/Transport/null.p +m cp lib/Bundle/ blib/lib/Bundle/ cp lib/DBD/File/Developers.pod blib/lib/DBD/File/Developers.pod cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBI/Gofer/Serializer/ blib/lib/DBI/Gofer/Serializer/Base cp dbipport.h blib/arch/auto/DBI/dbipport.h cp lib/DBI/Gofer/ blib/lib/DBI/Gofer/ cp lib/DBI/ blib/lib/DBI/ cp lib/Win32/ blib/lib/Win32/ cp lib/DBI/DBD/ blib/lib/DBI/DBD/ cp lib/DBI/ blib/lib/DBI/ cp lib/DBD/ blib/lib/DBD/ cp lib/DBI/ blib/lib/DBI/ /usr/perl5/5.8.4/bin/perl -p -e "s/~DRIVER~/Perl/g" ./Driver.xst > Per +l.xsi /usr/perl5/5.8.4/bin/perl /usr/perl5/5.8.4/lib/ExtUtils/xsubpp -typem +ap /usr/perl5/5.8.4/lib/ExtUtils/typemap -typemap typemap Perl.xs > +Perl.xsc && mv Perl.xsc Perl.c gcc -c -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_TS_ERRNO -O2 - +fno-strict-aliasing -DVERSION=\"1.622\" -DXS_VERSION=\"1.622\" -f +PIC "-I/usr/perl5/5.8.4/lib/i86pc-solaris-64int/CORE" -DDBI_NO_THREA +DS Perl.c In file included from /usr/perl5/5.8.4/lib/i86pc-solaris-64int/CORE/pe +rl.h:2838, from DBIXS.h:23, from Perl.xs:7: /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/math.h:26:26: iso +/math_iso.h: No such file or directory In file included from /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/inc +lude/math.h:336, from /usr/perl5/5.8.4/lib/i86pc-solaris-64int/CORE/pe +rl.h:2838, from DBIXS.h:23, from Perl.xs:7: /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/floatingpoint.h:3 +0:24: sys/ieeefp.h: No such file or directory In file included from /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/inc +lude/math.h:336, from /usr/perl5/5.8.4/lib/i86pc-solaris-64int/CORE/pe +rl.h:2838, from DBIXS.h:23, from Perl.xs:7: /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/floatingpoint.h:1 +04: error: field `fpclass' has incomplete type /usr/local/lib/gcc/i386-pc-solaris2.10/3.4.6/include/floatingpoint.h:1 +28: error: field `rd' has incomplete type *** Error code 1 make: Fatal error: Command failed for target `Perl.o'

Here is my perl info

This is perl, v5.8.4 built for i86pc-solaris-64int (with 32 registered patches, see perl -V for more detail) Copyright 1987-2004, Larry Wall Perl may be copied only under the terms of either the Artistic License + or the GNU General Public License, which may be found in the Perl 5 source ki +t. Complete documentation for Perl, including FAQ lists, should be found +on this system using `man perl' or `perldoc perl'. If you have access to + the Internet, point your browser at, the Perl Home Pa +ge.

So, dear monks can someone please point out where I am going wrong?

thanks in advance

Replies are listed 'Best First'.
Re: Perl DBI and DBD::mysql
by Anonymous Monk on Sep 26, 2012 at 17:52 UTC

    Remember to actually *read* the README file!

    ... iso/math_iso.h: No such file or directory

    Well, you have a mising file.

Re: Perl DBI and DBD::mysql
by jonix (Friar) on Sep 27, 2012 at 09:09 UTC
    header-math might be missing on your system - see here

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://995761]
Approved by davido
Front-paged by davido
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2017-06-27 23:11 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (617 votes). Check out past polls.