Re: [rt-users] RT 4 on Amazon EC2

2017-02-22 Thread Landon Stewart
put of 'httpd -V' for the 'Server MPM' line. It should be prefork and you should tune the configuration of that to use less resources if not already done. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://www.internap.com>

Re: [rt-users] Help with rt-email-digest: not found

2017-02-04 Thread Landon Stewart
sends the digest emails? Hi Martin, Does /usr/sbin/rt-email-digest actually not exist or does the interpreter on the first line of /usr/sbin/rt-email-digest not exist? Is your RT installation in /opt/rt4/ or something? -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧

Re: [rt-users] How to delete Ticket

2017-01-25 Thread Landon Stewart
Oh, also. To remove a ticket properly (do not attempt to edit the database) you use rt-shredder. Example: rt-shredder --plugin 'Tickets=query,id = ' There's also a web UI within RT: https://rt-wiki.bestpractical.com/wiki/Shredder#WebUI On Jan 25, 2017, at 1:24 PM, Landon Stewar

Re: [rt-users] How to delete Ticket

2017-01-25 Thread Landon Stewart
www.prg.com<http://www.prg.com/> -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://www.internap.com>

Re: [rt-users] Occasional errors sending email through RT: Duplicate header field

2016-12-25 Thread Landon Stewart
Have you tried whitelisting senders in amavisd? -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://www.internap.com>

Re: [rt-users] Are these log errors normal?

2016-12-21 Thread Landon Stewart
AME=xenial DISTRIB_DESCRIPTION="Ubuntu 16.04.1 LTS" root@sbs-help:~# perl --version This is perl 5, version 22, subversion 1 (v5.22.1) built for x86_64-linux-gnu-thread-multi (with 58 registered patches, see perl -V for more detail) Thank you! -- Best regards, Steve -- Landon Stewa

Re: [rt-users] LastUpdated for tickets not working?

2016-12-19 Thread Landon Stewart
All date/time values stored by MySQL are GMT. One must convert them to GMT before storage and convert them to the user's timezone when displaying them. RT is aware of this and already takes care of it assuming your time zone settings are correct on the server. -- Landon Stewart Lead Analyst -

Re: [rt-users] supplying database credentials to rt-fulltext-indexer

2016-12-09 Thread Landon Stewart
and make sure it works before you potentially interrupt the flow of business in production. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://www.internap.com> - R

Re: [rt-users] supplying database credentials to rt-fulltext-indexer

2016-12-09 Thread Landon Stewart
can't be the first to use my own database name, username, and password who needs this tool to run. /opt/rt4/sbin/rt-setup-fulltext-index --dba root --dba-password secret Source: https://docs.bestpractical.com/rt/4.2.12/full_text_indexing.html -- Landon Stewart Lead Analyst - Abu

Re: [rt-users] which scripts fire when

2016-12-07 Thread Landon Stewart
:353) [16980] [Mon Oct 17 16:03:55 2016] [debug]: Skipping Scrip #74 because it isn't applicable (/opt/rt4/sbin/../lib/RT/Scrips.pm:353) [16980] [Mon Oct 17 16:03:55 2016] [debug]: Skipping Scrip #78 because it isn't applicable (/opt/rt4/sbin/../lib/RT/Scrips.pm:353) -- Landon St

Re: [rt-users] RTIR: Best way for customers to see all tickets for their employees

2016-12-05 Thread Landon Stewart
admincclist = $self->TicketObj->AdminCc; #$admincclist->AddMember($groupObj->Id); #This doesn't work... my ($status, $message) = $self->TicketObj->AddWatcher( Type=> "Customer", PrincipalId => $groupObj->Id ); RT->Logger->warning("AddWatc

Re: [rt-users] how to supply db credentials to rt-email-dashboards?

2016-12-02 Thread Landon Stewart
As far as I know the ~user/.rtrc file is good for both rt-crontool and the rt utility itself. I've cc'd the list in case anyone has any more info or corrections. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@int

Re: [rt-users] how to supply db credentials to rt-email-dashboards?

2016-11-25 Thread Landon Stewart
-email-dashboards create a file called '.rtrc'. That file should contain: server user root passwd Example: # cat ~root/.rtrc server http://localhost/rt user root passwd ohsupaihai7moR1 -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@inte

Re: [rt-users] Timezone set to GMT?

2016-11-18 Thread Landon Stewart
abase, and back again; users can override this. It should be set to a timezone recognized by your server. eg: Set($Timezone, "US/Eastern"); -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www

Re: [rt-users] Unable to drag files to attach them?

2016-11-08 Thread Landon Stewart
ton and it lights up while you do it but I don't know if that works on Windows and I don't know if it's the same in all browsers. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.co

Re: [rt-users] Enable devel-mode on existing RT instance?

2016-11-02 Thread Landon Stewart
tion such as passwords or ticket content. * Turns off caching of callbacks; this enables additional callbacks to be added while the server is running. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.i

Re: [rt-users] Mason Cache clear

2016-10-31 Thread Landon Stewart
sessions, and a new workshop day! https://bestpractical.com/training * Los Angeles - Q1 2017 -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://www.internap.com> - RT 4.

Re: [rt-users] CommandByMail config

2016-10-28 Thread Landon Stewart
sessions, and a new workshop day! https://bestpractical.com/training * Los Angeles - Q1 2017 -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://www.internap.com> - RT 4.

Re: [rt-users] Template snippet causes template to silently fail

2016-10-26 Thread Landon Stewart
} elsif ($self->TransactionObj->Type eq 'Comment') { # something else } else { # Not a Comment or Correspond transaction } } Or something that actually does exactly what your pseudocode does: { $self->TransactionObj->Type } I have found these very helpful in the pas

Re: [rt-users] error when using custom template

2016-10-26 Thread Landon Stewart
icket site. -- Alex Hall Automatic Distributors, IT department ah...@autodist.com<mailto:ah...@autodist.com> - RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017 -- Landon Stewart Lead Analy

Re: [rt-users] Seeing this error in the log

2016-10-25 Thread Landon Stewart
r->id } ) ) { ( $status, $msg ) = $reminder->SetOwner( $args->{ 'Reminder-Owner-' . $reminder->id }, "Force" ); push @subresults, $msg; } -- Landon Stewart Lead

Re: [rt-users] Seeing this error in the log

2016-10-25 Thread Landon Stewart
OH! I should mention that code stanza below is taken from the rt-4.4.1.tar.gz since I don't have 4.4.1 installed. On Oct 25, 2016, at 2:29 PM, Landon Stewart mailto:lstew...@internap.com>> wrote: I think it has something to do with the reminders if that helps. The following if(

Re: [rt-users] RT 4.2.9 (+ RTIR 3.2.0) Menus do not load all of a sudden this morning unless I turn $DevelMode on

2016-10-18 Thread Landon Stewart
On Oct 17, 2016, at 11:52 AM, Landon Stewart mailto:lstew...@internap.com>> wrote: Hello, This morning my team could not see the ticket history on tickets. I changed the $ShowHistory setting to 'always' and this fixed that particular issue. Then I noticed that the menus a

[rt-users] RT 4.2.9 (+ RTIR 3.2.0) Menus do not load all of a sudden this morning unless I turn $DevelMode on

2016-10-17 Thread Landon Stewart
also like to delay the ticket history like it was before too but I suspect that these issues are related (javascript issues). From my browser's developer console: [cid:C0C704A7-5798-43D0-A14D-A9B693CE1756@corp.iweb.com] -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧

Re: [rt-users] Calculating the number of emails/replies/correspondences per ticket

2016-10-04 Thread Landon Stewart
On Oct 4, 2016, at 2:09 PM, Anthony Nguyen-Duong mailto:ant...@hotmail.com>> wrote: Hi Landon, Thanks for the reply. In your implementation, what kind of charts can you make with those CFs? We classify our tickets by subject matter so the chart I'm seeing is basically grouped b

Re: [rt-users] Calculating the number of emails/replies/correspondences per ticket

2016-10-04 Thread Landon Stewart
(read the current CF value, add 1, delete the old CF value, record the new CF value). The net effect was that the CFs were updated only when it was necessary. This is a much more efficient way to do it. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@inter

Re: [rt-users] Close tickets with email

2016-10-01 Thread Landon Stewart
limit it's use to certain groups and change the Queue, Owner, Status, Custom Fields, etc with it by replying to tickets with certain content at the top of the reply. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@inte

Re: [rt-users] REST API; the plus-character (+) will be not processed; plain email

2016-09-20 Thread Landon Stewart
ill be processed. Here a simple content: content= id: ticket/new Subject: Test '\+' Queue: General You should urlencode that text: $ perl -e 'use URL::Encode qw/url_encode_utf8/; print url_encode_utf8("Test +");' Test+%2B The + here is the space, the %2B is the plus sign

Re: [rt-users] Ubuntu 16.04.1 LTS

2016-09-12 Thread Landon Stewart
On Sep 12, 2016, at 2:51 PM, Pavneet Arora mailto:pavneet_ar...@waroc.com>> wrote: This is the error that I am getting on the command line. If anyone has any insights, I would be most grateful before I dive into the switch to mod_fcgid with apache2 tonight: # /opt/rt4/sbin/rt-server.fcgi -pr

Re: [rt-users] Apt source for RT dependencies?

2016-09-12 Thread Landon Stewart
On Sep 12, 2016, at 12:39 PM, Alex Hall mailto:ah...@autodist.com>> wrote: When I issue the command you suggested: Can't open perl script: no such file or directory Something seems very off about the Perl installation on this server, given that all the dependencies it can't get seem to be the P

Re: [rt-users] Moving Tickets in Bulk

2016-09-12 Thread Landon Stewart
I would personally avoid editing the database manually. Instead I would simply stop new mail from coming in from users/staff and disable the Scrip that would send the notification until the import is done. On Sep 12, 2016, at 9:08 AM, Tim Gustafson wrote: > > We just finished importing around

Re: [rt-users] Apt source for RT dependencies?

2016-09-12 Thread Landon Stewart
> On Sep 12, 2016, at 12:32 PM, Landon Stewart wrote: > > I would not use the repo version even without familiarity with Linux - it > would make things actually more difficult later. I would follow the > instructions exactly as they are written by BestPractical from the .tar

Re: [rt-users] Apt source for RT dependencies?

2016-09-12 Thread Landon Stewart
I would not use the repo version even without familiarity with Linux - it would make things actually more difficult later. I would follow the instructions exactly as they are written by BestPractical from the .tar.gz on their site. One thing you can do to make life a little easier before doing

Re: [rt-users] import tickets from csv file

2016-09-09 Thread Landon Stewart
RT4.0 I do not know perl enough to write my own script. So hopefully there is something out there that works and can be shared. Regards Brian - RT 4.4 and RTIR training sessions, and a new workshop day! https://bestpractical.com/training * Boston - October 24-26 * Los Angeles - Q1 2017

Re: [rt-users] import tickets from csv file

2016-09-09 Thread Landon Stewart
mat the csv anyway as desired but importing as email will make me the requester for every ticket? From: Landon Stewart [mailto:lstew...@internap.com] Sent: Friday, September 9, 2016 2:38 PM To: Dunbar, Brian Cc: rt-users@lists.bestpractical.com<mailto:rt-users@lists.bestpractical.com> Subject: Re

Re: [rt-users] FW: Query for custom fields using 'NOT LIKE' is no longer working

2016-09-07 Thread Landon Stewart
Can you use != instead? eg. CF.{cfname} != 'EPIC'. I wonder if you have the same problem using != instead but yeah it does sound like a bug to me. I did notice that you had strange quotations again though but I trust you are just using regular single quotes in actuality. CF.{11} NOT L

Re: [rt-users] Emails causing duplicate tickets?

2016-09-07 Thread Landon Stewart
tream server capabilities. Note also that this option may be removed and forced enabled in a future fetchmail version. See also: --idfile. -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.intern

Re: [rt-users] Query for custom fields using 'NOT LIKE' is no longer working

2016-09-07 Thread Landon Stewart
on my screen the single quotes around the word Epic are different than the other words that have single quotes. 'development' vs ‘Epic’ [cid:B1747A7F-2B3B-409D-9B0F-63C79811C7FC@telus] -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@

Re: [rt-users] How to backup/dump Postgre SQL

2016-08-05 Thread Landon Stewart
eg: # su postgres $ pg_dump rtdb -> /tmp/rtdb-backup OOPS # su postgres $ pg_dump rtdb > /tmp/rtdb-backup -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://www.internap.com

Re: [rt-users] How to backup/dump Postgre SQL

2016-08-05 Thread Landon Stewart
es instead of just get the permissions of postgres. If that doesn't work because it doesn't have a shell try sudo but ultimately you need to be in a place you can write to while having the permissions of postgres or specify the location in the redirect. eg: # su postgres $ pg_dump rtdb

Re: [rt-users] Recover original scripts in RT

2016-07-18 Thread Landon Stewart
sounds like you just need to recreate the global Scrip that does this: [cid:83379900-285D-4257-B334-5A7854A16D06@corp.iweb.com] -- Landon Stewart Lead Analyst - Abuse and Security Management INTERNAP ® 📧 lstew...@internap.com<mailto:lstew...@internap.com> 🌍 www.internap.com<http://w

Re: [rt-users] Please help with RT::Authen::ExternalAuth with nested LDAP/AD groups

2016-07-15 Thread Landon Stewart
7; => 'UserAccountControl:1.2.840.113556.1.4.803:=2', 'group' => 'RTIR_WEB_SC_ACCESS', 'group_scope' => 'sub', 'group_attr' => 'memberOf:1.2.840.113556.1.4.1941:=CN=RTIR_WEB_SC_ACCESS', '

Re: [rt-users] Recover original scripts in RT

2016-07-15 Thread Landon Stewart
On Jul 15, 2016, at 10:41 AM, yugi mailto:uriboxmob...@gmail.com>> wrote: That one i tried already Are the emails that are not being CC'd or BCC'd coming into RT via email or are they being composed and sent from the RT interface? -- Landon Stewart Lead Analyst - Ab

[rt-users] Please help with RT::Authen::ExternalAuth with nested LDAP/AD groups

2016-07-14 Thread Landon Stewart
al/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth.pm:517) [28280] [Thu Jul 14 19:12:14 2016] [debug]: Trying external auth service: My_LDAP (/opt/rt4/local/plugins/RT-Authen-ExternalAuth/lib/RT/Authen/ExternalAuth/LDAP.pm:153) [28280] [Thu Jul 14 19:14:14 2016] [debug]: LDAP Search

Re: [rt-users] RT 4.2.12 and CentOS 7

2015-09-02 Thread Landon Stewart
h when using Request Tracker and mod_fcgid apache does not find any of the modules. Are you running 'make fixdeps' as root privileges? Landon Stewart : lstew...@iweb.com<mailto:lstew...@iweb.com> Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des

Re: [rt-users] ExtractCustomFields for Ticket values

2015-09-01 Thread Landon Stewart
Just an FYI, it might simplify things in the future if you access things as directly as possible. Some prefer to do this, some don't I guess. For Example - instead of: my $ticket = $self->TicketObj; $ticket->SetOwner($value) You might do: $self->TicketObj->SetOwner($value) Or even: $self->Tick

Re: [rt-users] single queue for multiple customers

2015-08-05 Thread Landon Stewart
In my opinion this would best be done with Constituencies but using a plugin for RT called RTIR. https://www.bestpractical.com/docs/rtir/3.2.0/Constituencies.html On Aug 4, 2015, at 11:54 PM, Asanka Gunasekera wrote: > > Hi All, hope some one can give me some insight to below or refer to a UT

Re: [rt-users] Configuring fetchmail to poll emails to respective queues.

2015-06-02 Thread Landon Stewart
e you are enclosing the whole command in double quotes. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-4932 signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [rt-users] Configuring fetchmail to poll emails to respective queues.

2015-06-02 Thread Landon Stewart
is a newly created queue it could be that everyone simply doesn't have permission to create tickets in the new queue. Hard to say without more information. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-4932 signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [rt-users] mail solutions

2015-05-26 Thread Landon Stewart
r logging is done through syslog while running in daemon mode. Note that fetchmail may automatically enable this option depending on upstream server capabilities. Note also that this option may be removed and forced enabled in a future fetchmail version. See also:

Re: [rt-users] Slow ticket search screen draw with RT 4.2.10 and PostgreSQL-9.4

2015-05-20 Thread Landon Stewart
Do you have a ton of users or some other CF with a lot of possible values that are only available (list in drop-down or an autocomplete field) to the RT super user? > On May 20, 2015, at 3:13 PM, "k...@rice.edu" wrote: > > Hi RT community, > > I am testing the performance. When I pull up > >

Re: [rt-users] Is setting up RT to create tickets via Gmail possible?

2015-05-15 Thread Landon Stewart
's generally how it's done. If you want to use an external POP3 account you can use fetchmail or getmail to download the mail and pipe each message to rt-mailgate but all mail to the From address needs to pipe to rt-mailgate somehow so that all replies are fed to RT. Landon Stewar

Re: [rt-users] Cannot Login to RT

2015-04-17 Thread Landon Stewart
d you check in /var/log/* or? Usually the log for RT can be found in /opt/rt4/var/log/rt.log but your installation might be different. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888

Re: [rt-users] User Authentication

2015-04-16 Thread Landon Stewart
g to do. Just an idea that might help... Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-4932 signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [rt-users] User Authentication

2015-04-16 Thread Landon Stewart
rs using the bin/rt utility? Example: /opt/rt4/bin/rt create -t users add Name=userName EmailAddress=em...@address.com Password=password More information can be found here: http://requesttracker.wikia.com/wiki/CLI <http://requesttracker.wikia.com/wiki/CLI> Landon Stewart : lstew...@iweb.co

Re: [rt-users] RT::Extension::Announce post install question

2015-04-08 Thread Landon Stewart
I could be wrong but it looks like it adds a queue called "RTAnnounce" and then a Custom Field for that queue called 'Announcement Groups'. Does this mysql query return an record from the Queues table? SELECT * FROM Queues WHERE Name = 'RTAnnounce'; Landon St

Re: [rt-users] RT::Extension::Announce post install question

2015-04-08 Thread Landon Stewart
e did that or if I still > need to. I see in the docs that running the initdb step more than once can > be a bad thing. How can I tell if initdb has already been run? I would check the Makefile to see what initdb actually does and then check the database to see if it was done. Landon Ste

Re: [rt-users] web request from custom scrip

2015-04-02 Thread Landon Stewart
27;) if $response->is_success; RT::Logger->info("Ticket ".$self->TicketObj->id." ".$response->message); return $status; Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-4932 signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [rt-users] need to run code when user presses a button

2015-03-26 Thread Landon Stewart
t it's supposed to do and then redirect back to the referrer (the display page in RT). Be sure to protect the page on the virtualhost somehow so it's not available to someone who should not see/use it. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécial

Re: [rt-users] Custom Fields

2015-03-24 Thread Landon Stewart
27;t know. I checked mine (4.2.9) and it's not available, only date fields that you are probably already seeing listed as well. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-49

Re: [rt-users] Custom Fields

2015-03-24 Thread Landon Stewart
rt of the query so the queue specific CFs are loaded. Once that is done you click "Chart" on the upper right. You can then use the dropdown for "Show chart grouped by" to select any field including custom fields. In 4.2 however you can graph by multiple custom fields a

[rt-users] Is there a way to include attachments from $Tickets{"TOP"} when using RT::Action::CreateTickets ?

2015-03-24 Thread Landon Stewart
7;s no way I'll have to abandon the use of RT::Action::CreateTickets and write a custom action module more similar to the example code I found. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb

Re: [rt-users] change queue not triggering Scrip

2015-03-20 Thread Landon Stewart
to be recorded in the ticket history that way it would trigger scrips such as the "On Queue Change" one you have that works when using the GUI. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-4932 signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [rt-users] Search Query Builder Issues (Space Encoding?)

2015-03-19 Thread Landon Stewart
sers}' Also to see what you are looking at in plain text you can visit the full URL and then change RTIR/Search/Results.html to /Search/Build.html and then click "Advanced" on the top right. The "Query" box will give you the plain text of the search you are performing

Re: [rt-users] How to email entire ticket history and attach items from tickets

2015-03-13 Thread Landon Stewart
By; # Default sort order $Transactions->GotoFirstItem; Also while searching for the OrderBy function I came across this which might help you even more: http://requesttracker.wikia.com/wiki/AddTicketHistoryToMail Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Manage

Re: [rt-users] How to email entire ticket history and attach items from tickets

2015-03-13 Thread Landon Stewart
ment->GetHeader('Subject') ? "Subject: ".$attachment->GetHeader('Subject')."\n\n" : ""; # Include the content of the attachment $content .= defined $attachment->OriginalContent ? $attachment->OriginalContent : "&quo

Re: [rt-users] TicketSQL to select all tickets with requestor "nobody in particular"

2015-03-13 Thread Landon Stewart
Our "Nobody" user is ID #6 so I'd use that in the TicketSQL query as: "Requestor.id = 6" You can find out what your "Nobody" user's ID is (probably the same as ours): 1) Admin -> Users -> Select 2) Go to user: Nobody 3) click "Go!" Lando

Re: [rt-users] The use of $Ticket{'TOP'}->CustomFieldValues($fieldname) with RT::Action::CreateTickets

2015-03-12 Thread Landon Stewart
On Mar 10, 2015, at 3:28 AM, Christian Loos wrote: > > @Alex: > CreateTickets support both, CustomField and CF keys [1]. > > @Landon: > Why don't you simply add this lines to you template, as you are using a > static customfield list and don't want to add a

Re: [rt-users] The use of $Ticket{'TOP'}->CustomFieldValues($fieldname) with RT::Action::CreateTickets

2015-03-10 Thread Landon Stewart
ed working perfectly. Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-4932 > On Mar 10, 2015, at 12:15 AM, Landon Stewart wrote: > > Hello, > > It seems that one

Re: [rt-users] The use of $Ticket{'TOP'}->CustomFieldValues($fieldname) with RT::Action::CreateTickets

2015-03-10 Thread Landon Stewart
On Mar 10, 2015, at 2:29 AM, Alex Peters wrote: > > You need to output "CustomField-$cfname" as the key, not "CF-$cfname". > > CF-$cfname should work as well but more importantly nothing is being outputted there which is the problem I'm most con

[rt-users] The use of $Ticket{'TOP'}->CustomFieldValues($fieldname) with RT::Action::CreateTickets

2015-03-10 Thread Landon Stewart
ied loading the CF using $Tickets{"TOP"}->LoadCustomFieldByIdentifier($cfname) but this does not work either. Basically I'm waning to copy a list of CFs from $Tickets{'TOP'} to the newly created one. Thank you. Landon Stewart : lstew...@iweb.com Lead Specialist,

Re: [rt-users] Cancel "Resolve" transaction based on custom fields

2015-01-29 Thread Landon Stewart
On Jan 29, 2015, at 3:05 PM, Landon Stewart wrote: > In the action (commit) section of the Scrip: > $self->TicketObj->Status("open"); > $self->TicketObj->Comment( Content => "Script re-opened because > CustomFieldName is > ".$self->TicketO

Re: [rt-users] Cancel "Resolve" transaction based on custom fields

2015-01-29 Thread Landon Stewart
the Scrip: $self->TicketObj->Status("open"); $self->TicketObj->Comment( Content => "Script re-opened because CustomFieldName is ".$self->TicketObj->FirstCustomFieldValue("CustomFieldName") ); Maybe? Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com : +1 (888) 909-4932 signature.asc Description: Message signed with OpenPGP using GPGMail

Re: [rt-users] Scrip for adding to the custom field based on another CF

2015-01-21 Thread Landon Stewart
" . $Num . $Append; Some notes: - The condition here is: $self->TicketObj->FirstCustomFieldValue('RMA Type') eq 'Student Withdrawl' - If the condition is true then $value will equal what's between the ? and the : (colon) - If the condition is false

Re: [rt-users] Warning before sending correspondence

2014-12-20 Thread Landon Stewart
cal solution to a problem with people might not be the answer perhaps modifying the textbox with some default text (ie. "This response will be seen by customers - remove this text.") for correspondence with something they have to actually remove before typing might be a relatively s

Re: [rt-users] Problem with date

2014-11-19 Thread Landon Stewart
converted to UTC first. More info: http://bestpractical.com/docs/rt/latest/RT_Config.html#Date-and-time-handling <http://bestpractical.com/docs/rt/latest/RT_Config.html#Date-and-time-handling> Landon Stewart : lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste princip

Re: [rt-users] how to allow subject line if update is from specific email address

2014-11-13 Thread Landon Stewart
On Nov 13, 2014, at 5:06 AM, Atif Mehboob wrote: > > Hi All, > > We are using RT 4.2.1. How can we allow a specific email address to update > the subject line of ticket in any queue. Any suggestions please? > > Regards, > Atif Hi Atif, We do this using a scrip (in this case it'd be a glob

Re: [rt-users] Sorting by the value of a custom field in search results *numerically*

2014-05-06 Thread Landon Stewart
Thanks for your replies guys. And thanks for adding that feature request Brent (http://issues.bestpractical.com/Ticket/Display.html?id=29638). On 2 May 2014 13:52, Landon Stewart wrote: > Hello, > > It seems that the sorting by custom field in search results is always done > al

[rt-users] Sorting by the value of a custom field in search results *numerically*

2014-05-02 Thread Landon Stewart
Hello, It seems that the sorting by custom field in search results is always done alphabetically. For example sorting by CF that contains only integers in descending order: 4 3 2 11 1 Is there a way to sort search results by custom field numerically? -- Landon Stewart :: lstew...@iweb.com

[rt-users] How can I take a user's dashboard and making it the default for everyone

2014-03-26 Thread Landon Stewart
rious. Thanks for reading and any information you can offer. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932 -- RT Training - Dallas May 20-21 http://bestpractical.com/training

Re: [rt-users] MySQL Question (joins and stuff)

2014-03-04 Thread Landon Stewart
Jason this is brilliant! Thank you! On 4 March 2014 13:57, j.hubbard wrote: > Hi Landon, below is some sql I wrote (I'm not too good at sql so some of it > could probably be optimized). It pulls a bunch of fields both system and > custom as well as the first comment on the ti

[rt-users] MySQL Question (joins and stuff)

2014-03-03 Thread Landon Stewart
achieved I would really really appreciate it. Failing that if anyone knows of any tips to figure this out (like a primer on turning tables on their side) I'd appreciate any advice you can give me. :-D -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Sp

Re: [rt-users] How to grab requestor's first and last name in email address ?

2014-02-05 Thread Landon Stewart
ght sound a little too familiar for business. In my opinion you'd want to just leave it as-is so if it's Last, First and they get an email addressed to them with "Dear Smith, Jim:" they'll know it's because they have it that way in their mail client. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932

Re: [rt-users] RT crashes during spreadsheet export with "...rt-server.fcgi" aborted: idle timeout (3 sec)

2014-02-03 Thread Landon Stewart
en pipe) > [Mon Feb 03 16:55:34 2014] [warn] FastCGI: server > "/opt/rt4/sbin/rt-server.fcgi" restarted (pid 16011) > > Any clues how to overcome this issue? We will need to be exporting into > spreadsheets on a monthly basis, and the amount of tickets in the queue > wil

Re: [rt-users] Relationship Permissions

2014-01-23 Thread Landon Stewart
p a link of any type on Ticket A RT will create a reciprocal link on Ticket B pointing to A as referred to by (in this case). -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932

Re: [rt-users] Postfix error: 500 No Host option provided

2014-01-16 Thread Landon Stewart
re you've done anything at > all." - God; Futurama > > "We'll get along much better once you accept that you're wrong and > neither am I." - Me > > > On Thu, Jan 16, 2014 at 10:37 AM, Landon Stewart wrote: > >> From the server itself what i

Re: [rt-users] Postfix error: 500 No Host option provided

2014-01-16 Thread Landon Stewart
to >> help you. >> >> How are you invoking rt-mailgate, from an aliases file? >> Show the alias file, with all the options you are passing to >> rt-mailgate. >> >> Have you read your apache error log? Since you're getting a 500 >> error, and that's an HTPT status code, I'd look there. >> >> -kevin >> > > -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932

Re: [rt-users] Question

2014-01-15 Thread Landon Stewart
can I download the program rtbouncehandler from? > > > > Bryon Baker > > Network Operations Manager > > *Copesan** - Specialists in Pest Solutions* > > 800-267-3726 • 262-783-6261 ext. 2296 > > bba...@copesan.com > > www.copesan.com > > *"Serv

Re: [rt-users] Using Fetchmail to pipe mail into RT.

2014-01-14 Thread Landon Stewart
On 13 January 2014 16:30, Joshua Riden wrote: > Landon, > > Thank you so much Landon for your help. I appreciate it a lot! : ) > > Now just a few questions.. > > Where is the mailserver log that pertains to fetchmail? > /var/logs/mailserver ? > fetchmail logging has t

Re: [rt-users] Big size of /opt/rt4/var directory

2014-01-06 Thread Landon Stewart
them. Those shouldn’t be there though so I’d probably first advise that you resolve that issue before you start using ‘find’ in a crontab to delete them if they are a certain number of days old or something. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932

[rt-users] Triggering two separate templates

2014-01-03 Thread Landon Stewart
thought of just CCing the other department when that template is used but that’s not really a viable thing to do in this case. The other department needs some data from a template that shouldn’t be sent to the requestor so the emails have to be entirely different. -- Landon Stewart :: lstew

Re: [rt-users] RT sending emails on behalf of

2013-12-20 Thread Landon Stewart
horized to send mail for that domain. Add SPF and DKIM records for the sending domain (from domain). Also… I’d use these headers instead of the Sender header: From: "Some Friendly Name" Subject: {$Ticket->Subject} RT-Attach-Message: yes -- Landon Stewart :: lstew...@iweb.com

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-18 Thread Landon Stewart
On 18 December 2013 10:07, Kevin Falcone wrote: > Can you download and run http://mysqltuner.pl on your database. > Fun tip. You can download that with just “wget mysqltuner.pl”. There’s some redirection magic that makes it work with just that command. -- Landon Stewart :: lstew...@iw

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-17 Thread Landon Stewart
the details of > which I cannot recall exactly. I do remember there were large ACL joins in > the database whenever we would try to load pages with these drop downs just > like you’ve described in your post. > >Hello Landon, > > I removed the rights from Everyone and we had

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-17 Thread Landon Stewart
the details of > which I cannot recall exactly. I do remember there were large ACL joins in > the database whenever we would try to load pages with these drop downs just > like you’ve described in your post. > >Hello Landon, > > I removed the rights from Everyone and we had

Re: [rt-users] any page showing a user drop down in a ticket is loading slow

2013-12-17 Thread Landon Stewart
st like you’ve described in your post. -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932

Re: [rt-users] How to create a new condition through the web gui

2013-12-17 Thread Landon Stewart
o add this soon. Thanks Kevin! -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932

[rt-users] Looking for flattened ticket data - De-normalized RT Views originally by Kenneth Crocker KFCrocker at lbl.gov

2013-12-11 Thread Landon Stewart
required for the RT data a little extreme to figure out in my head. I know it’s a complex thing to do but it would make generating statistics and digging through the data very easy without having to code something in perl from scratch every time a new statistical report is requested. -- Landon

[rt-users] Datetime customfield’s values not being stored in ticket created with RT::Ticket

2013-11-26 Thread Landon Stewart
ups'), 'CustomField-92' => $IncidentObj->FirstCustomFieldValue('ProductPrice'), 'CustomField-104' => $IncidentObj->FirstCustomFieldValue('ServerType'), 'CustomField-105' => $IncidentObj->FirstCustomFieldValue('OperatingSystem'), 'MIMEObj' => $InvMIMEObj, ); Do they have to be converted to RT::Date objects or even as far as AsString to be used as the value? -- Landon Stewart :: lstew...@iweb.com Lead Specialist, Abuse and Security Management Spécialiste principal, gestion des abus et sécurité http://iweb.com :: +1 (888) 909-4932

Re: [rt-users] What’s the correct SQL syntax for a date/time custom field that’s not set?

2013-11-20 Thread Landon Stewart
On 20 November 2013 11:29, Alex Vandiver wrote: > On Wed, 2013-11-20 at 11:13 -0800, Landon Stewart wrote: > > > Is using > "1970-01-01 00:00:00” the only way? > > Currently, yes. > Ok thank you. > > Seems like that definite value might be begging for b

  1   2   >