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