Re: [rt-users] errors on 3.6.5

2007-10-05 Thread Marco Avvisano 


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

RE: [rt-users] Status of the RT AssetTracker.

2007-10-05 Thread Jose Antonio Canton Olid 
Hello

The company where I work is wondering about use Asset Tracker, but the
link referenced in the last mail in the communication below do not works
properly. The tar.gz is decompressed with errors.

Please, can somebody solve the tar.gz or make accessible the asset
tracker from other site?

Thanks for your help
Josep



-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew
Ruthven
Sent: viernes, 20 de julio de 2007 8:28
To: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Status of the RT AssetTracker.

Hi guys,

Is there a publically accessible demo site for AssetTracker?

I'm thinking about using, but before I install it I'd like to try it
out.

The main feature I'm looking at is tracking components in computers.

Cheers!

On Thu, 2007-07-12 at 14:49 -0400, Jason A. Smith wrote:
 Is the RT AssetTracker project still alive?  I noticed that its old
home
 is still gone, except for a link to the last available source package:
 
 http://atwiki.chaka.net/at-1.2.3.tar.gz
 
 There is also a new SourceForge project that was created for it a few
 months ago:
 
 http://sourceforge.net/projects/rtat/

-- 
Andrew Ruthven
Wellington, New Zealand
At home: [EMAIL PROTECTED]   |  This space intentionally
 |left blank.

___
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


--
This e-mail and the documents attached are confidential and intended solely
for the addressee; it may also be privileged. If you receive this e-mail
in error, please notify the sender immediately and destroy it.
As its integrity cannot be secured on the Internet, the Atos Origin group
liability cannot be triggered for the message content. Although the
sender endeavours to maintain a computer virus-free network, the sender does
not warrant that this transmission is virus-free and will not be liable for
any damages resulting from any virus transmitted.

Este mensaje y los ficheros adjuntos pueden contener informacion
confidencial destinada solamente a la(s) persona(s) mencionadas
anteriormente. Pueden estar protegidos por secreto profesional Si usted
recibe este correo electronico por error, gracias de informar inmediatamente
al remitente y destruir el mensaje.
Al no estar asegurada la integridad de este mensaje sobre la red, Atos
Origin no se hace responsable por su contenido. Su contenido no constituye
ningun compromiso para el grupo Atos Origin, salvo ratificacion escrita por
ambas partes.
Aunque se esfuerza al maximo por mantener su red libre de virus, el emisor
no puede garantizar nada al respecto y no sera responsable de cualesquiera
danos que puedan resultar de una transmision de virus
--

___
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

[rt-users] RT sends 3 failure messages

2007-10-05 Thread Thomas Simmons 

Hi Everyone,
RT is setup and everything is working great for the most part. I'm using 
the LDAP overlay to auto create accounts when someone with an existing 
email sends a request. This works fine, but when someone sends an email 
that does not exist in LDAP, three messages are returned to this user. I 
would like to have only one email sent. I don't know if it has anything 
to do with my problems, but to get auto-creation to work, I had to give 
everyone the CreateTicket right, though the wiki claims this is not 
necessary. Any help would be really appreciated. The three emails are below.


User Could Not Be Loaded

User  '[EMAIL PROTECTED]' could not be loaded in the mail gateway


User Could Not Be Created

User creation failed in mailgateway: Could not set user info


Could Not Load A Valid User

RT could not load a valid user, and RT's configuration does not allow
for the creation of a new user for your email.


___
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

RE: [rt-users] Status of the RT AssetTracker.

2007-10-05 Thread Stephen Turner 

At Friday 10/5/2007 07:53 AM, Jose Antonio Canton Olid wrote:

Hello

The company where I work is wondering about use Asset Tracker, but the
link referenced in the last mail in the communication below do not works
properly. The tar.gz is decompressed with errors.

Please, can somebody solve the tar.gz or make accessible the asset
tracker from other site?

Thanks for your help
Josep


Jose,

I was able to download and decompress the tar.gz file two days ago, 
so I think the file is OK. I'd recommend giving it another try.


Steve 


___
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

[rt-users] time one hour off

2007-10-05 Thread Todd 
I have just completed a new install of RT 3.6.5 on Ubuntu 7.04, the  
install went great and everything seems to be working properly except  
the time as recorded by RT is one hour in the future of the system  
clock.  I'm guessing that this is a DST issue but I'm not sure. Has  
anyone seen this or know of a fix.


Thanks

Todd
___
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

Re: [rt-users] errors on 3.6.5

2007-10-05 Thread Jesse Vincent 
That looks like you somehow might not have initialized the database  
correctly.



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: