Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[Info-ingres] Problem compiling perl DBI

69 views
Skip to first unread message

Martin Bowes

unread,
Jun 17, 2021, 4:32:09 AM6/17/21
to info-...@lists.planetingres.org

Hi All,

 

In response to a strange situation where my programs had connected to a database, set date_format ‘dmy’ and then returned dates in the installation default multinational4 format I decided on a fresh install of Perl DBI on this platform.

 

The platform is: CentOS Linux release 7.9.2009 (Core)

 

Can anyone explain the following?

 

perl Makefile.PL

 

Configuring DBD::IngresII...

Found Ingres at : "/dbsystem/II"

Using DBI 1.627 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/vendor_perl/auto/DBI/

Checking if your kit is complete...

Looks good

Warning (mostly harmless): No library found for -lingres

Writing Makefile for DBD::IngresII

 

And $II_SYSTEM/ingres/lib/libingres.a is in existence on this host. So that message surprised me. Nonetheless it was flagged as mostly harmless so I pressed on and the compilation seemed to complete. Then I ran a test program which failed at the connect, generating the following:

 

install_driver(IngresII) failed: Can't load '/home/ingres/DBD/auto/DBD/IngresII/IngresII.so' for module DBD::IngresII: /home/ingres/DBD/auto/DBD/IngresII/IngresII.so: undefined symbol: __gxx_personality_v0 at /usr/lib64/perl5/DynaLoader.pm line 190.

at (eval 4) line 3.

Compilation failed in require at (eval 4) line 3.

Perhaps a required shared library or dll isn't installed where expected

at /home/ingres/scripts/perl/Classes/runDBI.pm line 336.

 

Anyone?

 

Marty

 

stelling

unread,
Jun 17, 2021, 4:44:10 AM6/17/21
to info-...@lists.planetingres.org
Hi,

is a option -L missing?

Following option -lingres the compiler search for libingres.a,
libingres.so ... on a list of directories. The directory list is
expanded with options -L...

my makefiles use

... -L/opt/Actian/IngresII/ingres/lib -lingres ...

Uwe

Am 17.06.21 um 10:30 schrieb Martin Bowes:
> _______________________________________________
> Info-ingres mailing list
> Info-...@lists.planetingres.org
> https://lists.planetingres.org/mailman/listinfo/info-ingres
>

Martin Bowes

unread,
Jun 17, 2021, 4:52:09 AM6/17/21
to stelling, info-...@lists.planetingres.org
Hi Uwe

The Makefile has:
OTHERLDFLAGS = -L"/dbsystem/II/ingres/lib" -lingres -lrt

That is the correct path for this installation.

Marty

Václav Dohnal

unread,
Jun 17, 2021, 5:12:09 AM6/17/21
to info-...@lists.planetingres.org

Hi Marty,

I'm compiling DBD::IngresII quite often on Centos 7. What I have to do is to add stdc++ library to compilation. Without this library you can’t compile IngresII.so. I’ve written to the author of this module but no response. The best option is Makefile.PL:

$opts{dynamic_lib} = { OTHERLDFLAGS => " $ld_options -lstdc++" };

 

Hope this helps

 

Vasek

Martin Bowes

unread,
Jun 17, 2021, 5:32:09 AM6/17/21
to Václav Dohnal, info-...@lists.planetingres.org

Hi Vasek,

 

Spot on! That’s solved the problem.

 

Thanks Heaps.

 

Marty

nikosv

unread,
Jun 17, 2021, 4:18:43 PM6/17/21
to
I think that -lstdc++ is a requirement for Ingres versions > 10.2
0 new messages