E-Mail setup Metabase/Sophos

We have a problem with setting up E-Mail.
SNMT proxy is a Sophos SG125 (192.168.1.144)

Metabase is running on a server (192.16.8.112.36) where other apps are using this SNMT proxy as well.
We can exclude firewall issues for this reason.
Configuration is quite simple

SMTP Host 192.168.1.144
SMTP Port 25
SMTP Security None
Sending E-Mail: metabase@transactionsolutions.de

Saving this settings results in
“Sorry, something went wrong. Please try again.”

Log File Metabase:

[3b5809f9-edab-4c15-b73b-fdd283769d78] 2020-03-31T13:16:11+02:00 ERROR metabase.email Fehler beim Test der SMTP Verbindung
[3b5809f9-edab-4c15-b73b-fdd283769d78] 2020-03-31T13:16:16+02:00 ERROR metabase.email Fehler beim Test der SMTP Verbindung
[3b5809f9-edab-4c15-b73b-fdd283769d78] 2020-03-31T13:16:16+02:00 WARN metabase.api.email Problem connecting to mail server: Exception reading response
[3b5809f9-edab-4c15-b73b-fdd283769d78] 2020-03-31T13:16:16+02:00 ERROR metabase.middleware.log PUT /api/email 500 17,5 s (0 DB calls)
{:message “Sorry, something went wrong. Please try again.”}

Log File Sophos:

2020:03:31-13:16:03 sophos-1 exim-in[7452]: 2020-03-31 13:16:03 SMTP connection from [192.168.112.36]:55814 (TCP/IP connection count = 2)
2020:03:31-13:16:07 sophos-1 exim-in[7452]: 2020-03-31 13:16:07 SMTP connection from [192.168.112.36]:55815 (TCP/IP connection count = 3)
2020:03:31-13:16:12 sophos-1 exim-in[7452]: 2020-03-31 13:16:12 SMTP connection from [192.168.112.36]:55819 (TCP/IP connection count = 4)
2020:03:31-13:16:19 sophos-1 exim-in[17297]: 2020-03-31 13:16:19 SMTP connection from [192.168.112.36]:55813 lost
2020:03:31-13:16:19 sophos-1 exim-in[17331]: 2020-03-31 13:16:19 SMTP connection from [192.168.112.36]:55814 lost
2020:03:31-13:16:24 sophos-1 exim-in[17333]: 2020-03-31 13:16:24 SMTP connection from [192.168.112.36]:55815 lost
2020:03:31-13:16:29 sophos-1 exim-in[17334]: 2020-03-31 13:16:29 SMTP protocol synchronization error (input sent without waiting for greeting): rejected connection from H=[192.168.112.36]:55819 input=“XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX \256\265E\322Lt!m\203\347p DqW\364\214\343\003\303"l\235h\026\025\210:E\3370\003@\327\305m\f8\344\336\230(\342\375”

{
“browser-info”: {
“language”: “de”,
“platform”: “Win32”,
“userAgent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:74.0) Gecko/20100101 Firefox/74.0”,
“vendor”: “”
},
“system-info”: {
“java.runtime.name”: “OpenJDK Runtime Environment”,
“java.runtime.version”: “13+33”,
“java.vendor”: “Oracle Corporation”,
“java.vendor.url”: “https://java.oracle.com/”,
“java.version”: “13”,
“java.vm.name”: “OpenJDK 64-Bit Server VM”,
“java.vm.version”: “13+33”,
“os.name”: “Windows Server 2016”,
“os.version”: “10.0”,
“user.language”: “de”,
“user.timezone”: “Europe/Berlin”
},
“metabase-info”: {
“databases”: [
“oracle”
],
“hosting-env”: “unknown”,
“application-database”: “h2”,
“application-database-details”: {
“database”: {
“name”: “H2”,
“version”: “1.4.197 (2018-03-18)”
},
“jdbc-driver”: {
“name”: “H2 JDBC Driver”,
“version”: “1.4.197 (2018-03-18)”
}
},
“run-mode”: “prod”,
“version”: {
“date”: “2020-02-25”,
“tag”: “v0.34.3”,
“branch”: “release-0.34.x”,
“hash”: “1a83edb”
},
“settings”: {
“report-timezone”: null
}
}
}

Any idea ?

Best Regards
Olaf

Hi @Olaf_Fischer
Try if TLS or SSL works. Also, try with Java 11. Try disabling whatever Sophos is trying to do. Otherwise you would have to bypass the SMTP.
And have a look here after:
https://www.metabase.com/docs/latest/operations-guide/migrating-from-h2.html

Thx, we have meanwhile migrated to MariaDB :slight_smile:
Java11 we tried, no difference. TLS SSL we can not use currently.

Thx for now, we will check Options.

Update to 0.35.1 solved the Problem.

1 Like

@Olaf_Fischer There’s no changes to how email (SMTP connections) works, so that’s interesting, but good it’s working.