Summary: | www-apps/rt-3.4.5 requiring relogin repeatedly. | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Ted Serreyn <ted> |
Component: | Current packages | Assignee: | Renat Lumpau (RETIRED) <rl03> |
Status: | RESOLVED UPSTREAM | ||
Severity: | major | CC: | d.stefanescu, jesse, philantrop, web-apps |
Priority: | High | ||
Version: | 2006.0 | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- |
Description
Ted Serreyn
2006-04-26 19:37:36 UTC
Let's see what the folks over at rt-users have to say. Still broken? Please reopen if upstream provides any info. the issue is with RT... To fix the login problem change the "a_session" type in the "session" table to LONGBLOB. This will just fix logins... however attachements will still break.. Convert all your tables to latin1_swedish_ci from utf8 and then you'll be all set. > To fix the login problem change the "a_session" type in the "session" table to > LONGBLOB. This will just fix logins... however attachements will still break.. This did not work for me, unfortunately. For people wanting to try this: mysql -u root -p use rt3; ALTER TABLE sessions CHANGE a_session a_session LONGBLOB; > Convert all your tables to latin1_swedish_ci from utf8 and then you'll be all > set. I did that, too. Did not work, either. For people wanting to try this: mysql -u root -p use rt3; show tables; ALTER TABLE $thetables CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci; (Unfortunately, mysql can't do ALTER TABLE (show tables) CONVERT TO CHARACTER SET latin1 COLLATE latin1_swedish_ci;) For further reference, see http://lists.bestpractical.com/pipermail/rt-users/2006-April/038964.html Richard, Well because the old field size was smaller it was trunicating data so you have bad data in your table. So the fix is my comments above then running DELETE FROM session; And clean out the sessions table then it works. I should have mentioned it. Sorry. Seems you need to remove the old session entries from the table after the change. I now have a working RT. Thanks to Doug Goldstein aka Cardoe for that tip! So, the full fix is: mysql -u root -p use rt3; 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; Of course, this will kill all open sessions. Seems we posted at the same time ;) (In reply to comment #7) Richard's long SQL statement fixed my RT w/ mysql 4.1x!! Thanks! So far so good, the RT ebuild worked out well. *** Bug 140768 has been marked as a duplicate of this bug. *** The "a_session" type problem as reported in comment #4 still exists in 3.6.1: CREATE TABLE sessions ( id char(32) NOT NULL, a_session LONGTEXT, LastUpdated TIMESTAMP, PRIMARY KEY (id) ); The fix... ALTER TABLE sessions CHANGE a_session a_session LONGBLOB; delete from sessions; ... works fine but I couldn't find any reference to this on rt-users or elsewhere. Did anyone inform upstream about this? The thread referenced in comment #5 is just about the charset issues (which I never ran into). Furthermore, it seems advisable to change the "Content" type in "Attachments" from LONGTEXT to LONGBLOB as well: ALTER TABLE Attachments CHANGE Content Content LONGBLOB; Just FYI, this problem still exists in 3.6.3. |