I just installed RT on a Linux 7.3 box. All of the perl modules are
installed, finddeps reported no errors. I was able to install
everything (I think) - I am a newbie and no little about the rest of
the funtioning of the program.
When I try to logout, I (briefly) get this message. I was able to
capture it after trying a few quick saves of the HTML. The error
appears to be a MySQL permission issue, but the user rt_user @
localhost has full privileges to the rt3 database. Any help would be
appreciated.
Greg
You have been logged out of RT.
You’re welcome to login again
System error
error: DBD::mysql::st execute failed: delete command denied to user
’rt_user’@‘localhost’ for table ‘sessions’ at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Store/DBI.pm line 117.
context:
…
113: }
114:
115: $self->{remove_sth}->bind_param(1, $session->{data}->{_session_id});
116:
117: $self->{remove_sth}->execute;
118: $self->{remove_sth}->finish;
119: }
120:
121: 1;
…
code stack: /usr/lib/perl5/site_perl/5.8.6/Apache/Session/Store/DBI.pm:117
/usr/lib/perl5/site_perl/5.8.6/Apache/Session.pm:515
/usr/lib/perl5/site_perl/5.8.6/Apache/Session.pm:477
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm:1068
raw error
DBD::mysql::st execute failed: delete command denied to user
’rt_user’@‘localhost’ for table ‘sessions’ at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Store/DBI.pm line 117.
Trace begun at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Exceptions.pm line 131
HTML::Mason::Exceptions::rethrow_exception(‘DBD::mysql::st execute
failed: delete command denied to user ‘rt_user’@‘localhost’ for
table ‘sessions’ at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Store/DBI.pm line
117.^J’) called at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session/Store/DBI.pm line 117
Apache::Session::Store::DBI::remove(‘Apache::Session::Store::MySQL=HASH(0x9f2308c)’,
‘Apache::Session::MySQL=HASH(0x9eb30d0)’) called at
/usr/lib/perl5/site_perl/5.8.6/Apache/Session.pm line 515
Apache::Session::save(‘Apache::Session::MySQL=HASH(0x9eb30d0)’) called
at /usr/lib/perl5/site_perl/5.8.6/Apache/Session.pm line 477
Apache::Session::DESTROY(‘Apache::Session::MySQL=HASH(0x9eb30d0)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line
1068
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef) called at
/usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 338
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 338
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/Request.pm line 297
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x9f23b0c)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm
line 134
eval {…} at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm
line 134
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x9f23b0c)’)
called at /usr/lib/perl5/site_perl/5.8.6/HTML/Mason/ApacheHandler.pm
line 827
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x9a98838)’,
‘Apache=SCALAR(0x9dfb5a4)’) called at /opt/rt3/bin/webmux.pl line 126
eval {…} at /opt/rt3/bin/webmux.pl line 126
RT::Mason::handler(‘Apache=SCALAR(0x9dfb5a4)’) called at /dev/null line 0
eval {…} at /dev/null line 0