Problems with ApacheDBI

Hi all,

I installed RT on out-of-box FreeBSD 5.1. Since I had some problems, I
was advised here to upgrade to Perl 5.8.0. So I upgraded everything on
that box, so Perl shoul be up to date. But now when I try to start
Apache, I receive this error message:

rt# /usr/local/etc/rc.d/apache2.sh start
[Tue Aug 12 11:58:02 2003] [error] Can’t locate DBI.pm in @INC (@INC
contains: /usr/local/lib/perl5/site_perl/5.6.1/mach/Apache2
/usr/local/lib/perl5/site_perl/5.6.1/mach
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl
/usr/local/lib/perl5/5.6.1/BSDPAN /usr/local/lib/perl5/5.6.1/mach
/usr/local/lib/perl5/5.6.1 . /usr/local/ /usr/local/lib/perl) at
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 7.
BEGIN failed–compilation aborted at
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 7.
Compilation failed in require at (eval 6) line 3.

[Tue Aug 12 11:58:02 2003] [error] Can’t load Perl module Apache::DBI
for server 192.168.0.80:0, exiting…

Any idea ?
Eng. Dusan Djordjevic (RHCE) PlanetSky Ltd.
Tel: +357 22454896 * Fax: +357-22518022
http://www.planetsky.com dusan@planetsky.com

Dusan,

try running this command:

perl -MCPAN -e ‘install DBI’
and because i’m not sure if DBI is the correct thing you’re missing try this
also:

perl -MPCAN -e ‘install Apache::DBI’

Check carefully if make test passes all tests, if not, DBI will not install
itself, you have to force it by going to the .cpan directory in your home
dir, then to build dir, then to DBI dir and run make install.

Also you noted that you have installed perl 5.8.0, but you still have DBI.pm
in your 5.6.1 dir…

A.-----Original Message-----
From: rt-users-admin@lists.fsck.com [mailto:rt-users-admin@lists.fsck.com]
On Behalf Of Dusan Djordjevic
Sent: Tuesday, August 12, 2003 8:04 AM
To: rt-users@lists.fsck.com
Subject: [rt-users] Problems with ApacheDBI

Hi all,

I installed RT on out-of-box FreeBSD 5.1. Since I had some problems, I
was advised here to upgrade to Perl 5.8.0. So I upgraded everything on
that box, so Perl shoul be up to date. But now when I try to start
Apache, I receive this error message:

rt# /usr/local/etc/rc.d/apache2.sh start
[Tue Aug 12 11:58:02 2003] [error] Can’t locate DBI.pm in @INC (@INC
contains: /usr/local/lib/perl5/site_perl/5.6.1/mach/Apache2
/usr/local/lib/perl5/site_perl/5.6.1/mach
/usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl
/usr/local/lib/perl5/5.6.1/BSDPAN /usr/local/lib/perl5/5.6.1/mach
/usr/local/lib/perl5/5.6.1 . /usr/local/ /usr/local/lib/perl) at
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 7.
BEGIN failed–compilation aborted at
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm line 7.
Compilation failed in require at (eval 6) line 3.

[Tue Aug 12 11:58:02 2003] [error] Can’t load Perl module Apache::DBI
for server 192.168.0.80:0, exiting…

Any idea ?
Eng. Dusan Djordjevic (RHCE) PlanetSky Ltd.
Tel: +357 22454896 * Fax: +357-22518022
http://www.planetsky.com dusan@planetsky.com

rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm

perl -MCPAN -e ‘install DBI’
and because i’m not sure if DBI is the correct thing you’re missing
try this also:
perl -MPCAN -e ‘install Apache::DBI’

I already updated them manually:

rt# perl -MCPAN -e ‘install Apache::DBI’
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Mon, 11 Aug 2003 09:44:38 GMT
Apache::DBI is up to date.
rt# perl -MCPAN -e ‘install DBI’
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Mon, 11 Aug 2003 09:44:38 GMT
DBI is up to date.

That is why I am so confused.

Also you noted that you have installed perl 5.8.0, but you still
have DBI.pm in your 5.6.1 dir…

So how should I remove it. I used ports to upgrade to Perl 5.8.0,
Eng. Dusan Djordjevic (RHCE) PlanetSky Ltd.
Tel: +357 22454896 * Fax: +357-22518022
http://www.planetsky.com dusan@planetsky.com

Dusan,

try doing this:

mv /usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm
/usr/local/lib/perl5/site_perl/5.6.1/Apache/DBI.pm.dusan

and re-run the perl -MCPAN lines again…

Btw, where is perl 5.8.0 installed on your machine? /usr/local?

A.From: Dusan Djordjevic [mailto:dj.dule@planetsky.com]
Sent: Tuesday, August 12, 2003 8:34 AM
To: Aleš Sušnik; rt-users@lists.fsck.com
Subject: Re: [rt-users] Problems with ApacheDBI

perl -MCPAN -e ‘install DBI’
and because i’m not sure if DBI is the correct thing you’re missing
try this also:
perl -MPCAN -e ‘install Apache::DBI’

I already updated them manually:

rt# perl -MCPAN -e ‘install Apache::DBI’
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Mon, 11 Aug 2003 09:44:38 GMT
Apache::DBI is up to date.
rt# perl -MCPAN -e ‘install DBI’
CPAN: Storable loaded ok
Going to read /root/.cpan/Metadata
Database was generated on Mon, 11 Aug 2003 09:44:38 GMT
DBI is up to date.

That is why I am so confused.

Also you noted that you have installed perl 5.8.0, but you still
have DBI.pm in your 5.6.1 dir…

So how should I remove it. I used ports to upgrade to Perl 5.8.0,
Eng. Dusan Djordjevic (RHCE) PlanetSky Ltd.
Tel: +357 22454896 * Fax: +357-22518022
http://www.planetsky.com dusan@planetsky.com

Dusan Djordjevic wrote:

I installed RT on out-of-box FreeBSD 5.1. Since I had some problems, I
was advised here to upgrade to Perl 5.8.0. So I upgraded everything on
that box, so Perl shoul be up to date. But now when I try to start
Apache, I receive this error message:

rt# /usr/local/etc/rc.d/apache2.sh start
[Tue Aug 12 11:58:02 2003] [error] Can’t locate DBI.pm in @INC (@INC
contains: /usr/local/lib/perl5/site_perl/5.6.1/mach/Apache2
/usr/local/lib/perl5/site_perl/5.6.1/mach

You need to rebuild mod_perl for perl 5.8.0.
Phil Homewood, Systems Janitor, http://www.SnapGear.com
pdh@snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances

rt# /usr/local/etc/rc.d/apache2.sh start
[Tue Aug 12 11:58:02 2003] [error] Can’t locate DBI.pm in @INC
(@INC contains: /usr/local/lib/perl5/site_perl/5.6.1/mach/Apache2
/usr/local/lib/perl5/site_perl/5.6.1/mach

You need to rebuild mod_perl for perl 5.8.0.

Yes, this is the solution. After rebuilding mod_perl2 everything works
fine.
Eng. Dusan Djordjevic (RHCE) PlanetSky Ltd.
Tel: +357 22454896 * Fax: +357-22518022
http://www.planetsky.com dusan@planetsky.com