[rt-users] Testing 4.0.0rc5 - experiences upgrading from 3.6.4 on RHEL6

Darren Nickerson darren at dazza.org
Fri Feb 18 20:33:27 EST 2011


So I figured I'd give 4.0.0rc5 a try on a disposable RHEL6 virtual machine tonight with a dump of our 3.6.4 database. I have to say, the various upgrade scripts seemed to have worked wonders, and I actually have a functioning 4.0.0rc5 running. It's reporting a lot of errors in syslog however, most of them to do with 'lifecycle', such as:

Feb 18 20:01:51 rt RT: DBD::mysql::st execute failed: Unknown column 'lifecycle' in 'field list' at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 509. (/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:509)

The Queues table looks like:

mysql> describe Queues;
+-------------------+--------------+------+-----+---------+----------------+
| Field             | Type         | Null | Key | Default | Extra          |
+-------------------+--------------+------+-----+---------+----------------+
| id                | int(11)      | NO   | PRI | NULL    | auto_increment |
| Name              | varchar(200) | NO   | UNI |         |                |
| Description       | varchar(255) | YES  |     | NULL    |                |
| CorrespondAddress | varchar(120) | YES  |     | NULL    |                |
| CommentAddress    | varchar(120) | YES  |     | NULL    |                |
| InitialPriority   | int(11)      | NO   |     | 0       |                |
| FinalPriority     | int(11)      | NO   |     | 0       |                |
| DefaultDueIn      | int(11)      | NO   |     | 0       |                |
| Creator           | int(11)      | NO   |     | 0       |                |
| Created           | datetime     | YES  |     | NULL    |                |
| LastUpdatedBy     | int(11)      | NO   |     | 0       |                |
| LastUpdated       | datetime     | YES  |     | NULL    |                |
| Disabled          | smallint(6)  | NO   | MUL | 0       |                |
+-------------------+--------------+------+-----+---------+----------------+
13 rows in set (0.01 sec)


What'd I miss?

A second, more fatal problem that has me completely baffled presently is that after the initial cycle of:

- import old database
- upgrade to 3.7.87 using the script that allows you to specify start/end revisions
- generate the queries.sql file and then run those

I seem to be able to login once, but as soon as I explicitly logout, I can no longer login no matter how many mason/browser cache clearing loops I do.

A third problem is that I can't seem to get RT to run when I first start apache. I get:

	mkdir /opt/rt4/var/mason_data/obj/3452818388: Permission denied at /usr/local/share/perl5/HTML/Mason/Compiler/ToObject.pm line 107

Looks like the various directories were created as root:

[root at rt rt-4.0.0rc5]# ls -al /opt/rt4/var/mason_data/
total 16
drwxrwx---. 4 apache apache 4096 Feb 18 20:21 .
drwxr-xr-x. 5 root   root   4096 Feb 18 17:50 ..
drwxr-xr-x. 2 root   root   4096 Feb 18 19:41 cache
drwxr-xr-x. 2 root   root   4096 Feb 18 20:21 obj
[root at rt rt-4.0.0rc5]# 

If I delete the subdirs under mason_data while apache is still running, it recreates the obj directory with a user ID it can deal with:

[root at rt rt-4.0.0rc5]# ls -al /opt/rt4/var/mason_data/
total 12
drwxrwx---. 3 apache apache 4096 Feb 18 20:25 .
drwxr-xr-x. 5 root   root   4096 Feb 18 17:50 ..
drwxr-xr-x. 3 apache apache 4096 Feb 18 20:25 obj
[root at rt rt-4.0.0rc5]# 

and the site loads. Still can't login tho.

Feb 18 20:12:24 rt RT: FAILED LOGIN for root from ##.##.##.## (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:605)
Feb 18 20:12:37 rt RT: FAILED LOGIN for root from ##.##.##.##(/opt/rt4/sbin/../lib/RT/Interface/Web.pm:605)
Feb 18 20:13:08 rt RT: FAILED LOGIN for root from ##.##.##.## (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:605)


Help?

-d

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110218/aec99c3f/attachment.htm>


More information about the rt-users mailing list