Re: [rt-users] Problem wuth creating ticket through mail
I don't try to make fetchmail do all of the work. Some of it I pass on
to procmail, before finally handing it off to RT.
-- Hugh
Here is how I do it:
.fetchmailrc
poll mail.mydomain.com protocol IMAP \
user "r...@mydomain.com" there \
with password "secret" \
is "rt" here \
wants mda "procmail /home/rt/.procmailrc.ymd" \
ssl sslfingerprint "sslfingerprint_here"
.procmailrc
PATH=/usr/local/bin:/usr/bin:/bin
MAILDIR=$HOME/mydomain/Mail
DEFAULT=$MAILDIR/mbox
LOGFILE=$MAILDIR/from
# VERBOSE=yes
# :0
# /home/rt/Mail/mbox
:0 c
backup
:0
* ^To:.*rt-comment
* ^Subject:.*this_queue
|/usr/local/rt/ymd/rt3.8.8/bin/rt-mailgate --queue ThisQueue --action comment
--url http://rt1.mydomain.com
:0
* ^Subject:.*this_queue
|/usr/local/rt/ymd/rt3.8.8/bin/rt-mailgate --queue ThisQueue --action
correspond --url http://rt1.mydomain.com
. . . additional queues configured here . . .
:0
|/usr/local/rt/ymd/rt3.8.8/bin/rt-mailgate --queue General --action comment
--url http://rt1.mydomain.com
:0
/home/rt/mydomain/Mail/mbox
On Mon, 7 Feb 2011 15:28:51 +0530
Rohit Babu wrote:
> Hello,
>
> I have configured rt-3.6.10 on my centos-5.5 machine. I am facing problem
> with creating ticket through mail. i have followed the blow link:
> http://www.mail-archive.com/rt-users@lists.bestpractical.com/msg26966.html
>
> But i cant create a ticket through mail. Please help.
>
> Please find below my fetchmailrc file.
>
> set syslog;
> set daemon 20;
>
> poll pop.gmail.com proto pop3 port 995:
> username r...@mydomain.in password ssl mda "/usr/bin/perl
> /usr/sbin/rt-mailgate --url http://192.168.1.138/rt3/ --queue General
> --action correspond"
>
> Its fetching mails from my mail account. There is no ticket created in my
> RT.
>
>
>
>
> --
> Regards,
> Rohith Babu PS
> System Administrator
> Valyoo Technologies.
> +919990334811
>
--
Hugh Esco
skype: hresco3_ ; 678-921-8186
http://www.CampaignFoundations.com/
Providing Application Hosting,
Telephony and IT Development Services
to Green Candidates, Green Parties and
the non profits working for a just and sustainable future.
if( $insurance->rationing() ) { $people->die(); }
Re: [rt-users] RT::Authen::ExternalAuth
This means that RT::Authen::ExternalAuth can not be found in your
path. You say you installed this from source. Did you install it in
your path (which is listed here)? If not, you need to either move it
(or reinstall it) somewhere in that path, OR add its location to your
path for the user (likely apache, www-data, nobody) which is invoking
it.
-- Hugh
On Thu, 3 Feb 2011 06:01:24 -0800
"Mr.Taske" wrote:
> [error] Can't locate RT/Authen/ExternalAuth.pm in @INC (@INC contains:
> /usr/local/lib/rt3/lib /usr/lib/perl5/vendor_perl/5.10.0
> /usr/local/lib/perl5/site_perl/5.10.0/i386-linux-thread-multi
> /usr/local/lib/perl5/site_perl/5.10.0
> /usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi
> /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.10.0/i386-linux-thread-multi
> /usr/lib/perl5/5.10.0 /usr/lib/perl5/site_perl . /etc/httpd) at
> /usr/lib/perl5/vendor_perl/5.10.0/RT.pm line 627.\nCompilation failed in
> require at (eval 2) line 1.\n
> [error] Can't load Perl file: /usr/sbin/webmux.pl for server example:80,
> exiting...
--
Hugh Esco
skype: hresco3_ ; 678-921-8186
http://www.CampaignFoundations.com/
Providing Application Hosting,
Telephony and IT Development Services
to Green Candidates, Green Parties and
the non profits working for a just and sustainable future.
if( $insurance->rationing() ) { $people->die(); }
Re: [rt-users] Data from external database into custome field
Is that in the tarball? I could not find it in the installation
directory.
-- Hugh
On Thu, 13 Jan 2011 09:33:36 -0500
Kevin Falcone wrote:
> On Thu, Jan 13, 2011 at 04:30:41PM +0800, Lanang Sejagat wrote:
> > Is there any example for populating custom field data from external
> > database ?
>
> Have you read through docs/creating_external_custom_fields.pod ?
>
> -kevin
--
Hugh Esco
skype: hresco3_ ; 678-921-8186
http://www.CampaignFoundations.com/
Providing Application Hosting,
Telephony and IT Development Services
to Green Candidates, Green Parties and
the non profits working for a just and sustainable future.
if( $insurance->rationing() ) { $people->die(); }
Re: [rt-users] "Can you make it act like a time card system?"
I use a cron driven bash script to run this query each night
to monitor the hours for which we're incurring obligations to
our contractors at YMD Partners LLC.
SELECT realname AS name,
round(sum(timetaken)/60.0,2) as hours,
q.name AS queue,
tix.id AS ticket,
tix.status,
tix.subject
FROM transactions tr
LEFT JOIN tickets tix
ON tr.objectid = tix.id
LEFT JOIN users u
ON u.id = tr.creator
LEFT JOIN queues q
ON tix.queue = q.id
WHERE tr.objecttype = 'RT::Ticket'
AND tr.created > '2010-11-01 00:00:00'
AND tr.created < '2010-12-01 00:00:00'
GROUP BY u.id, u.realname, q.name,
tix.queue, tix.id, tix.status,
tix.subject
HAVING sum(timetaken) > 0
ORDER BY u.realname, tix.queue, tix.id ;
This query is run monthly to generate client
specific reports.
SELECT realname AS name,
round(sum(timetaken)/60.0,2) as hours,
q.name AS queue,
tix.id AS ticket,
tix.status,
tix.subject
FROM transactions tr
LEFT JOIN tickets tix
ON tr.objectid = tix.id
LEFT JOIN users u
ON u.id = tr.creator
LEFT JOIN queues q
ON tix.queue = q.id
WHERE tr.objecttype = 'RT::Ticket'
AND tix.queue IN(14,15,21,22)
AND tr.created > '2010-11-01 00:00:00'
AND tr.created < '2010-12-01 00:00:00'
GROUP BY u.id, u.realname, q.name,
tix.queue, tix.id, tix.status,
tix.subject
HAVING sum(timetaken) > 0
ORDER BY q.name, u.realname, tix.queue, tix.id ;
These reports get emailed to me each night.
---
On Mon, 06 Dec 2010 15:09:16 -0800
Gary Greene wrote:
> On 6/12/10 1:49 PM, "RAT" wrote:
> > We are nearly finished with a new RT deployment but the request was made to
> > be
> > able to print out reports for each user for each day showing hours worked
> > and
> > where there are gaps (I know *sigh*). I didn't see any reports or
> > extensions
> > that exactly fit the bill. Does anyone have any ideas?
> >
> > Robert Threet
> > http://yesistilluseperl.blogspot.com/
>
> My best guess would be to use a script that either uses the REST API to get
> the info from the DB, or reads directly from the DB to get the ticket work
> time and then output a pretty HTML report per user, which is linked off a
> roster, or some-such.
>
> --
> Gary L. Greene, Jr.
> IT Operations
> Minerva Networks, Inc.
> Cell: (650) 704-6633
> Office: (408) 240-1239
--
Hugh Esco
skype: hresco3_ ; 678-921-8186
http://www.CampaignFoundations.com/
Providing Application Hosting,
Telephony and IT Development Services
to Green Candidates, Green Parties and
the non profits working for a just and sustainable future.
if( $insurance->rationing() ) { $people->die(); }
Re: [rt-users] RT With FastCGI
I would start by giving a real path to your DocRoot and ScriptAlias lines. Lose the extra space between '/' and 'opt...' Restart apache and test again. -- Hugh Esco http://CampaignFoundations.com/ From: =?ISO-8859-1?Q?jos=E9?= fernandez To: rt-users@lists.bestpractical.com Date: Mon, 21 Dec 2009 16:13:37 +0100 Subject: [rt-users] RT With FastCGI Hello, I want to use FastCGI with RT. So I installed the modules libcgi-fast-perl and libapache2-mod-fastcgi of Apache2 and Apache2 is my configuration: ServerName www.example.com DocumentRoot / opt/rt3/share/html ErrorLog / var/log/apache2/rt/error.log CustomLog / var/log/apache2/rt/access.log combined AddHandler fastcgi-script fcgi ScriptAlias / / opt/rt3/bin/mason_handler.fcgi / Options FollowSymLinks ExecCGI AllowOverride None apache2.conf then I added: # Number of processes is tunable, but you need at least 3 or 4 FastCgiServer / opt/rt3/bin/mason_handler.fcgi-idle-timeout 120-processes 4 I have an error message and can not access RT because I have a 500 error. When I checked my logs this is what I have: FastCGI: comm with server "/ opt/rt3/bin/mason_handler.fcgi" aborted: idle timeout (30 sec) FastCGI: incomplete headers (0 bytes) received from server "/ opt/rt3/bin/mason_handler.fcgi" Have you an idea of the problem? Thank you ___ 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] How to permit user to change their own password ???
I have found references in the documentation for earlier versions to a
'ModifySelf' privilege, which does not seem to be available in the
current version of RT.
I also found this:
http://wiki.bestpractical.com/view/PasswordReminder
which advocates a number of modifications to the stock install.
Is this ability not built into RT yet? For the installation of
immediate concern, I'm running version 3.8.6 downloaded only a week or
two ago.
--
Hugh Esco
http://www.CampaignFoundations.com/
if( $insurance->rationing() ) { $people->die(); }
___
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] Logs say: mason_handler.fcgiindex.html, browser missing css, gives me 404 on initial login
This is my fifth RT install and the second server I've put this
application on. The first four installs were on the same Debian
machine. This one is the first on this centOS box.
I get the login form and logo
(http://rt.ourdomain.com/NoAuth/images/bplogo.gif),
but no css, or any other images. Then after an initial log-in with
root:password, I get only a 404 error.
Anyone recognize those symptoms?
While rendering the login page, it writes to /var/log/httpd/error_log,
thirteen invocations of this error:
script not found or unable to stat:
/usr/local/rt/vp/rt3.8.6/bin/mason_handler.fcgiNoAuth
The 'mason_handler.fcgiNoAuth', with no space before the 'NoAuth' looks
awfully suspicious, but I have no idea where that might be generated.
Then, when I try to log in, I get this error:
script not found or unable to stat:
/usr/local/rt/vp/rt3.8.6/bin/mason_handler.fcgiindex.html
Again, with the no space after the '.fcgi' . . .
I tried adding an extra space at the end of the lines in my vhost
container.
FastCgiServer /usr/local/rt/vp/rt3.8.6/bin/mason_handler.fcgi
-idle-timeout 120
ScriptAlias / /usr/local/rt/vp/rt3.8.6/bin/mason_handler.fcgi
without changing the result.
What is it I might be missing here, please?
CentOS, apache (from yum), mod_fastcgi-2.4.6 (from source).
RT 3.8.6 from source.
--
Hugh Esco
http://www.CampaignFoundations.com/
if( $insurance->rationing() ) { $people->die(); }
___
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
