<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 10.00.9200.16635"></HEAD>
<BODY>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>I'm looking to move
all of my MySQL servers from Windows XP systems to Linux. I'm doing testing now
& so far all is well, except with RT. I currently am running RT 4.0.17 on
Ubuntu 12.04LTS with a MySQL 5.5x database on Windows XP SP3. I am able to
successfully backup & restore the database on the Windows machine. However,
when I restore it to the new Linux box, I get the following
error:</FONT></SPAN></DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2
face=Arial>=============================================================</FONT></SPAN></DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial><A
href="mailto:root@starbug:/home/admsjc/rt-4.0.17">root@starbug:/home/admsjc/rt-4.0.17</A>#
service apache2 start<BR> * Starting web server
apache2
[Tue Aug 13 18:40:45 2013] [warning]: DBD::mysql::st execute failed: Table
'rtdb.Users' doesn't exist at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line 589.
(/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm:589)<BR>[Tue Aug 13
18:40:45 2013] [warning]: RT::Handle=HASH(0xb8986ab4) couldn't execute the query
'SELECT * FROM Users WHERE Name = ?' at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Handle.pm line
602.<BR>
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb8986ab4)',
'SELECT * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line
1234<BR>
DBIx::SearchBuilder::Record::_LoadFromSQL('RT::CurrentUser=HASH(0xb895ab10)',
'SELECT * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line
1153<BR>
DBIx::SearchBuilder::Record::LoadByCols('RT::CurrentUser=HASH(0xb895ab10)',
'Name', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.pm line
120<BR>
DBIx::SearchBuilder::Record::Cachable::LoadByCols('RT::CurrentUser=HASH(0xb895ab10)',
'Name', 'RT_System') called at /opt/rt4/sbin/../lib/RT/Record.pm line
375<BR>
RT::Record::LoadByCols('RT::CurrentUser=HASH(0xb895ab10)', 'Name', 'RT_System')
called at /usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line
1098<BR>
DBIx::SearchBuilder::Record::LoadByCol('RT::CurrentUser=HASH(0xb895ab10)',
'Name', 'RT_System') called at /opt/rt4/sbin/../lib/RT/User.pm line
479<BR>
RT::User::Load('RT::CurrentUser=HASH(0xb895ab10)', 'RT_System') called at
/opt/rt4/sbin/../lib/RT/Handle.pm line
238<BR>
RT::Handle::CheckIntegrity('RT::Handle') called at /opt/rt4/sbin/rt-server line
99<BR> require /opt/rt4/sbin/rt-server
called at (eval 6) line 3<BR> eval
'package
Plack::Sandbox::_2fopt_2frt4_2fsbin_2frt_2dserver;<BR>{<BR> my
$app = do $_file;<BR> if ( !$app && ( my $error = $@
|| $! )) { die $error; }<BR> $app;<BR>}</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>;' called at
/usr/share/perl5/Plack/Util.pm line
118<BR>
Plack::Util::_load_sandbox('/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Util.pm line
155<BR>
Plack::Util::load_psgi('/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Handler/Apache2.pm line
32<BR>
Plack::Handler::Apache2::load_app('Plack::Handler::Apache2',
'/opt/rt4/sbin/rt-server') called at /usr/share/perl5/Plack/Handler/Apache2.pm
line 24<BR>
Plack::Handler::Apache2::preload('Plack::Handler::Apache2',
'/opt/rt4/sbin/rt-server') called at /etc/apache2/sites-enabled/000-default line
20<BR> eval 'package
Apache2::ReadConfig::etc::apache2::sites_enabled::000_default::line_19;<BR>#line
19 /etc/apache2/sites-enabled/000-default<BR>use
Plack::Handler::Apache2;<BR>Plack::Handler::Apache2->preload("/opt/rt4/sbin/rt-server");</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>;' called at
/opt/rt4/sbin/rt-server line 0
(/usr/local/share/perl/5.14.2/Carp.pm:103)<BR>[Tue Aug 13 18:40:45 2013]
[warning]: Use of uninitialized value in concatenation (.) or string at
/opt/rt4/sbin/../lib/RT/Handle.pm line 240.
(/opt/rt4/sbin/../lib/RT/Handle.pm:239)</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>RT couldn't connect
to the database where tickets are stored.<BR>If this is a new installation of
RT, you should visit the URL below<BR>to configure RT and initialize your
database.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>If this is an
existing RT installation, this may indicate a database<BR>connectivity
problem.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>The error RT got
back when trying to connect to your database was:</FONT></SPAN></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>Couldn't find
RT_System user in the DB ''</FONT></SPAN></DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>(more error messages
after
this)<BR>======================================================================</FONT></SPAN></DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>I am able to use the
MySQL client tools on the Ubuntu Server running RT to successfully access the RT
database. There is something funny I noticed. If I try to execute: SELECT
* FROM Users WHERE Name = ?'</FONT></SPAN></DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>I get: ERROR 1146
(42S02): Table 'rtdb.Users' doesn't exist<BR></FONT></SPAN></DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2 face=Arial>If I then go into
the RT database & change the "user" table to "User", RT goes further &
has the same error for the ticket tables. Did I do something wrong with my
backup? Or is this a Windows/Linux issue I've never seen
before?</DIV></FONT></SPAN>
<DIV><SPAN class=327393718-13082013><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><SPAN class=327393718-13082013><FONT size=2
face=Arial></FONT></SPAN> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV align=left><FONT size=2 face=Arial>Stephen Cena</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>QVII</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>MIS/IT Dept</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>850 Hudson Ave.</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>Rochester, NY. 14620</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>585-544-0450 x300</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial><A
href="mailto:sjc@qvii.com">sjc@qvii.com</A></FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>"Thank you for helping us help you help
us all."</FONT></DIV>
<DIV align=left><FONT size=2 face=Arial>--For email related issues, please
contact <A
href="mailto:postmaster@qvii.com">postmaster@qvii.com</A></FONT></DIV>
<DIV align=left><FONT size=2 face=Arial></FONT> </DIV>
<DIV align=left><FONT size=2 face=Arial></FONT> </DIV>
<DIV> </DIV></BODY></HTML>