[rt-devel] Mysql DBI error on make install
'Jesse'
jesse at fsck.com
Wed May 16 15:31:52 EDT 2001
Interesting. I'm running 1.2216..
I've definitely seen this before. I've never actually tracked it down t
o a specific version interaction. But sometimes a reinstall
of msql-mysql-modules can magically make thing better.
-j
On Wed, May 16, 2001 at 03:13:48PM -0400, John Fisher wrote:
> I ran into a similar problem when installing the new version of rt on a
> new system. From CPAN I got the latest DBD::mysql which is version 1.2216.
> This seems to have a bug with $dbh->{'mysql_insertid'}
> When you insert a new row, you get 0 back all the time (the row is still
> inserted with the correct id (auto_increment)).
>
> The previous version Msql-Mysql-modules-1.2215 works fine, which is what I
> had to install by hand to get it to work. This is not an RT only thing. I
> created my own test script - using the documentation that came with the
> module - and it too did not work.
>
> jon
>
>
>
> On Wed, 16 May 2001, 'Jesse' wrote:
>
> > Urk. They've gone and released a new _broken_ beta of DBD::mysql into CPAN
> > that now overrides the production release. gimme a bit of time to figure
> > out the right thing.
> >
> >
> >
> > On Wed, May 16, 2001 at 10:16:41AM -0700, Shaun Hedges wrote:
> > > YvrS-DAT02-LI:/opt/src/webrt/rt2 # perl -MDBD::mysql -e'print
> > > $DBD::mysql::VERSION'
> > > 2.009902
> > >
> > > Is this out of date?
> > >
> > > Cya
> > >
> > >
> > > -----Original Message-----
> > > From: 'Jesse' [mailto:jesse at fsck.com]
> > > Sent: Wednesday, May 16, 2001 10:16 AM
> > > To: Shaun Hedges
> > > Cc: rt-devel at lists.fsck.com
> > > Subject: Re: [rt-devel] Mysql DBI error on make install
> > >
> > >
> > > pallas:% perl -MDBD::mysql -e'print $DBD::mysql::VERSION'
> > > 2.0416
> > >
> > >
> > > I suspect you've got a badly out of date mysql driver.
> > >
> > >
> > >
> > > On Wed, May 16, 2001 at 10:08:37AM -0700, Shaun Hedges wrote:
> > > > YvrS-DAT02-LI:/opt/src/webrt/rt2 # locate mysql.pm
> > > > /usr/lib/perl5/site_perl/5.005/DBIx/DataSource/mysql.pm
> > > > /usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle/mysql.pm
> > > > /usr/lib/perl5/site_perl/5.005/i586-linux/DBD/mysql.pm
> > > > YvrS-DAT02-LI:/opt/src/webrt/rt2 # head -10
> > > > /usr/lib/perl5/site_perl/5.005/i586-linux/DBD/mysql.pm
> > > > # Our beloved Emacs will give us -*- perl -*- mode :-)
> > > > #
> > > > # $Id: mysql.pm 1.1 Tue, 30 Sep 1997 01:28:08 +0200 joe $
> > > > #
> > > > # Copyright (c) 1994,1995,1996,1997 Alligator Descartes, Tim Bunce
> > > > #
> > > > # You may distribute under the terms of either the GNU General Public
> > > > # License or the Artistic License, as specified in the Perl README file.
> > > >
> > > > package DBD::mysql;
> > > >
> > > > 1.1? Is there another way to get the version?
> > > >
> > > > Thx
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Jesse [mailto:jesse at fsck.com]
> > > > Sent: Wednesday, May 16, 2001 10:06 AM
> > > > To: Shaun Hedges
> > > > Cc: rt-devel at lists.fsck.com
> > > > Subject: Re: [rt-devel] Mysql DBI error on make install
> > > >
> > > >
> > > > What version of DBD::mysql do you have?
> > > >
> > > >
> > > > On Wed, May 16, 2001 at 09:55:04AM -0700, Shaun Hedges wrote:
> > > > > Hi,
> > > > >
> > > > > Has anyone got this before:
> > > > >
> > > > > mkdir -p /opt/webrt2/bin
> > > > > mkdir -p /opt/webrt2/WebRT/data
> > > > > mkdir -p /opt/webrt2/WebRT/sessiondata
> > > > > mkdir -p /opt/webrt2/etc
> > > > > mkdir -p /opt/webrt2/lib
> > > > > mkdir -p /opt/webrt2/WebRT/html
> > > > > /usr/bin/perl tools/initdb 'mysql' '/opt/mysql' '127.0.0.1' 'root'
> > > > > 'webrt2' create
> > > > > Now creating a database for RT.
> > > > > Enter the mysql password for root:
> > > > > Creating mysql database webrt2.
> > > > > DBI->connect(dbname=;host=127.0.0.1) failed: Unknown MySQL Server Host
> > > > > 'host=127.0.0.1' (2) at
> > > > > /usr/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74
> > > > > Unknown MySQL Server Host 'host=127.0.0.1' (2) at
> > > > > /usr/lib/perl5/site_perl/5.005/DBIx/DataSource/Driver.pm line 74,
> > > <STDIN>
> > > > > chunk 1.
> > > > > make: *** [createdb] Error 255
> > > > >
> > > > > I noticed some totally different perl/dbi code before getting a similar
> > > > > error. I think it's something to do with the dbi version.
> > > > >
> > > > > Any ideas?
> > > > >
> > > > > Sorry of this question has already been answered, i'm new to the list.
> > > > >
> > > > > Thx
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > Rt-devel mailing list
> > > > > Rt-devel at lists.fsck.com
> > > > > http://lists.fsck.com/mailman/listinfo/rt-devel
> > > > >
> > > >
> > > > --
> > > > jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> > > > 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> > > >
> > > > "If IBM _wanted_ to make clones, we could make them cheaper and faster
> > > than
> > > > anyone else!" - An IBM Rep. visiting Vassar College's Comp Sci
> > > Department.
> > > >
> > > >
> > >
> > > --
> > > jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> > > 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> > >
> > > that's security the same way that asking for directions to topeka and
> > > being told that a seal is a mammal is informative
> > > -robin at apocalypse.org
> > >
> > >
> >
> > --
> > jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
> > 70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
> >
> > ...realized that the entire structure of the net could be changed to be made
> > more efficient, elegant, and spontaneously make more money for everyone
> > involved. It's a marvelously simple diagram, but this form doesn't have a way
> > for me to draw it. It'll wait. -Adam Hirsch
> >
> > _______________________________________________
> > Rt-devel mailing list
> > Rt-devel at lists.fsck.com
> > http://lists.fsck.com/mailman/listinfo/rt-devel
> >
>
>
>
> _______________________________________________
> Rt-devel mailing list
> Rt-devel at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-devel
>
--
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90
A REAL sysadmin challenge is "resurrect five dead mailserver while so ripped
to the gills on mdma that you can't focus on any given line of text for more
than 10 seconds continuously."
-Nathan Mehl
More information about the Rt-devel
mailing list