Recurring signin with 3.6.4

RT Users
1

To all,

I read about this bug in 3.6.0 and I waited until 3.6.4 before

downloading the newest version (3.6.4). Either I missed a module or a
patch or something because RT keeps making sign-in a second time the
moment I select something from the menu after my initial sign-in. I went
looking for this error and I’m afraid that the patch is so far removed
from today that I just can’t seem to find it. Has anyone else had
difficulty with a recurring sign-in on RT 3.6.4? Anyone have an idea as
to what I may have NOT downloaded? OR a task I missed? Thanks.

Kenn
LBNL

2

Ken,

We are on 3.6.4 are occasionally have the same problem. We write our
session data to disk rather than the hard drive. It seems that when the
repeated sign on problem occurs, the session data didn’t get properly
written. It’s a bit annoying, but usually after your second sign on it
goes away. Sometimes it takes several tries.

At this point, I’m not quite sure if there is a solution or what could
be causing it. Write contention in the sessions folder perhaps?

I know this doesn’t solve your problem, but maybe it’s a little
reassuring that you’re not the only one.

Craig Patterson
NGIT/City of Grand Rapids-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Tuesday, December 04, 2007 7:02 PM
To: rt Users
Subject: [rt-users] Recurring signin with 3.6.4

To all,

I read about this bug in 3.6.0 and I waited until 3.6.4 before

downloading the newest version (3.6.4). Either I missed a module or a
patch or something because RT keeps making sign-in a second time the
moment I select something from the menu after my initial sign-in. I went

looking for this error and I’m afraid that the patch is so far removed
from today that I just can’t seem to find it. Has anyone else had
difficulty with a recurring sign-in on RT 3.6.4? Anyone have an idea as
to what I may have NOT downloaded? OR a task I missed? Thanks.

Kenn
LBNL

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

3

Craig and Kenn,

I am curious. What are your reasons for storing the session information
in a file and not in the database?

Cheers,
Ken MarshallOn Wed, Dec 05, 2007 at 07:44:33AM -0500, Patterson, Craig wrote:

Ken,

We are on 3.6.4 are occasionally have the same problem. We write our
session data to disk rather than the hard drive. It seems that when the
repeated sign on problem occurs, the session data didn’t get properly
written. It’s a bit annoying, but usually after your second sign on it
goes away. Sometimes it takes several tries.

At this point, I’m not quite sure if there is a solution or what could
be causing it. Write contention in the sessions folder perhaps?

I know this doesn’t solve your problem, but maybe it’s a little
reassuring that you’re not the only one.

Craig Patterson
NGIT/City of Grand Rapids

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Tuesday, December 04, 2007 7:02 PM
To: rt Users
Subject: [rt-users] Recurring signin with 3.6.4

To all,

I read about this bug in 3.6.0 and I waited until 3.6.4 before
downloading the newest version (3.6.4). Either I missed a module or a
patch or something because RT keeps making sign-in a second time the
moment I select something from the menu after my initial sign-in. I went

looking for this error and I’m afraid that the patch is so far removed
from today that I just can’t seem to find it. Has anyone else had
difficulty with a recurring sign-in on RT 3.6.4? Anyone have an idea as
to what I may have NOT downloaded? OR a task I missed? Thanks.

Kenn
LBNL

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

4

I can’t speak for Kenn, he never mentions that he stores his session
data on his servers hard drive.

As for me, there’s no specific reason we store it on the drive rather
than in the database. When my predecessor installed 3.4.2 a couple of
years ago, he set it up that way. When I upgraded a few months ago to
3.6.4, I left it as it was.

That said, to me, it seems overkill to save session data in the db. In
my two years as RT admin, I’ve never had to go back and look up old
session data.

Perhaps someone else can answer whether or not there is an advantage to
one way or another.

CraigFrom: Kenneth Marshall [mailto:ktm@rice.edu]
Sent: Wednesday, December 05, 2007 8:50 AM
To: Patterson, Craig
Cc: Kenneth Crocker; rt Users
Subject: Re: [rt-users] Recurring signin with 3.6.4

Craig and Kenn,

I am curious. What are your reasons for storing the session information
in a file and not in the database?

Cheers,
Ken Marshall

Ken,

We are on 3.6.4 are occasionally have the same problem. We write our
session data to disk rather than the hard drive. It seems that when
the
repeated sign on problem occurs, the session data didn’t get properly
written. It’s a bit annoying, but usually after your second sign on
it
goes away. Sometimes it takes several tries.

At this point, I’m not quite sure if there is a solution or what could
be causing it. Write contention in the sessions folder perhaps?

I know this doesn’t solve your problem, but maybe it’s a little
reassuring that you’re not the only one.

Craig Patterson
NGIT/City of Grand Rapids

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Tuesday, December 04, 2007 7:02 PM
To: rt Users
Subject: [rt-users] Recurring signin with 3.6.4

To all,

I read about this bug in 3.6.0 and I waited until 3.6.4 before
downloading the newest version (3.6.4). Either I missed a module or a
patch or something because RT keeps making sign-in a second time the
moment I select something from the menu after my initial sign-in. I
went

looking for this error and I’m afraid that the patch is so far removed

from today that I just can’t seem to find it. Has anyone else had
difficulty with a recurring sign-in on RT 3.6.4? Anyone have an idea
as
to what I may have NOT downloaded? OR a task I missed? Thanks.

Kenn
LBNL

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

5

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1On 2007-Dec-05, at 08:49, Kenneth Marshall wrote:

Craig and Kenn,

I am curious. What are your reasons for storing the session
information
in a file and not in the database?

I’m not sure about Craig and Kenn, but we’re using local files for
session data because the database didn’t work. I posted a few
messages about that a couple of weeks ago, but didn’t find any
solutions to the problem. We were seeing something similar to Kenn…
basically, people would be logged out randomly as RT failed to get
their current session cookie from the database.

http://lists.bestpractical.com/pipermail/rt-users/2007-November/
048776.html

Matt

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (Darwin)

iD8DBQFHVusomFeRJ0tjIxERAhi/AJ9i/GqGsf7+O+ePqf3SQLt4si3PBACbBxMY
3ft9zjRzzM4mK/5yM4AWh3U=
=l16U
-----END PGP SIGNATURE-----

6

Craig,

Thanks. I appreciate it.

Kenn
LBNLOn 12/5/2007 4:44 AM, Patterson, Craig wrote:

Ken,

We are on 3.6.4 are occasionally have the same problem. We write our
session data to disk rather than the hard drive. It seems that when the
repeated sign on problem occurs, the session data didn’t get properly
written. It’s a bit annoying, but usually after your second sign on it
goes away. Sometimes it takes several tries.

At this point, I’m not quite sure if there is a solution or what could
be causing it. Write contention in the sessions folder perhaps?

I know this doesn’t solve your problem, but maybe it’s a little
reassuring that you’re not the only one.

Craig Patterson
NGIT/City of Grand Rapids

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Tuesday, December 04, 2007 7:02 PM
To: rt Users
Subject: [rt-users] Recurring signin with 3.6.4

To all,

I read about this bug in 3.6.0 and I waited until 3.6.4 before
downloading the newest version (3.6.4). Either I missed a module or a
patch or something because RT keeps making sign-in a second time the
moment I select something from the menu after my initial sign-in. I went

looking for this error and I’m afraid that the patch is so far removed
from today that I just can’t seem to find it. Has anyone else had
difficulty with a recurring sign-in on RT 3.6.4? Anyone have an idea as
to what I may have NOT downloaded? OR a task I missed? Thanks.

Kenn
LBNL

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

7

Kenneth,

We are on Oracle 9 (soon going to 10) and RT doesn't seem to work well

with Oracle for sessions. So we use the “file” method for storing. I
would love to hear from anyone using Oracle on how they deal with the
sessions table problem.

Kenn
LBNLOn 12/5/2007 5:49 AM, Kenneth Marshall wrote:

Craig and Kenn,

I am curious. What are your reasons for storing the session information
in a file and not in the database?

Cheers,
Ken Marshall

On Wed, Dec 05, 2007 at 07:44:33AM -0500, Patterson, Craig wrote:

Ken,

We are on 3.6.4 are occasionally have the same problem. We write our
session data to disk rather than the hard drive. It seems that when the
repeated sign on problem occurs, the session data didn’t get properly
written. It’s a bit annoying, but usually after your second sign on it
goes away. Sometimes it takes several tries.

At this point, I’m not quite sure if there is a solution or what could
be causing it. Write contention in the sessions folder perhaps?

I know this doesn’t solve your problem, but maybe it’s a little
reassuring that you’re not the only one.

Craig Patterson
NGIT/City of Grand Rapids

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Tuesday, December 04, 2007 7:02 PM
To: rt Users
Subject: [rt-users] Recurring signin with 3.6.4

To all,

I read about this bug in 3.6.0 and I waited until 3.6.4 before
downloading the newest version (3.6.4). Either I missed a module or a
patch or something because RT keeps making sign-in a second time the
moment I select something from the menu after my initial sign-in. I went

looking for this error and I’m afraid that the patch is so far removed
from today that I just can’t seem to find it. Has anyone else had
difficulty with a recurring sign-in on RT 3.6.4? Anyone have an idea as
to what I may have NOT downloaded? OR a task I missed? Thanks.

Kenn
LBNL

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

8

Craig,

My situation is the same as yours. We've been storing our session data

on file for a couple years now, since 3.4.4. IS there anyone out there
using ORACLE that has this problem?

Kenn
LBNLOn 12/5/2007 6:20 AM, Patterson, Craig wrote:

I can’t speak for Kenn, he never mentions that he stores his session
data on his servers hard drive.

As for me, there’s no specific reason we store it on the drive rather
than in the database. When my predecessor installed 3.4.2 a couple of
years ago, he set it up that way. When I upgraded a few months ago to
3.6.4, I left it as it was.

That said, to me, it seems overkill to save session data in the db. In
my two years as RT admin, I’ve never had to go back and look up old
session data.

Perhaps someone else can answer whether or not there is an advantage to
one way or another.

Craig

-----Original Message-----
From: Kenneth Marshall [mailto:ktm@rice.edu]
Sent: Wednesday, December 05, 2007 8:50 AM
To: Patterson, Craig
Cc: Kenneth Crocker; rt Users
Subject: Re: [rt-users] Recurring signin with 3.6.4

Craig and Kenn,

I am curious. What are your reasons for storing the session information
in a file and not in the database?

Cheers,
Ken Marshall

On Wed, Dec 05, 2007 at 07:44:33AM -0500, Patterson, Craig wrote:

Ken,

We are on 3.6.4 are occasionally have the same problem. We write our
session data to disk rather than the hard drive. It seems that when
the
repeated sign on problem occurs, the session data didn’t get properly
written. It’s a bit annoying, but usually after your second sign on
it
goes away. Sometimes it takes several tries.

At this point, I’m not quite sure if there is a solution or what could
be causing it. Write contention in the sessions folder perhaps?

I know this doesn’t solve your problem, but maybe it’s a little
reassuring that you’re not the only one.

Craig Patterson
NGIT/City of Grand Rapids

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Tuesday, December 04, 2007 7:02 PM
To: rt Users
Subject: [rt-users] Recurring signin with 3.6.4

To all,

I read about this bug in 3.6.0 and I waited until 3.6.4 before
downloading the newest version (3.6.4). Either I missed a module or a
patch or something because RT keeps making sign-in a second time the
moment I select something from the menu after my initial sign-in. I
went
looking for this error and I’m afraid that the patch is so far removed

from today that I just can’t seem to find it. Has anyone else had
difficulty with a recurring sign-in on RT 3.6.4? Anyone have an idea
as
to what I may have NOT downloaded? OR a task I missed? Thanks.

Kenn
LBNL

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

9

Kenneth Crocker wrote:

Kenneth,

We are on Oracle 9 (soon going to 10) and RT doesn't seem to work

well with Oracle for sessions. So we use the “file” method for storing.
I would love to hear from anyone using Oracle on how they deal with the
sessions table problem.

Kenn
LBNL

Craig and Kenn,

I am curious. What are your reasons for storing the session information
in a file and not in the database?

We tried it too, storing in the db, using Oracle XE (10g) but it doesn’t
work somehow.
Since storing on disk does work and having a cron entry removing
everything older than a couple of days I don’t mind being those files on
disk. There isn’t any data in it which needs to be backuped up so I let
it be.

Joop

10

Joop,

Thanks. We are currently doing the same thing you are (storing session

on disk), yet I am still getting the two-time loop for sign-ins. What
did you do to resolve the cookie problem, if you had one? If you didn’t
have a cookie problem, then I still can’t figure out what is causing the
double sign-in. What were you’re setup procedures/parameters for storing
session data to file? It perplexes me.
I was looking thru the archives and the causes seemed to be in two
camps: 1) the DB camp - whereas an alter for the sessions table to
CLOB/ORACLE or LONGBLOB/MySQL seemed to work and 2) the store to file
camp - which listed various causes such as FireFox/cookies/expire date
on cookies/clearing cookies and possibly binary data corruption.
At this point, I feel the need to ask Jesse what your technical guys
have found out about this problem in relation to ORACLE and/or FireFox?
Did this happen for ORACLE users in 3.6.1 thru 3.6.3? If not, what does
3.6.4 do differently that may cause this? This is critical to our
getting 3.6.4 into production. Any help here would be greatly
appreciated. Thanks.

Kenn
LBNLOn 12/6/2007 1:09 AM, Joop van de Wege wrote:

Kenneth Crocker wrote:

Kenneth,

We are on Oracle 9 (soon going to 10) and RT doesn't seem to work

well with Oracle for sessions. So we use the “file” method for
storing. I would love to hear from anyone using Oracle on how they
deal with the sessions table problem.

Kenn
LBNL

On 12/5/2007 5:49 AM, Kenneth Marshall wrote:

Craig and Kenn,

I am curious. What are your reasons for storing the session information
in a file and not in the database?

We tried it too, storing in the db, using Oracle XE (10g) but it doesn’t
work somehow.
Since storing on disk does work and having a cron entry removing
everything older than a couple of days I don’t mind being those files on
disk. There isn’t any data in it which needs to be backuped up so I let
it be.

Joop

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll take
up to 20 percent off the price. This sale won’t last long, so get in
touch today. Email us at sales@bestpractical.com or call us at +1 617
812 0745.

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

11

Kenn,

I don’t think it’s a cookie issue. What we noticed was that the session
file on the server that the cookie referred to didn’t have its
attributes filled in. So, I believe the problem is that sometimes the
session file fails to fully write. When we’ve looked at a file for a
session that didn’t have the repeated login problem, it has the binary
data followed by attributes, ie, username, etc. When we looked at the
session file for when we did have the repeated login issue, it only has
binary data filled in.

What you can do to verify this is, first, look at the cookie of a
repeated login session to get its session id. Then look that at the
corresponding session file in the rthome/var/session folder.

I’ve attached an example of a good and a bad session file. They are
binary files, I looked at them with vi on linux and notepad in windows.

Craig Patterson
NGIT/City of Grand RapidsFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Thursday, December 06, 2007 12:45 PM
To: Joop van de Wege
Cc: rt Users
Subject: Re: [rt-users] Recurring signin with 3.6.4

Joop,

Thanks. We are currently doing the same thing you are (storing

session
on disk), yet I am still getting the two-time loop for sign-ins. What
did you do to resolve the cookie problem, if you had one? If you didn’t
have a cookie problem, then I still can’t figure out what is causing the

double sign-in. What were you’re setup procedures/parameters for storing

session data to file? It perplexes me.
I was looking thru the archives and the causes seemed to be in
two
camps: 1) the DB camp - whereas an alter for the sessions table to
CLOB/ORACLE or LONGBLOB/MySQL seemed to work and 2) the store to file
camp - which listed various causes such as FireFox/cookies/expire date
on cookies/clearing cookies and possibly binary data corruption.
At this point, I feel the need to ask Jesse what your technical
guys
have found out about this problem in relation to ORACLE and/or FireFox?
Did this happen for ORACLE users in 3.6.1 thru 3.6.3? If not, what does
3.6.4 do differently that may cause this? This is critical to our
getting 3.6.4 into production. Any help here would be greatly
appreciated. Thanks.

Kenn
LBNL

Kenneth Crocker wrote:

Kenneth,

We are on Oracle 9 (soon going to 10) and RT doesn't seem to work

well with Oracle for sessions. So we use the “file” method for
storing. I would love to hear from anyone using Oracle on how they
deal with the sessions table problem.

Kenn
LBNL

Craig and Kenn,

I am curious. What are your reasons for storing the session
information
in a file and not in the database?

We tried it too, storing in the db, using Oracle XE (10g) but it
doesn’t
work somehow.
Since storing on disk does work and having a cron entry removing
everything older than a couple of days I don’t mind being those files
on
disk. There isn’t any data in it which needs to be backuped up so I
let
it be.

Joop

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today. Email us at sales@bestpractical.com or call us at +1
617
812 0745.

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

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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

d960b271c4df5258f21681a8da6fdbc2.good (3.04 KB)

d960b271c4df5258f21681a8da6fdbc2.bad (197 Bytes)

12

Craig,

Thanks! REALLY! I'll get on this right away. Hope that's it.

Ken
LBNLOn 12/6/2007 10:24 AM, Patterson, Craig wrote:

Kenn,

I don’t think it’s a cookie issue. What we noticed was that the session
file on the server that the cookie referred to didn’t have its
attributes filled in. So, I believe the problem is that sometimes the
session file fails to fully write. When we’ve looked at a file for a
session that didn’t have the repeated login problem, it has the binary
data followed by attributes, ie, username, etc. When we looked at the
session file for when we did have the repeated login issue, it only has
binary data filled in.

What you can do to verify this is, first, look at the cookie of a
repeated login session to get its session id. Then look that at the
corresponding session file in the rthome/var/session folder.

I’ve attached an example of a good and a bad session file. They are
binary files, I looked at them with vi on linux and notepad in windows.

Craig Patterson
NGIT/City of Grand Rapids

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Kenneth
Crocker
Sent: Thursday, December 06, 2007 12:45 PM
To: Joop van de Wege
Cc: rt Users
Subject: Re: [rt-users] Recurring signin with 3.6.4

Joop,

Thanks. We are currently doing the same thing you are (storing
session
on disk), yet I am still getting the two-time loop for sign-ins. What
did you do to resolve the cookie problem, if you had one? If you didn’t
have a cookie problem, then I still can’t figure out what is causing the

double sign-in. What were you’re setup procedures/parameters for storing

session data to file? It perplexes me.
I was looking thru the archives and the causes seemed to be in
two
camps: 1) the DB camp - whereas an alter for the sessions table to
CLOB/ORACLE or LONGBLOB/MySQL seemed to work and 2) the store to file
camp - which listed various causes such as FireFox/cookies/expire date
on cookies/clearing cookies and possibly binary data corruption.
At this point, I feel the need to ask Jesse what your technical
guys
have found out about this problem in relation to ORACLE and/or FireFox?
Did this happen for ORACLE users in 3.6.1 thru 3.6.3? If not, what does
3.6.4 do differently that may cause this? This is critical to our
getting 3.6.4 into production. Any help here would be greatly
appreciated. Thanks.

Kenn
LBNL

On 12/6/2007 1:09 AM, Joop van de Wege wrote:

Kenneth Crocker wrote:

Kenneth,

We are on Oracle 9 (soon going to 10) and RT doesn't seem to work

well with Oracle for sessions. So we use the “file” method for
storing. I would love to hear from anyone using Oracle on how they
deal with the sessions table problem.

Kenn
LBNL

On 12/5/2007 5:49 AM, Kenneth Marshall wrote:

Craig and Kenn,

I am curious. What are your reasons for storing the session
information
in a file and not in the database?

We tried it too, storing in the db, using Oracle XE (10g) but it
doesn’t
work somehow.
Since storing on disk does work and having a cron entry removing
everything older than a couple of days I don’t mind being those files
on
disk. There isn’t any data in it which needs to be backuped up so I
let
it be.

Joop

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today. Email us at sales@bestpractical.com or call us at +1
617
812 0745.

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

The rt-users Archives

SAVE THOUSANDS OF DOLLARS ON RT SUPPORT:

If you sign up for a new RT support contract before December 31, we’ll
take
up to 20 percent off the price. This sale won’t last long, so get in
touch today.
Email us at sales@bestpractical.com or call us at +1 617 812 0745.

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