[rt-users] Scrip On Create Notify AdminCcs not working right?

2015-04-09 Thread Edsall, William (WJ)
Hello list,
I'm having trouble finding a pattern but sometimes the AdminCC notification 
email goes out, and sometimes it does not.
The 'On Create Autoreply To Requestors' always seems to be emailed correctly. 
It's just the AdminCC email that doesn't seem to go out properly.


Could anyone kindly recommend some testing or suggestions?

William


Re: [rt-users] Could not load a valid user

2015-04-09 Thread k...@rice.edu
On Thu, Apr 09, 2015 at 12:34:33PM +, Daniel Moore wrote:
 Hello,
 
 I have an issue where we keep getting emails for ONE particular email that 
 says Cannot load a valid user.
 
 I have already added this user into RT. I have even deleted and re-added 
 him (I deleted it from the SQL database and ensured no reference to it all 
 was in RT). He is back in the system.
 
 I have configured my RT_SiteConfig.pm three different ways with no avail.
 
 Set( $ValidateUserEmailAddress, 1); current setting
 
 #Set( $ValidateUserEmailAddress, 0); previous setting
 
 Set( $ValidateUserEmailAddress, 0); original setting
 
 I do not know why this is still happening even though I have tried to turn 
 this off. I originally set it up because this was new to our organization 
 (this version) and we had a lot of junk emails getting through. I thought I 
 had turned this off by commenting it out.
 
 This only effects ONE email address (that I know of) and it happens every day.
 
 Is there a way to permanently turn this off so that it doesn't validate users?
 
 Oh, and this user has administrator privileges in RT so user rights are not a 
 problem. This is our IT email address.
 

Hi Daniel,

When we have seen this error, it was the result of our CanonicalizeEmailAddress
function in User_Local.pm (in 3.8.x). Run through that functions logic to 
determine
where the problem is. In our case, the problem was caused by user primary Email
address changes. The permissions of the account do not matter since the cause is
the failure to determine the correct Email address. I hope this helps.

Regards,
Ken


Re: [rt-users] Could not load a valid user

2015-04-09 Thread Bryon Baker
We have this same issue.  I have track down the issue to the fact that the 
email address has mixed case somewhere in the address.  To solve it, I have to 
manually the user so the name is all lower case and the email address matches 
the incoming email address.

I did at one point have an open case about this issue with Best Practical.  I 
do not know if this issue has been addressed.

I am running version 4.2.3

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 
k...@rice.edu
Sent: Thursday, April 09, 2015 8:02 AM
To: Daniel Moore
Cc: 'rt-users@lists.bestpractical.com'
Subject: Re: [rt-users] Could not load a valid user

On Thu, Apr 09, 2015 at 12:34:33PM +, Daniel Moore wrote:
 Hello,
 
 I have an issue where we keep getting emails for ONE particular email that 
 says Cannot load a valid user.
 
 I have already added this user into RT. I have even deleted and re-added 
 him (I deleted it from the SQL database and ensured no reference to it all 
 was in RT). He is back in the system.
 
 I have configured my RT_SiteConfig.pm three different ways with no avail.
 
 Set( $ValidateUserEmailAddress, 1); current setting
 
 #Set( $ValidateUserEmailAddress, 0); previous setting
 
 Set( $ValidateUserEmailAddress, 0); original setting
 
 I do not know why this is still happening even though I have tried to turn 
 this off. I originally set it up because this was new to our organization 
 (this version) and we had a lot of junk emails getting through. I thought I 
 had turned this off by commenting it out.
 
 This only effects ONE email address (that I know of) and it happens every day.
 
 Is there a way to permanently turn this off so that it doesn't validate users?
 
 Oh, and this user has administrator privileges in RT so user rights are not a 
 problem. This is our IT email address.
 

Hi Daniel,

When we have seen this error, it was the result of our CanonicalizeEmailAddress 
function in User_Local.pm (in 3.8.x). Run through that functions logic to 
determine where the problem is. In our case, the problem was caused by user 
primary Email address changes. The permissions of the account do not matter 
since the cause is the failure to determine the correct Email address. I hope 
this helps.

Regards,
Ken


Re: [rt-users] Could not load a valid user

2015-04-09 Thread k...@rice.edu
You can fix the CanonicalizeEmailAddress function to handle the fact that
their are case differences and select the correct address to use in those
cases.

Regards,
Ken

On Thu, Apr 09, 2015 at 02:32:52PM +, Bryon Baker wrote:
 We have this same issue.  I have track down the issue to the fact that the 
 email address has mixed case somewhere in the address.  To solve it, I have 
 to manually the user so the name is all lower case and the email address 
 matches the incoming email address.
 
 I did at one point have an open case about this issue with Best Practical.  I 
 do not know if this issue has been addressed.
 
 I am running version 4.2.3
 
 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 
 k...@rice.edu
 Sent: Thursday, April 09, 2015 8:02 AM
 To: Daniel Moore
 Cc: 'rt-users@lists.bestpractical.com'
 Subject: Re: [rt-users] Could not load a valid user
 
 On Thu, Apr 09, 2015 at 12:34:33PM +, Daniel Moore wrote:
  Hello,
  
  I have an issue where we keep getting emails for ONE particular email that 
  says Cannot load a valid user.
  
  I have already added this user into RT. I have even deleted and re-added 
  him (I deleted it from the SQL database and ensured no reference to it all 
  was in RT). He is back in the system.
  
  I have configured my RT_SiteConfig.pm three different ways with no avail.
  
  Set( $ValidateUserEmailAddress, 1); current setting
  
  #Set( $ValidateUserEmailAddress, 0); previous setting
  
  Set( $ValidateUserEmailAddress, 0); original setting
  
  I do not know why this is still happening even though I have tried to turn 
  this off. I originally set it up because this was new to our organization 
  (this version) and we had a lot of junk emails getting through. I thought 
  I had turned this off by commenting it out.
  
  This only effects ONE email address (that I know of) and it happens every 
  day.
  
  Is there a way to permanently turn this off so that it doesn't validate 
  users?
  
  Oh, and this user has administrator privileges in RT so user rights are not 
  a problem. This is our IT email address.
  
 
 Hi Daniel,
 
 When we have seen this error, it was the result of our 
 CanonicalizeEmailAddress function in User_Local.pm (in 3.8.x). Run through 
 that functions logic to determine where the problem is. In our case, the 
 problem was caused by user primary Email address changes. The permissions of 
 the account do not matter since the cause is the failure to determine the 
 correct Email address. I hope this helps.
 
 Regards,
 Ken
 


[rt-users] attachments not properly present in HTML mail

2015-04-09 Thread Boli
Hi

I'm sure there's a problem with my template. Can anyone point it out to
me? The attachments seem to be added to the mail if I view the mail
source - but I cannot see them in most mail clients (Thunderbird in
particular)

This only happened when I recently a) upgraded from 4.2.2 to 4.2.10, and
b) started using HTML templates

Thanks

-- template starts here --
{
  my $result=;
  my $u = $Transaction-CreatorObj;
  if ( $u-Privileged ) {
my $a = $Ticket-QueueObj-CorrespondAddress;
$a = $Ticket-QueueObj-CommentAddress if ( $Transaction-Type eq
'Comment' );
$result .= From: .$Ticket-QueueObj-Description(). .$a.;
  }
  $result;
}
RT-Attach-Message: yes
Content-Type: text/html

{$Transaction-Content( Type = text/html)}
--template ends here --

-- 
Jon 'Boli' Copeland
Systems Engineer
IT Sales  Services Ltd
All sales enquiries   : sa...@itss.co.tz
All support enquiries : supp...@itss.co.tz
Emergencies Only  : +255 (0) 685 374780



[rt-users] Could not load a valid user

2015-04-09 Thread Daniel Moore
Hello,

I have an issue where we keep getting emails for ONE particular email that says 
Cannot load a valid user.

I have already added this user into RT. I have even deleted and re-added him 
(I deleted it from the SQL database and ensured no reference to it all was in 
RT). He is back in the system.

I have configured my RT_SiteConfig.pm three different ways with no avail.

Set( $ValidateUserEmailAddress, 1); current setting

#Set( $ValidateUserEmailAddress, 0); previous setting

Set( $ValidateUserEmailAddress, 0); original setting

I do not know why this is still happening even though I have tried to turn this 
off. I originally set it up because this was new to our organization (this 
version) and we had a lot of junk emails getting through. I thought I had 
turned this off by commenting it out.

This only effects ONE email address (that I know of) and it happens every day.

Is there a way to permanently turn this off so that it doesn't validate users?

Oh, and this user has administrator privileges in RT so user rights are not a 
problem. This is our IT email address.


V/R,

Daniel Moore
IT Systems Technician
Osborne Wood Products, Inc.
[http://hosting-source.bm23.com/9241/public/OsborneLogo111.jpg]
P: 706.282.5764
F: 888.777.4304
http://www.osbornewood.com



[rt-users] RTx-WorkflowBuilder Workflow issues

2015-04-09 Thread Matt Wells
I was able to walk back some of the errors but not all.  At one point
I was able to get tickets created with the only issue being the
'Finance approval' as they would never have permissions or the ability
to view the tickets.  Any guidance would be great.


*** RT_SiteConfig.pm
  Set( $WorkflowBuilderStages,
   { 'Manager approval' =
 { content = '.',

   owner = q!{{
Fire= 'matt.wells',
Marketing   = 'user1'}-{
$Approving-FirstCustomFieldValue('TechReview') }}! },
 'Finance approval' =


{ content = '... ',
   owner = 'user2',
 },
 'CEO approval' =


{ content = '..',
   owner = 'matt.wells',
 }});

  Set( $WorkflowBuilderRules,
  { 'PO-Approval' = [ 'Manager approval' = 'Finance approval' =
'CEO approval'],
'Vacation-Approval' = [ 'Manager approval' = 'CEO approval']
 }
);




[root@server1 lib]# pwd
/opt/rt4/local/plugins/RTx-WorkflowBuilder/lib
[root@server1 lib]# PERL5LIB=/opt/rt4/local/lib:/opt/rt4/lib:$PERL5LIB
../bin/rt-workflow Wells-CCB PO-Approval --create
[15133] [Thu Apr  9 17:02:49 2015] [warning]: DBD::mysql::st execute
failed: Unknown column 'main.Queue' in 'where clause' at
/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 586.
(/usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm:586)
[15133] [Thu Apr  9 17:02:49 2015] [warning]:
RT::Handle=HASH(0x11c2088) couldn't execute the query 'SELECT main.*
FROM Scrips main  WHERE (main.Disabled = '0') AND (main.Queue = '6') '
at /usr/local/share/perl5/DBIx/SearchBuilder/Handle.pm line 599.
DBIx::SearchBuilder::Handle::SimpleQuery(RT::Handle=HASH(0x11c2088),
SELECT main.* FROM Scrips main  WHERE (main.Disabled = '0') A...)
called at /usr/local/share/perl5/DBIx/SearchBuilder.pm line 239
DBIx::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x3b5bfc8)) called at
/opt/rt4/lib/RT/SearchBuilder.pm line 985
RT::SearchBuilder::_DoSearch(RT::Scrips=HASH(0x3b5bfc8)) called at
/usr/local/share/perl5/DBIx/SearchBuilder.pm line 507
DBIx::SearchBuilder::Next(RT::Scrips=HASH(0x3b5bfc8)) called at
/opt/rt4/lib/RT/Scrips.pm line 253
RT::Scrips::Next(RT::Scrips=HASH(0x3b5bfc8)) called at
../bin/rt-workflow line 121 (/usr/share/perl5/Carp.pm:169)