[rt-users] MySQL issue - Windows vs. Linux - Table name case seems to matter

Cena, Stephen (ext. 300) SJC at qvii.com
Tue Aug 13 14:45:00 EDT 2013

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:
root at starbug:/home/admsjc/rt-4.0.17# service apache2 start
 * 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.
[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.
'SELECT  * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1234
10)', 'SELECT  * FROM Users WHERE Name = ?', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1153
)', 'Name', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record/Cachable.pm line
0xb895ab10)', 'Name', 'RT_System') called at
/opt/rt4/sbin/../lib/RT/Record.pm line 375
'Name', 'RT_System') called at
/usr/local/share/perl/5.14.2/DBIx/SearchBuilder/Record.pm line 1098
', 'Name', 'RT_System') called at /opt/rt4/sbin/../lib/RT/User.pm line
        RT::User::Load('RT::CurrentUser=HASH(0xb895ab10)', 'RT_System')
called at /opt/rt4/sbin/../lib/RT/Handle.pm line 238
        RT::Handle::CheckIntegrity('RT::Handle') called at
/opt/rt4/sbin/rt-server line 99
        require /opt/rt4/sbin/rt-server called at (eval 6) line 3
        eval 'package Plack::Sandbox::_2fopt_2frt4_2fsbin_2frt_2dserver;
    my $app = do $_file;
    if ( !$app && ( my $error = $@ || $! )) { die $error; }
;' called at /usr/share/perl5/Plack/Util.pm line 118
        Plack::Util::_load_sandbox('/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Util.pm line 155
        Plack::Util::load_psgi('/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Handler/Apache2.pm line 32
'/opt/rt4/sbin/rt-server') called at
/usr/share/perl5/Plack/Handler/Apache2.pm line 24
'/opt/rt4/sbin/rt-server') called at
/etc/apache2/sites-enabled/000-default line 20
        eval 'package
#line 19 /etc/apache2/sites-enabled/000-default
use Plack::Handler::Apache2;
;' called at /opt/rt4/sbin/rt-server line 0
[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)
RT couldn't connect to the database where tickets are stored.
If this is a new installation of RT, you should visit the URL below
to configure RT and initialize your database.
If this is an existing RT installation, this may indicate a database
connectivity problem.
The error RT got back when trying to connect to your database was:
Couldn't find RT_System user in the DB ''
(more error messages after this)
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 = ?'
I get: ERROR 1146 (42S02): Table 'rtdb.Users' doesn't exist

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?
Stephen Cena
850 Hudson Ave.
Rochester, NY. 14620
585-544-0450 x300
sjc at qvii.com
"Thank you for helping us help you help us all."
--For email related issues, please contact postmaster at qvii.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20130813/7aaf89c9/attachment.htm>

More information about the rt-users mailing list