[rt-users] Help with logout

[Greg Kopp]

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