[rt-users] Scrip On Create Notify AdminCcs not working right?
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
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
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
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
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
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
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)