"RT couldn't store your session" when moving to a new server

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.

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

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