doesn't change anything... i always get an error like this: "Can't locate Apache2/DBI.pm in @INC (...)" or "Can't locate Apache/DBI.pm in @INC (...)"
does this work for you? Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von CARNINO Daniele (FIAT SERVICES) Gesendet: Mittwoch, 24. September 2008 16:54 An: User questions and discussions about OTRS. Betreff: [otrs] R: OTRS performance tuning 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
