Using GMail and pending changes to SMTP authentication (requiring OAuth)

SOLVED

A customer forwarded an email from Google about some pending changes, and is asking me about whether Sage 100 is compatible.

We’re constantly working to improve the security of your organization’s Google accounts. As part of this effort, and in consideration of the current threat landscape, we’ll be turning off access to less secure apps (LSA) — non-Google apps that can access your Google account with only a username and password, without requiring any additional verification steps. Access through only a username and password makes your account more vulnerable to hijacking attempts. Moving forward, only apps that support a more modern and secure access method called OAuth will be able to access your G Suite account.

Access to LSAs will be turned off in two stages:

  1. June 15, 2020 - Users who try to connect to an LSA for the first time will no longer be able to do so. This includes third-party apps that allow password-only access to Google calendars, contacts, and email via protocols such as CalDAV, CardDAV and IMAP. Users who have connected to LSAs prior to this date will be able to continue using them until usage of all LSAs is turned off.
  2. February 15, 2021 - Access to LSAs will be turned off for all G Suite accounts.

References:

https://developers.google.com/identity/protocols/OAuth2

https://developers.google.com/identity/protocols/OAuth2InstalledApp

Of course, Sage 100 only allows me to set server, user, password, and encryption... with no information on the authentication methods.  Can someone confirm if these requirements will cause problems when Google turns off the LSA access (or if Sage 100 can be upgraded to allow this authentication method)?

Parents Reply Children
  • 0 in reply to Johnbhoy

    Just a note, Oauth is only supported in sage 100 versions 2021 and higher. 

    Since you are discussing Gmail, you might want to look at this new Knowledgebase article #115141

    Using OAuth 2.0 with Sage 100

    Resolution

    Note: Sage Customer Support cannot assist setting up OAuth Authentication to connect to various SMTP Mail Servers.

    This information is provided to assist Sage 100 Business Partners or Customers familiar with the SMTP (Mail) Server being used.

    While Sage cannot provide guidance for all SMTP Server configurations, the following is an example, and to be used as guidance, on how to connect Sage 100 to Gmail using OAuth 2.0

    Please consult with your Sage 100 Business Partner or Sage City if you are not familiar with SMTP (Mail) Server setup.

    How to connect Sage 100 to Gmail using OAuth 2.0

    • Open Company Maintenance and select Company Code
    • SMTP (Mail) Server = OAuth
    • Address = smtp.gmail.com
    • Port = 587
    • SMTP Encryption = TLS
    • User ID = User's Gmail email address
    • Client ID = Client ID obtained from Google Cloud Platform
    • Client Secret = Client Secret obtained from Google Cloud Platform
    • Auth End Point = account.google.com.com/.../auth
    • Token End Point = oauth2.googleapis.com/token
    • Scope = https://mail.google.com/
    • Redirect URI = http://localhost
    • Redirect Port = 3017
    • Code Challenge Method = None
    • Select 128-bit Encryption for Password Protected Documents if 128-bit encryption is desired when password-protected documents are e-mailed
  • 0 in reply to DGR

    Thanks DGR

    Is OAuth the technical term for two factor authentication? The client who opened the support ticket with us, letting us know they can no longer send emails through paperless, is using Sage 2018. I doubt that we can workaround this problem without upgrading them to 2021. Would you agree with that?

    John

  • 0 in reply to Johnbhoy

    OAuth is the alternative to 2FA when configuring system generated emails.

    I believe Sage did offer patches to older versions for this, but v2018 is fully unsupported now.  You'll need an upgrade to benefit from this new feature.

    Using a less-secure SMTP relay might be an option, if your IT is willing to set that up.

  • 0 in reply to Kevin M

    This is a client that has just a few users and a one man IT support person. I'll ask our account manager to contact them about an upgrade to 2021/2022 and take it from there.

    Thanks again Kevin.