perl.dbi.users http://www.nntp.perl.org/group/perl.dbi.users/ ... Copyright 1998-2014 perl.org Thu, 30 Oct 2014 22:20:38 +0000 ask@perl.org Re: First time DBI user crashing perl by Bruce Johnson <br/>On Oct 30, 2014, at 2:44 PM, Furst, Carl &lt;Carl.Furst@mlb.com&gt; wrote:<br/><br/>&gt; Is the driver you are using the one you used to install the DBD libs with?<br/>&gt; <br/>&gt; If you installed the DBD libs with one driver and then, say, upgraded the<br/>&gt; driver, you would have to re-install the DBD libs.<br/><br/>Also, I don&#146;t know about DB2, and less about Strawberry perl :-/ but I do know a very common issue with is bitness mismatch in the database vendor drivers; 32-bit database driver vs 64-bit perl and vice versa, although there are usually install time errors that will signal this.<br/><br/>-- <br/>Bruce Johnson<br/>University of Arizona<br/>College of Pharmacy<br/>Information Technology Group<br/><br/>Institutions do not have opinions, merely customs<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37024.html Thu, 30 Oct 2014 22:09:06 +0000 Re: First time DBI user crashing perl by Furst, Carl Is the driver you are using the one you used to install the DBD libs with? <br/> <br/>If you installed the DBD libs with one driver and then, say, upgraded the <br/>driver, you would have to re-install the DBD libs. <br/> <br/> <br/>Carl Furst <br/> <br/> <br/> <br/> <br/> <br/> <br/>On 10/30/14, 5:37 PM, &quot;Tim Bunce&quot; &lt;tim.bunce@pobox.com&gt; wrote: <br/> <br/>&gt;On Thu, Oct 30, 2014 at 03:33:05PM -0500, Peter Shabino wrote: <br/>&gt;&gt; Here is the environment variables: <br/>&gt;&gt; env DB2INSTANCE = DB2 <br/>&gt;&gt; env DB2LIB = C:/Program Files/IBM/SQLLIB/lib/Win32 <br/>&gt;&gt; env LD_LIBRARY_PATH = C:/Program Files/IBM/SQLLIB/lib/Win32 <br/>&gt;&gt; env LIBPATH = C:/Program Files/IBM/SQLLIB/lib/Win32 <br/>&gt;&gt; and the output from trace 15 <br/>&gt;&gt; New &#39;DBI::dr&#39; (for DBD::DB2::dr, parent=&#39;&#39;, id=undef) <br/>&gt;&gt; <br/>&gt;&gt;dbih_setup_handle(DBI::dr=HASH(0x2e4c7c0)=&gt;DBI::dr=HASH(0x2e4c868), <br/>&gt;&gt;DBD::DB2::dr, 0, Null!) <br/>&gt;&gt; dbih_make_com(Null!, 0, DBD::DB2::dr, 176, 0) thr#98a6f8 <br/>&gt;&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Err, Null!) <br/>&gt;&gt;SCALAR(0x2acff18) (already defined) <br/>&gt;&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), State, Null!) <br/>&gt;&gt;SCALAR(0x2e11358) (already defined) <br/>&gt;&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Errstr, Null!) <br/>&gt;&gt;SCALAR(0x2acff60) (already defined) <br/>&gt;&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), TraceLevel, Null!) 0 <br/>&gt;&gt;(already defined) <br/>&gt;&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), FetchHashKeyName, <br/>&gt;&gt;Null!) &#39;NAME&#39; (already defined) <br/>&gt;&gt; &lt;- install_driver= DBI::dr=HASH(0x2e4c7c0) <br/>&gt;&gt; &gt;&gt; data_sources DISPATCH (DBI::dr=HASH(0x2e4c7c0) rc1/3 @1 g3 <br/>&gt;&gt;ima801 pid#9476) at <br/>&gt;&gt; c:/strawberry/perl/site/lib/DBI.pm line 1066 via at db2.pl line 35 <br/>&gt;&gt; !! The warn &#39;0&#39; was CLEARED by call to data_sources method <br/>&gt;&gt; -&gt; data_sources for DBD::DB2::dr <br/>&gt;&gt;(DBI::dr=HASH(0x2e4c7c0)~0x2e4c868) thr#98a6f8 <br/>&gt;&gt; Any clues in there on what I have set up wrong? <br/>&gt; <br/>&gt;Nope. Sure looks like a crash within the DBD::DB2 driver. <br/>&gt;Hopefully someone here can help but you could also try <br/>&gt;http://www.software.ibm.com/data/db2/perl <br/>&gt; <br/>&gt;Tim. <br/>&gt; <br/>&gt;&gt; Here is my perl version <br/>&gt;&gt; This is perl 5, version 18, subversion 1 (v5.18.1) built for <br/>&gt;&gt;MSWin32-x64-multi-thread <br/>&gt;&gt; Thanks! <br/>&gt;&gt; Peter <br/>&gt;&gt; <br/>&gt;&gt; My projects: <br/>&gt;&gt; http://www.wire2wire.org/ <br/>&gt;&gt; &gt; Date: Thu, 30 Oct 2014 12:17:19 +0000 <br/>&gt;&gt; &gt; From: Tim.Bunce@pobox.com <br/>&gt;&gt; &gt; To: three18ti@gmail.com <br/>&gt;&gt; &gt; CC: wireb@hotmail.com; dbi-users@perl.org <br/>&gt;&gt; &gt; Subject: Re: First time DBI user crashing perl <br/>&gt;&gt; &gt; <br/>&gt;&gt; &gt; Turning on tracing is usually a good idea when odd things are <br/>&gt;&gt;happening. <br/>&gt;&gt; &gt; Read https://metacpan.org/pod/DBI#TRACING <br/>&gt;&gt; &gt; and set the DBI_TRACE environment variable. <br/>&gt;&gt; &gt; <br/>&gt;&gt; &gt; Tim. <br/>&gt;&gt; &gt; <br/>&gt;&gt; &gt; On Wed, Oct 29, 2014 at 09:56:27PM -0600, Jon wrote: <br/>&gt;&gt; &gt; &gt; Hello Peter, <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Well, that&#39;s kinda what I figured but never hurts try for the <br/>&gt;&gt;easy answer. <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; I cleaned up your test script a bit. <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Can you give this version a try: <br/>&gt;&gt;[1]https://gist.github.com/three18ti/c37587ef7d5fb9ee5748 <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; I&#39;m downloading DB2 as we speak, but I wanted to ask for your <br/>&gt;&gt;DB2_HOME environment variable. In your <br/>&gt;&gt; &gt; &gt; instructions it has you set it, but the instructions are clearly <br/>&gt;&gt;for a linux server, what did you do <br/>&gt;&gt; on <br/>&gt;&gt; &gt; &gt; your windows server? <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Honestly, I have very limited DB2 experience, so it&#39;s kinda the <br/>&gt;&gt;blind leading the blind here. I&#39;m <br/>&gt;&gt; &gt; &gt; really just curious myself. you&#39;re more than welcome to ignore <br/>&gt;&gt;me and wait for one of the more <br/>&gt;&gt; &gt; &gt; experienced guys :) <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Best Regards, <br/>&gt;&gt; &gt; &gt; Jon A <br/>&gt;&gt; &gt; &gt; On Wed, Oct 29, 2014 at 8:42 PM, Peter Shabino <br/>&gt;&gt;&lt;[2]wireb@hotmail.com&gt; wrote: <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; I am running it from a command prompt and I am getting some of <br/>&gt;&gt;the output so perl is running fine. <br/>&gt;&gt; &gt; &gt; Just looks like any command that trys and uses the DB2 interface <br/>&gt;&gt;causes a crash. <br/>&gt;&gt; &gt; &gt; Thanks, <br/>&gt;&gt; &gt; &gt; Peter <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; My projects: <br/>&gt;&gt; &gt; &gt; [3]http://www.wire2wire.org/ <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; <br/>&gt;&gt;------------------------------------------------------------------------- <br/>&gt;&gt;------------------------------- <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Date: Wed, 29 Oct 2014 20:26:15 -0600 <br/>&gt;&gt; &gt; &gt; Subject: RE: First time DBI user crashing perl <br/>&gt;&gt; &gt; &gt; From: [4]three18ti@gmail.com <br/>&gt;&gt; &gt; &gt; To: [5]wireb@hotmail.com <br/>&gt;&gt; &gt; &gt; CC: [6]dbi-users@perl.org <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Hello Peter, <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; How are you invoking the script? Do you have a perl script that <br/>&gt;&gt;you double click? <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; If so, can you try opening a command/powershell window and <br/>&gt;&gt;running your program? You&#39;ll likely have <br/>&gt;&gt; to <br/>&gt;&gt; &gt; &gt; specify the full path to the perl binary then pass your script <br/>&gt;&gt;as the first parameter. <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; E.g.: \strawberry\perl\bin\perl.exe [7]my_script.pl <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; I have not encountered this particular problem with db2 but this <br/>&gt;&gt;is my first step when trying to get <br/>&gt;&gt; &gt; &gt; one of my scripts to run in Windows (I&#39;m a Linux enginner by the <br/>&gt;&gt;Windows engineers steal a lot of my <br/>&gt;&gt; &gt; &gt; applications), perhaps someone has more specific experience than <br/>&gt;&gt;myself. <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Best Regards, <br/>&gt;&gt; &gt; &gt; Jon A <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; On Oct 29, 2014 5:50 PM, &quot;Peter Shabino&quot; &lt;[8]wireb@hotmail.com&gt; <br/>&gt;&gt;wrote: <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Try this again I apparently found a keyboard shortcut to send <br/>&gt;&gt;the message in hotmail...... <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Trying to set up a connection to a remote DB2 server in perl to <br/>&gt;&gt;query some data. <br/>&gt;&gt; &gt; &gt; Followed the directions here: <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt;[9]http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335 <br/>&gt;&gt; &gt; &gt; Then searching the web I came up with this chunk of code: <br/>&gt;&gt; &gt; &gt; use warnings; <br/>&gt;&gt; &gt; &gt; use strict; <br/>&gt;&gt; &gt; &gt; use DBI; <br/>&gt;&gt; &gt; &gt; use DBD::DB2; <br/>&gt;&gt; &gt; &gt; print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;); <br/>&gt;&gt; &gt; &gt; print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;); <br/>&gt;&gt; &gt; &gt; print(&quot;Perl Version = &quot;,$],&quot;\n&quot;); <br/>&gt;&gt; &gt; &gt; print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;); <br/>&gt;&gt; &gt; &gt; print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;); <br/>&gt;&gt; &gt; &gt; print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;); <br/>&gt;&gt; &gt; &gt; my @driver_names = DBI-&gt;available_drivers; <br/>&gt;&gt; &gt; &gt; print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;); <br/>&gt;&gt; &gt; &gt; print(&quot;I am here\n&quot;); <br/>&gt;&gt; &gt; &gt; my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;); <br/>&gt;&gt; &gt; &gt; print(@dataSources,&quot;\n&quot;); <br/>&gt;&gt; &gt; &gt; print(&quot;I am there\n&quot;); <br/>&gt;&gt; &gt; &gt; exit(0); <br/>&gt;&gt; &gt; &gt; When I run this I get a popup that says the &quot;Perl interpreter <br/>&gt;&gt;has stopped working&quot; and a button to <br/>&gt;&gt; &gt; &gt; close the program. <br/>&gt;&gt; &gt; &gt; on the console I get: <br/>&gt;&gt; &gt; &gt; Operating System = MSWin32 <br/>&gt;&gt; &gt; &gt; Perl Binary = c:\strawberry\perl\bin\perl.exe <br/>&gt;&gt; &gt; &gt; Perl Version = 5.018001 <br/>&gt;&gt; &gt; &gt; DBI Version = 1.631 <br/>&gt;&gt; &gt; &gt; DBD::DB2 Version = 1.85 <br/>&gt;&gt; &gt; &gt; env = DB2 <br/>&gt;&gt; &gt; &gt; ADO <br/>&gt;&gt; &gt; &gt; DB2 <br/>&gt;&gt; &gt; &gt; DBM <br/>&gt;&gt; &gt; &gt; ExampleP <br/>&gt;&gt; &gt; &gt; File <br/>&gt;&gt; &gt; &gt; Gofer <br/>&gt;&gt; &gt; &gt; ODBC <br/>&gt;&gt; &gt; &gt; Pg <br/>&gt;&gt; &gt; &gt; Proxy <br/>&gt;&gt; &gt; &gt; SQLite <br/>&gt;&gt; &gt; &gt; Sponge <br/>&gt;&gt; &gt; &gt; mysql <br/>&gt;&gt; &gt; &gt; I am here <br/>&gt;&gt; &gt; &gt; So the failure is when I try and get the DB2 data sources... <br/>&gt;&gt; &gt; &gt; Just have no idea even where to start looking for the issue <br/>&gt;&gt;since there is no error message. Is <br/>&gt;&gt; &gt; &gt; there a log file with more information on what might have died? <br/>&gt;&gt; &gt; &gt; Thanks, <br/>&gt;&gt; &gt; &gt; Peter <br/>&gt;&gt; &gt; &gt; My projects: <br/>&gt;&gt; &gt; &gt; [10]http://www.wire2wire.org/ <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; References <br/>&gt;&gt; &gt; &gt; <br/>&gt;&gt; &gt; &gt; Visible links <br/>&gt;&gt; &gt; &gt; 1. https://gist.github.com/three18ti/c37587ef7d5fb9ee5748 <br/>&gt;&gt; &gt; &gt; 2. mailto:wireb@hotmail.com <br/>&gt;&gt; &gt; &gt; 3. http://www.wire2wire.org/ <br/>&gt;&gt; &gt; &gt; 4. mailto:three18ti@gmail.com <br/>&gt;&gt; &gt; &gt; 5. mailto:wireb@hotmail.com <br/>&gt;&gt; &gt; &gt; 6. mailto:dbi-users@perl.org <br/>&gt;&gt; &gt; &gt; 7. http://my_script.pl/ <br/>&gt;&gt; &gt; &gt; 8. mailto:wireb@hotmail.com <br/>&gt;&gt; &gt; &gt; 9. <br/>&gt;&gt;http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335 <br/>&gt;&gt; &gt; &gt; 10. http://www.wire2wire.org/ <br/> <br/>********************************************************** <br/> <br/>MLB.com: Where Baseball is Always On<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37023.html Thu, 30 Oct 2014 21:45:02 +0000 Re: First time DBI user crashing perl by Tim Bunce On Thu, Oct 30, 2014 at 03:33:05PM -0500, Peter Shabino wrote:<br/>&gt; Here is the environment variables:<br/>&gt; env DB2INSTANCE = DB2<br/>&gt; env DB2LIB = C:/Program Files/IBM/SQLLIB/lib/Win32<br/>&gt; env LD_LIBRARY_PATH = C:/Program Files/IBM/SQLLIB/lib/Win32<br/>&gt; env LIBPATH = C:/Program Files/IBM/SQLLIB/lib/Win32<br/>&gt; and the output from trace 15<br/>&gt; New &#39;DBI::dr&#39; (for DBD::DB2::dr, parent=&#39;&#39;, id=undef)<br/>&gt; dbih_setup_handle(DBI::dr=HASH(0x2e4c7c0)=&gt;DBI::dr=HASH(0x2e4c868), DBD::DB2::dr, 0, Null!)<br/>&gt; dbih_make_com(Null!, 0, DBD::DB2::dr, 176, 0) thr#98a6f8<br/>&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Err, Null!) SCALAR(0x2acff18) (already defined)<br/>&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), State, Null!) SCALAR(0x2e11358) (already defined)<br/>&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Errstr, Null!) SCALAR(0x2acff60) (already defined)<br/>&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), TraceLevel, Null!) 0 (already defined)<br/>&gt; dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), FetchHashKeyName, Null!) &#39;NAME&#39; (already defined)<br/>&gt; &lt;- install_driver= DBI::dr=HASH(0x2e4c7c0)<br/>&gt; &gt;&gt; data_sources DISPATCH (DBI::dr=HASH(0x2e4c7c0) rc1/3 @1 g3 ima801 pid#9476) at<br/>&gt; c:/strawberry/perl/site/lib/DBI.pm line 1066 via at db2.pl line 35<br/>&gt; !! The warn &#39;0&#39; was CLEARED by call to data_sources method<br/>&gt; -&gt; data_sources for DBD::DB2::dr (DBI::dr=HASH(0x2e4c7c0)~0x2e4c868) thr#98a6f8<br/>&gt; Any clues in there on what I have set up wrong?<br/><br/>Nope. Sure looks like a crash within the DBD::DB2 driver.<br/>Hopefully someone here can help but you could also try<br/>http://www.software.ibm.com/data/db2/perl<br/><br/>Tim.<br/><br/>&gt; Here is my perl version<br/>&gt; This is perl 5, version 18, subversion 1 (v5.18.1) built for MSWin32-x64-multi-thread<br/>&gt; Thanks!<br/>&gt; Peter<br/>&gt; <br/>&gt; My projects:<br/>&gt; http://www.wire2wire.org/<br/>&gt; &gt; Date: Thu, 30 Oct 2014 12:17:19 +0000<br/>&gt; &gt; From: Tim.Bunce@pobox.com<br/>&gt; &gt; To: three18ti@gmail.com<br/>&gt; &gt; CC: wireb@hotmail.com; dbi-users@perl.org<br/>&gt; &gt; Subject: Re: First time DBI user crashing perl<br/>&gt; &gt;<br/>&gt; &gt; Turning on tracing is usually a good idea when odd things are happening.<br/>&gt; &gt; Read https://metacpan.org/pod/DBI#TRACING<br/>&gt; &gt; and set the DBI_TRACE environment variable.<br/>&gt; &gt;<br/>&gt; &gt; Tim.<br/>&gt; &gt;<br/>&gt; &gt; On Wed, Oct 29, 2014 at 09:56:27PM -0600, Jon wrote:<br/>&gt; &gt; &gt; Hello Peter,<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Well, that&#39;s kinda what I figured but never hurts try for the easy answer.<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; I cleaned up your test script a bit.<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Can you give this version a try: [1]https://gist.github.com/three18ti/c37587ef7d5fb9ee5748<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; I&#39;m downloading DB2 as we speak, but I wanted to ask for your DB2_HOME environment variable. In your<br/>&gt; &gt; &gt; instructions it has you set it, but the instructions are clearly for a linux server, what did you do<br/>&gt; on<br/>&gt; &gt; &gt; your windows server?<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Honestly, I have very limited DB2 experience, so it&#39;s kinda the blind leading the blind here. I&#39;m<br/>&gt; &gt; &gt; really just curious myself. you&#39;re more than welcome to ignore me and wait for one of the more<br/>&gt; &gt; &gt; experienced guys :)<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Best Regards,<br/>&gt; &gt; &gt; Jon A<br/>&gt; &gt; &gt; On Wed, Oct 29, 2014 at 8:42 PM, Peter Shabino &lt;[2]wireb@hotmail.com&gt; wrote:<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; I am running it from a command prompt and I am getting some of the output so perl is running fine.<br/>&gt; &gt; &gt; Just looks like any command that trys and uses the DB2 interface causes a crash.<br/>&gt; &gt; &gt; Thanks,<br/>&gt; &gt; &gt; Peter<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; My projects:<br/>&gt; &gt; &gt; [3]http://www.wire2wire.org/<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt;<br/>&gt; --------------------------------------------------------------------------------------------------------<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Date: Wed, 29 Oct 2014 20:26:15 -0600<br/>&gt; &gt; &gt; Subject: RE: First time DBI user crashing perl<br/>&gt; &gt; &gt; From: [4]three18ti@gmail.com<br/>&gt; &gt; &gt; To: [5]wireb@hotmail.com<br/>&gt; &gt; &gt; CC: [6]dbi-users@perl.org<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Hello Peter,<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; How are you invoking the script? Do you have a perl script that you double click?<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; If so, can you try opening a command/powershell window and running your program? You&#39;ll likely have<br/>&gt; to<br/>&gt; &gt; &gt; specify the full path to the perl binary then pass your script as the first parameter.<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; E.g.: \strawberry\perl\bin\perl.exe [7]my_script.pl<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; I have not encountered this particular problem with db2 but this is my first step when trying to get<br/>&gt; &gt; &gt; one of my scripts to run in Windows (I&#39;m a Linux enginner by the Windows engineers steal a lot of my<br/>&gt; &gt; &gt; applications), perhaps someone has more specific experience than myself.<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Best Regards,<br/>&gt; &gt; &gt; Jon A<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; On Oct 29, 2014 5:50 PM, &quot;Peter Shabino&quot; &lt;[8]wireb@hotmail.com&gt; wrote:<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Try this again I apparently found a keyboard shortcut to send the message in hotmail......<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Trying to set up a connection to a remote DB2 server in perl to query some data.<br/>&gt; &gt; &gt; Followed the directions here:<br/>&gt; &gt; &gt; [9]http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt; &gt; &gt; Then searching the web I came up with this chunk of code:<br/>&gt; &gt; &gt; use warnings;<br/>&gt; &gt; &gt; use strict;<br/>&gt; &gt; &gt; use DBI;<br/>&gt; &gt; &gt; use DBD::DB2;<br/>&gt; &gt; &gt; print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;);<br/>&gt; &gt; &gt; print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;);<br/>&gt; &gt; &gt; print(&quot;Perl Version = &quot;,$],&quot;\n&quot;);<br/>&gt; &gt; &gt; print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;);<br/>&gt; &gt; &gt; print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;);<br/>&gt; &gt; &gt; print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;);<br/>&gt; &gt; &gt; my @driver_names = DBI-&gt;available_drivers;<br/>&gt; &gt; &gt; print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;);<br/>&gt; &gt; &gt; print(&quot;I am here\n&quot;);<br/>&gt; &gt; &gt; my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;);<br/>&gt; &gt; &gt; print(@dataSources,&quot;\n&quot;);<br/>&gt; &gt; &gt; print(&quot;I am there\n&quot;);<br/>&gt; &gt; &gt; exit(0);<br/>&gt; &gt; &gt; When I run this I get a popup that says the &quot;Perl interpreter has stopped working&quot; and a button to<br/>&gt; &gt; &gt; close the program.<br/>&gt; &gt; &gt; on the console I get:<br/>&gt; &gt; &gt; Operating System = MSWin32<br/>&gt; &gt; &gt; Perl Binary = c:\strawberry\perl\bin\perl.exe<br/>&gt; &gt; &gt; Perl Version = 5.018001<br/>&gt; &gt; &gt; DBI Version = 1.631<br/>&gt; &gt; &gt; DBD::DB2 Version = 1.85<br/>&gt; &gt; &gt; env = DB2<br/>&gt; &gt; &gt; ADO<br/>&gt; &gt; &gt; DB2<br/>&gt; &gt; &gt; DBM<br/>&gt; &gt; &gt; ExampleP<br/>&gt; &gt; &gt; File<br/>&gt; &gt; &gt; Gofer<br/>&gt; &gt; &gt; ODBC<br/>&gt; &gt; &gt; Pg<br/>&gt; &gt; &gt; Proxy<br/>&gt; &gt; &gt; SQLite<br/>&gt; &gt; &gt; Sponge<br/>&gt; &gt; &gt; mysql<br/>&gt; &gt; &gt; I am here<br/>&gt; &gt; &gt; So the failure is when I try and get the DB2 data sources...<br/>&gt; &gt; &gt; Just have no idea even where to start looking for the issue since there is no error message. Is<br/>&gt; &gt; &gt; there a log file with more information on what might have died?<br/>&gt; &gt; &gt; Thanks,<br/>&gt; &gt; &gt; Peter<br/>&gt; &gt; &gt; My projects:<br/>&gt; &gt; &gt; [10]http://www.wire2wire.org/<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; References<br/>&gt; &gt; &gt;<br/>&gt; &gt; &gt; Visible links<br/>&gt; &gt; &gt; 1. https://gist.github.com/three18ti/c37587ef7d5fb9ee5748<br/>&gt; &gt; &gt; 2. mailto:wireb@hotmail.com<br/>&gt; &gt; &gt; 3. http://www.wire2wire.org/<br/>&gt; &gt; &gt; 4. mailto:three18ti@gmail.com<br/>&gt; &gt; &gt; 5. mailto:wireb@hotmail.com<br/>&gt; &gt; &gt; 6. mailto:dbi-users@perl.org<br/>&gt; &gt; &gt; 7. http://my_script.pl/<br/>&gt; &gt; &gt; 8. mailto:wireb@hotmail.com<br/>&gt; &gt; &gt; 9. http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt; &gt; &gt; 10. http://www.wire2wire.org/<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37022.html Thu, 30 Oct 2014 21:38:26 +0000 RE: First time DBI user crashing perl by Peter Shabino Here is the environment variables: <br/>env DB2INSTANCE = DB2env DB2LIB = C:/Program Files/IBM/SQLLIB/lib/Win32env LD_LIBRARY_PATH = C:/Program Files/IBM/SQLLIB/lib/Win32env LIBPATH = C:/Program Files/IBM/SQLLIB/lib/Win32<br/>and the output from trace 15<br/> New &#39;DBI::dr&#39; (for DBD::DB2::dr, parent=&#39;&#39;, id=undef) dbih_setup_handle(DBI::dr=HASH(0x2e4c7c0)=&gt;DBI::dr=HASH(0x2e4c868), DBD::DB2::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::DB2::dr, 176, 0) thr#98a6f8 dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Err, Null!) SCALAR(0x2acff18) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), State, Null!) SCALAR(0x2e11358) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), Errstr, Null!) SCALAR(0x2acff60) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x2e4c868), FetchHashKeyName, Null!) &#39;NAME&#39; (already defined) &lt;- install_driver= DBI::dr=HASH(0x2e4c7c0) &gt;&gt; data_sources DISPATCH (DBI::dr=HASH(0x2e4c7c0) rc1/3 @1 g3 ima801 pid#9476) at c:/strawberry/perl/site/lib/DBI.pm line 1066 via at db2.pl line 35 !! The warn &#39;0&#39; was CLEARED by call to data_sources method -&gt; data_sources for DBD::DB2::dr (DBI::dr=HASH(0x2e4c7c0)~0x2e4c868) thr#98a6f8<br/>Any clues in there on what I have set up wrong?<br/>Here is my perl versionThis is perl 5, version 18, subversion 1 (v5.18.1) built for MSWin32-x64-multi-thread<br/><br/>Thanks!Peter<br/><br/>My projects:<br/>http://www.wire2wire.org/<br/><br/><br/>&gt; Date: Thu, 30 Oct 2014 12:17:19 +0000<br/>&gt; From: Tim.Bunce@pobox.com<br/>&gt; To: three18ti@gmail.com<br/>&gt; CC: wireb@hotmail.com; dbi-users@perl.org<br/>&gt; Subject: Re: First time DBI user crashing perl<br/>&gt; <br/>&gt; Turning on tracing is usually a good idea when odd things are happening.<br/>&gt; Read https://metacpan.org/pod/DBI#TRACING<br/>&gt; and set the DBI_TRACE environment variable.<br/>&gt; <br/>&gt; Tim.<br/>&gt; <br/>&gt; On Wed, Oct 29, 2014 at 09:56:27PM -0600, Jon wrote:<br/>&gt; &gt; Hello Peter,<br/>&gt; &gt; <br/>&gt; &gt; Well, that&#39;s kinda what I figured but never hurts try for the easy answer.<br/>&gt; &gt; <br/>&gt; &gt; I cleaned up your test script a bit. <br/>&gt; &gt; <br/>&gt; &gt; Can you give this version a try: [1]https://gist.github.com/three18ti/c37587ef7d5fb9ee5748<br/>&gt; &gt; <br/>&gt; &gt; I&#39;m downloading DB2 as we speak, but I wanted to ask for your DB2_HOME environment variable. In your<br/>&gt; &gt; instructions it has you set it, but the instructions are clearly for a linux server, what did you do on<br/>&gt; &gt; your windows server?<br/>&gt; &gt; <br/>&gt; &gt; Honestly, I have very limited DB2 experience, so it&#39;s kinda the blind leading the blind here. I&#39;m<br/>&gt; &gt; really just curious myself. you&#39;re more than welcome to ignore me and wait for one of the more<br/>&gt; &gt; experienced guys :)<br/>&gt; &gt; <br/>&gt; &gt; Best Regards,<br/>&gt; &gt; Jon A<br/>&gt; &gt; On Wed, Oct 29, 2014 at 8:42 PM, Peter Shabino &lt;[2]wireb@hotmail.com&gt; wrote:<br/>&gt; &gt; <br/>&gt; &gt; I am running it from a command prompt and I am getting some of the output so perl is running fine.<br/>&gt; &gt; Just looks like any command that trys and uses the DB2 interface causes a crash. <br/>&gt; &gt; Thanks,<br/>&gt; &gt; Peter<br/>&gt; &gt; <br/>&gt; &gt; My projects:<br/>&gt; &gt; [3]http://www.wire2wire.org/<br/>&gt; &gt; <br/>&gt; &gt; --------------------------------------------------------------------------------------------------------<br/>&gt; &gt; <br/>&gt; &gt; Date: Wed, 29 Oct 2014 20:26:15 -0600<br/>&gt; &gt; Subject: RE: First time DBI user crashing perl<br/>&gt; &gt; From: [4]three18ti@gmail.com<br/>&gt; &gt; To: [5]wireb@hotmail.com<br/>&gt; &gt; CC: [6]dbi-users@perl.org<br/>&gt; &gt; <br/>&gt; &gt; Hello Peter,<br/>&gt; &gt; <br/>&gt; &gt; How are you invoking the script? Do you have a perl script that you double click?<br/>&gt; &gt; <br/>&gt; &gt; If so, can you try opening a command/powershell window and running your program? You&#39;ll likely have to<br/>&gt; &gt; specify the full path to the perl binary then pass your script as the first parameter.<br/>&gt; &gt; <br/>&gt; &gt; E.g.: \strawberry\perl\bin\perl.exe [7]my_script.pl<br/>&gt; &gt; <br/>&gt; &gt; I have not encountered this particular problem with db2 but this is my first step when trying to get<br/>&gt; &gt; one of my scripts to run in Windows (I&#39;m a Linux enginner by the Windows engineers steal a lot of my<br/>&gt; &gt; applications), perhaps someone has more specific experience than myself.<br/>&gt; &gt; <br/>&gt; &gt; Best Regards,<br/>&gt; &gt; Jon A<br/>&gt; &gt; <br/>&gt; &gt; On Oct 29, 2014 5:50 PM, &quot;Peter Shabino&quot; &lt;[8]wireb@hotmail.com&gt; wrote:<br/>&gt; &gt; <br/>&gt; &gt; Try this again I apparently found a keyboard shortcut to send the message in hotmail......<br/>&gt; &gt; <br/>&gt; &gt; Trying to set up a connection to a remote DB2 server in perl to query some data. <br/>&gt; &gt; Followed the directions here:<br/>&gt; &gt; [9]http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt; &gt; Then searching the web I came up with this chunk of code:<br/>&gt; &gt; use warnings;<br/>&gt; &gt; use strict;<br/>&gt; &gt; use DBI;<br/>&gt; &gt; use DBD::DB2;<br/>&gt; &gt; print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;);<br/>&gt; &gt; print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;);<br/>&gt; &gt; print(&quot;Perl Version = &quot;,$],&quot;\n&quot;);<br/>&gt; &gt; print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;);<br/>&gt; &gt; print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;);<br/>&gt; &gt; print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;);<br/>&gt; &gt; my @driver_names = DBI-&gt;available_drivers;<br/>&gt; &gt; print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;);<br/>&gt; &gt; print(&quot;I am here\n&quot;);<br/>&gt; &gt; my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;);<br/>&gt; &gt; print(@dataSources,&quot;\n&quot;);<br/>&gt; &gt; print(&quot;I am there\n&quot;);<br/>&gt; &gt; exit(0);<br/>&gt; &gt; When I run this I get a popup that says the &quot;Perl interpreter has stopped working&quot; and a button to<br/>&gt; &gt; close the program. <br/>&gt; &gt; on the console I get:<br/>&gt; &gt; Operating System = MSWin32<br/>&gt; &gt; Perl Binary = c:\strawberry\perl\bin\perl.exe<br/>&gt; &gt; Perl Version = 5.018001<br/>&gt; &gt; DBI Version = 1.631<br/>&gt; &gt; DBD::DB2 Version = 1.85<br/>&gt; &gt; env = DB2<br/>&gt; &gt; ADO<br/>&gt; &gt; DB2<br/>&gt; &gt; DBM<br/>&gt; &gt; ExampleP<br/>&gt; &gt; File<br/>&gt; &gt; Gofer<br/>&gt; &gt; ODBC<br/>&gt; &gt; Pg<br/>&gt; &gt; Proxy<br/>&gt; &gt; SQLite<br/>&gt; &gt; Sponge<br/>&gt; &gt; mysql<br/>&gt; &gt; I am here<br/>&gt; &gt; So the failure is when I try and get the DB2 data sources... <br/>&gt; &gt; Just have no idea even where to start looking for the issue since there is no error message. Is<br/>&gt; &gt; there a log file with more information on what might have died?<br/>&gt; &gt; Thanks,<br/>&gt; &gt; Peter<br/>&gt; &gt; My projects:<br/>&gt; &gt; [10]http://www.wire2wire.org/<br/>&gt; &gt; <br/>&gt; &gt; References<br/>&gt; &gt; <br/>&gt; &gt; Visible links<br/>&gt; &gt; 1. https://gist.github.com/three18ti/c37587ef7d5fb9ee5748<br/>&gt; &gt; 2. mailto:wireb@hotmail.com<br/>&gt; &gt; 3. http://www.wire2wire.org/<br/>&gt; &gt; 4. mailto:three18ti@gmail.com<br/>&gt; &gt; 5. mailto:wireb@hotmail.com<br/>&gt; &gt; 6. mailto:dbi-users@perl.org<br/>&gt; &gt; 7. http://my_script.pl/<br/>&gt; &gt; 8. mailto:wireb@hotmail.com<br/>&gt; &gt; 9. http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt; &gt; 10. http://www.wire2wire.org/<br/> <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37021.html Thu, 30 Oct 2014 20:33:13 +0000 Re: First time DBI user crashing perl by Tim Bunce Turning on tracing is usually a good idea when odd things are happening.<br/>Read https://metacpan.org/pod/DBI#TRACING<br/>and set the DBI_TRACE environment variable.<br/><br/>Tim.<br/><br/>On Wed, Oct 29, 2014 at 09:56:27PM -0600, Jon wrote:<br/>&gt; Hello Peter,<br/>&gt; <br/>&gt; Well, that&#39;s kinda what I figured but never hurts try for the easy answer.<br/>&gt; <br/>&gt; I cleaned up your test script a bit. <br/>&gt; <br/>&gt; Can you give this version a try: [1]https://gist.github.com/three18ti/c37587ef7d5fb9ee5748<br/>&gt; <br/>&gt; I&#39;m downloading DB2 as we speak, but I wanted to ask for your DB2_HOME environment variable. In your<br/>&gt; instructions it has you set it, but the instructions are clearly for a linux server, what did you do on<br/>&gt; your windows server?<br/>&gt; <br/>&gt; Honestly, I have very limited DB2 experience, so it&#39;s kinda the blind leading the blind here. I&#39;m<br/>&gt; really just curious myself. you&#39;re more than welcome to ignore me and wait for one of the more<br/>&gt; experienced guys :)<br/>&gt; <br/>&gt; Best Regards,<br/>&gt; Jon A<br/>&gt; On Wed, Oct 29, 2014 at 8:42 PM, Peter Shabino &lt;[2]wireb@hotmail.com&gt; wrote:<br/>&gt; <br/>&gt; I am running it from a command prompt and I am getting some of the output so perl is running fine.<br/>&gt; Just looks like any command that trys and uses the DB2 interface causes a crash. <br/>&gt; Thanks,<br/>&gt; Peter<br/>&gt; <br/>&gt; My projects:<br/>&gt; [3]http://www.wire2wire.org/<br/>&gt; <br/>&gt; --------------------------------------------------------------------------------------------------------<br/>&gt; <br/>&gt; Date: Wed, 29 Oct 2014 20:26:15 -0600<br/>&gt; Subject: RE: First time DBI user crashing perl<br/>&gt; From: [4]three18ti@gmail.com<br/>&gt; To: [5]wireb@hotmail.com<br/>&gt; CC: [6]dbi-users@perl.org<br/>&gt; <br/>&gt; Hello Peter,<br/>&gt; <br/>&gt; How are you invoking the script? Do you have a perl script that you double click?<br/>&gt; <br/>&gt; If so, can you try opening a command/powershell window and running your program? You&#39;ll likely have to<br/>&gt; specify the full path to the perl binary then pass your script as the first parameter.<br/>&gt; <br/>&gt; E.g.: \strawberry\perl\bin\perl.exe [7]my_script.pl<br/>&gt; <br/>&gt; I have not encountered this particular problem with db2 but this is my first step when trying to get<br/>&gt; one of my scripts to run in Windows (I&#39;m a Linux enginner by the Windows engineers steal a lot of my<br/>&gt; applications), perhaps someone has more specific experience than myself.<br/>&gt; <br/>&gt; Best Regards,<br/>&gt; Jon A<br/>&gt; <br/>&gt; On Oct 29, 2014 5:50 PM, &quot;Peter Shabino&quot; &lt;[8]wireb@hotmail.com&gt; wrote:<br/>&gt; <br/>&gt; Try this again I apparently found a keyboard shortcut to send the message in hotmail......<br/>&gt; <br/>&gt; Trying to set up a connection to a remote DB2 server in perl to query some data. <br/>&gt; Followed the directions here:<br/>&gt; [9]http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt; Then searching the web I came up with this chunk of code:<br/>&gt; use warnings;<br/>&gt; use strict;<br/>&gt; use DBI;<br/>&gt; use DBD::DB2;<br/>&gt; print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;);<br/>&gt; print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;);<br/>&gt; print(&quot;Perl Version = &quot;,$],&quot;\n&quot;);<br/>&gt; print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;);<br/>&gt; print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;);<br/>&gt; print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;);<br/>&gt; my @driver_names = DBI-&gt;available_drivers;<br/>&gt; print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;);<br/>&gt; print(&quot;I am here\n&quot;);<br/>&gt; my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;);<br/>&gt; print(@dataSources,&quot;\n&quot;);<br/>&gt; print(&quot;I am there\n&quot;);<br/>&gt; exit(0);<br/>&gt; When I run this I get a popup that says the &quot;Perl interpreter has stopped working&quot; and a button to<br/>&gt; close the program. <br/>&gt; on the console I get:<br/>&gt; Operating System = MSWin32<br/>&gt; Perl Binary = c:\strawberry\perl\bin\perl.exe<br/>&gt; Perl Version = 5.018001<br/>&gt; DBI Version = 1.631<br/>&gt; DBD::DB2 Version = 1.85<br/>&gt; env = DB2<br/>&gt; ADO<br/>&gt; DB2<br/>&gt; DBM<br/>&gt; ExampleP<br/>&gt; File<br/>&gt; Gofer<br/>&gt; ODBC<br/>&gt; Pg<br/>&gt; Proxy<br/>&gt; SQLite<br/>&gt; Sponge<br/>&gt; mysql<br/>&gt; I am here<br/>&gt; So the failure is when I try and get the DB2 data sources... <br/>&gt; Just have no idea even where to start looking for the issue since there is no error message. Is<br/>&gt; there a log file with more information on what might have died?<br/>&gt; Thanks,<br/>&gt; Peter<br/>&gt; My projects:<br/>&gt; [10]http://www.wire2wire.org/<br/>&gt; <br/>&gt; References<br/>&gt; <br/>&gt; Visible links<br/>&gt; 1. https://gist.github.com/three18ti/c37587ef7d5fb9ee5748<br/>&gt; 2. mailto:wireb@hotmail.com<br/>&gt; 3. http://www.wire2wire.org/<br/>&gt; 4. mailto:three18ti@gmail.com<br/>&gt; 5. mailto:wireb@hotmail.com<br/>&gt; 6. mailto:dbi-users@perl.org<br/>&gt; 7. http://my_script.pl/<br/>&gt; 8. mailto:wireb@hotmail.com<br/>&gt; 9. http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt; 10. http://www.wire2wire.org/<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37020.html Thu, 30 Oct 2014 12:17:38 +0000 DBI - DBD - mysql on Yosemite by Michael Ahrweiler Hi<br/><br/>&gt; Am 29.10.2014 um 10:49 schrieb Jens Rehsack &lt;rehsack@gmail.com &lt;mailto:rehsack@gmail.com&gt;&gt;:<br/>&gt; Am 28.10.2014 um 17:45 schrieb Michael Ahrweiler &lt;ma@versale.de &lt;mailto:ma@versale.de&gt;&gt;:<br/>&gt; <br/>&gt;&gt; Hello<br/>&gt; Hi Michael,<br/>&gt; <br/>&gt;&gt; It is not, that it does not function.<br/>&gt;&gt; It did. <br/>&gt;&gt; mysql was just not starting at boot time. So I updated. Since then, it&rsquo;s a mess.<br/>&gt;&gt; <br/>&gt;&gt; After installing the latest mysql community-version 5.6.21<br/>&gt;&gt; On &quot;make test&quot; of DBD I get:<br/>&gt;&gt; <br/>&gt;&gt; # Failed test &#39;use DBD::mysql;&#39;<br/>&gt;&gt; # at t/00base.t line 18.<br/>&gt;&gt; # Tried to use &#39;DBD::mysql&#39;.<br/>&gt;&gt; # Error: Can&#39;t load &#39;/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle&lsquo;<br/>&gt;&gt; for module DBD::mysql: dlopen(/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle, 2):<br/>&gt;&gt; Library not loaded: libmysqlclient.18.dylib<br/>&gt; <br/>&gt; Where is this libmysqlclient.18.dylib from?<br/>see answer to otool-question<br/><br/>&gt; What is /temp?<br/>it is a near root-level folder from where I install those things<br/>As I said, this error came at &quot;make test&ldquo; but is similar to what the web pages will say when I install anyway.<br/><br/>&gt; What says &#39;otool -L /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle&lsquo;?<br/>it says<br/>/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle:<br/> /usr/local/mysql/lib/libmysqlclient.16.dylib (compatibility version 17.0.0, current version 17.0.0)<br/> /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1213.0.0)<br/><br/>There you have libmysqlclient.xx.dylib.<br/>It says 16 now, because I re-installed mysql-server 5.1.63. With 5.6.21 it is 18.<br/>Roaming at the same spot (actual mysql-folder in /usr/local) -- but somehow being part of the trouble.<br/><br/>SPOILER HERE !!!<br/><br/>Dumping my bases, getting rid of the receipts and<br/>re-installing the 5.1.63 -- plus the actual dbi and dbd -- DID IT !!<br/>Perl works again with them mysql databases !!<br/>Still Yosemiting, no croaking&hellip;<br/><br/>So &hellip; it may be the combination of Yosemite AND version 5.6.21 that will run into these troubles.<br/>(Of course, I would not test the combination Mavericks and 5.6.21, too late for that.)<br/><br/>&gt;&gt; # Referenced from: /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle<br/>&gt;&gt; # Reason: image not found at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.<br/><br/>Just an idea for tracing&hellip;<br/>I looked up Dynaloader.pm line 194 and there is a comment before the croak command, <br/>that says&hellip;<br/><br/> # Many dynamic extension loading problems will appear to come from<br/> # this section of code: XYZ failed at line 123 of DynaLoader.pm.<br/> # Often these errors are actually occurring in the initialisation<br/> # C code of the extension XS file. Perl reports the error as being<br/> # in this perl code simply because this was the last perl code<br/> # it executed.<br/><br/>before continuing<br/><br/> my $libref = dl_load_file($file, $module-&gt;dl_load_flags) or<br/> croak(&quot;Can&#39;t load &#39;$file&#39; for module $module: &quot;.dl_error());<br/><br/>Well, I heard that croak a lot&hellip;<br/><br/>I would/could not follow that track &ndash; dunno my way around things enough.<br/>Which xs might be the one in this case ?<br/><br/>&gt;&gt; Is there a path ?<br/>&gt; There is always a path - but what dedicated path are you looking for?<br/>that was just a way of speaking<br/>The path here is not really inside a computer&hellip;<br/>(meanwhile the one inside the machine i.e. the file system, might be decisive by the times we live)<br/><br/>very happy to be up and running again<br/>mitch<br/><br/>&gt; <br/>&gt; Cheers<br/>&gt; -- <br/>&gt; Jens Rehsack<br/>&gt; rehsack@gmail.com &lt;mailto:rehsack@gmail.com&gt;<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37019.html Thu, 30 Oct 2014 07:15:45 +0000 Re: First time DBI user crashing perl by Jon Hello Peter,<br/><br/>Well, that&#39;s kinda what I figured but never hurts try for the easy answer.<br/><br/>I cleaned up your test script a bit.<br/><br/>Can you give this version a try:<br/>https://gist.github.com/three18ti/c37587ef7d5fb9ee5748<br/><br/>I&#39;m downloading DB2 as we speak, but I wanted to ask for your DB2_HOME<br/>environment variable. In your instructions it has you set it, but the<br/>instructions are clearly for a linux server, what did you do on your<br/>windows server?<br/><br/>Honestly, I have very limited DB2 experience, so it&#39;s kinda the blind<br/>leading the blind here. I&#39;m really just curious myself. you&#39;re more than<br/>welcome to ignore me and wait for one of the more experienced guys :)<br/><br/>Best Regards,<br/>Jon A<br/><br/>On Wed, Oct 29, 2014 at 8:42 PM, Peter Shabino &lt;wireb@hotmail.com&gt; wrote:<br/><br/>&gt; I am running it from a command prompt and I am getting some of the output<br/>&gt; so perl is running fine. Just looks like any command that trys and uses the<br/>&gt; DB2 interface causes a crash.<br/>&gt;<br/>&gt; Thanks,<br/>&gt; Peter<br/>&gt;<br/>&gt; My projects:<br/>&gt; http://www.wire2wire.org/<br/>&gt;<br/>&gt;<br/>&gt; ------------------------------<br/>&gt; Date: Wed, 29 Oct 2014 20:26:15 -0600<br/>&gt; Subject: RE: First time DBI user crashing perl<br/>&gt; From: three18ti@gmail.com<br/>&gt; To: wireb@hotmail.com<br/>&gt; CC: dbi-users@perl.org<br/>&gt;<br/>&gt;<br/>&gt; Hello Peter,<br/>&gt;<br/>&gt; How are you invoking the script? Do you have a perl script that you double<br/>&gt; click?<br/>&gt;<br/>&gt; If so, can you try opening a command/powershell window and running your<br/>&gt; program? You&#39;ll likely have to specify the full path to the perl binary<br/>&gt; then pass your script as the first parameter.<br/>&gt;<br/>&gt; E.g.: \strawberry\perl\bin\perl.exe my_script.pl<br/>&gt;<br/>&gt; I have not encountered this particular problem with db2 but this is my<br/>&gt; first step when trying to get one of my scripts to run in Windows (I&#39;m a<br/>&gt; Linux enginner by the Windows engineers steal a lot of my applications),<br/>&gt; perhaps someone has more specific experience than myself.<br/>&gt;<br/>&gt; Best Regards,<br/>&gt; Jon A<br/>&gt; On Oct 29, 2014 5:50 PM, &quot;Peter Shabino&quot; &lt;wireb@hotmail.com&gt; wrote:<br/>&gt;<br/>&gt; Try this again I apparently found a keyboard shortcut to send the message<br/>&gt; in hotmail......<br/>&gt;<br/>&gt; Trying to set up a connection to a remote DB2 server in perl to query some<br/>&gt; data.<br/>&gt;<br/>&gt; Followed the directions here:<br/>&gt; http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt;<br/>&gt; Then searching the web I came up with this chunk of code:<br/>&gt;<br/>&gt; use warnings;<br/>&gt; use strict;<br/>&gt; use DBI;<br/>&gt; use DBD::DB2;<br/>&gt;<br/>&gt; print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;);<br/>&gt; print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;);<br/>&gt; print(&quot;Perl Version = &quot;,$],&quot;\n&quot;);<br/>&gt; print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;);<br/>&gt; print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;);<br/>&gt; print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;);<br/>&gt;<br/>&gt; my @driver_names = DBI-&gt;available_drivers;<br/>&gt; print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;);<br/>&gt;<br/>&gt; print(&quot;I am here\n&quot;);<br/>&gt;<br/>&gt; my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;);<br/>&gt; print(@dataSources,&quot;\n&quot;);<br/>&gt;<br/>&gt; print(&quot;I am there\n&quot;);<br/>&gt;<br/>&gt; exit(0);<br/>&gt;<br/>&gt; When I run this I get a popup that says the &quot;Perl interpreter has stopped<br/>&gt; working&quot; and a button to close the program.<br/>&gt;<br/>&gt; on the console I get:<br/>&gt; Operating System = MSWin32<br/>&gt; Perl Binary = c:\strawberry\perl\bin\perl.exe<br/>&gt; Perl Version = 5.018001<br/>&gt; DBI Version = 1.631<br/>&gt; DBD::DB2 Version = 1.85<br/>&gt;<br/>&gt; env = DB2<br/>&gt; ADO<br/>&gt; DB2<br/>&gt; DBM<br/>&gt; ExampleP<br/>&gt; File<br/>&gt; Gofer<br/>&gt; ODBC<br/>&gt; Pg<br/>&gt; Proxy<br/>&gt; SQLite<br/>&gt; Sponge<br/>&gt; mysql<br/>&gt; I am here<br/>&gt;<br/>&gt; So the failure is when I try and get the DB2 data sources...<br/>&gt;<br/>&gt; Just have no idea even where to start looking for the issue since there is<br/>&gt; no error message. Is there a log file with more information on what might<br/>&gt; have died?<br/>&gt;<br/>&gt; Thanks,<br/>&gt; Peter<br/>&gt;<br/>&gt;<br/>&gt; My projects:<br/>&gt; http://www.wire2wire.org/<br/>&gt;<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37018.html Thu, 30 Oct 2014 03:56:42 +0000 RE: First time DBI user crashing perl by Peter Shabino I am running it from a command prompt and I am getting some of the output so perl is running fine. Just looks like any command that trys and uses the DB2 interface causes a crash. <br/>Thanks,<br/>Peter<br/><br/>My projects:<br/>http://www.wire2wire.org/<br/><br/><br/>Date: Wed, 29 Oct 2014 20:26:15 -0600<br/>Subject: RE: First time DBI user crashing perl<br/>From: three18ti@gmail.com<br/>To: wireb@hotmail.com<br/>CC: dbi-users@perl.org<br/><br/>Hello Peter,<br/>How are you invoking the script? Do you have a perl script that you double click?<br/>If so, can you try opening a command/powershell window and running your program? You&#39;ll likely have to specify the full path to the perl binary then pass your script as the first parameter.<br/>E.g.: \strawberry\perl\bin\perl.exe my_script.pl<br/>I have not encountered this particular problem with db2 but this is my first step when trying to get one of my scripts to run in Windows (I&#39;m a Linux enginner by the Windows engineers steal a lot of my applications), perhaps someone has more specific experience than myself.<br/>Best Regards,<br/><br/>Jon A<br/>On Oct 29, 2014 5:50 PM, &quot;Peter Shabino&quot; &lt;wireb@hotmail.com&gt; wrote:<br/><br/><br/><br/>Try this again I apparently found a keyboard shortcut to send the message in hotmail......<br/><br/><br/><br/><br/>Trying to set up a connection to a remote DB2 server in perl to query some data. <br/>Followed the directions here:http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>Then searching the web I came up with this chunk of code:<br/>use warnings;use strict;use DBI;use DBD::DB2;<br/>print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;);print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;);print(&quot;Perl Version = &quot;,$],&quot;\n&quot;);print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;);print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;);print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;);<br/>my @driver_names = DBI-&gt;available_drivers;print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;);<br/>print(&quot;I am here\n&quot;);<br/>my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;);print(@dataSources,&quot;\n&quot;);<br/>print(&quot;I am there\n&quot;);<br/>exit(0);<br/>When I run this I get a popup that says the &quot;Perl interpreter has stopped working&quot; and a button to close the program. <br/>on the console I get:Operating System = MSWin32Perl Binary = c:\strawberry\perl\bin\perl.exePerl Version = 5.018001DBI Version = 1.631DBD::DB2 Version = 1.85<br/>env = DB2ADODB2DBMExamplePFileGoferODBCPgProxySQLiteSpongemysqlI am here<br/>So the failure is when I try and get the DB2 data sources... <br/>Just have no idea even where to start looking for the issue since there is no error message. Is there a log file with more information on what might have died?<br/>Thanks,<br/>Peter<br/><br/>My projects:<br/>http://www.wire2wire.org/<br/> <br/> <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37017.html Thu, 30 Oct 2014 02:42:45 +0000 RE: First time DBI user crashing perl by Jon Hello Peter,<br/><br/>How are you invoking the script? Do you have a perl script that you double<br/>click?<br/><br/>If so, can you try opening a command/powershell window and running your<br/>program? You&#39;ll likely have to specify the full path to the perl binary<br/>then pass your script as the first parameter.<br/><br/>E.g.: \strawberry\perl\bin\perl.exe my_script.pl<br/><br/>I have not encountered this particular problem with db2 but this is my<br/>first step when trying to get one of my scripts to run in Windows (I&#39;m a<br/>Linux enginner by the Windows engineers steal a lot of my applications),<br/>perhaps someone has more specific experience than myself.<br/><br/>Best Regards,<br/>Jon A<br/>On Oct 29, 2014 5:50 PM, &quot;Peter Shabino&quot; &lt;wireb@hotmail.com&gt; wrote:<br/><br/>&gt; Try this again I apparently found a keyboard shortcut to send the message<br/>&gt; in hotmail......<br/>&gt;<br/>&gt; Trying to set up a connection to a remote DB2 server in perl to query some<br/>&gt; data.<br/>&gt;<br/>&gt; Followed the directions here:<br/>&gt; http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>&gt;<br/>&gt; Then searching the web I came up with this chunk of code:<br/>&gt;<br/>&gt; use warnings;<br/>&gt; use strict;<br/>&gt; use DBI;<br/>&gt; use DBD::DB2;<br/>&gt;<br/>&gt; print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;);<br/>&gt; print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;);<br/>&gt; print(&quot;Perl Version = &quot;,$],&quot;\n&quot;);<br/>&gt; print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;);<br/>&gt; print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;);<br/>&gt; print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;);<br/>&gt;<br/>&gt; my @driver_names = DBI-&gt;available_drivers;<br/>&gt; print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;);<br/>&gt;<br/>&gt; print(&quot;I am here\n&quot;);<br/>&gt;<br/>&gt; my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;);<br/>&gt; print(@dataSources,&quot;\n&quot;);<br/>&gt;<br/>&gt; print(&quot;I am there\n&quot;);<br/>&gt;<br/>&gt; exit(0);<br/>&gt;<br/>&gt; When I run this I get a popup that says the &quot;Perl interpreter has stopped<br/>&gt; working&quot; and a button to close the program.<br/>&gt;<br/>&gt; on the console I get:<br/>&gt; Operating System = MSWin32<br/>&gt; Perl Binary = c:\strawberry\perl\bin\perl.exe<br/>&gt; Perl Version = 5.018001<br/>&gt; DBI Version = 1.631<br/>&gt; DBD::DB2 Version = 1.85<br/>&gt;<br/>&gt; env = DB2<br/>&gt; ADO<br/>&gt; DB2<br/>&gt; DBM<br/>&gt; ExampleP<br/>&gt; File<br/>&gt; Gofer<br/>&gt; ODBC<br/>&gt; Pg<br/>&gt; Proxy<br/>&gt; SQLite<br/>&gt; Sponge<br/>&gt; mysql<br/>&gt; I am here<br/>&gt;<br/>&gt; So the failure is when I try and get the DB2 data sources...<br/>&gt;<br/>&gt; Just have no idea even where to start looking for the issue since there is<br/>&gt; no error message. Is there a log file with more information on what might<br/>&gt; have died?<br/>&gt;<br/>&gt; Thanks,<br/>&gt; Peter<br/>&gt;<br/>&gt;<br/>&gt; My projects:<br/>&gt; http://www.wire2wire.org/<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37016.html Thu, 30 Oct 2014 02:26:27 +0000 RE: First time DBI user crashing perl by Peter Shabino Try this again I apparently found a keyboard shortcut to send the message in hotmail......<br/><br/><br/><br/><br/>Trying to set up a connection to a remote DB2 server in perl to query some data. <br/>Followed the directions here:http://www-01.ibm.com/support/docview.wss?rs=71&amp;uid=swg21297335<br/>Then searching the web I came up with this chunk of code:<br/>use warnings;use strict;use DBI;use DBD::DB2;<br/>print(&quot;Operating System = &quot;,$^O,&quot;\n&quot;);print(&quot;Perl Binary = &quot;,$^X,&quot;\n&quot;);print(&quot;Perl Version = &quot;,$],&quot;\n&quot;);print(&quot;DBI Version = &quot;,$DBI::VERSION,&quot;\n&quot;);print(&quot;DBD::DB2 Version = &quot;,$DBD::DB2::VERSION,&quot;\n\n&quot;);print(&quot;env = &quot;,$ENV{ DB2INSTANCE},&quot;\n&quot;);<br/>my @driver_names = DBI-&gt;available_drivers;print(join(&quot;\n&quot;,@driver_names),&quot;\n&quot;);<br/>print(&quot;I am here\n&quot;);<br/>my @dataSources = DBI-&gt;data_sources(&#39;DB2&#39;);print(@dataSources,&quot;\n&quot;);<br/>print(&quot;I am there\n&quot;);<br/>exit(0);<br/>When I run this I get a popup that says the &quot;Perl interpreter has stopped working&quot; and a button to close the program. <br/>on the console I get:Operating System = MSWin32Perl Binary = c:\strawberry\perl\bin\perl.exePerl Version = 5.018001DBI Version = 1.631DBD::DB2 Version = 1.85<br/>env = DB2ADODB2DBMExamplePFileGoferODBCPgProxySQLiteSpongemysqlI am here<br/>So the failure is when I try and get the DB2 data sources... <br/>Just have no idea even where to start looking for the issue since there is no error message. Is there a log file with more information on what might have died?<br/>Thanks,<br/>Peter<br/><br/>My projects:<br/>http://www.wire2wire.org/<br/> <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37015.html Wed, 29 Oct 2014 23:50:26 +0000 First time DBI user crashing perl by Peter Shabino Trying to set up a connection to a remote DB2 server in perl to query some data. <br/>Followed the directions here:<br/>My projects:<br/>http://www.wire2wire.org/<br/> <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37014.html Wed, 29 Oct 2014 23:44:45 +0000 Re: DBI - DBD - mysql on Yosemite by Jens Rehsack Hi Michael,<br/><br/>please keep dbi-users@ in cc ;)<br/><br/>Am 29.10.2014 um 14:37 schrieb Michael Ahrweiler &lt;ma@versale.de&gt;:<br/><br/>&gt; Hi<br/>&gt; <br/>&gt;&gt; Am 29.10.2014 um 10:49 schrieb Jens Rehsack &lt;rehsack@gmail.com&gt;:<br/>&gt;&gt; Am 28.10.2014 um 17:45 schrieb Michael Ahrweiler &lt;ma@versale.de&gt;:<br/>&gt;&gt; <br/>&gt;&gt;&gt; Hello<br/>&gt;&gt; Hi Michael,<br/>&gt;&gt; <br/>&gt;&gt;&gt; It is not, that it does not function.<br/>&gt;&gt;&gt; It did. <br/>&gt;&gt;&gt; mysql was just not starting at boot time. So I updated. Since then, it&rsquo;s a mess.<br/>&gt;&gt;&gt; <br/>&gt;&gt;&gt; After installing the latest mysql community-version 5.6.21<br/>&gt;&gt;&gt; On &quot;make test&quot; of DBD I get:<br/>&gt;&gt;&gt; <br/>&gt;&gt;&gt; # Failed test &#39;use DBD::mysql;&#39;<br/>&gt;&gt;&gt; # at t/00base.t line 18.<br/>&gt;&gt;&gt; # Tried to use &#39;DBD::mysql&#39;.<br/>&gt;&gt;&gt; # Error: Can&#39;t load &#39;/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle&lsquo;<br/>&gt;&gt;&gt; for module DBD::mysql: dlopen(/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle, 2):<br/>&gt;&gt;&gt; Library not loaded: libmysqlclient.18.dylib<br/>&gt;&gt; <br/>&gt;&gt; Where is this libmysqlclient.18.dylib from?<br/>&gt; see answer to otool-question<br/><br/>Already expected ;)<br/>Smells like that (from &quot;So I updated ...&quot;).<br/><br/>&gt;&gt; What is /temp?<br/>&gt; it is a near root-level folder from where I install those things<br/>&gt; As I said, this error came at &quot;make test&ldquo; but is similar to what the web pages will say when I install anyway.<br/><br/>Maybe you should use this experience to tell people why &quot;skipping &#39;make test&#39;&quot; isn&#39;t reasonable ...<br/><br/>&gt;&gt; What says &#39;otool -L /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle&lsquo;?<br/>&gt; it says<br/>&gt; /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle:<br/>&gt; /usr/local/mysql/lib/libmysqlclient.16.dylib (compatibility version 17.0.0, current version 17.0.0)<br/>&gt; /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1213.0.0)<br/>&gt; <br/>&gt; There you have libmysqlclient.xx.dylib.<br/>&gt; It says 16 now, because I re-installed mysql-server 5.1.63. With 5.6.21 it is 18.<br/><br/>What was the output of &quot;otool -L /usr/local/mysql/lib/libmysqlclient.18.dylib&quot;?<br/><br/>&gt; Roaming at the same spot (actual mysql-folder in /usr/local) -- but somehow being part of the trouble.<br/><br/>Play a bit around with stuff like dports, pkgsrc ...<br/>You&#39;ll detect some nice variables there named &quot;&lt;library&gt;.ABI &gt;= x.y.z&quot; or &quot;&lt;library&gt;.API &gt;= ...&quot;<br/>And always &quot;make clean&quot; :D<br/><br/>&gt; SPOILER HERE !!!<br/>&gt; <br/>&gt; Dumping my bases, getting rid of the receipts and<br/>&gt; re-installing the 5.1.63 -- plus the actual dbi and dbd -- DID IT !!<br/>&gt; Perl works again with them mysql databases !!<br/>&gt; Still Yosemiting, no croaking&hellip;<br/>&gt; <br/>&gt; So &hellip; it may be the combination of Yosemite AND version 5.6.21 that will run into these troubles.<br/>&gt; (Of course, I would not test the combination Mavericks and 5.6.21, too late for that.)<br/><br/>I do not expect that. I expect that there is another library causing the failure and you didn&#39;t track it down.<br/><br/>&gt;&gt;&gt; # Referenced from: /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle<br/>&gt;&gt;&gt; # Reason: image not found at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.<br/>&gt; <br/>&gt; Just an idea for tracing&hellip;<br/>&gt; I looked up Dynaloader.pm line 194 and there is a comment before the croak command, <br/>&gt; that says&hellip;<br/>&gt; <br/>&gt; # Many dynamic extension loading problems will appear to come from<br/>&gt; # this section of code: XYZ failed at line 123 of DynaLoader.pm.<br/>&gt; # Often these errors are actually occurring in the initialisation<br/>&gt; # C code of the extension XS file. Perl reports the error as being<br/>&gt; # in this perl code simply because this was the last perl code<br/>&gt; # it executed.<br/>&gt; <br/>&gt; before continuing<br/>&gt; <br/>&gt; my $libref = dl_load_file($file, $module-&gt;dl_load_flags) or<br/>&gt; croak(&quot;Can&#39;t load &#39;$file&#39; for module $module: &quot;.dl_error());<br/>&gt; <br/>&gt; Well, I heard that croak a lot&hellip;<br/>&gt; <br/>&gt; I would/could not follow that track &ndash; dunno my way around things enough.<br/>&gt; Which xs might be the one in this case ?<br/>&gt; <br/>&gt;&gt;&gt; Is there a path ?<br/>&gt;&gt; There is always a path - but what dedicated path are you looking for?<br/>&gt; that was just a way of speaking<br/><br/>I just couldn&#39;t guess what was asked for ;)<br/>Way of debugging? Location to search for libs? ...<br/><br/>&gt; The path here is not really inside a computer&hellip;<br/>&gt; (meanwhile the one inside the machine i.e. the file system, might be decisive by the times we live)<br/>&gt; <br/>&gt; very happy to be up and running again<br/><br/>Cheers<br/>-- <br/>Jens Rehsack<br/>rehsack@gmail.com<br/><br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37013.html Wed, 29 Oct 2014 14:09:49 +0000 Re: DBI - DBD - mysql on Yosemite by Jens Rehsack <br/>Am 28.10.2014 um 17:45 schrieb Michael Ahrweiler &lt;ma@versale.de&gt;:<br/><br/>&gt; Hello<br/><br/>Hi Michael,<br/><br/>&gt; It is not, that it does not function.<br/>&gt; It did. <br/>&gt; It was just not starting by itself. So I updated. Since then, it&rsquo;s a mess.<br/>&gt; <br/>&gt; After installing the latest mysql community-version 5.6.21<br/>&gt; On make test of DBD I get:<br/>&gt; <br/>&gt; # Failed test &#39;use DBD::mysql;&#39;<br/>&gt; # at t/00base.t line 18.<br/>&gt; # Tried to use &#39;DBD::mysql&#39;.<br/>&gt; # Error: Can&#39;t load &#39;/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle&#39; for module DBD::mysql: dlopen(/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: libmysqlclient.18.dylib<br/><br/>Where is this libmysqlclient.18.dylib from?<br/>What is /temp?<br/>What says &#39;otool -L /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle&#39;?<br/><br/>&gt; # Referenced from: /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle<br/>&gt; # Reason: image not found at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.<br/>&gt; # at (eval 8) line 2.<br/>&gt; <br/>&gt; If I do the install all the same I get (more or less) the same error-message on my web-pages using perl-DBI-DBD.<br/>&gt; <br/>&gt; I fumbled arount a lot&hellip;<br/>&gt; - with libmysqlclient.18.dylib<br/>&gt; - with old DBI DBD installation pouring over what was installed <br/>&gt; (getting &bdquo;an error occurred&ldquo; for loading shtml-pages with DBI DBD mysql-content) - which might be better but&hellip;<br/>&gt; - with installing oder version of DBI and DBD (with the same error in make test)<br/>&gt; <br/>&gt; I am out of &bdquo;ideas&ldquo;.<br/>&gt; Is this a yosemite thing? For instance harder sandbox something?<br/>&gt; <br/>&gt; Any ideas ?<br/><br/>Not enough information (at least for me)...<br/>Makes me fear updating to Yosemite ^^<br/><br/>&gt; Is there a path ?<br/><br/>There is always a path - but what dedicated path are you looking for?<br/><br/>Cheers<br/>-- <br/>Jens Rehsack<br/>rehsack@gmail.com<br/><br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37012.html Wed, 29 Oct 2014 09:49:31 +0000 DBI - DBD - mysql on Yosemite by Michael Ahrweiler Hello<br/><br/>It is not, that it does not function.<br/>It did. <br/>It was just not starting by itself. So I updated. Since then, it&rsquo;s a mess.<br/><br/>After installing the latest mysql community-version 5.6.21<br/>On make test of DBD I get:<br/><br/># Failed test &#39;use DBD::mysql;&#39;<br/># at t/00base.t line 18.<br/># Tried to use &#39;DBD::mysql&#39;.<br/># Error: Can&#39;t load &#39;/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle&#39; for module DBD::mysql: dlopen(/temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Library not loaded: libmysqlclient.18.dylib<br/># Referenced from: /temp/DBD-mysql-4.028/blib/arch/auto/DBD/mysql/mysql.bundle<br/># Reason: image not found at /System/Library/Perl/5.18/darwin-thread-multi-2level/DynaLoader.pm line 194.<br/># at (eval 8) line 2.<br/><br/>If I do the install all the same I get (more or less) the same error-message on my web-pages using perl-DBI-DBD.<br/><br/>I fumbled arount a lot&hellip;<br/>- with libmysqlclient.18.dylib<br/>- with old DBI DBD installation pouring over what was installed <br/> (getting &bdquo;an error occurred&ldquo; for loading shtml-pages with DBI DBD mysql-content) - which might be better but&hellip;<br/>- with installing oder version of DBI and DBD (with the same error in make test)<br/><br/>I am out of &bdquo;ideas&ldquo;.<br/>Is this a yosemite thing? For instance harder sandbox something?<br/><br/>Any ideas ?<br/>Is there a path ?<br/>Michael<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37011.html Wed, 29 Oct 2014 05:43:28 +0000 Re: DBD::Sybase building Problem 64<>32bit by Michael Peppler Hi,<br/><br/>So the issue is that the 64 bit libraries are not found at run-time.<br/><br/>If you &quot;source&quot; the SYBASE.sh file located in the root directory of your ASE 15.7 64 bit install you should be fine.<br/><br/>You can also add these directories to the /etc/ld.so.conf to add these directories to the normal search path.<br/><br/>On a CentOS box I have:<br/><br/>[mpeppler@li ~]$ cat /etc/ld.so.conf<br/>include ld.so.conf.d/*.conf<br/>[mpeppler@li ~]$ cat /etc/ld.so.conf.d/<br/>mysql-x86_64.conf sybase.conf <br/>[mpeppler@li ~]$ cat /etc/ld.so.conf.d/sybase.conf <br/>/opt/sybase/ASE-15_0/lib<br/>/opt/sybase/OCS-15_0/lib<br/>[mpeppler@li ~]$ <br/><br/><br/>Michael<br/><br/><br/>On 16 Oct 2014, at 19:13, Monetron Team &lt;develop@monetron.com&gt; wrote:<br/><br/>&gt; Hello List,<br/>&gt; <br/>&gt; My problem is that i have a 32 bit version of ASE/<br/>&gt; OpenClient, but as it is running on 64bit Linux, Perl is installed in 64 bit mode.<br/>&gt; <br/>&gt; # uname -a<br/>&gt; Linux 2.6.18-398.el5xen #1 SMP Tue Sep 16 21:31:50 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux<br/>&gt; <br/>&gt; # perl -v<br/>&gt; This is perl, v5.8.8 built for x86_64-linux-thread-multi<br/>&gt; <br/>&gt; # Sybase ASE 15.0 32 bit $SYBASE /opt/sybase/ase-15<br/>&gt; <br/>&gt; I have downloaded ASE 15.7 64bit<br/>&gt; and exported $SYBASE with the path to the 64bit OCS folder.<br/>&gt; <br/>&gt; first i tested with isql if the connection parameters in PWD-File are oK.<br/>&gt; then i started to build DBD::SYBASE<br/>&gt; and the make test, resulted in a lot of errors<br/>&gt; <br/>&gt; Please see attached log file<br/>&gt; <br/>&gt; i hope that someone here can help me, as i saw that the sybperl - peppler list is not active..<br/>&gt; <br/>&gt; thanks in advance<br/>&gt; Uwe<br/>&gt; <br/>&gt; &lt;logfile.txt&gt;<br/><br/><br/><br/>--<br/>Michael Peppler<br/>Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html<br/><br/>&quot;A successful [software] tool is one that was used to do something undreamed of by its author.&quot; -- S. C. Johnson <br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37010.html Fri, 17 Oct 2014 14:17:33 +0000 Re: Using DBI::Profile to count and time database calls by Tim Bunce Sorry for the delay.<br/><br/>On Tue, Oct 07, 2014 at 12:00:31PM -0700, Bill Moseley wrote:<br/>&gt; Noting like writing an email to trigger reading the docs again.<br/><br/>:)<br/><br/>&gt; On Tue, Oct 7, 2014 at 11:43 AM, Bill Moseley &lt;[1]moseley@hank.org&gt; wrote:<br/>&gt; <br/>&gt; I&#39;m trying to just count number of database queries and the time spent waiting on the database.<br/>&gt; <br/>&gt; Does this look correct?<br/>&gt; my $h = DBI::Profile-&gt;new( Path =&gt; [ sub { return $_[1] =~ /^(?:execute|do|select)/ ? undef : \undef;} ]<br/>&gt; );<br/><br/>Yes, though evaluating the regex during data collection will be slow.<br/>If efficiency is a concern then it&#39;s better to collect using &#39;!MethodName&#39;<br/>and post-process to merge the stats for the methods you&#39;re interested in.<br/><br/>Tim.<br/><br/>&gt; <br/>&gt; I can use this to just gather grand totals: <br/>&gt; DBI::Profile-&gt;new( Path =&gt; [ ] );<br/>&gt; The total time is fine even if it includes the small amount of time in DBI instead of directly waiting<br/>&gt; on the database. But, the counts are do not represent just trips to the database, rather apparently<br/>&gt; counts of all methods called (e.g. a prepare and execute counts as 2).<br/>&gt; Using:<br/>&gt; DBI::Profile-&gt;new( Path =&gt; [ &#39;!MethodName&#39; ] );<br/>&gt; might be ok, but I&#39;d have to then find all the methods that go to the db (e.g. &quot;execute&quot;, &quot;do&quot;).<br/>&gt; Can I use DBI::Profile to just gather up counts to the database?<br/>&gt; Thanks,<br/>&gt; --<br/>&gt; Bill Moseley<br/>&gt; [2]moseley@hank.org<br/>&gt; <br/>&gt; --<br/>&gt; Bill Moseley<br/>&gt; [3]moseley@hank.org<br/>&gt; <br/>&gt; References<br/>&gt; <br/>&gt; Visible links<br/>&gt; 1. mailto:moseley@hank.org<br/>&gt; 2. mailto:moseley@hank.org<br/>&gt; 3. mailto:moseley@hank.org<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37009.html Thu, 16 Oct 2014 21:21:43 +0000 DBD::Sybase building Problem 64<>32bit by Monetron Team Hello List,<br/><br/>My problem is that i have a 32 bit version of ASE/<br/>OpenClient, but as it is running on 64bit Linux, Perl is installed in 64 <br/>bit mode.<br/><br/># uname -a<br/>Linux 2.6.18-398.el5xen #1 SMP Tue Sep 16 21:31:50 EDT 2014 x86_64 <br/>x86_64 x86_64 GNU/Linux<br/><br/># perl -v<br/>This is perl, v5.8.8 built for x86_64-linux-thread-multi<br/><br/># Sybase ASE 15.0 32 bit $SYBASE /opt/sybase/ase-15<br/><br/>I have downloaded ASE 15.7 64bit<br/>and exported $SYBASE with the path to the 64bit OCS folder.<br/><br/>first i tested with isql if the connection parameters in PWD-File are oK.<br/>then i started to build DBD::SYBASE<br/>and the make test, resulted in a lot of errors<br/><br/>Please see attached log file<br/><br/>i hope that someone here can help me, as i saw that the sybperl - <br/>peppler list is not active..<br/><br/>thanks in advance<br/>Uwe<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37008.html Thu, 16 Oct 2014 18:13:24 +0000 Re: Using DBI::Profile to count and time database calls by Bill Moseley Noting like writing an email to trigger reading the docs again.<br/><br/>On Tue, Oct 7, 2014 at 11:43 AM, Bill Moseley &lt;moseley@hank.org&gt; wrote:<br/><br/>&gt; I&#39;m trying to just count number of database queries and the time spent<br/>&gt; waiting on the database.<br/>&gt;<br/><br/>Does this look correct?<br/><br/>my $h = DBI::Profile-&gt;new( Path =&gt; [ sub { return $_[1] =~<br/>/^(?:execute|do|select)/ ? undef : \undef;} ] );<br/><br/><br/><br/><br/>&gt;<br/>&gt; I can use this to just gather grand totals:<br/>&gt;<br/>&gt; DBI::Profile-&gt;new( Path =&gt; [ ] );<br/>&gt;<br/>&gt; The total time is fine even if it includes the small amount of time in DBI<br/>&gt; instead of directly waiting on the database. But, the counts are do not<br/>&gt; represent just trips to the database, rather apparently counts of all<br/>&gt; methods called (e.g. a prepare and execute counts as 2).<br/>&gt;<br/>&gt; Using:<br/>&gt;<br/>&gt; DBI::Profile-&gt;new( Path =&gt; [ &#39;!MethodName&#39; ] );<br/>&gt;<br/>&gt; might be ok, but I&#39;d have to then find all the methods that go to the db<br/>&gt; (e.g. &quot;execute&quot;, &quot;do&quot;).<br/>&gt;<br/>&gt; Can I use DBI::Profile to just gather up counts to the database?<br/>&gt;<br/>&gt; Thanks,<br/>&gt;<br/>&gt;<br/>&gt; --<br/>&gt; Bill Moseley<br/>&gt; moseley@hank.org<br/>&gt;<br/><br/><br/><br/>-- <br/>Bill Moseley<br/>moseley@hank.org<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37007.html Wed, 08 Oct 2014 10:00:27 +0000 Using DBI::Profile to count and time database calls by Bill Moseley I&#39;m trying to just count number of database queries and the time spent<br/>waiting on the database.<br/><br/>I can use this to just gather grand totals:<br/><br/>DBI::Profile-&gt;new( Path =&gt; [ ] );<br/><br/>The total time is fine even if it includes the small amount of time in DBI<br/>instead of directly waiting on the database. But, the counts are do not<br/>represent just trips to the database, rather apparently counts of all<br/>methods called (e.g. a prepare and execute counts as 2).<br/><br/>Using:<br/><br/>DBI::Profile-&gt;new( Path =&gt; [ &#39;!MethodName&#39; ] );<br/><br/>might be ok, but I&#39;d have to then find all the methods that go to the db<br/>(e.g. &quot;execute&quot;, &quot;do&quot;).<br/><br/>Can I use DBI::Profile to just gather up counts to the database?<br/><br/>Thanks,<br/><br/><br/>-- <br/>Bill Moseley<br/>moseley@hank.org<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/10/msg37006.html Wed, 08 Oct 2014 10:00:25 +0000 RE: buffer allocation bug in DBD::mysql leading to failures (was:DBD::mysql mysql_server_prepare=1 caching of statement handles) by Jens-Petter Salvesen Hi everyone!<br/><br/>I want to state the obvious: This bug forces MySQL users to choose between caching statement handles and server side prepare. This is pretty serious, IMHO: <br/><br/>Server side prepare is amongst other things necessary in order to determine if SQL is valid upon the prepare call (all other RDBMS&#39;es set sth-&gt;err() upon invalid SQL in the prepare statement). And statement caching is necessary in order to achieve performance and scalability. This is a choice no-one should have to make. <br/><br/>Unfortunately, I cannot C so my ability to help out is limited - but I can write up a unit test if that&#39;s of interest. <br/><br/>Best regards,<br/>Jens-Petter Salvesen<br/><br/>-----Original Message-----<br/>From: Marc Lehmann [mailto:schmorp@schmorp.de] <br/>Sent: 11. august 2014 05:28<br/>To: dbi-users@perl.org<br/>Cc: wouter-dbi-users@owl-ict.nl; patg@patg.net<br/>Subject: buffer allocation bug in DBD::mysql leading to failures (was: DBD::mysql mysql_server_prepare=1 caching of statement handles)<br/><br/>Hi!<br/><br/>I am not susbcribed to this list - I wanted to add information to a previous issue reported by Wouter de Geus (e.g. in http://code.activestate.com/lists/perl-dbi-users/36031/)<br/><br/>I ran into what is probably exactly the same problem as him and debugged it a bit further. I now believe this is simply a bug in the prepared statement implementation of DBD::mysql.<br/><br/>I&#39;ve directly cc&#39;ed Patrick Galbraith, as it seems rt.cpan.org is a blackhole for DBD::mysql bug reports nowadays, and this bug effectively renders prepared statements useless. (Patrick, if DBD::mysql is no longer maintained by you, do you happen to know by whom it is maintaiend these days, if anybody?)<br/><br/>Here is a typical trace of a repeated invocation, which matches the trace provided by Wouter. This works:<br/><br/> -&gt; fetchrow_arrayref for DBD::mysql::st (DBI::st=HASH(0x1f8aa20)~0x1f52d38)<br/> -&gt; dbd_st_fetch<br/> --&gt; dbd_describe<br/> dbd_describe() num_fields 1<br/> i 0 col_type 253 fbh-&gt;length 0<br/> fields[i].length 255 fields[i].max_length 41 fields[i].type 253 fields[i].charsetnr 63<br/> mysql_to_perl_type returned 253<br/> &lt;- dbd_describe<br/> dbd_st_fetch for 01f8aa80, chopblanks 0<br/> dbd_st_fetch calling mysql_fetch<br/><br/>And this fails, due to the MYSQL_DATA_TRUNCATED result:<br/><br/> &gt;&gt; fetchrow_arrayref DISPATCH (DBI::st=HASH(0x1f8aa20) rc1/1 @1 g2 ima0 pid#3097) at Schback/Slave.pm line 395 via at ./schbackd line 81<br/> -&gt; fetchrow_arrayref for DBD::mysql::st (DBI::st=HASH(0x1f8aa20)~0x1f52d38)<br/> -&gt; dbd_st_fetch<br/> dbd_st_fetch for 01f8aa80, chopblanks 0<br/> dbd_st_fetch calling mysql_fetch<br/> dbd_st_fetch data truncated<br/><br/>I found that this happens when I reuse the same statement handle and the second invocation returns a longer result for a field than the first.<br/><br/>I verified using ltrace -e memcpy that the buffer_length allocated in the failure case is the 41 from the previous execute, which is too small for the next one, causing the failure.<br/><br/>Lo and behold, an obvious testcase reproduces the bug:<br/><br/> $dbh = DBI-&gt;connect (&quot;dbi:mysql:test;mysql_read_default_group=client;mysql_server_prepare=1&quot;, &quot;&quot;, &quot;&quot;);<br/><br/> # DBI-&gt;trace (2);<br/><br/> $st = $dbh-&gt;prepare (&quot;select ?&quot;);<br/> $st-&gt;execute (&quot;1234&quot;);<br/> warn $st-&gt;fetchrow_arrayref;<br/><br/> $st-&gt;execute (&quot;123456789&quot;);<br/> warn $st-&gt;fetchrow_arrayref; # fails due to MYSQL_DATA_TRUNCATED<br/><br/>The first execute works, and fetchrow_arrayref returns the result row. The second execute works as well, but fetchrow_arrayref returns undef. When enabling tracing, it shows that the second fetch fails because of MYSQL_DATA_TRUNCATED status.<br/><br/>Clearly, something in DBD::mysql caches maximum buffer sizes between executes when it shouldn&#39;t.<br/><br/>-- <br/> The choice of a Deliantra, the free code+content MORPG<br/> -----==- _GNU_ http://www.deliantra.net<br/> ----==-- _ generation<br/> ---==---(_)__ __ ____ __ Marc Lehmann<br/> --==---/ / _ \/ // /\ \/ / schmorp@schmorp.de<br/> -=====/_/_//_/\_,_/ /_/\_\<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37005.html Tue, 30 Sep 2014 11:52:54 +0000 Re: SQL:Statement/Parser by Mauricio Begovich Hi Ron, nice to meet you and thank you so much for your soon answer.<br/><br/>Got it! now I&#39;ll never forget it: it&#39;s Perl ;)!<br/><br/>Well, I&#39;m working with the SQL::Statement module. The code with I&#39;m dealing<br/>is the following code:<br/>################################################################################<br/><br/> use SQL::Statement;<br/> my $sql = &quot;SELECT a FROM b JOIN c WHERE c=? AND e=7 ORDER BY f<br/>DESC LIMIT 5,2&quot;;<br/> my $parser = SQL::Parser-&gt;new();<br/> $parser-&gt;{RaiseError}=1;<br/> $parser-&gt;{PrintError}=0;<br/> $parser-&gt;parse(&quot;LOAD &#39;MyLib::MySyntax&#39; &quot;);<br/> my $stmt = SQL::Statement-&gt;new($sql,$parser);<br/> printf &quot;Command %s\n&quot;,$stmt-&gt;command;<br/> printf &quot;Num of Placeholders %s\n&quot;,scalar $stmt-&gt;params;<br/> printf &quot;Columns %s\n&quot;,join( &#39;,&#39;, map {$_-&gt;name}<br/>$stmt-&gt;column_defs() );<br/> printf &quot;Tables %s\n&quot;,join( &#39;,&#39;, map {$_-&gt;name}<br/>$stmt-&gt;tables() );<br/> printf &quot;Where operator %s\n&quot;,join( &#39;,&#39;, $stmt-&gt;where-&gt;op() );<br/> printf &quot;Limit %s\n&quot;,$stmt-&gt;limit();<br/> printf &quot;Offset %s\n&quot;,$stmt-&gt;offset();<br/><br/> # these will work not before $stmt-&gt;execute()<br/> printf &quot;Order Columns %s\n&quot;,join(&#39;,&#39;, map {$_-&gt;column}<br/>$stmt-&gt;order() );<br/><br/>################################################################################<br/><br/><br/>And the problem I have is that I can&#39;t access the $stmt-&gt;column_defs()<br/>through the<br/>map{$_-&gt;name} function.<br/><br/>When I do something like print DUMP $stmt-&gt;column_defs();, I can<br/>visualize the content<br/><br/>of the hash that contents information about the columns of the query.<br/><br/>Have you any ideas of what I&#39;m doing wrong?<br/><br/>Thanks in advance!<br/><br/>Mauricio.<br/><br/><br/><br/>2014-09-10 17:19 GMT-05:00 Ron Savage &lt;ron@savage.net.au&gt;:<br/><br/>&gt; Hi Mauricio<br/>&gt;<br/>&gt; &gt;Good morning!<br/>&gt;<br/>&gt; &gt;I&#39;m a Mexican PERL fan, and I write first for congratulate you for &gt;this<br/>&gt; great job.<br/>&gt;<br/>&gt; Glad to hear you&#39;re using Perl.<br/>&gt;<br/>&gt; And yes, it&#39;s Perl, not PERL.<br/>&gt;<br/>&gt; &gt;I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since &gt;my<br/>&gt; Ubuntu console, but I have some issues with the map {$_-&gt;name}<br/>&gt; &gt;$stmt-&gt;column_defs() method for parsing it.<br/>&gt;<br/>&gt; &gt;Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on<br/>&gt; &gt;unbless object.<br/>&gt;<br/>&gt; We need to see the code. Post the shortest possible sample code which<br/>&gt; produces this error.<br/>&gt;<br/>&gt; Are you connecting to a real, pre-existing database with pre-existing<br/>&gt; tables?<br/>&gt;<br/>&gt; If so, how /exactly/ are you doing that?<br/>&gt;<br/>&gt; &gt;I will appreciate too much, any information about this error that was<br/>&gt; &gt;taken from CPAN documentation of this module.<br/>&gt;<br/>&gt; --<br/>&gt; Ron Savage - savage.net.au<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37004.html Tue, 16 Sep 2014 12:16:27 +0000 Re: SQL:Statement/Parser by C.J. Adams-Collier KF7BMP On Thu, 2014-09-11 at 08:19 +1000, Ron Savage wrote:<br/>&gt; Hi Mauricio<br/>&gt; <br/>&gt; &gt;Good morning!<br/>&gt; <br/>&gt; &gt;I&#39;m a Mexican PERL fan, and I write first for congratulate you for <br/>&gt; &gt;this great job.<br/><br/>Welcome! I blame Tim for most of the awesome.<br/><br/>&gt; Glad to hear you&#39;re using Perl.<br/>&gt; <br/>&gt; And yes, it&#39;s Perl, not PERL.<br/><br/>Well it&#39;s officially either Perl or perl (if you&#39;re speaking of the<br/>interpreter) but we generally don&#39;t mind you calling it PERL for the<br/>most part. I&#39;ve always been a fan of the backronym &quot;Pathologically<br/>Eclectic Rubbish Lister,&quot; which is, along with PERL, one of the<br/>unofficial names.<br/><br/>(be nice, Ron! https://wp.colliertech.org/cj/?p=1069#lyrics)<br/><br/>&gt; &gt;I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since <br/>&gt; &gt;my Ubuntu console, but I have some issues with the map {$_-&gt;name} <br/>&gt; &gt;$stmt-&gt;column_defs() method for parsing it.<br/>&gt; <br/>&gt; &gt;Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on <br/>&gt; &gt;unbless object.<br/>&gt; <br/>&gt; We need to see the code. Post the shortest possible sample code which <br/>&gt; produces this error.<br/><br/>remember that the map operator iterates over the list in the second<br/>argument executing the code in the first argument for each element of<br/>the list. $_ is set to the value currently being iterated.<br/><br/>This means that you expect $stmt-&gt;column_defs() to return a list of<br/>objects which have the method &#39;name&#39; defined in their package. <br/><br/>I don&#39;t see the example code you&#39;ve given in the perldoc for<br/>SQL::Statement. Can you tell us where you got it and what you&#39;re trying<br/>to do?<br/><br/>&gt; Are you connecting to a real, pre-existing database with pre-existing <br/>&gt; tables?<br/>&gt; <br/>&gt; If so, how /exactly/ are you doing that?<br/><br/>Yes, can you confirm that you&#39;ve got a valid database handle and that<br/>you can issue queries against it?<br/><br/>&gt; &gt;I will appreciate too much, any information about this error that was <br/>&gt; &gt;taken from CPAN documentation of this module.<br/><br/>URL please?<br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37003.html Thu, 11 Sep 2014 00:19:08 +0000 Re: SQL:Statement/Parser by Ron Savage Hi Mauricio<br/><br/> &gt;Good morning!<br/><br/> &gt;I&#39;m a Mexican PERL fan, and I write first for congratulate you for <br/> &gt;this great job.<br/><br/>Glad to hear you&#39;re using Perl.<br/><br/>And yes, it&#39;s Perl, not PERL.<br/><br/> &gt;I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since <br/> &gt;my Ubuntu console, but I have some issues with the map {$_-&gt;name} <br/> &gt;$stmt-&gt;column_defs() method for parsing it.<br/><br/> &gt;Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on <br/> &gt;unbless object.<br/><br/>We need to see the code. Post the shortest possible sample code which <br/>produces this error.<br/><br/>Are you connecting to a real, pre-existing database with pre-existing <br/>tables?<br/><br/>If so, how /exactly/ are you doing that?<br/><br/> &gt;I will appreciate too much, any information about this error that was <br/> &gt;taken from CPAN documentation of this module.<br/><br/>-- <br/>Ron Savage - savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37002.html Wed, 10 Sep 2014 22:18:55 +0000 Fwd: SQL:Statement/Parser by Jens Rehsack <br/><br/>Anfang der weitergeleiteten Nachricht:<br/><br/>&gt; Von: Mauricio Begovich &lt;mauricio.begovich@gmail.com&gt;<br/>&gt; Betreff: SQL:Statement/Parser<br/>&gt; Datum: 10. September 2014 15:44:55 MESZ<br/>&gt; An: rehsack@cpan.org<br/>&gt; <br/>&gt; Good morning!<br/>&gt; <br/>&gt; I&#39;m a Mexican PERL fan, and I write first for congratulate you for this great job.<br/>&gt; <br/>&gt; I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since my Ubuntu console, but I have some issues with the map {$_-&gt;name} $stmt-&gt;column_defs() method for parsing it.<br/>&gt; <br/>&gt; Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on unbless object.<br/>&gt; <br/>&gt; I will appreciate too much, any information about this error that was taken from CPAN documentation of this module.<br/><br/>-- <br/>Jens Rehsack<br/>rehsack@gmail.com<br/><br/><br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37001.html Wed, 10 Sep 2014 14:40:00 +0000 DBD::Pg 3.4.0 released by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/>Version 3.4.0 of DBD::Pg, the Perl interface to Postgres, <br/>was released on August 16, 2014. The primary changes in this <br/>version are improvements in the table_info() and column_info() <br/>methods: see below for details. As always, you can download <br/>a tarball from CPAN:<br/><br/>http://search.cpan.org/dist/DBD-Pg/<br/><br/>Checksums for version 3.4.0 of DBD::Pg<br/><br/>e1fbe2ac4bd4951f1726a36b315c263c DBD-Pg-3.4.0.tar.gz<br/>611cda7b4eefcc437991eebb4a1561a112554c18 DBD-Pg-3.4.0.tar.gz<br/><br/>The mailing list welcomes any and all questions:<br/><br/>http://www.nntp.perl.org/group/perl.dbd.pg/<br/><br/>Development can be tracked via git:<br/><br/>git://bucardo.org/dbdpg.git<br/><br/>Complete list of changes in 3.4.0:<br/><br/>(git commit 7a5da12d84b4c2e9879f90fb6168f56c095071fa)<br/><br/> - Cleanup and improve table_info()<br/> [Mike Pomraning &lt;mjp@pilcrow.madison.wi.us&gt;] (github issue #7)<br/><br/> table_info() type searching now supports TABLE, VIEW, SYSTEM TABLE,<br/> SYSTEM VIEW, and LOCAL TEMPORARY<br/><br/> table_info() object searching fully supports the above types.<br/><br/> table_info() object searching no longer ignores invalid types - a filter <br/> of &#39;NOSUCH&#39; will return no rows, and &#39;NOSUCH,LOCAL TEMPORARY&#39; will<br/> return only temp objects.<br/><br/> tableinfo() type filters are strictly matched now ... previously a <br/> search for SYSTEM TABLE would have fetched plain TABLE objects.<br/><br/> table_info() now treats temporary tables and temporary views as LOCAL TEMPORARY<br/><br/> - Make sure column_info() and table_info() can handle materialized views.<br/> [Greg Sabino Mullane] (CPAN bug #97032)<br/><br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>PGP Key: 0x14964AC8 201408181051<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlPyEwYACgkQvJuQZxSWSsgBBQCgrYkYnb9Sgv4G5yQJYNQqIOfj<br/>VhkAn2bxny/zVJBOFvOJ/w/AtajXgO52<br/>=70S2<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg37000.html Mon, 18 Aug 2014 14:54:43 +0000 Re: Informinx Perl Module Installation Issues by Jonathan Leffler Hi Sagar,<br/><br/>I&#39;ve tried to get hold of RHEL Tikanga, but it is pretty old (much older<br/>than the version of Perl you are using) and not available for a<br/>sufficiently nominal fee that I can afford to get it just to sort out your<br/>problem.<br/><br/>Please provide the information requested in the Notes/bug.reports file &mdash;<br/>most notably the output of &#39;perl -V&#39; (capital V), which gives information<br/>about the compilation flags used to create Perl, and whether it is<br/>threaded, etc. With that information, I will then try to create a version<br/>of Perl analogous to yours, and then install DBI and DBD::Informix. I&#39;ll<br/>be using Ubuntu 14.04 (in a VM), at least in the first instance. But I had<br/>no problems with the system provided Perl 5.18.2 (compiled with threading).<br/><br/>&#39;perl -V&#39; output for Ubuntu 14.04:<br/><br/>Summary of my perl5 (revision 5 version 18 subversion 2) configuration:<br/><br/> Platform:<br/> osname=linux, osvers=3.2.0-58-generic,<br/>archname=x86_64-linux-gnu-thread-multi<br/> uname=&#39;linux brownie 3.2.0-58-generic #88-ubuntu smp tue dec 3 17:37:58<br/>utc 2013 x86_64 x86_64 x86_64 gnulinux &#39;<br/> config_args=&#39;-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN<br/>-D_FORTIFY_SOURCE=2 -g -O2 -fstack-protector --param=ssp-buffer-size=4<br/>-Wformat -Werror=format-security -Dldflags= -Wl,-Bsymbolic-functions<br/>-Wl,-z,relro -Dlddlflags=-shared -Wl,-Bsymbolic-functions -Wl,-z,relro<br/>-Dcccdlflags=-fPIC -Darchname=x86_64-linux-gnu -Dprefix=/usr<br/>-Dprivlib=/usr/share/perl/5.18 -Darchlib=/usr/lib/perl/5.18<br/>-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5<br/>-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local<br/>-Dsitelib=/usr/local/share/perl/5.18.2<br/>-Dsitearch=/usr/local/lib/perl/5.18.2 -Dman1dir=/usr/share/man/man1<br/>-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1<br/>-Dsiteman3dir=/usr/local/man/man3 -Duse64bitint -Dman1ext=1 -Dman3ext=3perl<br/>-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm<br/>-Ui_libutil -Uversiononly -DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib<br/>-Dlibperl=libperl.so.5.18.2 -des&#39;<br/> hint=recommended, useposix=true, d_sigaction=define<br/> useithreads=define, usemultiplicity=define<br/> useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef<br/> use64bitint=define, use64bitall=define, uselongdouble=undef<br/> usemymalloc=n, bincompat5005=undef<br/> Compiler:<br/> cc=&#39;cc&#39;, ccflags =&#39;-D_REENTRANT -D_GNU_SOURCE -DDEBIAN<br/>-fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include<br/>-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64&#39;,<br/> optimize=&#39;-O2 -g&#39;,<br/> cppflags=&#39;-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector<br/>-fno-strict-aliasing -pipe -I/usr/local/include&#39;<br/> ccversion=&#39;&#39;, gccversion=&#39;4.8.2&#39;, gccosandvers=&#39;&#39;<br/> intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678<br/> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16<br/> ivtype=&#39;long&#39;, ivsize=8, nvtype=&#39;double&#39;, nvsize=8, Off_t=&#39;off_t&#39;,<br/>lseeksize=8<br/> alignbytes=8, prototype=define<br/> Linker and Libraries:<br/> ld=&#39;cc&#39;, ldflags =&#39; -fstack-protector -L/usr/local/lib&#39;<br/> libpth=/usr/local/lib /lib/x86_64-linux-gnu /lib/../lib<br/>/usr/lib/x86_64-linux-gnu /usr/lib/../lib /lib /usr/lib<br/> libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt<br/> perllibs=-ldl -lm -lpthread -lc -lcrypt<br/> libc=, so=so, useshrplib=true, libperl=libperl.so.5.18.2<br/> gnulibc_version=&#39;2.19&#39;<br/> Dynamic Linking:<br/> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=&#39;-Wl,-E&#39;<br/> cccdlflags=&#39;-fPIC&#39;, lddlflags=&#39;-shared -L/usr/local/lib<br/>-fstack-protector&#39;<br/><br/><br/>Characteristics of this binary (from libperl):<br/> Compile-time options: HAS_TIMES MULTIPLICITY PERLIO_LAYERS<br/> PERL_DONT_CREATE_GVSV<br/> PERL_HASH_FUNC_ONE_AT_A_TIME_HARD<br/> PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP<br/> PERL_PRESERVE_IVUV PERL_SAWAMPERSAND USE_64_BIT_ALL<br/> USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES<br/> USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE<br/> USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF<br/> USE_REENTRANT_API<br/> Locally applied patches:<br/> DEBPKG:debian/cpan_definstalldirs - Provide a sensible INSTALLDIRS<br/>default for modules installed from CPAN.<br/> DEBPKG:debian/db_file_ver - http://bugs.debian.org/340047 Remove overly<br/>restrictive DB_File version check.<br/> DEBPKG:debian/doc_info - Replace generic man(1) instructions with<br/>Debian-specific information.<br/> DEBPKG:debian/enc2xs_inc - http://bugs.debian.org/290336 Tweak enc2xs<br/>to follow symlinks and ignore missing @INC directories.<br/> DEBPKG:debian/errno_ver - http://bugs.debian.org/343351 Remove Errno<br/>version check due to upgrade problems with long-running processes.<br/> DEBPKG:debian/libperl_embed_doc - http://bugs.debian.org/186778 Note<br/>that libperl-dev package is required for embedded linking<br/> DEBPKG:fixes/respect_umask - Respect umask during installation<br/> DEBPKG:debian/writable_site_dirs - Set umask approproately for site<br/>install directories<br/> DEBPKG:debian/extutils_set_libperl_path - EU:MM: Set location of<br/>libperl.a to /usr/lib<br/> DEBPKG:debian/no_packlist_perllocal - Don&#39;t install .packlist or<br/>perllocal.pod for perl or vendor<br/> DEBPKG:debian/prefix_changes - Fiddle with *PREFIX and variables<br/>written to the makefile<br/> DEBPKG:debian/fakeroot - Postpone LD_LIBRARY_PATH evaluation to the<br/>binary targets.<br/> DEBPKG:debian/instmodsh_doc - Debian policy doesn&#39;t install .packlist<br/>files for core or vendor.<br/> DEBPKG:debian/ld_run_path - Remove standard libs from LD_RUN_PATH as<br/>per Debian policy.<br/> DEBPKG:debian/libnet_config_path - Set location of libnet.cfg to<br/>/etc/perl/Net as /usr may not be writable.<br/> DEBPKG:debian/mod_paths - Tweak @INC ordering for Debian<br/> DEBPKG:debian/module_build_man_extensions -<br/>http://bugs.debian.org/479460 Adjust Module::Build manual page extensions<br/>for the Debian Perl policy<br/> DEBPKG:debian/prune_libs - http://bugs.debian.org/128355 Prune the list<br/>of libraries wanted to what we actually need.<br/> DEBPKG:fixes/net_smtp_docs - [rt.cpan.org #36038]<br/>http://bugs.debian.org/100195 Document the Net::SMTP &#39;Port&#39; option<br/> DEBPKG:debian/perlivp - http://bugs.debian.org/510895 Make perlivp skip<br/>include directories in /usr/local<br/> DEBPKG:debian/cpanplus_definstalldirs - http://bugs.debian.org/533707<br/>Configure CPANPLUS to use the site directories by default.<br/> DEBPKG:debian/cpanplus_config_path - Save local versions of<br/>CPANPLUS::Config::System into /etc/perl.<br/> DEBPKG:debian/deprecate-with-apt - http://bugs.debian.org/702096 Point<br/>users to Debian packages of deprecated core modules<br/> DEBPKG:debian/squelch-locale-warnings - http://bugs.debian.org/508764<br/>Squelch locale warnings in Debian package maintainer scripts<br/> DEBPKG:debian/skip-upstream-git-tests - Skip tests specific to the<br/>upstream Git repository<br/> DEBPKG:debian/patchlevel - http://bugs.debian.org/567489 List packaged<br/>patches for 5.18.2-2ubuntu1 in patchlevel.h<br/> DEBPKG:debian/skip-kfreebsd-crash - http://bugs.debian.org/628493 [perl<br/>#96272] Skip a crashing test case in t/op/threads.t on GNU/kFreeBSD<br/> DEBPKG:fixes/document_makemaker_ccflags - http://bugs.debian.org/628522<br/>[rt.cpan.org #68613] Document that CCFLAGS should include $Config{ccflags}<br/> DEBPKG:debian/find_html2text - http://bugs.debian.org/640479 Configure<br/>CPAN::Distribution with correct name of html2text<br/> DEBPKG:debian/hurd_test_skip_stack - http://bugs.debian.org/650175<br/>Disable failing GNU/Hurd tests dist/threads/t/stack.t<br/> DEBPKG:fixes/manpage_name_Test-Harness - http://bugs.debian.org/650451 [<br/>rt.cpan.org #73399] cpan/Test-Harness: add NAME headings in modules with POD<br/> DEBPKG:debian/makemaker-pasthru - http://bugs.debian.org/660195 [<br/>rt.cpan.org #28632] Make EU::MM pass LD through to recursive Makefile.PL<br/>invocations<br/> DEBPKG:debian/perl5db-x-terminal-emulator.patch -<br/>http://bugs.debian.org/668490 Invoke x-terminal-emulator rather than xterm<br/>in perl5db.pl<br/> DEBPKG:debian/cpan-missing-site-dirs - http://bugs.debian.org/688842<br/>Fix CPAN::FirstTime defaults with nonexisting site dirs if a parent is<br/>writable<br/> DEBPKG:fixes/memoize_storable_nstore - [rt.cpan.org #77790]<br/>http://bugs.debian.org/587650 Memoize::Storable: respect &#39;nstore&#39; option<br/>not respected<br/> DEBPKG:fixes/net_ftp_failed_command - [rt.cpan.org #37700]<br/>http://bugs.debian.org/491062 Net::FTP: cope gracefully with a failed<br/>command<br/> DEBPKG:fixes/perlbug-patchlist - [3541c11] http://bugs.debian.org/710842<br/>[perl #118433] Make perlbug look up the list of local patches at run time<br/> DEBPKG:fixes/module_metadata_security_doc - [68cdd4b] CVE-2013-1437<br/>documentation fix<br/> DEBPKG:fixes/module_metadata_taint_fix - [bff978f]<br/>http://bugs.debian.org/722210 [rt.cpan.org #88576] untaint version, if<br/>needed, in Module::Metadata<br/> DEBPKG:fixes/IPC-SysV-spelling - http://bugs.debian.org/730558 [<br/>rt.cpan.org #86736] Fix spelling of IPC_CREAT in IPC-SysV documentation<br/> DEBPKG:fixes/fix-undef-source -<br/> Built under linux<br/> Compiled at Mar 27 2014 18:30:28<br/> @INC:<br/> /etc/perl<br/> /usr/local/lib/perl/5.18.2<br/> /usr/local/share/perl/5.18.2<br/> /usr/lib/perl5<br/> /usr/share/perl5<br/> /usr/lib/perl/5.18<br/> /usr/share/perl/5.18<br/> /usr/local/lib/site_perl<br/> .<br/><br/><br/><br/>On Fri, Aug 8, 2014 at 9:21 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/><br/>&gt; Hi Jonathan,<br/>&gt;<br/>&gt; Thanks for the update.<br/>&gt;<br/>&gt; I have run the installation successfully in my lab server and unable to do<br/>&gt; it on production servers.<br/>&gt;<br/>&gt; RHEL version and PERL version on both servers are same. I will give you<br/>&gt; the complete details.<br/>&gt;<br/>&gt; =================<br/>&gt; *Lab Server*<br/>&gt;<br/>&gt; [root@inhusz1-sdcitnm 5.18.2]# cat /etc/redhat-release<br/>&gt; Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/>&gt;<br/>&gt; [root@inhusz1-sdcitnm 5.18.2]# gcc --version<br/>&gt; *gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>&gt; Copyright (C) 2006 Free Software Foundation, Inc.<br/>&gt; This is free software; see the source for copying conditions. There is NO<br/>&gt; warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/>&gt;<br/>&gt; [root@inhusz1-sdcitnm DBD-Informix-2013.0521]# perl -v<br/>&gt;<br/>&gt; *This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/>&gt;<br/>&gt; Copyright 1987-2013, Larry Wall<br/>&gt;<br/>&gt; Perl may be copied only under the terms of either the Artistic License or<br/>&gt; the<br/>&gt; GNU General Public License, which may be found in the Perl 5 source kit.<br/>&gt;<br/>&gt; Complete documentation for Perl, including FAQ lists, should be found on<br/>&gt; this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>&gt; Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/>&gt;<br/>&gt; *Customer Server*<br/>&gt;<br/>&gt; [root@CRPVLX1NETCOOLITNM ~]# cat /etc/redhat-release<br/>&gt; Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/>&gt;<br/>&gt; [root@CRPVLX1NETCOOLITNM ~]# gcc --version<br/>&gt; *gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>&gt; Copyright (C) 2006 Free Software Foundation, Inc.<br/>&gt; This is free software; see the source for copying conditions. There is NO<br/>&gt; warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/>&gt;<br/>&gt; [root@CRPVLX1NETCOOLITNM]# perl -v<br/>&gt;<br/>&gt; *This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/>&gt;<br/>&gt; Copyright 1987-2013, Larry Wall<br/>&gt;<br/>&gt; Perl may be copied only under the terms of either the Artistic License or<br/>&gt; the<br/>&gt; GNU General Public License, which may be found in the Perl 5 source kit.<br/>&gt;<br/>&gt; Complete documentation for Perl, including FAQ lists, should be found on<br/>&gt; this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>&gt; Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/>&gt;<br/>&gt; =================<br/>&gt;<br/>&gt; Could you please let me know what would be the solution to resolve the<br/>&gt; issue.<br/>&gt;<br/>&gt; Thanks,<br/>&gt; Sagar<br/>&gt;<br/>&gt;<br/>&gt; On Fri, Aug 8, 2014 at 6:42 PM, Jonathan Leffler &lt;<br/>&gt; jonathan.leffler@gmail.com&gt; wrote:<br/>&gt;<br/>&gt;&gt; It means there is a mismatch between the code used in compiling<br/>&gt;&gt; DBD::Informix and the code used in compiling Perl. You&#39;ve not given<br/>&gt;&gt; explicit platform information (it seems to be a 64-bit RedHat Linux), nor<br/>&gt;&gt; the version of Perl. This problem occurred semi-regularly&hellip;oh, about ten<br/>&gt;&gt; years ago. It hasn&#39;t often been a problem since. It might be that you&#39;re<br/>&gt;&gt; using a threaded Perl, but it isn&#39;t supposed to be a problem.<br/>&gt;&gt;<br/>&gt;&gt; Please look at the bug reporting instructions in the file<br/>&gt;&gt; Notes/bug.reports and use the script BugReport.<br/>&gt;&gt;<br/>&gt;&gt; It&#39;ll be a couple of days or so before I can look at the problem in any<br/>&gt;&gt; detail.<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; On Thu, Aug 7, 2014 at 11:00 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/>&gt;&gt;<br/>&gt;&gt;&gt; Hi Team,<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; I am facing issues while running make command while installing the<br/>&gt;&gt;&gt; Informix perl module.<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; Here is the error snippet.<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>&gt;&gt;&gt; -L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>&gt;&gt;&gt; -fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>&gt;&gt;&gt; ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>&gt;&gt;&gt; blib/arch/auto/DBD/Informix/Informix.so \<br/>&gt;&gt;&gt; \<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>&gt;&gt;&gt; function `_start&#39;:<br/>&gt;&gt;&gt; (.text+0x20): undefined reference to `main&#39;<br/>&gt;&gt;&gt; Informix.o: In function `dbi_get_state&#39;:<br/>&gt;&gt;&gt; Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt;&gt; Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x116): undefined reference to<br/>&gt;&gt;&gt; `Perl_xs_apiversion_bootcheck&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x139): undefined reference to<br/>&gt;&gt;&gt; `Perl_xs_version_bootcheck&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>&gt;&gt;&gt; `Perl_newXS_flags&#39; follow<br/>&gt;&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt;&gt; Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; collect2: ld returned 1 exit status<br/>&gt;&gt;&gt; make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; Please let me know what need to do here.<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; -Thanks,<br/>&gt;&gt;&gt; Sagar<br/>&gt;&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; --<br/>&gt;&gt; Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>&gt;&gt; Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&gt;&gt; &quot;Blessed are we who can laugh at ourselves, for we shall never cease to<br/>&gt;&gt; be amused.&quot;<br/>&gt;&gt;<br/>&gt;<br/>&gt;<br/><br/><br/>-- <br/>Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>amused.&quot;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36999.html Thu, 14 Aug 2014 05:22:15 +0000 buffer allocation bug in DBD::mysql leading to failures (was:DBD::mysql mysql_server_prepare=1 caching of statement handles) by Marc Lehmann Hi!<br/><br/>I am not susbcribed to this list - I wanted to add information to a previous<br/>issue reported by Wouter de Geus (e.g. in http://code.activestate.com/lists/perl-dbi-users/36031/)<br/><br/>I ran into what is probably exactly the same problem as him and debugged<br/>it a bit further. I now believe this is simply a bug in the prepared<br/>statement implementation of DBD::mysql.<br/><br/>I&#39;ve directly cc&#39;ed Patrick Galbraith, as it seems rt.cpan.org is a<br/>blackhole for DBD::mysql bug reports nowadays, and this bug effectively<br/>renders prepared statements useless. (Patrick, if DBD::mysql is no longer<br/>maintained by you, do you happen to know by whom it is maintaiend these<br/>days, if anybody?)<br/><br/>Here is a typical trace of a repeated invocation, which matches the trace<br/>provided by Wouter. This works:<br/><br/> -&gt; fetchrow_arrayref for DBD::mysql::st (DBI::st=HASH(0x1f8aa20)~0x1f52d38)<br/> -&gt; dbd_st_fetch<br/> --&gt; dbd_describe<br/> dbd_describe() num_fields 1<br/> i 0 col_type 253 fbh-&gt;length 0<br/> fields[i].length 255 fields[i].max_length 41 fields[i].type 253 fields[i].charsetnr 63<br/> mysql_to_perl_type returned 253<br/> &lt;- dbd_describe<br/> dbd_st_fetch for 01f8aa80, chopblanks 0<br/> dbd_st_fetch calling mysql_fetch<br/><br/>And this fails, due to the MYSQL_DATA_TRUNCATED result:<br/><br/> &gt;&gt; fetchrow_arrayref DISPATCH (DBI::st=HASH(0x1f8aa20) rc1/1 @1 g2 ima0 pid#3097) at Schback/Slave.pm line 395 via at ./schbackd line 81<br/> -&gt; fetchrow_arrayref for DBD::mysql::st (DBI::st=HASH(0x1f8aa20)~0x1f52d38)<br/> -&gt; dbd_st_fetch<br/> dbd_st_fetch for 01f8aa80, chopblanks 0<br/> dbd_st_fetch calling mysql_fetch<br/> dbd_st_fetch data truncated<br/><br/>I found that this happens when I reuse the same statement handle and the<br/>second invocation returns a longer result for a field than the first.<br/><br/>I verified using ltrace -e memcpy that the buffer_length allocated in the<br/>failure case is the 41 from the previous execute, which is too small for<br/>the next one, causing the failure.<br/><br/>Lo and behold, an obvious testcase reproduces the bug:<br/><br/> $dbh = DBI-&gt;connect (&quot;dbi:mysql:test;mysql_read_default_group=client;mysql_server_prepare=1&quot;, &quot;&quot;, &quot;&quot;);<br/><br/> # DBI-&gt;trace (2);<br/><br/> $st = $dbh-&gt;prepare (&quot;select ?&quot;);<br/> $st-&gt;execute (&quot;1234&quot;);<br/> warn $st-&gt;fetchrow_arrayref;<br/><br/> $st-&gt;execute (&quot;123456789&quot;);<br/> warn $st-&gt;fetchrow_arrayref; # fails due to MYSQL_DATA_TRUNCATED<br/><br/>The first execute works, and fetchrow_arrayref returns the result row. The<br/>second execute works as well, but fetchrow_arrayref returns undef. When<br/>enabling tracing, it shows that the second fetch fails because of<br/>MYSQL_DATA_TRUNCATED status.<br/><br/>Clearly, something in DBD::mysql caches maximum buffer sizes between<br/>executes when it shouldn&#39;t.<br/><br/>-- <br/> The choice of a Deliantra, the free code+content MORPG<br/> -----==- _GNU_ http://www.deliantra.net<br/> ----==-- _ generation<br/> ---==---(_)__ __ ____ __ Marc Lehmann<br/> --==---/ / _ \/ // /\ \/ / schmorp@schmorp.de<br/> -=====/_/_//_/\_,_/ /_/\_\<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36998.html Wed, 13 Aug 2014 08:24:03 +0000 Re: Informinx Perl Module Installation Issues by sagar nch Hi Jonathan,<br/><br/>Thanks for the update.<br/><br/>I have run the installation successfully in my lab server and unable to do<br/>it on production servers.<br/><br/>RHEL version and PERL version on both servers are same. I will give you<br/>the complete details.<br/><br/>=================<br/>*Lab Server*<br/><br/>[root@inhusz1-sdcitnm 5.18.2]# cat /etc/redhat-release<br/>Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/><br/>[root@inhusz1-sdcitnm 5.18.2]# gcc --version<br/>*gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>Copyright (C) 2006 Free Software Foundation, Inc.<br/>This is free software; see the source for copying conditions. There is NO<br/>warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/><br/>[root@inhusz1-sdcitnm DBD-Informix-2013.0521]# perl -v<br/><br/>*This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/><br/>Copyright 1987-2013, Larry Wall<br/><br/>Perl may be copied only under the terms of either the Artistic License or<br/>the<br/>GNU General Public License, which may be found in the Perl 5 source kit.<br/><br/>Complete documentation for Perl, including FAQ lists, should be found on<br/>this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/><br/>*Customer Server*<br/><br/>[root@CRPVLX1NETCOOLITNM ~]# cat /etc/redhat-release<br/>Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/><br/>[root@CRPVLX1NETCOOLITNM ~]# gcc --version<br/>*gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>Copyright (C) 2006 Free Software Foundation, Inc.<br/>This is free software; see the source for copying conditions. There is NO<br/>warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/><br/>[root@CRPVLX1NETCOOLITNM]# perl -v<br/><br/>*This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/><br/>Copyright 1987-2013, Larry Wall<br/><br/>Perl may be copied only under the terms of either the Artistic License or<br/>the<br/>GNU General Public License, which may be found in the Perl 5 source kit.<br/><br/>Complete documentation for Perl, including FAQ lists, should be found on<br/>this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/><br/>=================<br/><br/>Could you please let me know what would be the solution to resolve the<br/>issue.<br/><br/>Thanks,<br/>Sagar<br/><br/>On Fri, Aug 8, 2014 at 6:42 PM, Jonathan Leffler &lt;jonathan.leffler@gmail.com<br/>&gt; wrote:<br/><br/>&gt; It means there is a mismatch between the code used in compiling<br/>&gt; DBD::Informix and the code used in compiling Perl. You&#39;ve not given<br/>&gt; explicit platform information (it seems to be a 64-bit RedHat Linux), nor<br/>&gt; the version of Perl. This problem occurred semi-regularly&hellip;oh, about ten<br/>&gt; years ago. It hasn&#39;t often been a problem since. It might be that you&#39;re<br/>&gt; using a threaded Perl, but it isn&#39;t supposed to be a problem.<br/>&gt;<br/>&gt; Please look at the bug reporting instructions in the file<br/>&gt; Notes/bug.reports and use the script BugReport.<br/>&gt;<br/>&gt; It&#39;ll be a couple of days or so before I can look at the problem in any<br/>&gt; detail.<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; On Thu, Aug 7, 2014 at 11:00 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/>&gt;<br/>&gt;&gt; Hi Team,<br/>&gt;&gt;<br/>&gt;&gt; I am facing issues while running make command while installing the<br/>&gt;&gt; Informix perl module.<br/>&gt;&gt;<br/>&gt;&gt; Here is the error snippet.<br/>&gt;&gt;<br/>&gt;&gt; INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>&gt;&gt; -L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>&gt;&gt; -fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>&gt;&gt; ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>&gt;&gt; blib/arch/auto/DBD/Informix/Informix.so \<br/>&gt;&gt; \<br/>&gt;&gt;<br/>&gt;&gt; /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>&gt;&gt; function `_start&#39;:<br/>&gt;&gt; (.text+0x20): undefined reference to `main&#39;<br/>&gt;&gt; Informix.o: In function `dbi_get_state&#39;:<br/>&gt;&gt; Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>&gt;&gt; Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt; Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; Informix.c:(.text+0x116): undefined reference to<br/>&gt;&gt; `Perl_xs_apiversion_bootcheck&#39;<br/>&gt;&gt; Informix.c:(.text+0x139): undefined reference to<br/>&gt;&gt; `Perl_xs_version_bootcheck&#39;<br/>&gt;&gt; Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>&gt;&gt; `Perl_newXS_flags&#39; follow<br/>&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt; Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;<br/>&gt;&gt; bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>&gt;&gt; dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; collect2: ld returned 1 exit status<br/>&gt;&gt; make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/>&gt;&gt;<br/>&gt;&gt; Please let me know what need to do here.<br/>&gt;&gt;<br/>&gt;&gt; -Thanks,<br/>&gt;&gt; Sagar<br/>&gt;&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; --<br/>&gt; Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>&gt; Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&gt; &quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>&gt; amused.&quot;<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36997.html Sat, 09 Aug 2014 05:42:21 +0000 Re: Informinx Perl Module Installation Issues by Jonathan Leffler It means there is a mismatch between the code used in compiling<br/>DBD::Informix and the code used in compiling Perl. You&#39;ve not given<br/>explicit platform information (it seems to be a 64-bit RedHat Linux), nor<br/>the version of Perl. This problem occurred semi-regularly&hellip;oh, about ten<br/>years ago. It hasn&#39;t often been a problem since. It might be that you&#39;re<br/>using a threaded Perl, but it isn&#39;t supposed to be a problem.<br/><br/>Please look at the bug reporting instructions in the file Notes/bug.reports<br/>and use the script BugReport.<br/><br/>It&#39;ll be a couple of days or so before I can look at the problem in any<br/>detail.<br/><br/><br/><br/>On Thu, Aug 7, 2014 at 11:00 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/><br/>&gt; Hi Team,<br/>&gt;<br/>&gt; I am facing issues while running make command while installing the<br/>&gt; Informix perl module.<br/>&gt;<br/>&gt; Here is the error snippet.<br/>&gt;<br/>&gt; INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>&gt; -L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>&gt; -fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>&gt; ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>&gt; blib/arch/auto/DBD/Informix/Informix.so \<br/>&gt; \<br/>&gt;<br/>&gt; /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>&gt; function `_start&#39;:<br/>&gt; (.text+0x20): undefined reference to `main&#39;<br/>&gt; Informix.o: In function `dbi_get_state&#39;:<br/>&gt; Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>&gt; Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>&gt; Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>&gt; Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt; Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>&gt; Informix.c:(.text+0x116): undefined reference to<br/>&gt; `Perl_xs_apiversion_bootcheck&#39;<br/>&gt; Informix.c:(.text+0x139): undefined reference to<br/>&gt; `Perl_xs_version_bootcheck&#39;<br/>&gt; Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>&gt; `Perl_newXS_flags&#39; follow<br/>&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt; Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/>&gt;<br/>&gt; bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>&gt; dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt; dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; collect2: ld returned 1 exit status<br/>&gt; make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/>&gt;<br/>&gt; Please let me know what need to do here.<br/>&gt;<br/>&gt; -Thanks,<br/>&gt; Sagar<br/>&gt;<br/><br/><br/><br/>-- <br/>Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>amused.&quot;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36996.html Fri, 08 Aug 2014 13:13:10 +0000 Informinx Perl Module Installation Issues by sagar nch Hi Team,<br/><br/>I am facing issues while running make command while installing the Informix<br/>perl module.<br/><br/>Here is the error snippet.<br/><br/>INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>-L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>-fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>blib/arch/auto/DBD/Informix/Informix.so \<br/> \<br/><br/>/usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>function `_start&#39;:<br/>(.text+0x20): undefined reference to `main&#39;<br/>Informix.o: In function `dbi_get_state&#39;:<br/>Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>Informix.o: In function `boot_DBD__Informix&#39;:<br/>Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>Informix.c:(.text+0x116): undefined reference to<br/>`Perl_xs_apiversion_bootcheck&#39;<br/>Informix.c:(.text+0x139): undefined reference to `Perl_xs_version_bootcheck&#39;<br/>Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>`Perl_newXS_flags&#39; follow<br/>Informix.o: In function `boot_DBD__Informix&#39;:<br/>Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/><br/>bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>collect2: ld returned 1 exit status<br/>make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/><br/>Please let me know what need to do here.<br/><br/>-Thanks,<br/>Sagar<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36995.html Fri, 08 Aug 2014 07:45:48 +0000 Re: DBD::mysql 4.028 released by Paul DuBois <br/>On Aug 2, 2014, at 10:15 PM, Patrick Galbraith wrote:<br/><br/>&gt; Dear Pert and MySQL community,<br/>&gt; <br/>&gt; I&rdquo;m pleased to announce the release of DBD::mysql 4.028. This release includes several fixes, per change log:<br/>&gt; <br/>&gt; * Fixed bug in mysql.xs where dbh was being used as error code<br/><br/>Thanks. I was seeing a mysterious error that a failure of connect() was returning the object rather than undef. It&#39;s now gone after upgrading.<br/><br/>&gt; * RT #97570: fix wrong salloc free in mysql_st_internal_execute - (Reini Urban, cPanel)<br/>&gt; * Fix RT #97625 use-after-free in mysql_dr_error, and #86153 - (Reini Urban, cPanel)<br/>&gt; * find mysql.h for MariaDB on Win32 (Graham Ollis)<br/>&gt; * Update mysql.pm to work with ipv6 and ipv4 addresses (katyavoid)<br/>&gt; <br/>&gt; I want to thank Reini Urban, Graham Ollis, and Katyavoid for their pull requests and contributions to DBD::mysql!<br/>&gt; <br/>&gt; Please feel free to visit:<br/>&gt; <br/>&gt; http://search.cpan.org/~capttofu/DBD-mysql-4.028/<br/>&gt; <br/>&gt; And as always:<br/>&gt; <br/>&gt; https://github.com/perl5-dbi/DBD-mysql.git<br/>&gt; <br/>&gt; Regards,<br/>&gt; <br/>&gt; Patrick Galbraith<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36994.html Sun, 03 Aug 2014 19:53:43 +0000 Re: DBD::mysql 4.028 released by Patrick Galbraith <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36993.html Sun, 03 Aug 2014 03:18:54 +0000 DBD::mysql 4.028 released by Patrick Galbraith <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36992.html Sun, 03 Aug 2014 03:15:27 +0000 RE: Bad error message by Meir Guttman <br/><br/>&gt; -----Original Message-----<br/>&gt; From: Peter J. Holzer [mailto:hjp@wsr.ac.at]<br/>&gt; Sent: &#x5D9;&#x5D5;&#x5DD;&nbsp;&#x5D2; 29 &#x5D9;&#x5D5;&#x5DC;&#x5D9; 2014 11:23<br/>&gt; To: Stuart Cooper<br/>&gt; Cc: Meir Guttman; dbi-users@perl.org<br/>&gt; Subject: Re: Bad error message<br/>&gt; <br/><br/> ------<br/><br/>&gt; <br/>&gt; However, not all RDBMSs support proper prepared statements and bind<br/>&gt; values, and even for those that do, the driver may not use them<br/>&gt; (DBD::mysql only uses them if mysql_server_prepare is set). <br/><br/>Dear, dear Peter,<br/><br/>Thank you very much for the tip!<br/><br/>Indeed, acting on your tip and adding &quot;mysql_server_prepare =&gt; 1,&quot; to my<br/>%conn_attrs hash indeed caught the missing back-tick error right away!<br/><br/>(Your reaction to my post will no doubt be RTFM! And you will be right... :(<br/>)<br/><br/>MeirG<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36991.html Tue, 29 Jul 2014 08:48:24 +0000 Re: Bad error message by Peter J. Holzer On 2014-07-27 23:07:02 +1000, Stuart Cooper wrote:<br/>&gt; Because of your missing a backquote you effectively got an SQL statement<br/>&gt; with 0 bind variables.<br/><br/>Yes, however:<br/><br/>[...]<br/>&gt; On Sun, Jul 27, 2014 at 7:44 PM, Meir Guttman &lt;meir@guttman.co.il&gt; wrote:<br/>[...]<br/>&gt; my $sql = qq(<br/>&gt; &nbsp; REPLACE INTO `test.`params`<br/>&gt; &nbsp; -- missing &nbsp; &nbsp; &nbsp; &nbsp;^<br/>&gt; &nbsp; -- back-tick &nbsp; &nbsp; &nbsp;|<br/>&gt; &nbsp; -- here ----------+<br/>&gt; &nbsp; (`ID`,`AsOf_date`,`Value`) VALUES<br/>&gt; &nbsp; (?,?,?)<br/>&gt; &nbsp; );<br/>&gt; <br/>&gt; my $sth = $dbh-&gt;prepare($sql) // die &quot;&#39;prepare&#39; error:\n$DBI::errstr&quot;;<br/><br/>One would naively expect that prepare would notice the syntax error and<br/>return an error here, instead of returning a valid statement handle with<br/>0 placeholders.<br/><br/>&gt; my $affected = $sth-&gt;execute(&#39;0123&#39;, &#39;2014-06-24&#39;, 1000) // die &quot;&#39;execute&#39;<br/>&gt; error:\n$DBI::errstr&quot;;<br/><br/>So this would never be reached. <br/><br/>However, not all RDBMSs support proper prepared statements and bind<br/>values, and even for those that do, the driver may not use them<br/>(DBD::mysql only uses them if mysql_server_prepare is set). If they<br/>aren&#39;t used they must be simulated by inserting properly quoted strings<br/>into the statement and the database will only see the final, composed<br/>statement. So it&#39;s possible that the wrong number of parameters is<br/>noticed before a syntax error.<br/><br/>I still think this is a bug: The backquotes are obviously considered<br/>while scanning for placeholders, so the fact that they are mismatched<br/>should be noticed.<br/><br/> hp<br/><br/><br/>-- <br/> _ | Peter J. Holzer | I think we need two definitions:<br/>|_|_) | WSR - Softwaredevelopment | 1) The problem the *users* want us to solve<br/>| | | und Projektunterst&uuml;tzung | 2) The problem our solution addresses.<br/>__/ | hjp@wsr.ac.at | -- Phillip Hallam-Baker on spam<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36990.html Tue, 29 Jul 2014 08:23:25 +0000 Re: Bad error message by Stuart Cooper Hi Meir,<br/><br/>Remember that the process of changing the ? placeholders to actual variables<br/>is called &quot;binding&quot;.. and that can go wrong if for example you have 4 ?<br/>placeholders<br/>and provide 3 values or you have 0 ? and provide 3 values.<br/><br/>Because of your missing a backquote you effectively got an SQL statement<br/>with 0 bind variables. The first time perl::DBI was able to figure that out<br/>was the mismatch of what it thought were 0 ? placeholders with 3 you<br/>provided.<br/><br/>Look into some better text editors.. the best ones will colour-highlight<br/>your strings<br/>and it&#39;ll be easier to find when you make an omission like yours. I&#39;ve never<br/>liked the `test`.`params` strict way of MySQL table naming.. you already<br/>know you&#39;re using the `test` database so let&#39;s just call the table &#39;params&#39;.<br/>Also the qq() is a bit of overkill, let&#39;s just write is as a single perl<br/>string,<br/>and I&#39;ll use normal single quotes around the field names and table name<br/>params.<br/><br/>my $sql=&quot; REPLACE INTO &#39;params&#39;<br/> (&#39;ID&#39;,&#39;AsOf_date&#39;,&#39;Value&#39;) VALUES<br/> (?,?,?)<br/>&quot;;<br/><br/>You will need more complex qq() operators sometimes, but for your task<br/>I find the simpler string much preferable.<br/><br/>Some MySQL utilities like mysqldump will write table names as<br/>`test`.`params`<br/>but that&#39;s to cater for silly tablenames with spaces in them or unicode or<br/>stuff<br/>and you know that&#39;s not the case with your data, so go with the simpler<br/>form.<br/><br/>Hope this helps,<br/>Stuart.<br/><br/><br/><br/>On Sun, Jul 27, 2014 at 7:44 PM, Meir Guttman &lt;meir@guttman.co.il&gt; wrote:<br/><br/>&gt; Dear DBI folks,<br/>&gt;<br/>&gt; The other day I had a trivial typo in my DBI SQL query that gave me an<br/>&gt; outlandish error message and grief. So outlandish that I spent two hours<br/>&gt; looking for the culprit.<br/>&gt;<br/>&gt; All it was is a missing closing back-tic in the db name part of the<br/>&gt; `database_name`.`table_name` SQL clause, see the code.<br/>&gt;<br/>&gt; Here is the test program:<br/>&gt;<br/>&gt; &lt;code&gt;<br/>&gt; use strict;<br/>&gt; use warnings;<br/>&gt; use utf8;<br/>&gt; use DBI;<br/>&gt;<br/>&gt; my %conn_attrs = (<br/>&gt; RaiseError =&gt; 0,<br/>&gt; PrintError =&gt; 0,<br/>&gt; AutoCommit =&gt; 1,<br/>&gt; mysql_enable_utf8 =&gt; 1,<br/>&gt; );<br/>&gt;<br/>&gt; my $dbh = DBI-&gt;connect (<br/>&gt; &#39;DBI:mysql:test:localhost&#39;,<br/>&gt; &#39;my_account&#39;,<br/>&gt; &#39;secret&#39;,<br/>&gt; \%conn_attrs<br/>&gt; );<br/>&gt;<br/>&gt; my $sql = qq(<br/>&gt; REPLACE INTO `test.`params`<br/>&gt; -- missing ^<br/>&gt; -- back-tick |<br/>&gt; -- here ----------+<br/>&gt; (`ID`,`AsOf_date`,`Value`) VALUES<br/>&gt; (?,?,?)<br/>&gt; );<br/>&gt;<br/>&gt; my $sth = $dbh-&gt;prepare($sql) // die &quot;&#39;prepare&#39; error:\n$DBI::errstr&quot;;<br/>&gt; my $affected = $sth-&gt;execute(&#39;0123&#39;, &#39;2014-06-24&#39;, 1000) // die &quot;&#39;execute&#39;<br/>&gt; error:\n$DBI::errstr&quot;;<br/>&gt; $affected += 0;<br/>&gt; print &quot;$affected row was inserted&quot;;<br/>&gt; __END__<br/>&gt; &lt;/code&gt;<br/>&gt;<br/>&gt;<br/>&gt; This resulted with the following error message:<br/>&gt;<br/>&gt; &#39;execute&#39; error:<br/>&gt; called with 3 bind variables when 0 are needed at DBI_error_test.pl line<br/>&gt; 31.<br/>&gt;<br/>&gt; Wherefrom in Scott&#39;s name did you take the idea that &quot;... 0 (bind<br/>&gt; variables)<br/>&gt; are needed...???&quot;<br/>&gt;<br/>&gt; BTW, executing the very same SQL in MySQL WorkBench resulted with a<br/>&gt; straight<br/>&gt; forward &quot;Syntax error ...&quot;<br/>&gt;<br/>&gt; Well, IMHO, MySQL does not, repeat does not, merit any reward for clear and<br/>&gt; meaningful error messages. But this DBI/DBD one might be a winner. Is that<br/>&gt; a<br/>&gt; bug or is there a good reason for that?<br/>&gt;<br/>&gt; And finally Versions:<br/>&gt; ========<br/>&gt; OS: Win 7 (Fully updated)<br/>&gt; Strawberry Perl 5.18.2<br/>&gt; MySQL 5.5.25a<br/>&gt;<br/>&gt; perl module installed latest<br/>&gt; ---------- --------- -------<br/>&gt; DBI 1.6300 1.6310<br/>&gt; DBD::ODBC 1.4700 1.5000<br/>&gt; DBD::mysql 4.0250 4.0270<br/>&gt;<br/>&gt; Regards,<br/>&gt; MeirG<br/>&gt;<br/>&gt;<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36989.html Sun, 27 Jul 2014 13:07:10 +0000 Bad error message by Meir Guttman Dear DBI folks,<br/><br/>The other day I had a trivial typo in my DBI SQL query that gave me an<br/>outlandish error message and grief. So outlandish that I spent two hours<br/>looking for the culprit.<br/><br/>All it was is a missing closing back-tic in the db name part of the<br/>`database_name`.`table_name` SQL clause, see the code.<br/><br/>Here is the test program:<br/><br/>&lt;code&gt;<br/>use strict;<br/>use warnings;<br/>use utf8;<br/>use DBI;<br/><br/>my %conn_attrs = (<br/> RaiseError =&gt; 0,<br/> PrintError =&gt; 0,<br/> AutoCommit =&gt; 1,<br/> mysql_enable_utf8 =&gt; 1,<br/> );<br/><br/>my $dbh = DBI-&gt;connect (<br/> &#39;DBI:mysql:test:localhost&#39;,<br/> &#39;my_account&#39;,<br/> &#39;secret&#39;,<br/> \%conn_attrs<br/>);<br/><br/>my $sql = qq(<br/> REPLACE INTO `test.`params`<br/> -- missing ^<br/> -- back-tick |<br/> -- here ----------+<br/> (`ID`,`AsOf_date`,`Value`) VALUES<br/> (?,?,?)<br/> );<br/><br/>my $sth = $dbh-&gt;prepare($sql) // die &quot;&#39;prepare&#39; error:\n$DBI::errstr&quot;;<br/>my $affected = $sth-&gt;execute(&#39;0123&#39;, &#39;2014-06-24&#39;, 1000) // die &quot;&#39;execute&#39;<br/>error:\n$DBI::errstr&quot;;<br/>$affected += 0;<br/>print &quot;$affected row was inserted&quot;;<br/>__END__<br/>&lt;/code&gt;<br/><br/><br/>This resulted with the following error message:<br/><br/>&#39;execute&#39; error:<br/>called with 3 bind variables when 0 are needed at DBI_error_test.pl line 31.<br/><br/>Wherefrom in Scott&#39;s name did you take the idea that &quot;... 0 (bind variables)<br/>are needed...???&quot;<br/><br/>BTW, executing the very same SQL in MySQL WorkBench resulted with a straight<br/>forward &quot;Syntax error ...&quot;<br/><br/>Well, IMHO, MySQL does not, repeat does not, merit any reward for clear and<br/>meaningful error messages. But this DBI/DBD one might be a winner. Is that a<br/>bug or is there a good reason for that?<br/><br/>And finally Versions:<br/>========<br/>OS: Win 7 (Fully updated)<br/>Strawberry Perl 5.18.2<br/>MySQL 5.5.25a<br/><br/>perl module installed latest<br/>---------- --------- -------<br/>DBI 1.6300 1.6310<br/>DBD::ODBC 1.4700 1.5000<br/>DBD::mysql 4.0250 4.0270<br/><br/>Regards,<br/>MeirG<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36988.html Sun, 27 Jul 2014 09:44:29 +0000 New 1.50 release of DBD::ODBC by Martin J. Evans I&#39;ve just uploaded DBD::ODBC 1.50 to the CPAN. This is the culmination of a series of 4 development releases in the 1.49 series. There are a number of bug fixes, enhancements, deprecated features and most importantly some changes in behaviour. See below for a list of changes.<br/><br/>1.50 2014-07-25<br/><br/> [BUG FIXES]<br/><br/> The 80_odbc_diags.t test could fail if a driver fails a table does<br/> not exist test in the prepare instead of the execute.<br/><br/>1.49_4 2014-07-08<br/><br/> [BUG FIXES]<br/><br/> Fixed sql_type_cast.t test which assumed column aliases which stay<br/> lowercase.<br/><br/> Fixed 87_odbc_lob_read.t test which did not bow out of the test<br/> properly if the database was not MS SQL Server.<br/><br/> [DOCUMENTATION]<br/><br/> Revised the query notification example and documentation.<br/><br/> Added a link to a better Query Notification article.<br/><br/>1.49_3 2014-05-01<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned years ago, this release removes the odbc_old_unicode attribute.<br/> If you have a good reason to use it speak up now before the next non-development<br/> release.<br/><br/> [BUG FIXES]<br/><br/> Fix rt89255: Fails to create test table for tests using PostgreSQL odbc driver.<br/> Change test suite to fallback on PRECISION if COLUMN_SIZE is not found.<br/><br/> [ENHANCEMENTS]<br/><br/> Added support for MS SQL Server Query Notification. See the new<br/> section in the pod.<br/><br/> Added a currently undocumented (and experimental)<br/> odbc_describe_param method on a statement handle which takes a<br/> parameter number as the only argument and returns an array of the<br/> data type, parameter size, decimal digits and nullable (as per<br/> SQLDescribeParam).<br/><br/> [DOCUMENTATION]<br/><br/> Added FAQ on truncated column names with freeTDS.<br/><br/> [MISCELLANEOUS]<br/><br/> I have removed the &quot;experimental&quot; tag for odbc_getdiagfield and odbc_getdiagrec<br/> methods.<br/><br/>1.49_2 2014-04-26<br/><br/> [BUG FIXES]<br/><br/> Change to data_sources in 1.49_1 could lead to a compile error since<br/> data_sources was not returning a value if an error occurred.<br/><br/>1.49_1 2014-04-25<br/><br/> [BUG FIXES]<br/><br/> If you had a lot of DSNs on Windows (more than 280 but it depends on<br/> the length of their names) and called the data_sources method it<br/> could crash your script. Code internally changed to stop putting the DSNs<br/> returned on the stack.<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned years ago, the private data_sources method has been<br/> removed - use DBI one instead.<br/><br/> [MISCELLANEOUS]<br/><br/> Added FAQ entry of maximum number of allowed parameters.<br/><br/>Martin<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36987.html Fri, 25 Jul 2014 12:48:06 +0000 Re: DBD::Informix by Helmut Hi Martin,<br/><br/>i tried both, no change/success..<br/>..also copying the libdl.so to the Informix-Lib-Dir<br/><br/>Helmut<br/><br/>Am 09.07.2014 18:22, schrieb Martin J. Evans:<br/>&gt; On 09/07/14 15:58, Helmut wrote:<br/>&gt;&gt; Hi all,<br/>&gt;&gt;<br/>&gt;&gt; i have problems building DBD::Informix.<br/>&gt;&gt;<br/>&gt;&gt; Running Makefile.pl ends up with<br/>&gt;&gt;<br/>&gt;&gt; ..<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlopen&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/esql/libifos.so: undefined reference to `crypt&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlclose&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlerror&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlsym&#39;<br/>&gt;&gt; collect2: Fehler: ld gab 1 als Ende-Status zur&uuml;ck<br/>&gt;&gt; Failed to link test program esqltest<br/>&gt;&gt; running on configuration at lib/DBD/Informix/TechSupport.pm line 225.<br/>&gt;&gt;<br/>&gt;&gt; System: ArchLinux x86-64<br/>&gt;&gt; Perl: v5.18.2<br/>&gt;&gt; Informix: clientsdk.4.10.FC4DE.LINUX<br/>&gt;&gt; DBD-Informix-2013.0521<br/>&gt;&gt;<br/>&gt;&gt; The bug report &quot;perl -Ilib BugReport A&quot; is below / attached.<br/>&gt;&gt;<br/>&gt;&gt; What can i do to track the problem down?<br/>&gt;&gt;<br/>&gt;&gt; Thank you<br/>&gt;&gt; Helmut<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;<br/>&gt; I don&#39;t do Informix but all those missing symbols are in dl.so. Try to<br/>&gt; find a way to get the Makefile.PL to add -ldl to the link line. Maybe<br/>&gt; just setting LDFLAGS=-ldl and exporting it before running Makefile.PL<br/>&gt; will do it.<br/>&gt;<br/>&gt; Martin<br/>&gt;<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36986.html Wed, 09 Jul 2014 17:09:30 +0000 Re: DBD::Informix by Helmut libdl (libdl-2.19.so)<br/>and libcrypt (libcrypt-2.19.so)<br/>are in /usr/lib64<br/>which is in turn a link to /usr/lib<br/><br/>Helmut<br/><br/>Am 09.07.2014 18:27, schrieb Jonathan Leffler:<br/>&gt; You may need to get an extra compilation flag, -ldl, added to the link<br/>&gt; line, though it is a little surprising to find that&#39;s necessary. That<br/>&gt; might solve dlopen, dlclose, dlerror, dlsym. Missing crypt is more<br/>&gt; puzzling; maybe there&#39;s a library -lcrypt or something that&#39;s needed. It<br/>&gt; is very odd, though; those are not normally a problem.<br/>&gt;<br/>&gt; The Perl configuration shows -ldl and -lcrypt are used.<br/>&gt;<br/>&gt; The debug output does not show a linking operation, but it is a linking<br/>&gt; operation which is failing, which is very puzzling. I&#39;ll see what I can<br/>&gt; do to reproduce it.<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; On Wed, Jul 9, 2014 at 7:58 AM, Helmut &lt;hz@hzlabs.de<br/>&gt; &lt;mailto:hz@hzlabs.de&gt;&gt; wrote:<br/>&gt;<br/>&gt; Hi all,<br/>&gt;<br/>&gt; i have problems building DBD::Informix.<br/>&gt;<br/>&gt; Running Makefile.pl ends up with<br/>&gt;<br/>&gt; ..<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlopen&#39;<br/>&gt; /opt/IBM/informix/lib/esql/__libifos.so: undefined reference to `crypt&#39;<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlclose&#39;<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlerror&#39;<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlsym&#39;<br/>&gt; collect2: Fehler: ld gab 1 als Ende-Status zur&uuml;ck<br/>&gt; Failed to link test program esqltest<br/>&gt; running on configuration at lib/DBD/Informix/TechSupport.__pm line 225.<br/>&gt;<br/>&gt; System: ArchLinux x86-64<br/>&gt; Perl: v5.18.2<br/>&gt; Informix: clientsdk.4.10.FC4DE.LINUX<br/>&gt; DBD-Informix-2013.0521<br/>&gt;<br/>&gt; The bug report &quot;perl -Ilib BugReport A&quot; is below / attached.<br/>&gt;<br/>&gt; What can i do to track the problem down?<br/>&gt;<br/>&gt; Thank you<br/>&gt; Helmut<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; --<br/>&gt; Jonathan Leffler &lt;jonathan.leffler@gmail.com<br/>&gt; &lt;mailto:jonathan.leffler@gmail.com&gt;&gt; #include &lt;disclaimer.h&gt;<br/>&gt; Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&gt; &quot;Blessed are we who can laugh at ourselves, for we shall never cease to<br/>&gt; be amused.&quot;<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36985.html Wed, 09 Jul 2014 16:42:10 +0000