How to verify SMTP server from E-business suite application server.
SOLUTION
It is very important to perform all the steps mentioned below; they will allow to perform the telnet SMTP test from the right node and to pass the correct values during the test.
1) Identify the concurrent tiers node where mailer runs
by running script below:
select target_node
from fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';
It will return for example:
TARGET_NODE
------------------------------
ebiz1
In this example ebiz1 is the node where java mailer runs.
2) Gather other parameters values necessary for the SMTP telnet test:
To perform the SMTP telnet test, in addition to mailer node, you will also need to know on which node is the SMTP server (this is mailer "outbound server" parameter), and what is the reply to address that is set up for the java mailer (this is mailer "reply to" parameter).
To get these values run the following:
SELECT b.component_name,
c.parameter_name,
a.parameter_value
FROM fnd_svc_comp_param_vals a,
fnd_svc_components b,
fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
AND b.component_type = c.component_type
AND c.parameter_id = a.parameter_id
AND c.encrypted_flag = 'N'
AND b.component_name like '%Mailer%'
AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')
ORDER BY c.parameter_name;
It will return for example:
COMPONENT_NAME PARAMETER_NAME PARAMETER_VALUE
------------------------------- ------------------------------ -----------------------
Workflow Notification Mailer OUTBOUND_SERVER mitini1
Workflow Notification Mailer REPLYTO jmailer1@dummy_domain.com
In this example the outbound server is on mitini1 node and the reply to address is set to jmailer1@dummy_domain.com.
3) Perform the SMTP telnet test as follows:
3.1) Log on to the node where mailer runs (to identify it, please refer to step 1)
This is mandatory. SMTP telnet test is only meaningful when it is performed from the concurrent tier where mailer runs.
In our example you should log to ebiz1 node.
3.2) From mailer node, issue the following commands one by one:
telnet [outbound server] 25
EHLO [mailer node]
MAIL FROM: [reply_to address]
RCPT TO: [my_test_email_address]
DATA
Subject: Test message
Test message body
.
quit
SOLUTION
It is very important to perform all the steps mentioned below; they will allow to perform the telnet SMTP test from the right node and to pass the correct values during the test.
1) Identify the concurrent tiers node where mailer runs
by running script below:
select target_node
from fnd_concurrent_queues where concurrent_queue_name like 'WFMLRSVC%';
It will return for example:
TARGET_NODE
------------------------------
ebiz1
In this example ebiz1 is the node where java mailer runs.
2) Gather other parameters values necessary for the SMTP telnet test:
To perform the SMTP telnet test, in addition to mailer node, you will also need to know on which node is the SMTP server (this is mailer "outbound server" parameter), and what is the reply to address that is set up for the java mailer (this is mailer "reply to" parameter).
To get these values run the following:
SELECT b.component_name,
c.parameter_name,
a.parameter_value
FROM fnd_svc_comp_param_vals a,
fnd_svc_components b,
fnd_svc_comp_params_b c
WHERE b.component_id = a.component_id
AND b.component_type = c.component_type
AND c.parameter_id = a.parameter_id
AND c.encrypted_flag = 'N'
AND b.component_name like '%Mailer%'
AND c.parameter_name in ('OUTBOUND_SERVER', 'REPLYTO')
ORDER BY c.parameter_name;
It will return for example:
COMPONENT_NAME PARAMETER_NAME PARAMETER_VALUE
------------------------------- ------------------------------ -----------------------
Workflow Notification Mailer OUTBOUND_SERVER mitini1
Workflow Notification Mailer REPLYTO jmailer1@dummy_domain.com
In this example the outbound server is on mitini1 node and the reply to address is set to jmailer1@dummy_domain.com.
3) Perform the SMTP telnet test as follows:
3.1) Log on to the node where mailer runs (to identify it, please refer to step 1)
This is mandatory. SMTP telnet test is only meaningful when it is performed from the concurrent tier where mailer runs.
In our example you should log to ebiz1 node.
3.2) From mailer node, issue the following commands one by one:
telnet [outbound server] 25
EHLO [mailer node]
MAIL FROM: [reply_to address]
RCPT TO: [my_test_email_address]
DATA
Subject: Test message
Test message body
.
quit
No comments:
Post a Comment
Note: only a member of this blog may post a comment.