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

[Don Beethe]

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:jesse at bestpractical.com] 
Sent: July 12, 2006 10:22 AM
To: Kaylea Hascall
Cc: rt-users at lists.bestpractical.com; Don Beethe; egunnett at qualcomm.com
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  
> 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
>