ing 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
rer headers, etc.
I think I'm going to have to refactor RT::Action::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
ion
machine(s). Anybody else done this? If so, any comments on your
experience doing so?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
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
afte
t; rejected => [qw(new open stalled resolved deleted)],
> deleted => [qw(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 sta
. Willing to consider a patch that does so and tries 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
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
>> /
o make sure you have appropriate
> Perl modules, and generally follow the install guide.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
ou're
describing it might be better to set a custom field up for it instead.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
u'll tend to get lots of copies of the SelfService URL in your ticket
logs.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
n one; grab RT::Extension::SMSNotify from CPAN.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
iases to
remote-deliver over http directly to the new server and set the Apache
security rules to allow 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, Trai
>> > I will try manually setting a regexp and see 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 th
b service call - usually done
with LWP::Simple.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
CustomFieldSetTo.pm
Description: Perl program
y ideas how I might resolve this issue?
Searching for the user by email address should find them. If not, try a
wildcard.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
manually?
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
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 scrip
Cygwin, it's
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 packag
far as I know the RT server its self doesn't run on Windows.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
-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?
>
On 07/04/2013 11:00 PM, Maximilien Drouet wrote:
> (&(&(ObjectCategory=User)(ObjectClass=Person))(sAMAccountName=myuser ))
If you execute this LDAP search directly against your directory with the
same base dn as given in the logs, does it find the user?
--
Craig Ringer
The CF is set using the
extension RT::Extension::CustomFieldsOnUpdate, 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 chang
ved search?
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
t you follow up on http://dba.stackexchange.com/ if you're
stuck with the MySQL side of things.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
he email isn't
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
s before, but it's
worthwhile so you can easily manage your modules in git or whatever your
preferred SCM is. It's saved me a lot of hassle, especially since I
maintain a test RT 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
d advise you to use
PgBouncer 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 &quo
.
For example, if you invoke RT::Action::SendEmail, it'll use the
transaction in GetFriendlyName to get the creator of the current
transaction and from it, the friendlyname. 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
rade as a given user for automation purposes that
won't work so well, though.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
n.org/~rudy/DBD-Pg/Pg.pm
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
was suddenly empty 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
.id =
gm.groupid) INNER JOIN users u ON (u.id = gm.memberid) where g.type =
'Privileged' and g.domain = 'SystemInternal';
You can not use this approach to find group memberships to
non-SystemInternal groups because non-SystemInternal groups can have
other groups as members.
On 06/21/2013 11:56 PM, Ruslan Zakirov wrote:
>
>
>
> On Fri, Jun 21, 2013 at 5:36 PM, Craig Ringer <mailto:cr...@2ndquadrant.com>> wrote:
>
> On 06/21/2013 08:21 PM, Ruslan Zakirov wrote:
> > Hi,
> >
> > Some of what you men
upgrade files
> so they can not be applied twice 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
y
already serves the required purpose.
Thoughts/opinions?
Would the RT team consider accepting a patch implementing the above as a
change to RTxInitDB ?
If so, how would you deal with the addition of the new column to each of
the tables? Do it as part of the upgrade script for the next
make assumptions about the calling context. Whether you can use a
plugin would 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
support shifts for SMS notification is included in the update. See:
http://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
ive you hooks after ticket creation.
If I was to write 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
versions is with a second install in a VM.
Since that handily prevents all sorts of other nasty problems with
combining test and live systems that's the approach I favour anyway.
- --
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Tra
ce in complexity, 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 Th
Web.pm to insert the desired header into the generated
message (in the case of Web.pm) or parsed email (in the case of
Email.pm). You could probably make a convincing case for such a patch to
be accepted into RT proper, at least for adding a header to Web.pm
generated messages; probably harder to
On 03/21/2013 07:41 PM, Ruslan Zakirov wrote:
> On Thu, Mar 21, 2013 at 11:05 AM, Craig Ringer wrote:
>> 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
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
>>
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
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
Email::Address.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
for things like
RT::Ticket->Create where it's one giant monolithic method).
In the mean time I'm living with a few limitations in the code posted above:
- Users can only be a member of one customer group if they submit
tickets via email; and
- Tickets created via the web ui are crea
in string eq at
> /usr/local/lib/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
additional
method 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/trai
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
> whe
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 CPA
paste WhoBelongToGroups method here
1;
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
>From 6dc19ce480ed5449e4867e07c44562e30e661e8f Mon Sep 17 00:00:00 2001
From: Craig Ringer
Date: Thu, 7 Mar 2013 12
ailing list).
> Keep in mind that nabble is far from the only public 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
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 & Serv
#x27;t see any way to do it without patching 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 tr
P-encrypted version.
Thanks 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-
$msgstring = $MIMEObj->bodyhandle->as_string;
eval {
$RT::Logger->debug("Notifying $ph about ticket
SLA");
$sender->send_sms(
text => $msgstring,
to => $ph
quot; --action
RT::Action::RecordComment --template 'SLA Overdue'
I'm also doing SLA alerting via SMS, but haven't packaged that into a
module yet.
It strikes me that it'd be really nice if rt-crontool could be driven
from a database table, so extensions could automa
there an RT Essentials update coming for RT4?
--
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
it. Then for each of my queues I 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
-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
dashboard entry showing
tickets in SLA priority order with severity highlighting, a summary
report of time left before resolution of all tickets across a time
period, etc. I haven't done those yet so I can't help there, but will
try to follow up when I have.
Next problem: H
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
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
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 CHE
k at how hard it'd
be to patch RT to support differentiating between client and server
time. I'm really hoping there's a good answer to this that I'm just
totally missing, though.
Ideas/suggestions?
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Dev
65 matches
Mail list logo