Moving RT to another Server

I am part way finished moving a working RT-3.4.5 installation to a newer
server running MySQL 5, PHP 5 and Fedora 8. I tarred up the rt
installation and put it in the same place on the new server. I did a
mysqldump of the rt3 database and then ran that on the new server. The
running installation is using FastCGI which I can’t get installed on the
newer server since the Apache source is not on the new server. So I
decided to use mod_perl. Looking at the Bok RT Essentials I think I have
it set right but now I got the “Almost There” page when I try to login.

The error logs show a missing favicon.ico file.

Here is my rt portion of my httpd.conf file:

DocumentRoot /opt/rt3/share/html AddDefaultCharset UTF-8 ErrorLog logs/rt_error_log ServerAdmin myemail ServerName rt.adphila.org
    Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/

    PerlModule Apache::DBI
    PerlRequire /opt/rt3/bin/webmux.pl
    TransferLog logs/rt_access_log
    DirectoryIndex index.html index.htm index.shtml
    <Directory "/opt/rt3/share/html">
            Options FollowSymLinks ExecCGI
            AllowOverride None
    </Directory>

    ErrorLog logs/rt_error_log
    <Location /rt3>
    SetHandler perl-script
    PerlHandler RT::Mason
    </Location>

Any pointers would be appreciated.

TIA

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia

“Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!”

Have you checked the other config files in /etc/httpd/conf.d? Anyways,
that error is just informational and doesn’t affect anything.

So the question is, does RT work now?

James Moseley

         "John  BORIS"                                                 
         <jboris@adphila.o                                             
         rg>                                                        To 
                                   <jmoseley@corp.xanadoo.com>         
         03/14/2008 12:51                                           cc 
         PM                        <rt-users-bounces@lists.bestpractic 
                                   al.com>                             
                                                               Subject 
                                   Re: [rt-users] Moving RT to another 
                                   Server                              

James,
I did as you said but I get this message when I restart the httpd
daemon

Stopping httpd: [ OK ]
Starting httpd: [Fri Mar 14 13:49:58 2008] [warn] module fcgid_module
is already loaded, skipping

I checked the httpd.conf file and the only instance for that module is
what I added. Could that have been compiled in?

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia

“Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!”

jmoseley@corp.xanadoo.com 3/14/2008 12:28:06 PM >>>
Personally, since you have a new server to test with, I would take the
time
to upgrade to the latest version - 3.6.6. Install the backed up mysql
database, run the scripts to adjust the DB schema, install HTTP and
mod_fcgid (via yum), install RT (from source), then run a ‘make
testdeps’
to see what Perl modules are missing. Then use CPAN or yum to get
those
installed.

You can also use your tarred 3.4.5 installation as well, but switching
to
mod_perl is going to be slower. The Fedora repository doesn’t contain
an
RPM for Apache’s FastCGI, but it does contain mod_fcgid - an alternate
to
the Apache FastCGI module and works just as well. The only thing you
need
to get this working on the new server is simply the Apache syntax to
use
with mod_fcgid. Here’s my config - it should get you up and working -
adjust the paths as necessary:

LoadModule fcgid_module modules/mod_fcgid.so

Use FastCGI to process .fcg .fcgi & .fpl scripts

Don’t do this if mod_fastcgi is present, as it will try to do the

same
thing
<IfModule !mod_fastcgi.c>
AddHandler fcgid-script fcg fcgi fpl

Sane place to put sockets and shared memory file

SocketPath run/mod_fcgid
SharememPath run/fcgid_shm

Main instance

Alias /rt/NoAuth/images/ /opt/rt/share/html/NoAuth/images/
ScriptAlias /rt /opt/rt/bin/mason_handler.fcgi/

James Moseley

         "John  BORIS"

         <jboris@adphila.o

         rg>

To
Sent by:
rt-users@lists.bestpractical.com
rt-users-bounces@
cc
lists.bestpractic

         al.com

Subject
[rt-users] Moving RT to another

                                   Server

         03/14/2008 10:54

         AM

I am part way finished moving a working RT-3.4.5 installation to a
newer
server running MySQL 5, PHP 5 and Fedora 8. I tarred up the rt
installation and put it in the same place on the new server. I did a
mysqldump of the rt3 database and then ran that on the new server. The
running installation is using FastCGI which I can’t get installed on
the
newer server since the Apache source is not on the new server. So I
decided to use mod_perl. Looking at the Bok RT Essentials I think I
have
it set right but now I got the “Almost There” page when I try to
login.

The error logs show a missing favicon.ico file.

Here is my rt portion of my httpd.conf file:

DocumentRoot /opt/rt3/share/html AddDefaultCharset UTF-8 ErrorLog logs/rt_error_log ServerAdmin myemail ServerName rt.adphila.org
    Alias /NoAuth/images/ /opt/rt3/share/html/NoAuth/images/

    PerlModule Apache::DBI
    PerlRequire /opt/rt3/bin/webmux.pl
    TransferLog logs/rt_access_log
    DirectoryIndex index.html index.htm index.shtml
    <Directory "/opt/rt3/share/html">
            Options FollowSymLinks ExecCGI
            AllowOverride None
    </Directory>

    ErrorLog logs/rt_error_log
    <Location /rt3>
    SetHandler perl-script
    PerlHandler RT::Mason
    </Location>

Any pointers would be appreciated.

TIA

John J. Boris, Sr.
JEN-A-SyS Administrator
Archdiocese of Philadelphia

“Remember! That light at the end of the tunnel
Just might be the headlight of an oncoming train!”
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com