[rt-devel] Mysql DBI error on make install

Wed May 16 15:13:48 EDT 2001

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
> 