Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

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 Config.pm 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/Changes.pm cp Changes blib/lib/DBI/Changes.pm cp Driver_xst.h blib/arch/auto/DBI/Driver_xst.h cp lib/DBD/Proxy.pm blib/lib/DBD/Proxy.pm cp lib/DBI/Gofer/Response.pm blib/lib/DBI/Gofer/Response.pm cp lib/DBI/Util/_accessor.pm blib/lib/DBI/Util/_accessor.pm cp lib/DBI/Gofer/Transport/Base.pm blib/lib/DBI/Gofer/Transport/Base.p +m cp lib/DBD/DBM.pm blib/lib/DBD/DBM.pm cp DBIXS.h blib/arch/auto/DBI/DBIXS.h cp dbixs_rev.pl blib/lib/dbixs_rev.pl cp lib/DBI/Const/GetInfoType.pm blib/lib/DBI/Const/GetInfoType.pm cp lib/DBI/Gofer/Serializer/DataDumper.pm blib/lib/DBI/Gofer/Serialize +r/DataDumper.pm cp lib/DBI/DBD/Metadata.pm blib/lib/DBI/DBD/Metadata.pm cp lib/DBD/Gofer/Transport/pipeone.pm blib/lib/DBD/Gofer/Transport/pip +eone.pm cp lib/DBI/Const/GetInfo/ODBC.pm blib/lib/DBI/Const/GetInfo/ODBC.pm cp lib/DBI/ProfileDumper/Apache.pm 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/File.pm blib/lib/DBD/File.pm cp lib/DBI/Util/CacheMemory.pm blib/lib/DBI/Util/CacheMemory.pm cp lib/DBD/NullP.pm blib/lib/DBD/NullP.pm cp lib/DBI/ProfileSubs.pm blib/lib/DBI/ProfileSubs.pm 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/Gofer.pm blib/lib/DBD/Gofer.pm 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/corostream.pm blib/lib/DBD/Gofer/Transport/ +corostream.pm cp lib/DBD/Gofer/Transport/Base.pm blib/lib/DBD/Gofer/Transport/Base.p +m cp lib/DBI/FAQ.pm blib/lib/DBI/FAQ.pm cp lib/DBD/Gofer/Policy/rush.pm blib/lib/DBD/Gofer/Policy/rush.pm cp lib/DBI/SQL/Nano.pm blib/lib/DBI/SQL/Nano.pm cp lib/DBI/Const/GetInfo/ANSI.pm blib/lib/DBI/Const/GetInfo/ANSI.pm cp lib/DBI/Gofer/Request.pm blib/lib/DBI/Gofer/Request.pm cp lib/DBD/Gofer/Transport/stream.pm blib/lib/DBD/Gofer/Transport/stre +am.pm cp lib/DBD/Gofer/Policy/classic.pm blib/lib/DBD/Gofer/Policy/classic.p +m cp lib/DBD/Gofer/Policy/Base.pm blib/lib/DBD/Gofer/Policy/Base.pm cp DBI.pm blib/lib/DBI.pm cp lib/DBI/Const/GetInfoReturn.pm blib/lib/DBI/Const/GetInfoReturn.pm cp lib/DBI/Gofer/Transport/stream.pm blib/lib/DBI/Gofer/Transport/stre +am.pm cp lib/DBI/Gofer/Serializer/Storable.pm blib/lib/DBI/Gofer/Serializer/ +Storable.pm cp lib/DBD/Sponge.pm blib/lib/DBD/Sponge.pm cp lib/DBD/Gofer/Policy/pedantic.pm blib/lib/DBD/Gofer/Policy/pedantic +.pm cp lib/DBI/W32ODBC.pm blib/lib/DBI/W32ODBC.pm cp lib/DBI/DBD/SqlEngine/Developers.pod blib/lib/DBI/DBD/SqlEngine/Dev +elopers.pod cp lib/DBI/Gofer/Transport/pipeone.pm blib/lib/DBI/Gofer/Transport/pip +eone.pm cp lib/DBD/Gofer/Transport/null.pm blib/lib/DBD/Gofer/Transport/null.p +m cp lib/Bundle/DBI.pm blib/lib/Bundle/DBI.pm cp lib/DBD/File/Developers.pod blib/lib/DBD/File/Developers.pod cp lib/DBI/Profile.pm blib/lib/DBI/Profile.pm cp lib/DBI/ProfileDumper.pm blib/lib/DBI/ProfileDumper.pm cp lib/DBI/ProxyServer.pm blib/lib/DBI/ProxyServer.pm cp lib/DBI/Gofer/Serializer/Base.pm blib/lib/DBI/Gofer/Serializer/Base +.pm cp dbipport.h blib/arch/auto/DBI/dbipport.h cp lib/DBI/Gofer/Execute.pm blib/lib/DBI/Gofer/Execute.pm cp lib/DBI/DBD.pm blib/lib/DBI/DBD.pm cp lib/Win32/DBIODBC.pm blib/lib/Win32/DBIODBC.pm cp lib/DBI/DBD/SqlEngine.pm blib/lib/DBI/DBD/SqlEngine.pm cp lib/DBI/PurePerl.pm blib/lib/DBI/PurePerl.pm cp lib/DBD/ExampleP.pm blib/lib/DBD/ExampleP.pm cp lib/DBI/ProfileData.pm blib/lib/DBI/ProfileData.pm /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 http://www.perl.com/, the Perl Home Pa +ge.


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

thanks in advance

Comment on Perl DBI and DBD::mysql
Select or Download Code
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?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://995761]
Approved by davido
Front-paged by davido
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (9)
As of 2014-08-01 22:35 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Who would be the most fun to work for?















    Results (50 votes), past polls