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

[Jesse Vincent]

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  
> khascall at uchicago.edu
> 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: sales at 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:// 
> bestpractical.com/about/jobs.html
>