<html><head><base href="http://rt4.ifax.com/index.html"></head><body style="-webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><base href="http://rt4.ifax.com/index.html">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:<div><div><br></div><div><div>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)</div></div><div><br></div><div>The Queues table looks like:</div><div><br></div><div><div><font class="Apple-style-span" face="'Courier New'">mysql> describe Queues;</font></div><div><font class="Apple-style-span" face="'Courier New'">+-------------------+--------------+------+-----+---------+----------------+</font></div><div><font class="Apple-style-span" face="'Courier New'">| Field | Type | Null | Key | Default | Extra |</font></div><div><font class="Apple-style-span" face="'Courier New'">+-------------------+--------------+------+-----+---------+----------------+</font></div><div><font class="Apple-style-span" face="'Courier New'">| id | int(11) | NO | PRI | NULL | auto_increment |</font></div><div><font class="Apple-style-span" face="'Courier New'">| Name | varchar(200) | NO | UNI | | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| Description | varchar(255) | YES | | NULL | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| CorrespondAddress | varchar(120) | YES | | NULL | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| CommentAddress | varchar(120) | YES | | NULL | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| InitialPriority | int(11) | NO | | 0 | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| FinalPriority | int(11) | NO | | 0 | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| DefaultDueIn | int(11) | NO | | 0 | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| Creator | int(11) | NO | | 0 | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| Created | datetime | YES | | NULL | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| LastUpdatedBy | int(11) | NO | | 0 | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| LastUpdated | datetime | YES | | NULL | |</font></div><div><font class="Apple-style-span" face="'Courier New'">| Disabled | smallint(6) | NO | MUL | 0 | |</font></div><div><font class="Apple-style-span" face="'Courier New'">+-------------------+--------------+------+-----+---------+----------------+</font></div><div><font class="Apple-style-span" face="'Courier New'">13 rows in set (0.01 sec)</font></div></div><div><br></div><div><br></div><div>What'd I miss?</div><div><br></div><div>A second, more fatal problem that has me completely baffled presently is that after the initial cycle of:</div><div><br></div><div>- import old database</div><div>- upgrade to 3.7.87 using the script that allows you to specify start/end revisions</div><div>- generate the queries.sql file and then run those</div><div><br></div><div>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.</div><div><br></div><div>A third problem is that I can't seem to get RT to run when I first start apache. I get:</div><div><br></div><div></div></div><span class="Apple-tab-span" style="white-space:pre"> </span>mkdir /opt/rt4/var/mason_data/obj/3452818388: Permission denied at /usr/local/share/perl5/HTML/Mason/Compiler/ToObject.pm line 107<div><br></div><div>Looks like the various directories were created as root:</div><div><br></div><div><div>[root@rt rt-4.0.0rc5]# ls -al /opt/rt4/var/mason_data/</div><div>total 16</div><div>drwxrwx---. 4 apache apache 4096 Feb 18 20:21 .</div><div>drwxr-xr-x. 5 root root 4096 Feb 18 17:50 ..</div><div>drwxr-xr-x. 2 root root 4096 Feb 18 19:41 cache</div><div>drwxr-xr-x. 2 root root 4096 Feb 18 20:21 obj</div><div>[root@rt rt-4.0.0rc5]# </div></div><div><br></div><div>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:</div><div><br></div><div><div>[root@rt rt-4.0.0rc5]# ls -al /opt/rt4/var/mason_data/</div><div>total 12</div><div>drwxrwx---. 3 apache apache 4096 Feb 18 20:25 .</div><div>drwxr-xr-x. 5 root root 4096 Feb 18 17:50 ..</div><div>drwxr-xr-x. 3 apache apache 4096 Feb 18 20:25 obj</div><div>[root@rt rt-4.0.0rc5]# </div><div><div><br></div><div>and the site loads. Still can't login tho.</div><div><br></div><div><div>Feb 18 20:12:24 rt RT: FAILED LOGIN for root from ##.##.##.## (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:605)</div><div>Feb 18 20:12:37 rt RT: FAILED LOGIN for root from ##.##.##.##(/opt/rt4/sbin/../lib/RT/Interface/Web.pm:605)</div><div>Feb 18 20:13:08 rt RT: FAILED LOGIN for root from ##.##.##.## (/opt/rt4/sbin/../lib/RT/Interface/Web.pm:605)</div></div><div><br></div><div><br></div><div>Help?</div><div><br></div><div>-d</div><div><br></div></div></div></body></html>