Changes to email settings in general.properties seem to be ignored

[Martin Schröder]

Dear Ofbiz Mailing List Members,

while trying to setup the email configuration for my ofbiz installation
(following
https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-EmailServerSettings)

it seems that that the changes I do in
framework/common/config/general.properties are completely ignored by
Ofbiz on startup.

Even though I have enabled the email notifications I get a strange error
message in the console output when trying to send email, e.g. when
resetting a users password through the ecommere app I get

2019-03-25 20:05:02,474 |http-nio-8443-exec-8
|EmailServices                 |I| Mail notifications disabled in
general.properties; mail with subject [OFBiz Demo - Password Reminder
([hidden email])] not sent to addressee [[hidden email]]

Please find below the line my email settinngs from the
general.properties file;

After grepping around for a while in the file system I found the file :
file:/...framework/common/data/CommonSystemPropertyData.xml.

Then after putting in all the email settings here too and loading the
file through the xml data loader and after trying to send passwort reset
emails, I got at least an error message that the mail could not be sent
due to an authentication problem.


Could someone tell me what I am missing here? Where is the right place
to configure the email settings ?

Thanks for your answer in advance.


Kind regards

Martin


____________________________________________________________snip________________________

# -- mail notifications enabled (Y|N)
mail.notifications.enabled=Y

# -- redirect all mail notifications to this address for testing
#mail.notifications.redirectTo=

# -- the default mail server to use
mail.smtp.relay.host=smtp.googlemail.com

# -- SMTP Auth settings
mail.smtp.auth.user=<[hidden email]>
mail.smtp.auth.password=<passwd>

# -- Additional Required Fields needed for Gmail and other non
traditional smtp servers
# -- These added fields also work for Yahoo business mail for instance
# -- Gmail smtp port can be either 465 or 587
mail.smtp.port=465
# -- Gmail requires StartTLS
mail.smtp.starttls.enable=true

# -- Gmail requires a JSSE socket factory, the following socketFactory
settings will override JavaMail's default socketFactory settings
# -- Port needs to be the same as mail.smtp.port
mail.smtp.socketFactory.port=465
mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
#--Fallback [true|false] determines whether you will allow a non secure
connection if you are unable to get a secure one
#mail.smtp.socketFactory.fallback=false

# -- how the address are matched with the CRM addresses
mail.address.caseInsensitive=N

# -- debug SMTP mail option enabled (Y|N)

mail.debug.on=Y


____________________________________________________________snap________________________

[Gil Portenseigne]

Hello Martin,

I think you got the good track for your issue.
Like you did, mailing configuration is done in general.property
configuration file.

But for multi-tenancy and others purpose OFBiz is embedded with
SystemProperty configuration in database that can overload file system
configuration.

There were some discussion [1] about this "feature" in the past that could
lead to the issue you met.

What I'd suggest to you is, if you have not loaded on purpose the
SystemProperties configuration within the db, to delete the concerned
data and work with the config file (like in the documentation)

I hope that will help

Regards,

Gil

[1] https://s.apache.org/hW2D

Le 20:55 - lundi 25 mars, Martin Schröder a écrit :

> Dear Ofbiz Mailing List Members,
>
> while trying to setup the email configuration for my ofbiz installation
> (following
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-EmailServerSettings)
>
> it seems that that the changes I do in
> framework/common/config/general.properties are completely ignored by
> Ofbiz on startup.
>
> Even though I have enabled the email notifications I get a strange error
> message in the console output when trying to send email, e.g. when
> resetting a users password through the ecommere app I get
>
> 2019-03-25 20:05:02,474 |http-nio-8443-exec-8
> |EmailServices                 |I| Mail notifications disabled in
> general.properties; mail with subject [OFBiz Demo - Password Reminder
> ([hidden email])] not sent to addressee [[hidden email]]
>
> Please find below the line my email settinngs from the
> general.properties file;
>
> After grepping around for a while in the file system I found the file :
> file:/...framework/common/data/CommonSystemPropertyData.xml.
>
> Then after putting in all the email settings here too and loading the
> file through the xml data loader and after trying to send passwort reset
> emails, I got at least an error message that the mail could not be sent
> due to an authentication problem.
>
>
> Could someone tell me what I am missing here? Where is the right place
> to configure the email settings ?
>
> Thanks for your answer in advance.
>
>
> Kind regards
>
> Martin
>
>
> ____________________________________________________________snip________________________
>
> # -- mail notifications enabled (Y|N)
> mail.notifications.enabled=Y
>
> # -- redirect all mail notifications to this address for testing
> #mail.notifications.redirectTo=
>
> # -- the default mail server to use
> mail.smtp.relay.host=smtp.googlemail.com
>
> # -- SMTP Auth settings
> mail.smtp.auth.user=<[hidden email]>
> mail.smtp.auth.password=<passwd>
>
> # -- Additional Required Fields needed for Gmail and other non
> traditional smtp servers
> # -- These added fields also work for Yahoo business mail for instance
> # -- Gmail smtp port can be either 465 or 587
> mail.smtp.port=465
> # -- Gmail requires StartTLS
> mail.smtp.starttls.enable=true
>
> # -- Gmail requires a JSSE socket factory, the following socketFactory
> settings will override JavaMail's default socketFactory settings
> # -- Port needs to be the same as mail.smtp.port
> mail.smtp.socketFactory.port=465
> mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
> #--Fallback [true|false] determines whether you will allow a non secure
> connection if you are unable to get a secure one
> #mail.smtp.socketFactory.fallback=false
>
> # -- how the address are matched with the CRM addresses
> mail.address.caseInsensitive=N
>
> # -- debug SMTP mail option enabled (Y|N)
>
> mail.debug.on=Y
>
>
> ____________________________________________________________snap________________________
>
>

[Pierre Smits-3]

Hi Martin,

The latest statement in your posting gives a clue as to where to look for
fixing your issue:

After grepping around for a while in the file system I found the file :
file:/...framework/common/data/CommonSystemPropertyData.xml.

Then after putting in all the email settings here too and loading the
file through the xml data loader and after trying to send passwort reset
emails, I got at least an error message that the mail could not be sent
due to an authentication problem.


This may be indicating that:

   1. the authentication credentials for your MTA are incorrect
   2. the 'ofbiz' user that is used to send the emails has incorrect
   authentication credentials

Your log file could provide more insights.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Mon, Mar 25, 2019 at 8:55 PM Martin Schröder <
[hidden email]> wrote:

> Dear Ofbiz Mailing List Members,
>
> while trying to setup the email configuration for my ofbiz installation
> (following
>
> https://cwiki.apache.org/confluence/display/OFBIZ/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-EmailServerSettings
> )
>
> it seems that that the changes I do in
> framework/common/config/general.properties are completely ignored by
> Ofbiz on startup.
>
> Even though I have enabled the email notifications I get a strange error
> message in the console output when trying to send email, e.g. when
> resetting a users password through the ecommere app I get
>
> 2019-03-25 20:05:02,474 |http-nio-8443-exec-8
> |EmailServices                 |I| Mail notifications disabled in
> general.properties; mail with subject [OFBiz Demo - Password Reminder
> ([hidden email])] not sent to addressee [[hidden email]]
>
> Please find below the line my email settinngs from the
> general.properties file;
>
> After grepping around for a while in the file system I found the file :
> file:/...framework/common/data/CommonSystemPropertyData.xml.
>
> Then after putting in all the email settings here too and loading the
> file through the xml data loader and after trying to send passwort reset
> emails, I got at least an error message that the mail could not be sent
> due to an authentication problem.
>
>
> Could someone tell me what I am missing here? Where is the right place
> to configure the email settings ?
>
> Thanks for your answer in advance.
>
>
> Kind regards
>
> Martin
>
>
>
> ____________________________________________________________snip________________________
>
> # -- mail notifications enabled (Y|N)
> mail.notifications.enabled=Y
>
> # -- redirect all mail notifications to this address for testing
> #mail.notifications.redirectTo=
>
> # -- the default mail server to use
> mail.smtp.relay.host=smtp.googlemail.com
>
> # -- SMTP Auth settings
> mail.smtp.auth.user=<[hidden email]>
> mail.smtp.auth.password=<passwd>
>
> # -- Additional Required Fields needed for Gmail and other non
> traditional smtp servers
> # -- These added fields also work for Yahoo business mail for instance
> # -- Gmail smtp port can be either 465 or 587
> mail.smtp.port=465
> # -- Gmail requires StartTLS
> mail.smtp.starttls.enable=true
>
> # -- Gmail requires a JSSE socket factory, the following socketFactory
> settings will override JavaMail's default socketFactory settings
> # -- Port needs to be the same as mail.smtp.port
> mail.smtp.socketFactory.port=465
> mail.smtp.socketFactory.class=javax.net.ssl.SSLSocketFactory
> #--Fallback [true|false] determines whether you will allow a non secure
> connection if you are unable to get a secure one
> #mail.smtp.socketFactory.fallback=false
>
> # -- how the address are matched with the CRM addresses
> mail.address.caseInsensitive=N
>
> # -- debug SMTP mail option enabled (Y|N)
>
> mail.debug.on=Y
>
>
>
> ____________________________________________________________snap________________________
>
>
>