daniele,

thanks a lot for your reply.

unfortunately i can’t solve this mod_perl issue. i already had all this packages (apache2, apache2-perl-mod and apache-dbi-perl) installed... and when i had a look on the otrs.conf file i recognized that everything was exactly the same like the one you posted in... except this line:

PerlModule Apache::DBI

but as far as i put this line into this configuration file, i get an error when i try to start my apache:

“Invalid command ‘PerlModule’, perhaps misspelled or defined by a module not included in the server configuration”

well, i checked the spelling and everything was fine. i think the problem is that first of all the module has to be included in the apache configuration... but i am not sure how to do this. any idea? i was trying to add a line containing something like that:

LoadModule perl_module ../apache2/mod_perl.so

but i don’t know where to add this line... httpd.conf? apache-httpd.conf? apache2-httpd.include.conf? sorry, but maybe you can explain me what is the difference between all this httpd configuration files...

thanks a lot.

regards,

patrick.

Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von CARNINO Daniele (FIAT SERVICES)
Gesendet: Mittwoch, 24. September 2008 12:35
An: User questions and discussions about OTRS.
Betreff: [otrs] R: OTRS performance tuning

Sorry but I'm not that skilled on Suse, since I use Debian.

But I assume you should activate mod_perl and dbi on your apache server (is it Apache2, right?)

For example, on Debian I should install apache, dbi and mod_perl by issuing:

apt-get install apache2

apt-get install apache2-perl-mod

apt-get install apache-dbi-perl

then, I put a file /etc/apache2/conf.d/otrs containing the following directives:

# --
# added for OTRS (http://otrs.org/)
# $Id: apache2-httpd-new.include.conf,v 1.3 2007/04/16 12:11:53 martin Exp $
# --

# agent, admin and customer frontend
ScriptAlias /otrs/ "/opt/otrs/bin/cgi-bin/"
Alias /otrs-web/ "/opt/otrs/var/httpd/htdocs/"

#Persistent connections#
PerlModule Apache::DBI

# if mod_perl is used
<IfModule mod_perl.c>

# load all otrs modules
Perlrequire /opt/otrs/scripts/apache2-perl-startup.pl

    # Apache::Reload - Reload Perl Modules when Changed on Disk
    PerlModule Apache2::Reload
    PerlInitHandler Apache2::Reload
    PerlModule Apache2::RequestRec

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

</IfModule>

# directory settings
<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>

# MaxRequestsPerChild (so no apache child will be to big!)
MaxRequestsPerChild 400

and, restarting apache, everithing works.

Hope this helps.

Ciao, d.

Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di Patrick Schiess
Inviato: mercoledì 24 settembre 2008 12.06
A: 'User questions and discussions about OTRS.'
Oggetto: Re: [otrs] OTRS performance tuning

sure... ;-) sorry, i forgot that... seems to be important... ;-)

i am running otrs on a suse enterprise 10 system...

regards,

patrick.

Von: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Im Auftrag von CARNINO Daniele (FIAT SERVICES)
Gesendet: Mittwoch, 24. September 2008 11:53
An: User questions and discussions about OTRS.
Betreff: [otrs] R: OTRS performance tuning

If you tell us what kind of operating system you use (Debian? Suse? Windows?), maybe someone can help you more accurately...

Ciao, d.

Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] Per conto di Patrick Schiess
Inviato: mercoledì 24 settembre 2008 11.26
A: 'User questions and discussions about OTRS.'
Oggetto: [otrs] OTRS performance tuning

hi everyone,

i have loaded the OTRS support package which should analyze my system. well, after running this package i have two critical points to review:

Apache::DBI Apache::DBI should be used to get a better performance (pre establish database connections). Critical

Apache::Reload You should use mod_perl to increase your performance very strong! Critical

well i searched all over the internet and couldn’t find anything on this two points. as i guess, this is not really a OTRS issue but more a apache issue... unfortunately i am not really familiar with apache... so hopefully someone of you guys can give a clue.

thanks a lot.

regards,

patrick.