These are only some errors from my http error log:
[[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: DBD::mysql::st execute failed: You
have an error in your SQL syntax near 'ON ( ObjectCustomFields_1.CustomField
= main.id ) WHERE (main.Disabled = '0') A' at line 1 at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
505., referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: RT::Handle=HASH(0xad562ec)
couldn't execute the query 'SELECT DISTINCT main.* FROM CustomFields main
JOIN ObjectCustomFields ObjectCustomFields_1 ON (
ObjectCustomFields_1.CustomField = main.id ) WHERE (main.Disabled = '0')
AND (ObjectCustomFields_1.ObjectId = '3' OR ObjectCustomFields_1.ObjectId =
'0') AND (main.LookupType = 'RT::Queue-RT::Ticket') ORDER BY
ObjectCustomFields_1.ObjectId ASC, ObjectCustomFields_1.SortOrder ASC ' at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line
518, referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xad562ec)',
'SELECT DISTINCT main.* FROM CustomFields main JOIN ObjectCust...') called
at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 238,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::_DoSearch('RT::CustomFields=HASH(0xb0b47c0)') called
at /opt/rt3/lib/RT/CustomFields_Overlay.pm line 172, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!RT::CustomFields::_DoSearch('RT::CustomFields=HASH(0xb0b47c0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 498,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Next('RT::CustomFields=HASH(0xb0b47c0)') called at
/opt/rt3/lib/RT/CustomFields_Overlay.pm line 190, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!RT::CustomFields::Next('RT::CustomFields=HASH(0xb0b47c0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 555,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::First('RT::CustomFields=HASH(0xb0b47c0)') called at
/opt/rt3/share/html/Ticket/Elements/ShowSummary line 57, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x9d5bcc0)',
'Attachments', 'RT::Attachments=HASH(0xad45010)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0b47e4)',
'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)', 'Attachments',
'RT::Attachments=HASH(0xad45010)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1252,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0x9d5bcc0)', 'Attachments',
'RT::Attachments=HASH(0xad45010)') called at
/opt/rt3/share/html/Ticket/Display.html line 58, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !HTML::Mason::Commands::__ANON__()
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm
line 1335, referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1335,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::content('HTML::Mason::Request::CGI=HASH(0xb079b8c)')
called at /opt/rt3/share/html/Widgets/TitleBox line 51, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('title', 'Metadati del ticket') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xafe99c0)',
'title', 'Metadati del ticket') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xad562ec)',
'SELECT DISTINCT main.* FROM Users main JOIN Principals Princi...') called
at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 238,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::_DoSearch('RT::Users=HASH(0xb0c4474)') called at
/opt/rt3/lib/RT/Users_Overlay.pm line 137, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!RT::Users::_DoSearch('RT::Users=HASH(0xb0c4474)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/DBIx/SearchBuilder.pm line 498,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!DBIx::SearchBuilder::Next('RT::Users=HASH(0xb0c4474)') called at
/opt/rt3/share/html/Ticket/Elements/ShowGroupMembers line 51, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('Group', 'RT::Group=HASH(0xb0c02e8)',
'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm line 135,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0dcb4c)',
'Group', 'RT::Group=HASH(0xb0c02e8)', 'Ticket',
'RT::Ticket=HASH(0x9d5bcc0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1252,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::comp('undef', 'undef', 'Group',
'RT::Group=HASH(0xb0c02e8)', 'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)') called
at /opt/rt3/share/html/Ticket/Elements/ShowPeople line 55, referer:
http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Commands::__ANON__('Ticket', 'RT::Ticket=HASH(0x9d5bcc0)')
called at /usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Component.pm
line 135, referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xb0cef1c)',
'Ticket', 'RT::Ticket=HASH(0x9d5bcc0)') called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1262,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr: !eval {...} called at
/usr/local/perl-5.8.5/lib/site_perl/5.8.5/HTML/Mason/Request.pm line 1252,
referer: http://monit.regione.toscana.it/index.html
[Fri Oct 05 10:05:48 2007] [error] [client 10.110.23.12] FastCGI: server
"/opt/rt3/bin/mason_handler.fcgi" stderr:
!HTML::Mason::Request::comp('undef', 'undef', 'Ticket',
'RT::Ticket=HASH(0x9d5bcc0)') called at
/opt/rt3/share/html/Ticket/Elements/ShowSummary line 67, referer:
http://monit.regione.toscana.it/index.html
M.
On Wed, Oct 03, 2007 at 01:22:47PM +0200, Marco Avvisano wrote:
I have installed Rt 3.6.5 ( Red Hat Enterprise Linux ES release 3),
and i see a lot of error in my http errors log:
FastCGI: server "/opt/rt3/bin/mason_handler.fcgi" stderr:
Did you miss the actual error?
I used these http configuration:
### NameVirtualHost *:80
### <VirtualHost *:80>
### ServerAdmin root
### ServerName your.host.name
### DocumentRoot /opt/rt3/share/html/
### AddDefaultCharset UTF-8
### # Adding the following for RT (the ticket tracker)
### AddHandler fastcgi-script .fcgi
### <Directory "/opt/rt3/share/html">
### Options FollowSymLinks ExecCGI
### AllowOverride None
### </Directory>
### # Pass through requests to for noauth
### Alias /NoAuth/images /opt/rt3/share/html/NoAuth/images
### ScriptAlias / /opt/rt3/bin/mason_handler.fcgi/
### </VirtualHost>
### FastCgiIpcDir /tmp
### FastCgiServer /opt/rt3/bin/mason_handler.fcgi -idle-timeout
120 -processes 4
Any ideas?
I also have problems, from the web, to see group/users created, and
change
the person to assign
ticket (from root login, only nobody user)
thanks for suggestions
Marco
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
--
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
