[rt-users] 3.6 continual re-login issue [A Fix!]

[Kaylea Hascall]

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:


ALTER TABLE sessions CHANGE a_session a_session LONGBLOB;
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 at uchicago.edu
Technology & Scholarly Computing         http://nsit.uchicago.edu/academic
Assistant Director: Academic Technologies      NSIT, University of Chicago