• [Info-ingres] Problem compiling perl DBI

    From stelling@21:1/5 to All on Thu Jun 17 10:42:10 2021
    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


    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to All on Thu Jun 17 08:30:46 2021
    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


    <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
    <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style><!--
    /* Font Definitions */
    @font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
    @font-face
    {font-family:"Lucida Console";
    panose-1:2 11 6 9 4 5 4 2 2 4;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:#0563C1;
    text-decoration:underline;}
    a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:#954F72;
    text-decoration:underline;}
    span.EmailStyle17
    {mso-style-type:personal-compose;
    font-family:"Calibri",sans-serif;
    color:windowtext;}
    .MsoChpDefault
    {mso-style-type:export-only;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    @page WordSection1
    {size:612.0pt 792.0pt;
    margin:72.0pt 72.0pt 72.0pt 72.0pt;}
    div.WordSection1
    {page:WordSection1;}
    </style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]-->
    </head>
    <body lang="EN-GB" link="#0563C1" vlink="#954F72">
    <div class="WordSection1">
    <p class="MsoNormal">Hi All,<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">In response to a strange situation where my programs had connected to a database, set date_format &#8216;dmy&#8217; and then returned dates in the installation default multinational4 format I decided on a fresh install of Perl DBI on
    this platform.<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal" style="text-autospace:none">The platform is: <span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">
    CentOS Linux release 7.9.2009 (Core)<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Can anyone explain the following?<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">perl Makefile.PL<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Configuring DBD::IngresII...<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Found Ingres at : &quot;/dbsystem/II&quot;<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Using DBI 1.627 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /usr/lib64/perl5/vendor_perl/auto/DBI/<o:p></o:p></span></

    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Checking if your kit is complete...<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Looks good<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Warning (mostly harmless): No library found for -lingres<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Writing Makefile for DBD::IngresII<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">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:<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">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.<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">at (eval 4) line 3.<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Compilation failed in require at (eval 4) line 3.<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">Perhaps a required shared library or dll isn't installed where expected<o:p></o:p></span></p>
    <p class="MsoNormal" style="text-autospace:none"><span style="font-size:10.0pt;font-family:&quot;Lucida Console&quot;">at /home/ingres/scripts/perl/Classes/runDBI.pm line 336.<o:p></o:p></span></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Anyone?<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoNormal">Marty<o:p></o:p></p>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    </div>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to stelling on Thu Jun 17 08:50:55 2021
    To: info-ingres@lists.planetingres.org (info-ingres@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
    -----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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Martin Bowes@21:1/5 to =?iso-8859-1?Q?V=E1clav_Dohnal?= on Thu Jun 17 09:31:55 2021
    To: info-ingres@lists.planetingres.org (info-ingres@lists.planetingres.org)

    Hi Vasek,

    Spot on! That's solved the problem.

    Thanks Heaps.

    Marty

    From: Václav Dohnal <vdohnal@prytanis.cz>
    Sent: 17 June 2021 10:10
    To: info-ingres@lists.planetingres.org
    Subject: Re: [Info-ingres] Problem compiling perl DBI


    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



    -----Original Message-----
    From: info-ingres-bounces@lists.planetingres.org<mailto:info-ingres-bounces@lists.planetingres.org> <info-ingres-bounces@lists.planetingres.org<mailto:info-ingres-bounces@lists.planetingres.org>> On Behalf Of Martin Bowes
    Sent: Thursday, June 17, 2021 10:51 AM
    To: stelling <Uwe.Stelling@bgr.de<mailto:Uwe.Stelling@bgr.de>>; info-ingres@lists.planetingres.org<mailto:info-ingres@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.Stelling@bgr.de<mailto:Uwe.Stelling@bgr.de>>

    Sent: 17 June 2021 09:42

    To: info-ingres@lists.planetingres.org<mailto: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<mailto:Info-ingres@lists.planetingres.org>

    https://lists.planetingres.org/mailman/listinfo/info-ingres



    _______________________________________________

    Info-ingres mailing list

    Info-ingres@lists.planetingres.org<mailto:Info-ingres@lists.planetingres.org>

    https://lists.planetingres.org/mailman/listinfo/info-ingres

    _______________________________________________

    Info-ingres mailing list

    Info-ingres@lists.planetingres.org<mailto:Info-ingres@lists.planetingres.org>

    https://lists.planetingres.org/mailman/listinfo/info-ingres

    <html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    <meta name="Generator" content="Microsoft Word 15 (filtered medium)"> <style><!--
    /* Font Definitions */
    @font-face
    {font-family:"Cambria Math";
    panose-1:2 4 5 3 5 4 6 3 2 4;}
    @font-face
    {font-family:Calibri;
    panose-1:2 15 5 2 2 2 4 3 2 4;}
    /* Style Definitions */
    p.MsoNormal, li.MsoNormal, div.MsoNormal
    {margin:0cm;
    margin-bottom:.0001pt;
    font-size:12.0pt;
    font-family:"Times New Roman",serif;}
    a:link, span.MsoHyperlink
    {mso-style-priority:99;
    color:#0563C1;
    text-decoration:underline;}
    a:visited, span.MsoHyperlinkFollowed
    {mso-style-priority:99;
    color:#954F72;
    text-decoration:underline;}
    p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
    {mso-style-priority:99;
    mso-style-link:"Plain Text Char";
    margin:0cm;
    margin-bottom:.0001pt;
    font-size:11.0pt;
    font-family:"Calibri",sans-serif;
    mso-fareast-language:EN-US;}
    p.msonormal0, li.msonormal0, div.msonormal0
    {mso-style-name:msonormal;
    mso-margin-top-alt:auto;
    margin-right:0cm;
    mso-margin-bottom-alt:auto;
    margin-left:0cm;
    font-size:12.0pt;
    font-family:"Times New Roman",serif;}
    span.PlainTextChar
    {mso-style-name:"Plain Text Char";
    mso-style-priority:99;
    mso-style-link:"Plain Text";
    font-family:"Calibri",sans-serif;}
    span.EmailStyle20
    {mso-style-type:personal-reply;
    font-family:"Calibri",sans-serif;
    color:#1F497D;}
    .MsoChpDefault
    {mso-style-type:export-only;
    font-size:10.0pt;}
    @page WordSection1
    {size:612.0pt 792.0pt;
    margin:70.85pt 70.85pt 70.85pt 70.85pt;}
    div.WordSection1
    {page:WordSection1;}
    </style><!--[if gte mso 9]><xml>
    <o:shapedefaults v:ext="edit" spidmax="1026" />
    </xml><![endif]--><!--[if gte mso 9]><xml>
    <o:shapelayout v:ext="edit">
    <o:idmap v:ext="edit" data="1" />
    </o:shapelayout></xml><![endif]-->
    </head>
    <body lang="EN-GB" link="#0563C1" vlink="#954F72">
    <div class="WordSection1">
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Hi Vasek,<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Spot on! That&#8217;s solved the problem.<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Thanks Heaps.<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US">Marty<o:p></o:p></span></p>
    <p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p>&nbsp;</o:p></span></p>
    <div>
    <div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
    <p class="MsoNormal"><b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> Václav Dohnal &lt;vdohnal@prytanis.cz&
    gt;

    <b>Sent:</b> 17 June 2021 10:10<br>
    <b>To:</b> info-ingres@lists.planetingres.org<br>
    <b>Subject:</b> Re: [Info-ingres] Problem compiling perl DBI<o:p></o:p></span></p>
    </div>
    </div>
    <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
    <p class="MsoPlainText"><span lang="CS">Hi Marty,<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">I</span><span lang="EN-US">'m compiling DBD::IngresII quite often on Centos 7. What I have to do is to add stdc&#43;&#43; library to compilation. Without this library you can&#8217;t compile IngresII.so. I&#8217;ve
    written to the author
    of this module but no response. The best option is Makefile.PL:<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="EN-US">$opts{dynamic_lib} = { OTHERLDFLAGS =&gt; &quot; $ld_options
    <b>-lstdc&#43;&#43;</b>&quot; };<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Hope this helps<o:p></o:p></span></p> <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Vasek<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="EN-US" style="mso-fareast-language:CS">-----Original Message-----<br>
    From: <a href="mailto:info-ingres-bounces@lists.planetingres.org">info-ingres-bounces@lists.planetingres.org</a> &lt;<a href="mailto:info-ingres-bounces@lists.planetingres.org">info-ingres-bounces@lists.planetingres.org</a>&gt; On Behalf Of Martin Bowes<

    Sent: Thursday, June 17, 2021 10:51 AM<br>
    To: stelling &lt;<a href="mailto:Uwe.Stelling@bgr.de">Uwe.Stelling@bgr.de</a>&gt;; <a href="mailto:info-ingres@lists.planetingres.org">
    info-ingres@lists.planetingres.org</a><br>
    Subject: Re: [Info-ingres] Problem compiling perl DBI</span><span lang="CS"><o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Hi Uwe<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">The Makefile has:<o:p></o:p></span></p> <p class="MsoPlainText"><span lang="CS">OTHERLDFLAGS =&nbsp; -L&quot;/dbsystem/II/ingres/lib&quot; -lingres -lrt<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">That is the correct path for this installation.<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Marty<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">-----Original Message-----<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">From: stelling &lt;<a href="mailto:Uwe.Stelling@bgr.de"><span style="color:windowtext;text-decoration:none">Uwe.Stelling@bgr.de</span></a>&gt;<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Sent: 17 June 2021 09:42<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">To: <a href="mailto:info-ingres@lists.planetingres.org">
    <span style="color:windowtext;text-decoration:none">info-ingres@lists.planetingres.org</span></a><o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Subject: Re: [Info-ingres] Problem compiling perl DBI<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Hi,<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">is a option -L missing?<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Following option -lingres the compiler search for libingres.a, libingres.so ... on a list of directories. The directory list is expanded with options -L...<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">my makefiles use<o:p></o:p></span></p> <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&nbsp;&nbsp;&nbsp; ... -L/opt/Actian/IngresII/ingres/lib -lingres ...<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Uwe<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><o:p>&nbsp;</o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Am 17.06.21 um 10:30 schrieb Martin Bowes:<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Hi All,<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; In response to a strange situation where my programs had connected to
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; a database, set date_format 'dmy' and then returned dates in the
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; installation default multinational4 format I decided on a fresh
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; install of Perl DBI on this platform.<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; The platform is: CentOS Linux release 7.9.2009 (Core)<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Can anyone explain the following?<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; perl Makefile.PL<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Configuring DBD::IngresII...<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Found Ingres at : &quot;/dbsystem/II&quot;<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Using DBI 1.627 (for perl 5.016003 on x86_64-linux-thread-multi)
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; installed in /usr/lib64/perl5/vendor_perl/auto/DBI/<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Checking if your kit is complete...<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Looks good<o:p></o:p></span></p> <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Warning (mostly harmless): No library found for -lingres<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Writing Makefile for DBD::IngresII<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; And $II_SYSTEM/ingres/lib/libingres.a is in existence on this host. So
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; that message surprised me. Nonetheless it was flagged as mostly
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; harmless so I pressed on and the compilation seemed to complete. Then
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; I ran a test program which failed at the connect, generating the following:<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; install_driver(IngresII) failed: Can't load
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; '/home/ingres/DBD/auto/DBD/IngresII/IngresII.so' for module<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; DBD::IngresII: /home/ingres/DBD/auto/DBD/IngresII/IngresII.so:
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; undefined<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; symbol: __gxx_personality_v0 at /usr/lib64/perl5/DynaLoader.pm line 190.<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; at (eval 4) line 3.<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Compilation failed in require at (eval 4) line 3.<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Perhaps a required shared library or dll isn't installed where
    <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; expected<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; at /home/ingres/scripts/perl/Classes/runDBI.pm line 336.<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Anyone?<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Marty<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; _______________________________________________<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; Info-ingres mailing list<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <a href="mailto:Info-ingres@lists.planetingres.org">
    <span style="color:windowtext;text-decoration:none">Info-ingres@lists.planetingres.org</span></a><o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <a href="https://lists.planetingres.org/mailman/listinfo/info-ingres">
    <span style="color:windowtext;text-decoration:none">https://lists.planetingres.org/mailman/listinfo/info-ingres</span></a><o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">&gt; <o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">_______________________________________________<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Info-ingres mailing list<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><a href="mailto:Info-ingres@lists.planetingres.org"><span style="color:windowtext;text-decoration:none">Info-ingres@lists.planetingres.org</span></a><o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><a href="https://lists.planetingres.org/mailman/listinfo/info-ingres"><span style="color:windowtext;text-decoration:none">https://lists.planetingres.org/mailman/listinfo/info-ingres</span></a><o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">_______________________________________________<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS">Info-ingres mailing list<o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><a href="mailto:Info-ingres@lists.planetingres.org"><span style="color:windowtext;text-decoration:none">Info-ingres@lists.planetingres.org</span></a><o:p></o:p></span></p>
    <p class="MsoPlainText"><span lang="CS"><a href="https://lists.planetingres.org/mailman/listinfo/info-ingres"><span style="color:windowtext;text-decoration:none">https://lists.planetingres.org/mailman/listinfo/info-ingres</span></a><o:p></o:p></span></p>
    </div>
    </body>
    </html>

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From nikosv@21:1/5 to All on Thu Jun 17 13:18:42 2021
    On Thursday, June 17, 2021 at 12:12:09 PM UTC+3, Václav 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 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
    -----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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)