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
--------
2011 Training: http://bestpractical.com/services/training.html
