Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched through google
and the list archive and found other people that have had similar problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there were
some dependencies that were missing but i fixed that with the make testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per the
ManualInstallation guide, restarted apache, and when I browse to the page I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method “connect” via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I tried
removing and re-installing DBI with cpan but there was no change…I still
get the same error.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill

Hello All:

I’m having a problem with a new install of RT. I’ve searched through google
and the list archive and found other people that have had similar problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there were
some dependencies that were missing but i fixed that with the make testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per the
ManualInstallation guide, restarted apache, and when I browse to the page I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method “connect” via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I tried
removing and re-installing DBI with cpan but there was no change…I still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT 2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for ‘locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using ‘make
fixdeps’

DBI is version 1.48

BillFrom: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per the
ManualInstallation guide, restarted apache, and when I browse to the page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method "connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I tried
removing and re-installing DBI with cpan but there was no change…I still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for ‘locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/9/05, Bill Sandiford bill@telnetcommunications.com wrote:

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per the
ManualInstallation guide, restarted apache, and when I browse to the page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method "connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I
tried
removing and re-installing DBI with cpan but there was no change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for ‘locate
DBI.pm’ if that matters
If you installed DBI then you must have DBI.pm file in your system.

when you are referring to the configure script, what configure script are
you referring to…for what package.
RT’s configure script.

I installed DBI and every other perl module from cpan, mostly by using ‘make
fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per the
ManualInstallation guide, restarted apache, and when I browse to the page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method "connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I tried
removing and re-installing DBI with cpan but there was no change…I still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.

Best regards, Ruslan.

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for ‘locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per the
ManualInstallation guide, restarted apache, and when I browse to the page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method "connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I
tried
removing and re-installing DBI with cpan but there was no change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for ‘locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per
the
ManualInstallation guide, restarted apache, and when I browse to the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method "connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I
tried
removing and re-installing DBI with cpan but there was no change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to resolve
the issues. Does anyone else have any ideas?

Regards,
Bill----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/9/05, Bill Sandiford bill@telnetcommunications.com wrote:

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/9/05, Bill Sandiford bill@telnetcommunications.com wrote:

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per
the
ManualInstallation guide, restarted apache, and when I browse to the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I
tried
removing and re-installing DBI with cpan but there was no change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to resolve
the issues. Does anyone else have any ideas?
add ‘use DBI;’ string to the
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
but I checked this file in my system and it has this string there.

Did you install RT with devel mode enabled?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good, there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per
the
ManualInstallation guide, restarted apache, and when I browse to the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I
tried
removing and re-installing DBI with cpan but there was no change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56 EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

use DBI; is already at the top of that file…first few lines of file looks
like this

$Header: /home/jesse/DBIx-SearchBuilder/history/SearchBuilder/Handle.pm,v

1.21 2002/01/28 06:11:37 jesse Exp $
package DBIx::SearchBuilder::Handle;
use strict;
use Carp qw(croak cluck);
use DBI;
use Class::ReturnValue;
use Encode;

As far as devel mode goes, I don’t know what you mean by this. To install,
I followed the instructions at
http://wiki.bestpractical.com/index.cgi?ManualInstallation----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 12:58 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to
resolve the issues. Does anyone else have any ideas?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/9/05, Bill Sandiford bill@telnetcommunications.com wrote:

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/9/05, Bill Sandiford bill@telnetcommunications.com wrote:

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good,
there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per
the
ManualInstallation guide, restarted apache, and when I browse to the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I
tried
removing and re-installing DBI with cpan but there was no change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56
EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

use DBI; is already at the top of that file…first few lines of file looks
like this
I don’t have more ideas except one random:
perl -Mstrict -w -MDBI -e’my $dbh = DBI->connect(“dbi:mysql:base=rt3”,
“rt_user”, “rt_pass”, {RaiseError => 1});’

If it works I don’t know where should you look.

$Header: /home/jesse/DBIx-SearchBuilder/history/SearchBuilder/Handle.pm,v

1.21 2002/01/28 06:11:37 jesse Exp $
package DBIx::SearchBuilder::Handle;
use strict;
use Carp qw(croak cluck);
use DBI;
use Class::ReturnValue;
use Encode;

As far as devel mode goes, I don’t know what you mean by this. To install,
I followed the instructions at
http://wiki.bestpractical.com/index.cgi?ManualInstallation
ok, this mean you don’t use devel mode.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 12:58 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to
resolve the issues. Does anyone else have any ideas?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good,
there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as per
the
ManualInstallation guide, restarted apache, and when I browse to the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

I have verified that DBI is installed, (make testdeps confirmed). I
tried
removing and re-installing DBI with cpan but there was no change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56
EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

Ruslan:

Thanks for all your help…as expected, the command you have me run was
successful, so I don’t know where to go from here.

perl -Mstrict -w -MDBI -e’my $dbh = DBI->connect(“dbi:mysql:base=rt3”,
"", “”, {RaiseError => 1});’

returned to the prompt with no output, so I’m assuming that means it
works…just to verify, I tried changing the password to an invalid
password and I got the following output.

DBI connect(‘base=rt3’,‘rt-user’,…) failed: Access denied for user
’rt_user’@‘localhost’ (using password: YES) at -e line 1

So I can only assume that DBI is installed properly

Thanks for your helpFrom: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 2:49 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

use DBI; is already at the top of that file…first few lines of file
looks
like this
I don’t have more ideas except one random:
perl -Mstrict -w -MDBI -e’my $dbh = DBI->connect(“dbi:mysql:base=rt3”,
“rt_user”, “rt_pass”, {RaiseError => 1});’

If it works I don’t know where should you look.

$Header:

/home/jesse/DBIx-SearchBuilder/history/SearchBuilder/Handle.pm,v
1.21 2002/01/28 06:11:37 jesse Exp $
package DBIx::SearchBuilder::Handle;
use strict;
use Carp qw(croak cluck);
use DBI;
use Class::ReturnValue;
use Encode;

As far as devel mode goes, I don’t know what you mean by this. To
install,
I followed the instructions at
http://wiki.bestpractical.com/index.cgi?ManualInstallation
ok, this mean you don’t use devel mode.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 12:58 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to
resolve the issues. Does anyone else have any ideas?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure
script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by
using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched
through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good,
there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as
per
the
ManualInstallation guide, restarted apache, and when I browse to
the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

I have verified that DBI is installed, (make testdeps confirmed).
I
tried
removing and re-installing DBI with cpan but there was no
change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you
want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56
EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

How can I test to make sure that mod_perl is working properly?From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 2:49 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

use DBI; is already at the top of that file…first few lines of file
looks
like this
I don’t have more ideas except one random:
perl -Mstrict -w -MDBI -e’my $dbh = DBI->connect(“dbi:mysql:base=rt3”,
“rt_user”, “rt_pass”, {RaiseError => 1});’

If it works I don’t know where should you look.

$Header:

/home/jesse/DBIx-SearchBuilder/history/SearchBuilder/Handle.pm,v
1.21 2002/01/28 06:11:37 jesse Exp $
package DBIx::SearchBuilder::Handle;
use strict;
use Carp qw(croak cluck);
use DBI;
use Class::ReturnValue;
use Encode;

As far as devel mode goes, I don’t know what you mean by this. To
install,
I followed the instructions at
http://wiki.bestpractical.com/index.cgi?ManualInstallation
ok, this mean you don’t use devel mode.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 12:58 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to
resolve the issues. Does anyone else have any ideas?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure
script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by
using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched
through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good,
there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as
per
the
ManualInstallation guide, restarted apache, and when I browse to
the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

I have verified that DBI is installed, (make testdeps confirmed).
I
tried
removing and re-installing DBI with cpan but there was no
change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you
want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56
EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

I did some more testing and I found out the following, don’t know if this
helps or not.

I have found out that all attempts to pull any page, html or otherwise from
this server, gives the same 500 Internal Server Error. In the apache
error_log its the same old

[error] Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

So basically any file I tried to access gave me the above error, even if it
was just a simple “hello world” html file. The only way to stop this
behavious was to comment out the following line in httpd.conf

PerlHandler RT::Mason

After commenting out that line in httpd.conf I figured I’d write just a
little test script and try executing it from the webserver as opposed to
from the command line. The script I wrote is:

#!/usr/local/bin/perl
use DBI;
print “Content-type: text/plain\n\n”;
my $dbh = DBI->connect(“dbi:mysql:base=rt3”,“rt_user”, “rt_pass”,
{RaiseError => 1});

This script ran without causing any errors. So this tells me that the
problem is somehow related to the RT::Mason line in the httpd.conf

Any ideas?

Bill

PerlHandler RT::MasonFrom: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 2:49 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

use DBI; is already at the top of that file…first few lines of file
looks
like this
I don’t have more ideas except one random:
perl -Mstrict -w -MDBI -e’my $dbh = DBI->connect(“dbi:mysql:base=rt3”,
“rt_user”, “rt_pass”, {RaiseError => 1});’

If it works I don’t know where should you look.

$Header:

/home/jesse/DBIx-SearchBuilder/history/SearchBuilder/Handle.pm,v
1.21 2002/01/28 06:11:37 jesse Exp $
package DBIx::SearchBuilder::Handle;
use strict;
use Carp qw(croak cluck);
use DBI;
use Class::ReturnValue;
use Encode;

As far as devel mode goes, I don’t know what you mean by this. To
install,
I followed the instructions at
http://wiki.bestpractical.com/index.cgi?ManualInstallation
ok, this mean you don’t use devel mode.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 12:58 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to
resolve the issues. Does anyone else have any ideas?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure
script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by
using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched
through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good,
there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as
per
the
ManualInstallation guide, restarted apache, and when I browse to
the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

I have verified that DBI is installed, (make testdeps confirmed).
I
tried
removing and re-installing DBI with cpan but there was no
change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you
want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56
EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com

Best regards, Ruslan.

Do you have Apache::DBI in your httpd conf. Try to comment it out.

“PerlModule RT::Mason” enables RT.

You could try FastCGI instead of mod_perl.On 10/11/05, Bill Sandiford bill@telnetcommunications.com wrote:

I did some more testing and I found out the following, don’t know if this
helps or not.

I have found out that all attempts to pull any page, html or otherwise from
this server, gives the same 500 Internal Server Error. In the apache
error_log its the same old

[error] Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

So basically any file I tried to access gave me the above error, even if it
was just a simple “hello world” html file. The only way to stop this
behavious was to comment out the following line in httpd.conf

PerlHandler RT::Mason

After commenting out that line in httpd.conf I figured I’d write just a
little test script and try executing it from the webserver as opposed to
from the command line. The script I wrote is:

#!/usr/local/bin/perl
use DBI;
print “Content-type: text/plain\n\n”;
my $dbh = DBI->connect(“dbi:mysql:base=rt3”,“rt_user”, “rt_pass”,
{RaiseError => 1});

This script ran without causing any errors. So this tells me that the
problem is somehow related to the RT::Mason line in the httpd.conf

Any ideas?

Bill

PerlHandler RT::Mason
----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 2:49 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/10/05, Bill Sandiford bill@telnetcommunications.com wrote:

use DBI; is already at the top of that file…first few lines of file
looks
like this
I don’t have more ideas except one random:
perl -Mstrict -w -MDBI -e’my $dbh = DBI->connect(“dbi:mysql:base=rt3”,
“rt_user”, “rt_pass”, {RaiseError => 1});’

If it works I don’t know where should you look.

$Header:

/home/jesse/DBIx-SearchBuilder/history/SearchBuilder/Handle.pm,v
1.21 2002/01/28 06:11:37 jesse Exp $
package DBIx::SearchBuilder::Handle;
use strict;
use Carp qw(croak cluck);
use DBI;
use Class::ReturnValue;
use Encode;

As far as devel mode goes, I don’t know what you mean by this. To
install,
I followed the instructions at
http://wiki.bestpractical.com/index.cgi?ManualInstallation
ok, this mean you don’t use devel mode.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 12:58 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

The other suggestions have been appreciated, but so far not able to
resolve the issues. Does anyone else have any ideas?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/9/05, Bill Sandiford bill@telnetcommunications.com wrote:

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure
script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by
using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

On 10/9/05, Bill Sandiford bill@telnetcommunications.com wrote:

Hello All:

I’m having a problem with a new install of RT. I’ve searched
through
google
and the list archive and found other people that have had similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was good,
there
were
some dependencies that were missing but i fixed that with the make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file as
per
the
ManualInstallation guide, restarted apache, and when I browse to
the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

I have verified that DBI is installed, (make testdeps confirmed).
I
tried
removing and re-installing DBI with cpan but there was no
change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl installed. By
default configure script choose default perl in ‘/usr/bin/perl’. You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you
want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3 17:52:56
EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.

Best regards, Ruslan.

I tried commenting out PerlModule Apache::DBI from the httpd.conf but still
the same error.

Is there anything special that I will need to do to switch from mod_perl to
FastCGI? Do I have to do anything special to remove mod_perl?

BillFrom: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 5:59 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Do you have Apache::DBI in your httpd conf. Try to comment it out.

“PerlModule RT::Mason” enables RT.

You could try FastCGI instead of mod_perl.

Of course I did !!! But I’ve done dumber things in the past, so I’m glad you
asked !!!

Is there anything special that I will need to do to switch from mod_perl to
FastCGI? Do I have to do anything special to remove mod_perl?From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Sent: Monday, October 10, 2005 6:08 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I tried commenting out PerlModule Apache::DBI from the httpd.conf but
still
the same error.
I hope you restarted server.

Is there anything special that I will need to do to switch from mod_perl
to
FastCGI? Do I have to do anything special to remove mod_perl?

Bill
----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 5:59 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Do you have Apache::DBI in your httpd conf. Try to comment it out.

“PerlModule RT::Mason” enables RT.

You could try FastCGI instead of mod_perl.

I did some more testing and I found out the following, don’t know if
this
helps or not.

I have found out that all attempts to pull any page, html or otherwise
from
this server, gives the same 500 Internal Server Error. In the apache
error_log its the same old

[error] Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm line
108.\n

So basically any file I tried to access gave me the above error, even if
it
was just a simple “hello world” html file. The only way to stop this
behavious was to comment out the following line in httpd.conf

PerlHandler RT::Mason

After commenting out that line in httpd.conf I figured I’d write just a
little test script and try executing it from the webserver as opposed to
from the command line. The script I wrote is:

#!/usr/local/bin/perl
use DBI;
print “Content-type: text/plain\n\n”;
my $dbh = DBI->connect(“dbi:mysql:base=rt3”,“rt_user”, “rt_pass”,
{RaiseError => 1});

This script ran without causing any errors. So this tells me that the
problem is somehow related to the RT::Mason line in the httpd.conf

Any ideas?

Bill

PerlHandler RT::Mason
----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 2:49 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

use DBI; is already at the top of that file…first few lines of file
looks
like this
I don’t have more ideas except one random:
perl -Mstrict -w -MDBI -e’my $dbh = DBI->connect(“dbi:mysql:base=rt3”,
“rt_user”, “rt_pass”, {RaiseError => 1});’

If it works I don’t know where should you look.

$Header:

/home/jesse/DBIx-SearchBuilder/history/SearchBuilder/Handle.pm,v
1.21 2002/01/28 06:11:37 jesse Exp $
package DBIx::SearchBuilder::Handle;
use strict;
use Carp qw(croak cluck);
use DBI;
use Class::ReturnValue;
use Encode;

As far as devel mode goes, I don’t know what you mean by this. To
install,
I followed the instructions at
http://wiki.bestpractical.com/index.cgi?ManualInstallation
ok, this mean you don’t use devel mode.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Monday, October 10, 2005 12:58 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

I’m still stuck with this error.

Can’t locate object method “connect” via package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

The other suggestions have been appreciated, but so far not able to
resolve the issues. Does anyone else have any ideas?

Regards,
Bill
----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 8:20 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Both,

/usr/local/bin/perl -MDBI -e’1’
and
sudo -u apache /usr/local/bin/perl -MDBI -e’1’

return back to the shell prompt after giving no output.

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Sunday, October 09, 2005 4:53 AM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

FYI

in the Makefile for RT, PERL=/usr/local/bin/perl
in the Makefile for mod_perl, PERL=/usr/local/bin/perl
This is good.

output of ‘find / -name DBI.pm -print’

/root/.cpan/build/Apache-DBI-0.94/DBI.pm
/root/.cpan/build/Apache-DBI-0.94/blib/lib/Apache/DBI.pm
/root/.cpan/build/DBI-1.48/lib/Bundle/DBI.pm
/root/.cpan/build/DBI-1.48/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/DBI.pm
/root/.cpan/build/DBI-1.48/blib/lib/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/Bundle/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/i686-linux/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/Session/Store/DBI.pm
/usr/local/lib/perl5/site_perl/5.8.7/Apache/DBI.pm
Ok. looks like you really have DBI installed and it’s installed in
correct location.
File permissions could be reason of your problems.
First of all try /usr/local/bin/perl -MDBI -e'1' as root, then
try
as user of the apache server.
May be you have too strict umask for root.

----- Original Message -----
From: “Bill Sandiford” bill@telnetcommunications.com
To: “Ruslan Zakirov” ruslan.zakirov@gmail.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 11:25 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hi Ruslan:

yes you are correct about the distro Perl

/usr/bin/perl -v — gives output of 5.8.0
/usr/local/bin/perl -v — gives output of 5.8.7

running ‘locate DBI’ comes back with no response, same thing for
’locate
DBI.pm’ if that matters

when you are referring to the configure script, what configure
script
are
you referring to…for what package.

I installed DBI and every other perl module from cpan, mostly by
using
’make fixdeps’

DBI is version 1.48

Bill

----- Original Message -----
From: “Ruslan Zakirov” ruslan.zakirov@gmail.com
To: “Bill Sandiford” bill@telnetcommunications.com
Cc: rt-users@lists.bestpractical.com
Sent: Saturday, October 08, 2005 7:18 PM
Subject: Re: [rt-users] Problem with new install of RT 3.4.4

Hello All:

I’m having a problem with a new install of RT. I’ve searched
through
google
and the list archive and found other people that have had
similar
problems,
but was unable to put my hand on a solution.

Basically, everything went fine, install of everything was
good,
there
were
some dependencies that were missing but i fixed that with the
make
testdeps,
make fixdeps procedure.

I added the relevant info to the bottom of my httpd.conf file
as
per
the
ManualInstallation guide, restarted apache, and when I browse
to
the
page
I
get a 500 Internal server error.

When I look at apache’s error_log I get:

[Sat Oct 8 16:28:12 2005] [error] Can’t locate object method
"connect"
via
package “DBI” at
/usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
line
108.\n

I have verified that DBI is installed, (make testdeps
confirmed).
I
tried
removing and re-installing DBI with cpan but there was no
change…I
still
get the same error.
Please run ‘locate DBI’ from shell.
I think you installed perl and also have distro’s perl
installed.
By
default configure script choose default perl in ‘/usr/bin/perl’.
You
have to run
PERL=/usr/local/bin/perl ./configure.
Also you use mod_perl then you have to build it against perl you
want
to use with RT.

Hope this would help you.

Here are my versions.

RT 3.4.4
uname -a: Linux localhost 2.4.21-4.ELsmp #1 SMP Fri Oct 3
17:52:56
EDT
2003
i686 i686 i386 GNU/Linux
mysql 4.1.14
Apache 1.3.33
mod_perl 1.29
perl v5.8.7

Any help would be appreciated !!!

Regards,
Bill


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at
http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!

Download a free sample chapter from
http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at
http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from
http://rtbook.bestpractical.com


Best regards, Ruslan.


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT Wiki at http://wiki.bestpractical.com

Buy your copy of our new book, RT Essentials, today!
Download a free sample chapter from http://rtbook.bestpractical.com


Best regards, Ruslan.


Best regards, Ruslan.

Best regards, Ruslan.