[rt-users] "RT couldn't store your session" when moving to a new server

[Kevin Falcone]

On Tue, Jul 26, 2011 at 03:06:25PM -0700, Lee Hughes wrote:
> I've read many threads on this issue but none of the suggestions
> have worked for me.
> 
> I'm trying to move an existing 3.6.5 database to a new server to set
> up a sandbox for testing the 4.x upgrade.
> 
> I have 3.6.5 installed and running on the new server with our
> plugins and customizations. Now I'm trying to move a copy of our
> data over. We use InnoDB and store sessions in the database
> (default).
> 
> I copied over all the .frm files and the InnoDB data/log files and
> restarted MySQL and Apache.
> 
> Browsing to the site gives:
> 
> ----------------------------
> RT couldn't store your session.
> This may mean that that the directory
> '/usr/local/rt3/var/session_data' isn't writable or a database table
> is missing or corrupt.

Looks like you're either missing your sessions table in the DB (keep
in mind that in 3.6.5, the sessions table was MyISAM, not innodb) or
you've configured on-disk sessions and not given rights to that
directory.

During the upgrade to 4.0, RT will change your sessions table to be
innodb

-kevin

> Trace begun at
> /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm line 129
> HTML::Mason::Exceptions::rethrow_exception('RT couldn\'t store your
> session.^JThis may mean that that the directory
> \'/usr/local/rt3/var/session_data\' isn\'t writable or a database
> table is missing or corrupt.^J^J') called at
> /usr/local/rt3/share/html/Elements/SetupSessionCookie line 100
> HTML::Mason::Commands::__ANON__ at
> /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a1f3f4)')
> called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 1302
> eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
> HTML::Mason::Request::comp(undef, undef) called at
> /usr/local/rt3/share/html/autohandler line 120
> HTML::Mason::Commands::__ANON__ at
> /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8a1e68c)')
> called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 1297
> eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1292
> HTML::Mason::Request::comp(undef, undef, undef) called at
> /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481
> eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 481
> eval {...} at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 433
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa314d44)')
> called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
> line 168
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa314d44)')
> called at /usr/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm
> line 825
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x98a9da4)',
> 'Apache2::RequestRec=SCALAR(0x9a77ca0)') called at
> /usr/local/rt3/bin/webmux.pl line 125
> eval {...} at /usr/local/rt3/bin/webmux.pl line 125
> RT::Mason::handler('Apache2::RequestRec=SCALAR(0x9a77ca0)') called
> at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/MySQL.pm line 0
> eval {...} at /usr/lib/perl5/site_perl/5.8.8/Apache/Session/MySQL.pm line 0
> ---------------
> 
> Any help or ideas greatly appreciated.
> 
> Thanks-
> 
> Lee
> 
> --------
> 2011 Training: http://bestpractical.com/services/training.html
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20110727/822e40eb/attachment.sig>