[rt-users] database authentication (as in RT_SiteConfig.pm) using a kerberos principal

2012-06-23 Thread Natxo Asenjo
hi,

Using postgresql (or oracle possibly) it is possible to use kerberos/gssapi
to log in the database.

If I create a kerberos service principal rt/myserver.domain.tld/MYREALM.TLD
I can login the postgresql database with a keytab for this principal.

How can I tell the request tracker application it has to use this keytab
instead of setting a username/password in clear text in a config file? This
would be a huge security improvement IMO.

With other apps I can use the KRB5CCNAME variable to specify where the
ticket cache file is and use that.

Could something like this be possible?

TIA,
--
Groeten,
natxo


[rt-users] Templates in HTML

2012-06-23 Thread Josh Hopkins
Is there a way to add HTML within the templates?  For example it would been 
nice to have a footer image at the bottom of the autoresponse that has our logo 
in it.  Is this possible?  Thanks


Re: [rt-users] Fetchmail AuthFail

2012-06-23 Thread Borngunners

I have made the changes as suggested with the full email address and I am still 
having error messages:

root@helpdesks:~# tail .f /var/log/fetchmail.log
tail: cannot open `.f' for reading: No such file or directory
== /var/log/fetchmail.log ==
fetchmail: Warning: the connection is insecure, continuing anyways. (Better use 
--sslcertck!)
fetchmail: Authorization failure on helpd...@ticket.co.it
fetchmail: For help, see http://www.fetchmail.info/fetchmail-FAQ.html#R15
fetchmail: Query status=3 (AUTHFAIL)
fetchmail: Warning: the connection is insecure, continuing anyways. (Better use 
--sslcertck!)
fetchmail: Authorization failure on helpd...@ticket.co.it
fetchmail: For help, see http://www.fetchmail.info/fetchmail-FAQ.html#R15
fetchmail: Query status=3 (AUTHFAIL)
fetchmail: restarting fetchmail (/etc/fetchmailrc changed)
fetchmail:/etc/fetchmailrc:6: syntax error at /usr/bin/rt-mailgate --queue 
general --action correspond --url http://localhost/rt;




-Original Message-
From: 20/20 Lab l...@pacbell.net
To: Borngunners borngunn...@aol.com
Cc: rt-users rt-users@lists.bestpractical.com
Sent: Fri, Jun 22, 2012 6:06 pm
Subject: Re: [rt-users] Fetchmail AuthFail


Have you tried your full email address as your user name?  
helpd...@ticket.co.it instead of just helpdesk most servers wont auth 
without the full email address anymore.

-Matt


On 06/22/2012 2:22 PM, Borngunners wrote:

set daemon 60
set invisible
set no bouncemail
set no syslog
set logfile /var/log/fetchmail.log
poll mailserver.ticket.co.it protocol pop3 username helpdesk password 
 mda /usr/bin/rt-mailgate --queue general --action correspond --$











-Original Message-
From: 20/20 Lab l...@pacbell.net
To: rt-users rt-users@lists.bestpractical.com
Sent: Fri, Jun 22, 2012 4:21 pm
Subject: Re: [rt-users] Fetchmail AuthFail


On 06/22/2012 8:49 AM, Borngunners wrote:

fetchmail: Query status=3 (AUTHFAIL)
fetchmail: Warning: the connection is insecure, continuing anyways. (Better use 
--sslcertck!)
fetchmail: Authorization failure on helpd...@ticket.co.it
fetchmail: For help, see http://www.fetchmail.info/fetchmail-FAQ.html#R15


Please help

any chance of posting your fetchmailrc ?  Most common problem with this error 
is the lack of single quotes (') around the email address and password.

-Matt








Re: [rt-users] Templates in HTML

2012-06-23 Thread Josh Hopkins
So I found where you can add Content-Type: html/text to the top of a template 
and you will get a nice html output.  The only problem that I have found is 
that it places 'Content-Type: html/text' at the top of the email body.   Any 
way of hiding from being displayed?


From: rt-users-boun...@lists.bestpractical.com 
[mailto:rt-users-boun...@lists.bestpractical.com] On Behalf Of Josh Hopkins
Sent: Saturday, June 23, 2012 1:19 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Templates in HTML

Is there a way to add HTML within the templates?  For example it would been 
nice to have a footer image at the bottom of the autoresponse that has our logo 
in it.  Is this possible?  Thanks