I set up an instance of rt 3.4.5 and upgraded it to 3.6 using mysql for the database and it worked just fine... When I tried upgrading another test rt system from 3.4.5 using oracle database to 3.6, it had the continual login issue... I haven't talked to the DBA about this change to see if it clears things up...
BTW, the mysql rt is running on Fedora Core 5, kernel 2.6.16-1.2115_FC4, the oracle rt is running on Solaris 8... -----Original Message----- From: Jesse Vincent [mailto:[EMAIL PROTECTED] Sent: July 12, 2006 10:22 AM To: Kaylea Hascall Cc: [email protected]; Don Beethe; [EMAIL PROTECTED] Subject: Re: [rt-users] 3.6 continual re-login issue [A Fix!] On Jul 12, 2006, at 12:17 PM, Kaylea Hascall wrote: > > Thank you everyone who has e-mailed me off-list about this. The > problem in my case seemed to lie between mysql, mason, and RT. > Changing the character set seems to resolve it [credit here goes to > Freman -- thanks!!]. I'm CC'ing the other people I've seen report this > recently, too. > > Here's the SQL Freman sent me, which solved my problem: I _believe_ that only this statement should be necessary if the issue is what I now believe it to be. > ALTER TABLE sessions CHANGE a_session a_session LONGBLOB; I'd worry a _lot_ about these changes. Setting your characterset to latin1 with swedish collation isn't going to fix things properly, but may mask a number of other issues. We've got a branch of 3.6 with a "proper" fix for these issues (which I presume only manifest on MySQL 5. Would anyone like to confirm or deny that?) > Best, JEsse > ALTER TABLE ACL CONVERT TO CHARACTER SET latin1 COLLATE > latin1_swedish_ci; ALTER TABLE Attachments CONVERT TO CHARACTER SET > latin1 COLLATE latin1_swedish_ci; ALTER TABLE Attributes CONVERT TO > CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE > CachedGroupMembers CONVERT TO CHARACTER SET latin1 COLLATE > latin1_swedish_ci; ALTER TABLE CustomFieldValues CONVERT TO CHARACTER > SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE CustomFields CONVERT > TO CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE > GroupMembers CONVERT TO CHARACTER SET latin1 COLLATE > latin1_swedish_ci; ALTER TABLE Groups CONVERT TO CHARACTER SET latin1 > COLLATE latin1_swedish_ci; ALTER TABLE Links CONVERT TO CHARACTER SET > latin1 COLLATE latin1_swedish_ci; ALTER TABLE ObjectCustomFieldValues > CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE > ObjectCustomFields CONVERT TO CHARACTER SET latin1 COLLATE > latin1_swedish_ci; ALTER TABLE Principals CONVERT TO CHARACTER SET > latin1 COLLATE latin1_swedish_ci; ALTER TABLE Queues CONVERT TO > CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE > ScripActions CONVERT TO CHARACTER SET latin1 COLLATE > latin1_swedish_ci; ALTER TABLE ScripConditions CONVERT TO CHARACTER > SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE Scrips CONVERT TO > CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE Templates > CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci; ALTER TABLE > Tickets CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci; > ALTER TABLE Transactions CONVERT TO CHARACTER SET latin1 COLLATE > latin1_swedish_ci; ALTER TABLE Users CONVERT TO CHARACTER SET latin1 > COLLATE latin1_swedish_ci; ALTER TABLE sessions CONVERT TO CHARACTER > SET latin1 COLLATE latin1_swedish_ci; delete from sessions; > > The suggestions I got also included updating my DBD-mysql driver > (which may have been necessary, but wasn't sufficient to solve my > problem). > > -Kaylea > ----------------- > Kaylea Hascall (773) 834-4117 or > [EMAIL PROTECTED] > Technology & Scholarly Computing http://nsit.uchicago.edu/ > academic > Assistant Director: Academic Technologies NSIT, University of > Chicago > _______________________________________________ > 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 > > > We're hiring! Come hack Perl for Best Practical: http:// > bestpractical.com/about/jobs.html > _______________________________________________ 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 We're hiring! Come hack Perl for Best Practical: http://bestpractical.com/about/jobs.html
