<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>I'd certainly be interested in what changes (if any) were made in session handling 3.8.0 -> 3.8.1</div><br><div><div>On 2. sep.. 2008, at 18.13, Trenton Taylor wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>I went back to 3.8.0 and everything is working fine ... Do you think<br>there is any problem with running 3.8.0 against a 3.8.1 database<br>upgrade? I didn't restore back to my 3.8.0 database because I'll lose a<br>couple hundred tickets ... <br><br>Not sure what to do but I think you guys are in the same place I am.<br><br>Thanks,<br>Trent<br><br>-----Original Message-----<br>From: <a href="mailto:rt-users-bounces@lists.bestpractical.com">rt-users-bounces@lists.bestpractical.com</a><br>[<a href="mailto:rt-users-bounces@lists.bestpractical.com">mailto:rt-users-bounces@lists.bestpractical.com</a>] On Behalf Of Marco<br>Avvisano<br>Sent: Tuesday, September 02, 2008 3:52 AM<br>To: Chris Searle; <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>Subject: Re: [rt-users] RT requiring login for every click<br><br>this my describe table output:<br><br> id | varchar(32) | | PRI | | |<br>| a_session | longtext | YES | | NULL | |<br>| LastUpdated | timestamp | YES | | CURRENT_TIMESTAMP |<br><br><br>and show create table:<br><br>| sessions | CREATE TABLE `sessions` (<br> `id` varchar(32) NOT NULL default '',<br> `a_session` longtext,<br> `LastUpdated` timestamp NOT NULL default CURRENT_TIMESTAMP on update <br>CURRENT_TIMESTAMP,<br> PRIMARY KEY (`id`)<br>) ENGINE=MyISAM DEFAULT CHARSET=latin1 |<br><br>There is wrong vlaues?<br><br>M.<br><br><br><br><br>*************************************************************<br>Marco Avvisano<br>Regione Toscana - Giunta Regionale<br>Direzione Generale Organizzazione - Servizio I.I.T.R.<br>Via di Novoli, 26 - 50127 Firenze (Italy)<br>Tel. +39.055.438.3809 - Fax +39.055.438.5101<br>e-mail: <a href="mailto:m.avvisano@regione.toscana.it">m.avvisano@regione.toscana.it</a><br>*************************************************************<br>----- Original Message ----- <br>From: "Chris Searle" <<a href="mailto:chris+lists@chrissearle.org">chris+lists@chrissearle.org</a>><br>To: <<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><br>Sent: Monday, September 01, 2008 10:43 PM<br>Subject: Re: [rt-users] RT requiring login for every click<br><br><br><blockquote type="cite"><br></blockquote><blockquote type="cite">On 31. aug.. 2008, at 11.39, Chris Searle wrote:<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">there are some DB maintenance scripts you need to run. read the<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><blockquote type="cite">install README file. this happened to me, too :)<br></blockquote></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">Do you recall which ones?<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">After running make upgrade from 3.8.0 to 3.8.1 I ran<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">--action upgrade<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">And when asked - entered 3.8.0 as the version being upgraded from.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">However - I'm still getting asked to login for most clicks.<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite"><br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">I'm a little confused as to what maintenance script didn't get run<br></blockquote></blockquote><blockquote type="cite"><blockquote type="cite">here.<br></blockquote></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Been digging here - still not getting anywhere.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Checked the sessions table structure -<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">CREATE TABLE sessions (<br></blockquote><blockquote type="cite"> id char(32) NOT NULL,<br></blockquote><blockquote type="cite"> a_session longtext,<br></blockquote><blockquote type="cite"> LastUpdated timestamp NOT NULL default CURRENT_TIMESTAMP on update<br></blockquote><blockquote type="cite">CURRENT_TIMESTAMP,<br></blockquote><blockquote type="cite"> PRIMARY KEY (id) )<br></blockquote><blockquote type="cite">ENGINE=InnoDB DEFAULT CHARSET=latin1;<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">which looks very similar to etc/schema.mysql<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">CREATE TABLE sessions (<br></blockquote><blockquote type="cite"> id char(32) NOT NULL,<br></blockquote><blockquote type="cite"> a_session LONGTEXT,<br></blockquote><blockquote type="cite"> LastUpdated TIMESTAMP,<br></blockquote><blockquote type="cite"> PRIMARY KEY (id)<br></blockquote><blockquote type="cite">);<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">The table was originally MyISAM (was the only one that was) - changed<br></blockquote><blockquote type="cite">it to InnoDB on the offchance - made no difference in behaviour.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Its odd - here's an example.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Login - you're logged in<br></blockquote><blockquote type="cite">Click 'Tickets' - you get the tickets query form<br></blockquote><blockquote type="cite">Choose an owner and hit 'add these terms' - you get to the login<br></blockquote>screen<br><blockquote type="cite">Login again - you get to the tickets form _with_ the query updated.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">I've tried clearing the old session table (well - dumping it to disk<br></blockquote><blockquote type="cite">then truncating it) - no change.<br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">The 3.8.0 backup - that works fine with no issues.<br></blockquote><blockquote type="cite">_______________________________________________<br></blockquote><blockquote type="cite"><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br></blockquote><blockquote type="cite">Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite"><br></blockquote><blockquote type="cite">Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br></blockquote><blockquote type="cite">Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a> <br></blockquote><br>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>Commercial support: <a href="mailto:sales@bestpractical.com">sales@bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media. <br>Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br><br><br>No virus found in this incoming message.<br>Checked by AVG - <a href="http://www.avg.com">http://www.avg.com</a> <br>Version: 8.0.169 / Virus Database: 270.6.14/1646 - Release Date:<br>2008-09-01 6:03 PM<br><br>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. <br><br></div></blockquote></div><br></body></html>