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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [email protected] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com
