Re: [rt-users] shredding attachments based on date

2016-12-19 Thread Andy Smith
On 2016-12-19, JON 'BOLI' COPELAND wrote: > you can shred based on sql query, such as > > ./rt-shredder --plugin "Tickets=query,Queue = 'Support' and Status = > 'deleted';limit,5000" --sqldump /root/bup9.sql --force > > ...so you can change the query as you see fit. Hi Jon, thanks for your

[rt-users] shredding attachments based on date

2016-12-19 Thread Andy Smith
Hi all, I'd like to remove attachments older than x months from the database and thought probably rt-shredder is the tool for this (its not something I've used before). Having googled this a bit and checked "rt-shredder --plugin help-Attachments" for instructions it looks like it may not be pos

[rt-users] An internal RT error has occurred on People tab

2016-09-08 Thread Andy Smith
Hi all, our RT system has been suffering from this annoying problem for months where, only sometimes, when you go to the "People" tab of a ticket it displays the error "An internal RT error has occurred". In the system logs I see: Sep 8 09:30:16 rt RT: [22413] Can't call method "head" on an u

Re: [rt-users] change default https to http

2016-07-12 Thread Andy Smith
> Hi Fernando, > > your virtual host in Apache is missing the config required for RT, you need > to follow the instructions here: > > https://docs.bestpractical.com/rt/4.2.12/web_deployment.html > > thanks, Andy.- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training *

Re: [rt-users] change default https to http

2016-07-12 Thread Andy Smith
Hi Fernando, changing between HTTP and HTTPS is configured in your web server. The only thing you can configure in RT is the URL and port RT uses for links in the GUI and that it puts in emails as links, which obviously need to match how you have your web server configured in order for the link

Re: [rt-users] Web GUI allow resolve stalled tickets

2016-07-12 Thread Andy Smith
Hi Jon, great! thanks for the tip! By adding the Lifecyle config to RT_SiteConfig and adding a line: # loc{label} 'stalled -> resolved' => { label => 'Resolve', update => 'Comment' }, I've got the menu item I wanted :) many thanks, Andy.- RT 4.4 and RTIR Training Sessions https://

[rt-users] Web GUI allow resolve stalled tickets

2016-07-11 Thread Andy Smith
Hi, I've been working on a solution whereby a ticket is marked stalled if the last update is from a non-internal email address. By this I can work out if a ticket has been awaiting customer action, and if it has and has not been updated in X days I can auto close that ticket via rt-crontool by

Re: [rt-users] Send Mail Scrip problems

2009-03-17 Thread Andy Smith
Hi Ken, thanks for replying. Actually I seem to have found a way to get it working but without really understanding what I have done :P. Please see my second post with the issue described slightly more clearly (I think). http://lists.bestpractical.com/pipermail/rt-users/2009-March/058001

[rt-users] custom template probs using RT::Group

2009-03-16 Thread Andy Smith
Hi, On RT 3.8.2 I am trying to use the example here: http://wiki.bestpractical.com/view/SendEmailAction When I try and use the section in the template as described in the wiki: To: { my $GroupObj = RT::Group->new($user); $GroupObj->LoadUserDefinedGroup('Group Name'); $GroupObj->MemberEmailAd

[rt-users] Send Mail Scrip problems

2009-03-15 Thread Andy Smith
Hi, I am trying to use the example here: http://wiki.bestpractical.com/view/SendEmailAction to send emails based on custom conditions. I have this working using hard coded destination mail addresses but when I try and use the section in the template as described in the wiki: To: { my $Gr

Re: [rt-users] Rich text in templates?

2009-01-16 Thread Andy Smith
Hi Alex, ok, many thanks for responding. Currently I have 3.8.1 so Ill have to upgrade. Thanks for the examples, cheers Andy. This message was sent using IMP, the Internet Messaging Program. __

[rt-users] Rich text in templates?

2009-01-16 Thread Andy Smith
Hi, In RT 3.8.x is rich text formatting supported for templates? It appears to me not which seems a strange omission, if its not supported is it in the pipeline for future versions? thanks Andy. This message was sent using I

Re: [rt-users] DB upgrade for RT 3.8 fails

2009-01-15 Thread Andy Smith
Hi James, yes, Im not averse to compiling software from source, but actaully having not been using it for very long (I was on various different Unixs before) Ive been very impressed with FreeBSD ports (no probs with Horde/IMP BTW). Much more so than Linux tools such as yum and apt-get w

Re: [rt-users] DB upgrade for RT 3.8 fails

2009-01-15 Thread Andy Smith
Hi James, ok, well thats nice I managed to get to the instructions for 3.8 using a bit of guesswork :P. The only reason Im on 3.8.1 is that it is the current ports version in FreeBSD. If its worth waiting for 3.8.2 I'm happy to wait, Im not in any hurry to upgrade. Thanks for the info,

Re: [rt-users] DB upgrade for RT 3.8 fails

2009-01-15 Thread Andy Smith
Hi All, OK I think I have a solution to my problem which I hope results in a correctly upgrade database. The last piece of the puzzle, is what are the "content" files and what do you need to do with them? Well I guessed that you are meant to do this: rt-setup-database --action insert -

Re: [rt-users] DB upgrade for RT 3.8 fails

2009-01-15 Thread Andy Smith
Hi Alex, thanks a lot for your reply. I had tried more or less to do this before, although I hadn't split the upgrade section in to two steps, doing first until 3.8.0 then the rest. I just tried running this, and I get the same error as before when attempting the first db upgrade (your st

Re: [rt-users] DB upgrade for RT 3.8 fails

2009-01-15 Thread Andy Smith
Hi Racke, that was the subject of my first post to the list to which no one replied, I attempted to follow the infro in README and UPGRADING and UPGRADING.mysql and all i got left with was an error message and a failed upgrade :(. My second mail was in desperation (as stated), I know that

Re: [rt-users] DB upgrade for RT 3.8 fails

2009-01-15 Thread Andy Smith
:S thanks, Andy. Quoting Andy Smith : > Hi, > > I am testing an upgrade on FreeBSD of RT 3.6.7 to RT 3.8.1 and I > am getting an error when attempting to upgrade the MySQL DB. > > I am running the command: > > rt-setup-database --dba=root --action upgrade > > A

[rt-users] DB upgrade for RT 3.8 fails

2009-01-14 Thread Andy Smith
Hi, I am testing an upgrade on FreeBSD of RT 3.6.7 to RT 3.8.1 and I am getting an error when attempting to upgrade the MySQL DB. I am running the command: rt-setup-database --dba=root --action upgrade And after answering the various questions it starts to execute then bombs out with thi

Re: [rt-users] Not understanding initial email config :(

2008-05-29 Thread Andy Smith
Thanks to all those who replied, I think fetchmail is a good alternative if you don't want to have to mess with your MTA config. Leading on from this, what permissions are necessary to set to allow rt-mailgate to create tickets in the queues and how can this be secured (simply without LDAP, spam

Re: [rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
Ok, Ive recieved this advise from some guys on the exim mailing list. I have to update my Exim config to get this to work... http://lists.exim.org/lurker/message/20080528.191851.4e0c63fd.en.html Is this the only way to achieve email integration with RT? Or are their other methods that wouldnt

Re: [rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
hanks Andy. - Original Message - From: "John BORIS" <[EMAIL PROTECTED]> To: ; "Andy Smith" <[EMAIL PROTECTED]> Sent: Wednesday, May 28, 2008 9:02 PM Subject: Re: [rt-users] Not understanding initial email config :( > Andy, > The email address h

Re: [rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
real email even if generated on the command line on the mail server isnt making it to RT... In my exim logs I see unroutable address. Whats the recommended config here to make this work? thanks Andy. - Original Message - From: Andy Smith To: rt-users@lists.bestpractical.com

[rt-users] Not understanding initial email config :(

2008-05-28 Thread Andy Smith
Hi, Im new to RT and am trying to configure a pilot system on FreeBSD, using RT 3.6.6. I want to get incoming mail to go to the general queue (creating a new ticket) but from the documentation Im really not understanding how this is meant to work. I have the RT server up and running on one ser