[rt-users] Problem sending email from Reply

2014-05-16 Thread Tamás, Szép
Dear RT users,

We at CERT-Hungary are using a very old version (3.0.12) of RT with the
IR plugin. Recently I installed RT 4.0.18 with IR 3.0.2, using Ubuntu
12.04.4 LTS on a separate server. Copied every configuration items from
the old version to the new what I thought to be important. Made some
improvements and changes as well. Do not plan to migrate data since it
is very problematic due to the huge change between the two versions.

Everything seems to be working fine... except one very important thing:
'Reply' function does not send email to the sender, neither does 'New
investigation' to the correspondent.

The strange thing is that RT receives emails and even sends but only to
CCs, BCCs, One-time CCs and One-time BCCs.

Any help would be appreciated.
Please consider that I am not a Linux guru.

Best regards,

Tamas Szep
GovCERT-Hungary
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training


Re: [rt-users] Problem sending email from Reply

2014-05-16 Thread Tamás, Szép
It doesn't matter if I reply with the same user or not: it won't send an
email.

NotifyActor is set to 0, but isn't it responsible for notifying the
person who actually performs an update? I mean that the sender (from
outside the world) who sends us an email is not an 'actor' in this
context, is he?

OK, here is a scenario:
1. John Smith sends us an email that his network is being attacked eg.
by spear fishing emails. He sends us the attacker's IP address and other
info.
2. RT gets this and an Incident Report is being generated automatically.
3. Our incident handler colleague Takes the Incident Report and Replies
to John Smith that we acknowledged his problem. (here is the first
problem, email is not being sent)
4. The incident handler creates an Incident from the Report.
5. The incident handler launches a new Investigation. (here is the
second problem, email is not being sent)
6...etc.

Just to mention: CC, BCC is OK, so the mail handler (using Sendmail) is
working right.

Tamas

 Are you replying with the same user that created the ticket? By
default RT won't send a mail to you if you performed the action that
generated an email.

 See:
 http://bestpractical.com/docs/rt/4.2/RT_Config.html#NotifyActor

 Gareth


 On 16 May 2014, at 08:27, Tamás, Szép wrote:

  Everything seems to be working fine... except one very important thing:
  'Reply' function does not send email to the sender, neither does 'New
  investigation' to the correspondent.
 
  The strange thing is that RT receives emails and even sends but only to
  CCs, BCCs, One-time CCs and One-time BCCs.
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training


Re: [rt-users] Problem sending email from Reply

2014-05-16 Thread Kevin Falcone
On Fri, May 16, 2014 at 09:27:22AM +0200, Tamás, Szép wrote:
 We at CERT-Hungary are using a very old version (3.0.12) of RT with the
 IR plugin. Recently I installed RT 4.0.18 with IR 3.0.2, using Ubuntu
 12.04.4 LTS on a separate server. Copied every configuration items from
 the old version to the new what I thought to be important. Made some
 improvements and changes as well. 

What configurations did you copy.  Did you change the Scrips?

 Do not plan to migrate data since it
 is very problematic due to the huge change between the two versions.

Which problems, we've walked a few clients through upgrading from that
vintage of RTIR, keeping their data intact.

 Everything seems to be working fine... except one very important thing:
 'Reply' function does not send email to the sender, neither does 'New
 investigation' to the correspondent.

These are both standard built-in features of RT and RTIR

 The strange thing is that RT receives emails and even sends but only to
 CCs, BCCs, One-time CCs and One-time BCCs.

You claim to not be putting yourself in as the Requestor (thus
avoiding NotifyActor), please show the debug logs when sending mail
that should notify the Requestor.  This is most easily accomplished by 
Set($LogToScreen,'debug'); and then going and reading your Apache
error logs.

-kevin


pgp_aEXyuCp0N.pgp
Description: PGP signature
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training

[rt-users] [rt-announce] Assets 1.01 released

2014-05-16 Thread Alex Vandiver
Assets 1.01 -- 2014-05-16
-

We are pleased to announce the release of Assets 1.01.  This release
makes minor changes to the Assets display, improves localization
support, and adds one new feature: CSV download.

http://download.bestpractical.com/pub/rt/release/RT-Extension-Assets-1.01.tar.gz
http://download.bestpractical.com/pub/rt/release/RT-Extension-Assets-1.01.tar.gz.asc

SHA1 sums

bddd2ba69735817142c11c8c8b41f642f7014a07  RT-Extension-Assets-1.01.tar.gz
b8e2a1ebe64ce17c5cfb3124f7dffc6d1d62bac2  RT-Extension-Assets-1.01.tar.gz.asc

Changes from 1.0:
 * Squelch warnings when Assets configuration options are set in
   RT_SiteConfig.pm
 * Add a CSV export option
 * Better formatting of people on Assets display pages
 * Adjust CSS to no longer cause core RT tables to be overly-wide
 * Localization fixes, and a French translation

A complete changelog is available from git by running:
git log 1.0..1.01
or visiting
https://github.com/bestpractical/rt-extension-assets/compare/1.0...1.01
___
rt-announce mailing list
rt-annou...@lists.bestpractical.com
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-announce
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training


[rt-users] Help Resolving Incorrect Ticket Merging

2014-05-16 Thread Sean Snell
Hello everyone,
First of all, yes, I'm totally aware of the big glaring warning that
clearly states Warning: merging is a non-reversible action! Enter a single
ticket number to be merged into. And yes, I'm about to go overboard on
very explicit security permissions for my guys.

However, I'm now facing a stupid situation all thanks to an intern who
thought he'd problem solve himself, and he accidentally merged a sub-ticket
of an ongoing case that is completely unrelated to what he was trying to
do. Now, I have a simple ticket that was *supposed* to be a purchasing
request, and now he's managed to merge the data in error. How can I sort
this issue out, even if I have to do it by hand? I have SQL experience (my
backend DB), so I'm not afraid from that respect, but since I'm still
fairly newish to RT, so I hesitate at just hunting via SQL queries and
trying to update the info without guidance.

*Side thought: Why are there so many non-reversible actions in RT? Another
example are ticket comments, which now at this point have a ton of awful
typo's, but we're forced to roll with it because there's no way to
correct the typo*.

Thanks for the help, and sorry if I sound a bit heated at the moment.

Sean
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training

[rt-users] Column order in tables after upgrade from 3.6.10 to 4.2.4

2014-05-16 Thread LABANJ2
Distinguished RT-Users,

After running upgrade_database (I am upgrading from 3.6.10 to 4.2.4) I 
have some problems (e.g., [Search Tickets] times out in the browser, but I 
admit that I did not do a whole lot of testing yet). What I found is that 
some columns in the schema.Oracle script in the 4.2.4 distribution, and 
the columns in the tables in the database after conversion from 3.6.10 to 
4.2.4, are in a different order.
For example, in the schema.Oracle for 4.2.4:
CREATE TABLE Queues (
id  NUMBER(11,0)
CONSTRAINT Queues_Key PRIMARY KEY,
NameVARCHAR2(200) CONSTRAINT 
Queues_Name_Unique UNIQUE NOT NULL,
Description VARCHAR2(255),
CorrespondAddress   VARCHAR2(120),
CommentAddress  VARCHAR2(120),
Lifecycle   VARCHAR2(32),
SubjectTag  VARCHAR2(120),
InitialPriority NUMBER(11,0) DEFAULT 0 NOT NULL,
FinalPriority   NUMBER(11,0) DEFAULT 0 NOT NULL,
DefaultDueInNUMBER(11,0) DEFAULT 0 NOT NULL,
Creator NUMBER(11,0) DEFAULT 0 NOT NULL,
Created DATE,
LastUpdatedBy   NUMBER(11,0) DEFAULT 0 NOT NULL,
LastUpdated DATE,
DisabledNUMBER(11,0) DEFAULT 0 NOT NULL
);

In the actual table after conversion to 4.2.4:
Column Name:
ID
NAME
DESCRIPTION
CORRESPONDADDRESS
COMMENTADDRESS
INITIALPRIORITY
FINALPRIORITY
DEFAULTDUEIN
CREATOR
CREATED
LASTUPDATEDBY
LASTUPDATED
DISABLED
SUBJECTTAG
LIFECYCLE
Of course, if data are always retrieved as hashrefs for rows it should 
have no impact, but if they are retrieved occasionally as arrays, it may 
be a problem ...

Should I worry or look elsewhere?
Jan Labanowski
laba...@nationwide.com-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training

Re: [rt-users] Column order in tables after upgrade from 3.6.10 to 4.2.4

2014-05-16 Thread Alex Vandiver
On 05/16/2014 05:02 PM, laba...@nationwide.com wrote:
 Distinguished RT-Users,
 
 After running upgrade_database (I am upgrading from 3.6.10 to 4.2.4) I
 have some problems (e.g., [Search Tickets] times out in the browser, but
 I admit that I did not do a whole lot of testing yet). What I found is
 that some columns in the schema.Oracle script in the 4.2.4 distribution,
 and the columns in the tables in the database after conversion from
 3.6.10 to 4.2.4, are in a different order.

RT doesn't depend on the position of the columns.  There's nothing to
worry about here.
 - Alex
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training


Re: [rt-users] Help Resolving Incorrect Ticket Merging

2014-05-16 Thread Alex Vandiver
On 05/16/2014 05:08 PM, Sean Snell wrote:
 However, I'm now facing a stupid situation all thanks to an intern who
 thought he'd problem solve himself, and he accidentally merged a
 sub-ticket of an ongoing case that is completely unrelated to what he
 was trying to do. Now, I have a simple ticket that was /supposed/ to be
 a purchasing request, and now he's managed to merge the data in error.
 How can I sort this issue out, even if I have to do it by hand? I have
 SQL experience (my backend DB), so I'm not afraid from that respect, but
 since I'm still fairly newish to RT, so I hesitate at just hunting via
 SQL queries and trying to update the info without guidance.

Assuming tickets 17 and 42 were mistakenly merged:

  UPDATE Tickets SET EffectiveId = id,
 IsMerged = NULL
   WHERE id IN (17, 42);

Leave off the IsMerged column if you're still on 4.0.  Note that this
will _not_ undo new requestors/ccs/adminccs added to the merged-into
ticket.  You will need to adjust those by hand in the web UI.

 /Side thought: Why are there so many non-reversible actions in RT?
 Another example are ticket comments, which now at this point have a ton
 of awful typo's, but we're forced to roll with it because there's no
 way to correct the typo/.

Comments went out in email when they were made; you cannot go back and
edit the typos in them.  RT simply records the history as it happened.
 - Alex
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training


[rt-users] Unable to paste into Rich Text Editor since upgrading to RT 4.2.4

2014-05-16 Thread Jan Kurianski
Since upgrading to RT 4.2.4, users are unable to paste into the rich text 
editor.  Only bothered to reproduce this with Google Chrome on a Mac, as the 
error indicates that the problem is browser-wide.

Steps to reproduce:
1. Ensure your configuration has the Rich Text Editor enabled.
2. Reply to any ticket (or compose a new ticket).
3. Click on the text editor to give it focus.
4. Paste, using keyboard shortcut.

What happens:
Nothing.

What is expected:
Text from the clipboard appears in the editor.

Chrome shows the following errors in the console (where https://redacted/rt is 
the root of my RT site):
   GET 
https://redacted/rt/Ticket/plugins/pastefromword/filter/default.js?t=D08E 404 
(Not Found) squished-884af658b44cdd5c585766ea0a0518ba.js:3325
   Uncaught TypeError: undefined is not a function 
squished-884af658b44cdd5c585766ea0a0518ba.js:4040

The dynamic GET originates from this file (when un-squished):

/opt/rt4/share/static/RichText/ckeditor.js

CKEDITOR.getUrl(a.config.pasteFromWordCleanupFile||d+filter/default.js)

A hacky patch that solves the problem for me:

/opt/rt4/share/static/RichText/config.js
47a48,50

 // Since ckeditor is always used from an /rt/Controller, use '../' to get 
 back to the RT root directory.
 config.pasteFromWordCleanupFile = 
 '../static/RichText/plugins/pastefromword/filter/default.js';

Cheers,
Jan
-- 
RT Training - Dallas May 20-21
http://bestpractical.com/training