Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 131399 - www-apps/rt-3.4.5 requiring relogin repeatedly.
Summary: www-apps/rt-3.4.5 requiring relogin repeatedly.
Status: RESOLVED UPSTREAM
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: High major (vote)
Assignee: Renat Lumpau (RETIRED)
URL:
Whiteboard:
Keywords:
: 140768 (view as bug list)
Depends on:
Blocks:
 
Reported: 2006-04-26 19:37 UTC by Ted Serreyn
Modified: 2007-12-27 21:43 UTC (History)
4 users (show)

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Ted Serreyn 2006-04-26 19:37:36 UTC
www-apps/rt-3.4.5 requiring recuring login after clicking on any link.  I presume this is due to an update in mason or other component.  emerge -u sync; emerge -u world done regularly so packages are fairly up to date.  Since 4/15 or later this problem now occurs.

Ted



 emerge --info 
Portage 2.0.54 (default-linux/x86/2005.0, gcc-3.4.5, glibc-2.3.6-r3, 2.6.16-gentoo-r3 i686)
=================================================================
System uname: 2.6.16-gentoo-r3 i686 Intel(R) Pentium(R) 4 CPU 3.00GHz
Gentoo Base System version 1.6.14
dev-lang/python:     2.3.5-r2, 2.4.2
sys-apps/sandbox:    1.2.12
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1
sys-devel/binutils:  2.16.1
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O3 -mcpu=pentium4 -funroll-loops -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.4/env /usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3/share/config /usr/lib/X11/xkb /usr/share/config /var/bind /var/qmail/control"
CONFIG_PROTECT_MASK="/etc/eselect/compiler /etc/gconf /etc/terminfo /etc/env.d"
CXXFLAGS="-O3 -mcpu=pentium4 -funroll-loops -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks sandbox sfperms strict"
GENTOO_MIRRORS="http://gentoo.chem.wisc.edu/gentoo http://gentoo.oregonstate.edu http://www.ibiblio.org/pub/Linux/distributions/gentoo"
MAKEOPTS="-j3"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://199.171.86.153/gentoo-portage/"
USE="x86 X alsa apache2 apm arts audiofile avi berkdb bitmap-fonts bzip2 cli crypt cups curl dri eds emboss encode expat ffmpeg foomaticdb fortran gd gdbm gif gmp gnome gpm gstreamer gtk gtk2 imagemagick imap imlib innodb ipv6 isdnlog java jpeg kde lcms ldap libg++ libwww mad maildir mhash mikmod milter mng motif mp3 mpeg mysql ncurses nls ogg oggvorbis opengl oss pam pcre pdflib perl php png postgres pppd python qt quicktime readline reflection sasl sdl session snmp spell spl ssl tcpd tiff truetype truetype-fonts type1-fonts udev usb vorbis xml xml2 xmms xorg xv zlib userland_GNU kernel_linux elibc_glibc"
Unset:  ASFLAGS, CTARGET, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTDIR_OVERLA
Comment 1 Renat Lumpau (RETIRED) gentoo-dev 2006-04-27 04:31:47 UTC
Let's see what the folks over at rt-users have to say.
Comment 2 Renat Lumpau (RETIRED) gentoo-dev 2006-05-15 11:20:40 UTC
Still broken?
Comment 3 Renat Lumpau (RETIRED) gentoo-dev 2006-05-19 06:20:17 UTC
Please reopen if upstream provides any info.
Comment 4 Doug Goldstein (RETIRED) gentoo-dev 2006-05-26 08:48:16 UTC
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.
Comment 5 Richard Hartmann 2006-05-26 10:18:07 UTC
> 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
Comment 6 Doug Goldstein (RETIRED) gentoo-dev 2006-05-26 11:11:48 UTC
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.
Comment 7 Richard Hartmann 2006-05-26 11:13:53 UTC
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.
Comment 8 Richard Hartmann 2006-05-26 11:14:52 UTC
Seems we posted at the same time ;)
Comment 9 Rob Terhaar 2006-07-06 11:44:41 UTC
(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. 
Comment 10 Renat Lumpau (RETIRED) gentoo-dev 2006-07-17 12:12:34 UTC
*** Bug 140768 has been marked as a duplicate of this bug. ***
Comment 11 Wulf Krueger (RETIRED) gentoo-dev 2006-11-17 03:39:14 UTC
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;
Comment 12 Cheng Zhang 2007-03-14 03:52:39 UTC
Just FYI, this problem still exists in 3.6.3.