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:"Calibri",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:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US">Spot on! That’s solved the problem.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",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:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",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:"Calibri",sans-serif;color:#1F497D;mso-fareast-language:EN-US"><o:p> </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:"Calibri",sans-serif">From:</span></b><span lang="EN-US" style="font-size:11.0pt;font-family:"Calibri",sans-serif"> Václav Dohnal <
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> </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++ 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"><span lang="CS"><o:p> </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> </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> </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> <<a href="mailto:
info-ingres-bounces@lists.planetingres.org">
info-ingres-bounces@lists.planetingres.org</a>> On Behalf Of Martin Bowes<
Sent: Thursday, June 17, 2021 10:51 AM<br>
To: stelling <<a href="mailto:
Uwe.Stelling@bgr.de">
Uwe.Stelling@bgr.de</a>>; <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> </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> </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 = -L"/dbsystem/II/ingres/lib" -lingres -lrt<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS"><o:p> </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> </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 <<a href="mailto:
Uwe.Stelling@bgr.de"><span style="color:windowtext;text-decoration:none">
Uwe.Stelling@bgr.de</span></a>><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> </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> </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> </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> </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> </o:p></span></p>
<p class="MsoPlainText"><span lang="CS"> ... -L/opt/Actian/IngresII/ingres/lib -lingres ...<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS"><o:p> </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> </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">> Hi All,<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> In response to a strange situation where my programs had connected to
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> a database, set date_format 'dmy' and then returned dates in the
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> installation default multinational4 format I decided on a fresh
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> install of Perl DBI on this platform.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> The platform is: CentOS Linux release 7.9.2009 (Core)<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Can anyone explain the following?<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> perl Makefile.PL<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Configuring DBD::IngresII...<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Found Ingres at : "/dbsystem/II"<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> 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">> installed in /usr/lib64/perl5/vendor_perl/auto/DBI/<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Checking if your kit is complete...<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Looks good<o:p></o:p></span></p> <p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Warning (mostly harmless): No library found for -lingres<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Writing Makefile for DBD::IngresII<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> 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">> that message surprised me. Nonetheless it was flagged as mostly
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> harmless so I pressed on and the compilation seemed to complete. Then
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> 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">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> install_driver(IngresII) failed: Can't load
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> '/home/ingres/DBD/auto/DBD/IngresII/IngresII.so' for module<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> DBD::IngresII: /home/ingres/DBD/auto/DBD/IngresII/IngresII.so:
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> undefined<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> symbol: __gxx_personality_v0 at /usr/lib64/perl5/DynaLoader.pm line 190.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> at (eval 4) line 3.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Compilation failed in require at (eval 4) line 3.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Perhaps a required shared library or dll isn't installed where
<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> expected<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> at /home/ingres/scripts/perl/Classes/runDBI.pm line 336.<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Anyone?<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> Marty<o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <o:p></o:p></span></p>
<p class="MsoPlainText"><span lang="CS">> <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">_______________________________________________<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)