On 11/16/05 2:11 AM, "KartheeK" wrote:

Hello Everybody,

I am in the process of performing "Performance Tuning" as per the OTRS documentation:

http://doc.otrs.org/2.0/en/html/x1497.html#performance-tuning-webserver-db

Preestablish da tababase connections:

I have configured the "apache2-perl-startup.pl" as follows: =====================================================

use Apache (); use Apache::DBI (); Apache::DBI->connect_on_init('DBI:mysql:otrs::localhost',"otrs","hot"); use DBI (); use DBD::mysql (); ====================================================

But, on doing this my httpd server doesn¹t start and I get the following error:

********************************ERROR---1************************************* ********

Can't locate Apache.pm in @INC (@INC contains: /opt/otrs/Kernel/cpan-lib /opt/otrs/ /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5. 8.3 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi /usr/lib/perl5/5.8.6 . /etc/httpd) at /opt/otrs/scripts/apache2-perl-startup.pl line 22.\nBEGIN failed--compilation aborted at /opt/otrs/scripts/apache2-perl-startup.pl line 22.\nCompilation failed in require at (eval 2) line 1.\n

[Wed Nov 16 12:03:30 2005] [error] Can't load Perl file: /opt/otrs/scripts/apache2-perl-startup.pl for server mercury.envisionone.net:0, exiting...

*****************************ERROR---1**************************************** ******

Therefore I Included the file Apache.pm

From:

³/usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi/DBI/ProfileDumper/Ap ache.pm²

To: ³/opt/otrs²

Now, I get another Error

****************************ERROR---2***************************************** ******

[Wed Nov 16 12:13:38 2005] [error] Can't locate Apache/DBI.pm in @INC (@INC contains: /opt/otrs/Kernel/cpan-lib /opt/otrs/ /usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.6 /usr/lib/perl5/site_perl/5.8.5 /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.3 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.6/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.5/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.4/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.6 /usr/lib/perl5/vendor_perl/5.8.5 /usr/lib/perl5/vendor_perl/5.8.4 /usr/lib/perl5/vendor_perl/5.8.3 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.6/i386-linux-thread-multi /usr/lib/perl5/5.8.6 . /etc/httpd) at /opt/otrs/scripts/apache2-perl-startup. pl line 23.\nBEGIN failed--compilation aborted at /opt/otrs/scripts/apache2-perl-startup.pl line 23.\nCompilation failed in require at (eval 2) line 1.\n

[Wed Nov 16 12:13:38 2005] [error] Can't load Perl file: /opt/otrs/scripts/apache2-perl-startup.pl for server mercury.envisionone.net:0, exiting...

********************************ERROR---2************************************* *********

However,

=====================================================

#use Apache (); #use Apache::DBI (); #Apache::DBI->connect_on_init('DBI:mysql:otrs::localhost',"otrs","hot"); use DBI (); use DBD::mysql (); ====================================================

Works without any problem.

Am I wrong in the configuration?? Anybody with success in this?

Regards

KartheeK

Do you have mod_perl installed? If not, then install it. If you're using Apache2, then it should be mod_perl2. -- Mark J. Nernberg Director of Technology (412)478-6262 http://www.downtownhelpdesk.com/ Customer Support: support@downtownhelpdesk.com Have you tried our on-demand remote support services? Downtown Help Desk and 1-Fast Computer Service, providing quality technology solutions to the small business since 2003.