Re: [rt-users] Fw: slow query on RT 4.2.9 with postgres

2015-01-07 Thread Craig Ringer
lots of sort memory. If you, for testing purposes: SET work_mem = '10MB' EXPLAIN (BUFFERS, ANALYZE) SELECT ... do you get a different result? Is it possible that the index is badly bloated? If you can afford the exclusive lock, try `REINDEX`ing acl1. -- Craig Ringer http

Re: [rt-users] Sending notification / alert mails without creating comments

2013-07-29 Thread Craig Ringer
::SendEmail pretty heavily. With luck the BestPractical team might accept a patch if I can do it without breaking things that wrap it while still making it re-usable. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] Notify via SMS if ticket Subject =~ /urgent/i

2013-07-28 Thread Craig Ringer
from CPAN. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] RT4 and HTML links / email

2013-07-28 Thread Craig Ringer
. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] New action and ticket status

2013-07-28 Thread Craig Ringer
up for it instead. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] RT on MAC

2013-07-28 Thread Craig Ringer
guide. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] Notify via SMS if ticket Subject =~ /urgent/i

2013-07-28 Thread Craig Ringer
On 07/29/2013 09:34 AM, Craig Ringer wrote: On 07/26/2013 01:15 AM, EJ Marmonti wrote: Greetings I'm using RT 4.0.10 and am trying to create a scrip to accomplish this. If the subject contains the word urgent (not case senstive, thus the /urgent/i), I want it to send me an SMS. I've

[rt-users] Sending notification / alert mails without creating comments

2013-07-28 Thread Craig Ringer
to split RT::Action::SendEmail up into smaller, more easily wrapped/overridden methods too? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] New action and ticket status

2013-07-28 Thread Craig Ringer
(new open stalled rejected resolved)], }, There are no statuses in which a transition to 'waiting' is possible. Add 'waiting' to the transition list for suitable source statuses like 'open'. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

Re: [rt-users] RT4 installation on Centos 6.4

2013-07-28 Thread Craig Ringer
On 07/12/2013 11:11 PM, Pedro Albuquerque wrote: Hi, Which redhat packages are needed to run sucessfully make fixdeps? AFAIK all you need is make, Perl and CPAN. What's unsuccesful about it? What error message are you getting, and after what command? -- Craig Ringer http

[rt-users] How do you configuration-manage your RT install?

2013-07-28 Thread Craig Ringer
, any comments on your experience doing so? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] blah.b...@foo.com is an address RT receives mail at

2013-07-25 Thread Craig Ringer
if that improves the situation. That fixes it. Thanks for the push. It'd be interesting if you could get the address regexp that RT generates when one is not specified. Maybe there's an issue there, or maybe it's with one of your queues. -- Craig Ringer http://www.2ndQuadrant.com

Re: [rt-users] Migration Prep

2013-07-25 Thread Craig Ringer
it. With a little effort you can keep the outage window down to less than a minute. - -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG

Re: [rt-users] RT on MAC

2013-07-24 Thread Craig Ringer
doesn't run on Windows. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] Error when sending or reciving mail (fork::abort: address space needed by xxx)

2013-07-24 Thread Craig Ringer
easy to fix the person's problem. Well, your question starts with 'I'm using 9.0.1 on Cygwin' there's your problem. Cygwin used to be important, but these days with easy, high performance VMs and native ports of many open source packages to Windows I no longer see the appeal. -- Craig

Re: [rt-users] Notifications are sent before status and custom field changes are applied?

2013-07-24 Thread Craig Ringer
On 07/25/2013 12:49 AM, Thomas Sibley wrote: On 07/23/2013 12:56 AM, Craig Ringer wrote: Do any of the other RT users here know of a reason *not* to use TransactionBatch for sending email notifications? Be wary of $self-TransactionObj in TransactionBatch scrips; it isn't guaranteed

Re: [rt-users] blah.b...@foo.com is an address RT receives mail at

2013-07-24 Thread Craig Ringer
? Try: cpan install Devel::REPL re.pl 'the@address' =~ qr{^my-rt-address-regexp-here$}; see if you get any match(es). -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] Error when adding user to RT 4 (email exists)

2013-07-24 Thread Craig Ringer
should find them. If not, try a wildcard. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] How to update CF via scripted mySQL commands

2013-07-24 Thread Craig Ringer
. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services CustomFieldSetTo.pm Description: Perl program

[rt-users] Notifications are sent before status and custom field changes are applied?

2013-07-23 Thread Craig Ringer
, but the Status is of course set by the core code. The order of events logged in the Results tab after Update.html runs and redirects to Display.html is: [Results] Message recorded Ticket : Status changed from 'new' to 'open' WaitingOn Support changed to Customer -- Craig Ringer

Re: [rt-users] Notifications are sent before status and custom field changes are applied?

2013-07-23 Thread Craig Ringer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/23/2013 09:00 PM, Kevin Falcone wrote: On Tue, Jul 23, 2013 at 03:56:49PM +0800, Craig Ringer wrote: Do any of the other RT users here know of a reason *not* to use TransactionBatch for sending email notifications? TransactionBatch Scrips

Re: [rt-users] SOS:: many mysql processes are killing RAM, why?

2013-07-22 Thread Craig Ringer
in transaction pooling mode, but I cannot offer much advice for MySQL. I'm sure there's a similar pooling proxy. This sort of question is probably better suited to Serverfault.com than the RT list. BTW, text output is usually way more useful than screenshots; eg top -b -n 1. -- Craig Ringer

Re: [rt-users] Custom script to set custom field value

2013-07-22 Thread Craig Ringer
instance for developing extensions on. I posted some notes on creating RT extensions here recently that I really need to turn into a doc on wikia. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] Help with open ticket with email.

2013-07-22 Thread Craig Ringer
matching. Perhaps you have some address re-writing going on at some stage in your system? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] RT migration to different OS

2013-07-22 Thread Craig Ringer
side of things. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

[rt-users] Emailing dashboards every 'n' minutes

2013-07-22 Thread Craig Ringer
? If not, I'll probably just hack it into our in-house extensions as an unconditional action to be invoked by rt-crontool. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

[rt-users] What do first, last and all mean in --transaction on rt-crontool?

2013-07-16 Thread Craig Ringer
. Same with SetReturnAddress. It might be worth elaborating on this a little more in the documentation and/or book. Feel free to use any of the above. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] API key support for RT REST API

2013-07-15 Thread Craig Ringer
stateless mechanism. ExternalAuth falls back to RT's internal database, so you can add a user/password used only for scripting and remote control purposes to the internal user database. If you want to masquerade as a given user for automation purposes that won't work so well, though. -- Craig

Re: [rt-users] RT session cleanup - session table size

2013-07-09 Thread Craig Ringer
-- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] RT session cleanup - session table size

2013-07-08 Thread Craig Ringer
after a restart? I'm wondering if it should be an UNLOGGED table on PostgreSQL 9.1 and above, so it doesn't incur write-ahead logging overhead. If it doesn't need to be crash-safe and it's OK to just have it truncated after a crash recovery restart, that'd be ideal. Thoughts? -- Craig Ringer

Re: [rt-users] RT Scrip

2013-07-05 Thread Craig Ringer
-- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] Making make initdb idempotent?

2013-06-24 Thread Craig Ringer
On 06/21/2013 11:56 PM, Ruslan Zakirov wrote: On Fri, Jun 21, 2013 at 5:36 PM, Craig Ringer cr...@2ndquadrant.com mailto:cr...@2ndquadrant.com wrote: On 06/21/2013 08:21 PM, Ruslan Zakirov wrote: Hi, Some of what you mention may be partially implemented in a branch

Re: [rt-users] Making make initdb idempotent?

2013-06-21 Thread Craig Ringer
so easy. Hm. That'd work if an extension could provide multiple upgrade files, so each new version could add new upgrade files. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

[rt-users] Making make initdb idempotent?

2013-06-20 Thread Craig Ringer
of the tables? Do it as part of the upgrade script for the next RT release that needs an upgrade script anyway, and if it isn't present, ignore the ExtensionIdentifier field in the initialdata for backward compatibility? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL

Re: [rt-users] Using RT library from outside

2013-04-15 Thread Craig Ringer
depend on how the code expects to be called; you can't just invoke a Mason callback as simple Perl code, for example. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

[rt-users] Creating tickets on behalf of users via email

2013-04-09 Thread Craig Ringer
something like this would it be useful to others? Would the RT team be prepared to accept a patch either for the hooks + a CPAN plugin, or for the whole feature integrated into the RT code? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support

[rt-users] Creating tickets on behalf of users via email

2013-04-09 Thread Craig Ringer
://search.cpan.org/~ringerc/RT-Extension-SMSNotify/ http://search.cpan.org/%7Eringerc/RT-Extension-SMSNotify/ -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services

Re: [rt-users] Debian package status

2013-03-23 Thread Craig Ringer
, but this probably isn't true for RT. - -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.13 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net

Re: [rt-users] Recognize tickets created via email or via web

2013-03-22 Thread Craig Ringer
for such a patch to be accepted into RT proper, at least for adding a header to Web.pm generated messages; probably harder to argue modification of externally originated mail for Email.pm. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training

[rt-users] EmailParser.pm:ParseEmailAddress - mixing usernames and email addresses

2013-03-21 Thread Craig Ringer
: - Users can only be a member of one customer group if they submit tickets via email; and - Tickets created via the web ui are created with the requestor as the individual user then immediately rewritten by a scrip to use the customer group; this rewrite is visible in the logs. -- Craig Ringer

Re: [rt-users] Email::Address-Parse - recovering unmatched entries

2013-03-21 Thread Craig Ringer
On 03/21/2013 03:02 PM, Craig Ringer wrote: Would you consider using http://search.cpan.org/~ruz/Email-Address-List/lib/Email/Address/List.pm http://search.cpan.org/%7Eruz/Email-Address-List/lib/Email/Address/List.pm ? It appears to be designed to solve just this problem and is based

Re: [rt-users] error in rt-crontool

2013-03-21 Thread Craig Ringer
On 03/21/2013 03:41 PM, Albert Shih wrote: Le 21/03/2013 ? 08:54:08+0800, Craig Ringer a ?crit Hi, Since I create a new lifecycle I got this error /usr/local/bin/rt-crontool --search RT::Search::ActiveTicketsInQueue --search-arg Support --action RT::Action::EscalatePriority Use

Re: [rt-users] error in rt-crontool

2013-03-20 Thread Craig Ringer
/perl5/site_perl/5.14.2/RT/Lifecycle.pm line 507. Use of uninitialized value $to[0] in join or string at /usr/local/lib/perl5/site_perl/5.14.2/RT/Lifecycle.pm line 507. Since you're showing line numbers it'd be useful to know the exact RT version you're using. -- Craig Ringer

[rt-users] [PATCH] RT::Users-WhoBelongToGroups applies LimitToPrivileged filter

2013-03-13 Thread Craig Ringer
; -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services From 6dc19ce480ed5449e4867e07c44562e30e661e8f Mon Sep 17 00:00:00 2001 From: Craig Ringer cr...@2ndquadrant.com Date: Thu, 7 Mar 2013 12:54:26 +0800 Subject: [PATCH

Re: [rt-users] Initial version of SMS alerting

2013-03-13 Thread Craig Ringer
On 02/28/2013 01:49 PM, Craig Ringer wrote: Hi all Here's a simple action module to send SMS alerts to the user's PagerPhone. I've found the time to package this as RT::Extension::SMSNotify and document it. It's released under the Perl license on CPAN: http://search.cpan.org/~ringerc/RT

Re: [rt-users] [PATCH] RT::Users-WhoBelongToGroups applies LimitToPrivileged filter

2013-03-13 Thread Craig Ringer
On 03/13/2013 04:40 PM, Craig Ringer wrote: Hi all I've noticed that the WhoBelongToGroups method of user search class RT::Users unconditionally calls LimitToPrivileged, making it useless for when you want to find both privileged and unprivileged users, or when you want to find only

Re: [rt-users] [PATCH] RT::Users-WhoBelongToGroups applies LimitToPrivileged filter

2013-03-13 Thread Craig Ringer
won't affect any other code. Private in effect because of that. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT

Re: [rt-users] Delete Post

2013-03-04 Thread Craig Ringer
mailing list archive of rt-users. Additionally, everyone who received a copy by email still has it unless they delete old list mail. You really can't put the cat back in the bag. - -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training

Re: [rt-users] Redacting details from ticket emails?

2013-02-28 Thread Craig Ringer
for the tip. I hadn't realised the shredder could operate on individual transactions not just whole tickets. - -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.13 (GNU/Linux

[rt-users] SLA: How to tell what response is required?

2013-02-28 Thread Craig Ringer
the SLA module to add private explanatory comments when it changes the due date, which would be a very spammy solution. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- RT training in Amsterdam, March 20-21: http

[rt-users] Allowing SelfService users to set own language and timezone prefs

2013-02-28 Thread Craig Ringer
. Is there a security or other reason not to show things like timezone and language to unprivileged users? I can add an overlay, I just want to avoid breaking anything important. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- RT

[rt-users] Redacting details from ticket emails?

2013-02-27 Thread Craig Ringer
? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our user survey: https://www.surveymonkey.com/s/N23JW9T

[rt-users] Initial version of SMS alerting

2013-02-27 Thread Craig Ringer
to notify $ph about ticket SLA: $@); } } return 1; } 1; -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services

Re: [rt-users] Getting relative time in a template, configuring SLA and SLA alerting [SOLVED]

2013-02-19 Thread Craig Ringer
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/19/2013 10:48 PM, Kevin Falcone wrote: On Tue, Feb 19, 2013 at 12:37:42PM +0800, Craig Ringer wrote: { my $d = RT::Date-new(RT::SystemUser); $d-Set(Format='ISO', Value=$Ticket-Due, Timezone=GMT); our $tdiff = $d-AgeAsString(); You can

Re: [rt-users] Could someone help a newb evaluating RT with email setup?

2013-02-19 Thread Craig Ringer
just entered the top-level domain aliases for the correspond and comment addresses, so RT would use these correctly in outbound mail. Hope this is useful. -- Craig Ringer -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our

[rt-users] Getting relative time in a template, configuring SLA and SLA alerting [SOLVED]

2013-02-18 Thread Craig Ringer
have. Next problem: How to bind multiple accounts (addresses) together into customers who can all see each others' tickets. It's amazing that this doesn't seem to be built-in to RT. Ideas? I'll follow up with solutions, either mine or others'. -- Craig Ringer http://www

[rt-users] Displaying times in local user's timezone (worldwide support)?

2013-02-13 Thread Craig Ringer
just totally missing, though. Ideas/suggestions? -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training Services -- RT training in Amsterdam, March 20-21: http://bestpractical.com/services/training.html Help improve RT by taking our user

Re: [rt-users] Displaying times in local user's timezone (worldwide support)?

2013-02-13 Thread Craig Ringer
On 02/13/2013 08:13 PM, Craig Ringer wrote: Am I missing something? Yes, yes I am. Inevitably, as soon as I posted this message I noticed that there's a timezone field in the user table, though it isn't exposed in the UI and is defined as varchar(50) with no CHECK constraint, so it's

Re: [rt-users] Displaying times in local user's timezone (worldwide support)?

2013-02-13 Thread Craig Ringer
On 02/13/2013 10:17 PM, Christian Loos wrote: Am 13.02.2013 14:19, schrieb Craig Ringer: Yes, yes I am. Inevitably, as soon as I posted this message I noticed that there's a timezone field in the user table, though it isn't exposed in the UI and is defined as varchar(50) with no CHECK

Re: [rt-users] Displaying times in local user's timezone (worldwide support)?

2013-02-13 Thread Craig Ringer
On 02/13/2013 10:38 PM, Craig Ringer wrote: On 02/13/2013 10:17 PM, Christian Loos wrote: Am 13.02.2013 14:19, schrieb Craig Ringer: Yes, yes I am. Inevitably, as soon as I posted this message I noticed that there's a timezone field in the user table, though it isn't exposed in the UI