I'm trying to figure out how to make Oracle Reports server work with a TLS-enabled SMTP server, if possible at all. It's been hours and I've been reading everything and its contrary. Here is my config in rwserver.conf:
<pluginParam name="mailServer" value="smtpserver.domain.fr">
<property name="enableSSL" value="yes"/>
<property name="port" value="465"/>
<!--UserName and Password that can be used to connect to the mail server-->
<!--property name="mailUserName" value="%MAIL_USERID%" /-->
<!--property name="mailPassword" value="%MAIL_PASSWORD%"/-->
</pluginParam>
I've tried with both ports 465 and 587 which are both enabled on the SMTP server, but I always get the same error in rwserver_diagnostic.log:
REP-50152 : An error occurred while sending mail: 530 5.7.0 Must issue a STARTTLS command first
I am not aware of any other properties that I may specify for the mailServer plugin. Even the 'port' one I am not sure if it really exists. Plus Oracle documentation on this part is very vague.
So : does Oracle Reports Server 12c even support TLS for sending mails? If no, then what is the use of the 'enableSSL' property ? does it support SSL only and not TLS ? but from what I understand, SSL doesn't really exist anymore and it would be hard to set up a SSL > TLS relay.
Environment details:
- OS: RHEL 8.10
- WebLogic version: 12.2.1.4
- SMTP server: currently just a Postfix relay, but production target is world-wide SMTP servers like Gmail etc.
Could you please help me identify the truth? Does Oracle Reports Server 12c even support TLS for sending emails? If yes, how do I set it up properly? Thank you!