Email Configuration Error

apurba · March 27, 2023, 12:31pm

Hi,
is there any idea , how i can fixed it

Thanks

pcr · March 27, 2023, 1:10pm

Hi apurba
Did you configure the SMTP in ̶m̶a̶n̶a̶g̶e̶r̶_̶c̶o̶n̶f̶i̶g̶.̶j̶s̶o̶n̶ docker-compose.yml?
Please show the configuration (without sensitive data ofc)

p.s. I noticed you use Google Workspace, i think you need to use an app-specific password if you haven’t already

apurba · March 27, 2023, 1:35pm

Hi pcr,
i am using google app password .

what to do in manager.config

pcr · March 27, 2023, 1:56pm

Sorry in yml not manager_config.json

This is my configuration, you are missing some ports/protocols

    environment:
      OR_SETUP_TYPE:
      OR_ADMIN_PASSWORD:
      OR_SETUP_RUN_ON_RESTART:
      OR_EMAIL_HOST: ${OR_EMAIL_HOST:-my.smtp.com}
      OR_EMAIL_USER: ${OR_EMAIL_USER:-my@username.com}
      OR_EMAIL_PASSWORD: ${OR_EMAIL_PASSWORD:-mypassword}
      OR_EMAIL_PORT: ${OR_EMAIL_PORT:-587}
      OR_EMAIL_TLS: ${OR_EMAIL_TLS:-STARTTLS}
      OR_EMAIL_X_HEADERS:
      OR_EMAIL_FROM: ${OR_EMAIL_FROM:-my@username.com}
      OR_EMAIL_ADMIN: ${OR_EMAIL_ADMIN:-my@username.com}

apurba · March 27, 2023, 2:21pm

Hi,
now getting this issue

pcr · March 27, 2023, 2:26pm

Did you just change mail configuration or did anything else in the meantime? If you revert the changes it gives the same error?

apurba · March 27, 2023, 3:04pm

Hi pcr ,
i am getting error like below

any idea @Don @martin.peeters

pcr · March 27, 2023, 3:24pm

Did you put both of this?

      OR_EMAIL_PORT: ${OR_EMAIL_PORT:-587}
      OR_EMAIL_TLS: ${OR_EMAIL_TLS:-STARTTLS}

apurba · March 27, 2023, 3:35pm

yes

Screenshot_20230327_210348

apurba · March 27, 2023, 4:35pm

Hi PCR,
any solution regarding this ,

without port no and Tls , i configured it before and also get email notification .but after changes in yml regarding storage issue ,its not working

pcr · March 28, 2023, 10:09am

I didn’t actually update to the latest version, so it’s better if we wait for a comment by someone from the team

apurba · March 28, 2023, 1:41pm

Hi,
Thanks for your support , i tried many options and deploy in new machine also (old yml file)
, Getting same error .

Actually need to show in presentation this feature.

If you guess anything pls share

Thanks

pcr · March 28, 2023, 2:22pm

Tried few more things:
-apparently i’m able to make it work only with another smtp, with Google it’s not working. Tried a few combinations with/without STARTTLS or SSL but nothing happens. Other SMTP with exact same configuration works

deputy-chief-hardy · March 28, 2023, 3:31pm

Hi @pcr,
unfortunately I do not get it to work either. Which SMTP did you use? Can you maybe give me some example values to fill in my docker-compose.yml, which you see in the following?

  manager:
#    privileged: true
    restart: always
    image: openremote/manager:${MANAGER_VERSION:-latest}
    depends_on:
      keycloak:
        condition: service_healthy
    environment:
      OR_SETUP_TYPE:
      OR_ADMIN_PASSWORD:
      OR_SETUP_RUN_ON_RESTART:
      OR_EMAIL_HOST:
      OR_EMAIL_USER:
      OR_EMAIL_PASSWORD:
      OR_EMAIL_X_HEADERS:
      OR_EMAIL_FROM:
      OR_EMAIL_ADMIN:
      OR_HOSTNAME: ${OR_HOSTNAME:-localhost}
      OR_ADDITIONAL_HOSTNAMES: ${OR_ADDITIONAL_HOSTNAMES:-}
      OR_SSL_PORT: ${OR_SSL_PORT:-}
      OR_DEV_MODE: ${OR_DEV_MODE:-false}
      OR_DB_HOST: ${DATABASE_URL}
      OR_DB_PORT: ${DATABASE_PORT}
      OR_DB_USER: ${DATABASE_USERNAME}
      OR_DB_PASSWORD: ${DATABASE_PASSWORD}

pcr · March 28, 2023, 3:46pm

I made it work with this
The smtp is provided by a local national hosting site
If I try with my Google Workspace account, same configuration, it doesn’t work

pcr:

    environment:
      OR_SETUP_TYPE:
      OR_ADMIN_PASSWORD:
      OR_SETUP_RUN_ON_RESTART:
      OR_EMAIL_HOST: ${OR_EMAIL_HOST:-my.smtp.com}
      OR_EMAIL_USER: ${OR_EMAIL_USER:-my@username.com}
      OR_EMAIL_PASSWORD: ${OR_EMAIL_PASSWORD:-mypassword}
      OR_EMAIL_PORT: ${OR_EMAIL_PORT:-587}
      OR_EMAIL_TLS: ${OR_EMAIL_TLS:-STARTTLS}
      OR_EMAIL_X_HEADERS:
      OR_EMAIL_FROM: ${OR_EMAIL_FROM:-my@username.com}
      OR_EMAIL_ADMIN: ${OR_EMAIL_ADMIN:-my@username.com}

One thing I noticed, but not sure if it’s useful, is that I get the “must issue STARTTLS command” if I write the variables like this
OR_EMAIL_USER: my@email.com
Instead if I write it as
OR_EMAIL_USER: ${OR_EMAIL_USER:-my@email.com}
I get the error
Error processing from REALM_RULESET - NOTIFICATION_HANDLER_CONFIG_ERROR (Handler is not valid: email): Notification{name=‘null’, message=org.openremote.model.notification.EmailNotificationMessage@1e26a3b7, repeatFrequency=null, repeatInterval=‘null’, targets=[Target{type=USER, id=xxxx}]}
I’m wondering if he’s getting some values from somewhere else that bugs it? From what I understood the parenthesis should mean "use the variable, otherwise by default value is the one following :- "

apurba · March 28, 2023, 4:03pm

yeah same thing is happening with me

hi @Don any missing configuration here

deputy-chief-hardy · March 28, 2023, 4:17pm

Thanks for your answer, but unfortunately it still does not work.

I used:

  manager:
#    privileged: true
    restart: always
    image: openremote/manager:${MANAGER_VERSION:-latest}
    depends_on:
      keycloak:
        condition: service_healthy
    environment:
      OR_SETUP_TYPE:
      OR_ADMIN_PASSWORD:
      OR_SETUP_RUN_ON_RESTART:
      OR_EMAIL_HOST: smtp.web.de
      OR_EMAIL_USER: leoxxx@web.de
      OR_EMAIL_PASSWORD: xxx
      OR_EMAIL_PORT: ${OR_EMAIL_PORT:-587}
      OR_EMAIL_TLS: ${OR_EMAIL_TLS:-STARTTLS}
      OR_EMAIL_X_HEADERS:
      OR_EMAIL_FROM: leoxxx@web.de
      OR_EMAIL_ADMIN:
      OR_HOSTNAME: ${OR_HOSTNAME:-xxx.de}
      OR_ADDITIONAL_HOSTNAMES: ${OR_ADDITIONAL_HOSTNAMES:-}
      OR_SSL_PORT: ${OR_SSL_PORT:-}
      OR_DEV_MODE: ${OR_DEV_MODE:-false}
      OR_DB_HOST: ${DATABASE_URL}
      OR_DB_PORT: ${DATABASE_PORT}
      OR_DB_USER: ${DATABASE_USERNAME}
      OR_DB_PASSWORD: ${DATABASE_PASSWORD}

and get the following error:

Error processing from REALM_RULESET - NOTIFICATION_HANDLER_CONFIG_ERROR (Handler is not valid: email): Notification{name='null', message=org.openremote.model.notification.EmailNotificationMessage@606ab39a, repeatFrequency=null, repeatInterval='null', targets=[Target{type=USER, id=91d45952-e957-44e0-89b0-d72b3ec71abb}]}

Did I do something wrong?

pcr · March 30, 2023, 1:11pm

@Don any idea about this? Have you ever configured an SMTP on Google?

Don · March 30, 2023, 1:45pm

I’ve done something with gmail in a different application and I needed a specific key. Something like this I guess: Sign in with App Passwords - Google Account Help

Edit: Oh, you posted that already. That didn’t work?

pcr · March 30, 2023, 2:30pm

Yep, it didn’t work
It was the first thing I thought since Google expect those passwords for anything that doesn’t use OAuth2
I suspect there is something wrong with the combination of ports/protocols, but 587 STARTTLS is the standard for Gmail. Maybe someone else in the staff has an instance with gmail or can give it a try?