RES: RT2 and DBI problems

Changed PerlModule Apache::DBI to PerlModule DBI but the error remains.

Ops ! CPAN installed perl 5.6.1 to me, but I have used perl5.6.0. When
installing RT, I’ve changed the PERL line:

PERL=/usr/bin/perl5.6.0

[root@pinguim rt-2-0-9]# make testdeps
/usr/bin/perl5.6.0 ./tools/testdeps -warn mysql
Checking for DBI 1.18 …found
Checking for DBIx::DataSource 0.02 …found
Checking for DBIx::SearchBuilder 0.47 …found
Checking for HTML::Entities…found
Checking for MLDBM…found
Checking for Net::Domain…found
Checking for Net::SMTP…found
Checking for Params::Validate 0.02 …found
Checking for HTML::Mason 0.896 …found
Checking for CGI::Cookie 1.20 …found
Checking for Apache::Cookie…found
Checking for Apache::Session 1.53 …found
Checking for Date::Parse…found
Checking for Date::Format…found
Checking for MIME::Entity 5.108 …found
Checking for Mail::Mailer 1.20 …found
Checking for Getopt::Long 2.24 …found
Checking for Tie::IxHash…found
Checking for Text::Wrapper…found
Checking for Text::Template…found
Checking for File::Spec 0.8 …found
Checking for Errno…found
Checking for FreezeThaw…found
Checking for File::Temp…found
Checking for Log::Dispatch 1.6 …found
Checking for DBD::mysql 2.0416 …found

[root@pinguim bin]# perl -v
This is perl, v5.6.1 built for i686-linux

[root@pinguim bin]# pwd
/usr/bin

[root@pinguim bin]# cp perl5.6.0 perl

[root@pinguim bin]# perl -v
This is perl, v5.6.0 built for i386-linux

[root@pinguim rt-2-0-9]# /usr/local/apache/bin/apachectl restart
/usr/local/apache/bin/apachectl restart: httpd restarted

Tried to load RT2 page … the error in apache error_log is the same:

[root@pinguim rt-2-0-9]# tail /usr/local/apache/logs/error_log
[Thu Nov 29 07:10:38 2001] [notice] Apache/1.3.20 (Unix) PHP/4.0.6
mod_perl/1.26 configured – resuming normal operations
[Thu Nov 29 07:11:18 2001] [error] Can’t locate object method “connect” via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.
[Thu Nov 29 07:11:37 2001] [error] Can’t locate object method “connect” via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.
[Thu Nov 29 07:11:39 2001] [error] Can’t locate object method “connect” via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.

Presciliano

I found this message at http://groups.yahoo.com/group/modperl/message/17512.
Does the “DBI pragma” aplies to my problem ? How to use it ?

Thanks,

PrescilianoFrom: Geoffrey Young <gyoung@l…>
Date: Thu Jan 6, 2000 2:50 pm
Subject: RE: problem with Apache::DBI

Apache::DBI and DBI are different packages - Apache::DBI requires DBI to
function.

thus, you still need to include the use DBI pragma.

HTH

–Geoff

-----Original Message-----
From: Michael Baxter [mailto:fineprint@w…]
Sent: Thursday, January 06, 2000 4:17 AM
To: modperl@a…
Subject: problem with Apache::DBI

I’ve posted this to comp.lang.perl.modules but got no
response. Perhaps
you can help.

I’ve been accessing a mysql db with (non-mod)perl/cgi. I’ve installed
mod_perl as per the eagle book (right down to the suggested directory
layout) and have run examples 2.1 and 2.3, so I’m
assuming Apache::Registry works. But when I try to run one of my old
scripts (with the use DBI commented out) all I get is an error msg:

[Sun Jan 2 16:29:41 2000] [error] [Sun Jan 2 16:29:41 2000] null:
Can’t locate object method “connect” via package “Apache::DBI” at
/usr/lib/perl5/site_perl/DBI.pm line 382. The file is there.

I’m running redhat 5.2, mysql 2.22.26a, apache 1.3.9 and
mod_perl 1.21.

Any suggestions - I’ve run out of ideas and curses.
Thanks,
MickB.

----- Mensagem original -----
De: Presciliano dos Santos Neto
Enviada em: Quinta-feira, 29 de Novembro de 2001 09:19
Para: 'rt-users@lists.fsck.com’
Assunto: RES: [rt-users] RT2 and DBI problems

Ops ! CPAN installed perl 5.6.1 to me, but I have used perl5.6.0. When
installing RT, I’ve changed the PERL line:

PERL=/usr/bin/perl5.6.0

[root@pinguim rt-2-0-9]# make testdeps
/usr/bin/perl5.6.0 ./tools/testdeps -warn mysql
Checking for DBI 1.18 …found
Checking for DBIx::DataSource 0.02 …found
Checking for DBIx::SearchBuilder 0.47 …found
Checking for HTML::Entities…found
Checking for MLDBM…found
Checking for Net::Domain…found
Checking for Net::SMTP…found
Checking for Params::Validate 0.02 …found
Checking for HTML::Mason 0.896 …found
Checking for CGI::Cookie 1.20 …found
Checking for Apache::Cookie…found
Checking for Apache::Session 1.53 …found
Checking for Date::Parse…found
Checking for Date::Format…found
Checking for MIME::Entity 5.108 …found
Checking for Mail::Mailer 1.20 …found
Checking for Getopt::Long 2.24 …found
Checking for Tie::IxHash…found
Checking for Text::Wrapper…found
Checking for Text::Template…found
Checking for File::Spec 0.8 …found
Checking for Errno…found
Checking for FreezeThaw…found
Checking for File::Temp…found
Checking for Log::Dispatch 1.6 …found
Checking for DBD::mysql 2.0416 …found

[root@pinguim bin]# perl -v
This is perl, v5.6.1 built for i686-linux

[root@pinguim bin]# pwd
/usr/bin

[root@pinguim bin]# cp perl5.6.0 perl

[root@pinguim bin]# perl -v
This is perl, v5.6.0 built for i386-linux

[root@pinguim rt-2-0-9]# /usr/local/apache/bin/apachectl restart
/usr/local/apache/bin/apachectl restart: httpd restarted

Tried to load RT2 page … the error in apache error_log is the same:

[root@pinguim rt-2-0-9]# tail /usr/local/apache/logs/error_log
[Thu Nov 29 07:10:38 2001] [notice] Apache/1.3.20 (Unix) PHP/4.0.6
mod_perl/1.26 configured – resuming normal operations
[Thu Nov 29 07:11:18 2001] [error] Can’t locate object method "connect"
via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.
[Thu Nov 29 07:11:37 2001] [error] Can’t locate object method "connect"
via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.
[Thu Nov 29 07:11:39 2001] [error] Can’t locate object method "connect"
via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.

Presciliano

----- Mensagem original -----
De: Jesse Vincent [SMTP:jesse@bestpractical.com]
Enviada em: Quarta-feira, 28 de Novembro de 2001 19:54
Para: Presciliano dos Santos Neto
Cc: 'rt-users@lists.fsck.com’
Assunto: Re: [rt-users] RT2 and DBI problems

what does perl -v tell you?

Hello !

I have installed RT2, checked all the documentation but I can’t
resolve
an

issue with DBI. I think the following lines describes the problem
better

than my poor english :slight_smile:
I know DBI and Apache::DBI are diferent modules, and I think somebody
is

calling the wrong one. Any help ?

Thanks in advance,

Presciliano

------ I’ve installed all the RT2 dependencies with CPAN, and
Apache::DBI
again by hand …

cpan> install DBI
DBI is up to date.

cpan> install Apache::DBI
Apache::DBI is up to date.

cpan> exit
Lockfile removed.

------- http.conf

<VirtualHost *>
DocumentRoot /usr/local/rt2/WebRT/html
ServerName security.telepar.net.br
PerlModule Apache::DBI
PerlFreshRestart On
PerlRequire /usr/local/rt2/bin/webmux.pl

SetHandler perl-script
PerlHandler RT::Mason


------ httpd loads fine

[root@pinguim /root]# /usr/local/apache/bin/apachectl restart
/usr/local/apache/bin/apachectl restart: httpd restarted

------ Tried to load RT2 page in a browser. Received the Internal
Server
500

error

[root@pinguim /root]# tail /usr/local/apache/logs/error_log
[Wed Nov 28 17:08:42 2001] [notice] SIGHUP received. Attempting to
restart
[Wed Nov 28 17:08:42 2001] [notice] Apache/1.3.20 (Unix) PHP/4.0.6
mod_perl/1.26 configured – resuming normal operations
[Wed Nov 28 17:08:56 2001] [error] Can’t locate object method
"connect"
via

package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.

[root@pinguim /root]# find / -name DBI.pm
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Bundle/DBI.pm
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm
/usr/lib/perl5/site_perl/5.6.0/Apache/Session/Store/DBI.pm
/usr/lib/perl5/site_perl/5.6.0/Apache/DBI.pm


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


http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.


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

This may not be a great suggestion, but…

just to bypas the whole 5.6.0 vs 5.6.1 mess you should consider
removing all perl and then build 5.6.1 by hand so you only have one
perl:

I built perl 5.6.1 with libperl as shared object:

develrt:/usr/local/build/perl-5.6.1 # sh Configure -Duseshrplib
develrt:/usr/local/build/perl-5.6.1 # make
develrt:/usr/local/build/perl-5.6.1 # make test
develrt:/usr/local/build/perl-5.6.1 # make install

and then apache with mod_perl as non-DSO:

develrt:/usr/local/build/mod_perl-1.26 # perl Makefile.PL APACHE_SRC=…/apache_1
develrt:/usr/local/build/mod_perl-1.26 # make && make test && make install
develrt:/usr/local/build/mod_perl-1.26 # cd …/apache_1.3.22/
develrt:/usr/local/build/apache_1.3.22 # make install

ofcourse you then should rebuild all your perlmods (I presume), that
should be a snap. I found most every thing worked better this way.

I have kept good notes on installing RT (would you believe 6 times!) and
I am happy to send them if you want.

ashleyOn Thu, Nov 29, 2001 at 09:18:30AM -0200, Presciliano dos Santos Neto wrote:

Ops ! CPAN installed perl 5.6.1 to me, but I have used perl5.6.0. When
installing RT, I’ve changed the PERL line:

PERL=/usr/bin/perl5.6.0

[root@pinguim rt-2-0-9]# make testdeps
/usr/bin/perl5.6.0 ./tools/testdeps -warn mysql
Checking for DBI 1.18 …found
Checking for DBIx::DataSource 0.02 …found
Checking for DBIx::SearchBuilder 0.47 …found
Checking for HTML::Entities…found
Checking for MLDBM…found
Checking for Net::Domain…found
Checking for Net::SMTP…found
Checking for Params::Validate 0.02 …found
Checking for HTML::Mason 0.896 …found
Checking for CGI::Cookie 1.20 …found
Checking for Apache::Cookie…found
Checking for Apache::Session 1.53 …found
Checking for Date::Parse…found
Checking for Date::Format…found
Checking for MIME::Entity 5.108 …found
Checking for Mail::Mailer 1.20 …found
Checking for Getopt::Long 2.24 …found
Checking for Tie::IxHash…found
Checking for Text::Wrapper…found
Checking for Text::Template…found
Checking for File::Spec 0.8 …found
Checking for Errno…found
Checking for FreezeThaw…found
Checking for File::Temp…found
Checking for Log::Dispatch 1.6 …found
Checking for DBD::mysql 2.0416 …found

[root@pinguim bin]# perl -v
This is perl, v5.6.1 built for i686-linux

[root@pinguim bin]# pwd
/usr/bin

[root@pinguim bin]# cp perl5.6.0 perl

[root@pinguim bin]# perl -v
This is perl, v5.6.0 built for i386-linux

[root@pinguim rt-2-0-9]# /usr/local/apache/bin/apachectl restart
/usr/local/apache/bin/apachectl restart: httpd restarted

Tried to load RT2 page … the error in apache error_log is the same:

[root@pinguim rt-2-0-9]# tail /usr/local/apache/logs/error_log
[Thu Nov 29 07:10:38 2001] [notice] Apache/1.3.20 (Unix) PHP/4.0.6
mod_perl/1.26 configured – resuming normal operations
[Thu Nov 29 07:11:18 2001] [error] Can’t locate object method “connect” via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.
[Thu Nov 29 07:11:37 2001] [error] Can’t locate object method “connect” via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.
[Thu Nov 29 07:11:39 2001] [error] Can’t locate object method “connect” via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.

Presciliano

----- Mensagem original -----
De: Jesse Vincent [SMTP:jesse@bestpractical.com]
Enviada em: Quarta-feira, 28 de Novembro de 2001 19:54
Para: Presciliano dos Santos Neto
Cc: 'rt-users@lists.fsck.com’
Assunto: Re: [rt-users] RT2 and DBI problems

what does perl -v tell you?

On Wed, Nov 28, 2001 at 07:38:02PM -0200, Presciliano dos Santos Neto wrote:

Hello !

I have installed RT2, checked all the documentation but I can’t resolve
an
issue with DBI. I think the following lines describes the problem better
than my poor english :slight_smile:
I know DBI and Apache::DBI are diferent modules, and I think somebody is
calling the wrong one. Any help ?

Thanks in advance,

Presciliano

------ I’ve installed all the RT2 dependencies with CPAN, and
Apache::DBI
again by hand …

cpan> install DBI
DBI is up to date.

cpan> install Apache::DBI
Apache::DBI is up to date.

cpan> exit
Lockfile removed.

------- http.conf

<VirtualHost *>
DocumentRoot /usr/local/rt2/WebRT/html
ServerName security.telepar.net.br
PerlModule Apache::DBI
PerlFreshRestart On
PerlRequire /usr/local/rt2/bin/webmux.pl

SetHandler perl-script
PerlHandler RT::Mason


------ httpd loads fine

[root@pinguim /root]# /usr/local/apache/bin/apachectl restart
/usr/local/apache/bin/apachectl restart: httpd restarted

------ Tried to load RT2 page in a browser. Received the Internal Server
500
error

[root@pinguim /root]# tail /usr/local/apache/logs/error_log
[Wed Nov 28 17:08:42 2001] [notice] SIGHUP received. Attempting to
restart
[Wed Nov 28 17:08:42 2001] [notice] Apache/1.3.20 (Unix) PHP/4.0.6
mod_perl/1.26 configured – resuming normal operations
[Wed Nov 28 17:08:56 2001] [error] Can’t locate object method "connect"
via
package “Apache::DBI::connect” at
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm line 420.

[root@pinguim /root]# find / -name DBI.pm
/usr/lib/perl5/site_perl/5.6.0/i386-linux/Bundle/DBI.pm
/usr/lib/perl5/site_perl/5.6.0/i386-linux/DBI.pm
/usr/lib/perl5/site_perl/5.6.0/Apache/Session/Store/DBI.pm
/usr/lib/perl5/site_perl/5.6.0/Apache/DBI.pm


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


http://www.bestpractical.com/products/rt – Trouble Ticketing. Free.


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