[rt-users] RT requiring login for every click

[Marco Avvisano]

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