perl.dbi.users http://www.nntp.perl.org/group/perl.dbi.users/ ... Copyright 1998-2014 perl.org Sat, 20 Sep 2014 09:02:05 +0000 ask@perl.org Re: SQL:Statement/Parser by Mauricio Begovich Hi Ron, nice to meet you and thank you so much for your soon answer.<br/><br/>Got it! now I&#39;ll never forget it: it&#39;s Perl ;)!<br/><br/>Well, I&#39;m working with the SQL::Statement module. The code with I&#39;m dealing<br/>is the following code:<br/>################################################################################<br/><br/> use SQL::Statement;<br/> my $sql = &quot;SELECT a FROM b JOIN c WHERE c=? AND e=7 ORDER BY f<br/>DESC LIMIT 5,2&quot;;<br/> my $parser = SQL::Parser-&gt;new();<br/> $parser-&gt;{RaiseError}=1;<br/> $parser-&gt;{PrintError}=0;<br/> $parser-&gt;parse(&quot;LOAD &#39;MyLib::MySyntax&#39; &quot;);<br/> my $stmt = SQL::Statement-&gt;new($sql,$parser);<br/> printf &quot;Command %s\n&quot;,$stmt-&gt;command;<br/> printf &quot;Num of Placeholders %s\n&quot;,scalar $stmt-&gt;params;<br/> printf &quot;Columns %s\n&quot;,join( &#39;,&#39;, map {$_-&gt;name}<br/>$stmt-&gt;column_defs() );<br/> printf &quot;Tables %s\n&quot;,join( &#39;,&#39;, map {$_-&gt;name}<br/>$stmt-&gt;tables() );<br/> printf &quot;Where operator %s\n&quot;,join( &#39;,&#39;, $stmt-&gt;where-&gt;op() );<br/> printf &quot;Limit %s\n&quot;,$stmt-&gt;limit();<br/> printf &quot;Offset %s\n&quot;,$stmt-&gt;offset();<br/><br/> # these will work not before $stmt-&gt;execute()<br/> printf &quot;Order Columns %s\n&quot;,join(&#39;,&#39;, map {$_-&gt;column}<br/>$stmt-&gt;order() );<br/><br/>################################################################################<br/><br/><br/>And the problem I have is that I can&#39;t access the $stmt-&gt;column_defs()<br/>through the<br/>map{$_-&gt;name} function.<br/><br/>When I do something like print DUMP $stmt-&gt;column_defs();, I can<br/>visualize the content<br/><br/>of the hash that contents information about the columns of the query.<br/><br/>Have you any ideas of what I&#39;m doing wrong?<br/><br/>Thanks in advance!<br/><br/>Mauricio.<br/><br/><br/><br/>2014-09-10 17:19 GMT-05:00 Ron Savage &lt;ron@savage.net.au&gt;:<br/><br/>&gt; Hi Mauricio<br/>&gt;<br/>&gt; &gt;Good morning!<br/>&gt;<br/>&gt; &gt;I&#39;m a Mexican PERL fan, and I write first for congratulate you for &gt;this<br/>&gt; great job.<br/>&gt;<br/>&gt; Glad to hear you&#39;re using Perl.<br/>&gt;<br/>&gt; And yes, it&#39;s Perl, not PERL.<br/>&gt;<br/>&gt; &gt;I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since &gt;my<br/>&gt; Ubuntu console, but I have some issues with the map {$_-&gt;name}<br/>&gt; &gt;$stmt-&gt;column_defs() method for parsing it.<br/>&gt;<br/>&gt; &gt;Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on<br/>&gt; &gt;unbless object.<br/>&gt;<br/>&gt; We need to see the code. Post the shortest possible sample code which<br/>&gt; produces this error.<br/>&gt;<br/>&gt; Are you connecting to a real, pre-existing database with pre-existing<br/>&gt; tables?<br/>&gt;<br/>&gt; If so, how /exactly/ are you doing that?<br/>&gt;<br/>&gt; &gt;I will appreciate too much, any information about this error that was<br/>&gt; &gt;taken from CPAN documentation of this module.<br/>&gt;<br/>&gt; --<br/>&gt; Ron Savage - savage.net.au<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37004.html Tue, 16 Sep 2014 12:16:27 +0000 Re: SQL:Statement/Parser by C.J. Adams-Collier KF7BMP On Thu, 2014-09-11 at 08:19 +1000, Ron Savage wrote:<br/>&gt; Hi Mauricio<br/>&gt; <br/>&gt; &gt;Good morning!<br/>&gt; <br/>&gt; &gt;I&#39;m a Mexican PERL fan, and I write first for congratulate you for <br/>&gt; &gt;this great job.<br/><br/>Welcome! I blame Tim for most of the awesome.<br/><br/>&gt; Glad to hear you&#39;re using Perl.<br/>&gt; <br/>&gt; And yes, it&#39;s Perl, not PERL.<br/><br/>Well it&#39;s officially either Perl or perl (if you&#39;re speaking of the<br/>interpreter) but we generally don&#39;t mind you calling it PERL for the<br/>most part. I&#39;ve always been a fan of the backronym &quot;Pathologically<br/>Eclectic Rubbish Lister,&quot; which is, along with PERL, one of the<br/>unofficial names.<br/><br/>(be nice, Ron! https://wp.colliertech.org/cj/?p=1069#lyrics)<br/><br/>&gt; &gt;I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since <br/>&gt; &gt;my Ubuntu console, but I have some issues with the map {$_-&gt;name} <br/>&gt; &gt;$stmt-&gt;column_defs() method for parsing it.<br/>&gt; <br/>&gt; &gt;Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on <br/>&gt; &gt;unbless object.<br/>&gt; <br/>&gt; We need to see the code. Post the shortest possible sample code which <br/>&gt; produces this error.<br/><br/>remember that the map operator iterates over the list in the second<br/>argument executing the code in the first argument for each element of<br/>the list. $_ is set to the value currently being iterated.<br/><br/>This means that you expect $stmt-&gt;column_defs() to return a list of<br/>objects which have the method &#39;name&#39; defined in their package. <br/><br/>I don&#39;t see the example code you&#39;ve given in the perldoc for<br/>SQL::Statement. Can you tell us where you got it and what you&#39;re trying<br/>to do?<br/><br/>&gt; Are you connecting to a real, pre-existing database with pre-existing <br/>&gt; tables?<br/>&gt; <br/>&gt; If so, how /exactly/ are you doing that?<br/><br/>Yes, can you confirm that you&#39;ve got a valid database handle and that<br/>you can issue queries against it?<br/><br/>&gt; &gt;I will appreciate too much, any information about this error that was <br/>&gt; &gt;taken from CPAN documentation of this module.<br/><br/>URL please?<br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37003.html Thu, 11 Sep 2014 00:19:08 +0000 Re: SQL:Statement/Parser by Ron Savage Hi Mauricio<br/><br/> &gt;Good morning!<br/><br/> &gt;I&#39;m a Mexican PERL fan, and I write first for congratulate you for <br/> &gt;this great job.<br/><br/>Glad to hear you&#39;re using Perl.<br/><br/>And yes, it&#39;s Perl, not PERL.<br/><br/> &gt;I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since <br/> &gt;my Ubuntu console, but I have some issues with the map {$_-&gt;name} <br/> &gt;$stmt-&gt;column_defs() method for parsing it.<br/><br/> &gt;Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on <br/> &gt;unbless object.<br/><br/>We need to see the code. Post the shortest possible sample code which <br/>produces this error.<br/><br/>Are you connecting to a real, pre-existing database with pre-existing <br/>tables?<br/><br/>If so, how /exactly/ are you doing that?<br/><br/> &gt;I will appreciate too much, any information about this error that was <br/> &gt;taken from CPAN documentation of this module.<br/><br/>-- <br/>Ron Savage - savage.net.au<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37002.html Wed, 10 Sep 2014 22:18:55 +0000 Fwd: SQL:Statement/Parser by Jens Rehsack <br/><br/>Anfang der weitergeleiteten Nachricht:<br/><br/>&gt; Von: Mauricio Begovich &lt;mauricio.begovich@gmail.com&gt;<br/>&gt; Betreff: SQL:Statement/Parser<br/>&gt; Datum: 10. September 2014 15:44:55 MESZ<br/>&gt; An: rehsack@cpan.org<br/>&gt; <br/>&gt; Good morning!<br/>&gt; <br/>&gt; I&#39;m a Mexican PERL fan, and I write first for congratulate you for this great job.<br/>&gt; <br/>&gt; I&#39;ve just download the SQL:Statement from CPAN via MCPAN shell since my Ubuntu console, but I have some issues with the map {$_-&gt;name} $stmt-&gt;column_defs() method for parsing it.<br/>&gt; <br/>&gt; Indeed {$_-&gt;name} returns an error saying that name can&#39;t be found on unbless object.<br/>&gt; <br/>&gt; I will appreciate too much, any information about this error that was taken from CPAN documentation of this module.<br/><br/>-- <br/>Jens Rehsack<br/>rehsack@gmail.com<br/><br/><br/><br/><br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/09/msg37001.html Wed, 10 Sep 2014 14:40:00 +0000 DBD::Pg 3.4.0 released by Greg Sabino Mullane <br/>-----BEGIN PGP SIGNED MESSAGE-----<br/>Hash: RIPEMD160<br/><br/>Version 3.4.0 of DBD::Pg, the Perl interface to Postgres, <br/>was released on August 16, 2014. The primary changes in this <br/>version are improvements in the table_info() and column_info() <br/>methods: see below for details. As always, you can download <br/>a tarball from CPAN:<br/><br/>http://search.cpan.org/dist/DBD-Pg/<br/><br/>Checksums for version 3.4.0 of DBD::Pg<br/><br/>e1fbe2ac4bd4951f1726a36b315c263c DBD-Pg-3.4.0.tar.gz<br/>611cda7b4eefcc437991eebb4a1561a112554c18 DBD-Pg-3.4.0.tar.gz<br/><br/>The mailing list welcomes any and all questions:<br/><br/>http://www.nntp.perl.org/group/perl.dbd.pg/<br/><br/>Development can be tracked via git:<br/><br/>git://bucardo.org/dbdpg.git<br/><br/>Complete list of changes in 3.4.0:<br/><br/>(git commit 7a5da12d84b4c2e9879f90fb6168f56c095071fa)<br/><br/> - Cleanup and improve table_info()<br/> [Mike Pomraning &lt;mjp@pilcrow.madison.wi.us&gt;] (github issue #7)<br/><br/> table_info() type searching now supports TABLE, VIEW, SYSTEM TABLE,<br/> SYSTEM VIEW, and LOCAL TEMPORARY<br/><br/> table_info() object searching fully supports the above types.<br/><br/> table_info() object searching no longer ignores invalid types - a filter <br/> of &#39;NOSUCH&#39; will return no rows, and &#39;NOSUCH,LOCAL TEMPORARY&#39; will<br/> return only temp objects.<br/><br/> tableinfo() type filters are strictly matched now ... previously a <br/> search for SYSTEM TABLE would have fetched plain TABLE objects.<br/><br/> table_info() now treats temporary tables and temporary views as LOCAL TEMPORARY<br/><br/> - Make sure column_info() and table_info() can handle materialized views.<br/> [Greg Sabino Mullane] (CPAN bug #97032)<br/><br/><br/>- -- <br/>Greg Sabino Mullane greg@turnstep.com<br/>PGP Key: 0x14964AC8 201408181051<br/>http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8<br/>-----BEGIN PGP SIGNATURE-----<br/><br/>iEYEAREDAAYFAlPyEwYACgkQvJuQZxSWSsgBBQCgrYkYnb9Sgv4G5yQJYNQqIOfj<br/>VhkAn2bxny/zVJBOFvOJ/w/AtajXgO52<br/>=70S2<br/>-----END PGP SIGNATURE-----<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg37000.html Mon, 18 Aug 2014 14:54:43 +0000 Re: Informinx Perl Module Installation Issues by Jonathan Leffler Hi Sagar,<br/><br/>I&#39;ve tried to get hold of RHEL Tikanga, but it is pretty old (much older<br/>than the version of Perl you are using) and not available for a<br/>sufficiently nominal fee that I can afford to get it just to sort out your<br/>problem.<br/><br/>Please provide the information requested in the Notes/bug.reports file &mdash;<br/>most notably the output of &#39;perl -V&#39; (capital V), which gives information<br/>about the compilation flags used to create Perl, and whether it is<br/>threaded, etc. With that information, I will then try to create a version<br/>of Perl analogous to yours, and then install DBI and DBD::Informix. I&#39;ll<br/>be using Ubuntu 14.04 (in a VM), at least in the first instance. But I had<br/>no problems with the system provided Perl 5.18.2 (compiled with threading).<br/><br/>&#39;perl -V&#39; output for Ubuntu 14.04:<br/><br/>Summary of my perl5 (revision 5 version 18 subversion 2) configuration:<br/><br/> Platform:<br/> osname=linux, osvers=3.2.0-58-generic,<br/>archname=x86_64-linux-gnu-thread-multi<br/> uname=&#39;linux brownie 3.2.0-58-generic #88-ubuntu smp tue dec 3 17:37:58<br/>utc 2013 x86_64 x86_64 x86_64 gnulinux &#39;<br/> config_args=&#39;-Dusethreads -Duselargefiles -Dccflags=-DDEBIAN<br/>-D_FORTIFY_SOURCE=2 -g -O2 -fstack-protector --param=ssp-buffer-size=4<br/>-Wformat -Werror=format-security -Dldflags= -Wl,-Bsymbolic-functions<br/>-Wl,-z,relro -Dlddlflags=-shared -Wl,-Bsymbolic-functions -Wl,-z,relro<br/>-Dcccdlflags=-fPIC -Darchname=x86_64-linux-gnu -Dprefix=/usr<br/>-Dprivlib=/usr/share/perl/5.18 -Darchlib=/usr/lib/perl/5.18<br/>-Dvendorprefix=/usr -Dvendorlib=/usr/share/perl5<br/>-Dvendorarch=/usr/lib/perl5 -Dsiteprefix=/usr/local<br/>-Dsitelib=/usr/local/share/perl/5.18.2<br/>-Dsitearch=/usr/local/lib/perl/5.18.2 -Dman1dir=/usr/share/man/man1<br/>-Dman3dir=/usr/share/man/man3 -Dsiteman1dir=/usr/local/man/man1<br/>-Dsiteman3dir=/usr/local/man/man3 -Duse64bitint -Dman1ext=1 -Dman3ext=3perl<br/>-Dpager=/usr/bin/sensible-pager -Uafs -Ud_csh -Ud_ualarm -Uusesfio -Uusenm<br/>-Ui_libutil -Uversiononly -DDEBUGGING=-g -Doptimize=-O2 -Duseshrplib<br/>-Dlibperl=libperl.so.5.18.2 -des&#39;<br/> hint=recommended, useposix=true, d_sigaction=define<br/> useithreads=define, usemultiplicity=define<br/> useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef<br/> use64bitint=define, use64bitall=define, uselongdouble=undef<br/> usemymalloc=n, bincompat5005=undef<br/> Compiler:<br/> cc=&#39;cc&#39;, ccflags =&#39;-D_REENTRANT -D_GNU_SOURCE -DDEBIAN<br/>-fstack-protector -fno-strict-aliasing -pipe -I/usr/local/include<br/>-D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64&#39;,<br/> optimize=&#39;-O2 -g&#39;,<br/> cppflags=&#39;-D_REENTRANT -D_GNU_SOURCE -DDEBIAN -fstack-protector<br/>-fno-strict-aliasing -pipe -I/usr/local/include&#39;<br/> ccversion=&#39;&#39;, gccversion=&#39;4.8.2&#39;, gccosandvers=&#39;&#39;<br/> intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678<br/> d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16<br/> ivtype=&#39;long&#39;, ivsize=8, nvtype=&#39;double&#39;, nvsize=8, Off_t=&#39;off_t&#39;,<br/>lseeksize=8<br/> alignbytes=8, prototype=define<br/> Linker and Libraries:<br/> ld=&#39;cc&#39;, ldflags =&#39; -fstack-protector -L/usr/local/lib&#39;<br/> libpth=/usr/local/lib /lib/x86_64-linux-gnu /lib/../lib<br/>/usr/lib/x86_64-linux-gnu /usr/lib/../lib /lib /usr/lib<br/> libs=-lgdbm -lgdbm_compat -ldb -ldl -lm -lpthread -lc -lcrypt<br/> perllibs=-ldl -lm -lpthread -lc -lcrypt<br/> libc=, so=so, useshrplib=true, libperl=libperl.so.5.18.2<br/> gnulibc_version=&#39;2.19&#39;<br/> Dynamic Linking:<br/> dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=&#39;-Wl,-E&#39;<br/> cccdlflags=&#39;-fPIC&#39;, lddlflags=&#39;-shared -L/usr/local/lib<br/>-fstack-protector&#39;<br/><br/><br/>Characteristics of this binary (from libperl):<br/> Compile-time options: HAS_TIMES MULTIPLICITY PERLIO_LAYERS<br/> PERL_DONT_CREATE_GVSV<br/> PERL_HASH_FUNC_ONE_AT_A_TIME_HARD<br/> PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP<br/> PERL_PRESERVE_IVUV PERL_SAWAMPERSAND USE_64_BIT_ALL<br/> USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES<br/> USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE<br/> USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF<br/> USE_REENTRANT_API<br/> Locally applied patches:<br/> DEBPKG:debian/cpan_definstalldirs - Provide a sensible INSTALLDIRS<br/>default for modules installed from CPAN.<br/> DEBPKG:debian/db_file_ver - http://bugs.debian.org/340047 Remove overly<br/>restrictive DB_File version check.<br/> DEBPKG:debian/doc_info - Replace generic man(1) instructions with<br/>Debian-specific information.<br/> DEBPKG:debian/enc2xs_inc - http://bugs.debian.org/290336 Tweak enc2xs<br/>to follow symlinks and ignore missing @INC directories.<br/> DEBPKG:debian/errno_ver - http://bugs.debian.org/343351 Remove Errno<br/>version check due to upgrade problems with long-running processes.<br/> DEBPKG:debian/libperl_embed_doc - http://bugs.debian.org/186778 Note<br/>that libperl-dev package is required for embedded linking<br/> DEBPKG:fixes/respect_umask - Respect umask during installation<br/> DEBPKG:debian/writable_site_dirs - Set umask approproately for site<br/>install directories<br/> DEBPKG:debian/extutils_set_libperl_path - EU:MM: Set location of<br/>libperl.a to /usr/lib<br/> DEBPKG:debian/no_packlist_perllocal - Don&#39;t install .packlist or<br/>perllocal.pod for perl or vendor<br/> DEBPKG:debian/prefix_changes - Fiddle with *PREFIX and variables<br/>written to the makefile<br/> DEBPKG:debian/fakeroot - Postpone LD_LIBRARY_PATH evaluation to the<br/>binary targets.<br/> DEBPKG:debian/instmodsh_doc - Debian policy doesn&#39;t install .packlist<br/>files for core or vendor.<br/> DEBPKG:debian/ld_run_path - Remove standard libs from LD_RUN_PATH as<br/>per Debian policy.<br/> DEBPKG:debian/libnet_config_path - Set location of libnet.cfg to<br/>/etc/perl/Net as /usr may not be writable.<br/> DEBPKG:debian/mod_paths - Tweak @INC ordering for Debian<br/> DEBPKG:debian/module_build_man_extensions -<br/>http://bugs.debian.org/479460 Adjust Module::Build manual page extensions<br/>for the Debian Perl policy<br/> DEBPKG:debian/prune_libs - http://bugs.debian.org/128355 Prune the list<br/>of libraries wanted to what we actually need.<br/> DEBPKG:fixes/net_smtp_docs - [rt.cpan.org #36038]<br/>http://bugs.debian.org/100195 Document the Net::SMTP &#39;Port&#39; option<br/> DEBPKG:debian/perlivp - http://bugs.debian.org/510895 Make perlivp skip<br/>include directories in /usr/local<br/> DEBPKG:debian/cpanplus_definstalldirs - http://bugs.debian.org/533707<br/>Configure CPANPLUS to use the site directories by default.<br/> DEBPKG:debian/cpanplus_config_path - Save local versions of<br/>CPANPLUS::Config::System into /etc/perl.<br/> DEBPKG:debian/deprecate-with-apt - http://bugs.debian.org/702096 Point<br/>users to Debian packages of deprecated core modules<br/> DEBPKG:debian/squelch-locale-warnings - http://bugs.debian.org/508764<br/>Squelch locale warnings in Debian package maintainer scripts<br/> DEBPKG:debian/skip-upstream-git-tests - Skip tests specific to the<br/>upstream Git repository<br/> DEBPKG:debian/patchlevel - http://bugs.debian.org/567489 List packaged<br/>patches for 5.18.2-2ubuntu1 in patchlevel.h<br/> DEBPKG:debian/skip-kfreebsd-crash - http://bugs.debian.org/628493 [perl<br/>#96272] Skip a crashing test case in t/op/threads.t on GNU/kFreeBSD<br/> DEBPKG:fixes/document_makemaker_ccflags - http://bugs.debian.org/628522<br/>[rt.cpan.org #68613] Document that CCFLAGS should include $Config{ccflags}<br/> DEBPKG:debian/find_html2text - http://bugs.debian.org/640479 Configure<br/>CPAN::Distribution with correct name of html2text<br/> DEBPKG:debian/hurd_test_skip_stack - http://bugs.debian.org/650175<br/>Disable failing GNU/Hurd tests dist/threads/t/stack.t<br/> DEBPKG:fixes/manpage_name_Test-Harness - http://bugs.debian.org/650451 [<br/>rt.cpan.org #73399] cpan/Test-Harness: add NAME headings in modules with POD<br/> DEBPKG:debian/makemaker-pasthru - http://bugs.debian.org/660195 [<br/>rt.cpan.org #28632] Make EU::MM pass LD through to recursive Makefile.PL<br/>invocations<br/> DEBPKG:debian/perl5db-x-terminal-emulator.patch -<br/>http://bugs.debian.org/668490 Invoke x-terminal-emulator rather than xterm<br/>in perl5db.pl<br/> DEBPKG:debian/cpan-missing-site-dirs - http://bugs.debian.org/688842<br/>Fix CPAN::FirstTime defaults with nonexisting site dirs if a parent is<br/>writable<br/> DEBPKG:fixes/memoize_storable_nstore - [rt.cpan.org #77790]<br/>http://bugs.debian.org/587650 Memoize::Storable: respect &#39;nstore&#39; option<br/>not respected<br/> DEBPKG:fixes/net_ftp_failed_command - [rt.cpan.org #37700]<br/>http://bugs.debian.org/491062 Net::FTP: cope gracefully with a failed<br/>command<br/> DEBPKG:fixes/perlbug-patchlist - [3541c11] http://bugs.debian.org/710842<br/>[perl #118433] Make perlbug look up the list of local patches at run time<br/> DEBPKG:fixes/module_metadata_security_doc - [68cdd4b] CVE-2013-1437<br/>documentation fix<br/> DEBPKG:fixes/module_metadata_taint_fix - [bff978f]<br/>http://bugs.debian.org/722210 [rt.cpan.org #88576] untaint version, if<br/>needed, in Module::Metadata<br/> DEBPKG:fixes/IPC-SysV-spelling - http://bugs.debian.org/730558 [<br/>rt.cpan.org #86736] Fix spelling of IPC_CREAT in IPC-SysV documentation<br/> DEBPKG:fixes/fix-undef-source -<br/> Built under linux<br/> Compiled at Mar 27 2014 18:30:28<br/> @INC:<br/> /etc/perl<br/> /usr/local/lib/perl/5.18.2<br/> /usr/local/share/perl/5.18.2<br/> /usr/lib/perl5<br/> /usr/share/perl5<br/> /usr/lib/perl/5.18<br/> /usr/share/perl/5.18<br/> /usr/local/lib/site_perl<br/> .<br/><br/><br/><br/>On Fri, Aug 8, 2014 at 9:21 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/><br/>&gt; Hi Jonathan,<br/>&gt;<br/>&gt; Thanks for the update.<br/>&gt;<br/>&gt; I have run the installation successfully in my lab server and unable to do<br/>&gt; it on production servers.<br/>&gt;<br/>&gt; RHEL version and PERL version on both servers are same. I will give you<br/>&gt; the complete details.<br/>&gt;<br/>&gt; =================<br/>&gt; *Lab Server*<br/>&gt;<br/>&gt; [root@inhusz1-sdcitnm 5.18.2]# cat /etc/redhat-release<br/>&gt; Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/>&gt;<br/>&gt; [root@inhusz1-sdcitnm 5.18.2]# gcc --version<br/>&gt; *gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>&gt; Copyright (C) 2006 Free Software Foundation, Inc.<br/>&gt; This is free software; see the source for copying conditions. There is NO<br/>&gt; warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/>&gt;<br/>&gt; [root@inhusz1-sdcitnm DBD-Informix-2013.0521]# perl -v<br/>&gt;<br/>&gt; *This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/>&gt;<br/>&gt; Copyright 1987-2013, Larry Wall<br/>&gt;<br/>&gt; Perl may be copied only under the terms of either the Artistic License or<br/>&gt; the<br/>&gt; GNU General Public License, which may be found in the Perl 5 source kit.<br/>&gt;<br/>&gt; Complete documentation for Perl, including FAQ lists, should be found on<br/>&gt; this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>&gt; Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/>&gt;<br/>&gt; *Customer Server*<br/>&gt;<br/>&gt; [root@CRPVLX1NETCOOLITNM ~]# cat /etc/redhat-release<br/>&gt; Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/>&gt;<br/>&gt; [root@CRPVLX1NETCOOLITNM ~]# gcc --version<br/>&gt; *gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>&gt; Copyright (C) 2006 Free Software Foundation, Inc.<br/>&gt; This is free software; see the source for copying conditions. There is NO<br/>&gt; warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/>&gt;<br/>&gt; [root@CRPVLX1NETCOOLITNM]# perl -v<br/>&gt;<br/>&gt; *This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/>&gt;<br/>&gt; Copyright 1987-2013, Larry Wall<br/>&gt;<br/>&gt; Perl may be copied only under the terms of either the Artistic License or<br/>&gt; the<br/>&gt; GNU General Public License, which may be found in the Perl 5 source kit.<br/>&gt;<br/>&gt; Complete documentation for Perl, including FAQ lists, should be found on<br/>&gt; this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>&gt; Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/>&gt;<br/>&gt; =================<br/>&gt;<br/>&gt; Could you please let me know what would be the solution to resolve the<br/>&gt; issue.<br/>&gt;<br/>&gt; Thanks,<br/>&gt; Sagar<br/>&gt;<br/>&gt;<br/>&gt; On Fri, Aug 8, 2014 at 6:42 PM, Jonathan Leffler &lt;<br/>&gt; jonathan.leffler@gmail.com&gt; wrote:<br/>&gt;<br/>&gt;&gt; It means there is a mismatch between the code used in compiling<br/>&gt;&gt; DBD::Informix and the code used in compiling Perl. You&#39;ve not given<br/>&gt;&gt; explicit platform information (it seems to be a 64-bit RedHat Linux), nor<br/>&gt;&gt; the version of Perl. This problem occurred semi-regularly&hellip;oh, about ten<br/>&gt;&gt; years ago. It hasn&#39;t often been a problem since. It might be that you&#39;re<br/>&gt;&gt; using a threaded Perl, but it isn&#39;t supposed to be a problem.<br/>&gt;&gt;<br/>&gt;&gt; Please look at the bug reporting instructions in the file<br/>&gt;&gt; Notes/bug.reports and use the script BugReport.<br/>&gt;&gt;<br/>&gt;&gt; It&#39;ll be a couple of days or so before I can look at the problem in any<br/>&gt;&gt; detail.<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; On Thu, Aug 7, 2014 at 11:00 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/>&gt;&gt;<br/>&gt;&gt;&gt; Hi Team,<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; I am facing issues while running make command while installing the<br/>&gt;&gt;&gt; Informix perl module.<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; Here is the error snippet.<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>&gt;&gt;&gt; -L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>&gt;&gt;&gt; -fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>&gt;&gt;&gt; ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>&gt;&gt;&gt; blib/arch/auto/DBD/Informix/Informix.so \<br/>&gt;&gt;&gt; \<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>&gt;&gt;&gt; function `_start&#39;:<br/>&gt;&gt;&gt; (.text+0x20): undefined reference to `main&#39;<br/>&gt;&gt;&gt; Informix.o: In function `dbi_get_state&#39;:<br/>&gt;&gt;&gt; Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt;&gt; Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x116): undefined reference to<br/>&gt;&gt;&gt; `Perl_xs_apiversion_bootcheck&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x139): undefined reference to<br/>&gt;&gt;&gt; `Perl_xs_version_bootcheck&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt;&gt; Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>&gt;&gt;&gt; `Perl_newXS_flags&#39; follow<br/>&gt;&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt;&gt; Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt; Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt;&gt; dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt;&gt; collect2: ld returned 1 exit status<br/>&gt;&gt;&gt; make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; Please let me know what need to do here.<br/>&gt;&gt;&gt;<br/>&gt;&gt;&gt; -Thanks,<br/>&gt;&gt;&gt; Sagar<br/>&gt;&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt; --<br/>&gt;&gt; Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>&gt;&gt; Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&gt;&gt; &quot;Blessed are we who can laugh at ourselves, for we shall never cease to<br/>&gt;&gt; be amused.&quot;<br/>&gt;&gt;<br/>&gt;<br/>&gt;<br/><br/><br/>-- <br/>Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>amused.&quot;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36999.html Thu, 14 Aug 2014 05:22:15 +0000 buffer allocation bug in DBD::mysql leading to failures (was:DBD::mysql mysql_server_prepare=1 caching of statement handles) by Marc Lehmann Hi!<br/><br/>I am not susbcribed to this list - I wanted to add information to a previous<br/>issue reported by Wouter de Geus (e.g. in http://code.activestate.com/lists/perl-dbi-users/36031/)<br/><br/>I ran into what is probably exactly the same problem as him and debugged<br/>it a bit further. I now believe this is simply a bug in the prepared<br/>statement implementation of DBD::mysql.<br/><br/>I&#39;ve directly cc&#39;ed Patrick Galbraith, as it seems rt.cpan.org is a<br/>blackhole for DBD::mysql bug reports nowadays, and this bug effectively<br/>renders prepared statements useless. (Patrick, if DBD::mysql is no longer<br/>maintained by you, do you happen to know by whom it is maintaiend these<br/>days, if anybody?)<br/><br/>Here is a typical trace of a repeated invocation, which matches the trace<br/>provided by Wouter. This works:<br/><br/> -&gt; fetchrow_arrayref for DBD::mysql::st (DBI::st=HASH(0x1f8aa20)~0x1f52d38)<br/> -&gt; dbd_st_fetch<br/> --&gt; dbd_describe<br/> dbd_describe() num_fields 1<br/> i 0 col_type 253 fbh-&gt;length 0<br/> fields[i].length 255 fields[i].max_length 41 fields[i].type 253 fields[i].charsetnr 63<br/> mysql_to_perl_type returned 253<br/> &lt;- dbd_describe<br/> dbd_st_fetch for 01f8aa80, chopblanks 0<br/> dbd_st_fetch calling mysql_fetch<br/><br/>And this fails, due to the MYSQL_DATA_TRUNCATED result:<br/><br/> &gt;&gt; fetchrow_arrayref DISPATCH (DBI::st=HASH(0x1f8aa20) rc1/1 @1 g2 ima0 pid#3097) at Schback/Slave.pm line 395 via at ./schbackd line 81<br/> -&gt; fetchrow_arrayref for DBD::mysql::st (DBI::st=HASH(0x1f8aa20)~0x1f52d38)<br/> -&gt; dbd_st_fetch<br/> dbd_st_fetch for 01f8aa80, chopblanks 0<br/> dbd_st_fetch calling mysql_fetch<br/> dbd_st_fetch data truncated<br/><br/>I found that this happens when I reuse the same statement handle and the<br/>second invocation returns a longer result for a field than the first.<br/><br/>I verified using ltrace -e memcpy that the buffer_length allocated in the<br/>failure case is the 41 from the previous execute, which is too small for<br/>the next one, causing the failure.<br/><br/>Lo and behold, an obvious testcase reproduces the bug:<br/><br/> $dbh = DBI-&gt;connect (&quot;dbi:mysql:test;mysql_read_default_group=client;mysql_server_prepare=1&quot;, &quot;&quot;, &quot;&quot;);<br/><br/> # DBI-&gt;trace (2);<br/><br/> $st = $dbh-&gt;prepare (&quot;select ?&quot;);<br/> $st-&gt;execute (&quot;1234&quot;);<br/> warn $st-&gt;fetchrow_arrayref;<br/><br/> $st-&gt;execute (&quot;123456789&quot;);<br/> warn $st-&gt;fetchrow_arrayref; # fails due to MYSQL_DATA_TRUNCATED<br/><br/>The first execute works, and fetchrow_arrayref returns the result row. The<br/>second execute works as well, but fetchrow_arrayref returns undef. When<br/>enabling tracing, it shows that the second fetch fails because of<br/>MYSQL_DATA_TRUNCATED status.<br/><br/>Clearly, something in DBD::mysql caches maximum buffer sizes between<br/>executes when it shouldn&#39;t.<br/><br/>-- <br/> The choice of a Deliantra, the free code+content MORPG<br/> -----==- _GNU_ http://www.deliantra.net<br/> ----==-- _ generation<br/> ---==---(_)__ __ ____ __ Marc Lehmann<br/> --==---/ / _ \/ // /\ \/ / schmorp@schmorp.de<br/> -=====/_/_//_/\_,_/ /_/\_\<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36998.html Wed, 13 Aug 2014 08:24:03 +0000 Re: Informinx Perl Module Installation Issues by sagar nch Hi Jonathan,<br/><br/>Thanks for the update.<br/><br/>I have run the installation successfully in my lab server and unable to do<br/>it on production servers.<br/><br/>RHEL version and PERL version on both servers are same. I will give you<br/>the complete details.<br/><br/>=================<br/>*Lab Server*<br/><br/>[root@inhusz1-sdcitnm 5.18.2]# cat /etc/redhat-release<br/>Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/><br/>[root@inhusz1-sdcitnm 5.18.2]# gcc --version<br/>*gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>Copyright (C) 2006 Free Software Foundation, Inc.<br/>This is free software; see the source for copying conditions. There is NO<br/>warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/><br/>[root@inhusz1-sdcitnm DBD-Informix-2013.0521]# perl -v<br/><br/>*This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/><br/>Copyright 1987-2013, Larry Wall<br/><br/>Perl may be copied only under the terms of either the Artistic License or<br/>the<br/>GNU General Public License, which may be found in the Perl 5 source kit.<br/><br/>Complete documentation for Perl, including FAQ lists, should be found on<br/>this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/><br/>*Customer Server*<br/><br/>[root@CRPVLX1NETCOOLITNM ~]# cat /etc/redhat-release<br/>Red Hat Enterprise Linux Server release *5.5 (Tikanga)*<br/><br/>[root@CRPVLX1NETCOOLITNM ~]# gcc --version<br/>*gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48)*<br/>Copyright (C) 2006 Free Software Foundation, Inc.<br/>This is free software; see the source for copying conditions. There is NO<br/>warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.<br/><br/>[root@CRPVLX1NETCOOLITNM]# perl -v<br/><br/>*This is perl 5, version 18, subversion 2 (v5.18.2) built for x86_64-linux*<br/><br/>Copyright 1987-2013, Larry Wall<br/><br/>Perl may be copied only under the terms of either the Artistic License or<br/>the<br/>GNU General Public License, which may be found in the Perl 5 source kit.<br/><br/>Complete documentation for Perl, including FAQ lists, should be found on<br/>this system using &quot;man perl&quot; or &quot;perldoc perl&quot;. If you have access to the<br/>Internet, point your browser at http://www.perl.org/, the Perl Home Page.<br/><br/>=================<br/><br/>Could you please let me know what would be the solution to resolve the<br/>issue.<br/><br/>Thanks,<br/>Sagar<br/><br/>On Fri, Aug 8, 2014 at 6:42 PM, Jonathan Leffler &lt;jonathan.leffler@gmail.com<br/>&gt; wrote:<br/><br/>&gt; It means there is a mismatch between the code used in compiling<br/>&gt; DBD::Informix and the code used in compiling Perl. You&#39;ve not given<br/>&gt; explicit platform information (it seems to be a 64-bit RedHat Linux), nor<br/>&gt; the version of Perl. This problem occurred semi-regularly&hellip;oh, about ten<br/>&gt; years ago. It hasn&#39;t often been a problem since. It might be that you&#39;re<br/>&gt; using a threaded Perl, but it isn&#39;t supposed to be a problem.<br/>&gt;<br/>&gt; Please look at the bug reporting instructions in the file<br/>&gt; Notes/bug.reports and use the script BugReport.<br/>&gt;<br/>&gt; It&#39;ll be a couple of days or so before I can look at the problem in any<br/>&gt; detail.<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; On Thu, Aug 7, 2014 at 11:00 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/>&gt;<br/>&gt;&gt; Hi Team,<br/>&gt;&gt;<br/>&gt;&gt; I am facing issues while running make command while installing the<br/>&gt;&gt; Informix perl module.<br/>&gt;&gt;<br/>&gt;&gt; Here is the error snippet.<br/>&gt;&gt;<br/>&gt;&gt; INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>&gt;&gt; -L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>&gt;&gt; -fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>&gt;&gt; ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>&gt;&gt; blib/arch/auto/DBD/Informix/Informix.so \<br/>&gt;&gt; \<br/>&gt;&gt;<br/>&gt;&gt; /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>&gt;&gt; function `_start&#39;:<br/>&gt;&gt; (.text+0x20): undefined reference to `main&#39;<br/>&gt;&gt; Informix.o: In function `dbi_get_state&#39;:<br/>&gt;&gt; Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>&gt;&gt; Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt; Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; Informix.c:(.text+0x116): undefined reference to<br/>&gt;&gt; `Perl_xs_apiversion_bootcheck&#39;<br/>&gt;&gt; Informix.c:(.text+0x139): undefined reference to<br/>&gt;&gt; `Perl_xs_version_bootcheck&#39;<br/>&gt;&gt; Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>&gt;&gt; Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>&gt;&gt; `Perl_newXS_flags&#39; follow<br/>&gt;&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt;&gt; Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt; Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/>&gt;&gt;<br/>&gt;&gt; bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>&gt;&gt; dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>&gt;&gt; dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt;&gt; collect2: ld returned 1 exit status<br/>&gt;&gt; make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/>&gt;&gt;<br/>&gt;&gt; Please let me know what need to do here.<br/>&gt;&gt;<br/>&gt;&gt; -Thanks,<br/>&gt;&gt; Sagar<br/>&gt;&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; --<br/>&gt; Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>&gt; Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&gt; &quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>&gt; amused.&quot;<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36997.html Sat, 09 Aug 2014 05:42:21 +0000 Re: Informinx Perl Module Installation Issues by Jonathan Leffler It means there is a mismatch between the code used in compiling<br/>DBD::Informix and the code used in compiling Perl. You&#39;ve not given<br/>explicit platform information (it seems to be a 64-bit RedHat Linux), nor<br/>the version of Perl. This problem occurred semi-regularly&hellip;oh, about ten<br/>years ago. It hasn&#39;t often been a problem since. It might be that you&#39;re<br/>using a threaded Perl, but it isn&#39;t supposed to be a problem.<br/><br/>Please look at the bug reporting instructions in the file Notes/bug.reports<br/>and use the script BugReport.<br/><br/>It&#39;ll be a couple of days or so before I can look at the problem in any<br/>detail.<br/><br/><br/><br/>On Thu, Aug 7, 2014 at 11:00 AM, sagar nch &lt;sagarnch@gmail.com&gt; wrote:<br/><br/>&gt; Hi Team,<br/>&gt;<br/>&gt; I am facing issues while running make command while installing the<br/>&gt; Informix perl module.<br/>&gt;<br/>&gt; Here is the error snippet.<br/>&gt;<br/>&gt; INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>&gt; -L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>&gt; -fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>&gt; ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>&gt; blib/arch/auto/DBD/Informix/Informix.so \<br/>&gt; \<br/>&gt;<br/>&gt; /usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>&gt; function `_start&#39;:<br/>&gt; (.text+0x20): undefined reference to `main&#39;<br/>&gt; Informix.o: In function `dbi_get_state&#39;:<br/>&gt; Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>&gt; Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>&gt; Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>&gt; Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt; Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>&gt; Informix.c:(.text+0x116): undefined reference to<br/>&gt; `Perl_xs_apiversion_bootcheck&#39;<br/>&gt; Informix.c:(.text+0x139): undefined reference to<br/>&gt; `Perl_xs_version_bootcheck&#39;<br/>&gt; Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>&gt; Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>&gt; `Perl_newXS_flags&#39; follow<br/>&gt; Informix.o: In function `boot_DBD__Informix&#39;:<br/>&gt; Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>&gt; Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/>&gt;<br/>&gt; bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>&gt; dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>&gt; dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>&gt; dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>&gt; collect2: ld returned 1 exit status<br/>&gt; make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/>&gt;<br/>&gt; Please let me know what need to do here.<br/>&gt;<br/>&gt; -Thanks,<br/>&gt; Sagar<br/>&gt;<br/><br/><br/><br/>-- <br/>Jonathan Leffler &lt;jonathan.leffler@gmail.com&gt; #include &lt;disclaimer.h&gt;<br/>Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&quot;Blessed are we who can laugh at ourselves, for we shall never cease to be<br/>amused.&quot;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36996.html Fri, 08 Aug 2014 13:13:10 +0000 Informinx Perl Module Installation Issues by sagar nch Hi Team,<br/><br/>I am facing issues while running make command while installing the Informix<br/>perl module.<br/><br/>Here is the error snippet.<br/><br/>INFORMIXC=&#39;/usr/local/bin/perl esqlld&#39; ESQLLD=&#39;cc -shared -O2<br/>-L/usr/local/lib -fstack-protector&#39; esql -shared -O2 -L/usr/local/lib<br/>-fstack-protector Informix.o dbdimp.o dbdattr.o sqltoken.o sqltype.o<br/>ixblob.o odbctype.o kludge.o link.o esqlcver.o esqlc_v6.o -o<br/>blib/arch/auto/DBD/Informix/Informix.so \<br/> \<br/><br/>/usr/lib/gcc/x86_64-redhat-linux/4.1.2/../../../../lib64/crt1.o: In<br/>function `_start&#39;:<br/>(.text+0x20): undefined reference to `main&#39;<br/>Informix.o: In function `dbi_get_state&#39;:<br/>Informix.c:(.text+0x1b): undefined reference to `PL_thr_key&#39;<br/>Informix.c:(.text+0x48): undefined reference to `PL_thr_key&#39;<br/>Informix.c:(.text+0x61): undefined reference to `Perl_get_cv&#39;<br/>Informix.c:(.text+0x82): undefined reference to `Perl_croak_nocontext&#39;<br/>Informix.o: In function `boot_DBD__Informix&#39;:<br/>Informix.c:(.text+0x9f): undefined reference to `PL_thr_key&#39;<br/>Informix.c:(.text+0x116): undefined reference to<br/>`Perl_xs_apiversion_bootcheck&#39;<br/>Informix.c:(.text+0x139): undefined reference to `Perl_xs_version_bootcheck&#39;<br/>Informix.c:(.text+0x168): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x1a1): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x1da): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x213): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.c:(.text+0x24c): undefined reference to `Perl_newXS_flags&#39;<br/>Informix.o:Informix.c:(.text+0x285): more undefined references to<br/>`Perl_newXS_flags&#39; follow<br/>Informix.o: In function `boot_DBD__Informix&#39;:<br/>Informix.c:(.text+0x87e): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x8a3): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x8d2): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x901): undefined reference to `Perl_newXS&#39;<br/>Informix.c:(.text+0x926): undefined reference to `Perl_newXS&#39;<br/><br/>bdattr.o: In function `dbd_ix_db_STORE_attrib&#39;:<br/>dbdattr.c:(.text+0x190b): undefined reference to `Perl_sv_2pv_flags&#39;<br/>dbdattr.c:(.text+0x1a33): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1a4a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1ad1): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1ae5): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1cc8): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1cdf): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1d49): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1d60): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1dd6): undefined reference to `Perl_croak_nocontext&#39;<br/>dbdattr.c:(.text+0x1e23): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1e3a): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1e92): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1ea6): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1eba): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1ece): undefined reference to `Perl_sv_2bool_flags&#39;<br/>dbdattr.c:(.text+0x1eff): undefined reference to `PL_thr_key&#39;<br/>dbdattr.c:(.text+0x1f13): undefined reference to `Perl_sv_2bool_flags&#39;<br/>collect2: ld returned 1 exit status<br/>make: *** [blib/arch/auto/DBD/Informix/Informix.so] Error 1<br/><br/>Please let me know what need to do here.<br/><br/>-Thanks,<br/>Sagar<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36995.html Fri, 08 Aug 2014 07:45:48 +0000 Re: DBD::mysql 4.028 released by Paul DuBois <br/>On Aug 2, 2014, at 10:15 PM, Patrick Galbraith wrote:<br/><br/>&gt; Dear Pert and MySQL community,<br/>&gt; <br/>&gt; I&rdquo;m pleased to announce the release of DBD::mysql 4.028. This release includes several fixes, per change log:<br/>&gt; <br/>&gt; * Fixed bug in mysql.xs where dbh was being used as error code<br/><br/>Thanks. I was seeing a mysterious error that a failure of connect() was returning the object rather than undef. It&#39;s now gone after upgrading.<br/><br/>&gt; * RT #97570: fix wrong salloc free in mysql_st_internal_execute - (Reini Urban, cPanel)<br/>&gt; * Fix RT #97625 use-after-free in mysql_dr_error, and #86153 - (Reini Urban, cPanel)<br/>&gt; * find mysql.h for MariaDB on Win32 (Graham Ollis)<br/>&gt; * Update mysql.pm to work with ipv6 and ipv4 addresses (katyavoid)<br/>&gt; <br/>&gt; I want to thank Reini Urban, Graham Ollis, and Katyavoid for their pull requests and contributions to DBD::mysql!<br/>&gt; <br/>&gt; Please feel free to visit:<br/>&gt; <br/>&gt; http://search.cpan.org/~capttofu/DBD-mysql-4.028/<br/>&gt; <br/>&gt; And as always:<br/>&gt; <br/>&gt; https://github.com/perl5-dbi/DBD-mysql.git<br/>&gt; <br/>&gt; Regards,<br/>&gt; <br/>&gt; Patrick Galbraith<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36994.html Sun, 03 Aug 2014 19:53:43 +0000 Re: DBD::mysql 4.028 released by Patrick Galbraith <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36993.html Sun, 03 Aug 2014 03:18:54 +0000 DBD::mysql 4.028 released by Patrick Galbraith <br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/08/msg36992.html Sun, 03 Aug 2014 03:15:27 +0000 RE: Bad error message by Meir Guttman <br/><br/>&gt; -----Original Message-----<br/>&gt; From: Peter J. Holzer [mailto:hjp@wsr.ac.at]<br/>&gt; Sent: &#x5D9;&#x5D5;&#x5DD;&nbsp;&#x5D2; 29 &#x5D9;&#x5D5;&#x5DC;&#x5D9; 2014 11:23<br/>&gt; To: Stuart Cooper<br/>&gt; Cc: Meir Guttman; dbi-users@perl.org<br/>&gt; Subject: Re: Bad error message<br/>&gt; <br/><br/> ------<br/><br/>&gt; <br/>&gt; However, not all RDBMSs support proper prepared statements and bind<br/>&gt; values, and even for those that do, the driver may not use them<br/>&gt; (DBD::mysql only uses them if mysql_server_prepare is set). <br/><br/>Dear, dear Peter,<br/><br/>Thank you very much for the tip!<br/><br/>Indeed, acting on your tip and adding &quot;mysql_server_prepare =&gt; 1,&quot; to my<br/>%conn_attrs hash indeed caught the missing back-tick error right away!<br/><br/>(Your reaction to my post will no doubt be RTFM! And you will be right... :(<br/>)<br/><br/>MeirG<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36991.html Tue, 29 Jul 2014 08:48:24 +0000 Re: Bad error message by Peter J. Holzer On 2014-07-27 23:07:02 +1000, Stuart Cooper wrote:<br/>&gt; Because of your missing a backquote you effectively got an SQL statement<br/>&gt; with 0 bind variables.<br/><br/>Yes, however:<br/><br/>[...]<br/>&gt; On Sun, Jul 27, 2014 at 7:44 PM, Meir Guttman &lt;meir@guttman.co.il&gt; wrote:<br/>[...]<br/>&gt; my $sql = qq(<br/>&gt; &nbsp; REPLACE INTO `test.`params`<br/>&gt; &nbsp; -- missing &nbsp; &nbsp; &nbsp; &nbsp;^<br/>&gt; &nbsp; -- back-tick &nbsp; &nbsp; &nbsp;|<br/>&gt; &nbsp; -- here ----------+<br/>&gt; &nbsp; (`ID`,`AsOf_date`,`Value`) VALUES<br/>&gt; &nbsp; (?,?,?)<br/>&gt; &nbsp; );<br/>&gt; <br/>&gt; my $sth = $dbh-&gt;prepare($sql) // die &quot;&#39;prepare&#39; error:\n$DBI::errstr&quot;;<br/><br/>One would naively expect that prepare would notice the syntax error and<br/>return an error here, instead of returning a valid statement handle with<br/>0 placeholders.<br/><br/>&gt; my $affected = $sth-&gt;execute(&#39;0123&#39;, &#39;2014-06-24&#39;, 1000) // die &quot;&#39;execute&#39;<br/>&gt; error:\n$DBI::errstr&quot;;<br/><br/>So this would never be reached. <br/><br/>However, not all RDBMSs support proper prepared statements and bind<br/>values, and even for those that do, the driver may not use them<br/>(DBD::mysql only uses them if mysql_server_prepare is set). If they<br/>aren&#39;t used they must be simulated by inserting properly quoted strings<br/>into the statement and the database will only see the final, composed<br/>statement. So it&#39;s possible that the wrong number of parameters is<br/>noticed before a syntax error.<br/><br/>I still think this is a bug: The backquotes are obviously considered<br/>while scanning for placeholders, so the fact that they are mismatched<br/>should be noticed.<br/><br/> hp<br/><br/><br/>-- <br/> _ | Peter J. Holzer | I think we need two definitions:<br/>|_|_) | WSR - Softwaredevelopment | 1) The problem the *users* want us to solve<br/>| | | und Projektunterst&uuml;tzung | 2) The problem our solution addresses.<br/>__/ | hjp@wsr.ac.at | -- Phillip Hallam-Baker on spam<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36990.html Tue, 29 Jul 2014 08:23:25 +0000 Re: Bad error message by Stuart Cooper Hi Meir,<br/><br/>Remember that the process of changing the ? placeholders to actual variables<br/>is called &quot;binding&quot;.. and that can go wrong if for example you have 4 ?<br/>placeholders<br/>and provide 3 values or you have 0 ? and provide 3 values.<br/><br/>Because of your missing a backquote you effectively got an SQL statement<br/>with 0 bind variables. The first time perl::DBI was able to figure that out<br/>was the mismatch of what it thought were 0 ? placeholders with 3 you<br/>provided.<br/><br/>Look into some better text editors.. the best ones will colour-highlight<br/>your strings<br/>and it&#39;ll be easier to find when you make an omission like yours. I&#39;ve never<br/>liked the `test`.`params` strict way of MySQL table naming.. you already<br/>know you&#39;re using the `test` database so let&#39;s just call the table &#39;params&#39;.<br/>Also the qq() is a bit of overkill, let&#39;s just write is as a single perl<br/>string,<br/>and I&#39;ll use normal single quotes around the field names and table name<br/>params.<br/><br/>my $sql=&quot; REPLACE INTO &#39;params&#39;<br/> (&#39;ID&#39;,&#39;AsOf_date&#39;,&#39;Value&#39;) VALUES<br/> (?,?,?)<br/>&quot;;<br/><br/>You will need more complex qq() operators sometimes, but for your task<br/>I find the simpler string much preferable.<br/><br/>Some MySQL utilities like mysqldump will write table names as<br/>`test`.`params`<br/>but that&#39;s to cater for silly tablenames with spaces in them or unicode or<br/>stuff<br/>and you know that&#39;s not the case with your data, so go with the simpler<br/>form.<br/><br/>Hope this helps,<br/>Stuart.<br/><br/><br/><br/>On Sun, Jul 27, 2014 at 7:44 PM, Meir Guttman &lt;meir@guttman.co.il&gt; wrote:<br/><br/>&gt; Dear DBI folks,<br/>&gt;<br/>&gt; The other day I had a trivial typo in my DBI SQL query that gave me an<br/>&gt; outlandish error message and grief. So outlandish that I spent two hours<br/>&gt; looking for the culprit.<br/>&gt;<br/>&gt; All it was is a missing closing back-tic in the db name part of the<br/>&gt; `database_name`.`table_name` SQL clause, see the code.<br/>&gt;<br/>&gt; Here is the test program:<br/>&gt;<br/>&gt; &lt;code&gt;<br/>&gt; use strict;<br/>&gt; use warnings;<br/>&gt; use utf8;<br/>&gt; use DBI;<br/>&gt;<br/>&gt; my %conn_attrs = (<br/>&gt; RaiseError =&gt; 0,<br/>&gt; PrintError =&gt; 0,<br/>&gt; AutoCommit =&gt; 1,<br/>&gt; mysql_enable_utf8 =&gt; 1,<br/>&gt; );<br/>&gt;<br/>&gt; my $dbh = DBI-&gt;connect (<br/>&gt; &#39;DBI:mysql:test:localhost&#39;,<br/>&gt; &#39;my_account&#39;,<br/>&gt; &#39;secret&#39;,<br/>&gt; \%conn_attrs<br/>&gt; );<br/>&gt;<br/>&gt; my $sql = qq(<br/>&gt; REPLACE INTO `test.`params`<br/>&gt; -- missing ^<br/>&gt; -- back-tick |<br/>&gt; -- here ----------+<br/>&gt; (`ID`,`AsOf_date`,`Value`) VALUES<br/>&gt; (?,?,?)<br/>&gt; );<br/>&gt;<br/>&gt; my $sth = $dbh-&gt;prepare($sql) // die &quot;&#39;prepare&#39; error:\n$DBI::errstr&quot;;<br/>&gt; my $affected = $sth-&gt;execute(&#39;0123&#39;, &#39;2014-06-24&#39;, 1000) // die &quot;&#39;execute&#39;<br/>&gt; error:\n$DBI::errstr&quot;;<br/>&gt; $affected += 0;<br/>&gt; print &quot;$affected row was inserted&quot;;<br/>&gt; __END__<br/>&gt; &lt;/code&gt;<br/>&gt;<br/>&gt;<br/>&gt; This resulted with the following error message:<br/>&gt;<br/>&gt; &#39;execute&#39; error:<br/>&gt; called with 3 bind variables when 0 are needed at DBI_error_test.pl line<br/>&gt; 31.<br/>&gt;<br/>&gt; Wherefrom in Scott&#39;s name did you take the idea that &quot;... 0 (bind<br/>&gt; variables)<br/>&gt; are needed...???&quot;<br/>&gt;<br/>&gt; BTW, executing the very same SQL in MySQL WorkBench resulted with a<br/>&gt; straight<br/>&gt; forward &quot;Syntax error ...&quot;<br/>&gt;<br/>&gt; Well, IMHO, MySQL does not, repeat does not, merit any reward for clear and<br/>&gt; meaningful error messages. But this DBI/DBD one might be a winner. Is that<br/>&gt; a<br/>&gt; bug or is there a good reason for that?<br/>&gt;<br/>&gt; And finally Versions:<br/>&gt; ========<br/>&gt; OS: Win 7 (Fully updated)<br/>&gt; Strawberry Perl 5.18.2<br/>&gt; MySQL 5.5.25a<br/>&gt;<br/>&gt; perl module installed latest<br/>&gt; ---------- --------- -------<br/>&gt; DBI 1.6300 1.6310<br/>&gt; DBD::ODBC 1.4700 1.5000<br/>&gt; DBD::mysql 4.0250 4.0270<br/>&gt;<br/>&gt; Regards,<br/>&gt; MeirG<br/>&gt;<br/>&gt;<br/>&gt;<br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36989.html Sun, 27 Jul 2014 13:07:10 +0000 Bad error message by Meir Guttman Dear DBI folks,<br/><br/>The other day I had a trivial typo in my DBI SQL query that gave me an<br/>outlandish error message and grief. So outlandish that I spent two hours<br/>looking for the culprit.<br/><br/>All it was is a missing closing back-tic in the db name part of the<br/>`database_name`.`table_name` SQL clause, see the code.<br/><br/>Here is the test program:<br/><br/>&lt;code&gt;<br/>use strict;<br/>use warnings;<br/>use utf8;<br/>use DBI;<br/><br/>my %conn_attrs = (<br/> RaiseError =&gt; 0,<br/> PrintError =&gt; 0,<br/> AutoCommit =&gt; 1,<br/> mysql_enable_utf8 =&gt; 1,<br/> );<br/><br/>my $dbh = DBI-&gt;connect (<br/> &#39;DBI:mysql:test:localhost&#39;,<br/> &#39;my_account&#39;,<br/> &#39;secret&#39;,<br/> \%conn_attrs<br/>);<br/><br/>my $sql = qq(<br/> REPLACE INTO `test.`params`<br/> -- missing ^<br/> -- back-tick |<br/> -- here ----------+<br/> (`ID`,`AsOf_date`,`Value`) VALUES<br/> (?,?,?)<br/> );<br/><br/>my $sth = $dbh-&gt;prepare($sql) // die &quot;&#39;prepare&#39; error:\n$DBI::errstr&quot;;<br/>my $affected = $sth-&gt;execute(&#39;0123&#39;, &#39;2014-06-24&#39;, 1000) // die &quot;&#39;execute&#39;<br/>error:\n$DBI::errstr&quot;;<br/>$affected += 0;<br/>print &quot;$affected row was inserted&quot;;<br/>__END__<br/>&lt;/code&gt;<br/><br/><br/>This resulted with the following error message:<br/><br/>&#39;execute&#39; error:<br/>called with 3 bind variables when 0 are needed at DBI_error_test.pl line 31.<br/><br/>Wherefrom in Scott&#39;s name did you take the idea that &quot;... 0 (bind variables)<br/>are needed...???&quot;<br/><br/>BTW, executing the very same SQL in MySQL WorkBench resulted with a straight<br/>forward &quot;Syntax error ...&quot;<br/><br/>Well, IMHO, MySQL does not, repeat does not, merit any reward for clear and<br/>meaningful error messages. But this DBI/DBD one might be a winner. Is that a<br/>bug or is there a good reason for that?<br/><br/>And finally Versions:<br/>========<br/>OS: Win 7 (Fully updated)<br/>Strawberry Perl 5.18.2<br/>MySQL 5.5.25a<br/><br/>perl module installed latest<br/>---------- --------- -------<br/>DBI 1.6300 1.6310<br/>DBD::ODBC 1.4700 1.5000<br/>DBD::mysql 4.0250 4.0270<br/><br/>Regards,<br/>MeirG<br/><br/><br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36988.html Sun, 27 Jul 2014 09:44:29 +0000 New 1.50 release of DBD::ODBC by Martin J. Evans I&#39;ve just uploaded DBD::ODBC 1.50 to the CPAN. This is the culmination of a series of 4 development releases in the 1.49 series. There are a number of bug fixes, enhancements, deprecated features and most importantly some changes in behaviour. See below for a list of changes.<br/><br/>1.50 2014-07-25<br/><br/> [BUG FIXES]<br/><br/> The 80_odbc_diags.t test could fail if a driver fails a table does<br/> not exist test in the prepare instead of the execute.<br/><br/>1.49_4 2014-07-08<br/><br/> [BUG FIXES]<br/><br/> Fixed sql_type_cast.t test which assumed column aliases which stay<br/> lowercase.<br/><br/> Fixed 87_odbc_lob_read.t test which did not bow out of the test<br/> properly if the database was not MS SQL Server.<br/><br/> [DOCUMENTATION]<br/><br/> Revised the query notification example and documentation.<br/><br/> Added a link to a better Query Notification article.<br/><br/>1.49_3 2014-05-01<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned years ago, this release removes the odbc_old_unicode attribute.<br/> If you have a good reason to use it speak up now before the next non-development<br/> release.<br/><br/> [BUG FIXES]<br/><br/> Fix rt89255: Fails to create test table for tests using PostgreSQL odbc driver.<br/> Change test suite to fallback on PRECISION if COLUMN_SIZE is not found.<br/><br/> [ENHANCEMENTS]<br/><br/> Added support for MS SQL Server Query Notification. See the new<br/> section in the pod.<br/><br/> Added a currently undocumented (and experimental)<br/> odbc_describe_param method on a statement handle which takes a<br/> parameter number as the only argument and returns an array of the<br/> data type, parameter size, decimal digits and nullable (as per<br/> SQLDescribeParam).<br/><br/> [DOCUMENTATION]<br/><br/> Added FAQ on truncated column names with freeTDS.<br/><br/> [MISCELLANEOUS]<br/><br/> I have removed the &quot;experimental&quot; tag for odbc_getdiagfield and odbc_getdiagrec<br/> methods.<br/><br/>1.49_2 2014-04-26<br/><br/> [BUG FIXES]<br/><br/> Change to data_sources in 1.49_1 could lead to a compile error since<br/> data_sources was not returning a value if an error occurred.<br/><br/>1.49_1 2014-04-25<br/><br/> [BUG FIXES]<br/><br/> If you had a lot of DSNs on Windows (more than 280 but it depends on<br/> the length of their names) and called the data_sources method it<br/> could crash your script. Code internally changed to stop putting the DSNs<br/> returned on the stack.<br/><br/> [CHANGE IN BEHAVIOUR]<br/><br/> As warned years ago, the private data_sources method has been<br/> removed - use DBI one instead.<br/><br/> [MISCELLANEOUS]<br/><br/> Added FAQ entry of maximum number of allowed parameters.<br/><br/>Martin<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36987.html Fri, 25 Jul 2014 12:48:06 +0000 Re: DBD::Informix by Helmut Hi Martin,<br/><br/>i tried both, no change/success..<br/>..also copying the libdl.so to the Informix-Lib-Dir<br/><br/>Helmut<br/><br/>Am 09.07.2014 18:22, schrieb Martin J. Evans:<br/>&gt; On 09/07/14 15:58, Helmut wrote:<br/>&gt;&gt; Hi all,<br/>&gt;&gt;<br/>&gt;&gt; i have problems building DBD::Informix.<br/>&gt;&gt;<br/>&gt;&gt; Running Makefile.pl ends up with<br/>&gt;&gt;<br/>&gt;&gt; ..<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlopen&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/esql/libifos.so: undefined reference to `crypt&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlclose&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlerror&#39;<br/>&gt;&gt; /opt/IBM/informix/lib/libifasf.so: undefined reference to `dlsym&#39;<br/>&gt;&gt; collect2: Fehler: ld gab 1 als Ende-Status zur&uuml;ck<br/>&gt;&gt; Failed to link test program esqltest<br/>&gt;&gt; running on configuration at lib/DBD/Informix/TechSupport.pm line 225.<br/>&gt;&gt;<br/>&gt;&gt; System: ArchLinux x86-64<br/>&gt;&gt; Perl: v5.18.2<br/>&gt;&gt; Informix: clientsdk.4.10.FC4DE.LINUX<br/>&gt;&gt; DBD-Informix-2013.0521<br/>&gt;&gt;<br/>&gt;&gt; The bug report &quot;perl -Ilib BugReport A&quot; is below / attached.<br/>&gt;&gt;<br/>&gt;&gt; What can i do to track the problem down?<br/>&gt;&gt;<br/>&gt;&gt; Thank you<br/>&gt;&gt; Helmut<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;&gt;<br/>&gt;<br/>&gt; I don&#39;t do Informix but all those missing symbols are in dl.so. Try to<br/>&gt; find a way to get the Makefile.PL to add -ldl to the link line. Maybe<br/>&gt; just setting LDFLAGS=-ldl and exporting it before running Makefile.PL<br/>&gt; will do it.<br/>&gt;<br/>&gt; Martin<br/>&gt;<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36986.html Wed, 09 Jul 2014 17:09:30 +0000 Re: DBD::Informix by Helmut libdl (libdl-2.19.so)<br/>and libcrypt (libcrypt-2.19.so)<br/>are in /usr/lib64<br/>which is in turn a link to /usr/lib<br/><br/>Helmut<br/><br/>Am 09.07.2014 18:27, schrieb Jonathan Leffler:<br/>&gt; You may need to get an extra compilation flag, -ldl, added to the link<br/>&gt; line, though it is a little surprising to find that&#39;s necessary. That<br/>&gt; might solve dlopen, dlclose, dlerror, dlsym. Missing crypt is more<br/>&gt; puzzling; maybe there&#39;s a library -lcrypt or something that&#39;s needed. It<br/>&gt; is very odd, though; those are not normally a problem.<br/>&gt;<br/>&gt; The Perl configuration shows -ldl and -lcrypt are used.<br/>&gt;<br/>&gt; The debug output does not show a linking operation, but it is a linking<br/>&gt; operation which is failing, which is very puzzling. I&#39;ll see what I can<br/>&gt; do to reproduce it.<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; On Wed, Jul 9, 2014 at 7:58 AM, Helmut &lt;hz@hzlabs.de<br/>&gt; &lt;mailto:hz@hzlabs.de&gt;&gt; wrote:<br/>&gt;<br/>&gt; Hi all,<br/>&gt;<br/>&gt; i have problems building DBD::Informix.<br/>&gt;<br/>&gt; Running Makefile.pl ends up with<br/>&gt;<br/>&gt; ..<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlopen&#39;<br/>&gt; /opt/IBM/informix/lib/esql/__libifos.so: undefined reference to `crypt&#39;<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlclose&#39;<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlerror&#39;<br/>&gt; /opt/IBM/informix/lib/__libifasf.so: undefined reference to `dlsym&#39;<br/>&gt; collect2: Fehler: ld gab 1 als Ende-Status zur&uuml;ck<br/>&gt; Failed to link test program esqltest<br/>&gt; running on configuration at lib/DBD/Informix/TechSupport.__pm line 225.<br/>&gt;<br/>&gt; System: ArchLinux x86-64<br/>&gt; Perl: v5.18.2<br/>&gt; Informix: clientsdk.4.10.FC4DE.LINUX<br/>&gt; DBD-Informix-2013.0521<br/>&gt;<br/>&gt; The bug report &quot;perl -Ilib BugReport A&quot; is below / attached.<br/>&gt;<br/>&gt; What can i do to track the problem down?<br/>&gt;<br/>&gt; Thank you<br/>&gt; Helmut<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt;<br/>&gt; --<br/>&gt; Jonathan Leffler &lt;jonathan.leffler@gmail.com<br/>&gt; &lt;mailto:jonathan.leffler@gmail.com&gt;&gt; #include &lt;disclaimer.h&gt;<br/>&gt; Guardian of DBD::Informix - v2013.0521 - http://dbi.perl.org<br/>&gt; &quot;Blessed are we who can laugh at ourselves, for we shall never cease to<br/>&gt; be amused.&quot;<br/> http://www.nntp.perl.org/group/perl.dbi.users/2014/07/msg36985.html Wed, 09 Jul 2014 16:42:10 +0000 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