[Fwd: ibm and bugzilla]

David Reid david at REID-IBA.com
Wed Jun 8 20:20:39 UTC 2005


DBI output attached. 


Some men see things as they are and say "why?".  
I dream things that never were and say "why not?". - Robert Kennedy

David Reid
Intelligent Business Automation Inc
phone - 847-891-8520  |  Fax - 630-214-3723
david at reid-iba.com

-----Original Message-----
From: developers-owner at bugzilla.org [mailto:developers-owner at bugzilla.org]
On Behalf Of Benton, Kevin
Sent: Wednesday, June 08, 2005 2:26 PM
To: developers at bugzilla.org
Subject: Re: [Fwd: ibm and bugzilla]

> -----Original Message-----
> From: developers-owner at bugzilla.org
[mailto:developers-owner at bugzilla.org]
> On Behalf Of David Reid
> Sent: Wednesday, June 08, 2005 12:54 PM
> To: 'developers at bugzilla.org'
> Subject: Re: [Fwd: ibm and bugzilla]
> 
> Kevin,
> 
> I re-installed DBD & DBI via CPAN.  DBD was updated and DBI is
reported as
> already up-to-date.  I did receive an error running the Perl test
script
> regarding something in DBI.  All results are below.
> 
> [root at sccmbug root]# perl -MCPAN -e 'install "DBD::mysql"'

...

You're going to need to force it to reinstall DBD::mysql.

perl -MCPAN -e 'force install "DBD::mysql"'

This is due to the fact that the versions agree, but the libraries your
old DBD::mysql were compiled against were for an older version of MySQL.
The libraries have been changed so you need to force it to recompile the
module.

---
Kevin Benton
Perl/Bugzilla Developer
Advanced Micro Devices
 
The opinions stated in this communication do not necessarily reflect the
view of Advanced Micro Devices and have not been reviewed by management.
This communication may contain sensitive and/or confidential and/or
proprietary information.  Distribution of such information is strictly
prohibited without prior consent of Advanced Micro Devices.  This
communication is for the intended recipient(s) only.  If you have
received this communication in error, please notify the sender, then
destroy any remaining copies of this communication.

> CPAN: Storable loaded ok
> Going to read /root/.cpan/Metadata
>   Database was generated on Mon, 06 Jun 2005 15:58:05 GMT
> CPAN: LWP::UserAgent loaded ok
> Fetching with LWP:
>   ftp://cpan.mirrors.redwire.net/pub/CPAN/authors/01mailrc.txt.gz
> Going to read /root/.cpan/sources/authors/01mailrc.txt.gz
> Fetching with LWP:
> 
>
ftp://cpan.mirrors.redwire.net/pub/CPAN/modules/02packages.details.txt.g
z
> Going to read /root/.cpan/sources/modules/02packages.details.txt.gz
>   Database was generated on Wed, 08 Jun 2005 11:57:15 GMT
> 
>   There's a new CPAN.pm version (v1.76) available!
>   [Current version is v1.61]
>   You might want to try
>     install Bundle::CPAN
>     reload cpan
>   without quitting the current session. It should be a seamless
upgrade
>   while we are running...
> 
> Fetching with LWP:
>   ftp://cpan.mirrors.redwire.net/pub/CPAN/modules/03modlist.data.gz
> Going to read /root/.cpan/sources/modules/03modlist.data.gz
> Going to write /root/.cpan/Metadata
> DBD::mysql is up to date.
> 
> [root at sccmbug root]# perl -MCPAN -e 'install "DBD::mysql"'
> CPAN: Storable loaded ok
> Going to read /root/.cpan/Metadata
>   Database was generated on Wed, 08 Jun 2005 11:57:15 GMT
> DBD::mysql is up to date.
> 
> [root at sccmbug root]# perl -MCPAN -e 'install "DBI"'
> CPAN: Storable loaded ok
> Going to read /root/.cpan/Metadata
>   Database was generated on Wed, 08 Jun 2005 11:57:15 GMT
> DBI is up to date.
> 
> [root at sccmbug tmp]# /usr/bin/perl ./perl-test.pl
> Can't locate auto/DBI/new.al in @INC (@INC contains:
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
> /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl
> /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl/5.8.0 /usr/lib/perl5/vendor_perl
> /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0 .)
at
> ./perl-test.pl line 8
> 
>
========================================================================
==
> ==
> ======
>
========================================================================
==
> ==
> ======
> 
> Some men see things as they are and say "why?".
> I dream things that never were and say "why not?". - Robert Kennedy
> 
> David Reid
> Intelligent Business Automation Inc
> phone - 847-891-8520  |  Fax - 630-214-3723
> david at reid-iba.com
> 
> -----Original Message-----
> From: developers-owner at bugzilla.org
[mailto:developers-owner at bugzilla.org]
> On Behalf Of Benton, Kevin
> Sent: Tuesday, June 07, 2005 7:39 PM
> To: developers at bugzilla.org
> Subject: Re: [Fwd: ibm and bugzilla]
> 
> What version of MySQL are you using?  Did you re-install your Perl
> DBD_mysql module since your last MySQL installation?  Upgrading MySQL
> without upgrading the Perl module will generally cause problems.
> 
> 99% of the time, when Perl throws a MySQL error from checksetup.pl,
it's
> due to a mismatch between the MySQL libraries and the Perl Module
> libraries.  One way to check to see if you're able to get MySQL to
work
> with Perl is to run this little snippet of code:
> 
> #!/usr/bin/perl
> 
> use DBI;
> 
> $host='your_mysql_host';
> $db='your_bugzilla_db';
> $db_port='your_mysql_server_port_usually_3306'
> $dbh=new DBI("DBI:mysql:host=$host;database=$db;port=$db_port")
>           or die("Unable to create new connection to MySQL\n");
> $sth=$dbh->prepare('select version()')
>           or die("Your DB doesn't understand select version()\n");
> $sth->execute() or die("A problem occurred while trying to execute the
> prepared statement.\n");
> @row=$sth->fetchrow_array();
> print("got ${row[0]} back from MySQL\n");
> exit;
> 
> ---
> Kevin Benton
> Perl/Bugzilla Developer
> Advanced Micro Devices
> 
> The opinions stated in this communication do not necessarily reflect
the
> view of Advanced Micro Devices and have not been reviewed by
management.
> This communication may contain sensitive and/or confidential and/or
> proprietary information.  Distribution of such information is strictly
> prohibited without prior consent of Advanced Micro Devices.  This
> communication is for the intended recipient(s) only.  If you have
> received this communication in error, please notify the sender, then
> destroy any remaining copies of this communication.
> 
> 
> 
> > -----Original Message-----
> > From: developers-owner at bugzilla.org
> [mailto:developers-owner at bugzilla.org]
> > On Behalf Of David Reid
> > Sent: Tuesday, June 07, 2005 3:35 PM
> > To: developers at bugzilla.org
> > Subject: Re: [Fwd: ibm and bugzilla]
> >
> > <snip>
> >
> >
> > Kevin,
> > Thank you for offering to help out.  I am receiving the following
> error
> > message when running 'checksetup.pl':
> >
> > Precompiling templates ...
> > /usr/bin/perl: relocation error:
> > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-
> > multi/auto/DBD/mysql/mysql.
> > so: undefined symbol: mysql_init
> >
> > I have attempted to include below several pieces of information
> regarding
> > my
> > installation attempt including the full text of the 'checksetup.pl'
> run.
> > Any help you can provide is greatly appreciated.
> >
> > -Jeff Tyree
> > jt at reid-iba.com
> > 630-712-3535
> >
> > ======================================================
> > ======================================================
> >
> > [root at sccmbug bugzilla-2.18.1]# uname -a Linux sccmbug.sccm.org
> 2.4.21-
> > 4.EL
> > #1 Fri Oct 3 18:13:58 EDT 2003 i686 i686 i386 GNU/Linux
> >
> >
> > ======================================================
> > ======================================================
> >
> > [root at sccmbug bugzilla-2.18.1]# perl -v
> >
> >
> > This is perl, v5.8.0 built for i386-linux-thread-multi (with 1
> registered
> > patch, see perl -V for more detail)
> >
> >
> > Copyright 1987-2002, Larry Wall
> >
> >
> > Perl may be copied only under the terms of either the Artistic
License
> or
> > the GNU General Public License, which may be found in the Perl 5
> source
> > kit.
> >
> >
> > Complete documentation for Perl, including FAQ lists, should be
found
> on
> > this system using `man perl' or `perldoc perl'.  If you have access
to
> the
> > Internet, point your browser at http://www.perl.com/, the Perl Home
> Page.
> >
> >
> > ======================================================
> > ======================================================
> >
> > [root at sccmbug bugzilla-2.18.1]# perl -V
> > Summary of my perl5 (revision 5.0 version 8 subversion 0)
> configuration:
> >   Platform:
> >     osname=linux, osvers=2.4.21-1.1931.2.393.entsmp,
> > archname=i386-linux-thread-multi
> >     uname='linux por'
> >
> > <snip>
> >
> > Characteristics of this binary (from libperl):
> >   Compile-time options: DEBUGGING MULTIPLICITY USE_ITHREADS
> > USE_LARGE_FILES
> > PERL_IMPLICIT_CONTEXT
> >   Locally applied patches:
> >         MAINT18379
> >   Built under linux
> >   Compiled at Sep 15 2003 10:03:52
> >   @INC:
> >     /usr/lib/perl5/5.8.0/i386-linux-thread-multi
> >     /usr/lib/perl5/5.8.0
> >     /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
> >     /usr/lib/perl5/site_perl/5.8.0
> >     /usr/lib/perl5/site_perl
> >     /usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
> >     /usr/lib/perl5/vendor_perl/5.8.0
> >     /usr/lib/perl5/vendor_perl
> >     /usr/lib/perl5/5.8.0/i386-linux-thread-multi
> >     /usr/lib/perl5/5.8.0
> >     .
> >
> >
> > ======================================================
> > ======================================================
> >
> > [root at sccmbug bugzilla-2.18.1]# mysqld -V mysqld  Ver
4.1.12-standard
> for
> > pc-linux-gnu on i686 (MySQL Community Edition - Standard (GPL))
> >
> > [root at sccmbug bugzilla-2.18.1]# mysql -V mysql  Ver 14.7 Distrib
> 4.1.12,
> > for
> > pc-linux-gnu (i686) using readline 4.3
> >
> >
> > ======================================================
> > ======================================================
> >
> > [root at sccmbug bugzilla-2.18.1]# ./checksetup.pl
> >
> > Checking perl modules ...
> > Checking for       AppConfig (v1.52)   ok: found v1.56
> > Checking for             CGI (v2.93)   ok: found v3.10
> > Checking for    Data::Dumper (any)     ok: found v2.12
> > Checking for    Date::Format (v2.21)   ok: found v2.22
> > Checking for             DBI (v1.36)   ok: found v1.48
> > Checking for      DBD::mysql (v2.1010) ok: found v2.9008
> > Checking for      File::Spec (v0.82)   ok: found v3.08
> > Checking for      File::Temp (any)     ok: found v0.16
> > Checking for        Template (v2.08)   ok: found v2.14
> > Checking for      Text::Wrap (v2001.0131) ok: found v2001.0929
> >
> > The following Perl modules are optional:
> > Checking for              GD (v1.20)   ok: found v2.19
> > Checking for     Chart::Base (v1.0)    ok: found v2.3
> > Checking for     XML::Parser (any)     ok: found v2.31
> > Checking for       GD::Graph (any)     ok: found v1.43
> > Checking for GD::Text::Align (any)     ok: found v1.18
> > Checking for     PatchReader (v0.9.4)  ok: found v0.9.5
> >
> > Checking user setup ...
> > Removing existing compiled templates ...
> > Precompiling templates ...
> > /usr/bin/perl: relocation error:
> > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-
> > multi/auto/DBD/mysql/mysql.
> > so: undefined symbol: mysql_init
> >
> >
> > ======================================================
> > ======================================================
> >
> > David W Reid
> > Intelligent Business Automation, Inc.
> > e. david at reid-iba.com
> > p. +1 (847) 891-8520
> > f. +1 (630) 214-3723
> > w. www.intelligentbusinessautomation.com
> >
> > "As democracy is perfected, the office of president represents, more
> and
> > more closely, the inner soul of the people. On some great and
glorious
> > day,
> > the plain folks of the land will reach their heart's desire at last,
> and
> > the
> > White House will be adorned by a downright moron."
> >
> > --H.L. Mencken (1880 - 1956)
> >
> >
> > -----Original Message-----
> > From: developers-owner at bugzilla.org
> [mailto:developers-owner at bugzilla.org]
> > On Behalf Of Benton, Kevin
> > Sent: Tuesday, June 07, 2005 12:38 PM
> > To: developers at bugzilla.org
> > Subject: Re: [Fwd: ibm and bugzilla]
> >
> > What was your question?  I never saw it...
> >
> > ---
> > Kevin Benton
> > Perl/Bugzilla Developer
> > Advanced Micro Devices
> >
> > The opinions stated in this communication do not necessarily reflect
> the
> > view of Advanced Micro Devices and have not been reviewed by
> management.
> > This communication may contain sensitive and/or confidential and/or
> > proprietary information.  Distribution of such information is
strictly
> > prohibited without prior consent of Advanced Micro Devices.  This
> > communication is for the intended recipient(s) only.  If you have
> > received this communication in error, please notify the sender, then
> > destroy any remaining copies of this communication.
> >
> >
> >
> > > -----Original Message-----
> > > From: developers-owner at bugzilla.org
> > [mailto:developers-owner at bugzilla.org]
> > > On Behalf Of David Reid
> > > Sent: Tuesday, June 07, 2005 11:27 AM
> > > To: developers at bugzilla.org
> > > Subject: Re: [Fwd: ibm and bugzilla]
> > >
> > > Well actually I did ask, several times over several days and no
one
> > ever
> > > responded. I was just hoping that their might be a more responsive
> > forum.
> > >
> > > David W Reid
> > > Intelligent Business Automation, Inc.
> > > e. david at reid-iba.com
> > > p. +1 (847) 891-8520
> > > f. +1 (630) 214-3723
> > > w. www.intelligentbusinessautomation.com
> > >
> > > "As democracy is perfected, the office of president represents,
more
> > and
> > > more closely, the inner soul of the people. On some great and
> glorious
> > > day,
> > > the plain folks of the land will reach their heart's desire at
last,
> > and
> > > the
> > > White House will be adorned by a downright moron."
> > >
> > > --H.L. Mencken (1880 - 1956)
> > >
> > >
> > > -----Original Message-----
> > > From: developers-owner at bugzilla.org
> > [mailto:developers-owner at bugzilla.org]
> > > On Behalf Of Benton, Kevin
> > > Sent: Tuesday, June 07, 2005 10:06 AM
> > > To: developers at bugzilla.org
> > > Subject: Re: [Fwd: ibm and bugzilla]
> > >
> > > Colin Ogilvie Wrote:
> > >
> > > > David Reid wrote:
> > > >
> > > > >Do you have a suggestion where we might be able to ask, what I
> > think
> > > are,
> > > > a few simple questions?
> > > > >
> > > > There is #mozwebtools on irc.mozilla.org where you can ask
> > questions,
> > > or
> > > > the netscape.public.mozilla.webtools newsgroup. Details of all
the
> > > > support options available for Bugzilla are available at
> > > > http://www.bugzilla.org/support/
> > >
> > > Also, while you're at it, please - feel free to just ask.  Asking
to
> > ask
> > > just adds delay.
> > >
> > > ---
> > > Kevin Benton
> > > Perl/Bugzilla Developer
> > > Advanced Micro Devices
> > >
> > > The opinions stated in this communication do not necessarily
reflect
> > the
> > > view of Advanced Micro Devices and have not been reviewed by
> > management.
> > > This communication may contain sensitive and/or confidential
and/or
> > > proprietary information.  Distribution of such information is
> strictly
> > > prohibited without prior consent of Advanced Micro Devices.  This
> > > communication is for the intended recipient(s) only.  If you have
> > > received this communication in error, please notify the sender,
then
> > > destroy any remaining copies of this communication.
> > >
> > >
> > > -
> > > To view or change your list settings, click here:
> > > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=david@reid-iba.com>
> > > -
> > > To view or change your list settings, click here:
> > > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=kevin.benton@amd.com>
> >
> >
> >
> > -
> > To view or change your list settings, click here:
> > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=david@reid-iba.com>
> > -
> > To view or change your list settings, click here:
> > <http://bugzilla.org/cgi-bin/mj_wwwusr?user=kevin.benton@amd.com>
> 
> 
> 
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=david@reid-iba.com>
> -
> To view or change your list settings, click here:
> <http://bugzilla.org/cgi-bin/mj_wwwusr?user=kevin.benton@amd.com>



-
To view or change your list settings, click here:
<http://bugzilla.org/cgi-bin/mj_wwwusr?user=david@reid-iba.com>

-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: force-DBI-result.txt
URL: <http://lists.bugzilla.org/pipermail/developers/attachments/20050608/cba2559f/attachment.txt>


More information about the developers mailing list