Mysql DBI error on make install

RT Developers
1

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,
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

2

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,
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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent – root@eruditorum.org – jesse@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.

3

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 :slight_smile:

$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?

ThxFrom: Jesse [mailto:jesse@fsck.com]
Sent: Wednesday, May 16, 2001 10:06 AM
To: Shaun Hedges
Cc: rt-devel@lists.fsck.com
Subject: Re: [rt-devel] Mysql DBI error on make install

What version of DBD::mysql do you have?

4

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 :slight_smile:

$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@fsck.com]
Sent: Wednesday, May 16, 2001 10:06 AM
To: Shaun Hedges
Cc: rt-devel@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,
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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

–
jesse reed vincent – root@eruditorum.org – jesse@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@eruditorum.org – jesse@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@apocalypse.org

5

YvrS-DAT02-LI:/opt/src/webrt/rt2 # perl -MDBD::mysql -e’print
$DBD::mysql::VERSION’
2.009902

Is this out of date?

CyaFrom: ‘Jesse’ [mailto:jesse@fsck.com]
Sent: Wednesday, May 16, 2001 10:16 AM
To: Shaun Hedges
Cc: rt-devel@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.

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 :slight_smile:

$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@fsck.com]
Sent: Wednesday, May 16, 2001 10:06 AM
To: Shaun Hedges
Cc: rt-devel@lists.fsck.com
Subject: Re: [rt-devel] Mysql DBI error on make install

What version of DBD::mysql do you have?

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,

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

–
jesse reed vincent – root@eruditorum.org – jesse@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@eruditorum.org – jesse@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@apocalypse.org

6

Hi Shaun,

Older DBD::mysql drivers did not support the DBI->connect syntax:

    DBI:mysql:dbname=db;host=host

instead you have to use:

    DBI:mysql:db:host

We found this on a lot of systems, might be worth switching to the old
style syntax, or mentioning it in the docs.

Cheers,

AlexOn Wed, 16 May 2001 09:55:04 -0700 “Shaun Hedges” shaun@lexicom.ab.ca 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,
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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

7

Yes, seems reasonable.

Are newer versions backwards compatible? I have some code that uses the old
style syntax still.

Thx everyone for the helpFrom: rt-devel-admin@lists.fsck.com
[mailto:rt-devel-admin@lists.fsck.com]On Behalf Of Alex Krohn
Sent: Wednesday, May 16, 2001 10:22 AM
To: Shaun Hedges
Cc: rt-devel@lists.fsck.com
Subject: Re: [rt-devel] Mysql DBI error on make install

Hi Shaun,

Older DBD::mysql drivers did not support the DBI->connect syntax:

    DBI:mysql:dbname=db;host=host

instead you have to use:

    DBI:mysql:db:host

We found this on a lot of systems, might be worth switching to the old
style syntax, or mentioning it in the docs.

Cheers,

Alex

8

Hi,

Yes, seems reasonable.

Are newer versions backwards compatible? I have some code that uses the old
style syntax still.

Yes, The old style DBI:mysql:db:host will work on all versions of
DBD::mysql, the new version only works on fairly recent versions.

Cheers,

Alex

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

9

YvrS-DAT02-LI:/opt/src/webrt/rt2 # /usr/bin/perl /opt/webrt2/etc/insertdata
DBD::mysql::st execute failed: Duplicate entry ‘RT_System’ for key 2 at
/usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm line 297.
RT::Handle=HASH(0x85bb540) couldn’t execute the query 'INSERT INTO Users
(Created, Creator, Name, LastUpdated, Privileged, RealName, LastUpdatedBy,
Comments) VALUES (?, ?, ?, ?, ?, ?, ?, ?)'Duplicate entry ‘RT_System’ for
key 2
Creating system user…Could not create user

I see this error now on make install and when running the insertdata script
arbitrarily. Any ideas?

ThxFrom: rt-devel-admin@lists.fsck.com
[mailto:rt-devel-admin@lists.fsck.com]On Behalf Of Alex Krohn
Sent: Wednesday, May 16, 2001 10:30 AM
To: Shaun Hedges
Cc: rt-devel@lists.fsck.com
Subject: Re: [rt-devel] Mysql DBI error on make install

Hi,

Yes, seems reasonable.

Are newer versions backwards compatible? I have some code that uses the
old
style syntax still.

Yes, The old style DBI:mysql:db:host will work on all versions of
DBD::mysql, the new version only works on fairly recent versions.

Cheers,

Alex

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

10

Hi,

YvrS-DAT02-LI:/opt/src/webrt/rt2 # /usr/bin/perl /opt/webrt2/etc/insertdata
DBD::mysql::st execute failed: Duplicate entry ‘RT_System’ for key 2 at
/usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm line 297.
RT::Handle=HASH(0x85bb540) couldn’t execute the query 'INSERT INTO Users
(Created, Creator, Name, LastUpdated, Privileged, RealName, LastUpdatedBy,
Comments) VALUES (?, ?, ?, ?, ?, ?, ?, ?)'Duplicate entry ‘RT_System’ for
key 2
Creating system user…Could not create user

I see this error now on make install and when running the insertdata script
arbitrarily. Any ideas?

Jesse, these were the sort of errors I got. If anything goes wrong
during the install, you are forced to manually remove the user, and/or
drop and recreate the database. Putting prompts in whether this should
be done would be very useful.

Shaun, basically RT has already added the rt user to mysql, and now when
trying to reinstall it’s dying. You can delete it manually from the
mysql.User table and you should be fine.

Cheers,

Alex

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

11

Sorry again,

That error comes after this error:

This error is reported on make install:
/usr/bin/perl /opt/webrt2/etc/insertdata
RT::Handle=HASH(0x85bb414) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle/mysql.pm line 34.
Creating system user…Could not create user

and the previous error was reported when running insertdata

Sorry for all the questions, anymore ideas?From: rt-devel-admin@lists.fsck.com
[mailto:rt-devel-admin@lists.fsck.com]On Behalf Of Alex Krohn
Sent: Wednesday, May 16, 2001 10:49 AM
To: Shaun Hedges
Cc: rt-devel@lists.fsck.com
Subject: Re: [rt-devel] Mysql DBI error on make install

Hi,

YvrS-DAT02-LI:/opt/src/webrt/rt2 # /usr/bin/perl
/opt/webrt2/etc/insertdata
DBD::mysql::st execute failed: Duplicate entry ‘RT_System’ for key 2 at
/usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm line 297.
RT::Handle=HASH(0x85bb540) couldn’t execute the query 'INSERT INTO Users
(Created, Creator, Name, LastUpdated, Privileged, RealName, LastUpdatedBy,
Comments) VALUES (?, ?, ?, ?, ?, ?, ?, ?)'Duplicate entry ‘RT_System’ for
key 2
Creating system user…Could not create user

I see this error now on make install and when running the insertdata
script
arbitrarily. Any ideas?

Jesse, these were the sort of errors I got. If anything goes wrong
during the install, you are forced to manually remove the user, and/or
drop and recreate the database. Putting prompts in whether this should
be done would be very useful.

Shaun, basically RT has already added the rt user to mysql, and now when
trying to reinstall it’s dying. You can delete it manually from the
mysql.User table and you should be fine.

Cheers,

Alex

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

12

Hi,

Sorry again,

That error comes after this error:

This error is reported on make install:
/usr/bin/perl /opt/webrt2/etc/insertdata
RT::Handle=HASH(0x85bb414) no row id returned on row creation at
/usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle/mysql.pm line 34.
Creating system user…Could not create user

and the previous error was reported when running insertdata

Sorry for all the questions, anymore ideas?

I have a feeling you’ll see a lot of these errors as I don’t think this
version of RT has been tested with an older driver.

Another difference with older DBD::mysql’s is that it does not support:

    $sth->{mysql_insertid}

property to get the last inserted id. Instead, you use:

    $sth->{insertid}

This will throw a “depreciated warning” on the new DBD::mysql, so I
would recommend changing in DBIx/SearchBuilder/Handle/mysql.pm:

    $self->{'id'}=$self->dbh->{'mysql_insertid'};

to:

    $self->{id} = $sth->{mysql_insertid} || $sth->{insertid};

(I wasn’t aware you could get it out of a dbh, is that correct? What if
you have multiple sth’s doing inserts, which id would it be, the last
one?)

Cheers,

Alex

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

13

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@fsck.com]
Sent: Wednesday, May 16, 2001 10:16 AM
To: Shaun Hedges
Cc: rt-devel@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 :slight_smile:

$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@fsck.com]
Sent: Wednesday, May 16, 2001 10:06 AM
To: Shaun Hedges
Cc: rt-devel@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,

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

–
jesse reed vincent – root@eruditorum.org – jesse@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@eruditorum.org – jesse@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@apocalypse.org

jesse reed vincent – root@eruditorum.org – jesse@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

14

I have a feeling you’ll see a lot of these errors as I don’t think this
version of RT has been tested with an older driver.

Nope. And I’m not really interested in porting RT to out of date versions
of DBD::mysql, when the current versions are fully backward compatible.
The next version of RT will specify a minimum DBD::mysql version.

(I wasn’t aware you could get it out of a dbh, is that correct? What if
you have multiple sth’s doing inserts, which id would it be, the last
one?)

Both are correct. DBI isn’t threadsafe, so it’s pretty much impossible to
run into the problem you suggest. Iirc, the $sth-> version is deprecated.

jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

I have images of Marc in well worn combat fatigues, covered in mud,
sweat and blood, knife in one hand and PSION int he other, being
restrained by several other people, screaming “Let me at it!
Just let me at it!” Eichin standing calmly by with something
automated, milspec, and likely recoilless.
-xiphmont on opensource peer review

15

Actually, it’s not the nysql RT user but RT’s RT_System user.
I’ll add a comment about reinitializing RT’s database to the readme.

Hi,
Jesse, these were the sort of errors I got. If anything goes wrong
during the install, you are forced to manually remove the user, and/or
drop and recreate the database. Putting prompts in whether this should
be done would be very useful.

Shaun, basically RT has already added the rt user to mysql, and now when
trying to reinstall it’s dying. You can delete it manually from the
mysql.User table and you should be fine.

That’s not an issue. RT’s already smart about that.

Cheers,

Alex

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent – root@eruditorum.org – jesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

Pelcgb-serrqbz abj!

16

Hi Jesse,

I have a feeling you’ll see a lot of these errors as I don’t think this
version of RT has been tested with an older driver.

Nope. And I’m not really interested in porting RT to out of date versions
of DBD::mysql, when the current versions are fully backward compatible.
The next version of RT will specify a minimum DBD::mysql version.

Totall fair. Just to warn you though, as someone who distributes perl
applications for a living, when we first distributed our SQL library
which used dbname=foo;host=foo, we found about 20% of users ran into
connection problems. It was much higher then I would have thought.

But I don’t think this is really an issue in your situation as you
pretty much require the ability to install perl modules and have root on
the server. We were dealing with people trying to install on virtuals
and upgrading mysql drivers were not an option.

We’ve also found a large number of users still use perl 5.004. :wink:

Cheers,

Alex

-------------------- Gossamer Threads Inc. ----------------------
Alex Krohn Email: alex@gossamer-threads.com
Internet Consultant Phone: (604) 687-5804
http://www.gossamer-threads.com Fax : (604) 687-5806

17

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.

jonOn 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@fsck.com]
Sent: Wednesday, May 16, 2001 10:16 AM
To: Shaun Hedges
Cc: rt-devel@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 :slight_smile:

$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@fsck.com]
Sent: Wednesday, May 16, 2001 10:06 AM
To: Shaun Hedges
Cc: rt-devel@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,

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

–
jesse reed vincent – root@eruditorum.org – jesse@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@eruditorum.org – jesse@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@apocalypse.org

–
jesse reed vincent – root@eruditorum.org – jesse@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

18

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.

    -jOn 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@fsck.com]
Sent: Wednesday, May 16, 2001 10:16 AM
To: Shaun Hedges
Cc: rt-devel@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 :slight_smile:

$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@fsck.com]
Sent: Wednesday, May 16, 2001 10:06 AM
To: Shaun Hedges
Cc: rt-devel@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,

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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

–
jesse reed vincent – root@eruditorum.org – jesse@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@eruditorum.org – jesse@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@apocalypse.org

–
jesse reed vincent – root@eruditorum.org – jesse@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@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

Rt-devel mailing list
Rt-devel@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-devel

jesse reed vincent – root@eruditorum.org – jesse@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