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?

 

 

Uhm... maybe you should user Apache::DBI instead of Apache2::DBI?

Da: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] 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.

 

 

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.

 

 

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:

 

 

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.

 

 

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

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.