RT 3 times out on a ticket

RT Users
1

I have a ticket which I can’t see in RT 3.0. Syslog says:

Jun 10 00:37:13 strontium postgres[4456]: [1] DEBUG: connection:
host=127.0.0.1 user=rt database=rt3
Jun 10 00:37:13 strontium RT: Database handle destroyed without
explicit disconnect at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm
line 269. (/usr/share/perl5/RT.pm:222)
Jun 10 04:37:22 strontium postgres[4455]: [2] DEBUG: pq_recvbuf:
unexpected EOF on client connection

(One interesting (although not necessarily relevant) piece of
information is that the above lines are logged within a minute of
each other, and the timestamp on the last one is wrong by 4 hours –
which is my UTC offset.)

Any clues? Other tickets work fine.

meeroh

http://web.meeroh.org/ | KB1FMP

A: Because it reverses the logical flow of conversation.
Q: Why is top posting frowned upon?

2

I’m starting to install RT3.

When installing the prerequisites, via the provided script, I’m running
into a problem with libapreq-1.1. I have mod_perl installed (FreeBSD-4.8)
as bsdpan-mod_perl-1.27_01-dev, but this module insists upon downloading
mod_perl-1.27 - and it’s not clear to me why it’s not finding the mod_perl
that I have installed, or if I can override that with a variable?

Thanks.

3

Dear Forrest,

I have had repeated problems with newer modules installed by CPAN being ignored by CPAN.  I have found that if a module is already installed in the default <whatever>/lib/perl5/<module-stuff> CPAN then installs the new module in <whatever>/lib/perl5/site_perl/<module-stuff> but still thinks the module is out of date (when doing CPAN 'r' recommend option).

If I manually remove the one at the higher level, usually the older one ( find . -name <module.pm> -exec grep VERSION {} \; ), then the problem seems to be fixed for that module.  I have been having to do this for each module to get CPAN to think it's updated.

I don't know if this is your problem, but I have tried posting to 'CPAN-testers' and 'perl-beginners' and don't have an answer yet.

The script to 'test-deps' uses CPAN and also looks for specific versions, so a <*-dev> might not be recognized by RT.

HTH.

Greg

Gregory L. Hering
(256) 722-6420
4807 Bradford Dr
Benchmark Electronics, Inc.
Hunvtsville, Al 35805-----Original Message-----
From: Forrest Aldrich [mailto:forrie@forrie.com]
Sent: Tuesday, June 10, 2003 4:40 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Installing prerequisite perl modules

I’m starting to install RT3.

When installing the prerequisites, via the provided script, I’m running
into a problem with libapreq-1.1. I have mod_perl installed (FreeBSD-4.8)
as bsdpan-mod_perl-1.27_01-dev, but this module insists upon downloading
mod_perl-1.27 - and it’s not clear to me why it’s not finding the mod_perl
that I have installed, or if I can override that with a variable?

Thanks.

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

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

4

Hi Greg,

Turns out the problem has to do with Apache::test (Found in another
module). Though I am able to find “test.pm” in the perl library directory,
so it appears to really be there. Someone told me privately that CPAN
often ignorantly requires higher versions of modules that aren’t always
required.

I’m letting the process continue (prerequisite installation) to see what
else happens.

Thanks.

At 05:55 PM 6/10/2003, Greg.Hering@bench.com wrote:

5

What SearchBuilder are you running? There was a bug in 0.84.On Tue, Jun 10, 2003 at 04:52:45PM -0400, Miro Jurisic wrote:

I have a ticket which I can’t see in RT 3.0. Syslog says:

Jun 10 00:37:13 strontium postgres[4456]: [1] DEBUG: connection:
host=127.0.0.1 user=rt database=rt3
Jun 10 00:37:13 strontium RT: Database handle destroyed without
explicit disconnect at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm
line 269. (/usr/share/perl5/RT.pm:222)
Jun 10 04:37:22 strontium postgres[4455]: [2] DEBUG: pq_recvbuf:
unexpected EOF on client connection

(One interesting (although not necessarily relevant) piece of
information is that the above lines are logged within a minute of
each other, and the timestamp on the last one is wrong by 4 hours –
which is my UTC offset.)

Any clues? Other tickets work fine.

meeroh

http://web.meeroh.org/ | KB1FMP

A: Because it reverses the logical flow of conversation.
Q: Why is top posting frowned upon?

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

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

Request Tracker... So much more than a help desk — Best Practical Solutions – Trouble Ticketing. Free.

6

This one time, at band camp, Miro Jurisic wrote:

I have a ticket which I can’t see in RT 3.0. Syslog says:

Which version of RT? Which version of DBIx::SearchBuilder?

(One interesting (although not necessarily relevant) piece of
information is that the above lines are logged within a minute of
each other, and the timestamp on the last one is wrong by 4 hours –
which is my UTC offset.)

Are you using syslog or LogToFile?

jaq@spacepants.org http://spacepants.org/jaq.gpg

7

At 11:24 AM +1000 6/11/03, Jamie Wilkinson wrote:

This one time, at band camp, Miro Jurisic wrote:

I have a ticket which I can’t see in RT 3.0. Syslog says:

Which version of RT?

3.0.0

Which version of DBIx::SearchBuilder?

0.80

Are you using syslog or LogToFile?

Syslog.

It would appear that this ticket got hosed after (while?) an
attachment was added to it by a user, but that could be a red
herring. And since I can’t look at the ticket, I can’t check :slight_smile:

meeroh

http://web.meeroh.org/ | KB1FMP

A: Because it reverses the logical flow of conversation.
Q: Why is top posting frowned upon?

8

Dear Forrest,

I am able to find three 'test.pm' modules in my Linux installation:

/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/Apache/test.pm
/usr/lib/perl5/site_perl/5.8.0/Mail/Mailer/test.pm
/usr/lib/perl5/5.8.0/Test.pm

but they are different. Is this what you are seeing?

I have posted several queries about the problem I described with no response so I have filed a bug report against CPAN. Also, I just found out about CPANPLUS today so I’m going to be doing some reading on that.

Remember that CPAN doesn’t ‘require’ anything; it recommends. When you run ‘sbin/rt-test-dependencies’ (or ‘make testdeps’) you are running a program which uses CPAN but the required dependencies, and version numbers when present, are RT requirements, not CPAN’s.

Sincerely,

Greg

Gregory L. Hering
(256) 722-6420
4807 Bradford Dr
Benchmark Electronics, Inc.
Hunvtsville, Al 35805From: Forrest Aldrich [mailto:forrie@forrie.com]
Sent: Tuesday, June 10, 2003 5:03 PM
To: rt-users@lists.fsck.com
Subject: RE: [rt-users] Installing prerequisite perl modules

Hi Greg,

Turns out the problem has to do with Apache::test (Found in another
module). Though I am able to find “test.pm” in the perl library directory,
so it appears to really be there. Someone told me privately that CPAN
often ignorantly requires higher versions of modules that aren’t always
required.

I’m letting the process continue (prerequisite installation) to see what
else happens.

Thanks.

At 05:55 PM 6/10/2003, Greg.Hering@bench.com wrote:

Dear Forrest,

    I have had repeated problems with newer modules installed by CPAN

being ignored by CPAN. I have found that if a module is already
installed in the default /lib/perl5/ CPAN then
installs the new module in /lib/perl5/site_perl/
but still thinks the module is out of date (when doing CPAN ‘r’ recommend
option).

    If I manually remove the one at the higher level, usually the

older one ( find . -name <module.pm> -exec grep VERSION {} ; ), then the
problem seems to be fixed for that module. I have been having to do this
for each module to get CPAN to think it’s updated.

    I don't know if this is your problem, but I have tried posting to

‘CPAN-testers’ and ‘perl-beginners’ and don’t have an answer yet.

    The script to 'test-deps' uses CPAN and also looks for specific

versions, so a <*-dev> might not be recognized by RT.

HTH.

Greg

Gregory L. Hering
(256) 722-6420
4807 Bradford Dr
Benchmark Electronics, Inc.
Hunvtsville, Al 35805

-----Original Message-----
From: Forrest Aldrich [mailto:forrie@forrie.com]
Sent: Tuesday, June 10, 2003 4:40 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Installing prerequisite perl modules

I’m starting to install RT3.

When installing the prerequisites, via the provided script, I’m running
into a problem with libapreq-1.1. I have mod_perl installed (FreeBSD-4.8)
as bsdpan-mod_perl-1.27_01-dev, but this module insists upon downloading
mod_perl-1.27 - and it’s not clear to me why it’s not finding the mod_perl
that I have installed, or if I can override that with a variable?

Thanks.

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

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

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

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

9

Greg,

I managed to get RT 3.0.2 running yesterday. I believe the Apache::test
module is a part of the Apache CPAN bundle.

I had to manually install the DBD-mysql module, because the test continued
to fail, and there wasn’t a way for me to pass options to that during the
prerequisites installation (I have passwords on my mysql.user accounts, and
it assumes none with root and mysql.test).

The RT system seems to be working okay otherwise. I believe the
Apache::test module was a prerequisite of yet another Bundle that was
installed. I’ve never seen so many prerequisites! :slight_smile:

That’s the best I can tell thus far.

I’ll take a look at the CPANPLUS page, it looks promising.

/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/Apache/test.pm
[ … ]

This looks like Apache::test

/usr/lib/perl5/site_perl/5.8.0/Mail/Mailer/test.pm
[ … ]

Mailer::test

/usr/lib/perl5/5.8.0/Test.pm
[ … ]

Bundle::Test? Never heard of this one.

So think you have three different ones… and if it’s really Apache::test
that was being sought, it looks like you have it.

I’ve run into issues using CPAN before, whereby you don’t necessarily HAVE
to install a later version of certain modules, and it will refuse to build
them without - but if you do it manually, they work fine. One developer
warned me of this a while ago, and it’s annoying.

Are you able to get RT running?

I had more of a devilish time getting mod_perl-1.x compiled and installed -
I hope MP2 and Apache2 have a better, cleaner installation method - it was
insanity. :slight_smile:

Forrest

10

Turns out that postgres was logging an error because the client
(apache) was crashing. Apache was crashing in libcrypto, which was
getting called because my RT and postgres were configured to use SSL.
Since the RT instance and the database server are running on the same
machine (for now), I was able to change the connection from SSL to
Unix domain socket, and now everything works fine.

meeroh

http://web.meeroh.org/ | KB1FMP

A: Because it reverses the logical flow of conversation.
Q: Why is top posting frowned upon?

11

Looking through the list archives, I see that many have problems
installing the Apache::Request module for RT. Why is this? Perhaps
libapreq is a fragile block in RT’s foundation?

At any rate, here’s the context for my problem with it:

RedHat Enterprise Server ES 2.1
Perl 5.6.1
PostgreSQL 7.3.3
Apache httpd 1.3.27, mod_perl 1.27
RT 3.0.2

The only thing still missing:

sbin/rt-test-dependencies --with-postgresql --with-modperl1 | grep MISS

    Apache::Request ...MISSING

Tried downloading and installing libapreq-1.2 with and without cpan;
“make test” always fails with same result:

…
/usr/local/apache/bin/httpd -X -d /root/libapreq-1.2/t -f
/root/libapreq-1.2/t/conf/httpd.conf -DAPACHE1
using Apache/1.3.27

waiting for server to start: .
waiting for server to start: ok (waited 0 secs)
server localhost.localdomain:8529 started
apreq/big_input…FAILED tests
1-21
Failed 21/21 tests, 0.00% okay
apreq/cookie…FAILED test
1
Failed 1/1 tests, 0.00% okay
apreq/inherit…FAILED test
1
Failed 1/1 tests, 0.00% okay
apreq/request…FAILED tests
1-2
Failed 2/2 tests, 0.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
apreq/big_input.t 21 21 100.00% 1-21
apreq/cookie.t 1 1 100.00% 1
apreq/inherit.t 1 1 100.00% 1
apreq/request.t 2 2 100.00% 1-2
*** server localhost.localdomain:8529 shutdown
!!! error running tests (please examine t/logs/error_log)
make: *** [run_tests] Error 1

Help?

  • Carl
12

This one caught me off guard as well.

It turns out that apache doesn’t like to be run as root, which is what you usually run the CPAN module as. So, you need to kill off any orphaned httpd processes which were left by the test, and then move/copy/chmod the apache-request install directory to where it can be read/written to by a non-root user, then manaully execute the standard process (perl Makefile.pl ; make ; make test and if that works, then, make install).

It worked for me.

Good luck,

Val-----Original Message-----
From: Carl Gibbons [mailto:cgibbons@du.edu]
Sent: Monday, June 23, 2003 2:12 PM
To: rt-users@lists.fsck.com
Subject: [rt-users] Installing prerequisite perl modules

Looking through the list archives, I see that many have problems
installing the Apache::Request module for RT. Why is this? Perhaps
libapreq is a fragile block in RT’s foundation?

At any rate, here’s the context for my problem with it:

RedHat Enterprise Server ES 2.1
Perl 5.6.1
PostgreSQL 7.3.3
Apache httpd 1.3.27, mod_perl 1.27
RT 3.0.2

The only thing still missing:

sbin/rt-test-dependencies --with-postgresql --with-modperl1 | grep MISS

    Apache::Request ...MISSING

Tried downloading and installing libapreq-1.2 with and without cpan;
“make test” always fails with same result:

…
/usr/local/apache/bin/httpd -X -d /root/libapreq-1.2/t -f
/root/libapreq-1.2/t/conf/httpd.conf -DAPACHE1
using Apache/1.3.27

waiting for server to start: .
waiting for server to start: ok (waited 0 secs)
server localhost.localdomain:8529 started
apreq/big_input…FAILED tests
1-21
Failed 21/21 tests, 0.00% okay
apreq/cookie…FAILED test
1
Failed 1/1 tests, 0.00% okay
apreq/inherit…FAILED test
1
Failed 1/1 tests, 0.00% okay
apreq/request…FAILED tests
1-2
Failed 2/2 tests, 0.00% okay
Failed Test Stat Wstat Total Fail Failed List of Failed
apreq/big_input.t 21 21 100.00% 1-21
apreq/cookie.t 1 1 100.00% 1
apreq/inherit.t 1 1 100.00% 1
apreq/request.t 2 2 100.00% 1-2
*** server localhost.localdomain:8529 shutdown
!!! error running tests (please examine t/logs/error_log)
make: *** [run_tests] Error 1

Help?

  • Carl

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

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

13

Hi All

I am getting ready to upgrade my RT 2.0.13 to RT 3-0-3. I was looking at
the installation procedure and only thing I saw regarding upgrade is
with RT3.x series. Is there any import tool I can use ?

Thanks
Asif Iqbal
http://pgpkeys.mit.edu:11371/pks/lookup?op=get&search=0x8B686E08
There’s no place like 127.0.0.1