Another Win32 Email Question

Thanks to Autrijus for making the Windows port extremely easy to install
and configure!
I am having some problems getting RT to accept emails. I have RT
installed on it’s own box running Windows 2000 Server. It will send out
email perfectly. We have an Exchange 2000 server that handles all of
our email using SMTP and MAPI. I seem to be missing something in the
instructions. I’ve searched this list and wiki.bestpractical.com to no
avail. I tried the following 2 configurations for fetchmail with no
real results:
poll mail.domain.com proto MAPI:
username root password mypass mda
"c:/progra~1/ourInternet/common/perl/bin/perl.exe
c:/progra~1/ourinternet/reques~1/rt/bin/rt-mailgate.in --url
http://localhost:8284/ --queue GENERAL --action correspond"
And
poll mail.domain.com proto pop3:
username root password mypass mda
"c:/progra~1/ourInternet/common/perl/bin/perl.exe
c:/progra~1/ourinternet/reques~1/rt/bin/rt-mailgate.in --url
http://localhost:8284/ --queue GENERAL --action correspond"
What steps do I need to take to get RT to work with my Exchange server?

If I need to use fetchmail where does the conf file go?
Which username and password is the conf file looking for? The root for
RT or one that has admin privileges for the Exchange server.

Thanks,
mhb

Michael H. Brown
Network Administrator
Senex Services Corp.
317.613.3000 ext. 217
brownmh@senexco.com
http://www.senexco.com

I am getting closer I believe. I am able to get rt-mailgate to check
the proper email account on our Exchange server and it sees that there
are messages. However I am getting the following error after it checks
the mail:

fetchmail: removing stale lockfile
FETCHM~1: starting fetchmail 6.2.5 daemon
FETCHM~1: sleeping at Thu Sep 16 09:14:54 2004
FETCHM~1: awakened at Thu Sep 16 09:15:54 2004
1 message for rt@domain at mail.domain.com.
reading message rt@domain.com@mail.domain.com:1 of 1 (645 header octets)
(970
body octets) .RT server error.

The RT server which handled your email did not behave as expected. It
said:

%# BEGIN LICENSE BLOCK
%#%# Copyright © 1996-2003 Jesse Vincent jesse@bestpractical.com
%#
%# (Except where explicitly superceded by other copyright notices)
%#
%# This work is made available to you under the terms of Version 2 of
%# the GNU General Public License. A copy of that license should have
%# been provided with this software, but in any event can be snarfed
%# from www.gnu.org.
%#
%# This work is distributed in the hope that it will be useful, but
%# WITHOUT ANY WARRANTY; without even the implied warranty of
%# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
%# General Public License for more details.
%#
%# Unless otherwise specified, all modifications, corrections or
%# extensions to this work which alter its source code become the
%# property of Best Practical Solutions, LLC when submitted for
%# inclusion in the work.
%#
%#
%# END LICENSE BLOCK
<%ARGS>
$message
$queue => 1
$action => “correspond”
$ticket => undef
</%ARGS>
<%init>
use RT::Interface::Email;
my ( $status, $error, $Ticket ) = RT::Interface::email::Gateway(%ARGS);
</%init>
<%flags>
inherit => undef # inhibit UTF8 conversion done in /autohandler
</%flags>
% if ($status == -75 ) {
temporary failure
% }
% elsif ($status == 1) {
ok
% if ( $Ticket->Id ) {
Ticket: <% $Ticket->Id %>
Queue: <% $Ticket->QueueObj->Name %>
Owner: <% $Ticket->OwnerObj->Name %>
Status: <% $Ticket->Status %>
Subject: <% $Ticket->Subject %>
Requestor: <% $Ticket->Requestors->MemberEmailAddressesAsString %>
% }
% } else {
not ok - <%$error%>
% }

FETCHM~1: MDA returned nonzero status 75
not flushed
FETCHM~1: sleeping at Thu Sep 16 09:16:32 2004
FETCHM~1: awakened at Thu Sep 16 09:17:32 2004

This is my conf file:

Please change all upper-case words to desired values,

and save as “rt-mailgate.conf”

poll mail.senexco.com proto imap:
username rt@domain.com password xxx mda
"c:/progra~1/ourInternet/common/perl/bin/perl.exe
c:/progra~1/ourinternet/reques~1/rt/bin/rt-mailgate.in --url
http://localhost:8284/ --queue GENERAL --action correspond"

I searched the archives again and cannot find any information on what to
do with the nonzero status. Most people are getting status 127 anyway.
I’d love to get this working to replace our out dated tracking software.
Thanks in advance for any help.

Thanks,
mhb

Michael H. Brown
Network Administrator
Senex Services Corp.
317.613.3000 ext. 217
brownmh@senexco.com
http://www.senexco.com http://www.senexco.com/

-----Original Message-----
From: rt-users-bounces@lists.bestpractical.com

[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Michael
H. Brown
Sent: Wednesday, September 15, 2004 4:39 PM
To: rt-users@lists.bestpractical.com
Subject: [rt-users] Another Win32 Email Question

Thanks to Autrijus for making the Windows port extremely easy to

install and configure!
I am having some problems getting RT to accept emails. I have
RT installed on it’s own box running Windows 2000 Server. It will send
out email perfectly. We have an Exchange 2000 server that handles all
of our email using SMTP and MAPI. I seem to be missing something in the
instructions. I’ve searched this list and wiki.bestpractical.com to no
avail. I tried the following 2 configurations for fetchmail with no
real results:

poll mail.domain.com proto MAPI: 
username root password mypass mda

“c:/progra~1/ourInternet/common/perl/bin/perl.exe
c:/progra~1/ourinternet/reques~1/rt/bin/rt-mailgate.in --url
http://localhost:8284/ http://localhost:8284/ --queue GENERAL
–action correspond”

And 
poll mail.domain.com proto pop3: 
username root password mypass mda

“c:/progra~1/ourInternet/common/perl/bin/perl.exe
c:/progra~1/ourinternet/reques~1/rt/bin/rt-mailgate.in --url
http://localhost:8284/ http://localhost:8284/ --queue GENERAL
–action correspond”

What steps do I need to take to get RT to work with my Exchange

server?
If I need to use fetchmail where does the conf file go?
Which username and password is the conf file looking for? The
root for RT or one that has admin privileges for the Exchange server.

Thanks, 
     mhb 

Michael H. Brown 
Network Administrator 
Senex Services Corp. 
317.613.3000 ext. 217 
brownmh@senexco.com 
http://www.senexco.com <http://www.senexco.com>  

The Senex Services Corp. email system added the following official information to this message.
NOTICE OF CONFIDENTIALITY
The information in this email, including attachments, may be confidential and/or privileged and may contain confidential health information. This email is intended to be reviewed only by the individual or organization named as addressee. If you have received this email in error please notify Senex Services Corp. immediately - by return message to the sender or to security@senexco.com - and destroy all copies of this message and any attachments. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Senex Services Corp. Confidential health information is protected by state and federal law, including, but not limited to, the Health Insurance Portability and Accountability Act (HIPAA) of 1996 and related regulations.

I am getting closer I believe. I am able to get rt-mailgate to check
the proper email account on our Exchange server and it sees that there
are messages. However I am getting the following error after it checks
the mail:

Hey, the attached webmux.pl.in should fix things; just overwrite the copy
in “C:\Program Files\OurInternet\Request Tracker\rt\bin” with this.

Let me know if this works or breaks; I’ll make sure it works on 3.0.12-win32.

Thanks,
/Autrijus/

webmux.pl.in (3.3 KB)

I’m glad to announce the release of rt-3.0.12-win32 rc1:

http://p4.elixus.org/dist/rt-3.0.12-rc1.exe
SIZE: 2005708 | MD5: 76d6aa483d8f1f55ad092afedce97c78 

Note that the “rc1” refers to the Win32 port, not the base RT
version; this is based on the RT 3.0.12-final release.

In additional to the main changelog for RT 3.0.12, this port
also updated dependencies:

  • Perl 5.8.5-2
    • Based on DBIx::SearchBuilder 1.10’s new cache code
    • Uses native MasonX::Apache2Handler with libapreq2
  • HTTPD 2.0.51
    • More robust log and restart handling
  • MySQL 4.1.4
    • Now installed as a service called “OIN-MySQL”
    • Native Unicode semantics on all RT’s InnoDB tables
  • Fetchmail 6.2.5-2.
    • Updated Cygwin1.dll so it actually works
    • No longer needs to set ownership of rt-mailgate.conf
    • New launch script “rt-mailgate.bat”, suitable for calling
      from other batch scripts. “rt-mailgate.lnk” has been
      modified to simply point to the batch file instead

Special thanks to Michael H. Brown for detailing his setup at
http://wiki.bestpractical.com/?WindowsOSInstallGuide and helping
me to test the mailgate.

Thanks,
/Autrijus/

Just a quick note to say that RC2 have been released:

http://p4.elixus.org/dist/rt-3.0.12-rc2.exe
SIZE: 2006797 | MD5: 32c0ab4786ece947f24b007f42f691cc 

Note that the “rc2” refers to the Win32 port, not the base RT
version; this is based on the RT 3.0.12-final release.

Compared to RC1 following things were changed:

  • Perl 5.8.5-3

    • Includes the latest DBIx::SearchBuilder 1.12_01 on CPAN
    • Recompiled mod_perl2 and libapreq2 against latest httpd source,
      which should result in better performance and memory usage.
  • TabbedUI is made RESTy by always returning a redirect after a POST.

  • Unbreak CustomFieldValue editing interface in TabbedUI.

  • An empty Workflow now no longer create redundant “BEGIN” approval tickets.

  • The RT log at winrt/rt.log is tidied up a bit; if you still find it too
    volumous, try changing the LogLevel in http://localhost:8284/Edit/Global/
    and restart the “Request Tracker” service.

Thanks,
/Autrijus/