[rt-users] RT requiring login for every click

Chris Searle chris+lists at chrissearle.org
Tue Sep 2 12:34:21 EDT 2008


I'd certainly be interested in what changes (if any) were made in  
session handling 3.8.0 -> 3.8.1

On 2. sep.. 2008, at 18.13, Trenton Taylor wrote:

> I went back to 3.8.0 and everything is working fine ... Do you think
> there is any problem with running 3.8.0 against a 3.8.1 database
> upgrade? I didn't restore back to my 3.8.0 database because I'll  
> lose a
> couple hundred tickets ...
>
> Not sure what to do but I think you guys are in the same place I am.
>
> Thanks,
> Trent
>
> -----Original Message-----
> From: rt-users-bounces at lists.bestpractical.com
> [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Marco
> Avvisano
> Sent: Tuesday, September 02, 2008 3:52 AM
> To: Chris Searle; rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] RT requiring login for every click
>
> this my describe table output:
>
> id          | varchar(32) |      | PRI |                   |       |
> | a_session   | longtext    | YES  |     | NULL              |       |
> | LastUpdated | timestamp   | YES  |     | CURRENT_TIMESTAMP |
>
>
> and show create table:
>
> | sessions | CREATE TABLE `sessions` (
>  `id` varchar(32) NOT NULL default '',
>  `a_session` longtext,
>  `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update
> CURRENT_TIMESTAMP,
>  PRIMARY KEY  (`id`)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
>
> There is wrong vlaues?
>
> M.
>
>
>
>
> *************************************************************
> Marco Avvisano
> Regione Toscana - Giunta Regionale
> Direzione Generale Organizzazione - Servizio I.I.T.R.
> Via di Novoli, 26 - 50127 Firenze (Italy)
> Tel. +39.055.438.3809 - Fax +39.055.438.5101
> e-mail: m.avvisano at regione.toscana.it
> *************************************************************
> ----- Original Message -----
> From: "Chris Searle" <chris+lists at chrissearle.org>
> To: <rt-users at lists.bestpractical.com>
> Sent: Monday, September 01, 2008 10:43 PM
> Subject: Re: [rt-users] RT requiring login for every click
>
>
>>
>> On 31. aug.. 2008, at 11.39, Chris Searle wrote:
>>
>>>> there are some DB maintenance scripts you need to run.  read the
>>>> install README file.  this happened to me, too :)
>>>
>>> Do you recall which ones?
>>>
>>> After running make upgrade from 3.8.0 to 3.8.1 I ran
>>>
>>> /opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password
>>> --action upgrade
>>>
>>> And when asked - entered 3.8.0 as the version being upgraded from.
>>>
>>> However - I'm still getting asked to login for most clicks.
>>>
>>> I'm a little confused as to what maintenance script didn't get run
>>> here.
>>
>> Been digging here - still not getting anywhere.
>>
>> Checked the sessions table structure -
>>
>> 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=InnoDB DEFAULT CHARSET=latin1;
>>
>> which looks very similar to etc/schema.mysql
>>
>> CREATE TABLE sessions (
>>    id char(32) NOT NULL,
>>    a_session LONGTEXT,
>>    LastUpdated TIMESTAMP,
>>    PRIMARY KEY (id)
>> );
>>
>> The table was originally MyISAM (was the only one that was) - changed
>> it to InnoDB on the offchance - made no difference in behaviour.
>>
>> Its odd - here's an example.
>>
>> Login - you're logged in
>> Click 'Tickets' - you get the tickets query form
>> Choose an owner and hit 'add these terms' - you get to the login
> screen
>> Login again - you get to the tickets form _with_ the query updated.
>>
>> I've tried clearing the old session table (well - dumping it to disk
>> then truncating it) - no change.
>>
>> The 3.8.0 backup - that works fine with no issues.
>> _______________________________________________
>> 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
>
> _______________________________________________
> 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
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.169 / Virus Database: 270.6.14/1646 - Release Date:
> 2008-09-01 6:03 PM
>
> Important: The information contained in this e-mail message is  
> confidential and is intended only for the named addressee(s). If the  
> reader of this e-mail message is not an intended recipient (or the  
> individual responsible for the delivery of this e-mail message to an  
> intended recipient), please be advised that any re-use,  
> dissemination, distribution or copying of this e-mail message is  
> prohibited. If you have received this e-mail message in error,  
> please reply to the sender that you have received the message in  
> error and then delete it. Thank you.
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20080902/b9ec4371/attachment.htm>


More information about the rt-users mailing list