• Re: [Info-ingres] Problem compiling perl DBI

    From stelling@Uwe.Stelling@bgr.de to info-ingres on Thu Jun 17 10:42:10 2021
    From Newsgroup: comp.databases.ingres

    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:
    Hi All,

    In response to a strange situation where my programs had connected to a database, set date_format admyA 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


    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Martin Bowes@martin.bowes@ndph.ox.ac.uk to info-ingres@lists.planetingres.org on Thu Jun 17 08:50:55 2021
    From Newsgroup: comp.databases.ingres

    Hi Uwe
    The Makefile has:
    OTHERLDFLAGS = -L"/dbsystem/II/ingres/lib" -lingres -lrt
    That is the correct path for this installation.
    Marty
    -----Original Message-----
    From: stelling <Uwe.Stelling@bgr.de>
    Sent: 17 June 2021 09:42
    To: info-ingres@lists.planetingres.org
    Subject: Re: [Info-ingres] Problem compiling perl DBI
    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:
    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


    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    _______________________________________________
    Info-ingres mailing list
    Info-ingres@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From nikosv@nikos.vaggalis@gmail.com to comp.databases.ingres on Thu Jun 17 13:18:42 2021
    From Newsgroup: comp.databases.ingres

    On Thursday, June 17, 2021 at 12:12:09 PM UTC+3, V|iclav Dohnal wrote:
    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 canrCOt compile IngresII.so. IrCOve 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
    -----Original Message-----
    From: info-ingr...@lists.planetingres.org <info-ingr...@lists.planetingres.org> On Behalf Of Martin Bowes
    Sent: Thursday, June 17, 2021 10:51 AM
    To: stelling <Uwe.St...@bgr.de>; info-...@lists.planetingres.org
    Subject: Re: [Info-ingres] Problem compiling perl DBI
    Hi Uwe
    The Makefile has:
    OTHERLDFLAGS = -L"/dbsystem/II/ingres/lib" -lingres -lrt
    That is the correct path for this installation.
    Marty
    -----Original Message-----
    From: stelling <Uwe.St...@bgr.de>
    Sent: 17 June 2021 09:42
    To: info-...@lists.planetingres.org
    Subject: Re: [Info-ingres] Problem compiling perl DBI
    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:
    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


    _______________________________________________
    Info-ingres mailing list
    Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres

    _______________________________________________
    Info-ingres mailing list
    Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres _______________________________________________
    Info-ingres mailing list
    Info-...@lists.planetingres.org https://lists.planetingres.org/mailman/listinfo/info-ingres
    I think that -lstdc++ is a requirement for Ingres versions > 10.2
    --- Synchronet 3.21b-Linux NewsLink 1.2