[rt-users] RT3.8.8 getting logged out after doing search

[o.nash at cs.ucc.ie]

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
Oliver

On 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 at 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 at 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
-------------------------