3.6 continual re-login issue

Jesse Vincent wrote:

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;

This fixes the issue for me.

Had my DBA change the field to an CLOB, since I’m using Oracle and I’m
still experiencing the problem…
Seems when I first login, if I click Edit on the “RT at a glance” line,
and then return to the home page, everything is fine… No request to
login again…

At Monday 7/24/2006 12:04 PM, Don Beethe wrote:

Had my DBA change the field to an CLOB, since I’m using Oracle and I’m
still experiencing the problem…
Seems when I first login, if I click Edit on the “RT at a glance” line,
and then return to the home page, everything is fine… No request to
login again…

For the record, we are using file-based session control, so the data
type of the field in the sessions table won’t have any effect for us (I think).

Steve

Steven,

I just tried this fix, and it also worked flawlessly for me! I’m
running 3.6.0. Thanks a bunch, as I was about out of hair to pull out :slight_smile:

Regards,
Bryce Porter
ShellShark Networks
Owner
ShellShark Networks
151 Shadoway Dr.
East Peoria, IL 61611

p. 309.698.5584 x103
f. 425.606.3294
e. bryce@shellshark.net
w. www.shellshark.netOn Jul 24, 2006, at 6:18 AM, Steven Coutts wrote:

Jesse Vincent wrote:

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;

This fixes the issue for me.


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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://
Careers — Best Practical Solutions

Steve, Don,

Can the two of you give 3.6.1rc1 a shot and see if it solves the
problem for you?

Thanks,
JesseOn Jul 24, 2006, at 9:14 AM, Stephen Turner wrote:

At Monday 7/24/2006 12:04 PM, Don Beethe wrote:

Had my DBA change the field to an CLOB, since I’m using Oracle and
I’m
still experiencing the problem…
Seems when I first login, if I click Edit on the “RT at a glance”
line,
and then return to the home page, everything is fine… No request to
login again…

For the record, we are using file-based session control, so the
data type of the field in the sessions table won’t have any effect
for us (I think).

Steve


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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://
Careers — Best Practical Solutions

PGP.sig (186 Bytes)

It worked…
Thank you for this excellent product.From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: July 24, 2006 15:25 PM
To: Stephen Turner
Cc: Don Beethe; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] 3.6 continual re-login issue [A Fix!]

Steve, Don,

Can the two of you give 3.6.1rc1 a shot and see if it solves the problem
for you?

Thanks,
Jesse

At Monday 7/24/2006 05:24 PM, Jesse Vincent wrote:

Steve, Don,

Can the two of you give 3.6.1rc1 a shot and see if it solves the
problem for you?

Thanks,
Jesse

Hi Jesse,

I’d love to try, but unfortunately I’m not able to do that in the
near future. For us the problem only occurs in the production
environment (Solaris), and it will take some time to arrange to get a
second RT instance up there. Strangely, on our test/dev machine
(RHEL), where I can install 3.6, the system works flawlessly.

Would it be possible for you to describe the fix? Is it feasible to
apply it to the 3.4 series?

Thanks,
Steve

This version has gone from continual to only the first page after RT at
a glance page.
Seems once I login and select either a ticket or a queue from the Quick
Search, it returns me to the login. I login and it displays the page.
Then I can click home and get back to the home page and then go thru the
ticket or Quick search and get the page.From: Jesse Vincent [mailto:jesse@bestpractical.com]
Sent: July 24, 2006 15:25 PM
To: Stephen Turner
Cc: Don Beethe; rt-users@lists.bestpractical.com
Subject: Re: [rt-users] 3.6 continual re-login issue [A Fix!]

Steve, Don,

Can the two of you give 3.6.1rc1 a shot and see if it solves the problem
for you?

Thanks,
Jesse

Finally managed to get this fixed…
We have a local copy of autohandler with ldap integration. Went thru the
ldap portion and made some changes in it and now everything is working.
Seems the problem was caused by the way I had to set up our database
lookup versus the way corporate rt set up theirs.

Thanks for all the help Jesse…

I’m running RT 3.6.1rc2 on

Mac OS X 10.4 server
perl 5.8.6
apache
Oracle 9i
using LDAP integration

I started with upgrading 3.4.5 to 3.6 and had the continual login issue.
I found the discussion on the list and downloaded and ran the upgrade
with 3.6.1rc2. Now I appear to be at the point described below.

This version has gone from continual to only the first page after RT at
a glance page.
Seems once I login and select either a ticket or a queue from the Quick
Search, it returns me to the login. I login and it displays the page.
Then I can click home and get back to the home page and then go thru the
ticket or Quick search and get the page.

Then I saw this:

Finally managed to get this fixed…
We have a local copy of autohandler with ldap integration. Went thru the
ldap portion and made some changes in it and now everything is working.
Seems the problem was caused by the way I had to set up our database
lookup versus the way corporate rt set up theirs.

Thanks for all the help Jesse…

Could someone share the changes to the LDAP integration (or point me to
another post I may have missed)?

We’re using the /local/lib/RT/User_Local.pm version and we don’t have an
autohandler.

Thanks,
Jim

Jim Brandt
Administrative Computing Services
University at Buffalo

Hello!On 8/4/06, Jim Brandt cbrandt@buffalo.edu wrote:

Then I saw this:

Finally managed to get this fixed…
We have a local copy of autohandler with ldap integration. Went thru the
ldap portion and made some changes in it and now everything is working.
Seems the problem was caused by the way I had to set up our database
lookup versus the way corporate rt set up theirs.

Thanks for all the help Jesse…

Could someone share the changes to the LDAP integration (or point me to
another post I may have missed)?

We’re using the /local/lib/RT/User_Local.pm version and we don’t have an
autohandler.

I probably misread this originally; I took it to mean they’d localized
the autohandler and done their own LDAP integration. If in fact it’s
changes to the autohandler callback, it’d be great to know what tweaks
were required.

Thanks!

–j
Jim Meyer, Geek at Large purp@acm.org

I diff’ed our local autohandler and the 3.6 autohandler and copied in
the changes required for our LDAP. Seems it did and didn’t fix the
problem. Now it is only forcing a re-login the first time and then only
when a user opens a fresh browser instance. If the browser has a cookie
set, it doesn’t happen.
I’m still trying to figure out what the conditions are that causes this
as my users want to upgrade, but not if until this is fixed.
Beginning to wonder if it is related to Oracle database, since several
who have reported this have also mentioned Oracle database in use.

Message: 5Date: Mon, 7 Aug 2006 19:53:18 -0400
From: “Jim Meyer” purp@acm.org
Subject: Re: [rt-users] 3.6 continual re-login issue
To: “Jim Brandt” cbrandt@buffalo.edu
Cc: rt-users@lists.bestpractical.com
Message-ID:
c09f2f8a0608071653r109f0e30j3f5deb3665a96885@mail.gmail.com
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hello!

Then I saw this:

Finally managed to get this fixed…
We have a local copy of autohandler with ldap integration. Went thru

the ldap portion and made some changes in it and now everything is
working.
Seems the problem was caused by the way I had to set up our database

lookup versus the way corporate rt set up theirs.

Thanks for all the help Jesse…

Could someone share the changes to the LDAP integration (or point me
to another post I may have missed)?

We’re using the /local/lib/RT/User_Local.pm version and we don’t have
an autohandler.

I probably misread this originally; I took it to mean they’d localized
the autohandler and done their own LDAP integration. If in fact it’s
changes to the autohandler callback, it’d be great to know what tweaks
were required.

Thanks!

–j
Jim Meyer, Geek at Large purp@acm.org