[rt-users] RT requiring login for every click

[Mark Hazen]

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.