<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><blockquote type="cite">there are some DB maintenance scripts you need to run. read the install README file. this happened to me, too :)</blockquote><div><br></div><div>Do you recall which ones?</div><div><br></div><div>After running make upgrade from 3.8.0 to 3.8.1 I ran</div><div><br></div><div><span class="Apple-style-span" style="font-family: Arial; font-size: 13px; line-height: 17px; ">/opt/rt3/sbin/rt-setup-database --dba root --prompt-for-dba-password --action upgrade</span></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 17px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 17px;">And when asked - entered 3.8.0 as the version being upgraded from.</span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 17px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 17px;">However - I'm still getting asked to login for most clicks.</span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 17px;"><br></span></font></div><div><font class="Apple-style-span" face="Arial" size="3"><span class="Apple-style-span" style="font-size: 13px; line-height: 17px;">I'm a little confused as to what maintenance script didn't get run here.</span></font></div><br><blockquote type="cite"><br><br>----- Original Message -----<br>From: Marco Avvisano <<a href="mailto:marco.avvisano@regione.toscana.it">marco.avvisano@regione.toscana.it</a>><br>Date: Thursday, August 28, 2008 6:16<br>Subject: Re: [rt-users] RT requiring login for every click<br>To: Ruslan Zakirov <<a href="mailto:ruz@bestpractical.com">ruz@bestpractical.com</a>><br>Cc: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br><br>> <br>> I have the same problem but not for every click<br>> <br>> RT 3.8.1<br>> Mysql 4.1.22<br>> OS: Linux 2.4.21-37.ELsmp<br>> <br>> any suggestions<br>> <br>> thanks<br>> <br>> Marco<br>> <br>> ----- Original Message ----- <br>> From: "Ruslan Zakirov" <<a href="mailto:ruz@bestpractical.com">ruz@bestpractical.com</a>><br>> To: "Mark Hazen" <<a href="mailto:markh@intechgra.com">markh@intechgra.com</a>><br>> Cc: <<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a>><br>> Sent: Wednesday, August 06, 2008 10:34 PM<br>> Subject: Re: [rt-users] RT requiring login for every click<br>> <br>> <br>> >I saw your followups on this issue, but I want to comment this.<br>> > <br>> > Yes, these fixes I was talking about have been integrated into 3.8.0<br>> > and as well several fixes would be in 3.8.1 (3.8.1rc1 is <br>> available at<br>> > this moment for download from our server).<br>> > <br>> > Affects: RT on mysql 4.1 and newer with utf8 as default DB charset<br>> > WHEN RT's DB was created, changing mysql options would not <br>> help much<br>> > <br>> > Symptoms: constant login requests on every action<br>> > <br>> > Check: change session handler to Apache::Session::File, if problem<br>> > goes away then it's this issue.<br>> > <br>> > Otherwise issue is different and needs more investigation. In this<br>> > case (according to Mark's further comments) situation is different.<br>> > <br>> > Hope this would help isolate different problems in future.<br>> > <br>> > On Tue, Aug 5, 2008 at 5:24 AM, Mark Hazen <br>> <<a href="mailto:markh@intechgra.com">markh@intechgra.com</a>> wrote:<br>> >> Hiya folks,<br>> >><br>> >> I saw this mentioned on the list a couple months back, but <br>> under Gentoo,<br>> >> and while the issue was related to the MySQL language <br>> configuration,>> there was a note from ruz@bp stating that this <br>> was an issue related the<br>> >> default charset setting for MySQL (under Gentoo, though) <br>> which had been<br>> >> addressed for the next release (under 3.6, so it'd be <br>> incorporated into<br>> >> 3.8 I'm guessing).<br>> >><br>> >> When a user (admin user in this case) logs in, they get the <br>> home page,<br>> >> but any subsequent clicks bring the login page up again. The <br>> system and<br>> >> Apache logs don't reveal any errors, just a successful login <br>> message>> when the logins are made.<br>> >><br>> >> I've checked the database and the cookie, and the RT_SID is <br>> identical>> and being updated with each request. We did have <br>> default-character-set<br>> >> as utf8 as recommended for Dovecot on the same machine, but I've<br>> >> commented that out and restarted all associated services, and <br>> we still<br>> >> have the multiple login requests.<br>> >><br>> >> I'm attaching my my.cnf file below in case that's the <br>> culprit; I do<br>> >> appreciate any suggestions that might help here.<br>> >><br>> >><br>> >> Environment:<br>> >> RT: 3.8.0<br>> >> OS: Oracle Linux <br>> 5.2 (RHEL5 equivalent)<br>> >> DB: MySQL 5.0.45<br>> >> Web Server: Apache/2.2.3<br>> >><br>> > <br>> > [snip]<br>> > <br>> > -- <br>> > Best regards, Ruslan.<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 <br>> Media. <br>> > Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><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 <br>> Media. <br>> Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><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></blockquote></div><br></body></html>