Mailing List Archive: Request Tracker: Users

Cookies Problem with RT 3.8.5

Index | Next | Previous | View Threaded

varun.vyas at elitecore

Nov 4, 2009, 1:49 AM

Post #1 of 3 (130 views)
Permalink

Cookies Problem with RT 3.8.5

Hello All

Yesterday I have upgraded from 3.6.3 to 3.8.5 all has works well. But I m
facing a strange problem for e.g. I have logged with root user and all
operations works fine but when I logged in with other user after logging out
I has got window and all queues which "root user has access". I have checked
credentials of the other user but It was a normal user with no admin
privileges. But still I was able to look in the queues that only admin can
see. Once I have cleared the cache cookies form browser then my normal
user's home page was fine and I can able to see the queue which that user is
supposed to see. But again when I logged in with admin user I was seeing the
queue of my previous user and not been able to see the admin queues. I am
facing this problem with my new installation (i.e. upgradation from 3.6.3 to
3.8.5 ) I have checked all stuffs with my browser but it is fine and also I
have no problem in switching users and I was able to see the home pages of
relevant users when I have used my beta machine having RT 3.6.3 installed

Please can any one suggest me what is problem with my installation .

Thanks & Regards

Varun Vyas

_____

From: Joop [mailto:JoopvandeWege[at]mococo.nl]
Sent: Wednesday, November 04, 2009 1:01 PM
To: Varun
Cc: rt-users[at]lists.bestpractical.com
Subject: Re: [rt-users] Database upgrade issue from RT 3.6.3 to RT 3.8.4

Varun wrote:

Hello Joop

As per your guessing you are right I am facing problem of corruption in sql
query when I upgraded from 3.6.3 to 3.8.6 application is working fine but
when I want to look at page where custom fields are or want to see the page
where tickets basics are there. I am not able to go that page and RT doesn't
seem too returned with that page and goes in unending loop of query firing
and also I get the query which I posted to you which is not firing as per
your suggestion. So can you can help me in how to fix this problem I am not
been able to find any solution for it.

Any help is highly appreciated.

I'm sorry but that is something that changed in RT and I'm not able to help
you there. Basically what I wrote to rt-devel is that probably there is a
mix up in column names and the query should read:

SELECT main.*
FROM Attributes main
WHERE (main.OBJECTID = '221')
AND (main.Name = 'BasedOn')
AND (main.ObjectType = 'RT::CustomField')

instead of:

SELECT main.*
FROM Attributes main
WHERE (main.Content = '221')
AND (main.Name = 'BasedOn')

Regards,

Joop

AND (main.ObjectType = 'RT::CustomField')

ktm at rice

Nov 4, 2009, 5:46 AM

Post #2 of 3 (118 views)
Permalink

Re: Cookies Problem with RT 3.8.5 [In reply to]

On Wed, Nov 04, 2009 at 03:19:44PM +0530, Varun wrote:
> Hello All
>
>
>
> Yesterday I have upgraded from 3.6.3 to 3.8.5 all has works well. But I m
> facing a strange problem for e.g. I have logged with root user and all
> operations works fine but when I logged in with other user after logging out
> I has got window and all queues which "root user has access". I have checked
> credentials of the other user but It was a normal user with no admin
> privileges. But still I was able to look in the queues that only admin can
> see. Once I have cleared the cache cookies form browser then my normal
> user's home page was fine and I can able to see the queue which that user is
> supposed to see. But again when I logged in with admin user I was seeing the
> queue of my previous user and not been able to see the admin queues. I am
> facing this problem with my new installation (i.e. upgradation from 3.6.3 to
> 3.8.5 ) I have checked all stuffs with my browser but it is fine and also I
> have no problem in switching users and I was able to see the home pages of
> relevant users when I have used my beta machine having RT 3.6.3 installed
>
>
>
> Please can any one suggest me what is problem with my installation .
>
>
>
> Thanks & Regards
>
> Varun Vyas
>
Hi Varun,

This sounds very similar to a recent thread. In that case the
problem was caused by an Apache mod_cache module caching cookies
incorrectly. I know they were working on an application change
to address the problem, but disabling the mod_cache module
fixed it immediately. It might be worth a look.

Regards,
Ken

_______________________________________________
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

varun.vyas at elitecore

Nov 4, 2009, 9:14 PM

Post #3 of 3 (113 views)
Permalink

Re: Cookies Problem with RT 3.8.5 [In reply to]

Hello Ken

Thanks for your suggestion. But in my apache I don't have mod_cache module
enabled. It is not there in my DSO libraries also. Any other ideas ??

Thanks
Varun

-----Original Message-----
From: Kenneth Marshall [mailto:ktm[at]rice.edu]
Sent: Wednesday, November 04, 2009 7:17 PM
To: Varun
Cc: 'Joop'; rt-users[at]lists.bestpractical.com
Subject: Re: [rt-users] Cookies Problem with RT 3.8.5

On Wed, Nov 04, 2009 at 03:19:44PM +0530, Varun wrote:
> Hello All
>
>
>
> Yesterday I have upgraded from 3.6.3 to 3.8.5 all has works well. But I m
> facing a strange problem for e.g. I have logged with root user and all
> operations works fine but when I logged in with other user after logging
out
> I has got window and all queues which "root user has access". I have
checked
> credentials of the other user but It was a normal user with no admin
> privileges. But still I was able to look in the queues that only admin can
> see. Once I have cleared the cache cookies form browser then my normal
> user's home page was fine and I can able to see the queue which that user
is
> supposed to see. But again when I logged in with admin user I was seeing
the
> queue of my previous user and not been able to see the admin queues. I am
> facing this problem with my new installation (i.e. upgradation from 3.6.3
to
> 3.8.5 ) I have checked all stuffs with my browser but it is fine and also
I
> have no problem in switching users and I was able to see the home pages of
> relevant users when I have used my beta machine having RT 3.6.3 installed
>
>
>
> Please can any one suggest me what is problem with my installation .
>
>
>
> Thanks & Regards
>
> Varun Vyas
>
Hi Varun,

This sounds very similar to a recent thread. In that case the
problem was caused by an Apache mod_cache module caching cookies
incorrectly. I know they were working on an application change
to address the problem, but disabling the mod_cache module
fixed it immediately. It might be worth a look.

Regards,
Ken

_______________________________________________
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

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com