[rt-devel] Installation problems with 1.3.49_01

[Jonas Liljegren]

I started using RT 1 six months ago.  This is my first look at RT2.

The installation was done on a Debian GNU/Linux system using mostly
TESTING and some UNSTABLE.

I wanted to use PostgreSQL, but the latest version (in unstable) is
7.0.3-4. So I used MySQL.

 - MySQL 3.23.33
 - Perl v5.6.0
 - DBI 1.13
 - DBD::mysql 2.0415
 - DBIx::DataSource 0.02
 - DBIx::DBSchema 0.16


The initdb didn't work. I got errors on tows 71 and 73:

print "\nCreating database schema.\n";
my $dbh = DBI->connect( $dsn, $DB_DBA, $DB_DBA_PASSWORD ) or die $DBI::errstr;
foreach my $statement ( $schema->sql($dsn, $DB_DBA, $DB_DBA_PASSWORD ) ) {
  print STDERR $statement if $DEBUG;
  my $sth = $dbh->prepare($statement) or die $dbh->errstr;
  unless ($sth->execute) {
    print STDERR "Problem with statement:\n $statement\n";
    die $sth->errstr;
  }
}



It was a lot of errors (sorry, didn't save them) about two things
during table creation:

1. It tried to create indexes there one of the keys was marked as NULL
   instead of NOT NULL.  That was not allowed.

2. It tried to produce keys longer that 255 bytes.  Ie, the combined
   length of an primary key or index key was too long.

I changed a number of NULL to not NULL and commented out many
indexes.  The changed file is included here:

-------------- next part --------------
A non-text attachment was scrubbed...
Name: schema.pm
Type: application/x-perl
Size: 12118 bytes
Desc: The modified schema
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20010309/79b44d2a/schema.bin
-------------- next part --------------

Hmm. Maby should have given a patch also...

-------------- next part --------------
A non-text attachment was scrubbed...
Name: schema.diff
Type: text/x-patch
Size: 1589 bytes
Desc: Diff against 1.3.49_01
Url : http://pallas.eruditorum.org/pipermail/rt-devel/attachments/20010309/79b44d2a/schema-0001.bin
-------------- next part --------------




-- 
jonas at rit.se   RIT AB   http://www.rit.se
Box 70, 428 21 K?llered Bes?k: G:a Riksv?gen 36
Tel: +46 (0)31 751 8600  Fax: +46 (0)31 751 8609