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
pgp32dn6HxZuj.pgp
Description: PGP signature
2011 Training: http://bestpractical.com/services/training.html
