Re: [rt-users] Tikcet MergedInto Operation Problem in RT

2013-04-03 Thread Tim Cutts

On 3 Apr 2013, at 03:41, Yuming Zhu y...@redhat.com wrote:

 Hi, Guys
 
 I got a problem when I query the DB for ticket history data.
 When I do this operations on rt web, the DB Tickets table as followed:
 
 
 1. create two tickets 193729 193730
 id EffectiveId Status
 -- --- -
 193729 193729   new  
 193730 193730   new
 
 2. merge 193729 into 193730. 193729's status becomes resolved
 id EffectiveId Status
 -- --- -
 193729 193730   resolved
 193730 193730   new
 
 so in STEP II, status of merged ticket became resolved
 
 But if this, because ticket can be created with new, open or resolved status, 
 and if there's no any status change before merging,
 the status of merged ticket couldn't be known logically.
 so we can't get the exact history data, although the case should hardly exist.

I'm not sure I understand the problem.  The status of the merged ticket is now 
'new' which what you'd expect.  The status of 193729 isn't really relevant any 
more, is it?

 Could it be considered as a bug or defect for change(remove this feature or 
 add a status change record in transactions table)?

This behaviour is configurable in ticket lifecycles.  The default is that the 
ticket that was merged away from is set to resolved.  You can change that to 
whatever you like, although the documentation does recommend that it's an 
'inactive' status (defined elsewhere in the lifecycle, but resolved or rejected 
by default)

I suspect odd things might happen if you set it to an active status.  You could 
always create a new inactive status 'merged' in the lifecycle, and then set the 
on_merge status to that.  I don't think it makes much difference though, since 
the status of the merged away ticket isn't displayed anywhere in the UI.

Tim

--
 The Wellcome Trust Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.


[rt-users] Link assets to customers

2013-04-03 Thread Coen Boef
Hi list,

We have started a project to implement RT as our primary ticket management 
system (with which we hope to replace TOPdesk http://www.topdesk.com).
There is one issue which I cannot solve by myself and I hope the list can help.

We are an ISP, offering managed services to our customers. Customers can send 
requests via mail and we use our current ticketing system to link an incoming 
email to a customer based on the requestor's email address. So here's the first 
issue for us. I cannot find a way to solve this. My idea is to group these 
requestors together in a group with the customer name, which leads to the next 
issue which is that the managed services (or servers) should be linked to the 
customer as well. As I see it now, there's no way (by default or extension) to 
link these three (ticket, asset and customer) together.

Can somebody please help us out here? I hope I overlooked something on the RT 
wiki and somebody has already solved this in the past, or that somebody can 
give me some pointers as to where to start.

Thanks in advance for your help

Kind regards,

Coen Boef





Re: [rt-users] Extract Attachment as Mime

2013-04-03 Thread Anthony Brodard
Hi Kevin,

Thanks for this reply.
Effectively, with this mistake, the scrip will not be right... I did lot of
test, maybe the fatigue...
SO, I will follow your advises and get the list informed.

Regards,
Anthony

2013/4/2 Kevin Falcone falc...@bestpractical.com

 On Tue, Apr 02, 2013 at 03:19:36PM +0200, Anthony Brodard wrote:

 At the very least, you'll note that these two variables aren't the
 same ($content vs $Content).  However, it's more complicated than that
 since you have the declaration buried so deep in scope that the later
 code can't even see it.

 At the very least, you'll need to forward declared $Content early, set
 it, and then check it before Creating.

   my $content = $attachment-ContentAsMIME;
   MIMEObj = $Content,

 I've not ready any of the other code closely, the syntax error just
 jumped out.

 -kevin



Re: [rt-users] Tikcet MergedInto Operation Problem in RT

2013-04-03 Thread Yuming Zhu
Hi, Tim
Sorry for this unclear description.

I mean that the Status of merged ticket #193029 between Creation and Merging 
Operation can not be sure, if I want to get the history by DB queries.
Because of the resolving action with MergedInto Operation hasn't been 
record in Transactions Table, such as
id objectIdtypefield  oldValue newValueCreated
n 193729 StatusStatus   new   resolved XXX
n+1   193729 AddLinkMergedInto  null   ***/193730  XXX

Now through OldValue new of transaction n, I can get that status before 
merged. I think it's the only way in my case.

It's also what I exactly expect, so that every change of ticket can be found in 
Transactions Table.

Cheers, Yuming.



- Original Message -
From: Tim Cutts t...@sanger.ac.uk
To: Yuming Zhu y...@redhat.com
Cc: rt-users@lists.bestpractical.com
Sent: Wednesday, April 3, 2013 4:12:50 PM
Subject: Re: [rt-users] Tikcet MergedInto Operation Problem in RT


On 3 Apr 2013, at 03:41, Yuming Zhu y...@redhat.com wrote:

 Hi, Guys
 
 I got a problem when I query the DB for ticket history data.
 When I do this operations on rt web, the DB Tickets table as followed:
 
 
 1. create two tickets 193729 193730
 id EffectiveId Status
 -- --- -
 193729 193729   new  
 193730 193730   new
 
 2. merge 193729 into 193730. 193729's status becomes resolved
 id EffectiveId Status
 -- --- -
 193729 193730   resolved
 193730 193730   new
 
 so in STEP II, status of merged ticket became resolved
 
 But if this, because ticket can be created with new, open or resolved status, 
 and if there's no any status change before merging,
 the status of merged ticket couldn't be known logically.
 so we can't get the exact history data, although the case should hardly exist.

I'm not sure I understand the problem.  The status of the merged ticket is now 
'new' which what you'd expect.  The status of 193729 isn't really relevant any 
more, is it?

 Could it be considered as a bug or defect for change(remove this feature or 
 add a status change record in transactions table)?

This behaviour is configurable in ticket lifecycles.  The default is that the 
ticket that was merged away from is set to resolved.  You can change that to 
whatever you like, although the documentation does recommend that it's an 
'inactive' status (defined elsewhere in the lifecycle, but resolved or rejected 
by default)

I suspect odd things might happen if you set it to an active status.  You could 
always create a new inactive status 'merged' in the lifecycle, and then set the 
on_merge status to that.  I don't think it makes much difference though, since 
the status of the merged away ticket isn't displayed anywhere in the UI.

Tim

--
 The Wellcome Trust Sanger Institute is operated by Genome Research
 Limited, a charity registered in England with number 1021457 and a
 company registered in England with number 2742969, whose registered
 office is 215 Euston Road, London, NW1 2BE.


Re: [rt-users] Can't fill in content in RT 4.0.10 when create/reply ticket

2013-04-03 Thread Kevin Falcone
On Wed, Mar 27, 2013 at 08:39:04PM +0400, Ruslan Zakirov wrote:
 IE10 was brought up recently in very similar context. I think you have
 to disable compatibility mode in IE for rich text editor to work. I
 think RT 4.0.11rc1 does it for you (tells IE to avoid compat mode).

IE10 turned out to have different breakages for the rich text editor.
If you're using IE10 and seeing these problems, it'd be great to get
more testing reports for 4.0.11rc2 before we turn it into a real
4.0.11.  Announcement and download links here:

http://lists.bestpractical.com/pipermail/rt-devel/2013-April/011849.html

-kevin


pgpi1D0Fxsafu.pgp
Description: PGP signature


Re: [rt-users] Move web port

2013-04-03 Thread John Buell
As it happens I never got the Redirect command to work properly, but a single 
web page delivered by apache2 on 8080 that redirects to 80 wound up doing the 
same trick. I got in a hurry last night and nearly forgot about the listen 
directive, which in my config goes in ports.conf. D’oh. ☺

But thanks again Aaron!

I’m about to set up our building manager with his own queue for non-IT 
workorders, so we’re going to get a lot of use out of RT!

From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of John Buell
Sent: Tuesday, April 02, 2013 5:38 PM
To: Aaron Guise
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Move web port

Sweet! Thanks!

John Buell
Systems Administrator
Country Samper LLC
(630) 762-7806

From: 
rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com
 [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Aaron Guise
Sent: Tuesday, April 02, 2013 5:34 PM
To: rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.com
Subject: Re: [rt-users] Move web port


Yes,

You need to add another LISTEN Directive to httpd.conf.  At the moment it will 
be a single LISTEN 80.  You'd need to add 8080 and then configure a virtualhost 
similar to this.

Mind it may need a bit of tweaking as only bashed that out from memory.

VirtualHost *:8080

  ServerName www.example.com:8080http://www.example.com:8080

  Redirect 301 / http://www.example.com/

/VirtualHost
---

Regards,

Aaron Guise

[Image removed by sender.]aa...@guise.net.nzmailto:aa...@guise.net.nz

[Image removed by sender.]  [Image removed by sender.]   [Image removed by 
sender.]   [Image removed by sender.]

On 2013-04-03 11:26, John Buell wrote:
Right, except that I’ve already “released it to the public” with 8080, so I was 
just trying to find a quick way to do a redirect. A second VirtualHost 
listening on 8080 and serving a single web page with a redirect to 80 would 
seem to me to be the way to do it, or is there another way?

John Buell
Systems Administrator
Country Samper LLC
(630) 762-7806

From: Aaron Guise [mailto:aa...@guise.net.nz]
Sent: Tuesday, April 02, 2013 5:11 PM
To: John Buell
Subject: Re: [rt-users] Move web port


Hi John,

The general idea is that you would configure a virtualhost on apache as per the 
guides.  This would then be listening on port 80 by default.  You would then 
shutdown the built in/standalone server you are currently running on port 8080. 
 This would then mean you can access your RT on port 80 via Apache once your 
vhost is setup correctly.
---

Regards,

Aaron Guise

[Image removed by sender.]aa...@guise.net.nzmailto:aa...@guise.net.nz

[Image removed by sender.]  [Image removed by sender.]   [Image removed by 
sender.]   [Image removed by sender.]

On 2013-04-03 11:06, John Buell wrote:

I am using the Plack server, but if I'm reading everything correctly, I should 
be disabling *THAT* and modify the Apache config files to be doing the web 
service at port 80? Then I could use a VirtualHost directive in an Apache 
config file on 8080 that redirects to 80, right?



John Buell

Systems Administrator

Country Samper LLC

(630) 762-7806





-Original Message-

From: 
rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com
 
[mailto:rt-users-boun...@lists.bestpractical.commailto:rt-users-boun...@lists.bestpractical.com]
 On Behalf Of Kevin Falcone

Sent: Tuesday, April 02, 2013 2:58 PM

To: 
rt-users@lists.bestpractical.commailto:rt-users@lists.bestpractical.comSubject:
 Re: [rt-users] Move web port



On Tue, Apr 02, 2013 at 06:33:30PM +, John Buell wrote:
I've been using a stock Ubuntu 12.04 system for hosting rt. I'm at a point 
where I think I'd like to get rid of apache/apache2 and whatever else might be 
running, and let rt run on port 80 (until now it's been on port 8080). Is there 
a way to allow rt to listen on both, or redirect traffic from 8080 to 80 after 
I shut down and disable apache?

How are you running RT?  Normally, RT runs in conjunction with apache.

You certainly can run it standalone for small installs using just a plack 
server.  I suggest having a look at the deployment docs and figuring out your 
current configuration.



http://bestpractical.com/rt/docs/latest/web_deployment.html



-kevin
inline: image001.jpginline: image003.jpginline: image004.jpg

Re: [rt-users] SLA calculation issue Resolve Due date

2013-04-03 Thread Asanka Gunasekera
Can any one tell me what I am doing wrong to have Due date on the dash to back 
date to 3 months when doing below

Thanks and Regards



 From: Asanka Gunasekera asanka_gunasek...@yahoo.co.uk
To: RT User List rt-users@lists.bestpractical.com 
Sent: Monday, 1 April 2013, 16:52
Subject: [rt-users] SLA calculation issue Resolve Due date
 

Hi I have SLA configured as below but when I apply S4 and reply due date is 
getting calculated correctly but the Resolve due date is been calculated in 
reverse that is backdated 3 months. What is that I am doing wrong 


'S4' = {
                                StartImmediately = 0,
                                BusinessHours = 'Support',
                                Response = { RealMinutes = 60*24*28 }, # four 
real weeks
                                Resolve  = { RealMinutes = 60*24*28*3 }, # 
three real mounths


Thanks and Regards

[rt-users] Articles with links?

2013-04-03 Thread Josh Tackitt
I'm just starting to really dive into Articles and have noticed that it
doesn't like for me to include links/html.

I created a new Article and included a basic a href.  Displaying the
article shows this as a functional link.  But when I add it to a ticket it
just shows up as a URL, not a clickable link.

What am I missing?

thanks,
Josh


[rt-users] RT MariaDB support

2013-04-03 Thread Cena, Stephen (ext. 300)
I'm currently running RT 4.0.10 and couldn't be happier. However, it's
database is currently housed on a shared, underpowered Windows XP system
 I'll looking to rework it. I'm not pleased with how MySQL has
progressed (I'm running 5.1 right now  would be moving to 5.5) and have
begun looking at MariaDB. Has anyone tried using MariaDB with RT? Is it
supported? Issues? Is there an alternate database I should be using?


Re: [rt-users] SLA calculation issue Resolve Due date

2013-04-03 Thread Thomas Sibley
On 04/03/2013 11:07 AM, Asanka Gunasekera wrote:
 Can any one tell me what I am doing wrong to have Due date on the dash
 to back date to 3 months when doing below

Yes, I told you earlier this week:
http://www.gossamer-threads.com/lists/rt/users/115569#115569

Please read replies to the list when you post to the list, and
especially before you bump your thread.


Re: [rt-users] RT MariaDB support

2013-04-03 Thread Gary Greene
I don't see why it wouldn't work, as MariaDB is supposed to be a drop-in 
replacement for MySQL. You might not be able to use one of the newer storage 
engines, but it should just work, no different than with MySQL.

--
Gary L. Greene, Jr.
Sr. Systems Administrator
IT Operations
Minerva Networks, Inc.
Cell: (650) 704-6633


From: rt-users-boun...@lists.bestpractical.com 
[rt-users-boun...@lists.bestpractical.com] on behalf of Cena, Stephen (ext. 
300) [s...@qvii.com]
Sent: Wednesday, April 03, 2013 11:22 AM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] RT  MariaDB support

I'm currently running RT 4.0.10 and couldn't be happier. However, it's database 
is currently housed on a shared, underpowered Windows XP system  I'll looking 
to rework it. I'm not pleased with how MySQL has progressed (I'm running 5.1 
right now  would be moving to 5.5) and have begun looking at MariaDB. Has 
anyone tried using MariaDB with RT? Is it supported? Issues? Is there an 
alternate database I should be using?


Re: [rt-users] Articles with links?

2013-04-03 Thread Valenzuela Lembach, Carlos Felipe (LAN Cargo)
Josh,

 

I'm new in RT, and I'm trying to customize Articles too but with no
success.  Can you (or someone) send me an example on how can I include
some html in the article?  Everything I've tried ended as plain text.. 

 

Thanks in advance!

 

Best regards,

Carlos

 

From: rt-users-boun...@lists.bestpractical.com
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Josh
Tackitt
Sent: Wednesday, April 03, 2013 2:18 PM
To: RT-Users@lists.bestpractical.com
Subject: [rt-users] Articles with links?

 

I'm just starting to really dive into Articles and have noticed that it
doesn't like for me to include links/html.

 

I created a new Article and included a basic a href.  Displaying the
article shows this as a functional link.  But when I add it to a ticket
it just shows up as a URL, not a clickable link.

 

What am I missing?

 

thanks,

Josh