Re: Preestablish database connection during httpd process startup--HOWTO??

[KartheeK]

Hi Frank,

I tried But I get this:

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

[Fri Nov 18 11:41:11 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 28.\nBEGIN failed--compilation aborted at /opt/otrs/scripts/apache2-perl-startup.pl line 28.\nCompilation failed in require at (eval 2) line 1.\n
[Fri Nov 18 11:41:11 2005] [error] Can't load Perl file: /opt/otrs/scripts/apache2-perl-startup.pl for server srocotrs.envisionone.net:0, exiting...
===========================================================

 

Frank Wiles <[EMAIL PROTECTED]> wrote:

On Thu, 17 Nov 2005 07:41:26 +0000 (GMT)
KartheeK <[EMAIL PROTECTED]>wrote:

> Hello Everybody,
> I am Using a Trouble ticketing System- OTRS it is running on
> mod_perl, I am trying to configure " Preestablish datababase
> connect ions" During httpd process startup: 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

Try it without the "use Apache ();" line, but leave the others in.

---------------------------------
Frank Wiles <[EMAIL PROTECTED]>
http://www.wiles.org
---------------------------------

---

Enjoy this Diwali with Y! India Click here