[rt-users] RT stops occasionally sending mail

2015-09-29 Thread Sternberger, Sven
Hello!

I use RT4.2.11 on Ubuntu14.04

since a week I notice that mail occasionally is not sended by notify  scrips. 
They are also not in the history and in the log I see

Sep 28 13:40:40 rthost RT: [16910] Scrip Prepare 483 died. - Can't locate 
object method "" via package "RT::Action::Notify" at 
/opt/rt4/sbin/../lib/RT/Action/SendEmail_Local.pm line 594.#012#012Stack:#012  
[/opt/rt4/sbin/../lib/RT/Action/SendEmail_Local.pm:594]#012  
[/opt/rt4/sbin/../lib/RT/Action/SendEmail_Local.pm:152]#012  
[/opt/rt4/sbin/../lib/RT/Action/Notify.pm:69]#012  
[/opt/rt4/sbin/../lib/RT/ScripAction.pm:223]#012  
[/opt/rt4/sbin/../lib/RT/Scrip.pm:637]#012  
[/opt/rt4/sbin/../lib/RT/Scrips.pm:342]#012  
[/opt/rt4/sbin/../lib/RT/Transaction.pm:189]#012  
[/opt/rt4/sbin/../lib/RT/Record.pm:1693]#012  
[/opt/rt4/sbin/../lib/RT/Ticket.pm:1613]#012  
[/opt/rt4/sbin/../lib/RT/Ticket.pm:1506]#012  
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:2349]#012  
[/opt/rt4/share/html/Ticket/Display.html:165]#012  
[/opt/rt4/local/html/Ticket/Update.html:304]#012  
[/opt/rt4/share/html/Ticket/autohandler:66]#012  
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:681]#012  
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:369]#012  
[/opt/rt4/share/html/autohandler:53]

or 

Sep 24 15:16:31 rthost RT: [26426] Scrip Prepare 481 died. - Can't locate 
object method "" via package "MIME::Entity" at 
/opt/rt4/sbin/../lib/RT/Action/SendEmail_Local.pm line 180.#012#012Stack:#012  
[/opt/rt4/sbin/../lib/RT/Action/SendEmail_Local.pm:180]#012  
[/opt/rt4/sbin/../lib/RT/Action/Notify.pm:69]#012  
[/opt/rt4/sbin/../lib/RT/ScripAction.pm:223]#012  
[/opt/rt4/sbin/../lib/RT/Scrip.pm:637]#012  
[/opt/rt4/sbin/../lib/RT/Scrips.pm:342]#012  
[/opt/rt4/sbin/../lib/RT/Transaction.pm:189]#012  
[/opt/rt4/sbin/../lib/RT/Record.pm:1693]#012  
[/opt/rt4/sbin/../lib/RT/Ticket.pm:1613]#012  
[/opt/rt4/sbin/../lib/RT/Ticket.pm:1506]#012  
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:2349]#012  
[/opt/rt4/share/html/Ticket/Display.html:165]#012  
[/opt/rt4/local/html/Ticket/Update.html:304]#012  
[/opt/rt4/share/html/Ticket/autohandler:66]#012  
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:681]#012  
[/opt/rt4/sbin/../lib/RT/Interface/Web.pm:369]#012  
[/opt/rt4/share/html/autohandler:53]

In the webserver log I can't see anything special. Any idea what could be the 
problem

regards

Sven

Sven Sternberger
System Engineer
Tel.: 040/8998-4397
DESY IT


[rt-users] Can I use % wildcard within Query Builder on QUEUES?

2015-09-29 Thread Sally Ainsley
Dear All

 

I have a range of queries I am trying to create in QUERY BUILDER where I
want to include or exclude a list of QUEUES. 

 

E.g.

QUEUE NAME 1 = BLUE

QUEUE NAME 2 = BLUE -UAT

QUEUE NAME 3 = RED

QUEUE NAME 2 = RED-UAT

 

I would like to be able to include or exclude QUEUES with the letters "UAT"
within them.

 

Using the ADVANCED option of the QUERY BUILDER I have tried:

 

a)  Queue = '_%UAT'   orQueue! = '_%UAT'   

b)  Queue = '%UAT' orQueue! = '%UAT'   

 

I have also tried to use MATCHES or LIKE instead of '=' but I cannot get any
of this to work.  I have spent the last hour and a half searching on-line
and have tried various things can anyone confirm if it is possible to search
using the Wildcard characters on QUEUES within QUREY BUILDER?  And if YES -
how could I get the above to work.

 

Many thanks in advance

 

Sally

 

Sally Ainsley 

 



Re: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

2015-09-29 Thread Sally Ainsley
Thanks Matt  for prompt response

I was hoping to do something in the Query Builder as I would need to secure 
some technical resource internally to go down the perl route as I don't have 
the knowledge for perl.  

I got the same error as you below when I tried the LIKE operator.  Perhaps LIKE 
doesn’t work on the QUEUE field for some reason.


Sally Ainsley | Lifecycle Software | T: 01635 553427

-Original Message-
From: Matt Zagrabelny [mailto:mzagr...@d.umn.edu] 
Sent: 29 September 2015 16:27
To: sally.ains...@lifecycle-software.com; rt-users 

Subject: Fwd: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

On Tue, Sep 29, 2015 at 10:05 AM, Sally Ainsley 
 wrote:
> Dear All
>
>
>
> I have a range of queries I am trying to create in QUERY BUILDER where 
> I want to include or exclude a list of QUEUES.
>
>
>
> E.g.
>
> QUEUE NAME 1 = BLUE
>
> QUEUE NAME 2 = BLUE -UAT
>
> QUEUE NAME 3 = RED
>
> QUEUE NAME 2 = RED-UAT
>
>
>
> I would like to be able to include or exclude QUEUES with the letters “UAT”
> within them.
>
>
>
> Using the ADVANCED option of the QUERY BUILDER I have tried:
>
>
>
> a)  Queue = '_%UAT'   orQueue! = '_%UAT'
>
> b)  Queue = ’%UAT’ orQueue! = '%UAT'
>
>
>
> I have also tried to use MATCHES or LIKE instead of ‘=’ but I cannot 
> get any of this to work.

If it were to work, "LIKE" would be the operator. However, I don't think it 
will work.

If you look at the Search Builder page, there is only "is" and "isn't"
in the drop down for building the Queue predicate.

I just tried it with LIKE and got the following error:

[error]: Couldn't parse query: Invalid Operation: LIKE for Queue at 
/opt/rt4/sbin/../lib/RT/Tickets.pm line 368.

That said, depending on what your final needs are you could write some 
supporting perl to achieve a similar effect:

# Not tested...
my @matching_queues = ();
my $Queues = RT::Queues->new($session{CurrentUser});
while (my $Queue = $Queues->next) {
if ($Queue->Name =~ /UAT$/) {
push @matching_queues, $Queue->Name;
}
}

my $sql =
join ' OR ',
map { "Queue = '$_'" },
@matching_queues,
;

my $Tickets = RT::Tickets->new($session{CurrentUser});
$Tickets->FromSQL($sql);
# end of untested code.

Perhaps that would help.

-m



[rt-users] Fwd: Can I use % wildcard within Query Builder on QUEUES?

2015-09-29 Thread Matt Zagrabelny
On Tue, Sep 29, 2015 at 10:05 AM, Sally Ainsley
 wrote:
> Dear All
>
>
>
> I have a range of queries I am trying to create in QUERY BUILDER where I
> want to include or exclude a list of QUEUES.
>
>
>
> E.g.
>
> QUEUE NAME 1 = BLUE
>
> QUEUE NAME 2 = BLUE -UAT
>
> QUEUE NAME 3 = RED
>
> QUEUE NAME 2 = RED-UAT
>
>
>
> I would like to be able to include or exclude QUEUES with the letters “UAT”
> within them.
>
>
>
> Using the ADVANCED option of the QUERY BUILDER I have tried:
>
>
>
> a)  Queue = '_%UAT'   orQueue! = '_%UAT'
>
> b)  Queue = ’%UAT’ orQueue! = '%UAT'
>
>
>
> I have also tried to use MATCHES or LIKE instead of ‘=’ but I cannot get any
> of this to work.

If it were to work, "LIKE" would be the operator. However, I don't
think it will work.

If you look at the Search Builder page, there is only "is" and "isn't"
in the drop down for building the Queue predicate.

I just tried it with LIKE and got the following error:

[error]: Couldn't parse query: Invalid Operation: LIKE for Queue at
/opt/rt4/sbin/../lib/RT/Tickets.pm line 368.

That said, depending on what your final needs are you could write some
supporting perl to achieve a similar effect:

# Not tested...
my @matching_queues = ();
my $Queues = RT::Queues->new($session{CurrentUser});
while (my $Queue = $Queues->next) {
if ($Queue->Name =~ /UAT$/) {
push @matching_queues, $Queue->Name;
}
}

my $sql =
join ' OR ',
map { "Queue = '$_'" },
@matching_queues,
;

my $Tickets = RT::Tickets->new($session{CurrentUser});
$Tickets->FromSQL($sql);
# end of untested code.

Perhaps that would help.

-m


Re: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

2015-09-29 Thread Matt Zagrabelny
On Tue, Sep 29, 2015 at 10:38 AM, Bryon Baker  wrote:
> Hello Sally and Mat
> The like phrase works you just need to use the "Advanced" button at top of 
> page.  At that point you can type in the phrase you would like.

Sure. But not for Queue. ;)

LIKE isn't supported for Queues.

> I use this phrase in reports because I do not want the data in my 
> calculations.
>
> Requestor.EmailAddress Not Like '%DAEMON%'

You don't need the percent signs. RT adds them automatically.

-m


Re: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

2015-09-29 Thread Matt Zagrabelny
On Tue, Sep 29, 2015 at 10:32 AM, Sally Ainsley
 wrote:
> Thanks Matt  for prompt response
>
> I was hoping to do something in the Query Builder as I would need to secure 
> some technical resource internally to go down the perl route as I don't have 
> the knowledge for perl.

Sure.

> I got the same error as you below when I tried the LIKE operator.  Perhaps 
> LIKE doesn’t work on the QUEUE field for some reason.

Without looking into the code, there is a limitation on operators that
can be used with the Queue in building your search.

You could:

A. File a feature request asking for LIKE (or matches) to be added to
the operator list. I can't comment on the likelihood of it getting
cycles for a future release.

B. A perl dev in your company could hack up a patch to support it.

C. Ask Best Practical for a quote to get RT to do what you'd like.

Cheers,

-m


Re: [rt-users] Regarding incoming mails.

2015-09-29 Thread Trev
Are you using fetchmail ?
Error logs ?

On Tue, Sep 29, 2015 at 12:58 PM, bharath reddy 
wrote:

> Dear All,
>
> I've upgraded RT from 4.0.8 to 4.2.12 recently and found that I'm not able
> to receive mails to the server but when I'm updating tickets from Web then
> users are receiving the update mails. Basically my machine is not able to
> receive mails but able to send mails. Any help or pointers to this issue
> will be appreciated.
>
> Thanks,
> Bharath.
>


Re: [rt-users] Regarding incoming mails.

2015-09-29 Thread bharath reddy
Hi Trev,

I can see following error in my logs :

Sep 29 10:30:52 devrt sm-mta[9167]: t8TEUpif009167: ruleset=check_rcpt,
arg1=, relay=mail-wi0-f179.google.com
[209.85.212.179], reject=550 5.7.1 ... Relaying
denied
Sep 29 10:30:52 devrt sm-mta[9167]: t8TEUpif009167: from=<
bvang...@cs.stonybrook.edu>, size=2400, class=0, nrcpts=0, proto=ESMTP,
daemon=MTA, relay=mail-wi0-f179.google.com [209.85.212.179]

and also this :

Sep 29 12:33:05 devrt sm-mta[11503]: t8TGX4n2011503: devrt.cs.stonybrook.edu
[130.245.27.22] did not issue MAIL/EXPN/VRFY/ETRN during connection to MTA
Sep 29 12:33:25 devrt sm-mta[11504]: t8TGXOHh011504: devrt.cs.stonybrook.edu
[130.245.27.22] did not issue MAIL/EXPN/VRFY/ETRN during connection to MTA

Thanks,
Bharath.


On Tue, Sep 29, 2015 at 1:03 PM, Trev  wrote:

> Are you using fetchmail ?
> Error logs ?
>
> On Tue, Sep 29, 2015 at 12:58 PM, bharath reddy  > wrote:
>
>> Dear All,
>>
>> I've upgraded RT from 4.0.8 to 4.2.12 recently and found that I'm not
>> able to receive mails to the server but when I'm updating tickets from Web
>> then users are receiving the update mails. Basically my machine is not able
>> to receive mails but able to send mails. Any help or pointers to this issue
>> will be appreciated.
>>
>> Thanks,
>> Bharath.
>>
>
>


[rt-users] Regarding incoming mails.

2015-09-29 Thread bharath reddy
Dear All,

I've upgraded RT from 4.0.8 to 4.2.12 recently and found that I'm not able
to receive mails to the server but when I'm updating tickets from Web then
users are receiving the update mails. Basically my machine is not able to
receive mails but able to send mails. Any help or pointers to this issue
will be appreciated.

Thanks,
Bharath.


Re: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

2015-09-29 Thread Sally Ainsley
Hi Matt and Byron

Many thanks for your input I think I have a work around.

I tried the LIKE option in the Advanced button at the top of the page but I get 
the horrid red  "Couldn't parse query" error that Matt described in the email 
trail.
So for some reason whilst LIKE works with Fields like Requestor.EmailAddress 
field (as per Byron's email)  it does not work on QUEUE.

I have therefore reviewed the options within the QUERY BUILDER where 'matches' 
is a drop down option.  
There is a long list of fields where this would work (not just REQUESTOR) and 
one of these is QueueAdminCC.

So what I have done is created a Test User in RT and put this Test User as the 
QueueAdminCC for my Queues which have a name with "UAT "in them.  

I can then write Queries with the QUERY BUILDER or the ADVANCED BUTTON that 
include [QueueCc.Name LIKE 'test'] as one of the rules to get all my UAT Queues

This is not ideal but I can now write queries to select several queues that I 
will not need to update each time we add a new Queue - I will simply update our 
internal instructions so that when new Queues are set up them up with the Test 
user in the QueueAdminCC field.

Many thanks

Sally


-Original Message-
From: Bryon Baker [mailto:bba...@copesan.com] 
Sent: 29 September 2015 16:38
To: Sally Ainsley ; 'Matt Zagrabelny' 
; 'rt-users' 
Subject: RE: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

Hello Sally and Mat
The like phrase works you just need to use the "Advanced" button at top of 
page.  At that point you can type in the phrase you would like.

I use this phrase in reports because I do not want the data in my calculations.

Requestor.EmailAddress Not Like '%DAEMON%'

Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726  •  262-783-6261 ext. 2296
bba...@copesan.com
www.copesan.com
"Servicing North America with Local Care"

-Original Message-
From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
Sally Ainsley
Sent: Tuesday, September 29, 2015 10:32 AM
To: 'Matt Zagrabelny'; 'rt-users'
Subject: Re: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

Thanks Matt  for prompt response

I was hoping to do something in the Query Builder as I would need to secure 
some technical resource internally to go down the perl route as I don't have 
the knowledge for perl.  

I got the same error as you below when I tried the LIKE operator.  Perhaps LIKE 
doesn’t work on the QUEUE field for some reason.


Sally Ainsley | Lifecycle Software | T: 01635 553427

-Original Message-
From: Matt Zagrabelny [mailto:mzagr...@d.umn.edu]
Sent: 29 September 2015 16:27
To: sally.ains...@lifecycle-software.com; rt-users 

Subject: Fwd: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

On Tue, Sep 29, 2015 at 10:05 AM, Sally Ainsley 
 wrote:
> Dear All
>
>
>
> I have a range of queries I am trying to create in QUERY BUILDER where 
> I want to include or exclude a list of QUEUES.
>
>
>
> E.g.
>
> QUEUE NAME 1 = BLUE
>
> QUEUE NAME 2 = BLUE -UAT
>
> QUEUE NAME 3 = RED
>
> QUEUE NAME 2 = RED-UAT
>
>
>
> I would like to be able to include or exclude QUEUES with the letters “UAT”
> within them.
>
>
>
> Using the ADVANCED option of the QUERY BUILDER I have tried:
>
>
>
> a)  Queue = '_%UAT'   orQueue! = '_%UAT'
>
> b)  Queue = ’%UAT’ orQueue! = '%UAT'
>
>
>
> I have also tried to use MATCHES or LIKE instead of ‘=’ but I cannot 
> get any of this to work.

If it were to work, "LIKE" would be the operator. However, I don't think it 
will work.

If you look at the Search Builder page, there is only "is" and "isn't"
in the drop down for building the Queue predicate.

I just tried it with LIKE and got the following error:

[error]: Couldn't parse query: Invalid Operation: LIKE for Queue at 
/opt/rt4/sbin/../lib/RT/Tickets.pm line 368.

That said, depending on what your final needs are you could write some 
supporting perl to achieve a similar effect:

# Not tested...
my @matching_queues = ();
my $Queues = RT::Queues->new($session{CurrentUser});
while (my $Queue = $Queues->next) {
if ($Queue->Name =~ /UAT$/) {
push @matching_queues, $Queue->Name;
}
}

my $sql =
join ' OR ',
map { "Queue = '$_'" },
@matching_queues,
;

my $Tickets = RT::Tickets->new($session{CurrentUser});
$Tickets->FromSQL($sql);
# end of untested code.

Perhaps that would help.

-m




Re: [rt-users] Sql to find disabled users

2015-09-29 Thread Matt Zagrabelny
> This might me tougher.

s/me/be/

-m


Re: [rt-users] Sql to find disabled users

2015-09-29 Thread Jesse Maseto
Thank you Matt. I'll let everyone what I find out.

On Tuesday, September 29, 2015, Matt Zagrabelny  wrote:

> > This might me tougher.
>
> s/me/be/
>
> -m
>


-- 


Jesse Maseto
Head of Support
ByWater Solutions
Support & Consulting for OSS
Office - Stratford,CT
T/F 888.900.8944
http://bywatersolutions.com
je...@bywatersolutions.com


Re: [rt-users] Sql to find disabled users

2015-09-29 Thread Matt Zagrabelny
Hi Jesse,

On Tue, Sep 29, 2015 at 5:18 PM, Jesse Maseto
 wrote:
> Hello All,
>
> I was wondering some one can assist me with creating an sql search of RT. I
> am looking to find all disaled users in my system and then use the
> rt-shredder pluggin to delete them.

I've not looked into the disabled-ness of a user, but to start
digging, I'd grep the following file:

lib/RT/User.pm

> Also maybe a search that shows accounts that have not logged in for over two
> years.

This might me tougher.

-m


Re: [rt-users] Getting rid of mis-spelled users

2015-09-29 Thread Jason L Tibbitts III
> "JLT" == Jason L Tibbitts  writes:

JLT> Is there any way for me to get rid of these bogus addresses?

And after seeing another message here about the shredder, I looked into
it and found it to be pretty much exactly what I'm looking for.

 - J<


Re: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

2015-09-29 Thread Bryon Baker
Hello Sally and Mat
The like phrase works you just need to use the "Advanced" button at top of 
page.  At that point you can type in the phrase you would like.

I use this phrase in reports because I do not want the data in my calculations.

Requestor.EmailAddress Not Like '%DAEMON%'

Thanks
Bryon Baker
Network Operations Manager
Copesan - Specialists in Pest Solutions
800-267-3726  •  262-783-6261 ext. 2296
bba...@copesan.com
www.copesan.com
"Servicing North America with Local Care"

-Original Message-
From: rt-users [mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of 
Sally Ainsley
Sent: Tuesday, September 29, 2015 10:32 AM
To: 'Matt Zagrabelny'; 'rt-users'
Subject: Re: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

Thanks Matt  for prompt response

I was hoping to do something in the Query Builder as I would need to secure 
some technical resource internally to go down the perl route as I don't have 
the knowledge for perl.  

I got the same error as you below when I tried the LIKE operator.  Perhaps LIKE 
doesn’t work on the QUEUE field for some reason.


Sally Ainsley | Lifecycle Software | T: 01635 553427

-Original Message-
From: Matt Zagrabelny [mailto:mzagr...@d.umn.edu]
Sent: 29 September 2015 16:27
To: sally.ains...@lifecycle-software.com; rt-users 

Subject: Fwd: [rt-users] Can I use % wildcard within Query Builder on QUEUES?

On Tue, Sep 29, 2015 at 10:05 AM, Sally Ainsley 
 wrote:
> Dear All
>
>
>
> I have a range of queries I am trying to create in QUERY BUILDER where 
> I want to include or exclude a list of QUEUES.
>
>
>
> E.g.
>
> QUEUE NAME 1 = BLUE
>
> QUEUE NAME 2 = BLUE -UAT
>
> QUEUE NAME 3 = RED
>
> QUEUE NAME 2 = RED-UAT
>
>
>
> I would like to be able to include or exclude QUEUES with the letters “UAT”
> within them.
>
>
>
> Using the ADVANCED option of the QUERY BUILDER I have tried:
>
>
>
> a)  Queue = '_%UAT'   orQueue! = '_%UAT'
>
> b)  Queue = ’%UAT’ orQueue! = '%UAT'
>
>
>
> I have also tried to use MATCHES or LIKE instead of ‘=’ but I cannot 
> get any of this to work.

If it were to work, "LIKE" would be the operator. However, I don't think it 
will work.

If you look at the Search Builder page, there is only "is" and "isn't"
in the drop down for building the Queue predicate.

I just tried it with LIKE and got the following error:

[error]: Couldn't parse query: Invalid Operation: LIKE for Queue at 
/opt/rt4/sbin/../lib/RT/Tickets.pm line 368.

That said, depending on what your final needs are you could write some 
supporting perl to achieve a similar effect:

# Not tested...
my @matching_queues = ();
my $Queues = RT::Queues->new($session{CurrentUser});
while (my $Queue = $Queues->next) {
if ($Queue->Name =~ /UAT$/) {
push @matching_queues, $Queue->Name;
}
}

my $sql =
join ' OR ',
map { "Queue = '$_'" },
@matching_queues,
;

my $Tickets = RT::Tickets->new($session{CurrentUser});
$Tickets->FromSQL($sql);
# end of untested code.

Perhaps that would help.

-m



Re: [rt-users] Regarding incoming mails.

2015-09-29 Thread bharath reddy
Thanks Trev for the quick response, there was a problem with our mail
sending server which was the reason RT was not able to receive the mails.
We fixed it and now RT is able to receive the mails and generate the
tickets automatically. Thanks once again for the help.

Thanks,
Bharath.

On Tue, Sep 29, 2015 at 1:34 PM, Trev  wrote:

> Just to be clear here:
>
> *Broken*:   Fetchmail from your RT server, pulling email from an account
> on your email server (exchange or whatever)
>
> *Working*:  Sendmail from your RT server, pushing notifications from the
> RT server to your email recipients
>
> The error you post, looks like sendmail errors... not fetchmail...
>
> /var/log/fetchmail.log
>
> Also, the fetchmail configuration file could be useful. (please replace
> passwords and other identifiers in your copy paste)
>
> Thanks,
>
> Trev
>
> On Tue, Sep 29, 2015 at 1:10 PM, bharath reddy 
> wrote:
>
>> Hi Trev,
>>
>> I can see following error in my logs :
>>
>> Sep 29 10:30:52 devrt sm-mta[9167]: t8TEUpif009167: ruleset=check_rcpt,
>> arg1=, relay=mail-wi0-f179.google.com
>> [209.85.212.179], reject=550 5.7.1 ... Relaying
>> denied
>> Sep 29 10:30:52 devrt sm-mta[9167]: t8TEUpif009167: from=<
>> bvang...@cs.stonybrook.edu>, size=2400, class=0, nrcpts=0, proto=ESMTP,
>> daemon=MTA, relay=mail-wi0-f179.google.com [209.85.212.179]
>>
>> and also this :
>>
>> Sep 29 12:33:05 devrt sm-mta[11503]: t8TGX4n2011503:
>> devrt.cs.stonybrook.edu [130.245.27.22] did not issue
>> MAIL/EXPN/VRFY/ETRN during connection to MTA
>> Sep 29 12:33:25 devrt sm-mta[11504]: t8TGXOHh011504:
>> devrt.cs.stonybrook.edu [130.245.27.22] did not issue
>> MAIL/EXPN/VRFY/ETRN during connection to MTA
>>
>> Thanks,
>> Bharath.
>>
>>
>> On Tue, Sep 29, 2015 at 1:03 PM, Trev  wrote:
>>
>>> Are you using fetchmail ?
>>> Error logs ?
>>>
>>> On Tue, Sep 29, 2015 at 12:58 PM, bharath reddy <
>>> vangoor.bhar...@gmail.com> wrote:
>>>
 Dear All,

 I've upgraded RT from 4.0.8 to 4.2.12 recently and found that I'm not
 able to receive mails to the server but when I'm updating tickets from Web
 then users are receiving the update mails. Basically my machine is not able
 to receive mails but able to send mails. Any help or pointers to this issue
 will be appreciated.

 Thanks,
 Bharath.

>>>
>>>
>>
>


[rt-users] Getting rid of mis-spelled users

2015-09-29 Thread Jason L Tibbitts III
Occasionally our office folks will create a ticket and CC an address
which does not exist.  And once they've done this, these addresses
appear in the dropdown so they keep getting chosen.  The bounces don't
go anywhere useful yet (though I'm trying to set up some kind of bounce
parsing).

Is there any way for me to get rid of these bogus addresses?  I can't
just delete them, but I would merge them all into the correct addresses
if I could.  In addition, whenever we get spam, those addresses enter
the list as well and it would be nice to clean them up somehow.  I know
those users are still referenced in tickets which is why I can't just
delete a user.  I'm thinking this is one of those things that requires
direct database manipulation and I'd hate to screw things up.

 - J<


[rt-users] How to measure progress on a task with a performance indicator evolving with time.

2015-09-29 Thread Gaston Huot
I'm helping on a project in Haïti (on a volontary base).

They use a Results Based Management (RBM) process.

I'm trying to use RT to support their work, having RT delivering what is
required by RBM

The concept uses many entities:

   - Ultimate outcome, depending on:
   - Intermediate outcomes, depending on:
   - Immediate outcomes, depending on:
   - Outputs
   - Activities/sub-act

For each outcome, there is a target and on a pre-defined frequency there is
an assessment made to measure progress and compare it to the expected
results.

Right now I have a queue for each of the above, and one for the expected
results. All theses are linked together. So far so good.

My problem is with the reporting of the progress. What would be the most
efficient and simpler way to capture the indicator at a specific moment
toward an expected result (which is a task in my actual model) and keep it
for reporting. The indicator could be a number (% and absolute numbers) or
a level represented by a letter)

Sorry if it is not more "clear".

Thanks

Gaston


Re: [rt-users] Regarding incoming mails.

2015-09-29 Thread Trev
Just to be clear here:

*Broken*:   Fetchmail from your RT server, pulling email from an account on
your email server (exchange or whatever)

*Working*:  Sendmail from your RT server, pushing notifications from the RT
server to your email recipients

The error you post, looks like sendmail errors... not fetchmail...

/var/log/fetchmail.log

Also, the fetchmail configuration file could be useful. (please replace
passwords and other identifiers in your copy paste)

Thanks,

Trev

On Tue, Sep 29, 2015 at 1:10 PM, bharath reddy 
wrote:

> Hi Trev,
>
> I can see following error in my logs :
>
> Sep 29 10:30:52 devrt sm-mta[9167]: t8TEUpif009167: ruleset=check_rcpt,
> arg1=, relay=mail-wi0-f179.google.com
> [209.85.212.179], reject=550 5.7.1 ... Relaying
> denied
> Sep 29 10:30:52 devrt sm-mta[9167]: t8TEUpif009167: from=<
> bvang...@cs.stonybrook.edu>, size=2400, class=0, nrcpts=0, proto=ESMTP,
> daemon=MTA, relay=mail-wi0-f179.google.com [209.85.212.179]
>
> and also this :
>
> Sep 29 12:33:05 devrt sm-mta[11503]: t8TGX4n2011503:
> devrt.cs.stonybrook.edu [130.245.27.22] did not issue MAIL/EXPN/VRFY/ETRN
> during connection to MTA
> Sep 29 12:33:25 devrt sm-mta[11504]: t8TGXOHh011504:
> devrt.cs.stonybrook.edu [130.245.27.22] did not issue MAIL/EXPN/VRFY/ETRN
> during connection to MTA
>
> Thanks,
> Bharath.
>
>
> On Tue, Sep 29, 2015 at 1:03 PM, Trev  wrote:
>
>> Are you using fetchmail ?
>> Error logs ?
>>
>> On Tue, Sep 29, 2015 at 12:58 PM, bharath reddy <
>> vangoor.bhar...@gmail.com> wrote:
>>
>>> Dear All,
>>>
>>> I've upgraded RT from 4.0.8 to 4.2.12 recently and found that I'm not
>>> able to receive mails to the server but when I'm updating tickets from Web
>>> then users are receiving the update mails. Basically my machine is not able
>>> to receive mails but able to send mails. Any help or pointers to this issue
>>> will be appreciated.
>>>
>>> Thanks,
>>> Bharath.
>>>
>>
>>
>