On Oct 5, 2007, at 4:17 AM, Marco Avvisano wrote:
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.htmlM.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 changethe 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--
PGP.sig
Description: This is a digitally signed message part
_______________________________________________ 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
