RT3.8.8 getting logged out after doing search

Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced
and sessions table dropped and re-created from Schema in rt3.sql dump we
are seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.

When browsing tickets from the HOME base list this does not happen.

Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] “GET
/Search/Results.html?Format=’%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’’%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1” 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST /Ticket/Display.html
HTTP/1.1” 200 32802
I have cleared old cookies and caches etc …

Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.

Oliver Nash
CSSG Computer Science UCC

Hi,

RT version? Show us how your new sessions table looks.

SHOW CREATE TABLE sessions;On Fri, Jan 6, 2012 at 15:56, o.nash@cs.ucc.ie wrote:

Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.

When browsing tickets from the HOME base list this does not happen.

Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] “GET
/Search/Results.html?Format=‘%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’‘%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1” 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST /Ticket/Display.html
HTTP/1.1” 200 32802

I have cleared old cookies and caches etc …

Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.


Oliver Nash
CSSG Computer Science UCC


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012

Best regards, Ruslan.

Hi Ruslan,
thanks for your reply. here is the sessions table show.
mysql> show create table sessions;
| Table | Create Table
|
| sessions | CREATE TABLE sessions (
id char(32) NOT NULL,
a_session longtext,
LastUpdated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
1 row in set (0.00 sec)

mysql>
thanks
OliverOn Sun, 8 Jan 2012, Ruslan Zakirov wrote:

Hi,

RT version? Show us how your new sessions table looks.

SHOW CREATE TABLE sessions;

On Fri, Jan 6, 2012 at 15:56, o.nash@cs.ucc.ie wrote:

Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.

When browsing tickets from the HOME base list this does not happen.

Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] “GET
/Search/Results.html?Format=‘%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’‘%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1” 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST /Ticket/Display.html
HTTP/1.1” 200 32802

I have cleared old cookies and caches etc …

Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.


Oliver Nash
CSSG Computer Science UCC


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012


Best regards, Ruslan.

Oliver Nash
CSSG Computer Science UCC

a_session column should be blob not text.On Mon, Jan 9, 2012 at 01:59, o.nash@cs.ucc.ie wrote:

Hi Ruslan,
thanks for your reply. here is the sessions table show.
mysql> show create table sessions;
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sessions | CREATE TABLE sessions (
id char(32) NOT NULL,
a_session longtext,
LastUpdated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>
thanks
Oliver

On Sun, 8 Jan 2012, Ruslan Zakirov wrote:

Hi,

RT version? Show us how your new sessions table looks.

SHOW CREATE TABLE sessions;

On Fri, Jan 6, 2012 at 15:56, o.nash@cs.ucc.ie wrote:

Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced
and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.

When browsing tickets from the HOME base list this does not happen.

Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] "GET

/Search/Results.html?Format=‘%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’‘%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1" 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST
/Ticket/Display.html
HTTP/1.1” 200 32802

I have cleared old cookies and caches etc …

Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.


Oliver Nash
CSSG Computer Science UCC


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012


Best regards, Ruslan.


Oliver Nash
CSSG Computer Science UCC


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston — March 5 & 6, 2012

Best regards, Ruslan.

Thanks
yes I had seen that in a thread on discussion group but was reluctant to
altar anything without a offering from the authers.

Anyway since I have messaed around with sessions table now I tried your
suggestion and that seems to have fixed it.

Thank very much
OliverOn Mon, 9 Jan 2012, Ruslan Zakirov wrote:

a_session column should be blob not text.

On Mon, Jan 9, 2012 at 01:59, o.nash@cs.ucc.ie wrote:

Hi Ruslan,
thanks for your reply. here is the sessions table show.
mysql> show create table sessions;
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sessions | CREATE TABLE sessions (
id char(32) NOT NULL,
a_session longtext,
LastUpdated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
±---------±----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>
thanks
Oliver

On Sun, 8 Jan 2012, Ruslan Zakirov wrote:

Hi,

RT version? Show us how your new sessions table looks.

SHOW CREATE TABLE sessions;

On Fri, Jan 6, 2012 at 15:56, o.nash@cs.ucc.ie wrote:

Dear all,
We recently had a MySQL crash [ due to RAM failure ], after RAM replaced
and
sessions table dropped and re-created from Schema in rt3.sql dump we are
seeing a new problem with searches.
When the search is executed the resulting tickets are displayed fine
but any attempt to open one results in the RT login screen.
If we do login the required ticket is opened.

When browsing tickets from the HOME base list this does not happen.

Here is an example apache log of the above search:
143.239.74.146 - - [06/Jan/2012:11:36:46 +0000] "GET

/Search/Results.html?Format=‘%20%20%20%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__id__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3A%23’%2C%0A’%3Cb%3E%3Ca%20href%3D%22__WebPath__%2FTicket%2FDisplay.html%3Fid%3D__id__%22%3E__Subject__%3C%2Fa%3E%3C%2Fb%3E%2FTITLE%3ASubject’%2C%0A’Status’%2C%0A’QueueName’%2C%0A’OwnerName’%2C%0A’Priority’%2C%0A’NEWLINE’%2C%0A’‘%2C%0A’%3Csmall%3E__Requestors__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__CreatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__ToldRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__LastUpdatedRelative__%3C%2Fsmall%3E’%2C%0A’%3Csmall%3E__TimeLeft__%3C%2Fsmall%3E’&Order=DESC%7CASC%7CASC%7CASC&OrderBy=LastUpdated%7C%7C%7C&Page=1&Query=Status%20%3D%20’new’%20OR%20Status%20%3D%20’open’&RowsPerPage=50&SavedChartSearchId=new&SavedSearchId=
HTTP/1.1" 200 35950
143.239.74.146 - - [06/Jan/2012:11:37:09 +0000] “GET
/Ticket/Display.html?id=16718 HTTP/1.1” 200 5267
143.239.74.146 - - [06/Jan/2012:11:37:25 +0000] “POST
/Ticket/Display.html
HTTP/1.1” 200 32802

I have cleared old cookies and caches etc …

Thanks
Oliver
ubuntu 10.04
perl 5.10.1
apache 2.2.17
mod_perl 2.0.5 [ previously we used mod_perl 2.0.4 ] this is only change
since crash.


Oliver Nash
CSSG Computer Science UCC


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston March 5 & 6, 2012


Best regards, Ruslan.


Oliver Nash
CSSG Computer Science UCC


RT Training Sessions (http://bestpractical.com/services/training.html)

  • Boston — March 5 & 6, 2012


Best regards, Ruslan.

Oliver Nash
CSSG Computer Science UCC