perl.dbi.users http://www.nntp.perl.org/group/perl.dbi.users/ ... Copyright 1998-2014 perl.org Tue, 22 Jul 2014 23:50:58 +0000 ask@perl.org 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 Re: DBD::Informix by Jonathan Leffler You may need to get an extra compilation flag, -ldl, added to the link<br/>line, though it is a little surprising to find that&#39;s necessary. That<br/>might solve dlopen, dlclose, dlerror, dlsym. Missing crypt is more<br/>puzzling; maybe there&#39;s a library -lcrypt or something that&#39;s needed. It<br/>is very odd, though; those are not normally a problem.<br/><br/>The Perl configuration shows -ldl and -lcrypt are used.<br/><br/>The debug output does not show a linking operation, but it is a linking<br/>operation which is failing, which is very puzzling. I&#39;ll see what I can do<br/>to reproduce it.<br/><br/><br/><br/><br/>On Wed, Jul 9, 2014 at 7:58 AM, Helmut &lt;hz@hzlabs.de&gt; wrote:<br/><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/><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/07/msg36984.html Wed, 09 Jul 2014 16:28:04 +0000 Re: DBD::Informix by Martin J. Evans On 09/07/14 15:58, Helmut wrote:<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/><br/>I don&#39;t do Informix but all those missing symbols are in dl.so. Try to find a way to get the Makefile.PL to add -ldl to the link line. Maybe just setting LDFLAGS=-ldl and exporting it before running Makefile.PL will do it.<br/><br/>Martin<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36983.html Wed, 09 Jul 2014 16:22:53 +0000 DBD::Informix by Helmut Hi all,<br/><br/>i have problems building DBD::Informix.<br/><br/>Running Makefile.pl ends up with<br/><br/>..<br/>/opt/IBM/informix/lib/libifasf.so: undefined reference to `dlopen&#39;<br/>/opt/IBM/informix/lib/esql/libifos.so: undefined reference to `crypt&#39;<br/>/opt/IBM/informix/lib/libifasf.so: undefined reference to `dlclose&#39;<br/>/opt/IBM/informix/lib/libifasf.so: undefined reference to `dlerror&#39;<br/>/opt/IBM/informix/lib/libifasf.so: undefined reference to `dlsym&#39;<br/>collect2: Fehler: ld gab 1 als Ende-Status zur&uuml;ck<br/>Failed to link test program esqltest<br/>running on configuration at lib/DBD/Informix/TechSupport.pm line 225.<br/><br/>System: ArchLinux x86-64<br/>Perl: v5.18.2<br/>Informix: clientsdk.4.10.FC4DE.LINUX<br/>DBD-Informix-2013.0521<br/><br/>The bug report &quot;perl -Ilib BugReport A&quot; is below / attached.<br/><br/>What can i do to track the problem down?<br/><br/>Thank you<br/>Helmut<br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36982.html Wed, 09 Jul 2014 14:59:01 +0000 perl_dbi_nulls_test.pl by Christian Metzger &lt;html&gt;&lt;head&gt;&lt;/head&gt;&lt;body&gt;&lt;div style=&quot;font-family: Verdana;font-size: 12.0px;&quot;&gt;&lt;div&gt;&lt;br/&gt;<br/>&amp;nbsp;&lt;/div&gt;<br/><br/>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br/><br/>&lt;div&gt;DBI&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; VERSION: 1.616&lt;/div&gt;<br/><br/>&lt;div&gt;DBD::mysql&amp;nbsp;&amp;nbsp; VERSION: 4.027&lt;/div&gt;<br/><br/>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br/><br/>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br/><br/>&lt;div&gt;<br/>&lt;div&gt;Using connect arguments, db version: 5.5.37-MariaDB-wsrep&lt;br/&gt;<br/>=&amp;gt; Drop table &amp;#39;dbi__null_test_tmp&amp;#39;, if it already exists...&lt;br/&gt;<br/>=&amp;gt; Create table &amp;#39;dbi__null_test_tmp&amp;#39;...&lt;br/&gt;<br/>=&amp;gt; Insert 4 rows into the table...&lt;br/&gt;<br/>&amp;nbsp;Inserting values (1, &amp;#39;Homer&amp;#39;)&lt;br/&gt;<br/>&amp;nbsp;Inserting values (2, NULL)&lt;br/&gt;<br/>&amp;nbsp;Inserting values (3, &amp;#39;Marge&amp;#39;)&lt;br/&gt;<br/>&amp;nbsp;Inserting values (4, NULL)&lt;/div&gt;<br/><br/>&lt;div&gt;=&amp;gt; Testing clause style 0: WHERE mycol = ?...&lt;br/&gt;<br/>&amp;nbsp;Selecting row with Marge&lt;br/&gt;<br/>&amp;nbsp;Selecting rows with NULL&lt;br/&gt;<br/>=&amp;gt; WHERE clause style 0 returned incorrect results.&lt;br/&gt;<br/>&amp;nbsp;Non-NULL test rows returned these row ids: 3&lt;br/&gt;<br/>&amp;nbsp;The NULL test rows returned these row ids:&lt;/div&gt;<br/><br/>&lt;div&gt;=&amp;gt; Testing clause style 1: WHERE NVL(mycol, &amp;#39;-&amp;#39;) = NVL(?, &amp;#39;-&amp;#39;)...&lt;br/&gt;<br/>&amp;nbsp;Selecting row with Marge&lt;br/&gt;<br/>DBD::mysql::st execute failed: FUNCTION test.NVL does not exist at ./dbi_nulls_test.pl line 123.&lt;/div&gt;<br/><br/>&lt;div&gt;=&amp;gt; Testing clause style 2: WHERE ISNULL(mycol, &amp;#39;-&amp;#39;) = ISNULL(?, &amp;#39;-&amp;#39;)...&lt;br/&gt;<br/>&amp;nbsp;Selecting row with Marge&lt;br/&gt;<br/>DBD::mysql::st execute failed: Incorrect parameter count in the call to native function &amp;#39;ISNULL&amp;#39; at ./dbi_nulls_test.pl line 123.&lt;/div&gt;<br/><br/>&lt;div&gt;=&amp;gt; Testing clause style 3: WHERE DECODE(mycol, ?, 1, 0) = 1...&lt;br/&gt;<br/>&amp;nbsp;Selecting row with Marge&lt;br/&gt;<br/>DBD::mysql::st execute failed: Incorrect parameter count in the call to native function &amp;#39;DECODE&amp;#39; at ./dbi_nulls_test.pl line 123.&lt;/div&gt;<br/><br/>&lt;div&gt;=&amp;gt; Testing clause style 4: WHERE mycol = ? OR (mycol IS NULL AND ? IS NULL)...&lt;br/&gt;<br/>&amp;nbsp;Selecting row with Marge&lt;br/&gt;<br/>&amp;nbsp;Selecting rows with NULL&lt;br/&gt;<br/>=&amp;gt; WHERE clause style 4 is supported.&lt;/div&gt;<br/><br/>&lt;div&gt;=&amp;gt; Testing clause style 5: WHERE mycol = ? OR (mycol IS NULL AND SP_ISNULL(?) = 1)...&lt;br/&gt;<br/>&amp;nbsp;Selecting row with Marge&lt;br/&gt;<br/>DBD::mysql::st execute failed: FUNCTION test.SP_ISNULL does not exist at ./dbi_nulls_test.pl line 123.&lt;/div&gt;<br/><br/>&lt;div&gt;=&amp;gt; Testing clause style 6: WHERE mycol = ? OR (mycol IS NULL AND ? = 1)...&lt;br/&gt;<br/>&amp;nbsp;Selecting row with Marge&lt;br/&gt;<br/>&amp;nbsp;Selecting rows with NULL&lt;br/&gt;<br/>=&amp;gt; WHERE clause style 6 is supported.&lt;/div&gt;<br/><br/>&lt;div&gt;------------------------------------------------------------------------&lt;br/&gt;<br/>2 styles are supported:&lt;br/&gt;<br/>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Style 4: WHERE mycol = ? OR (mycol IS NULL AND ? IS NULL)&lt;br/&gt;<br/>&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; Style 6: WHERE mycol = ? OR (mycol IS NULL AND ? = 1)&lt;br/&gt;<br/>------------------------------------------------------------------------&lt;/div&gt;<br/><br/>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br/><br/>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br/><br/>&lt;div&gt;&amp;nbsp;&lt;/div&gt;<br/>&lt;/div&gt;&lt;/div&gt;&lt;/body&gt;&lt;/html&gt;<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36981.html Wed, 09 Jul 2014 06:39:45 +0000 Re: DBD::mysql mysql_server_prepare=1 caching of statement handles by Ron Savage Hi Wouter<br/><br/>On 20/06/14 18:00, Wouter de Geus wrote:<br/>&gt; * Ron Savage &lt;ron@savage.net.au&gt; [2014-06-20 08:17:25 +1000]:<br/>&gt;<br/>&gt;&gt; Hi Wouter<br/>&gt;&gt;<br/>&gt;&gt; Which version of DBD::mysql are you using?<br/>&gt;<br/>&gt; DBD::mysql 4.027<br/>&gt; DBI 1.631<br/><br/>Thanx. I can&#39;t explain the problem, but it&#39;s always helpful to know <br/>which versions your dealing with.<br/><br/>-- <br/>Ron Savage<br/>savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36980.html Fri, 20 Jun 2014 23:50:53 +0000 Re: DBD::mysql mysql_server_prepare=1 caching of statement handles by Wouter de Geus * Ron Savage &lt;ron@savage.net.au&gt; [2014-06-20 08:17:25 +1000]:<br/><br/>&gt; Hi Wouter<br/>&gt; <br/>&gt; Which version of DBD::mysql are you using?<br/><br/>DBD::mysql 4.027<br/>DBI 1.631<br/><br/>Wouter<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36979.html Fri, 20 Jun 2014 08:01:00 +0000 Re: DBD::mysql mysql_server_prepare=1 caching of statement handles by Ron Savage Hi Wouter<br/><br/>Which version of DBD::mysql are you using?<br/><br/>-- <br/>Ron Savage<br/>savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36978.html Thu, 19 Jun 2014 22:17:41 +0000 DBD::mysql mysql_server_prepare=1 caching of statement handles by Wouter de Geus Hej folks,<br/><br/>I&#39;ve run into a weird problem with one of our websites. Long story short, our<br/>database class somehow didn&#39;t return any results for (SELECT) queries that<br/>have results if you run them on the commandline.<br/><br/>Since we wrote our own wrappers around DBI / DBD::mysql that was obviously the<br/>first place we looked. Our library has mysql_server_prepare=1 and caches the<br/>last bunch of statements. All selects are run through prepare.<br/>So summarized, a query is run through our library like<br/> res = $db-&gt;select($query, $arg1, $arg);<br/>And then our library does $sth = $dbh-&gt;prepare($query), $sth-&gt;execute(@args)<br/>and returns $sth-&gt;fetchall_arrayref({}).<br/>Meanwhile the last 5 $sth handled are cached and if the same query is run<br/>again it will be reused if possible.<br/><br/>This caching of $sth seems to be the problem, if I disable it and simply prepare<br/>the query again it works.<br/>Also this has worked for us for years, (although we often use DBD::Pg) however,<br/>it seems in this particular case the $sth simply returns no results. I&#39;ve<br/>set DBI-&gt;trace(2) and attached the output of that to this email.<br/><br/>Can anyone of you shine some light on what&#39;s going wrong? And why using a &#39;dead&#39;<br/>$sth doesn&#39;t throw any errors?<br/>I would have expected DBI-&gt;err() to return something or some other indication of<br/>failure, but I can&#39;t find any errors whatsoever.<br/><br/>If I set mysql_server_prepare=0 everything works as expected.<br/>I&#39;ve also tried using $sth-&gt;finish() on (all) the cached handles before reusing <br/>them, but that seems to have no effect.<br/><br/>Is the conclusion that I can not cache $sth like this?<br/><br/>Thanks for reading :-)<br/><br/>Regards,<br/><br/>Wouter.<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36977.html Thu, 19 Jun 2014 12:12:48 +0000 problems building DBD::mysql on omnios (opensolaris derivative) by Natxo Asenjo hi,<br/><br/>I posted this to the Perl beginners list but later I saw there is a list<br/>for dbi.<br/><br/>I have installed built perl 5.20 using perlbrew and gcc-4.8.1 on omnios, an<br/>opensolaris derivative.<br/><br/># perl -v<br/><br/>This is perl 5, version 20, subversion 0 (v5.20.0) built for<br/>i86pc-solaris-thread-multi-<br/>64int<br/><br/>for an application (RT) I want to use the mysql driver and I tried<br/>installing it throuch cpanm.<br/><br/>Then cpanm failed because it could not find the path to mysql_config. No<br/>problem, I can set it:<br/><br/>=============================================<br/># perl Makefile.PL --mysql_config=/usr/local/mysql/5.6/bin/mysql_config<br/>--cflags=&quot;-m32&quot;<br/><br/><br/>PLEASE NOTE:<br/><br/>For &#39;make test&#39; to run properly, you must ensure that the<br/>database user &#39;&#39; can connect to your MySQL server<br/>and has the proper privileges that these tests require such<br/>as &#39;drop table&#39;, &#39;create table&#39;, &#39;drop procedure&#39;, &#39;create procedure&#39;<br/>as well as others.<br/><br/>mysql&gt; grant all privileges on test.* to &#39;&#39;@&#39;localhost&#39; identified by<br/>&#39;s3kr1t&#39;;<br/><br/>You can also optionally set the user to run &#39;make test&#39; with:<br/><br/>perl Makefile.PL --testuser=username<br/><br/>I will use the following settings for compiling and testing:<br/><br/> cflags (User&#39;s choice) = -m32<br/> embedded (mysql_config ) =<br/> ldflags (mysql_config ) = -R/usr/local/mysql/5.6/lib<br/> libs (mysql_config ) = -L/usr/local/mysql/5.6/lib -lmysqlclient<br/>-lsocket -lnsl -lm -lssl -lcrypto<br/> mysql_config (Users choice ) = /usr/local/mysql/5.6/bin/mysql_config<br/> nocatchstderr (default ) = 0<br/> nofoundrows (default ) = 0<br/> ssl (guessed ) = 1<br/> testdb (default ) = test<br/> testhost (default ) =<br/> testpassword (default ) =<br/> testport (default ) =<br/> testsocket (default ) =<br/> testuser (guessed ) =<br/><br/>To change these settings, see &#39;perl Makefile.PL --help&#39; and<br/>&#39;perldoc DBD::mysql::INSTALL&#39;.<br/><br/>Using DBI 1.631 (for perl 5.020000 on i86pc-solaris-thread-multi-64int)<br/>installed in<br/>/opt/perl5//perls/perl-5.20.0/lib/site_perl/5.20.0/i86pc-solaris-thread-multi-64int/auto/DBI/<br/>Generating a Unix-style Makefile<br/>Writing Makefile for DBD::mysql<br/>Writing MYMETA.yml and MYMETA.json<br/><br/>=========================================================================================<br/><br/>But then make fails:<br/><br/>===========================================================<br/># make<br/>Skip blib/lib/DBD/mysql/INSTALL.pod (unchanged)<br/>Skip blib/lib/DBD/mysql.pm (unchanged)<br/>Skip blib/lib/Bundle/DBD/mysql.pm (unchanged)<br/>Skip blib/lib/DBD/README.pod (unchanged)<br/>Skip blib/lib/DBD/mysql/GetInfo.pm (unchanged)<br/>Running Mkbootstrap for DBD::mysql ()<br/>chmod 644 mysql.bs<br/>gcc -c<br/>-I/opt/perl5/perls/perl-5.20.0/lib/site_perl/5.20.0/i86pc-solaris-thread-multi-64int/auto/DBI<br/>-m32 -DDBD_MYSQL_WITH_SSL -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -D_REENTRANT<br/>-DPTR_IS_LONG -fno-stack-protector -fwrapv -fno-strict-aliasing -pipe<br/>-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -DPERL_USE_SAFE_PUTENV -O<br/>-DVERSION=\&quot;4.027\&quot; -DXS_VERSION=\&quot;4.027\&quot; -fPIC<br/>&quot;-I/opt/perl5/perls/perl-5.20.0/lib/5.20.0/i86pc-solaris-thread-multi-64int/CORE&quot;<br/>dbdimp.c<br/>In file included from dbdimp.c:20:0:<br/>dbdimp.h:21:49: fatal error: mysql.h: No such file or directory<br/> #include &lt;mysql.h&gt; /* Comes with MySQL-devel */<br/> ^<br/>compilation terminated.<br/>make: *** [dbdimp.o] Error 1<br/><br/>=====================================================================================================<br/><br/>so it cannot find the header. But it is there, this is what mysql_config<br/>tells me:<br/><br/># ./mysql_config<br/>Usage: ./mysql_config [OPTIONS]<br/>Options:<br/> --cflags [-I/usr/local/mysql/5.6/<br/>include -m64 -fPIC -g -fabi-version=2 -fno-omit-frame-pointer<br/>-fno-strict-aliasing]<br/> --cxxflags [-I/usr/local/mysql/5.6/include -m64 -fPIC -g<br/>-fabi-version=2 -fno-omit-frame-pointer -fno-strict-aliasing]<br/> --include [-I/usr/local/mysql/5.6/include]<br/> --libs [-L/usr/local/mysql/5.6/lib<br/>-R/usr/local/mysql/5.6/lib -lmysqlclient -lsocket -lnsl -lm -lssl -lcrypto]<br/> --libs_r [-L/usr/local/mysql/5.6/lib<br/>-R/usr/local/mysql/5.6/lib -lmysqlclient_r -lsocket -lnsl -lm -lssl<br/>-lcrypto]<br/> --plugindir [/usr/local/mysql/5.6/lib/plugin]<br/> --socket [/var/mysql/5.6/run/mysqld.socket]<br/> --port [0]<br/> --version [5.6.17]<br/> --libmysqld-libs [-L/usr/local/mysql/5.6/lib<br/>-R/usr/local/mysql/5.6/lib -lmysqld -lnsl -lm -lssl -lcrypto -lsocket]<br/> --variable=VAR VAR is one of:<br/> pkgincludedir [/usr/local/mysql/5.6/include]<br/> pkglibdir [/usr/local/mysql/5.6/lib]<br/> plugindir [/usr/local/mysql/5.6/lib/plugin]<br/><br/>And if I look in the include dir, sure there it is:<br/><br/>root@zone1:/usr/local/mysql/5.6/bin# ls -l ../include/mysql.h<br/>-rw-r--r-- 1 root bin 29058 Jun 15 16:56 ../include/mysql.h<br/><br/>Not really sure how to build this. Any tips greatly appreciated.<br/><br/>Thanks.<br/>--<br/>Groeten,<br/>natxo<br/>--<br/>Groeten,<br/>natxo<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36976.html Mon, 16 Jun 2014 07:12:16 +0000 RE: (Fwd) Issue :DBD::Oracle installation by Ranjitha Yeah .. I was still getting the error even after loading oracle library path.. , but somehow it is installed now.. with some warnings.. I think I can ignore those warning.. and all good now :) :)<br/><br/>Thanks a lot Bruce, Martin and Tim for your timely reply and help :) :),, you guys just rock !!!<br/><br/>Thanks and regards,<br/>Ranjitha<br/><br/>M:&nbsp; +91 9739463575<br/>T: +91 8039136322<br/>ranjitha@infosys.com<br/><br/>-----Original Message-----<br/>From: Bruce Johnson [mailto:johnson@Pharmacy.Arizona.EDU]<br/>Sent: Monday, June 09, 2014 12:58 AM<br/>To: Ranjitha<br/>Subject: Re: (Fwd) Issue :DBD::Oracle installation<br/><br/><br/>On Jun 5, 2014, at 10:49 PM, Ranjitha &lt;Ranjitha@infosys.com&gt; wrote:<br/><br/>&gt; Installing on a linux, Ver#2.6<br/>&gt;<br/>&gt; Using Oracle in /usr/lib/oracle/11.2/client64<br/>&gt;<br/>&gt; sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such<br/>&gt; file or directory<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; If sqlplus failed due to a linker/symbol/relocation/library error or similar problem<br/>&gt;<br/>&gt; then it&#39;s likely that you&#39;ve not configured your environment correctly.<br/>&gt;<br/>&gt; Specifically, your LD_LIBRARY_PATH environment variable<br/>&gt;<br/>&gt; set to include the directory containing the Oracle libraries.<br/><br/>This is exactly the answer: You need to make sure that the LD_LIBRARY_PATH is properly set *in the environment of the process running the perl script*<br/><br/>This is what Martin meant about being able to RUN sqlplus, not that it&#39;s installed. Log on as the user you&#39;re doing the install as and check the environment. When that user can run sqlplus, DBD::Oracle will successfully build.<br/><br/>**************** CAUTION - Disclaimer *****************<br/>This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely<br/>for the use of the addressee(s). If you are not the intended recipient, please<br/>notify the sender by e-mail and delete the original message. Further, you are not<br/>to copy, disclose, or distribute this e-mail or its contents to any other person and<br/>any such actions are unlawful. This e-mail may contain viruses. Infosys has taken<br/>every reasonable precaution to minimize this risk, but is not liable for any damage<br/>you may sustain as a result of any virus in this e-mail. You should carry out your<br/>own virus checks before opening the e-mail or attachment. Infosys reserves the<br/>right to monitor and review the content of all messages sent to or from this e-mail<br/>address. Messages sent to or from this e-mail address may be stored on the<br/>Infosys e-mail system.<br/>***INFOSYS******** End of Disclaimer ********INFOSYS***<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36975.html Mon, 09 Jun 2014 18:22:17 +0000 RE: (Fwd) Issue :DBD::Oracle installation by Ranjitha Hi Tim/Dbi-users<br/><br/>Please help :)<br/><br/>Thanks and regards,<br/>Ranjitha<br/><br/>M:&nbsp; +91 9739463575<br/>T: +91 8039136322<br/>ranjitha@infosys.com<br/><br/>-----Original Message-----<br/>From: Tim.Bunce@pobox.com [mailto:Tim.Bunce@pobox.com] <br/>Sent: Wednesday, June 04, 2014 5:14 PM<br/>To: dbi-users@perl.org<br/>Cc: Ranjitha<br/>Subject: (Fwd) Issue :DBD::Oracle installation<br/><br/>----- Forwarded message from Ranjitha &lt;Ranjitha@infosys.com&gt; -----<br/><br/>Date: Wed, 4 Jun 2014 11:05:34 +0000<br/>From: Ranjitha &lt;Ranjitha@infosys.com&gt;<br/>To: &quot;Tim.Bunce@pobox.com&quot; &lt;Tim.Bunce@pobox.com&gt;, &quot;timb@cpan.org&quot; &lt;timb@cpan.org&gt;<br/>Subject: Issue :DBD::Oracle installation<br/><br/> Hi Tim<br/><br/> Facing an issue while installing DBD::Oracle module from CPAN.<br/><br/> Direct installation on server cpan DBD::Oracle is failing.<br/><br/> I manually tried installing the module which CPAN has downloaded, below is the log.<br/><br/> ciw-app1:~/.cpan/build/DBD-Oracle-1.74-vjnZmt # perl Makefile.PL<br/><br/> Multiple copies of Driver.xst found in:<br/> /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/> /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 39<br/><br/> Using DBI 1.631 (for perl 5.010000 on x86_64-linux-thread-multi) installed in<br/> /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/><br/><br/><br/> Configuring DBD::Oracle for perl 5.010000 on linux (x86_64-linux-thread-multi)<br/><br/><br/><br/> Remember to actually *READ* the README file! Especially if you have any problems.<br/><br/><br/><br/> Installing on a linux, Ver#2.6<br/><br/> Using Oracle in /usr/lib/oracle/11.2/client64<br/><br/> sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such<br/> file or directory<br/><br/><br/><br/> If sqlplus failed due to a linker/symbol/relocation/library error or similar problem<br/><br/> then it&#39;s likely that you&#39;ve not configured your environment correctly.<br/><br/> Specifically, your LD_LIBRARY_PATH environment variable<br/><br/> set to include the directory containing the Oracle libraries.<br/><br/><br/><br/> I&#39;m having trouble finding your Oracle version number... trying harder<br/><br/><br/><br/> WARNING: I could not determine Oracle client version so I&#39;ll just<br/><br/> default to version 8.0.0.0. Some features of DBD::Oracle may not work.<br/><br/> Oracle version based logic in Makefile.PL may produce erroneous results.<br/><br/> You can use &quot;perl Makefile.PL -V X.Y.Z&quot; to specify a your client version.<br/><br/><br/><br/> Oracle version 8.0.0.0 (8.0)<br/><br/> DBD::Oracle no longer supports Oracle client versions before 9.2<br/><br/> Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.<br/><br/><br/><br/> Oracle client installed on the server is 11.2 , then why the issue ?? Could you please suggest some<br/> alternate solution /fix for the same.?<br/><br/> Thanks and regards,<br/><br/> Ranjitha<br/><br/> [1]Description: Description: Description: A NEW BTE_Email-signature_<br/><br/> M: +91 9739463575<br/><br/> T: +91 8039136322<br/><br/> [2]ranjitha@infosys.com<br/><br/><br/><br/> **************** CAUTION - Disclaimer *****************<br/> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely<br/> for the use of the addressee(s). If you are not the intended recipient, please<br/> notify the sender by e-mail and delete the original message. Further, you are not<br/> to copy, disclose, or distribute this e-mail or its contents to any other person and<br/> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken<br/> every reasonable precaution to minimize this risk, but is not liable for any damage<br/> you may sustain as a result of any virus in this e-mail. You should carry out your<br/> own virus checks before opening the e-mail or attachment. Infosys reserves the<br/> right to monitor and review the content of all messages sent to or from this e-mail<br/> address. Messages sent to or from this e-mail address may be stored on the<br/> Infosys e-mail system.<br/> ***INFOSYS******** End of Disclaimer ********INFOSYS***<br/><br/>References<br/><br/> Visible links<br/> 1. http://www.infosys.com/bte<br/> 2. mailto:ranjitha@infosys.com<br/><br/><br/><br/>----- End forwarded message -----<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36974.html Sun, 08 Jun 2014 06:25:20 +0000 Re: (Fwd) Issue :DBD::Oracle installation by Martin J. Evans On 06/06/14 12:17, Ranjitha wrote:<br/>&gt; Hi Martin<br/>&gt;<br/>&gt; Screen shot from yast :<br/><br/>showing sqlplus is installed.<br/><br/>&gt; I have sqlplus installed in my server, then why the error?<br/>&gt;<br/>&gt; Same way I have installed sqlplus in other servers also, no issue there.<br/>&gt;<br/>&gt; Thanks and regards,<br/><br/>You&#39;ve misunderstood me. I wasn&#39;t saying you have not installed sqlplus. I was saying you need to make sure you can run sqlplus before attempting to build DBD::Oracle. So sqlplus should be on your PATH or findable under LD_LIBRARY_PATH which you should set and export.<br/><br/>It is pointless trying to build DBD::Oracle if you cannot successfully run sqlplus - at best it will default to oracle 8.<br/><br/>Martin<br/><br/>&gt; -----Original Message-----<br/>&gt; From: Martin J. Evans [mailto:martin.evans@easysoft.com]<br/>&gt; Sent: Friday, June 06, 2014 1:44 PM<br/>&gt; To: Ranjitha; dbi-users@perl.org<br/>&gt; Subject: Re: (Fwd) Issue :DBD::Oracle installation<br/>&gt;<br/>&gt; On 04/06/14 12:44, Tim.Bunce@pobox.com &lt;mailto:Tim.Bunce@pobox.com&gt; wrote:<br/>&gt;<br/>&gt; &gt; ----- Forwarded message from Ranjitha &lt;Ranjitha@infosys.com &lt;mailto:Ranjitha@infosys.com&gt;&gt; -----<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Date: Wed, 4 Jun 2014 11:05:34 +0000<br/>&gt;<br/>&gt; &gt; From: Ranjitha &lt;Ranjitha@infosys.com &lt;mailto:Ranjitha@infosys.com&gt;&gt;<br/>&gt;<br/>&gt; &gt; To: &quot;Tim.Bunce@pobox.com &lt;mailto:Tim.Bunce@pobox.com&gt;&quot; &lt;Tim.Bunce@pobox.com &lt;mailto:Tim.Bunce@pobox.com&gt;&gt;, &quot;timb@cpan.org &lt;mailto:timb@cpan.org&gt;&quot; &lt;timb@cpan.org &lt;mailto:timb@cpan.org&gt;&gt;<br/>&gt;<br/>&gt; &gt; Subject: Issue :DBD::Oracle installation<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Hi Tim<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Facing an issue while installing DBD::Oracle module from CPAN.<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Direct installation on server cpan DBD::Oracle is failing.<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; I manually tried installing the module which CPAN has downloaded, below is the log.<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; ciw-app1:~/.cpan/build/DBD-Oracle-1.74-vjnZmt # perl Makefile.PL<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Multiple copies of Driver.xst found in:<br/>&gt;<br/>&gt; &gt; /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/>&gt;<br/>&gt; &gt; /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 39<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Using DBI 1.631 (for perl 5.010000 on x86_64-linux-thread-multi) installed in<br/>&gt;<br/>&gt; &gt; /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Configuring DBD::Oracle for perl 5.010000 on linux (x86_64-linux-thread-multi)<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Remember to actually *READ* the README file! Especially if you have any problems.<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Installing on a linux, Ver#2.6<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; Using Oracle in /usr/lib/oracle/11.2/client64<br/>&gt;<br/>&gt; &gt;<br/>&gt;<br/>&gt; &gt; sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such<br/>&gt;<br/>&gt; &gt; file or directory<br/>&gt;<br/>&gt; This is your problem. You need to get sqlplus working in your environment before attempting to build DBD::Oracle.<br/>&gt;<br/>&gt; Martin<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36973.html Fri, 06 Jun 2014 12:14:53 +0000 Re: (Fwd) Issue :DBD::Oracle installation by Martin J. Evans On 04/06/14 12:44, Tim.Bunce@pobox.com wrote:<br/>&gt; ----- Forwarded message from Ranjitha &lt;Ranjitha@infosys.com&gt; -----<br/>&gt;<br/>&gt; Date: Wed, 4 Jun 2014 11:05:34 +0000<br/>&gt; From: Ranjitha &lt;Ranjitha@infosys.com&gt;<br/>&gt; To: &quot;Tim.Bunce@pobox.com&quot; &lt;Tim.Bunce@pobox.com&gt;, &quot;timb@cpan.org&quot; &lt;timb@cpan.org&gt;<br/>&gt; Subject: Issue :DBD::Oracle installation<br/>&gt;<br/>&gt; Hi Tim<br/>&gt;<br/>&gt; Facing an issue while installing DBD::Oracle module from CPAN.<br/>&gt;<br/>&gt; Direct installation on server cpan DBD::Oracle is failing.<br/>&gt;<br/>&gt; I manually tried installing the module which CPAN has downloaded, below is the log.<br/>&gt;<br/>&gt; ciw-app1:~/.cpan/build/DBD-Oracle-1.74-vjnZmt # perl Makefile.PL<br/>&gt;<br/>&gt; Multiple copies of Driver.xst found in:<br/>&gt; /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/>&gt; /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 39<br/>&gt;<br/>&gt; Using DBI 1.631 (for perl 5.010000 on x86_64-linux-thread-multi) installed in<br/>&gt; /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; Configuring DBD::Oracle for perl 5.010000 on linux (x86_64-linux-thread-multi)<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; Remember to actually *READ* the README file! Especially if you have any problems.<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; Installing on a linux, Ver#2.6<br/>&gt;<br/>&gt; Using Oracle in /usr/lib/oracle/11.2/client64<br/>&gt;<br/>&gt; sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such<br/>&gt; file or directory<br/><br/>This is your problem. You need to get sqlplus working in your environment before attempting to build DBD::Oracle.<br/><br/>Martin<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36972.html Fri, 06 Jun 2014 08:13:49 +0000 (Fwd) Issue :DBD::Oracle installation by Tim.Bunce@pobox.com ----- Forwarded message from Ranjitha &lt;Ranjitha@infosys.com&gt; -----<br/><br/>Date: Wed, 4 Jun 2014 11:05:34 +0000<br/>From: Ranjitha &lt;Ranjitha@infosys.com&gt;<br/>To: &quot;Tim.Bunce@pobox.com&quot; &lt;Tim.Bunce@pobox.com&gt;, &quot;timb@cpan.org&quot; &lt;timb@cpan.org&gt;<br/>Subject: Issue :DBD::Oracle installation<br/><br/> Hi Tim<br/><br/> Facing an issue while installing DBD::Oracle module from CPAN.<br/><br/> Direct installation on server cpan DBD::Oracle is failing.<br/><br/> I manually tried installing the module which CPAN has downloaded, below is the log.<br/><br/> ciw-app1:~/.cpan/build/DBD-Oracle-1.74-vjnZmt # perl Makefile.PL<br/><br/> Multiple copies of Driver.xst found in:<br/> /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/> /usr/lib/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/ at Makefile.PL line 39<br/><br/> Using DBI 1.631 (for perl 5.010000 on x86_64-linux-thread-multi) installed in<br/> /usr/lib/perl5/site_perl/5.10.0/x86_64-linux-thread-multi/auto/DBI/<br/><br/><br/><br/> Configuring DBD::Oracle for perl 5.010000 on linux (x86_64-linux-thread-multi)<br/><br/><br/><br/> Remember to actually *READ* the README file! Especially if you have any problems.<br/><br/><br/><br/> Installing on a linux, Ver#2.6<br/><br/> Using Oracle in /usr/lib/oracle/11.2/client64<br/><br/> sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such<br/> file or directory<br/><br/><br/><br/> If sqlplus failed due to a linker/symbol/relocation/library error or similar problem<br/><br/> then it&#39;s likely that you&#39;ve not configured your environment correctly.<br/><br/> Specifically, your LD_LIBRARY_PATH environment variable<br/><br/> set to include the directory containing the Oracle libraries.<br/><br/><br/><br/> I&#39;m having trouble finding your Oracle version number... trying harder<br/><br/><br/><br/> WARNING: I could not determine Oracle client version so I&#39;ll just<br/><br/> default to version 8.0.0.0. Some features of DBD::Oracle may not work.<br/><br/> Oracle version based logic in Makefile.PL may produce erroneous results.<br/><br/> You can use &quot;perl Makefile.PL -V X.Y.Z&quot; to specify a your client version.<br/><br/><br/><br/> Oracle version 8.0.0.0 (8.0)<br/><br/> DBD::Oracle no longer supports Oracle client versions before 9.2<br/><br/> Try a version before 1.25 for 9 and 1.18 for 8! at Makefile.PL line 271.<br/><br/><br/><br/> Oracle client installed on the server is 11.2 , then why the issue ?? Could you please suggest some<br/> alternate solution /fix for the same.?<br/><br/> Thanks and regards,<br/><br/> Ranjitha<br/><br/> [1]Description: Description: Description: A NEW BTE_Email-signature_<br/><br/> M: +91 9739463575<br/><br/> T: +91 8039136322<br/><br/> [2]ranjitha@infosys.com<br/><br/><br/><br/> **************** CAUTION - Disclaimer *****************<br/> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely<br/> for the use of the addressee(s). If you are not the intended recipient, please<br/> notify the sender by e-mail and delete the original message. Further, you are not<br/> to copy, disclose, or distribute this e-mail or its contents to any other person and<br/> any such actions are unlawful. This e-mail may contain viruses. Infosys has taken<br/> every reasonable precaution to minimize this risk, but is not liable for any damage<br/> you may sustain as a result of any virus in this e-mail. You should carry out your<br/> own virus checks before opening the e-mail or attachment. Infosys reserves the<br/> right to monitor and review the content of all messages sent to or from this e-mail<br/> address. Messages sent to or from this e-mail address may be stored on the<br/> Infosys e-mail system.<br/> ***INFOSYS******** End of Disclaimer ********INFOSYS***<br/><br/>References<br/><br/> Visible links<br/> 1. http://www.infosys.com/bte<br/> 2. mailto:ranjitha@infosys.com<br/><br/><br/><br/>----- End forwarded message -----<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36971.html Wed, 04 Jun 2014 11:44:30 +0000 Re: Probably simple, stupid question about Oracle TAF and DBI by Martin J. Evans On 02/06/2014 01:25, Bruce Johnson wrote:<br/>&gt; I&#39;ve been tasked with making our Oracle db (used primarily as a DB<br/>&gt; back end for web applications) function within a disaster recovery<br/>&gt; plan now that we actually have hardware at a second site to do<br/>&gt; disaster recovery (other than &#39;Go buy a new server and restore it<br/>&gt; from backup&#39; :-)<br/>&gt;<br/>&gt; I&#39;m planning to use Oracle&#39;s Data Guard to manage the db backend,<br/>&gt; which seems quite straightforward, but my question is about managing<br/>&gt; failover (what Oracle calls TAF)<br/>&gt;<br/>&gt;&gt; From what I&#39;m reading<br/>&gt;&gt; &lt;http://search.cpan.org/~pythian/DBD-Oracle-1.74/lib/DBD/Oracle.pm#TAF_(Transparent_Application_Failover)&gt;<br/>&gt;<br/>&gt;&gt;<br/>&gt; DBD::Oracle uses the tns entry for TAF:<br/>&gt;<br/>&gt; eg:<br/>&gt;<br/>&gt; (FAILOVER_MODE= (TYPE=select) (METHOD=basic) (RETRIES=10)<br/>&gt; (DELAY=10))<br/>&gt;<br/>&gt; Am I right in thinking that since each time a script is called it<br/>&gt; creates a handle, does its thing, then ends, in the event of a<br/>&gt; failure, the, each call of the script will take over 100 seconds to<br/>&gt; fail over, given the above settings?<br/>&gt;<br/>&gt; Therefore, to take advantage of TAF I&#39;d have to utilize persistent<br/>&gt; DBI handles (using, for example, Apache::DBI<br/>&gt; &lt;http://perl.apache.org/docs/1.0/guide/databases.html&gt;) and once the<br/>&gt; first call to a failed instance takes 100 seconds to fail over, the<br/>&gt; $dbh will then talk to the backup server thereafter?<br/>&gt;<br/><br/>I fixed the TAF support when we were using Oracle RAC and I haven&#39;t used<br/>it in a while. Our application connects and stays connected and when the<br/>first server failed it took a while (initially) to fail over to the <br/>other server.<br/><br/>I&#39;m sorry but I don&#39;t have that kit available right now to retest so<br/>this is only my recollection. All I know for definite is what I wrote in<br/>the DBD::Oracle pod.<br/><br/>The actual failover is implemented in the OCI libraries and all <br/>DBD::Oracle does is make the appropriate calls to set it up and call the <br/>callback. As such Oracle docs will be your friend.<br/><br/>Try it and see and report back. Up to this point I only know of myself <br/>as having used TAF with DBD::Oracle. There may be an article on the <br/>Easysoft web site.<br/><br/>Martin<br/>-- <br/>Martin J. Evans<br/>Wetherby, UK<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36970.html Mon, 02 Jun 2014 18:25:34 +0000 Re: Oracle Freakishness by David E. Wheeler On May 5, 2013, at 5:02 PM, David E. Wheeler &lt;david@kineticode.com&gt; wrote:<br/><br/>&gt; No, I get the same error if I cast it to a varray. What&rsquo;s bizarre is that Oracle says that the error is on the join to tags, not the collect. Here&rsquo;s another example (with the cast):<br/>&gt; <br/>&gt; ORA-00942: table or view does not exist (DBD ERROR: error possibly near &lt;*&gt; indicator at char 419 in &#39;<br/>&gt; SELECT c.change_id AS id, c.change AS name, c.project, c.note,<br/>&gt; to_char(c.planned_at AT TIME ZONE &#39;UTC&#39;, &#39;&quot;year&quot;:YYYY:&quot;month&quot;:MM:&quot;day&quot;:DD&#39;) || to_char(c.planned_at AT TIME ZONE &#39;UTC&#39;, &#39;:&quot;hour&quot;:HH24:&quot;minute&quot;:MI:&quot;second&quot;:SS:&quot;time_zone&quot;:&quot;UTC&quot;&#39;) AS timestamp, c.planner_name, c.planner_email,<br/>&gt; cast(COLLECT(t.tag) AS sqitch_array) AS tags<br/>&gt; FROM changes c<br/>&gt; LEFT JOIN &lt;*&gt;tags t ON c.change_id = t.change_id<br/>&gt; WHERE c.project = :p1<br/>&gt; GROUP BY c.change_id, c.change, c.project, c.note, c.planned_at,<br/>&gt; c.planner_name, c.planner_email, c.committed_at<br/>&gt; ORDER BY c.committed_at ASC<br/>&gt; &#39;)<br/><br/>For the archives, I finally got a fix for this, thanks to some digging by a user. Turns out the problem was that COLLECT() needs the *collected* value to be cast to a specific type. The fix is to change this:<br/><br/> cast(COLLECT(t.tag) AS sqitch_array) AS tags<br/><br/>To this:<br/><br/> CAST(COLLECT(cast(t.tag as varchar2(512))) AS sqitch_array) AS tags<br/><br/>Crazy, right?<br/><br/>Thanks,<br/><br/>David<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36969.html Mon, 02 Jun 2014 17:59:59 +0000 DBD::Pg 3.3.0 released (driver for Postgres) by Greg Sabino Mullane Version 3.3.0 of DBD::Pg, DBI driver for PostgreSQL, is<br/>now available. This release enhances UTF-8 support a<br/>great deal, thanks to the work of Dagfinn Ilmari Manns&aring;ker<br/>and Nicholas Clark. As always, you can find it on CPAN at:<br/><br/>http://search.cpan.org/dist/DBD-Pg/<br/><br/>Checksums:<br/><br/>547de1382a47d66872912fe64282ff55 DBD-Pg-3.3.0.tar.gz<br/>9ec52d0d75463e6a448760e2d2fcbc41ca6201e1 DBD-Pg-3.3.0.tar.gz<br/><br/>Complete list of changes:<br/><br/>Version 3.3.0 Released May 31, 2014 (git commit 055f788cf96b380b9fe0e80b6cedb88f8d1799b8)<br/><br/> - Major cleanup of UTF-8 support:<br/> Fix quoting of UTF-8 values<br/> Add support for UTF-8 statement strings<br/> Fix UTF-8 support in placeholders and return values<br/> [Dagfinn Ilmari Manns&aring;ker] (CPAN bug #95214 and #91655)<br/> Test that the Pg server agrees with us about the lengths of input strings.<br/> Refactor Unicode test to use anon hashes to describe the tests to run.<br/> Test pg_enable_utf8 of -1, in addition to 0 and 1.<br/> Extend the Unicode round-trip tests to verify ASCII, BMP and non-BMP code points.<br/> Test that characters created in the server reach the client correctly.<br/><br/> - Rewrite foreign_key_info to be just one query<br/> [Dagfinn Ilmari Manns&aring;ker]<br/><br/> - Remove ODBC support from foreign_key_info<br/> [Dagfinn Ilmari Manns&aring;ker]<br/><br/> - Remove use of dTHX in functions in quote.c and types.c<br/> [Nicholas Clark]<br/><br/><br/>--<br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201406021319<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/06/msg36968.html Mon, 02 Jun 2014 17:20:11 +0000 Probably simple, stupid question about Oracle TAF and DBI by Bruce Johnson I&#39;ve been tasked with making our Oracle db (used primarily as a DB back end for web applications) function within a disaster recovery plan now that we actually have hardware at a second site to do disaster recovery (other than &#39;Go buy a new server and restore it from backup&#39; :-)<br/><br/>I&#39;m planning to use Oracle&#39;s Data Guard to manage the db backend, which seems quite straightforward, but my question is about managing failover (what Oracle calls TAF)<br/><br/>From what I&#39;m reading &lt;http://search.cpan.org/~pythian/DBD-Oracle-1.74/lib/DBD/Oracle.pm#TAF_(Transparent_Application_Failover)&gt;<br/><br/>DBD::Oracle uses the tns entry for TAF:<br/><br/>eg: <br/><br/> (FAILOVER_MODE= <br/> (TYPE=select) <br/> (METHOD=basic) <br/> (RETRIES=10) <br/> (DELAY=10))<br/><br/>Am I right in thinking that since each time a script is called it creates a handle, does its thing, then ends, in the event of a failure, the, each call of the script will take over 100 seconds to fail over, given the above settings?<br/><br/>Therefore, to take advantage of TAF I&#39;d have to utilize persistent DBI handles (using, for example, Apache::DBI &lt;http://perl.apache.org/docs/1.0/guide/databases.html&gt;) and once the first call to a failed instance takes 100 seconds to fail over, the $dbh will then talk to the backup server thereafter?<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/06/msg36967.html Mon, 02 Jun 2014 00:26:33 +0000 DBD::Pg version 3.2.1 released (Perl Postgres driver) by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/><br/>Version 3.2.1 of DBD::Pg, the Perl interface to Postgres,<br/>has just been released. In addition to some bug fixes, <br/>there is a new handle attribute called pg_placeholder_nocolons. <br/>When set, it will prevent the colon character from being picked <br/>up as a placeholder. More information can be found at:<br/><br/>http://blog.endpoint.com/2014/05/dbdpg-array-slices-and.html<br/><br/>The new version is available from CPAN:<br/><br/>http://search.cpan.org/dist/DBD-Pg/<br/><br/>hecksums:<br/><br/>6f2196ddd75d613e37a57e1ed7f0bcfc DBD-Pg-3.2.1.tar.gz<br/>ddcef35e7431742258a415069c9f1c2d303c0446 DBD-Pg-3.2.1.tar.gz<br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201405251417<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlOCNXgACgkQvJuQZxSWSsgmjgCg2cqODzZF5ZJuZsUUJ2F6IeF6<br/>LD8AnjtVS2AOhnEOZPHZg1wWLBMKNmDQ<br/>=yw6M<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36966.html Sun, 25 May 2014 18:27:27 +0000 Re: unable to locate DBI.pm by Daminto Lie Great, will do that then.<br/><br/>Thank you all for your great support. <br/><br/><br/>All&nbsp; <br/>On Thursday, 22 May 2014 11:06 AM, Ron Savage &lt;ron@savage.net.au&gt; wrote:<br/> <br/><br/><br/>Hi<br/><br/><br/>On 22/05/14 10:39, Daminto Lie wrote:<br/>&gt; Thank you Chad and sorry if I sent the reply to you to your personal address.<br/>&gt;<br/>&gt; Before I do that, I have another question.<br/>&gt;<br/>&gt; I normally install and update MySQL from source manually whenever the new version is released. Now, if I install DBD-mysql from the Ubuntu Repository rather than from the source, would it cause any problems with the latest version of MySQL?<br/><br/>No.<br/><br/>&gt; Thank you very much<br/>&gt;<br/>&gt;<br/>&gt; On Thursday, 22 May 2014 3:46 AM, Chad Wallace &lt;cwallace@lodgingcompany.com&gt; wrote:<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; Posting back to the list...&nbsp; Please don&#39;t reply to me personally; I am<br/>&gt; subscribed to the list.<br/>&gt;<br/>&gt;<br/>&gt; On Tue, 20 May 2014 18:23:52 -0700 (PDT)<br/>&gt; Daminto Lie &lt;dlie76@yahoo.com.au&gt; wrote:<br/>&gt;<br/>&gt;&gt; Thanks a lot for your reply.<br/>&gt;&gt;<br/>&gt;&gt; I think this is what I should be using to install DBI and DBD-mysql.<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; But as I mentioned to John before that I think I need to get rid of<br/>&gt;&gt; DBI-1.641 first before running the command you suggested. please<br/>&gt;&gt; correct me if I&#39;m wrong.<br/>&gt;<br/>&gt; Well, it doesn&#39;t seem like that DBI installation is even doing<br/>&gt; anything.&nbsp; But yes, you should remove it, just to get rid of<br/>&gt; the clutter.&nbsp; I would just run this:<br/>&gt;<br/>&gt; rm -r /root/perl5<br/>&gt;<br/>&gt; Then install DBI and DBD-mysql from your distro&#39;s packaging system.<br/>&gt; They&#39;ll be put in the correct place (one of the perl locations under<br/>&gt; /usr/share or /usr/lib), and then spamassassin and the others will be<br/>&gt; able to use them.<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;&gt; On Wednesday, 21 May 2014 10:32 AM, Chad Wallace<br/>&gt;&gt; &lt;cwallace@lodgingcompany.com&gt; wrote:<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; On Tue, 20 May 2014 17:22:58 -0700<br/>&gt;&gt;<br/>&gt;&gt; John R Pierce &lt;pierce@hogranch.com&gt; wrote:<br/>&gt;&gt;<br/>&gt;&gt;&gt; what operating system are you on?&nbsp; isn&#39;t there a DBI and such in the<br/>&gt;&gt;&gt; OS package repository?<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; for instance, on a RHEL/CentOS/Fedora type system, I&#39;d use...<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt;&nbsp; &nbsp; &nbsp; &nbsp; sudo yum install perl-DBI perl-DBD-MySQL<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; of course, for a different Linux distribution, or another OS<br/>&gt;&gt;&gt; entirely, both the command and the package names are probably<br/>&gt;&gt;&gt; different.<br/>&gt;&gt;<br/>&gt;&gt; on Debian and related distros:<br/>&gt;&gt;<br/>&gt;&gt; sudo apt-get install libdbi-perl libdbd-mysql-perl<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;<br/>&gt;<br/><br/>-- <br/>Ron Savage<br/>savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36965.html Thu, 22 May 2014 03:16:46 +0000 Re: unable to locate DBI.pm by Ron Savage Hi<br/><br/>On 22/05/14 10:39, Daminto Lie wrote:<br/>&gt; Thank you Chad and sorry if I sent the reply to you to your personal address.<br/>&gt;<br/>&gt; Before I do that, I have another question.<br/>&gt;<br/>&gt; I normally install and update MySQL from source manually whenever the new version is released. Now, if I install DBD-mysql from the Ubuntu Repository rather than from the source, would it cause any problems with the latest version of MySQL?<br/><br/>No.<br/><br/>&gt; Thank you very much<br/>&gt;<br/>&gt;<br/>&gt; On Thursday, 22 May 2014 3:46 AM, Chad Wallace &lt;cwallace@lodgingcompany.com&gt; wrote:<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; Posting back to the list... Please don&#39;t reply to me personally; I am<br/>&gt; subscribed to the list.<br/>&gt;<br/>&gt;<br/>&gt; On Tue, 20 May 2014 18:23:52 -0700 (PDT)<br/>&gt; Daminto Lie &lt;dlie76@yahoo.com.au&gt; wrote:<br/>&gt;<br/>&gt;&gt; Thanks a lot for your reply.<br/>&gt;&gt;<br/>&gt;&gt; I think this is what I should be using to install DBI and DBD-mysql.<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; But as I mentioned to John before that I think I need to get rid of<br/>&gt;&gt; DBI-1.641 first before running the command you suggested. please<br/>&gt;&gt; correct me if I&#39;m wrong.<br/>&gt;<br/>&gt; Well, it doesn&#39;t seem like that DBI installation is even doing<br/>&gt; anything. But yes, you should remove it, just to get rid of<br/>&gt; the clutter. I would just run this:<br/>&gt;<br/>&gt; rm -r /root/perl5<br/>&gt;<br/>&gt; Then install DBI and DBD-mysql from your distro&#39;s packaging system.<br/>&gt; They&#39;ll be put in the correct place (one of the perl locations under<br/>&gt; /usr/share or /usr/lib), and then spamassassin and the others will be<br/>&gt; able to use them.<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;&gt; On Wednesday, 21 May 2014 10:32 AM, Chad Wallace<br/>&gt;&gt; &lt;cwallace@lodgingcompany.com&gt; wrote:<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; On Tue, 20 May 2014 17:22:58 -0700<br/>&gt;&gt;<br/>&gt;&gt; John R Pierce &lt;pierce@hogranch.com&gt; wrote:<br/>&gt;&gt;<br/>&gt;&gt;&gt; what operating system are you on? isn&#39;t there a DBI and such in the<br/>&gt;&gt;&gt; OS package repository?<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; for instance, on a RHEL/CentOS/Fedora type system, I&#39;d use...<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; sudo yum install perl-DBI perl-DBD-MySQL<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; of course, for a different Linux distribution, or another OS<br/>&gt;&gt;&gt; entirely, both the command and the package names are probably<br/>&gt;&gt;&gt; different.<br/>&gt;&gt;<br/>&gt;&gt; on Debian and related distros:<br/>&gt;&gt;<br/>&gt;&gt; sudo apt-get install libdbi-perl libdbd-mysql-perl<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;<br/>&gt;<br/><br/>-- <br/>Ron Savage<br/>savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36964.html Thu, 22 May 2014 01:06:50 +0000 Re: unable to locate DBI.pm by Daminto Lie Thank you Chad and sorry if I sent the reply to you to your personal address.<br/><br/>Before I do that, I have another question.<br/><br/>I normally install and update MySQL from source manually whenever the new version is released. Now, if I install DBD-mysql from the Ubuntu Repository rather than from the source, would it cause any problems with the latest version of MySQL?<br/><br/>Thank you very much<br/><br/><br/>On Thursday, 22 May 2014 3:46 AM, Chad Wallace &lt;cwallace@lodgingcompany.com&gt; wrote:<br/> <br/><br/><br/><br/>Posting back to the list...&nbsp; Please don&#39;t reply to me personally; I am<br/>subscribed to the list.<br/><br/><br/>On Tue, 20 May 2014 18:23:52 -0700 (PDT)<br/>Daminto Lie &lt;dlie76@yahoo.com.au&gt; wrote:<br/><br/>&gt; Thanks a lot for your reply.<br/>&gt; <br/>&gt; I think this is what I should be using to install DBI and DBD-mysql. <br/>&gt; <br/>&gt; <br/>&gt; But as I mentioned to John before that I think I need to get rid of<br/>&gt; DBI-1.641 first before running the command you suggested. please<br/>&gt; correct me if I&#39;m wrong.<br/><br/>Well, it doesn&#39;t seem like that DBI installation is even doing<br/>anything.&nbsp; But yes, you should remove it, just to get rid of<br/>the clutter.&nbsp; I would just run this:<br/><br/>rm -r /root/perl5<br/><br/>Then install DBI and DBD-mysql from your distro&#39;s packaging system.<br/>They&#39;ll be put in the correct place (one of the perl locations under<br/>/usr/share or /usr/lib), and then spamassassin and the others will be<br/>able to use them.<br/><br/><br/><br/><br/>&gt; On Wednesday, 21 May 2014 10:32 AM, Chad Wallace<br/>&gt; &lt;cwallace@lodgingcompany.com&gt; wrote: <br/>&gt; <br/>&gt; <br/>&gt; On Tue, 20 May 2014 17:22:58 -0700<br/>&gt; <br/>&gt; John R Pierce &lt;pierce@hogranch.com&gt; wrote:<br/>&gt; <br/>&gt; &gt; what operating system are you on?&nbsp; isn&#39;t there a DBI and such in the<br/>&gt; &gt; OS package repository?<br/>&gt; &gt; <br/>&gt; &gt; for instance, on a RHEL/CentOS/Fedora type system, I&#39;d use...<br/>&gt; &gt; <br/>&gt; &gt;&nbsp; &nbsp; &nbsp; sudo yum install perl-DBI perl-DBD-MySQL<br/>&gt; &gt; <br/>&gt; &gt; of course, for a different Linux distribution, or another OS<br/>&gt; &gt; entirely, both the command and the package names are probably<br/>&gt; &gt; different.<br/>&gt; <br/>&gt; on Debian and related distros:<br/>&gt; <br/>&gt; sudo apt-get install libdbi-perl libdbd-mysql-perl<br/>&gt; <br/>&gt; <br/>&gt; <br/><br/><br/>-- <br/><br/>C. Chad Wallace, B.Sc.<br/>The Lodging Company<br/>http://www.lodgingcompany.com/<br/>OpenPGP Public Key ID: 0x262208A0<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36963.html Thu, 22 May 2014 00:40:07 +0000 Re: error can't locate DBI.pm by Daminto Lie Thank you for your reply.<br/><br/>Please see my answers to your questions.<br/><br/><br/>&gt; So this particular Perl does not look in /root/perl5/ as you report below.<br/><br/>&gt; Who are you logged in as when you do this?<br/><br/><br/>Yes, correct. I logged in as root when I did this.<br/><br/>But, I must say that I did change the ownership of the package as follows:<br/>- tar xvfz DBI-1.631<br/>- chown &ndash;R user.user ./DBI-1.631<br/>- chmod 755 ./DBI-1.631<br/>- cd ./DBI-1.631<br/>- perl Makefile.PL<br/>- make<br/>- make test<br/>- make test TEST_VERBOSE=1<br/>- make install<br/><br/><br/>And when I run all the above commands, I logged in as root. hmmm... could it be that I shouldn&#39;t have logged in as root but instead, run &quot;sudo some_commands&quot; <br/><br/><br/>&gt;&gt; This was how I installed the DBI-1.631.<br/>&gt;&gt;<br/>&gt;&gt; - perl Makefile.PL<br/>&gt;&gt; - make<br/>&gt;&gt; - make test<br/>&gt;&gt; - make test TEST_VERBOSE=1<br/>&gt;&gt; - make install<br/><br/>&gt; Who are you logged in as when you do this?<br/><br/>as root<br/><br/>&gt;&gt; And this was how I installed DBD-mysql-4.027<br/>&gt;&gt;<br/>&gt;&gt; - perl Makefile.PL = --mysql_config=/home/mysql/bin/mysql_config --testuser=root --testpassword=myPasswd<br/>&gt;&gt; - make -j3<br/>&gt;&gt; - make test<br/>&gt;&gt; - checkinstall -D make install<br/><br/>&gt; Who are you logged in as when you do this?<br/>as root<br/><br/>&gt;&gt; I also noticed that during the completion of the installation of DBI, <br/>it actually installed it in the /root directory as follows:<br/>&gt;&gt;<br/>&gt;&gt; Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver_xst.h<br/>[snip]<br/><br/>&gt; Perhaps you were logged on as root when you installed this version of <br/>Perl and DBI.<br/><br/>Yes, that&#39;s correct.<br/><br/><br/>&gt;&gt; And Furthermore, I might have accidentally installed Perl twice - one manually from the source and the other from the Repo.<br/>&gt;&gt;<br/>&gt;&gt; Thus, now, my DBI.pm is located in the following location:<br/>&gt;&gt; /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>&gt;&gt; /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/><br/>&gt; That&#39;s normal. The problem lies elsewhere.<br/><br/>&gt;&gt; This has affected the operation of my spamassassin, amavis and sqlgrey. All of them throw up a similar error<br/>&gt;&gt;<br/>&gt;&gt;<br/> For spamassassin, the error is Can&#39;t locate DBI.pm in @INC (@INC <br/>contains: lib /usr/local/share/perl/5.14.2 /etc/perl <br/>/usr/local/lib/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 <br/>/usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at <br/>/usr/local/share/perl/5.14.2/Mail/SpamAssassin/SQLBasedAddrList.pm line <br/>82.<br/><br/>&gt; This suggests spamassassin (and amavis etc below) are not logged on as <br/>root when they run. That is, they are using a different Perl than the <br/>one installed as root.<br/><br/><br/>When I built the server from scratch back then, I had done something that I should not have done in the first place. I installed perl from the source as follows:<br/>- tar xvzf perl-5.14.2.tar.gz<br/>- cd perl-5.14.2<br/>- ./Configure &ndash;des &ndash;Dprefix=/usr/local/perl<br/>- make<br/>- checkinstall &ndash;D make install<br/><br/><br/>To be honest, I&#39;m not sure if there are two perls installed on my systems but if I recalled, I might have accidentally run CPAN to install the perl again. very stupid move... learned my lesson the hard way.<br/><br/>Thank you very much in advance<br/><br/><br/>On Thursday, 22 May 2014 8:51 AM, Ron Savage &lt;ron@savage.net.au&gt; wrote:<br/> <br/><br/><br/>Hi<br/><br/>See below.<br/><br/>On 21/05/14 00:40, Daminto Lie wrote:<br/>&gt; Hi,<br/>&gt;<br/>&gt; I&#39;ve been getting the following errors after installing DBI and DBD-mysql manually from source.<br/>&gt;<br/>&gt; Can&#39;t locate DBI.pm in @INC (@INC contains:<br/>&gt; /etc/perl<br/>&gt; /usr/local/lib/perl/5.14.2<br/>&gt; /usr/local/share/perl/5.14.2<br/>&gt; /usr/lib/perl5 /usr/share/perl5<br/>&gt; /usr/lib/perl/5.14<br/>&gt; /usr/share/perl/5.14<br/>&gt; /usr/local/lib/site_perl .)<br/><br/>So this particular Perl does not look in /root/perl5/ as you report below.<br/><br/>Who are you logged in as when you do this?<br/><br/>&gt; This was how I installed the DBI-1.631.<br/>&gt;<br/>&gt; - perl Makefile.PL<br/>&gt; - make<br/>&gt; - make test<br/>&gt; - make test TEST_VERBOSE=1<br/>&gt; - make install<br/><br/>Who are you logged in as when you do this?<br/><br/>&gt; And this was how I installed DBD-mysql-4.027<br/>&gt;<br/>&gt; - perl Makefile.PL = --mysql_config=/home/mysql/bin/mysql_config --testuser=root --testpassword=myPasswd<br/>&gt; - make -j3<br/>&gt; - make test<br/>&gt; - checkinstall -D make install<br/><br/>Who are you logged in as when you do this?<br/><br/>&gt; I also noticed that during the completion of the installation of DBI, it actually installed it in the /root directory as follows:<br/>&gt;<br/>&gt; Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver_xst.h<br/>[snip]<br/><br/>Perhaps you were logged on as root when you installed this version of <br/>Perl and DBI.<br/><br/>&gt; And Furthermore, I might have accidentally installed Perl twice - one manually from the source and the other from the Repo.<br/>&gt;<br/>&gt; Thus, now, my DBI.pm is located in the following location:<br/>&gt; /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>&gt; /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/><br/>That&#39;s normal. The problem lies elsewhere.<br/><br/>&gt; This has affected the operation of my spamassassin, amavis and sqlgrey. All of them throw up a similar error<br/>&gt;<br/>&gt; For spamassassin, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib /usr/local/share/perl/5.14.2 /etc/perl /usr/local/lib/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/SQLBasedAddrList.pm line 82.<br/><br/>This suggests spamassassin (and amavis etc below) are not logged on as <br/>root when they run. That is, they are using a different Perl than the <br/>one installed as root.<br/><br/><br/>&gt; For amavis, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/SQL.pm line 50.<br/>&gt;<br/>&gt; Can&#39;t locate DBI.pm in @INC (@INC contains: lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/MySQL.pm line 51.<br/>&gt;<br/>&gt; For sqlgrey, it is Can&#39;t locate DBI.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at /usr/sbin/sqlgrey line 34.<br/>&gt; BEGIN failed--compilation aborted at /usr/sbin/sqlgrey line 34.<br/>&gt;<br/>&gt; I was wondering if there is any way of pointing it to the right location of DBI and DBD-mysql so that it would be able to load the DBI.pm (without having to rebuild my system from scratch)<br/><br/>Each version of Perl installed knows if and where DBI is installed.<br/><br/>How many versions of Perl do you have installed?<br/><br/>Which version is being used by each of the programs you&#39;ve having <br/>trouble with?<br/><br/>-- <br/>Ron Savage<br/>savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36962.html Thu, 22 May 2014 00:32:58 +0000 Re: error can't locate DBI.pm by Ron Savage Hi<br/><br/>See below.<br/><br/>On 21/05/14 00:40, Daminto Lie wrote:<br/>&gt; Hi,<br/>&gt;<br/>&gt; I&#39;ve been getting the following errors after installing DBI and DBD-mysql manually from source.<br/>&gt;<br/>&gt; Can&#39;t locate DBI.pm in @INC (@INC contains:<br/>&gt; /etc/perl<br/>&gt; /usr/local/lib/perl/5.14.2<br/>&gt; /usr/local/share/perl/5.14.2<br/>&gt; /usr/lib/perl5 /usr/share/perl5<br/>&gt; /usr/lib/perl/5.14<br/>&gt; /usr/share/perl/5.14<br/>&gt; /usr/local/lib/site_perl .)<br/><br/>So this particular Perl does not look in /root/perl5/ as you report below.<br/><br/>Who are you logged in as when you do this?<br/><br/>&gt; This was how I installed the DBI-1.631.<br/>&gt;<br/>&gt; - perl Makefile.PL<br/>&gt; - make<br/>&gt; - make test<br/>&gt; - make test TEST_VERBOSE=1<br/>&gt; - make install<br/><br/>Who are you logged in as when you do this?<br/><br/>&gt; And this was how I installed DBD-mysql-4.027<br/>&gt;<br/>&gt; - perl Makefile.PL = --mysql_config=/home/mysql/bin/mysql_config --testuser=root --testpassword=myPasswd<br/>&gt; - make -j3<br/>&gt; - make test<br/>&gt; - checkinstall -D make install<br/><br/>Who are you logged in as when you do this?<br/><br/>&gt; I also noticed that during the completion of the installation of DBI, it actually installed it in the /root directory as follows:<br/>&gt;<br/>&gt; Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver_xst.h<br/>[snip]<br/><br/>Perhaps you were logged on as root when you installed this version of <br/>Perl and DBI.<br/><br/>&gt; And Furthermore, I might have accidentally installed Perl twice - one manually from the source and the other from the Repo.<br/>&gt;<br/>&gt; Thus, now, my DBI.pm is located in the following location:<br/>&gt; /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>&gt; /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/><br/>That&#39;s normal. The problem lies elsewhere.<br/><br/>&gt; This has affected the operation of my spamassassin, amavis and sqlgrey. All of them throw up a similar error<br/>&gt;<br/>&gt; For spamassassin, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib /usr/local/share/perl/5.14.2 /etc/perl /usr/local/lib/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/SQLBasedAddrList.pm line 82.<br/><br/>This suggests spamassassin (and amavis etc below) are not logged on as <br/>root when they run. That is, they are using a different Perl than the <br/>one installed as root.<br/><br/>&gt; For amavis, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/SQL.pm line 50.<br/>&gt;<br/>&gt; Can&#39;t locate DBI.pm in @INC (@INC contains: lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/MySQL.pm line 51.<br/>&gt;<br/>&gt; For sqlgrey, it is Can&#39;t locate DBI.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at /usr/sbin/sqlgrey line 34.<br/>&gt; BEGIN failed--compilation aborted at /usr/sbin/sqlgrey line 34.<br/>&gt;<br/>&gt; I was wondering if there is any way of pointing it to the right location of DBI and DBD-mysql so that it would be able to load the DBI.pm (without having to rebuild my system from scratch)<br/><br/>Each version of Perl installed knows if and where DBI is installed.<br/><br/>How many versions of Perl do you have installed?<br/><br/>Which version is being used by each of the programs you&#39;ve having <br/>trouble with?<br/><br/>-- <br/>Ron Savage<br/>savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36961.html Wed, 21 May 2014 22:51:17 +0000 error can't locate DBI.pm by Daminto Lie Hi,<br/><br/>I&#39;ve been getting the following errors after installing DBI and DBD-mysql manually from source.<br/><br/>Can&#39;t locate DBI.pm in @INC (@INC contains: <br/>/etc/perl<br/>/usr/local/lib/perl/5.14.2<br/>/usr/local/share/perl/5.14.2<br/>/usr/lib/perl5 /usr/share/perl5<br/>/usr/lib/perl/5.14<br/>/usr/share/perl/5.14<br/>/usr/local/lib/site_perl .)<br/><br/>This was how I installed the DBI-1.631.<br/><br/>- perl Makefile.PL<br/>- make<br/>- make test<br/>- make test TEST_VERBOSE=1<br/>- make install<br/><br/><br/>And this was how I installed DBD-mysql-4.027<br/><br/>- perl Makefile.PL = --mysql_config=/home/mysql/bin/mysql_config --testuser=root --testpassword=myPasswd<br/>- make -j3<br/>- make test<br/>- checkinstall -D make install<br/><br/><br/>I also noticed that during the completion of the installation of DBI, it actually installed it in the /root directory as follows:<br/><br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver_xst.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbipport.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.so<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.bs<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbivport.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver.xst<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbd_xsh.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbi_sql.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBIXS.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbixs_rev.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/dbixs_rev.pl<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileData.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProxyServer.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Profile.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileSubs.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/W32ODBC.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/FAQ.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Changes.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/PurePerl.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Execute.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Response.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Request.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/pipeone.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/stream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/DataDumper.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Storable.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoReturn.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoType.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ANSI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ODBC.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/_accessor.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/CacheMemory.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/SQL/Nano.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/Metadata.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/Developers.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/HowTo.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper/Apache.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/DBM.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/NullP.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Sponge.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/ExampleP.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Proxy.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Developers.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Roadmap.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/HowTo.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/corostream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/null.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/pipeone.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/stream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/classic.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/pedantic.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/rush.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Win32/DBIODBC.pm<br/>Installing /root/perl5/man/man1/dbiprof.1p<br/>Installing /root/perl5/man/man1/dbilogstrip.1p<br/>Installing /root/perl5/man/man1/dbiproxy.1p<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::pipeone.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::pedantic.3pm<br/>Installing /root/perl5/man/man3/DBI::SQL::Nano.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfo::ODBC.3pm<br/>Installing /root/perl5/man/man3/DBI::PurePerl.3pm<br/>Installing /root/perl5/man/man3/DBI::ProxyServer.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::null.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileData.3pm<br/>Installing /root/perl5/man/man3/DBD::Sponge.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::Base.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::classic.3pm<br/>Installing /root/perl5/man/man3/DBI::Util::CacheMemory.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfoType.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::HowTo.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Serializer::DataDumper.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::pipeone.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileSubs.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::Metadata.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Execute.3pm<br/>Installing /root/perl5/man/man3/DBI.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::Base.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfo::ANSI.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileDumper::Apache.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::corostream.3pm<br/>Installing /root/perl5/man/man3/DBI::W32ODBC.3pm<br/>Installing /root/perl5/man/man3/DBD::File::Developers.3pm<br/>Installing /root/perl5/man/man3/DBI::FAQ.3pm<br/>Installing /root/perl5/man/man3/DBD::Proxy.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileDumper.3pm<br/>Installing /root/perl5/man/man3/Win32::DBIODBC.3pm<br/>Installing /root/perl5/man/man3/DBD::DBM.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Request.3pm<br/>Installing /root/perl5/man/man3/DBD::File::Roadmap.3pm<br/>Installing /root/perl5/man/man3/DBI::Profile.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::Base.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::Developers.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::stream.3pm<br/>Installing /root/perl5/man/man3/DBD::File::HowTo.3pm<br/>Installing /root/perl5/man/man3/Bundle::DBI.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfoReturn.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Serializer::Base.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Serializer::Storable.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine.3pm<br/>Installing /root/perl5/man/man3/DBD::File.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::stream.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Response.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::rush.3pm<br/>Installing /root/perl5/bin/dbiprof<br/>Installing /root/perl5/bin/dbiproxy<br/>Installing /root/perl5/bin/dbilogstrip<br/><br/><br/>And Furthermore, I might have accidentally installed Perl twice - one manually from the source and the other from the Repo.<br/><br/>Thus, now, my DBI.pm is located in the following location:<br/>/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/><br/>This has affected the operation of my spamassassin, amavis and sqlgrey. All of them throw up a similar error<br/><br/>For spamassassin, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib /usr/local/share/perl/5.14.2 /etc/perl /usr/local/lib/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/SQLBasedAddrList.pm line 82.<br/><br/>For amavis, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/SQL.pm line 50.<br/><br/>Can&#39;t locate DBI.pm in @INC (@INC contains: lib /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl) at /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/MySQL.pm line 51.<br/><br/>For sqlgrey, it is Can&#39;t locate DBI.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 /usr/local/lib/site_perl .) at /usr/sbin/sqlgrey line 34.<br/>BEGIN failed--compilation aborted at /usr/sbin/sqlgrey line 34.<br/><br/>I was wondering if there is any way of pointing it to the right location of DBI and DBD-mysql so that it would be able to load the DBI.pm (without having to rebuild my system from scratch)<br/><br/>Thank you in advance<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36960.html Wed, 21 May 2014 21:19:56 +0000 Re: unable to locate DBI.pm by Chad Wallace <br/>Posting back to the list... Please don&#39;t reply to me personally; I am<br/>subscribed to the list.<br/><br/><br/>On Tue, 20 May 2014 18:23:52 -0700 (PDT)<br/>Daminto Lie &lt;dlie76@yahoo.com.au&gt; wrote:<br/><br/>&gt; Thanks a lot for your reply.<br/>&gt; <br/>&gt; I think this is what I should be using to install DBI and DBD-mysql. <br/>&gt; <br/>&gt; <br/>&gt; But as I mentioned to John before that I think I need to get rid of<br/>&gt; DBI-1.641 first before running the command you suggested. please<br/>&gt; correct me if I&#39;m wrong.<br/><br/>Well, it doesn&#39;t seem like that DBI installation is even doing<br/>anything. But yes, you should remove it, just to get rid of<br/>the clutter. I would just run this:<br/><br/>rm -r /root/perl5<br/><br/>Then install DBI and DBD-mysql from your distro&#39;s packaging system.<br/>They&#39;ll be put in the correct place (one of the perl locations under<br/>/usr/share or /usr/lib), and then spamassassin and the others will be<br/>able to use them.<br/><br/><br/><br/>&gt; On Wednesday, 21 May 2014 10:32 AM, Chad Wallace<br/>&gt; &lt;cwallace@lodgingcompany.com&gt; wrote: <br/>&gt; <br/>&gt; <br/>&gt; On Tue, 20 May 2014 17:22:58 -0700<br/>&gt; <br/>&gt; John R Pierce &lt;pierce@hogranch.com&gt; wrote:<br/>&gt; <br/>&gt; &gt; what operating system are you on?&nbsp; isn&#39;t there a DBI and such in the<br/>&gt; &gt; OS package repository?<br/>&gt; &gt; <br/>&gt; &gt; for instance, on a RHEL/CentOS/Fedora type system, I&#39;d use...<br/>&gt; &gt; <br/>&gt; &gt;&nbsp; &nbsp; &nbsp; sudo yum install perl-DBI perl-DBD-MySQL<br/>&gt; &gt; <br/>&gt; &gt; of course, for a different Linux distribution, or another OS<br/>&gt; &gt; entirely, both the command and the package names are probably<br/>&gt; &gt; different.<br/>&gt; <br/>&gt; on Debian and related distros:<br/>&gt; <br/>&gt; sudo apt-get install libdbi-perl libdbd-mysql-perl<br/>&gt; <br/>&gt; <br/>&gt; <br/><br/><br/>-- <br/><br/>C. Chad Wallace, B.Sc.<br/>The Lodging Company<br/>http://www.lodgingcompany.com/<br/>OpenPGP Public Key ID: 0x262208A0<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36959.html Wed, 21 May 2014 17:46:21 +0000 Re: unable to locate DBI.pm by Chad Wallace On Tue, 20 May 2014 17:22:58 -0700<br/>John R Pierce &lt;pierce@hogranch.com&gt; wrote:<br/><br/>&gt; what operating system are you on? isn&#39;t there a DBI and such in the<br/>&gt; OS package repository?<br/>&gt; <br/>&gt; for instance, on a RHEL/CentOS/Fedora type system, I&#39;d use...<br/>&gt; <br/>&gt; sudo yum install perl-DBI perl-DBD-MySQL<br/>&gt; <br/>&gt; of course, for a different Linux distribution, or another OS<br/>&gt; entirely, both the command and the package names are probably<br/>&gt; different.<br/><br/>on Debian and related distros:<br/><br/>sudo apt-get install libdbi-perl libdbd-mysql-perl<br/><br/><br/><br/>-- <br/><br/>C. Chad Wallace, B.Sc.<br/>The Lodging Company<br/>http://www.lodgingcompany.com/<br/>OpenPGP Public Key ID: 0x262208A0<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36958.html Wed, 21 May 2014 00:32:34 +0000 Re: unable to locate DBI.pm by John R Pierce On 5/20/2014 5:11 PM, Daminto Lie wrote:<br/>&gt; I&#39;ve been getting the following errors after installing DBI and <br/>&gt; DBD-mysql manually from source.<br/><br/>it appears you installed all that stuff in /root&#39;s private directory, <br/>which is generally a bad practice.<br/><br/>what operating system are you on? isn&#39;t there a DBI and such in the OS <br/>package repository?<br/><br/>for instance, on a RHEL/CentOS/Fedora type system, I&#39;d use...<br/><br/> sudo yum install perl-DBI perl-DBD-MySQL<br/><br/>of course, for a different Linux distribution, or another OS entirely, <br/>both the command and the package names are probably different.<br/><br/><br/><br/><br/>-- <br/>john r pierce 37N 122W<br/>somewhere on the middle of the left coast<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36957.html Wed, 21 May 2014 00:23:13 +0000 Re: unable to locate DBI.pm by Daminto Lie Hi,<br/><br/>I&#39;m sorry that I posted this same question twice because I thought it did not go through the first time.<br/><br/>Thank you in advance<br/><br/><br/>Hi <br/>On Wednesday, 21 May 2014 10:11 AM, Daminto Lie &lt;dlie76@yahoo.com.au&gt; wrote:<br/> <br/><br/><br/>Hi,<br/><br/>I&#39;ve been getting the following errors after installing DBI and DBD-mysql manually from source.<br/><br/>Can&#39;t locate DBI.pm in @INC (@INC contains: <br/>/etc/perl<br/>/usr/local/lib/perl/5.14.2<br/>/usr/local/share/perl/5.14.2<br/>/usr/lib/perl5 /usr/share/perl5<br/>/usr/lib/perl/5.14<br/>/usr/share/perl/5.14<br/>/usr/local/lib/site_perl .)<br/><br/>This was how I installed the DBI-1.631.<br/><br/>- perl Makefile.PL<br/>- make<br/>- make test<br/>- make test<br/> TEST_VERBOSE=1<br/>- make install<br/><br/><br/>And this was how I installed DBD-mysql-4.027<br/><br/>- perl Makefile.PL = --mysql_config=/home/mysql/bin/mysql_config --testuser=root --testpassword=myPasswd<br/>- make -j3<br/>- make test<br/>- checkinstall -D make install<br/><br/><br/>I<br/> also noticed that during the completion of the installation of DBI, it <br/>actually installed it in the /root directory as follows:<br/><br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver_xst.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbipport.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.so<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.bs<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbivport.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver.xst<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbd_xsh.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbi_sql.h<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBIXS.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbixs_rev.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/dbixs_rev.pl<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileData.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProxyServer.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Profile.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileSubs.pm<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/W32ODBC.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/FAQ.pm<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Changes.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/PurePerl.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Execute.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Response.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Request.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/pipeone.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/stream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/DataDumper.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Storable.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoReturn.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoType.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ANSI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ODBC.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/_accessor.pm<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/CacheMemory.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/SQL/Nano.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/Metadata.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/Developers.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/HowTo.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper/Apache.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/DBM.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/NullP.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Sponge.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/ExampleP.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Proxy.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Developers.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Roadmap.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/HowTo.pod<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/corostream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/null.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/pipeone.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/stream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/classic.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/pedantic.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/rush.pm<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Win32/DBIODBC.pm<br/>Installing /root/perl5/man/man1/dbiprof.1p<br/>Installing /root/perl5/man/man1/dbilogstrip.1p<br/>Installing /root/perl5/man/man1/dbiproxy.1p<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::pipeone.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::pedantic.3pm<br/>Installing /root/perl5/man/man3/DBI::SQL::Nano.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfo::ODBC.3pm<br/>Installing /root/perl5/man/man3/DBI::PurePerl.3pm<br/>Installing /root/perl5/man/man3/DBI::ProxyServer.3pm<br/>Installing<br/> /root/perl5/man/man3/DBD::Gofer::Transport::null.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileData.3pm<br/>Installing /root/perl5/man/man3/DBD::Sponge.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::Base.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::classic.3pm<br/>Installing /root/perl5/man/man3/DBI::Util::CacheMemory.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfoType.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::HowTo.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Serializer::DataDumper.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::pipeone.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileSubs.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::Metadata.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Execute.3pm<br/>Installing /root/perl5/man/man3/DBI.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::Base.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfo::ANSI.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileDumper::Apache.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::corostream.3pm<br/>Installing /root/perl5/man/man3/DBI::W32ODBC.3pm<br/>Installing /root/perl5/man/man3/DBD::File::Developers.3pm<br/>Installing /root/perl5/man/man3/DBI::FAQ.3pm<br/>Installing /root/perl5/man/man3/DBD::Proxy.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileDumper.3pm<br/>Installing /root/perl5/man/man3/Win32::DBIODBC.3pm<br/>Installing<br/> /root/perl5/man/man3/DBD::DBM.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Request.3pm<br/>Installing /root/perl5/man/man3/DBD::File::Roadmap.3pm<br/>Installing /root/perl5/man/man3/DBI::Profile.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::Base.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::Developers.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::stream.3pm<br/>Installing /root/perl5/man/man3/DBD::File::HowTo.3pm<br/>Installing /root/perl5/man/man3/Bundle::DBI.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfoReturn.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Serializer::Base.3pm<br/>Installing<br/> /root/perl5/man/man3/DBI::Gofer::Serializer::Storable.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine.3pm<br/>Installing /root/perl5/man/man3/DBD::File.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::stream.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Response.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::rush.3pm<br/>Installing /root/perl5/bin/dbiprof<br/>Installing /root/perl5/bin/dbiproxy<br/>Installing /root/perl5/bin/dbilogstrip<br/><br/><br/>And Furthermore, I might have accidentally installed Perl twice - one manually from the source and the other from the Repo.<br/><br/>Thus, now, my DBI.pm is located in the following location:<br/>/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/><br/>This has affected the operation of my spamassassin, amavis and sqlgrey. All of them throw up a similar error<br/><br/>For<br/> spamassassin, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: <br/>lib /usr/local/share/perl/5.14.2 /etc/perl /usr/local/lib/perl/5.14.2 <br/>/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl) at <br/>/usr/local/share/perl/5.14.2/Mail/SpamAssassin/SQLBasedAddrList.pm line <br/>82.<br/><br/>For<br/> amavis, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib <br/>/etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 <br/>/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl) at<br/> /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/SQL.pm line <br/>50.<br/><br/>Can&#39;t<br/> locate DBI.pm in @INC (@INC contains: lib /etc/perl <br/>/usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 <br/>/usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl) at <br/>/usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/MySQL.pm line <br/>51.<br/><br/>For<br/> sqlgrey, it is Can&#39;t locate DBI.pm in @INC (@INC contains: /etc/perl <br/>/usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 <br/>/usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl .) at /usr/sbin/sqlgrey line 34.<br/>BEGIN failed--compilation aborted at /usr/sbin/sqlgrey line 34.<br/><br/>I was wondering if there is any way of pointing it to the right location of DBI and DBD-mysql so that it would be able to load<br/> the DBI.pm (without having to rebuild my system from scratch)<br/><br/>Thank you in advance<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36956.html Wed, 21 May 2014 00:13:51 +0000 unable to locate DBI.pm by Daminto Lie Hi,<br/><br/>I&#39;ve been getting the following errors after installing DBI and DBD-mysql manually from source.<br/><br/>Can&#39;t locate DBI.pm in @INC (@INC contains: <br/>/etc/perl<br/>/usr/local/lib/perl/5.14.2<br/>/usr/local/share/perl/5.14.2<br/>/usr/lib/perl5 /usr/share/perl5<br/>/usr/lib/perl/5.14<br/>/usr/share/perl/5.14<br/>/usr/local/lib/site_perl .)<br/><br/>This was how I installed the DBI-1.631.<br/><br/>- perl Makefile.PL<br/>- make<br/>- make test<br/>- make test TEST_VERBOSE=1<br/>- make install<br/><br/><br/>And this was how I installed DBD-mysql-4.027<br/><br/>- perl Makefile.PL = --mysql_config=/home/mysql/bin/mysql_config --testuser=root --testpassword=myPasswd<br/>- make -j3<br/>- make test<br/>- checkinstall -D make install<br/><br/><br/>I<br/> also noticed that during the completion of the installation of DBI, it <br/>actually installed it in the /root directory as follows:<br/><br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver_xst.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbipport.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.so<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBI.bs<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbivport.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/Driver.xst<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbd_xsh.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbi_sql.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/DBIXS.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/auto/DBI/dbixs_rev.h<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/dbixs_rev.pl<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileData.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProxyServer.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Profile.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileSubs.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/W32ODBC.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/FAQ.pm<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Changes.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/PurePerl.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Execute.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Response.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Request.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/pipeone.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/stream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Transport/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/DataDumper.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Storable.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Gofer/Serializer/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoReturn.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfoType.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ANSI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Const/GetInfo/ODBC.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/_accessor.pm<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/Util/CacheMemory.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/SQL/Nano.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/Metadata.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/Developers.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/DBD/SqlEngine/HowTo.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI/ProfileDumper/Apache.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/DBM.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/NullP.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Sponge.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/ExampleP.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Proxy.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Developers.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/Roadmap.pod<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/File/HowTo.pod<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/corostream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/null.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/pipeone.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/stream.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Transport/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/classic.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/pedantic.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/rush.pm<br/>Installing<br/> /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBD/Gofer/Policy/Base.pm<br/>Installing /root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Win32/DBIODBC.pm<br/>Installing /root/perl5/man/man1/dbiprof.1p<br/>Installing /root/perl5/man/man1/dbilogstrip.1p<br/>Installing /root/perl5/man/man1/dbiproxy.1p<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::pipeone.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::pedantic.3pm<br/>Installing /root/perl5/man/man3/DBI::SQL::Nano.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfo::ODBC.3pm<br/>Installing /root/perl5/man/man3/DBI::PurePerl.3pm<br/>Installing /root/perl5/man/man3/DBI::ProxyServer.3pm<br/>Installing<br/> /root/perl5/man/man3/DBD::Gofer::Transport::null.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileData.3pm<br/>Installing /root/perl5/man/man3/DBD::Sponge.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::Base.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::classic.3pm<br/>Installing /root/perl5/man/man3/DBI::Util::CacheMemory.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfoType.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::HowTo.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Serializer::DataDumper.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::pipeone.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileSubs.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::Metadata.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Execute.3pm<br/>Installing /root/perl5/man/man3/DBI.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::Base.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfo::ANSI.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileDumper::Apache.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::corostream.3pm<br/>Installing /root/perl5/man/man3/DBI::W32ODBC.3pm<br/>Installing /root/perl5/man/man3/DBD::File::Developers.3pm<br/>Installing /root/perl5/man/man3/DBI::FAQ.3pm<br/>Installing /root/perl5/man/man3/DBD::Proxy.3pm<br/>Installing /root/perl5/man/man3/DBI::ProfileDumper.3pm<br/>Installing /root/perl5/man/man3/Win32::DBIODBC.3pm<br/>Installing<br/> /root/perl5/man/man3/DBD::DBM.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Request.3pm<br/>Installing /root/perl5/man/man3/DBD::File::Roadmap.3pm<br/>Installing /root/perl5/man/man3/DBI::Profile.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::Base.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine::Developers.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Transport::stream.3pm<br/>Installing /root/perl5/man/man3/DBD::File::HowTo.3pm<br/>Installing /root/perl5/man/man3/Bundle::DBI.3pm<br/>Installing /root/perl5/man/man3/DBI::Const::GetInfoReturn.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Serializer::Base.3pm<br/>Installing<br/> /root/perl5/man/man3/DBI::Gofer::Serializer::Storable.3pm<br/>Installing /root/perl5/man/man3/DBI::DBD::SqlEngine.3pm<br/>Installing /root/perl5/man/man3/DBD::File.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Transport::stream.3pm<br/>Installing /root/perl5/man/man3/DBI::Gofer::Response.3pm<br/>Installing /root/perl5/man/man3/DBD::Gofer::Policy::rush.3pm<br/>Installing /root/perl5/bin/dbiprof<br/>Installing /root/perl5/bin/dbiproxy<br/>Installing /root/perl5/bin/dbilogstrip<br/><br/><br/>And Furthermore, I might have accidentally installed Perl twice - one manually from the source and the other from the Repo.<br/><br/>Thus, now, my DBI.pm is located in the following location:<br/>/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/DBI.pm<br/>/root/perl5/lib/perl5/i686-linux-gnu-thread-multi-64int/Bundle/DBI.pm<br/><br/>This has affected the operation of my spamassassin, amavis and sqlgrey. All of them throw up a similar error<br/><br/>For<br/> spamassassin, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: <br/>lib /usr/local/share/perl/5.14.2 /etc/perl /usr/local/lib/perl/5.14.2 <br/>/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl) at <br/>/usr/local/share/perl/5.14.2/Mail/SpamAssassin/SQLBasedAddrList.pm line <br/>82.<br/><br/>For<br/> amavis, the error is Can&#39;t locate DBI.pm in @INC (@INC contains: lib <br/>/etc/perl /usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 <br/>/usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl) at<br/> /usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/SQL.pm line <br/>50.<br/><br/>Can&#39;t<br/> locate DBI.pm in @INC (@INC contains: lib /etc/perl <br/>/usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 <br/>/usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl) at <br/>/usr/local/share/perl/5.14.2/Mail/SpamAssassin/BayesStore/MySQL.pm line <br/>51.<br/><br/>For<br/> sqlgrey, it is Can&#39;t locate DBI.pm in @INC (@INC contains: /etc/perl <br/>/usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5 <br/>/usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14 <br/>/usr/local/lib/site_perl .) at /usr/sbin/sqlgrey line 34.<br/>BEGIN failed--compilation aborted at /usr/sbin/sqlgrey line 34.<br/><br/>I was wondering if there is any way of pointing it to the right location of DBI and DBD-mysql so that it would be able to load<br/> the DBI.pm (without having to rebuild my system from scratch)<br/><br/>Thank you in advance<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36955.html Wed, 21 May 2014 00:11:11 +0000 Re: SQL Parser by Jens Rehsack <br/>Am 28.04.2014 um 07:28 schrieb Gustavo Castro &lt;cris7ian.gus7avo@gmail.com&gt;:<br/><br/>&gt; Hi! I have a doubt using SQL Parser Module (Link) I need to implement the command &quot;CREATE DATABASE&quot; because this module only implements &quot;CREATE TABLE&quot;. Thank you very much for your answer.<br/><br/>Hi,<br/><br/>currently all SQL::Parser based DBD&rsquo;s support only one Database which has to be specified at connection.<br/>That&rsquo;s why there&rsquo;s no need for a &bdquo;CREATE DATABASE&ldquo;.<br/><br/>Depending on you&rsquo;re goals you can derive from SQL::Parser and add support for a create database statement (if you want to continue with SQL::Statement), or - when just parsing is required - check what ribasushi has in his portfolio. IIRC, he has several SQL parsing packages which are much more advanced than SQL::Parser.<br/><br/>Best regards and good luck<br/>-- <br/>Jens Rehsack<br/>pkgsrc, Perl5<br/>rehsack@cpan.org<br/>cpanid: REHSACK<br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36954.html Sat, 03 May 2014 09:26:21 +0000 SQL Parser by Gustavo Castro Hi! I have a doubt using SQL Parser Module<br/>(Link&lt;http://search.cpan.org/~rehsack/SQL-Statement-1.405/lib/SQL/Parser.pm&gt;)<br/>I need to implement the command &quot;CREATE DATABASE&quot; because this module only<br/>implements &quot;CREATE TABLE&quot;. Thank you very much for your answer.<br/><br/><br/>-- <br/>Gustavo Castro<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/05/msg36953.html Fri, 02 May 2014 06:47:55 +0000 New development release of DBD::ODBC 1.49_3 by Martin J. Evans I&#39;ve just uploaded DBD::ODBC 1.49_3 to the CPAN. Please test it especially if you&#39;ve always wanted to use MS SQL Server Query Notification as it should now support it.<br/><br/>Changes since last full release are:<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_getdiaffield 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/05/msg36952.html Thu, 01 May 2014 12:55:31 +0000 Re: DBI->connect performance issue by Andrew Park Thanks for the suggestions that I received.<br/>We finally managed to find and correct the issue so I thought I&#39;d share it<br/>with the group to close this thread.<br/><br/>Essentially, if we try to use a local catalog entry for the DB2 10.5<br/>database we consistently get slow response times (4s for 32-bit version and<br/>6s for 64-bit!).<br/>But by creating a separate catalog entry to go through the network back to<br/>original database on DB2 V10.5, it works super fast!<br/><br/>So, as odd as it seems, the work around is really not to try to connect to<br/>DB2 10.5 via a local catalog entry...<br/><br/>Just thought I&#39;d share that with everybody in case anybody else is<br/>experiencing these performance-related issues with DB2 10.5.<br/><br/><br/>On Mon, Apr 14, 2014 at 10:27 PM, Greg Sabino Mullane &lt;greg@turnstep.com&gt;wrote:<br/><br/>&gt;<br/>&gt; -----BEGIN PGP SIGNED MESSAGE-----<br/>&gt; Hash: RIPEMD160<br/>&gt;<br/>&gt;<br/>&gt; &gt; We&#39;re finding that simply creating a connection maxes out one of the<br/>&gt; CPU&#39;s<br/>&gt; &gt; and consistently takes over 4s (but sometimes it manages to create the<br/>&gt; &gt; connection in about .2s).<br/>&gt; ...<br/>&gt; &gt; If any body can offer up any sort of suggestion, I&#39;d be most grateful -<br/>&gt; &gt; we&#39;re truly stumped.<br/>&gt;<br/>&gt; Nothing jumps out right away. You should probably dig deep and see where<br/>&gt; the pause is, by running it under strace.<br/>&gt;<br/>&gt; - --<br/>&gt; Greg Sabino Mullane greg@turnstep.com<br/>&gt; End Point Corporation http://www.endpoint.com/<br/>&gt; PGP Key: 0x14964AC8 201404141925<br/>&gt; http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>&gt; -----BEGIN PGP SIGNATURE-----<br/>&gt;<br/>&gt; iEYEAREDAAYFAlNMmPoACgkQvJuQZxSWSsjxFACgv+LgzhH1On5LGQ44Pebns8Li<br/>&gt; cBkAoIxt8rPaBMrvnJIVwI4Pg/d1rQzf<br/>&gt; =uwKW<br/>&gt; -----END PGP SIGNATURE-----<br/>&gt;<br/>&gt;<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/04/msg36951.html Wed, 30 Apr 2014 03:17:57 +0000 Re: DBI::mysql failures aren't being caught in an eval block in version 1.623 by peter | DBD::mysql::db do failed: INSERT, DELETE command denied to user<br/>| &#39;user&#39;@&#39;localhost&#39; for table &#39;faketable&#39; [for Statement &quot;LOAD DATA<br/>| LOW_PRIORITY LOCAL INFILE &#39;/tmp/GNjPykldGgfakedb.faketable.dat&#39;<br/>| REPLACE INTO TABLE fakedb.faketable CHARACTER SET utf8 FIELDS<br/>| TERMINATED BY &#39;,&#39; OPTIONALLY ENCLOSED BY &#39;&quot;&#39; LINES TERMINATED BY<br/>| &#39;\n&#39; (client,param,value)&quot;]<br/><br/><br/>Could it be that this is rather a MySQL issue than a DBI one?<br/>MySQL will issue the &quot;permission denied&quot; error instead of an &quot;object not<br/>found&quot; fatal error when your used ID does not have permission to read the<br/>metadata (list the table names) from the particular database (aka schema).<br/>Try (temporarily) modifying the grants for that user, e.g. &quot;GRANT SELECT ON *.*&quot;,<br/>and see if the changed error message (object not found) is catched by your<br/>eval block.<br/><br/>-- Peter Vanroose,<br/> ABIS Training &amp; Consulting,<br/> Leuven, Belgium.<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/04/msg36950.html Thu, 24 Apr 2014 16:25:55 +0000 DBI::mysql failures aren't being caught in an eval block in version1.623 by Hunter McMillen Hello,<br/><br/>My company is not on the most current version of DBI, we typically use <br/>v1.618. We built a new server however that is using v1.623, this is the <br/>version I am having issues with.<br/><br/>We have a module that does bulk inserts into tables using temporary <br/>files, as one of the tests for this module I try to upload a file to a <br/>table that does not exists. Which results not in a table does not exist <br/>error, but a permissions error.<br/><br/> DBD::mysql::db do failed: INSERT, DELETE command denied to user<br/> &#39;user&#39;@&#39;localhost&#39; for table &#39;faketable&#39; [for Statement &quot;LOAD DATA<br/> LOW_PRIORITY LOCAL INFILE &#39;/tmp/GNjPykldGgfakedb.faketable.dat&#39; <br/> REPLACE INTO TABLE fakedb.faketable CHARACTER SET utf8 FIELDS<br/> TERMINATED BY &#39;,&#39; OPTIONALLY ENCLOSED BY &#39;&quot;&#39; LINES TERMINATED BY<br/> &#39;\n&#39; (client,param,value)&quot;]<br/><br/>The call to the statement that attempts to upload this data is wrapped <br/>in an eval block:<br/><br/> eval {<br/> $dbh-&gt;upload($data);<br/> };<br/> if ($EVAL_ERROR) {<br/> # do something<br/> }<br/><br/>In version 1.618, the /eval/ block catches the returned error. In <br/>version 1.623 the error is not captured, and the program crashes.<br/><br/>Looking at the change log between these revisions I don&#39;t see anything <br/>related to this, but could this have been a bug introduced in that time <br/>frame?<br/><br/>Thanks.<br/>Hunter McMillen.<br/><br/><br/><br/>-- <br/> &lt;http://www.rimmkaufman.com&gt;<br/>&lt;http://twitter.com/rimmkaufman&gt; &lt;http://www.linkedin.com/company/85385&gt; &lt;http://plus.google.com/104980442218952272663/posts&gt;<br/> &lt;http://www.facebook.com/rimmkaufman&gt; &lt;http://www.RKGblog.com&gt;<br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/04/msg36949.html Wed, 23 Apr 2014 02:38:52 +0000 Re: Database encoding not recognized by DBD::Pg by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/>Vincent Veyron wrote:<br/><br/>&gt; Same thing for both servers:<br/>&gt;<br/>&gt; ppro_utf8=&gt; show client_encoding;<br/>&gt; client_encoding <br/>&gt; -----------------<br/>&gt; LATIN9<br/><br/>Just to be clear, if client_encoding is not UTF8, then most bets are <br/>off as far as DBD::Pg doing the &quot;right thing&quot;. It&#39;s highly recommended <br/>that client_encoding always be set to UTF8, regardless of the <br/>server_encoding.<br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201404221609<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlNWzTkACgkQvJuQZxSWSsiJzgCfQddTGTtyub3bqChqeR0Ans6e<br/>xokAoLEhK1ohqaQm6GN5yD5GznQM98rO<br/>=Ubs5<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/04/msg36948.html Tue, 22 Apr 2014 20:13:22 +0000 Re: DBI->connect performance issue by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/><br/>&gt; We&#39;re finding that simply creating a connection maxes out one of the CPU&#39;s<br/>&gt; and consistently takes over 4s (but sometimes it manages to create the<br/>&gt; connection in about .2s).<br/>...<br/>&gt; If any body can offer up any sort of suggestion, I&#39;d be most grateful -<br/>&gt; we&#39;re truly stumped.<br/><br/>Nothing jumps out right away. You should probably dig deep and see where <br/>the pause is, by running it under strace.<br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>End Point Corporation http://www.endpoint.com/<br/>PGP Key: 0x14964AC8 201404141925<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlNMmPoACgkQvJuQZxSWSsjxFACgv+LgzhH1On5LGQ44Pebns8Li<br/>cBkAoIxt8rPaBMrvnJIVwI4Pg/d1rQzf<br/>=uwKW<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/04/msg36947.html Tue, 15 Apr 2014 02:28:03 +0000