[rt-users] rt-3.8.6 is already installed... Error code 1

[Zach Boettner]

Can anyone explain a bit more the steps I need to take to resolve this
issue? Matthew, what 'command' are you talking about to run from the mysql
client? How do I create the sql structure required by RT? I have the
database, rt3, created, but no structure in it. I'm fairly new to FreeBSD
and a bit lost with this RT installation/config. It's a crash course.
Thanks, Zach


-----Original Message-----
From: Matthew Seaman [mailto:m.seaman at infracaninophile.co.uk] 
Sent: Friday, December 25, 2009 12:34 AM
To: Zach Boettner
Cc: rt-users at lists.bestpractical.com
Subject: Re: [rt-users] rt-3.8.6 is already installed... Error code 1

Zach Boettner wrote:
> Ok, now when I put the PerlRequire /usr/local/bin/webmux.pl in my
> httpd.conf, apache fails to restart and I get the following in my apache
> error log file. If I comment out the PerlRequire statement apache will run
> and I get the BestPractical - You're almost there web page. Does the
> following errors indicate a problem with my mysql config or my
> RT_SiteConfig.pm???
> 
> [Thu Dec 24 08:23:38 2009] [notice] SIGHUP received.  Attempting to
restart
> [Thu Dec 24 08:23:38 2009] [warn] (22)Invalid argument: Failed to enable
the
> 'htt
> pready' Accept Filter
> [Thu Dec 24 08:23:41 2009] [error] Can't use an undefined value as an
ARRAY
> refer
> ence at /usr/local/lib/perl5/site_perl/5.8.9/RT/Handle.pm line
> 278.\nCompilation
> failed in require at (eval 4) line 1.\n
> [Thu Dec 24 08:23:41 2009] [error] Can't load Perl file:
> /usr/local/bin/webmux.pl
>  for server freebsd8.bchq.local:80, exiting...
> [Thu Dec 24 08:23:51 2009] [error] Can't use an undefined value as an
ARRAY
> refer
> ence at /usr/local/lib/perl5/site_perl/5.8.9/RT/Handle.pm line
> 278.\nCompilation
> failed in require at (eval 4) line 1.\n
> [Thu Dec 24 08:23:51 2009] [error] Can't load Perl file:
> /usr/local/bin/webmux.pl
>  for server freebsd8.bchq.local:80, exiting...
> [Thu Dec 24 08:23:54 2009] [error] Can't use an undefined value as an
ARRAY
> refer
> ence at /usr/local/lib/perl5/site_perl/5.8.9/RT/Handle.pm line
> 278.\nCompilation
> failed in require at (eval 4) line 1.\n
> [Thu Dec 24 08:23:54 2009] [error] Can't load Perl file:
> /usr/local/bin/webmux.pl
>  for server freebsd8.bchq.local:80, exiting...

It's blowing up in this chunk of code (in RT::Handle) --

   277          if ( $state eq 'post' ) {
   278              my $create_table = $dbh->selectrow_arrayref("SHOW CREATE
TABLE Tickets")->[1];
   279              unless ( $create_table =~
/(?:ENGINE|TYPE)\s*=\s*InnoDB/i ) {
   280                  return (0, "RT requires that all its tables be of
InnoDB type. Upgrade RT tables.");
   281              }
   282          }

which suggests that you've got database problems.  Possibly that the rt
database
schema hasn't been installed.  Try running that command from mysql client.
You
should get output like this:

# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 63618
Server version: 5.0.84-log FreeBSD port: mysql-server-5.0.84

Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.

mysql> use rt3
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SHOW CREATE TABLE Tickets \G
*************************** 1. row ***************************
       Table: Tickets
Create Table: CREATE TABLE `Tickets` (
  `id` int(11) NOT NULL auto_increment,
  `EffectiveId` int(11) NOT NULL default '0',
  `Queue` int(11) NOT NULL default '0',
  `Type` varchar(16) character set ascii default NULL,
  `IssueStatement` int(11) NOT NULL default '0',
  `Resolution` int(11) NOT NULL default '0',
  `Owner` int(11) NOT NULL default '0',
  `Subject` varchar(200) character set utf8 collate utf8_unicode_ci default
'[no subject]',
  `InitialPriority` int(11) NOT NULL default '0',
  `FinalPriority` int(11) NOT NULL default '0',
  `Priority` int(11) NOT NULL default '0',
  `TimeEstimated` int(11) NOT NULL default '0',
  `TimeWorked` int(11) NOT NULL default '0',
  `Status` varchar(10) character set ascii default NULL,
  `TimeLeft` int(11) NOT NULL default '0',
  `Told` datetime default NULL,
  `Starts` datetime default NULL,
  `Started` datetime default NULL,
  `Due` datetime default NULL,
  `Resolved` datetime default NULL,
  `LastUpdatedBy` int(11) NOT NULL default '0',
  `LastUpdated` datetime default NULL,
  `Creator` int(11) NOT NULL default '0',
  `Created` datetime default NULL,
  `Disabled` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `Tickets1` (`Queue`,`Status`),
  KEY `Tickets2` (`Owner`),
  KEY `Tickets6` (`EffectiveId`,`Type`)
) ENGINE=InnoDB AUTO_INCREMENT=348 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)


	Cheers,

	Matthew

-- 
Dr Matthew J Seaman MA, D.Phil.                   7 Priory Courtyard
                                                  Flat 3
PGP: http://www.infracaninophile.co.uk/pgpkey     Ramsgate
                                                  Kent, CT11 9PW