Hi,

On Wed, Oct 8, 2014 at 11:45 AM, Michael Diederich <michael.diederich@gmail.com> wrote:
Hi,

I'm moving my old OTRS installation to a fresh server. In a later step, I want to upgrade to a newer version.

New VM: Fresh Debian stable 64bit, dedicated mysql-server 5.6, OTRS 2.4.12
Old VM: Old Debian stable 32bit, small localhost mysql, OTRS 2.4.12


I moved the old localhost mysql to the decicated mysql-server. Still no change - the old otrs is fast and the new otrs is terribly slow.

old server:
Apache/2.2.9
# apache2ctl -M
Loaded Modules:
...
 cgi_module (shared)
...
 perl_module (shared)
..
Syntax OK

#/etc/apache2/conf.d/otrs2

ScriptAlias /otrs/ "/opt/otrs/bin/cgi-bin/"
Alias /otrs-web/ "/opt/otrs/var/httpd/htdocs/"

<Directory "/opt/otrs/bin/cgi-bin/">
    AllowOverride None
    Options +ExecCGI -Includes
    Order allow,deny
    Allow from all
</Directory>
<Directory "/opt/otrs/var/httpd/htdocs/">
    AllowOverride None
    Order allow,deny
    Allow from all
</Directory>

new server:
Apache/2.2.22
# apache2ctl -M
Loaded Modules:
...
 cgid_module (shared)
...
 perl_module (shared)
...
Syntax OK

#/etc/apache2/conf.d/otrs2

ScriptAlias /otrs/ "/home/otrs-2.4.12/bin/cgi-bin/"Alias /otrs-web/ "/home/otrs-2.4.12/var/httpd/htdocs/"

<IfModule mod_perl.c>

    Perlrequire /home/otrs-2.4.12/scripts/apache2-perl-startup.pl
    PerlModule Apache2::Reload
    PerlInitHandler Apache2::Reload
    #PerlModule Apache2::RequestRec #test no differences

    <Location /otrs>
        ErrorDocument 403 /otrs/index.pl
        SetHandler  perl-script
        PerlResponseHandler ModPerl::Registry
        Options +ExecCGI
        PerlOptions +ParseHeaders
        PerlOptions +SetupEnv
        Order allow,deny
        Allow from all
    </Location>

    <Location /otrs/nph-genericinterface.pl>
        PerlOptions -ParseHeaders
    </Location>
</IfModule>

<Directory "/home/otrs-2.4.12/bin/cgi-bin/">
    AllowOverride None
    Options +ExecCGI -Includes
    Order allow,deny
    Allow from all

    <IfModule mod_deflate.c>
        AddOutputFilterByType DEFLATE text/html text/javascript text/css text/xml application/json text/json
    </IfModule>
</Directory>
<Directory "/home/otrs-2.4.12/var/httpd/htdocs/">
    AllowOverride None
    Order allow,deny
    Allow from all

    <IfModule mod_deflate.c>
        AddOutputFilterByType DEFLATE text/html text/javascript text/css text/xml application/json text/json
    </IfModule>
</Directory>
.......

#/home/otrs-2.4.12/scripts/apache2-perl-startup.pl

changed the following:

# set otrs lib path!
use lib "/home/otrs-2.4.12/";
use lib "/home/otrs-2.4.12/Kernel/cpan-lib";

# enable this if you use mysql
use DBD::mysql ();
use Kernel::System::DB::mysql;

Anyone any idea? :(