Re^2: DBD::SQLite install fails

[Anonymous Monk]

I do cpan DBD::SQLite, what do I have to do to set an option like this?

[mje]

Download DBD::SQLite from the CPAN. Untar it, change into the created dir, run perl Makefile.PL then edit the resulting Makefile. Look for line starting CCFLAGS= (be careful it will be in a comment at the start of the file and it is not that one). Add --std=c99 to the end of that line. Type make, make test, make install.

[Anonymous Monk]

I got further, but not too far:

gmake
cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm
cp lib/DBD/SQLite/Cookbook.pod blib/lib/DBD/SQLite/Cookbook.pod
/app/appname/perl/bin/perl -p -e "s/~DRIVER~/SQLite/g" /app/appname/pe
+rl/lib/site_perl/5.18.2/sun4-solaris-thread-multi-64/auto/DBI/Driver.
+xst > SQLite.xsi
/app/appname/perl/bin/perl /app/appname/perl/lib/5.18.2/ExtUtils/xsubp
+p  -typemap /app/appname/perl/lib/5.18.2/ExtUtils/typemap -typemap ty
+pemap  SQLite.xs > SQLite.xsc && mv SQLite.xsc SQLite.c
/app/appname/sfw/bin/gcc -c  -I. -I/app/appname/perl/lib/site_perl/5.1
+8.2/sun4-solaris-thread-multi-64/auto/DBI --std=c99 -D_REENTRANT -mcp
+u=v9 -m64 -fno-strict-aliasing -pipe -I/usr/local/include -D_LARGEFIL
+E_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -O -O2   -DVER
+SION=\"1.42\" -DXS_VERSION=\"1.42\" -fPIC "-I/app/appname/perl/lib/5.
+18.2/sun4-solaris-thread-multi-64/CORE"  -DSQLITE_ENABLE_FTS4 -DSQLIT
+E_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_COLUM
+N_METADATA -DSQLITE_ENABLE_STAT3 -DNDEBUG=1 -DHAVE_USLEEP=1 SQLite.c
In file included from SQLiteXS.h:11:0,
                 from SQLite.xs:3:
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perlio.
+h:292:15: note: in expansion of macro 'Off_t'
 PERL_EXPORT_C Off_t PerlIO_tell(PerlIO *);
               ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perlio.
+h:295:41: note: in expansion of macro 'Off_t'
 PERL_EXPORT_C int PerlIO_seek(PerlIO *, Off_t, int);
                                         ^
In file included from /app/appname/perl/lib/5.18.2/sun4-solaris-thread
+-multi-64/CORE/perl.h:38:0,
                 from SQLiteXS.h:11,
                 from SQLite.xs:3:
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/config.
+h:2299:20: error: unknown type name 'sigjmp_buf'
 #define Sigjmp_buf sigjmp_buf
                    ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/cop.h:3
+4:5: note: in expansion of macro 'Sigjmp_buf'
     Sigjmp_buf  je_buf;  /* only for use if !je_throw */
     ^
In file included from SQLiteXS.h:11:0,
                 from SQLite.xs:3:
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/proto.h
+:936:47: note: in expansion of macro 'Off_t'
 PERL_CALLCONV bool Perl_do_seek(pTHX_ GV* gv, Off_t pos, int whence);
                                               ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/proto.h
+:948:15: note: in expansion of macro 'Off_t'
 PERL_CALLCONV Off_t Perl_do_sysseek(pTHX_ GV* gv, Off_t pos, int when
+ce)
               ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/proto.h
+:948:51: note: in expansion of macro 'Off_t'
 PERL_CALLCONV Off_t Perl_do_sysseek(pTHX_ GV* gv, Off_t pos, int when
+ce)
                                                   ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/proto.h
+:953:15: note: in expansion of macro 'Off_t'
 PERL_CALLCONV Off_t Perl_do_tell(pTHX_ GV* gv)
               ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/proto.h
+:7884:53: note: in expansion of macro 'Off_t'
 PERL_CALLCONV int Perl_PerlIO_seek(pTHX_ PerlIO *f, Off_t offset, int
+ whence);
                                                     ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/perl.h:
+2541:22: error: unknown type name 'off64_t'
 #       define Off_t off64_t
                      ^
/app/appname/perl/lib/5.18.2/sun4-solaris-thread-multi-64/CORE/proto.h
+:7897:15: note: in expansion of macro 'Off_t'
 PERL_CALLCONV Off_t Perl_PerlIO_tell(pTHX_ PerlIO *f);
               ^
gmake: *** [SQLite.o] Error 1

[mje]

Add -D_LARGEFILE64_SOURCE to CCFLAGS too.