RHEL 4 with oracle 10g database needs to send messages out only via third-party mail

SteveInTallyFL · 12-22-2009, 03:00 PM

I cannot get my head around this

sendmail 8.13.2 installed along with Oracle RDBMS 10g. Oracle needs to send out e-mails from a "do_not_reply@mydomain.net" address through a third party mailer. I need to configure sendmail to not allow any other servers to pass messages through this server, and to forward the application-generated messages out to the contract mailer. I did a dig on this server of my domain name associated with the mailbox the third-party service set up for me (mydomain.net)and I can see a couple of MX pointers at the service provider's domain (mx1.themailguys.com and mx2.themailguys.com).

The contract mailer provided me with a list of server names/ports:

Quote:

Type - Server Name - Port
POP3 - pop.themailguys.com - 110
IMAP - imap.themailguys.com - 143
SMTP - smtp.themailguys.com - 25, 587, 8025, and 2525
POP3 with SSL - secure.themailguys.com - 995
IMAP with SSL - secure.themailguys.com - 993
SMTP with SSL - secure.themailguys.com - 25, 465, 587, 8025, and 2525

While I think I only need to send out non-secured messages, I am not sure which I should choose (POP3, IMAP, or SMTP).

I read a blog post about using submit.mc to make a submit.fc and linking it as sendmail.cf with daemon=off in the etc/sysconfig/sendmail. I tried to follow it, but it clearly did not work.

Perhaps I should have placed this in NOOB forum. . . .Im not sure I am making a meaningful description of my issue.

I just don't know where/how/what to begin to set up sendmail.mc to do this. I'll gladly take flames if it gets me to a solution.

harry edwards · 12-22-2009, 03:21 PM

POP and IMAP are used for incoming email, you need to use SMTP.

SteveInTallyFL · 12-23-2009, 12:25 PM

Thanks for that important fundamental bit.

Here is the submit.mc compiled (into submit.cf and s-linked to sendmail.cf) I am using:

Quote:

divert(0)dnl
dnl include(`/usr/share/sendmail-cf/m4/cf.m4')
VERSIONID(`client.mc for Red Hat Linux')dnl
define(`confCF_VERSION', `Client')dnl
define(`__OSTYPE__',`')dnl dirty hack to keep proto.m4 from complaining
define(`confTIME_ZONE', `USE_TZ')dnl

MASQUERADE_AS(`mydomain.net')dnl
FEATURE(`allmasquerade')dnl
FEATURE(`masquerade_envelope')dnl
FEATURE(`always_add_domain')dnl
EXPOSED_USER(`root operator')dnl

define(`SMART_HOST',`smtp.themailguys.com')dnl
define(`confMAX_MESSAGE_SIZE',`10000000')dnl

define(`confDONT_INIT_GROUPS', `True')dnl
define(`confDEF_USER_ID',`8:12')dnl
define(`confDONT_PROBE_INTERFACES',`true')dnl
dnl define(`confPID_FILE', `/var/run/sm-client.pid')dnl
dnl define(`confDIRECT_SUBMISSION_MODIFIERS',`C')

define(`confTO_QUEUEWARN_DSN', `')dnl
define(`confTO_QUEUERETURN_DSN', `12h')dnl

dnl FEATURE(`use_ct_file')dnl
dnl
dnl If you use IPv6 only, change [127.0.0.1] to [IPv6:::1]
dnl FEATURE(`msp', `[127.0.0.1]')dnl
FEATURE(`msp', `smtp.themailguys.com')dnl

I then modified /etc/sysconfig/sendmail so daemon=no, queue= , and SMQUEUE=p1h. Then I did a "service sendmail restart" that had to be ctrl-c.

Then I tried to send a test email this way:

Quote:

[root@my-server ~]# /usr/sbin/sendmail my.name@my.address
this is a test of do_not_reply and submit.mc at grid
.

which did not go anywhere. Here is the log:

Quote:

From MAILER-DAEMON@my-server.domain Wed Dec 23 15:51:37 2009
Return-Path: <MAILER-DAEMON@my-server.domain>
Received: from localhost (localhost)
by my-server.domain (8.13.1/8.13.1) id nBNKpbJw032097;
Wed, 23 Dec 2009 15:51:37 -0500
Date: Wed, 23 Dec 2009 15:51:37 -0500
From: Mail Delivery Subsystem <MAILER-DAEMON@my-server.domain>
Message-Id: <200912232051.nBNKpbJw032097@my-server.domain>
To: root@my-server.domain
MIME-Version: 1.0
Content-Type: multipart/report; report-type=delivery-status;
boundary="nBNKpbJw032097.1261601497/my-server.domain"
Subject: Returned mail: see transcript for details
Auto-Submitted: auto-generated (failure)

This is a MIME-encapsulated message

--nBNKpbJw032097.1261601497/my-server.domain

The original message was received at Wed, 23 Dec 2009 15:50:57 -0500
from root@localhost

----- The following addresses had permanent fatal errors -----
my.name@my_address (reason: 553 #5.1.8 Domain of sender address <root@my-server.domain> does not resolve)

----- Transcript of session follows -----
... while talking to viruswall.my-address.:
>>> MAIL From:<root@my-server.domain> SIZE=362
<<< 553 #5.1.8 Domain of sender address <root@my-server.domain> does not resolve
501 5.6.0 Data format error

--nBNKpbJw032097.1261601497/my-server.domain
Content-Type: message/delivery-status

Reporting-MTA: dns; my-server.domain
Arrival-Date: Wed, 23 Dec 2009 15:50:57 -0500

Final-Recipient: RFC822; my.name@my-address
Action: failed
Status: 5.1.3
Diagnostic-Code: SMTP; 553 #5.1.8 Domain of sender address <root@my-server.domain> does not resolve
Last-Attempt-Date: Wed, 23 Dec 2009 15:51:37 -0500

I expected the MTA to point to the SMART_HOST but it did not. My destination did not perceive that the message came from the contract service at all, so it rejected it.

I know I am not configured properly. Can anyone find any obvious (or not so obvious) errors in what I am trying to do here?