Install perl DBI::Ingres

From PTAGISWiki

After doing a major perl version upgrade on pitblade, I had to reinstall some perl modules, including DBI::Ingres.

The perl Makefile.PL announced that it couldn't find the Esql/C precompiler:

Using Ingres in /dsk1/ing2006r2/ingII
I can't find your Esql/C precompiler: '/dsk1/ing2006r2/ingII/ingres/bin/esqlc'
Is your Ingres set up correctly??

And it is true, that file doesn't exist. I couldn't find it on bay either, so I couldn't just copy it over. I probably need to go through the Ingres installer.

Installing Ingres esqlc

I started up ingbuild and pointed it to the installation file downloaded from ingres:

/dsk1/ing2006r2/ingII/ingres2006-9.1.1-103c-com-sun-solaris-sparc-32-64bit/ingres.tar

Selected custom install and then went through the list of options to turn off everything but the esql 32-bit and 64-bit components.

The install recommended that ingres be stopped, so I did an "ingstop" on pitblade, finished the install, and then ran "ingstart".

Back to installing Perl DBD::Ingres

The "perl Makefile.PL" now succeeds with no errors.

make fails though:

pitblade:II:rday: > make
/dsk1/ing2006r2/ingII/ingres/bin/esqlc -o.h -w -p dbdimp.sc 
ESQL dbdimp.sc:
gcc -c  -I/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBI -fno-strict-aliasing -pipe -Wdeclaration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -g   -DVERSION=\"0.52\" -DXS_VERSION=\"0.52\" -fPIC "-I/usr/local/lib/perl5/5.8.8/sun4-solaris/CORE"  -Wall -pedantic -Wno-comment -Wtraditional Ingres.c
cc1: error: unrecognized option `-Wdeclaration-after-statement'
make: *** [Ingres.o] Error 1

So I removed that option from the makefile.

Then make ran successfully. I ran make test like this:

pitblade:II:rday: > DBI_DSN=ptagis3 make test
PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/datatypes....ok       
t/dbi..........ok    
t/event........ok     
t/exec.........ok    
All tests successful.
Files=4, Tests=386, 18 wallclock secs ( 0.24 usr  0.01 sys +  0.62 cusr  0.15 csys =  1.02 CPU)
Result: PASS

Then I ran make install as root.

And perldoc perllocal now reports this:

     Thu Jul 17 10:56:17 2008: "Module" DBD::Ingres

     o   "installed into: /usr/local/lib/perl5/site_perl/5.8.8"

     o   "LINKTYPE: dynamic"

     o   "VERSION: 0.52"

     o   "EXE_FILES: "