[rt-users] RT-Extension-Assets : Howto change Elements/MyAssets to show assets for all users

2015-08-25 Thread Carl van Litsenborgh
Hi,

How can I change/modify either Elements/MyAssets OR User/Elements/AssetList (or 
both) to show assets for ALL users, and not only the logged-in user?

Any help suggestions would be appreciated.

Thank you.

Carl van Litsenborgh


Re: [rt-users] No outbound email after upgrade

2015-08-25 Thread Ditri, Chris
Hi Matt, and thanks for your response.

I have tried this.  It still produces nothing.  Here is what I added to my 
RT_SiteConfig.pm:

Set($MailCommand, mbox);
Set($SendmailPath, /usr/lib/sendmail);
Set($SendmailArguments, -t);
Set($OwnerEmail, m...@workplace.com); 


I have also tried:
Set($MailCommand, sendmailpipe);
Set($MailCommand, smtp);
Set($MailCommand, sendmail);
Set($MailCommand, test);

I do a '/etc/init.d/request-tracker4 restart' after each, and even try 
rebooting.  No good.

I'm sure I'm missing something silly here... but I just don't know what it is...

Any other suggestions?

Thank you.





From: Matt Zagrabelny mzagr...@d.umn.edu
Sent: Friday, August 21, 2015 4:05 PM
To: Ditri, Chris
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] No outbound email after upgrade

On Fri, Aug 21, 2015 at 2:09 PM, Ditri, Chris cdi...@experi-metal.com wrote:

 But, it was always able to send emails with no problem through exim, and I 
 can send emails from the bash command prompt with no problem as well.

From RT_Config.pm:

$MailCommand
$MailCommand defines which method RT will use to try to send mail.
We know that 'sendmailpipe' works fairly well. If 'sendmailpipe'
doesn't work well for you, try 'sendmail'. 'qmail' is also a
supported value.

For testing purposes, or to simply disable sending mail out into the
world, you can set $MailCommand to 'mbox' which logs all mail, in
mbox format, to files in /opt/rt4/var/ based in the process start
time. The 'testfile' option is similar, but the files that it
creates (under /tmp) are temporary, and removed upon process
completion; the format is also not mbox-compatable.

Perhaps try setting MailCommand to mbox or testfile.

-m


Re: [rt-users] No outbound email after upgrade

2015-08-25 Thread Matt Zagrabelny
On Tue, Aug 25, 2015 at 10:00 AM, Ditri, Chris cdi...@experi-metal.com wrote:
 Hi Matt, and thanks for your response.

 I have tried this.  It still produces nothing.  Here is what I added to my 
 RT_SiteConfig.pm:

 Set($MailCommand, mbox);
 Set($SendmailPath, /usr/lib/sendmail);
 Set($SendmailArguments, -t);
 Set($OwnerEmail, m...@workplace.com);


 I have also tried:
 Set($MailCommand, sendmailpipe);
 Set($MailCommand, smtp);
 Set($MailCommand, sendmail);
 Set($MailCommand, test);

 I do a '/etc/init.d/request-tracker4 restart' after each, and even try 
 rebooting.  No good.

 I'm sure I'm missing something silly here... but I just don't know what it 
 is...

 Any other suggestions?

It looks like you are using Debian. Are you using the SiteConfig.d
directory and running update-rt-siteconfig before restarting apache?

Other things you could try:

Set($LogStackTraces, 'debug');
Set($LogToSTDERR, 'debug');

then check the apache error log (/var/log/apache2/error.log)  for output.

-m


Re: [rt-users] Problem with extension RepeatTicket

2015-08-25 Thread Moose
Hmmm... I'm unsure what is causing that for you.

When I open a console window and run the 'daily' command on it's own
(/usr/local/share/request-tracker4/plugins/RT-Extension-RepeatTicket/bin/rt-repeat-ticket
--type daily) then ALL daily recurrence tickets get repeated, regardless of
the day of the week I have chosen on the Ticket Recurrence tab.

The same happens for the 'weekly' 'monthly'  'yearly' commands when dealing
with 'weekly', 'monthly'  'yearly' recurrence tickets. This is why I
created the 4 cronjobs - to workaround the fact that individual recurrence
settings were actually being ignored.

The cronjobs are *supposed* to separately target each of the 4 types of
recurrence ticket. They are timed for the start of the day/week/month/year
and /should/ only fire for the relevant type of recurrence.








--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Problem-with-extension-RepeatTicket-tp60471p60522.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


[rt-users] Prevent ticket creation by email

2015-08-25 Thread Hilling, Matt
Dear all,

I have a queue which has some mandatory custom fields. I wish to prevent ticket 
creation by email for this queue (and not any other queues) but still allow 
communication between requestor and owner by email once the ticket has been 
created. Is this possible? The users will be creating tickets in this queue 
using SelfService. If this cannot be done, but instead the email returned with 
a message stating what to do (ie login to SelfService) then that is fine too.

We are using RT 3.8.8.

Thanks,
Matt.




Re: [rt-users] No outbound email after upgrade

2015-08-25 Thread Matt Zagrabelny
On Tue, Aug 25, 2015 at 11:46 AM, Ditri, Chris cdi...@experi-metal.com wrote:
 Ok...

 After turning the debugging, I captured this from the log:

 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for 
 text/html - Subjectless message 
 (/usr/share/request-tracker4/lib/RT/I18N.pm:295)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for 
 text/html - Subjectless message 
 (/usr/share/request-tracker4/lib/RT/I18N.pm:295)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to prepare scrips for 
 transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:187)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for 
 TransactionCreate stage with applicable type(s) Correspond for txn #8404 on 
 ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to commit scrips for 
 transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:210)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for 
 TransactionBatch stage with applicable type(s) Correspond for txn #8404 on 
 ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4484 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4486 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4488 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4490 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4492 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4495 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4497 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4499 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4504 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4506 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4508 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4510 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4512 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4514 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4516 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4518 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)


 It says it didn't find a script for transaction batch and for transaction 
 create...  Makes me wonder if I'm missing a package?

Not a package. Check your DB or your admin web interface.

SELECT  * from objectscrips;
SELECT  * from scrips;

The objectscrips is how scrips can be selectively applied to individual queues.

-m


Re: [rt-users] No outbound email after upgrade

2015-08-25 Thread Ditri, Chris
Ok...

After turning the debugging, I captured this from the log:

[1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for 
text/html - Subjectless message (/usr/share/request-tracker4/lib/RT/I18N.pm:295)
[1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for 
text/html - Subjectless message (/usr/share/request-tracker4/lib/RT/I18N.pm:295)
[1426] [Tue Aug 25 16:41:21 2015] [debug]: About to prepare scrips for 
transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:187)
[1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for TransactionCreate 
stage with applicable type(s) Correspond for txn #8404 on ticket #621 
(/usr/share/request-tracker4/lib/RT/Scrips.pm:495)
[1426] [Tue Aug 25 16:41:21 2015] [debug]: About to commit scrips for 
transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:210)
[1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for TransactionBatch 
stage with applicable type(s) Correspond for txn #8404 on ticket #621 
(/usr/share/request-tracker4/lib/RT/Scrips.pm:495)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4484 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4486 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4488 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4490 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4492 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4495 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4497 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4499 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4504 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4506 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4508 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4510 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4512 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4514 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4516 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
[1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4518 of 
'text/html' type 
(/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)


It says it didn't find a script for transaction batch and for transaction 
create...  Makes me wonder if I'm missing a package?

Here is what aptitude says I have installed (and what's available):

p   rt-app  - Test application which simulates a real-ti
p   rt-tests- Test programs for rt kernels  
i   rt4-apache2 - Apache 2 specific files for request-tracke
i A rt4-clients - mail gateway and command-line interface to
i   rt4-db-mysql- MySQL database backend for request-tracker
p   rt4-db-postgresql   - PostgreSQL database backend for request-tr
p   rt4-db-sqlite   - SQLite database backend for request-tracke
p   rt4-doc-html- HTML documentation for request-tracker4   
i   rt4-extension-authenexternalaut - External authentication module for request
p   rt4-extension-calendar  - Calendar view for Request Tracker 4   
p   rt4-extension-customfieldsonupd - edit ticket's custom fields on reply/comme
p   rt4-extension-jsgantt   - Gantt charts for Request Tracker  
p   rt4-extension-spawnlinkedticket - quickly spawn linked tickets in 

Re: [rt-users] No outbound email after upgrade

2015-08-25 Thread Ditri, Chris
HI Again,

Yes, I'm using debian.  No, I haven't put it in my RT_SiteConfig.d directory 
because I don't want to lose track of the settings.  When the config is good, I 
will move them into the appropriate file and re-execute my update 
update-rt-siteconfig-4.  I'm trying to keep the debris out of my configs.  It 
only reads RT_SiteConfig.pm, so I don't see any harm in this strategy.

I have set the logging on, thank you for that... lets hope it dumps some useful 
info!

Thanks again.






From: Matt Zagrabelny mzagr...@d.umn.edu
Sent: Tuesday, August 25, 2015 11:13 AM
To: Ditri, Chris
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] No outbound email after upgrade

On Tue, Aug 25, 2015 at 10:00 AM, Ditri, Chris cdi...@experi-metal.com wrote:
 Hi Matt, and thanks for your response.

 I have tried this.  It still produces nothing.  Here is what I added to my 
 RT_SiteConfig.pm:

 Set($MailCommand, mbox);
 Set($SendmailPath, /usr/lib/sendmail);
 Set($SendmailArguments, -t);
 Set($OwnerEmail, m...@workplace.com);


 I have also tried:
 Set($MailCommand, sendmailpipe);
 Set($MailCommand, smtp);
 Set($MailCommand, sendmail);
 Set($MailCommand, test);

 I do a '/etc/init.d/request-tracker4 restart' after each, and even try 
 rebooting.  No good.

 I'm sure I'm missing something silly here... but I just don't know what it 
 is...

 Any other suggestions?

It looks like you are using Debian. Are you using the SiteConfig.d
directory and running update-rt-siteconfig before restarting apache?

Other things you could try:

Set($LogStackTraces, 'debug');
Set($LogToSTDERR, 'debug');

then check the apache error log (/var/log/apache2/error.log)  for output.

-m


Re: [rt-users] RT-Extension-Assets : Howto change Elements/MyAssets to show assets for all users

2015-08-25 Thread Tony G Palomino
We at Reed recently sponsored an updated version of Assets, which allows
for ticket-like asset searching, and saved asset searches.  You'd be able
to build a saved search that displays all assets in a catalog, with custom
display formatting to boot.  This is in version 1.06, but it doesn't appear
to be posted yet on BP's website.

So my suggestion:  hold on for a bit, it's coming.

Tony

On Tue, Aug 25, 2015 at 7:35 AM, Carl van Litsenborgh 
carl.vanlitsenbo...@za.saabgroup.com wrote:

 Hi,



 How can I change/modify either Elements/MyAssets OR
 User/Elements/AssetList (or both) to show assets for ALL users, and not
 only the logged-in user?



 Any help suggestions would be appreciated.



 Thank you.



 Carl van Litsenborgh




-- 
tony.palom...@reed.edu
Director, Computer User Services
Reed College
503-788-6622


Re: [rt-users] No outbound email after upgrade

2015-08-25 Thread Ditri, Chris
Hi Matt,

There is absolutely nothing in ObjectScrips, and everything is set to NULL in 
Scrips (in the database).

Are you implying that I need to make custom scrips to send routine emails 
regarding tickets?  
Something is different then... I definitely didn't have to do that before... 
must be new between 4.0.7 and 4.2.8 (4.0.7 shipped with Wheezy, and 4.2.8 with 
Jessie).  Was it normal to lose that functionality in the upgrade?

I have never messed with Scrips before... not sure I understand them.  Is there 
a good resource on the subject?

Thank you.








From: Matt Zagrabelny mzagr...@d.umn.edu
Sent: Tuesday, August 25, 2015 12:52 PM
To: Ditri, Chris
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] No outbound email after upgrade

On Tue, Aug 25, 2015 at 11:46 AM, Ditri, Chris cdi...@experi-metal.com wrote:
 Ok...

 After turning the debugging, I captured this from the log:

 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for 
 text/html - Subjectless message 
 (/usr/share/request-tracker4/lib/RT/I18N.pm:295)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Converting 'utf-8' to 'utf-8' for 
 text/html - Subjectless message 
 (/usr/share/request-tracker4/lib/RT/I18N.pm:295)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to prepare scrips for 
 transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:187)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for 
 TransactionCreate stage with applicable type(s) Correspond for txn #8404 on 
 ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: About to commit scrips for 
 transaction #8404 (/usr/share/request-tracker4/lib/RT/Transaction.pm:210)
 [1426] [Tue Aug 25 16:41:21 2015] [debug]: Found 0 scrips for 
 TransactionBatch stage with applicable type(s) Correspond for txn #8404 on 
 ticket #621 (/usr/share/request-tracker4/lib/RT/Scrips.pm:495)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4484 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4486 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4488 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4490 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4492 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4495 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4497 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4499 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4504 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4506 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4508 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4510 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4512 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4514 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4516 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)
 [1426] [Tue Aug 25 16:41:22 2015] [debug]: Rendering attachment #4518 of 
 'text/html' type 
 (/usr/share/request-tracker4/html/Elements/ShowTransactionAttachments:182)


 It says it didn't find a script for transaction batch and for transaction 
 create...  Makes me wonder if I'm missing a package?

Not a package. Check your DB or your admin web interface.

SELECT  * from objectscrips;
SELECT  * from scrips;

The objectscrips is how scrips can be selectively 

[rt-users] no To: field leads to RFC compliant TO required mail server error

2015-08-25 Thread alexander lunev

Hello everyone.

I have upgraded RT system, with following changes:
FreeBSD 6.2 - 10.1
RT 3.8.8 - 4.2.11
Postfix 2.4.6 - Exim 4.85

On the new system i'm having error in mail system RFC compliant TO 
required when RT tries to send mails about my comments on mine ticket. 
As far as i understand the logic behind, RT compose email with ticket's 
author email in To: header, and all other queue's followers in Cc: 
header, then see that it's me, the comment's author, is in To: header, 
and configured for not sending me email about my own comment, strips my 
email and effectively entire To: header from email.


Then there is a difference between old and new system: on the old system 
everything was exactly the same as on the new system (according to email 
headers in rt.log), but emails without To: header somehow were delivered 
to all Cc: addresses, but on the new system i get this error.


Logs from the old system: http://pastebin.com/mUJzFg2m (there is To: 
v...@zato.ru header in the beginning, and then it's gone)
Logs from the new system: http://pastebin.com/2PykYK71 (same with To: 
l...@zato.ru)


Emails from the old system have To: header with 
undisclosed-recipients:; in it. Emails from the new system, according 
to Mailer-Daemon messages, have not.


I think that maybe the old system's Postfix mail server inserting To: 
undisclosed-recipients:; header. I've tried to install and use new 
version of Postfix 2.11.6 with no changes - emails still doesn't delivered.


To overcome this situation i have configured Exim with the following ACL:

acl_check_data:
warn condition = ${if !def:h_To: {1}}
add_header = To: Undisclosed-Recipients:;

But i wonder, if there is a better for populating To: header with 
undisclosed-recipients:;? Or maybe there is something i missed in upgrade? I 
did run rt-setup-database after moving DB to new host, if that's matter.

--
best regards


Re: [rt-users] No outbound email after upgrade

2015-08-25 Thread Ditri, Chris


From: Matt Zagrabelny mzagr...@d.umn.edu
Sent: Tuesday, August 25, 2015 2:55 PM
To: Ditri, Chris
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] No outbound email after upgrade

On Tue, Aug 25, 2015 at 1:43 PM, Ditri, Chris cdi...@experi-metal.com wrote:
 Hi Matt,

 There is absolutely nothing in ObjectScrips, and everything is set to NULL in 
 Scrips (in the database).

 Are you implying that I need to make custom scrips to send routine emails 
 regarding tickets?
 Something is different then... I definitely didn't have to do that before... 
 must be new between 4.0.7 and 4.2.8 (4.0.7 shipped with Wheezy, and 4.2.8 
 with Jessie).  Was it normal to lose that functionality in the upgrade?

Certainly not normal.

You do need to run some upgrade commands (DB scripts) when upgrading
though. The (upstream) upgrade will normally prompt you for what
version of RT you are upgrading from and which one you are upgrading
to. Do you remember seeing that?

For the RT 3.8 Debian package, there was a directory,
/etc/request-tracker3.8/etc/upgrade. Do you have something similar for
RT 4(.2) ?

3.8 was the last time I used the deb package for RT, and I don't
remember what the upgrades were like - I'd imagine it also varies
depending on if you use db-config or not. We use Debian for the OS,
but use upstream tarballs for the RT installation. There is a make
target that handles applying the DB upgrade scripts.

Cheers,

-m


Now that you mention it, Matt, there was an issue with dbconfig-common.  It 
didn't want to take the root password for the the database.  Eventually I got 
it to go through, but there were some errors.  I found a log for 
dbconfig-common... but I honestly don't know why it goofed up, and how tor 
re-run dbconfig common for rt.

Here is the log I found in /var/log/dbconfig-common:

RROR 2002 (HY000): Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2).
unable to connect to mysql server.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
'/var/run/mysqld/mysqld.sock' (2).
unable to connect to mysql server.
granting access to database rtdb for rtuser@localhost: success.
verifying access for rtuser@localhost: success.
creating database rtdb: success.
verifying database rtdb exists: success.
populating database via scriptfile...  done.
dbconfig-common: dumping mysql database rtdb to 
/var/tmp/request-tracker4.rtdb.2013-12-16-14.45.mysql.q3wmxz.
dbconfig-common: dropping mysql database rtdb.
dropping database rtdb: success.
verifying database rtdb was dropped: success.
dbconfig-common: revoking privileges for user rtuser on rtdb.
revoking access to database rtdb from rtuser@localhost: success.
granting access to database rtdb for rtuser@localhost: success.
verifying access for rtuser@localhost: success.
creating database rtdb: success.
verifying database rtdb exists: success.
populating database via scriptfile...  done.
creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES).
unable to connect to mysql server.
creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES).
unable to connect to mysql server.
creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES).
unable to connect to mysql server.
creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES).
unable to connect to mysql server.
creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 
YES).
unable to connect to mysql server.
creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.10.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.12.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.12-2.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.19.
applying upgrade script for 4.0.7-5+deb7u3 - 4.2.3.
applying upgrade script for 4.0.7-5+deb7u3 - 4.2.4.
applying upgrade script for 4.0.7-5+deb7u3 - 4.2.6.
applying upgrade script for 4.0.7-5+deb7u3 - 4.2.7.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.10.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.12.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.12-2.
applying upgrade script for 4.0.7-5+deb7u3 - 4.0.19.
applying upgrade script for 4.0.7-5+deb7u3 - 4.2.3.
creating database backup in 
/var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.

Re: [rt-users] Problem with extension RepeatTicket

2015-08-25 Thread frankfurter
thx for helping,

i changed the cronjobs like you said yesterday, but today i'm still getting
tickets from monday or for example friday. 





--
View this message in context: 
http://requesttracker.8502.n7.nabble.com/Problem-with-extension-RepeatTicket-tp60471p60516.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.


Re: [rt-users] System switched to Install screen

2015-08-25 Thread Joop van de Wege
Felix Bachmann fe...@earthshadow.org schreef op 25 augustus 2015 01:04:29 
CEST:
Hi all,
I am hoping to get some hints for you. I was running version 4.2.4 for
a long time. Today I had some issues with the mysql database server and
after restart RT is always switching to the install screen as if it
doesn’t find the database.
It looks like apache can't access rt_siteconfig.pm.

Joop



Re: [rt-users] System switched to Install screen

2015-08-25 Thread Felix Bachmann
Hi Joop,
I was thinking that too and therefore even gave permissions to all. Didn’t work 
either.
This morning I tried again and everything all of the sudden is working again. I 
have not the slightest idea what was going on.
In any case, thanks for your answer. I will keep an eye on the installation
Kind regards
Felix

On Aug 25, 2015, at 2:05 AM, Joop van de Wege jvdw...@xs4all.nl wrote:

Felix Bachmann fe...@earthshadow.org schreef op 25 augustus 2015 01:04:29 
CEST:
 Hi all,
 I am hoping to get some hints for you. I was running version 4.2.4 for
 a long time. Today I had some issues with the mysql database server and
 after restart RT is always switching to the install screen as if it
 doesn’t find the database.
It looks like apache can't access rt_siteconfig.pm.

Joop





[rt-users] rt::extension::import::csv Configuration isseu

2015-08-25 Thread Barrett, Brian
Hi,
I have the RT::extension::import::CSV working but having a problem with 
importing in the field Held By. Getting the  error:
[warning]: Unknown asset field Held By for column Assigned User, skipping 
(/opt/rt/local/plugins/RT-Extension-Assets-Import-CSV/lib/RT/Extension/Assets/Import/CSV.pm:66)

Below is my configuration in the RT_SiteConfig.pm

Set( $AssetsImportUniqueCF, 'Serial Number' );
Set( %AssetsImportFieldMapping,
'Name'  = 'System Name',
'Catalog'   = \'Neuro Hardware',
'Owner' = \'Neurology',
'Held By'   = 'Assigned User',
'Contact'  = 
\'neurolog...@urmc.rochester.edu',
'CF.Manufacturer'   = 'Make',
'CF.Model'  = 'Model',
'CF.Neuro IT SN #'= 'Neuro IT Tag',
'CF.Serial Number'   = 'Serial Number',
'CF.OS'  = 'OS',
'CF.Location'= 'Location',
'CF.Division' = 'Division',
'CF.Asset Tag'= 'Asset Tag',
'CF.Notes'   = 'Notes',
);
Wondering how I can define the Held By name so it is recognized  
/rt-assets-import-csv?
Thanks
B Barrett
University of Rochester Medical Center


Re: [rt-users] [phish?] RE: No outbound email after upgrade

2015-08-25 Thread Matt Zagrabelny
On Tue, Aug 25, 2015 at 3:39 PM, Ditri, Chris cdi...@experi-metal.com wrote:

 
 From: Matt Zagrabelny mzagr...@d.umn.edu
 Sent: Tuesday, August 25, 2015 2:55 PM
 To: Ditri, Chris
 Cc: rt-users@lists.bestpractical.com
 Subject: Re: [rt-users] No outbound email after upgrade

 On Tue, Aug 25, 2015 at 1:43 PM, Ditri, Chris cdi...@experi-metal.com wrote:
 Hi Matt,

 There is absolutely nothing in ObjectScrips, and everything is set to NULL 
 in Scrips (in the database).

 Are you implying that I need to make custom scrips to send routine emails 
 regarding tickets?
 Something is different then... I definitely didn't have to do that before... 
 must be new between 4.0.7 and 4.2.8 (4.0.7 shipped with Wheezy, and 4.2.8 
 with Jessie).  Was it normal to lose that functionality in the upgrade?

 Certainly not normal.

 You do need to run some upgrade commands (DB scripts) when upgrading
 though. The (upstream) upgrade will normally prompt you for what
 version of RT you are upgrading from and which one you are upgrading
 to. Do you remember seeing that?

 For the RT 3.8 Debian package, there was a directory,
 /etc/request-tracker3.8/etc/upgrade. Do you have something similar for
 RT 4(.2) ?

 3.8 was the last time I used the deb package for RT, and I don't
 remember what the upgrades were like - I'd imagine it also varies
 depending on if you use db-config or not. We use Debian for the OS,
 but use upstream tarballs for the RT installation. There is a make
 target that handles applying the DB upgrade scripts.

 Cheers,

 -m


 Now that you mention it, Matt, there was an issue with dbconfig-common.  It 
 didn't want to take the root password for the the database.  Eventually I got 
 it to go through, but there were some errors.  I found a log for 
 dbconfig-common... but I honestly don't know why it goofed up, and how tor 
 re-run dbconfig common for rt.

I don't know anything about dbconfig-common. I generally stay away
from it, but perhaps it is useful in certain circumstances.

You could always file a Debian bug against the package if it broke
during upgrades. Dom is a very good maintainer.

 Here is the log I found in /var/log/dbconfig-common:

 RROR 2002 (HY000): Can't connect to local MySQL server through socket 
 '/var/run/mysqld/mysqld.sock' (2).
 unable to connect to mysql server.
 ERROR 2002 (HY000): Can't connect to local MySQL server through socket 
 '/var/run/mysqld/mysqld.sock' (2).
 unable to connect to mysql server.
 granting access to database rtdb for rtuser@localhost: success.
 verifying access for rtuser@localhost: success.
 creating database rtdb: success.
 verifying database rtdb exists: success.
 populating database via scriptfile...  done.
 dbconfig-common: dumping mysql database rtdb to 
 /var/tmp/request-tracker4.rtdb.2013-12-16-14.45.mysql.q3wmxz.
 dbconfig-common: dropping mysql database rtdb.
 dropping database rtdb: success.
 verifying database rtdb was dropped: success.
 dbconfig-common: revoking privileges for user rtuser on rtdb.
 revoking access to database rtdb from rtuser@localhost: success.
 granting access to database rtdb for rtuser@localhost: success.
 verifying access for rtuser@localhost: success.
 creating database rtdb: success.
 verifying database rtdb exists: success.
 populating database via scriptfile...  done.
 creating database backup in 
 /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
 password: YES).
 unable to connect to mysql server.
 creating database backup in 
 /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
 password: YES).
 unable to connect to mysql server.
 creating database backup in 
 /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
 password: YES).
 unable to connect to mysql server.
 creating database backup in 
 /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
 password: YES).
 unable to connect to mysql server.
 creating database backup in 
 /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
 ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using 
 password: YES).
 unable to connect to mysql server.
 creating database backup in 
 /var/cache/dbconfig-common/backups/request-tracker4_4.0.7-5+deb7u3.mysql.
 applying upgrade script for 4.0.7-5+deb7u3 - 4.0.10.
 applying upgrade script for 4.0.7-5+deb7u3 - 4.0.12.
 applying upgrade script for 4.0.7-5+deb7u3 - 4.0.12-2.
 applying upgrade script for 4.0.7-5+deb7u3 - 4.0.19.
 applying upgrade script for 4.0.7-5+deb7u3 - 4.2.3.
 applying upgrade script for 4.0.7-5+deb7u3 - 4.2.4.
 applying upgrade script for 4.0.7-5+deb7u3 - 4.2.6.
 applying upgrade