[rt-users] RT requiring login for every click

[Kenneth Crocker]

Mark,


	We ran into the same problem, only we are on Oracle. Our problem turned 
out to be the result of using FireFox and Oracle. Our solution was to 
change the code RT uses to set a session cookie as follows:

#   The following code should be added to the existing code in the “if” 
#   condition code in the file "SetupSessionCookie"
#   on line # 75 (right after my $session_properties;),
#   in the directory /$RTHOME/local/html/Elements:
#

     74  my $session_properties;
     75  if ( $session_class eq 'Apache::Session::File' ) {
     76      $session_properties = {
     77          Directory     => $RT::MasonSessionDir,
     78          LockDirectory => $RT::MasonSessionDir,
     79          Transaction => 1
     80      };
     81  } else {
     82      $session_properties = {
     83          Handle     => $RT::Handle->dbh,
     84          LockHandle => $RT::Handle->dbh,
     85          Transaction => 1
     86      };
     87  }

	Lines 78 and 85 were added to the original code. After that, we have 
had no problems at all. I hope this helps.


Kenn
LBNL


On 8/4/2008 6:24 PM, Mark Hazen wrote:
> Hiya folks,
> 
> I saw this mentioned on the list a couple months back, but under Gentoo,
> and while the issue was related to the MySQL language configuration,
> there was a note from ruz at bp stating that this was an issue related the
> default charset setting for MySQL (under Gentoo, though) which had been
> addressed for the next release (under 3.6, so it'd be incorporated into
> 3.8 I'm guessing).
> 
> When a user (admin user in this case) logs in, they get the home page,
> but any subsequent clicks bring the login page up again. The system and
> Apache logs don't reveal any errors, just a successful login message
> when the logins are made.
> 
> I've checked the database and the cookie, and the RT_SID is identical
> and being updated with each request. We did have default-character-set
> as utf8 as recommended for Dovecot on the same machine, but I've
> commented that out and restarted all associated services, and we still
> have the multiple login requests.
> 
> I'm attaching my my.cnf file below in case that's the culprit; I do
> appreciate any suggestions that might help here.
> 
> 
> Environment: 
> 	  RT: 3.8.0 
>         OS: Oracle Linux 5.2 (RHEL5 equivalent)
>         DB: MySQL 5.0.45
> Web Server: Apache/2.2.3
> 
> Just for completeness, "make testdeps" states that all dependencies have
> been found.
> 
> MySQL config (/etc/my.cnf):
>   [mysqld]
>   datadir=/var/lib/mysql
>   socket=/var/lib/mysql/mysql.sock
>   user=mysql
>   old_passwords=0
>   
>   # RT suggested settings
>   #
>   set-variable = innodb_mirrored_log_groups=1
>   set-variable = innodb_log_files_in_group=3
>   set-variable = innodb_log_file_size=5M
>   set-variable = innodb_log_buffer_size=8M
>   innodb_flush_log_at_trx_commit=1
>   innodb_log_archive=0
>   set-variable = innodb_buffer_pool_size=16M
>   set-variable = innodb_additional_mem_pool_size=2M
>   set-variable = innodb_file_io_threads=4
>   set-variable = innodb_lock_wait_timeout=50
>   set-variable = sort_buffer=2M
>   
>   # Dovecot suggested settings
>   #
>   # default-character-set = utf8
>   # default-collation = utf8_general_ci
> 
>   [mysqld_safe]
>   log-error=/var/log/mysqld.log
>   pid-file=/var/run/mysqld/mysqld.pid
> 
> 
> Thanks in advance, 
> -mh.
> _______________________________________________
> 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
>