Uhm... maybe you should user Apache::DBI instead of Apache2::DBI?
Ciao, d.
________________________________
Da: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Per conto di Patrick Schiess
Inviato: mercoledì 24 settembre 2008 15.14
A: 'User questions and discussions about OTRS.'
Oggetto: Re: [otrs] OTRS performance tuning
ok, finally i could load the mod_perl into the apache configuration... so this
seems to work fine now...
but i have still the issue that, when i include the following to line into the
apache2-perl-startup.pl:
use Apache2::DBI ();
Apache2::DBI->connect_on_init('DBI:mysql:db','user','pw'); [of course this are
just examples]
i get this error in the error_log file of the apache:
Can't load Perl module Apache2::DBI for server MYSERVER, exiting
when i comment the two lines in question and use instead:
use DBI ();
use DBD::mysql ();
everything works perfect!
any idea?
thanks.
regards,
patrick.
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Patrick Schiess
Gesendet: Mittwoch, 24. September 2008 14:30
An: 'User questions and discussions about OTRS.'
Betreff: Re: [otrs] OTRS performance tuning
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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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.
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
