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

[Roy El-Hames]

Jesse;
my dev system rt-3.6 ,perl, v5.8.8 , apache 2.0.58, dbix 1.43, mysql 
5.0.19 on gentoo system , I had this/similar problem with DBD-mysql 
3.0003, fixed with moving to DBD-mysql 3.0002 .. no sign of this problem 
since..
Roy


Jesse Vincent wrote:
>
> 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
>>
>
> _______________________________________________
> 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
>