[Fwd: ibm and bugzilla]
Benton, Kevin
kevin.benton at amd.com
Wed Jun 8 00:38:52 UTC 2005
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>
More information about the developers
mailing list