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…From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: July 12, 2006 10:22 AM
To: Kaylea Hascall
Cc: rt-users@lists.bestpractical.com; Don Beethe; egunnett@qualcomm.com
Subject: Re: [rt-users] 3.6 continual re-login issue [A Fix!]
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
khascall@uchicago.edu
Technology & Scholarly Computing http://nsit.uchicago.edu/
academic
Assistant Director: Academic Technologies NSIT, University of
Chicago
The rt-users Archives
Community help: http://wiki.bestpractical.com Commercial support:
sales@bestpractical.com
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://
Careers — Best Practical Solutions