[rt-users] Moved Database, now cannot create sessions

[Mathew Snyder]

this is the block of error that comes up when trying to connect:

[Thu Oct  4 13:10:21 2007] [warning]: DBD::mysql::st execute failed: SELECT
command denied to user 'rt_user'@'rtdev01.company.com' for table 'Users' at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505, <GEN33>
line 3. (/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:505)
[Thu Oct  4 13:10:21 2007] [warning]: RT::Handle=HASH(0x8217ce58) couldn't
execute the query 'SELECT  * FROM Users WHERE Name = ?' at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518
        DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8217ce58)',
'SELECT  * FROM Users WHERE Name = ?', 'msnyder') called at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1208

DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0x82e93408)',
'SELECT  * FROM Users WHERE Name = ?', 'msnyder') called at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1127

DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0x82e93408)',
'Name', 'msnyder') called at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Record/Cachable.pm line 119

DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0x82e93408)',
'Name', 'msnyder') called at /usr/local/rt3/lib/RT/Record.pm line 402
        RT::Record::LoadByCols('RT::CurrentUser=HASH(0x82e93408)', 'Name',
'msnyder') called at
/usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Record.pm line 1072

DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0x82e93408)',
'Name', 'msnyder') called at /usr/local/rt3/lib/RT/CurrentUser.pm line 287
        RT::CurrentUser::Load('RT::CurrentUser=HASH(0x82e93408)', 'msnyder')
called at /usr/local/rt3/share/html/autohandler line 245
        HTML::Mason::Commands::__ANON__('Error', 'Your username or password is
incorrect', 'pass', 'password', 'user', 'msnyder') called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Component.pm line 135

HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x819bc5ec)',
'Error', 'Your username or password is incorrect', 'pass', 'password', 'user',
'msnyder') called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line
1246
        eval {...} called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 1245
        HTML::Mason::Request::comp('undef', 'undef', 'undef', 'Error', 'Your
username or password is incorrect', 'pass', 'password', 'user', 'msnyder', ...)
called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459
        eval {...} called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 459
        eval {...} called at
/usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/Request.pm line 411

HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x82e958bc)')
called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 168

HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x82e958bc)')
called at /usr/lib/perl5/vendor_perl/5.8.7/HTML/Mason/ApacheHandler.pm line 826

HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x821766f8)',
'Apache2::RequestRec=SCALAR(0x82aba4d8)') called at /usr/local/rt3/bin/webmux.pl
line 125
        eval {...} called at /usr/local/rt3/bin/webmux.pl line 125
        RT::Mason::handler('Apache2::RequestRec=SCALAR(0x82aba4d8)') called at
-e line 0
        eval {...} called at -e line 0 (/usr/lib/perl5/5.8.8/Carp.pm:272)
[Thu Oct  4 13:10:21 2007] [error]: FAILED LOGIN for msnyder from 192.168.4.118
(/usr/local/rt3/share/html/autohandler:251)

This is all that is in /var/log/mysqld.log:
071004 11:19:10  InnoDB: Starting shutdown...
071004 11:19:11  InnoDB: Shutdown completed; log sequence number 5 3271909341
071004 11:19:11 [Note] /usr/libexec/mysqld: Shutdown complete

071004 11:19:11  mysqld ended

071004 11:19:12  mysqld started
071004 11:19:12  InnoDB: Started; log sequence number 5 3271909341
071004 11:19:12 [Warning] Neither --relay-log nor --relay-log-index were used;
so replication may break when this MySQL server acts as a slave and has his
hostname changed!! Please use '--relay-log=rtdev02-relay-bin' to avoid this problem.
071004 11:19:12 [ERROR] Failed to open the relay log
'./rt-devel-relay-bin.000008' (relay_log_pos 98)
071004 11:19:12 [ERROR] Could not find target log during relay log initialization
071004 11:19:12 [ERROR] Failed to initialize the master info structure
071004 11:19:12 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22-log'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  Source
distribution

Roy El-Hames wrote:
> Ah ok sorry ..
> When you logged in via sql from another host did you login as the rt
> user and the rt password??
> Have you got logging enabled on your sql server and debug level logging
> on RT? what is in the log files??
> Roy
>