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

[Lee Hughes]

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