<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-2">
<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.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:"Calibri",sans-serif;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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="CS" link="#0563C1" vlink="#954F72" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoPlainText">Hi Marty,<o:p></o:p></p>
<p class="MsoPlainText">I<span lang="EN-US">'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:<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="EN-US">$opts{dynamic_lib} = { OTHERLDFLAGS => " $ld_options
<b>-lstdc++</b>" };<o:p></o:p></span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Hope this helps<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Vasek<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"><span lang="EN-US" style="mso-fareast-language:CS">-----Original Message-----<br>
From: info-ingres-bounces@lists.planetingres.org <info-ingres-bounces@lists.planetingres.org> On Behalf Of Martin Bowes<br>
Sent: Thursday, June 17, 2021 10:51 AM<br>
To: stelling <Uwe.Stelling@bgr.de>; info-ingres@lists.planetingres.org<br>
Subject: Re: [Info-ingres] Problem compiling perl DBI</span></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Hi Uwe<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">The Makefile has:<o:p></o:p></p>
<p class="MsoPlainText">OTHERLDFLAGS = -L"/dbsystem/II/ingres/lib" -lingres -lrt<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">That is the correct path for this installation.<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Marty<o:p></o:p></p>
<p class="MsoPlainText">-----Original Message-----<o:p></o:p></p>
<p class="MsoPlainText">From: stelling <<a href="mailto:Uwe.Stelling@bgr.de"><span style="color:windowtext;text-decoration:none">Uwe.Stelling@bgr.de</span></a>><o:p></o:p></p>
<p class="MsoPlainText">Sent: 17 June 2021 09:42<o:p></o:p></p>
<p class="MsoPlainText">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></p>
<p class="MsoPlainText">Subject: Re: [Info-ingres] Problem compiling perl DBI<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Hi,<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">is a option -L missing?<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">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></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">my makefiles use<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText"> ... -L/opt/Actian/IngresII/ingres/lib -lingres ...<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Uwe<o:p></o:p></p>
<p class="MsoPlainText"><o:p> </o:p></p>
<p class="MsoPlainText">Am 17.06.21 um 10:30 schrieb Martin Bowes:<o:p></o:p></p>
<p class="MsoPlainText">> Hi All,<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> In response to a strange situation where my programs had connected to
<o:p></o:p></p>
<p class="MsoPlainText">> a database, set date_format 'dmy' and then returned dates in the
<o:p></o:p></p>
<p class="MsoPlainText">> installation default multinational4 format I decided on a fresh
<o:p></o:p></p>
<p class="MsoPlainText">> install of Perl DBI on this platform.<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> The platform is: CentOS Linux release 7.9.2009 (Core)<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Can anyone explain the following?<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> perl Makefile.PL<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Configuring DBD::IngresII...<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Found Ingres at : "/dbsystem/II"<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Using DBI 1.627 (for perl 5.016003 on x86_64-linux-thread-multi)
<o:p></o:p></p>
<p class="MsoPlainText">> installed in /usr/lib64/perl5/vendor_perl/auto/DBI/<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Checking if your kit is complete...<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Looks good<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Warning (mostly harmless): No library found for -lingres<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Writing Makefile for DBD::IngresII<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> And $II_SYSTEM/ingres/lib/libingres.a is in existence on this host. So
<o:p></o:p></p>
<p class="MsoPlainText">> that message surprised me. Nonetheless it was flagged as mostly
<o:p></o:p></p>
<p class="MsoPlainText">> harmless so I pressed on and the compilation seemed to complete. Then
<o:p></o:p></p>
<p class="MsoPlainText">> I ran a test program which failed at the connect, generating the following:<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> install_driver(IngresII) failed: Can't load <o:p></o:p></p>
<p class="MsoPlainText">> '/home/ingres/DBD/auto/DBD/IngresII/IngresII.so' for module<o:p></o:p></p>
<p class="MsoPlainText">> DBD::IngresII: /home/ingres/DBD/auto/DBD/IngresII/IngresII.so:
<o:p></o:p></p>
<p class="MsoPlainText">> undefined<o:p></o:p></p>
<p class="MsoPlainText">> symbol: __gxx_personality_v0 at /usr/lib64/perl5/DynaLoader.pm line 190.<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> at (eval 4) line 3.<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Compilation failed in require at (eval 4) line 3.<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Perhaps a required shared library or dll isn't installed where
<o:p></o:p></p>
<p class="MsoPlainText">> expected<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> at /home/ingres/scripts/perl/Classes/runDBI.pm line 336.<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Anyone?<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> Marty<o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">> _______________________________________________<o:p></o:p></p>
<p class="MsoPlainText">> Info-ingres mailing list<o:p></o:p></p>
<p class="MsoPlainText">> <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></p>
<p class="MsoPlainText">> <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></p>
<p class="MsoPlainText">> <o:p></o:p></p>
<p class="MsoPlainText">_______________________________________________<o:p></o:p></p>
<p class="MsoPlainText">Info-ingres mailing list<o:p></o:p></p>
<p class="MsoPlainText"><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></p>
<p class="MsoPlainText"><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></p>
<p class="MsoPlainText">_______________________________________________<o:p></o:p></p>
<p class="MsoPlainText">Info-ingres mailing list<o:p></o:p></p>
<p class="MsoPlainText"><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></p>
<p class="MsoPlainText"><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></p>
</div>
</body>
</html>