Re: [rt-users] (RT::Authen::ExternalAuth) email exists problem authenticating trough AD

2013-07-23 Thread Maximilien Drouet
Hello,


Anyone with an idea ?
I've tried many times without any success.



Thanks for your help.


On Fri, Jul 5, 2013 at 4:18 PM, Maximilien Drouet mdro...@randco.fr wrote:

 Hi,


 Both AD  RT have a user matching email  Username.

 Regarding RealName, yes I read about it but in my case, real names are
 NEVER the same they use Kevin FALCONE, KEVIN A FALCONE, KEVIN B FALCONE,
 and so on. But yes you're right about what's documented.


 On Fri, Jul 5, 2013 at 4:14 PM, Kevin Falcone 
 falc...@bestpractical.comwrote:

 On Thu, Jul 04, 2013 at 05:00:23PM +0200, Maximilien Drouet wrote:
 As you can see in the log output I successfully find the user BUT I
 have an error Couldn't
 create user myuser   which I don't understand because YES user
 exists but I just want to
 authenticate not recreate a user.

 Does the user exist with a matching Email Address AND username? Or is
 the username different.

 Also, as documented, you probably shouldn't be using RealName here:

 50  'attr_match_list' = [
 51  'Name',
 52  'EmailAddress',
 53  'RealName',
 54 ],

 It means you can't have two users named Kevin Falcone in your RT.

 -kevin




 --
 Max




-- 
Cordialement,

Maximilien DROUET
Consultant Systèmes  Réseaux
RANDCO, Cabinet de conseil en Réseau, Sécurité  Systèmes
19 Rue Pierre LESCOT
75001 Paris
Mob. 06.30.91.70.09
Fax. 01.72.74.44.01
http://www.randco.fr


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

2013-07-23 Thread Craig Ringer
Hi all

I was recently surprised to see that when a ticket is updated via the
web ui, notifications appear to be sent to ticket/queue watchers before
any custom field changes are applied. Tested in 4.0.13, albeit with a DB
that was created originally on 4.0.7.

After reading the code in question, it looks like the message is
recorded against the ticket before any other field changes, and all the
default notification scripts run on TransactionCreate not on
TransactionBatch, so they fire their notifications immediately.

Do any of the other RT users here know of a reason *not* to use
TransactionBatch for sending email notifications?

Have any of the other RT users here had similar issues?


The behaviour surprising for a couple of reasons:

* RT obviously can't rollback sending notifications, so it makes sense
to do it after all the things that can be rolled back are done.

* Notifications can't see CF and status changes made via the web UI
when they fire.

eg, in a recent ticket:

Fri, 19 Jul 2013 23:02:00 +0800 The RT System itself - Outgoing email
recorded [Show]
Fri, 19 Jul 2013 23:02:00 +0800 The RT System itself - Outgoing email
recorded [Show]
Fri, 19 Jul 2013 23:02:00 +0800 Some User - Status changed from 'new' to
'open'
Fri, 19 Jul 2013 23:02:00 +0800 Some User - WaitingOn Customer added

where WaitingOn is a CF with values Customer or Support.
Transaction numbers increase down the page. 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 changed from 'new' to 'open'
WaitingOn Support changed to Customer

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


Re: [rt-users] (RT::Authen::ExternalAuth) email exists problem authenticating trough AD

2013-07-23 Thread Maximilien Drouet
Hi,


Let me try, i never used ldapsearch before so i need to check the syntax.


On Tue, Jul 23, 2013 at 11:04 AM, Craig Ringer cr...@2ndquadrant.comwrote:

 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   http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training  Services




-- 
Cordialement,

Maximilien DROUET
Consultant Systèmes  Réseaux
RANDCO, Cabinet de conseil en Réseau, Sécurité  Systèmes
19 Rue Pierre LESCOT
75001 Paris
Mob. 06.30.91.70.09
Fax. 01.72.74.44.01
http://www.randco.fr


[rt-users] rt-mailgate issue with postfix

2013-07-23 Thread Rajat toshniwal

Hi Folks

We have just installed RT4.0.13 in our environment. Our foremost 
requirement is ticket creation via email. In our setup we already have 
postfix running on separate server.
On RT we are having exim which is acting as relay server and using 
postfix mail server as master.

Now I want to integrate my RT server with that mailbox.
In order to do that I installed rt-mailgate on my mail server and 
created below mentioned entries in /etc/aliases


*rt-database: |/opt/rt4/bin/rt-mailgate --queue database 
--action correspond --url http://rt.xyz.com/;
rt-database-comment: |/opt/rt4/bin/rt-mailgate --queue database 
--action comment --url http://rt.xyz.com/;

*
I have database queue configured on my RT box with the above mentioned 
email-address. I have also given create-ticket rights to everyone.
Both the email-ids rt-datab...@gml.com and rt-database-comm...@gml.com 
are configured on my AD.


But whenever i am trying to create ticket, I get the below mentioned 
error from mail.log


Jul 23 07:23:17 mail postfix/smtpd[7389]: connect from localhost[127.0.0.1]
Jul 23 07:23:17 mail postfix/smtpd[7389]: DC0DC45C61: 
client=localhost[127.0.0.1]
Jul 23 07:23:17 mail postfix/cleanup[7369]: DC0DC45C61: 
message-id=E1V1ag5-0001y3-Hu@dst-2
Jul 23 07:23:17 mail postfix/qmgr[5870]: DC0DC45C61: 
from=r...@gml.com, size=1448, nrcpt=1 (queue active)
Jul 23 07:23:17 mail postfix/smtpd[7389]: disconnect from 
localhost[127.0.0.1]
Jul 23 07:23:17 mail amavis[5064]: (05064-04) Passed CLEAN, 
[192.168.10.24] r...@gml.com - |/opt/rt4/bin/rt-mailgate --queue 
database --action correspond --url http://rt.tekmindz.com/@gml.com, 
Message-ID: E1V1ag5-0001y3-Hu@dst-2, mail_id: qXkzuLb1TZ4M, Hits: -1, 
size: 854, queued_as: DC0DC45C61, 28311 ms
Jul 23 07:23:17 mail postfix/smtp[7386]: 8553245C65: 
to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url 
http://rt.tekmindz.com/@gml.com, relay=127.0.0.1[127.0.0.1]:10024, 
delay=28, delays=0.11/0.03/0.01/28, dsn=2.0.0, status=sent (250 2.0.0 
Ok, id=05064-04, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as 
DC0DC45C61)

Jul 23 07:23:17 mail postfix/qmgr[5870]: 8553245C65: removed
Jul 23 07:23:18 mail postfix/virtual[7390]: DC0DC45C61: 
to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url 
http://rt.tekmindz.com/@gml.com, relay=virtual, delay=0.17, 
delays=0.06/0.05/0/0.06, dsn=5.1.1, status=bounced (unknown user: 
|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url 
http://rt.tekmindz.com/@gml.com;)
Jul 23 07:23:18 mail postfix/cleanup[7369]: 106A845C64: 
message-id=20130723112318.106a845...@mail.gml.com
Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: from=, size=3673, 
nrcpt=1 (queue active)
Jul 23 07:23:18 mail postfix/bounce[7391]: DC0DC45C61: sender 
non-delivery notification: 106A845C64

Jul 23 07:23:18 mail postfix/qmgr[5870]: DC0DC45C61: removed
Jul 23 07:23:18 mail postfix/virtual[7390]: 106A845C64: 
to=r...@gml.com, relay=virtual, delay=0.12, delays=0.06/0.01/0/0.05, 
dsn=2.0.0, status=sent (delivered to maildir)

Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: removed
Jul 23 07:24:29 mail postfix/smtpd[7363]: idle timeout -- exiting

Actually whole rt-mailgate entry is treated like a user. Right now i am 
clueless about what to do.

Kindly help me in troubleshooting this issue.

Regards



--
Disclaimer: The information contained in this communication is confidential, 
private, proprietary, or otherwise privileged and is intended only for the use 
of the addressee. Unauthorized use, disclosure, distribution or copying is 
strictly prohibited and may be unlawful. If you have received this 
communication in error, please delete this message and notify the sender 
immediately - Samin TekMindz India Pvt. Ltd.
--

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

2013-07-23 Thread k...@rice.edu
On Tue, Jul 23, 2013 at 10:14:39AM +0800, Craig Ringer wrote:
 On 07/19/2013 11:42 PM, Alex Decalli wrote:
  
  I have RT 3.8 on mysql 5.1 on ubuntu 11.04. Why do I have many mysql
  processes they are bringing down RAM.
 
 Quite likely you have too many Apache workers with mod_perl, or too many
 fcgi workers if you're using fcgi.
 
 You will need to limit the number of concurrent RT workers - assuming
 that the MySQL workers are even being used by RT, which we don't know
 based on the information you have provided.
 
 Alternately, you can put a *connection pool* in place between RT and the
 database. If you were using PostgreSQL I would 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 top -b -n 1.
 
Hi Alex,

I will second Craig's suggestion about a connection pooler. We use 
fcgi/pgbouncer
with PostgreSQL here and it works well. The only difference is that we use 
session
mode and not transaction mode with pgbouncer. We had cases of ticket updates 
being
interspersed. Maybe it was a local configuration problem but changing to
session mode fixed it.

Regards,
Ken


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

2013-07-23 Thread Kevin Falcone
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 do not show up in the Preview Scrips UI, so
you'll be unable to squelch users either at the Ticket or Transaction
level.

-kevin


pgprDlaM7qIwB.pgp
Description: PGP signature


Re: [rt-users] RSS feed customization

2013-07-23 Thread Kevin Falcone
On Mon, Jul 22, 2013 at 06:14:43PM -0700, S P wrote:
 Is there a way to include the queue name in the RSS feed of a saved
 search (or add it to the title or subject)? The directions at
 http://requesttracker.wikia.com/wiki/RssFeed reference adding
 strings to the dc hash, but the Results.rdf file distributed with
 4.0.8 doesn't contain a dc hash section (and doesn't contain much,
 in contrast to the Results.rdf file in 3.x)

There is no configuration of that code, just local overlays.

As you say, in 4.0 that file is very short:
 /Search/Elements/ResultsRSSView, %ARGS 

That loads and runs the specified mason component (since the same code
is used from 2 different places).  If you're going to be making
changes to RT, it's worth reviewing documentation on how Mason works.

http://www.masonbook.com/

-kevin


pgpjIgwu58NOS.pgp
Description: PGP signature


Re: [rt-users] rt-mailgate issue with postfix

2013-07-23 Thread Tim Wiley

On 07/23/2013 04:53 AM, Rajat toshniwal wrote:

Hi Folks

We have just installed RT4.0.13 in our environment. Our foremost
requirement is ticket creation via email. In our setup we already have
postfix running on separate server.
On RT we are having exim which is acting as relay server and using
postfix mail server as master.
Now I want to integrate my RT server with that mailbox.
In order to do that I installed rt-mailgate on my mail server and
created below mentioned entries in /etc/aliases

*rt-database: |/opt/rt4/bin/rt-mailgate --queue database
--action correspond --url http://rt.xyz.com/;
rt-database-comment: |/opt/rt4/bin/rt-mailgate --queue database
--action comment --url http://rt.xyz.com/;
*
I have database queue configured on my RT box with the above mentioned
email-address. I have also given create-ticket rights to everyone.
Both the email-ids rt-datab...@gml.com and rt-database-comm...@gml.com
are configured on my AD.

But whenever i am trying to create ticket, I get the below mentioned
error from mail.log

Jul 23 07:23:17 mail postfix/smtpd[7389]: connect from localhost[127.0.0.1]
Jul 23 07:23:17 mail postfix/smtpd[7389]: DC0DC45C61:
client=localhost[127.0.0.1]
Jul 23 07:23:17 mail postfix/cleanup[7369]: DC0DC45C61:
message-id=E1V1ag5-0001y3-Hu@dst-2
Jul 23 07:23:17 mail postfix/qmgr[5870]: DC0DC45C61:
from=r...@gml.com, size=1448, nrcpt=1 (queue active)
Jul 23 07:23:17 mail postfix/smtpd[7389]: disconnect from
localhost[127.0.0.1]
Jul 23 07:23:17 mail amavis[5064]: (05064-04) Passed CLEAN,
[192.168.10.24] r...@gml.com - |/opt/rt4/bin/rt-mailgate --queue
database --action correspond --url http://rt.tekmindz.com/@gml.com,
Message-ID: E1V1ag5-0001y3-Hu@dst-2, mail_id: qXkzuLb1TZ4M, Hits: -1,
size: 854, queued_as: DC0DC45C61, 28311 ms
Jul 23 07:23:17 mail postfix/smtp[7386]: 8553245C65:
to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url
http://rt.tekmindz.com/@gml.com, relay=127.0.0.1[127.0.0.1]:10024,
delay=28, delays=0.11/0.03/0.01/28, dsn=2.0.0, status=sent (250 2.0.0
Ok, id=05064-04, from MTA([127.0.0.1]:10025): 250 2.0.0 Ok: queued as
DC0DC45C61)
Jul 23 07:23:17 mail postfix/qmgr[5870]: 8553245C65: removed
Jul 23 07:23:18 mail postfix/virtual[7390]: DC0DC45C61:
to=|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url
http://rt.tekmindz.com/@gml.com, relay=virtual, delay=0.17,
delays=0.06/0.05/0/0.06, dsn=5.1.1, status=bounced (unknown user:
|/opt/rt4/bin/rt-mailgate --queue database --action correspond --url
http://rt.tekmindz.com/@gml.com;)
Jul 23 07:23:18 mail postfix/cleanup[7369]: 106A845C64:
message-id=20130723112318.106a845...@mail.gml.com
Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: from=, size=3673,
nrcpt=1 (queue active)
Jul 23 07:23:18 mail postfix/bounce[7391]: DC0DC45C61: sender
non-delivery notification: 106A845C64
Jul 23 07:23:18 mail postfix/qmgr[5870]: DC0DC45C61: removed
Jul 23 07:23:18 mail postfix/virtual[7390]: 106A845C64:
to=r...@gml.com, relay=virtual, delay=0.12, delays=0.06/0.01/0/0.05,
dsn=2.0.0, status=sent (delivered to maildir)
Jul 23 07:23:18 mail postfix/qmgr[5870]: 106A845C64: removed
Jul 23 07:24:29 mail postfix/smtpd[7363]: idle timeout -- exiting

Actually whole rt-mailgate entry is treated like a user. Right now i am
clueless about what to do.
Kindly help me in troubleshooting this issue.

Regards


You didn't post your exim.conf, so I'm pretty much stabbing in the dark, 
but my guess is a lack of address_pipe transport configuration.


That said, if your postfix machine is only used for routing to/from the 
RT machine, you may want to consider eliminating that machine  running 
postfix on your RT box.  And even if your postfix box is used for other 
things, you may want to consider using postfix on your RT box as well to 
eliminate the confusion of running 2 different MTAs.


[rt-users] Looking at upgrading 3.6.5 to latest

2013-07-23 Thread Beachey, Kendric
Hi everyone,

I'm investigating what will be necessary to do an upgrade from our installation 
of RT 3.6.5 to the latest version.

Currently installed versions of some items we are not looking to upgrade...are 
we safe here?

* mysql 5.0.51a
* perl 5.8.8
* Ubuntu 8.04 (yes, I know that's way old)
* haven't been using CPAN, but instead pulling in needed modules from Ubuntu 
repo

That last bit was at the sysadmin's request.  What's the general opinion on 
whether that's a good way to go?

Our RT is not exposed to the general internet; only our internal network, so 
I'm hoping the age of the Ubuntu distro isn't too much of a problem.  But I can 
talk to the sysamin about upgrading it first if it seems like a really bad idea 
to stick with 8.04.

Finally...I'm looking at the README files on the BP site and I have a question 
about the UPGRADING.mysql file.  The first step seems to apply only if you're 
not upgrading mysql itself.  Are there other steps in that document that are 
also not necessary if mysql isn't being upgraded?  It's kind of hard to tell.

Thanks!
--
Kendric Beachey




CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of 
the intended recipient(s) and contain information that may be confidential 
and/or legally privileged. If you have received this email in error, please 
notify the sender by reply email and delete the message. Any disclosure, 
copying, distribution or use of this communication (including attachments) by 
someone other than the intended recipient is prohibited. Thank you.



Re: [rt-users] Looking at upgrading 3.6.5 to latest

2013-07-23 Thread Kevin Falcone
On Tue, Jul 23, 2013 at 03:35:20PM +, Beachey, Kendric wrote:
 I'm investigating what will be necessary to do an upgrade from our 
 installation of RT 3.6.5 to the latest version.
 
 Currently installed versions of some items we are not looking to 
 upgrade...are we safe here?
 
 * mysql 5.0.51a
 * perl 5.8.8
 * Ubuntu 8.04 (yes, I know that's way old)
 * haven't been using CPAN, but instead pulling in needed modules from Ubuntu 
 repo
 
 That last bit was at the sysadmin's request.  What's the general opinion on 
 whether that's a good way to go?

You can build your own standalone perl without touching the system
perl using something like perlbrew http://perlbrew.pl

If you're planning to upgrade in-place, keep in mind that the
UPGRADING.mysql step (more below) generally takes a while.  We almost
always recommend working on a new machine or VM for a larger upgrade.
It allows you to test the upgrade and find out how much downtime
you're going to need.

 Finally...I'm looking at the README files on the BP site and I have a
 question about the UPGRADING.mysql file. The first step seems to apply
 only if you're not upgrading mysql itself. Are there other steps in
 that document that are also not necessary if mysql isn't being
 upgraded? It's kind of hard to tell.

If you're planning to upgrade in-place on that mysql, then you do not need
to dump and restore, but I'd make *really* sure that my backups were
sound before doing so.

-kevin


pgpJUipBAuWYf.pgp
Description: PGP signature


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

2013-07-23 Thread scott.dalzell
Hi Guy

i am running RT4.0.12 using a mysql 5.6.10 under cygwin 2.774 and i am
having a major issue

When i try and and reply to a ticket or create a ticket via email i get the
following in the error.log

---log file---

[Tue Jul 23 16:51:49 2013] [error] (11)Resource temporarily unavailable:
fork: Unable to fork new process
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:50 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:51 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 15:51:51 2013] [warning]: Use of uninitialized value $_[2] in
join or string at (eval 378) line 2. ((eval 378):2)
[Tue Jul 23 16:51:51 2013] [warn] FastCGI: (dynamic) server
/opt/rt4/sbin/rt-server.fcgi started (pid 408)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-665.16552-2...@lfm-software.com #16552/15723 -
Scrip 28 Notify Admin user - Reply
(/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-665.16552-2...@lfm-software.com No recipients
found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-1969.16552-5...@lfm-software.com #16552/15723 -
Scrip 52 Notify user - Reply
(/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-1969.16552-5...@lfm-software.com No recipients
found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-1733.16552-...@lfm-software.com #16552/15723 -
Scrip 5 On Correspond Notify AdminCcs
(/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-1733.16552-...@lfm-software.com No recipients
found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-1239.16552-...@lfm-software.com #16552/15723 -
Scrip 7 On Correspond Notify Other Recipients
(/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-1239.16552-...@lfm-software.com No recipients
found. Not sending. (/opt/rt4/sbin/../lib/RT/Interface/Email.pm:385)
[Tue Jul 23 15:52:05 2013] [info]:
rt-4.0.12-408-1374594725-1758.16552-...@lfm-software.com #16552/15723 -
Scrip 6 On Correspond Notify Requestors and Ccs
(/opt/rt4/sbin/../lib/RT/Action/SendEmail.pm:285)
  2 [main] perl 1952 child_info_fork::abort: address space needed by
'cygcrypto-1.0.0.dll' (0x41) is already occupied
[Tue Jul 23 15:52:05 2013] [critical]:
rt-4.0.12-408-1374594725-1758.16552-...@lfm-software.com: Could not send
mail with command `/opt/rt4/etc/msmtp_wrapper -oi -t -ODeliveryMode=b
-OErrorMode=m -f lfm.t...@aveva.com`: open2: fork failed: Resource
temporarily unavailable at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line
474.

Stack:
  [/usr/lib/perl5/site_perl/5.14/Carp.pm:100]
  [/usr/lib/perl5/5.14/IPC/Open3.pm:154]
  [/usr/lib/perl5/5.14/IPC/Open3.pm:242]
  

[rt-users] Sending a templated correspondence to a corresponded for tickets not updated by the correspondent for X hours

2013-07-23 Thread Landon
Hello,

I thought this would be kinda easy but it's proving to be quite difficult.

My problem is 2 parts:

*1) *
I've tried writing a custom condition for rt-crontool to find tickets that
were:
- last updated by the owner
- not updated in X hours (like 24 hours)

Since rt-crontool doesn't know who __CurrentOwner__ is it makes it hard to
use a query like I would in the RT Interface.  Presumably there might be
some way to see if the last update was a privileged RT user but was done
more than X hours ago.

Queue = 'Investigations'
AND Status = 'open'
AND LastUpdatedBy = '__CurrentUser__'
AND Owner = '__CurrentUser__'
AND LastUpdated  '24 hours ago'

Basically I want to nag customers to update the ticket if they haven't
updated it after 24 hours and then 36 hours.  If they still haven't updated
it after 48 hours I want do something like set the priority to 100 or
something so I can see what tickets are not being updated so their accounts
can be suspended or something in accordance with our policies.

*2) *
I also need help understanding the usage for the SendEmail action.  I read
an rt-users mailinglist post from a while ago about it but there's a mix of
other stuff about RecordComment in there etc which doesn't really apply
here.  I've also been reading
http://bestpractical.com/docs/rt/4.0/RT/Action/SendEmail.html but I'm
unclear on what the Blue bolded sections are - are those methods?  How does
one use this in another Action script?  Examples would be awesome if any
exist.

-- 
Landon Stewart landonstew...@gmail.com


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

2013-07-23 Thread window camera
Hello AllI've tried to add a person in our RT, but it says "email already in use", and doesn't let me create the new user.I query everything I can find, but nothing comes up.Obviously this is a user who doesn't have an account yet, but was included in one of the ticket emails. However, I'm unclear how to run a query for a "non privileged" user. (And the RT Essentials book doesn't reveal how because it's for a much older version).Any ideas how I might resolve this issue?Thank you!Rick


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

2013-07-23 Thread window camera
Thanks. Unfortunately there is nothing like that in the latest RT version. Plus, this is an unprivileged user, so it probably wouldn't show up anyway. Not sure.Strange though that I just can't get beyond this issue...Thanks!On Jul 23, 2013, at 05:16 PM, "Beachey, Kendric" kendric.beac...@garmin.com wrote:Hi Rick,It’s possible things have changed since the version of RT we’re running (3.6.5) but I do searches like this from the web interface, with the magic box checked...image001.pngHTH,Kendric BeacheyFrom: rt-users-boun...@lists.bestpractical.com [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of window camera Sent: Tuesday, July 23, 2013 3:58 PM To: rt-users@lists.bestpractical.com Subject: [rt-users] Error when adding user to RT 4 (email exists)Hello AllI've tried to add a person in our RT, but it says "email already in use", and doesn't let me create the new user.I query everything I can find, but nothing comes up.Obviously this is a user who doesn't have an account yet, but was included in one of the ticket emails. However, I'm unclear how to run a query for a "non privileged" user. (And the RT Essentials book doesn't reveal how because it's for a much older version).Any ideas how I might resolve this issue?Thank you!Rick CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of the intended recipient(s) and contain information that may be confidential and/or legally privileged. If you have received this email in error, please notify the sender by reply email and delete the message. Any disclosure, copying, distribution or use of this communication (including attachments) by someone other than the intended recipient is prohibited. Thank you. 

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

2013-07-23 Thread Beachey, Kendric
Hi Rick,

It's possible things have changed since the version of RT we're running (3.6.5) 
but I do searches like this from the web interface, with the magic box 
checked...

[rt.search.for.disabled.users.png]
HTH,

Kendric Beachey



From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of window camera
Sent: Tuesday, July 23, 2013 3:58 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Error when adding user to RT 4 (email exists)

Hello All

I've tried to add a person in our RT, but it says email already in use, and 
doesn't let me create the new user.I query everything I can find, but nothing 
comes up.

Obviously this is a user who doesn't have an account yet, but was included in 
one of the ticket emails. However, I'm unclear how to run a query for a non 
privileged user. (And the RT Essentials book doesn't reveal how because it's 
for a much older version).

Any ideas how I might resolve this issue?

Thank you!

Rick





CONFIDENTIALITY NOTICE: This email and any attachments are for the sole use of 
the intended recipient(s) and contain information that may be confidential 
and/or legally privileged. If you have received this email in error, please 
notify the sender by reply email and delete the message. Any disclosure, 
copying, distribution or use of this communication (including attachments) by 
someone other than the intended recipient is prohibited. Thank you.
inline: image001.png

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

2013-07-23 Thread Thomas Sibley
On 07/23/2013 02:31 PM, window camera wrote:
 Thanks. Unfortunately there is nothing like that in the latest RT
 version. Plus, this is an unprivileged user, so it probably wouldn't
 show up anyway. Not sure. 

Tools - Configuration - Users

The search form shows up there.

Unprivileged users are shown in user searches, but not when you first
load the page (since there are often thousands of unprivileged users).



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

2013-07-23 Thread Thomas Sibley
On 07/23/2013 09:19 AM, scott.dalzell wrote:
 Hi Guy
 
 i am running RT4.0.12 using a mysql 5.6.10 under cygwin 2.774 and i am
 having a major issue

It's rather brave to use Cygwin for a production RT instance.

 When i try and and reply to a ticket or create a ticket via email i get the
 following in the error.log
 
 ---log file---
 
 [Tue Jul 23 16:51:49 2013] [error] (11)Resource temporarily unavailable:
 fork: Unable to fork new process
[snip]
   2 [main] perl 1952 child_info_fork::abort: address space needed by
 'cygcrypto-1.0.0.dll' (0x41) is already occupied
 [Tue Jul 23 15:52:05 2013] [critical]:
 rt-4.0.12-408-1374594725-1758.16552-...@lfm-software.com: Could not send
 mail with command `/opt/rt4/etc/msmtp_wrapper -oi -t -ODeliveryMode=b
 -OErrorMode=m -f lfm.t...@aveva.com`: open2: fork failed: Resource
 temporarily unavailable at /opt/rt4/sbin/../lib/RT/Interface/Email.pm line
 474.

Your server is running out of memory, likely because the maximum memory
usages of MySQL and Apache aren't properly configured to coexist
peacefully within the limits of your server.  Most people install Apache
and MySQL without tuning them, and then eventually run into problems
like this.

You should read about how to tune Apache and MySQL.  Starting with
mysqltuner.pl is a good start, but nothing will do this automatically
for you.  You'll need to manually make changes.

 this all started to happen when i added in a set of new queues. i have
 removed the queues but the error persists.

The new queues have nothing in particular to do with it.

 i have done some research and rebasing might be the answer. 
 
 if this is the case how to i rebase and will it effect my mysql database?

Whatever research you did was mistaken or misleading.  Rebasing has
nothing to do with MySQL.  It is a concept in git, a source code
management tool, used during development.  You don't need to worry about
rebasing.



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 do not show up in the Preview Scrips UI,
 so you'll be unable to squelch users either at the Ticket or
 Transaction level.

Thanks for the tip. I don't think that matters much for my particular
use, but it's good to have on record here for others who're trying to
find out about the same issue later.

Would you be potentially inclined to accept a patch that recorded the
message *after* the status and other attribute changes - or would that
be too likely to break other things?

- -- 
 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/

iQEcBAEBAgAGBQJR71SSAAoJELBXNkqjr+S2QLMH/0VqQAig1efaAJJilkFh+4RF
HvHcIbpSsWlR2GduZaJvyoCqdtU6Ifc/fV3IbPC3fOfCl/2p0r+spq+NnYJaKJV9
of9ENB/HJB5Gye/ihR1FFDloZleKDm/WtqenVeZaykAMVwwPQwszJrMjj4hjhq80
dO/J6RHGeJVMbxMRyDz9FmdSSbyTQ9m+mHquCZOkHjFbHJUVm2V44Zp0Jlgpu5r7
MfMRpfgZVt7wHi/6AlJqYDci8NGnzbRz+py4LHf5poMp2rstSqCqYfsgq2kqKxO1
sSKddyAt+LjxYShBzzLkhaCG+3bEJkbS0cymm3InAHR3OoXDq9I6pgxEt+3bTIo=
=adr/
-END PGP SIGNATURE-


[rt-users] RT on MAC

2013-07-23 Thread Kenneth Crocker
I have an IMAC with Windows 7 running on Parallels. Is it possible to
install RT into that environment? If so, what are the system requirements
and do you have a good set of installation instructions for this

Thank you.

Kenn