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 reply, yes I'd seen this but this is using the tickets
plugin so I believe will shred the entire ticket. I want to use the
Attachments plugin, which according to the documentation has no SQL
query support, you appear to only be able to select based on name or
size. Or am I wrong? 

cheers, Andy.

[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
possible to use date, can anyone advise? Otherwise I guess I need to
delete them directly from MySQL, not sure if this will make a mess of RT
though, 

thanks for any help, Andy.

[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 undefined
value at /usr/local/lib/perl5/site_perl/RT/Action/SendEmail.pm line 261.
Stack: [/usr/local/lib/perl5/site_perl/RT/Action/SendEmail.pm:261]
[/usr/local/lib/perl5/site_perl/RT/Action/SendEmail.pm:232]
[/usr/local/share/rt44/html/Ticket/ModifyPeople.html:122]
[/usr/local/share/rt44/html/Ticket/autohandler:66]
[/usr/local/lib/perl5/site_perl/RT/Interface/Web.pm:696]
[/usr/local/lib/perl5/site_perl/RT/Interface/Web.pm:375]
[/usr/local/share/rt44/html/autohandler:53] 

Every time I think I've fixed this by removing/modifying a Scrip a week
or so later it comes back. As of today I've finally realised why I keep
thinking I've fixed it, because without modifying anything in the config
a simple restart of Apache makes the error go away, which seems really
weird :(. 

Which I've investigated a little but I really don't understand the error
and haven't found any similar issues reported. 

Now I'm prepared to imagine this could all be due to something I've done
wrong, ie config, custom Scrip etc. Other than the problem itself my
main concerns are, firstly the error doesn't give me sufficient
information to identify the root cause (maybe to someone more expert in
RT it does!) and secondly by restarting Apache the error goes away
temporarily. 

For now I've scheduled a nightly restart of Apache. If anyone has any
clue as to whats going on or can suggest any further trouble shooting
steps what would be great! 

OS FreeBSD 10.1 

RT 4.4.1 (previously had exactly the same issue with 4.2.12) 

Perl v5.20.3 

Apache 2.4.23 

thanks in advance, Andy.-
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] 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
* Los Angeles - September, 2016


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 links to
work. Ie see WebBaseURL and WebPort here: 

https://docs.bestpractical.com/rt/4.2.12/RT_Config.html 

thanks, Andy.-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016


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://bestpractical.com/training
* Los Angeles - September, 2016


[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 searching for stalled tickets etc. It seems to work quite nicely but
I've just noticed that in the web GUI you cannot directly resolve
stalled tickets which is annoying as it makes resolving tickets a 2 step
process for our support team. Can I customise the web GUI to show
"resolve" on the actions menu for stalled tickets easily? 

Or if anyone has any other take on my original problem and solution all
suggestions welcomed :) 

thanks in advance, Andy. 

PS We're running RT 4.2.12-
RT 4.4 and RTIR Training Sessions https://bestpractical.com/training
* Los Angeles - September, 2016


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.html

If you have any ideas what I have done any why it works with the later  
config it would be great to know!

Thanks Andy.

Quoting Ken Crocker :

> Andy,
>
>
>Did you remember to insert a "blank" line after the "to:" line.  
> When you replace "Subject:", "From:", or "to:" (header replacement  
> line) you MUST insert a blank line between them and the body of your  
> template.
>Hope this helps.
>
> Kenn
> LBNL

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[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->MemberEmailAddressesAsString()}


it doesn't work for me, I see this error in the system messages file:

Mar 16 00:01:52 alpha RT: RT::Users=HASH(0x16b0a97c) was created  
without a CurrentUser. Any RT object which is subclass of RT::Base  
must be created with a RT::CurrentUser or a RT::User object as the  
first argument. (/usr/local/lib/perl5/site_perl/5.8.9/RT/Base.pm:108)
Mar 16 00:01:53 alpha RT: Template parsing error:  
RT::Users=HASH(0x16b0a97c) was created without a CurrentUser at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/SearchBuilder.pm line 81   
RT::SearchBuilder::_Init('RT::Users=HASH(0x16b0a97c)', undef) called  
at /usr/local/lib/perl5/site_perl/5.8.9/RT/Users_Overlay.pm line 80 
 RT::Users::_Init('RT::Users=HASH(0x16b0a97c)', undef) called at  
/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 93  
  DBIx::SearchBuilder::new('RT::Users', undef) called at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 843   
   RT::Group::UserMembersObj('RT::Group=HASH(0x16b327ac)') called at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 878  
RT::Group::MemberEmailAddresses('RT::Group=HASH(0x16b327ac)') called  
at /usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 899
  
RT::Group::MemberEmailAddressesAsString('RT::Group=HASH(0x16b327ac)')  
called at template line 3 eval 'package Text::Template::GEN2;  
; #line 1 template  my $GroupObj = RT::Group->new
Mar 16 00:01:53 alpha kernel: oup->new


It does work if I use this code:

To: { my $GroupObj = RT::Group->new($RT::SystemUser);
$GroupObj->LoadUserDefinedGroup('Group Name');
$GroupObj->MemberEmailAddressesAsString()}

But I don't understand the difference, is using $RT::SystemUser going  
to do anything bad? If this is ok and there is some problem with the  
code as is on the wiki should I update the data on the wiki?

thanks for any help, Andy.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[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 $GroupObj = RT::Group->new($user);
$GroupObj->LoadUserDefinedGroup('Group Name');
$GroupObj->MemberEmailAddressesAsString()}


it doesn't work for me, I see this error in the system messages file:

Mar 16 00:01:52 alpha RT: RT::Users=HASH(0x16b0a97c) was created  
without a CurrentUser. Any RT object which is subclass of RT::Base  
must be created with a RT::CurrentUser or a RT::User object as the  
first argument. (/usr/local/lib/perl5/site_perl/5.8.9/RT/Base.pm:108)
Mar 16 00:01:53 alpha RT: Template parsing error:  
RT::Users=HASH(0x16b0a97c) was created without a CurrentUser at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/SearchBuilder.pm line 81   
RT::SearchBuilder::_Init('RT::Users=HASH(0x16b0a97c)', undef) called  
at /usr/local/lib/perl5/site_perl/5.8.9/RT/Users_Overlay.pm line 80 
 RT::Users::_Init('RT::Users=HASH(0x16b0a97c)', undef) called at  
/usr/local/lib/perl5/site_perl/5.8.9/DBIx/SearchBuilder.pm line 93  
  DBIx::SearchBuilder::new('RT::Users', undef) called at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 843   
   RT::Group::UserMembersObj('RT::Group=HASH(0x16b327ac)') called at  
/usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 878  
RT::Group::MemberEmailAddresses('RT::Group=HASH(0x16b327ac)') called  
at /usr/local/lib/perl5/site_perl/5.8.9/RT/Group_Overlay.pm line 899
  
RT::Group::MemberEmailAddressesAsString('RT::Group=HASH(0x16b327ac)')  
called at template line 3 eval 'package Text::Template::GEN2;  
; #line 1 template  my $GroupObj = RT::Group->new
Mar 16 00:01:53 alpha kernel: oup->new


Can anyone help? What is going wrong? This is on RT 3.8.2,

thanks for any help, Andy.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[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 IMP, the Internet Messaging Program.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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 which I dont really trust (tho that may be cos I dont know  
them sufficiently well). Anyway thats just a by the by in case you or  
anyone else every facies trying FreeBSD and ports package management ;).

TBH Im happy to wait for the ports, more or less as a matter of good  
practice so that its easier to track whats installed on servers,  
manage package dependencies, and also portaudit is a great tool for  
checking your system against known vulnarabilites (might not cover  
100% of issues but handy). Although in the same moment I accept ports  
or other package management systems arent always the best way to  
install software, when you are dealing with a lot of systems and a lot  
of programs the good outweighs the bad (especially with ports ;) ),

cheers Andy.

Quoting jmose...@corp.xanadoo.com:

>
> For what it's worth, although I too use yum/rpm management on my Redhat
> boxes to install/upgrade almost everything, I find that using packages to
> install/upgrade RT problematic.  It's much easier (for me) to upgrade from
> source, especially since you really aren't compiling anything.  This goes
> for Horde/Imp as well (which it appears you are using).
>
> As it is right now, you are only a few steps frm getting RT 3.8.2 going
> from source.  If you've installed the 3.8.1 from BSD ports, you are only
> two updated Perl modules away from using 3.8.2.  If those updated modules
> exist in ports, great.  If not, use Perl/CPAN to upgrade them.
>



This message was sent using IMP, the Internet Messaging Program.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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,

Andy.

Quoting jmose...@corp.xanadoo.com:


>
> Those are exactly the instructions for 3.8.0.  I don't know about 3.8.1.
> In 3.8.2, you can upgrade the database via two steps.  First, upgrading
> using rt-setup-database and inputting the version you want to stop at, then
> completing the steps revolving around schema.mysql-4.0-4.1.pl.
>
> Is there any reason you are not upgrading to 3.8.2?  There are many bug
> fixes in 3.8.2 and many features/shortcuts that existed in 3.6.x but were
> missing in 3.8.0 and 3.8.1.  In my opinion, you don't want to be running
> 3.8.1...
>
> James
>
>






This message was sent using IMP, the Internet Messaging Program.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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 --datafile  
./etc/upgrade/3.8.1/content  --dba root

for each file (in order).

So my end solution would be:

1) install RT 3.8 to new dir
2) going thro each directory in order in etc/upgrade apply the files  
as necessary until 3.8.0. schema files are applied by redirecting into  
a mysql session and contect files are loaded with rt-setup-database  
(as above).
3) run schema.mysql-4.0-4.1.pl and apply the resulting SQL to the database
4) apply the final directories in etc/upgrade as above to take to  
version 3.8.1


Bit more of an effort than a single command, but it seems good to me  
(ignorance is bliss ;) ).

thanks, Andy.


This message was sent using IMP, the Internet Messaging Program.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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 step 2) :(

[Thu Jan 15 13:15:22 2009] [crit]: DBD::mysql::st execute failed:  
Table 'Attachments' already exists at  
/usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.  
(/usr/local/lib/perl5/site_perl/5.8.8/RT.pm:379)
DBD::mysql::st execute failed: Table 'Attachments' already exists at  
/usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.

So im still stumped :(

thanks, Andy.


This message was sent using IMP, the Internet Messaging Program.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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 isnt the  
correct way to do it but the correct way didnt work and no one has  
suggested any fixes to this :(

thanks, Andy.

Quoting racke at linuxia.de:

> The robust way of upgrading is documented in README/UPGRADE files.
> Look for the script which applies etc/upgrade files.
>
> Regards
>   Racke



This message was sent using IMP, the Internet Messaging Program.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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

2009-01-15 Thread Andy Smith
Anybody? :S

Without any other clues, and out of curiosity, and not really  
following exactly what is supposed to be the correct upgrade procedure  
:P I tried the following:

run schema.mysql-4.0-4.1.pl and apply the generate SQL
go to each directory in the source under etc/upgrade and apply any  
schema.mysql files to my DB

After this on the face of it I have a working RT3.8, but I dont really  
know if this is a robust way of upgrading and how likely I am to  
encounter problems later :S For example I complete ignored all the  
"content" files as I dont know what they are for :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
>
> And after answering the various questions it starts to execute then  
> bombs out with this error:
>
> Proceed [y/N]:y
> Processing 3.7.1
> Now inserting data
> Processing 3.7.3
> Now populating database schema.
> [Wed Jan 14 17:09:06 2009] [crit]: DBD::mysql::st execute failed:  
> Table 'Attachments' already exists at  
> /usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.  
> (/usr/local/lib/perl5/site_perl/5.8.8/RT.pm:379)
> DBD::mysql::st execute failed: Table 'Attachments' already exists at  
> /usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.
>
> Can anyone help? I couldn't see any related problems searching via google :S
>
> thanks for any replies!
>
> Andy.
>
> 
> This message was sent using IMP, the Internet Messaging Program.
>




This message was sent using IMP, the Internet Messaging Program.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


[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 this error:

Proceed [y/N]:y
Processing 3.7.1
Now inserting data
Processing 3.7.3
Now populating database schema.
[Wed Jan 14 17:09:06 2009] [crit]: DBD::mysql::st execute failed:  
Table 'Attachments' already exists at  
/usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.  
(/usr/local/lib/perl5/site_perl/5.8.8/RT.pm:379)
DBD::mysql::st execute failed: Table 'Attachments' already exists at  
/usr/local/lib/perl5/site_perl/5.8.8/RT/Handle.pm line 470.

Can anyone help? I couldn't see any related problems searching via google :S

thanks for any replies!

Andy.


This message was sent using IMP, the Internet Messaging Program.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sa...@bestpractical.com


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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, spamassasin etc)? The 
default behaviour is that you get
an error like:

not ok - Ticket creation failed: No permission to create tickets in the 
queue 'Email' at /usr/local/rt3/bin/rt-mailgate
line 111, <> line 1.

Can I set this to only allow connections from localhost? I guess I can do 
this via httpd.conf, is that the best method?


thanks! Andy. 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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
require modifying my Exim configuration?

thanks for any info!

cheers Andy. 

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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

2008-05-28 Thread Andy Smith
Hi John,

  Ok, so I added a mailbox for the user rt-general, but as I suspected now 
when I send mail it just goes into
the mailspool area and sits in the "new" folder waiting for someone to read 
it. I cant understand how the alias
file is meant to be actioned (ie the piped command)

thanks 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 has to be valid for it to get to RT. I am no guru
> when it comes to email but woudn't the emailer try to resolve the email
> address and then look for the MX record for that address in DNS. If you
> sent the email from the command line and your log shows that address as
> unroutable then it can't locate the domain in DNS. I am not sure if you
> added it to a host table if that would get it to work. Your resolv.conf
> would have to be setup to have the lookup order to include looking in
> the host table.
>
>
>
> John J. Boris, Sr.

___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com


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

2008-05-28 Thread Andy Smith
Hi,

  ok I have proven that I can successfully create a ticket remotely from the 
Exim server by cat'ing an email into rt-mailgate like this:

cat 1172082829.H159040P74283.mx.test.net |/usr/local/rt3/bin/rt-mailgate 
--queue General --action correspond --url http://rt3.test.net/

But still 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 
  Sent: Wednesday, May 28, 2008 6:43 PM
  Subject: Not understanding initial email config :(


  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 server, and we have our live Exim 
SMTP running on another. On the RT box I have this in the
  site config PM file:

  Set($MailCommand , 'sendmail');
  Set($SendmailArguments , "-bm -- [EMAIL PROTECTED]");
  Set($SendmailPath, "/usr/local/sbin/exim");


  and on the Exim box I have installed the RT binaries so I have the 
rt-mailgate script and put this into the aliases file:

  rt-general: "|/usr/local/rt3/bin/rt-mailgate --queue general --action 
correspond --url http://rt3.test.net/";


  Is this really all I have to do?? So far it isnt working, but that doesnt 
surprise me much as I dont get how this can work :S
  However this alias syntax is totally new to me and seems quite odd :S 
  I did see one or two things written about adding some special config into the 
exim MTA config file, but I dont really want to
  have to modify my live exim MTA config just cos I want to add a new queue to 
RT.

  Anyone that can help me out of my confusion would be greatly appreciated!

  thanks in advance, Andy.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.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 server, and we have our live Exim 
SMTP running on another. On the RT box I have this in the
site config PM file:

Set($MailCommand , 'sendmail');
Set($SendmailArguments , "-bm -- [EMAIL PROTECTED]");
Set($SendmailPath, "/usr/local/sbin/exim");


and on the Exim box I have installed the RT binaries so I have the rt-mailgate 
script and put this into the aliases file:

rt-general: "|/usr/local/rt3/bin/rt-mailgate --queue general --action 
correspond --url http://rt3.test.net/";


Is this really all I have to do?? So far it isnt working, but that doesnt 
surprise me much as I dont get how this can work :S
However this alias syntax is totally new to me and seems quite odd :S 
I did see one or two things written about adding some special config into the 
exim MTA config file, but I dont really want to
have to modify my live exim MTA config just cos I want to add a new queue to RT.

Anyone that can help me out of my confusion would be greatly appreciated!

thanks in advance, Andy.
___
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com