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
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
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
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
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
-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
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
?
--
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
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
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
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
.
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
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
;
--
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
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
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
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
/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
:
- 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
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
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
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
, 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
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
://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
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
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
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
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
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
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
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
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
. 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
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
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
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
side of things.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
?
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
, 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
-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
doesn't run on Windows.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
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
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
?
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
should find them. If not, try a
wildcard.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
CustomFieldSetTo.pm
Description: Perl program
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
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
from CPAN.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
up for it instead.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
guide.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
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
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
(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
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
, any comments on your
experience doing so?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training Services
::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
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
60 matches
Mail list logo