RT 3.6.1 Logging

I cannot get RT to log any errors… not sure why.

I followed early posts and Wiki / Internet instructions.

I “DO” get one PERL error:

RT: DBD::mysql::st execute failed: Unknown column ‘main.LookupType’ in
’where clause’

I did all the schema upgrades.

Is there a way to fix this on an in place Production machine?

Regards,

Bob

Got RT logging working.

Seeing a lot of debug info, but “appears” my issues lie with the

RT: DBD::mysql::st execute failed: Unknown column ‘main.LookupType’ in
’where clause’

Error.

Any assistance would be greatly appreciated.

I searched and searched before bothering the list members with this.

Thanks

BFFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Saturday, August 26, 2006 10:25 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT 3.6.1 Logging

I cannot get RT to log any errors… not sure why.

I followed early posts and Wiki / Internet instructions.

I “DO” get one PERL error:

RT: DBD::mysql::st execute failed: Unknown column ‘main.LookupType’ in
’where clause’

I did all the schema upgrades.

Is there a way to fix this on an in place Production machine?

Regards,

Bob

Rebuilt RT on this box, installed Jesse’s CGI patch and got rid of the
PERL error below.

Now two things happened:

When upgrading I got this error:

readline() on closed filehandle SCHEMA_LOCAL at
/opt/rt3/sbin/rt-setup-database line 192

Then while using RT, it is VERY slow, and I get these errors: ( I
flushed the Mason cache )

[Sun Aug 27 09:51:07 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:54:51 2006] [error] [Mason] File does not exist:
/opt/rt3/share/html/favicon.ico

Aug 27 09:54:52 help RT: prepare_cached( SELECT
a_session FROM sessions WHERE id = ?) statement handle
DBI::st=HASH(0xac09370) still Active at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 80
(/usr/lib/perl5/5.8.8/Carp.pm:271)

Aug 27 09:56:03 help RT: prepare_cached( SELECT
a_session FROM sessions WHERE id = ?) statement handle
DBI::st=HASH(0xac0eba4) still Active at
/usr/lib/perl5/vendor_perl/5.8.8/Apache/Session/Store/DBI.pm line 80
(/usr/lib/perl5/5.8.8/Carp.pm:271)

[Sun Aug 27 09:56:51 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:56:51 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:56:54 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:56:55 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:57:07 2006] [error] [Mason] File does not exist:
/opt/rt3/share/html/favicon.ico

[Sun Aug 27 09:57:57 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:57:59 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:58:01 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:58:03 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

Aug 27 09:58:06 help RT: Successful login for rf from 192.168.250.26
(/opt/rt3/share/html/autohandler:244)

[Sun Aug 27 09:58:38 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:58:39 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:58:44 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:58:48 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:59:23 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:59:25 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

[Sun Aug 27 09:59:43 2006] [info] [client 192.168.250.26]
(104)Connection reset by peer: core_output_filter: writing data to the
network

[Sun Aug 27 09:59:44 2006] [info] [client 192.168.250.26] (32)Broken
pipe: core_output_filter: writing data to the network

Any help would be appreciated, for if this does not work, I need to put
the RT 3.0.11 box back online.

BobFrom: Farrell,Bob
Sent: Saturday, August 26, 2006 3:31 PM
To: Farrell,Bob; rt-users@lists.bestpractical.com
Subject: RE: [rt-users] RT 3.6.1 Logging

Got RT logging working.

Seeing a lot of debug info, but “appears” my issues lie with the

RT: DBD::mysql::st execute failed: Unknown column ‘main.LookupType’ in
’where clause’

Error.

Any assistance would be greatly appreciated.

I searched and searched before bothering the list members with this.

Thanks

BF

From: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of
Farrell,Bob
Sent: Saturday, August 26, 2006 10:25 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT 3.6.1 Logging

I cannot get RT to log any errors… not sure why.

I followed early posts and Wiki / Internet instructions.

I “DO” get one PERL error:

RT: DBD::mysql::st execute failed: Unknown column ‘main.LookupType’ in
’where clause’

I did all the schema upgrades.

Is there a way to fix this on an in place Production machine?

Regards,

Bob