Good afternoon guys!
I am trying to configurate google's email in the metabase application, but I am getting "Sorry, something went wrong. Please try again." everytime. I was able to send successfully using PHP as you can see the configurations below:
But when I tried to put the same configurations on Metabase I got this error:
The log:
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:18:57-03:00 ERROR metabase.email Erro ao testar a conexão SMTP
javax.mail.MessagingException: Could not connect to SMTP host: smtp.gmail.com, port: 587;
nested exception is:
java.net.SocketTimeoutException: Read timed out
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2102)
at com.sun.mail.smtp.SMTPTransport.protocolConnect(SMTPTransport.java:699)
at javax.mail.Service.connect(Service.java:366)
at metabase.email$run_smtp_test$fn__50698.invoke(email.clj:145)
at metabase.email$run_smtp_test.invokeStatic(email.clj:144)
at metabase.email$run_smtp_test.invoke(email.clj:128)
at metabase.email$guess_smtp_security.invokeStatic(email.clj:162)
at metabase.email$guess_smtp_security.invoke(email.clj:155)
at metabase.email$test_smtp_connection.invokeStatic(email.clj:183)
at metabase.email$test_smtp_connection.invoke(email.clj:169)
at metabase.api.email$fn__64296.invokeStatic(email.clj:79)
at metabase.api.email$fn__64296.invoke(email.clj:67)
at compojure.core$wrap_response$fn__1996.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__1980.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__1985.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__1989.invoke(core.clj:151)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1989.invoke(core.clj:153)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008.invoke(core.clj:200)
at metabase.server.middleware.auth$enforce_authentication$fn__76076.invoke(auth.clj:14)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008.invoke(core.clj:200)
at compojure.core$make_context$handler__2036.invoke(core.clj:287)
at compojure.core$make_context$fn__2038.invoke(core.clj:296)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$make_context$fn__2038.invoke(core.clj:297)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at metabase.api.routes$fn__76198$fn__76200.invoke(routes.clj:70)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008.invoke(core.clj:200)
at clojure.lang.AFn.applyToHelper(AFn.java:160)
at clojure.lang.AFn.applyTo(AFn.java:144)
at clojure.core$apply.invokeStatic(core.clj:665)
at clojure.core$apply.invoke(core.clj:660)
at metabase.server.routes$fn__78469$fn__78470.doInvoke(routes.clj:57)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008.invoke(core.clj:200)
at compojure.core$make_context$handler__2036.invoke(core.clj:287)
at compojure.core$make_context$fn__2038.invoke(core.clj:296)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1989.invoke(core.clj:153)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1989.invoke(core.clj:153)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1989.invoke(core.clj:153)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008$f__2009$respond_SINGLEQUOTE___2010.invoke(core.clj:197)
at metabase.server.routes$fn__78457$fn__78459.invoke(routes.clj:41)
at compojure.core$routes$fn__2008$f__2009.invoke(core.clj:198)
at compojure.core$routes$fn__2008.invoke(core.clj:200)
at metabase.server.middleware.exceptions$catch_uncaught_exceptions$fn__76189.invoke(exceptions.clj:98)
at metabase.server.middleware.exceptions$catch_api_exceptions$fn__76186.invoke(exceptions.clj:86)
at metabase.server.middleware.log$log_api_call$fn__78385$fn__78386.invoke(log.clj:195)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:216)
at toucan.db$_do_with_call_counting.invoke(db.clj:209)
at metabase.server.middleware.log$log_api_call$fn__78385.invoke(log.clj:189)
at metabase.server.middleware.browser_cookie$ensure_browser_id_cookie$fn__78021.invoke(browser_cookie.clj:30)
at metabase.server.middleware.security$add_security_headers$fn__76151.invoke(security.clj:142)
at metabase.server.middleware.json$wrap_json_body$fn__78166.invoke(json.clj:62)
at metabase.server.middleware.json$wrap_streamed_json_response$fn__78184.invoke(json.clj:98)
at ring.middleware.keyword_params$wrap_keyword_params$fn__78726.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__78742.invoke(params.clj:69)
at metabase.server.middleware.misc$maybe_set_site_url$fn__35891.invoke(misc.clj:58)
at metabase.server.middleware.session$bind_current_user$fn__42760$fn__42761.invoke(session.clj:257)
at metabase.server.middleware.session$do_with_current_user.invokeStatic(session.clj:238)
at metabase.server.middleware.session$do_with_current_user.invoke(session.clj:230)
at metabase.server.middleware.session$bind_current_user$fn__42760.invoke(session.clj:256)
at metabase.server.middleware.session$wrap_current_user_info$fn__42747.invoke(session.clj:216)
at metabase.server.middleware.session$wrap_session_id$fn__42733.invoke(session.clj:162)
at metabase.server.middleware.auth$wrap_api_key$fn__76084.invoke(auth.clj:27)
at ring.middleware.cookies$wrap_cookies$fn__78646.invoke(cookies.clj:216)
at metabase.server.middleware.misc$add_content_type$fn__35874.invoke(misc.clj:27)
at metabase.server.middleware.misc$disable_streaming_buffering$fn__35899.invoke(misc.clj:75)
at ring.middleware.gzip$wrap_gzip$fn__78688.invoke(gzip.clj:86)
at metabase.server.middleware.misc$bind_request$fn__35902.invoke(misc.clj:92)
at metabase.server.middleware.ssl$redirect_to_https_middleware$fn__78402.invoke(ssl.clj:38)
at metabase.server$async_proxy_handler$fn__77965.invoke(server.clj:71)
at metabase.server.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:516)
at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773)
at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905)
at java.lang.Thread.run(Unknown Source)
Caused by: java.net.SocketTimeoutException: Read timed out
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at java.net.SocketInputStream.read(Unknown Source)
at sun.security.ssl.SSLSocketInputRecord.read(Unknown Source)
at sun.security.ssl.SSLSocketInputRecord.readHeader(Unknown Source)
at sun.security.ssl.SSLSocketInputRecord.decode(Unknown Source)
at sun.security.ssl.SSLTransport.decode(Unknown Source)
at sun.security.ssl.SSLSocketImpl.decode(Unknown Source)
at sun.security.ssl.SSLSocketImpl.readHandshakeRecord(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.security.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at com.sun.mail.util.SocketFetcher.configureSSLSocket(SocketFetcher.java:598)
at com.sun.mail.util.SocketFetcher.createSocket(SocketFetcher.java:372)
at com.sun.mail.util.SocketFetcher.getSocket(SocketFetcher.java:238)
at com.sun.mail.smtp.SMTPTransport.openServer(SMTPTransport.java:2066)
... 123 more
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:18:58-03:00 WARN metabase.api.email Problem connecting to mail server: Exception reading response
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:18:58-03:00 ERROR metabase.server.middleware.log PUT /api/email 500 17,9 s (0 chamadas ao banco de dados)
{:message "Sorry, something went wrong. Please try again."}
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:18:58-03:00 DEBUG metabase.server.middleware.log GET /api/setting 200 1,7 ms (0 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (51 total de threads ativas) Consultas ativas: 0 (0 na fila)
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:18:58-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 10,8 ms (2 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (51 total de threads ativas) Consultas ativas: 0 (0 na fila)
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:19:02-03:00 DEBUG metabase.server.middleware.log GET /api/user/current 200 5,8 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 5 / 50 (1 ocioso, 0 na fila) (53 total de threads ativas) Consultas ativas: 0 (0 na fila)
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:19:02-03:00 DEBUG metabase.server.middleware.log GET /api/session/properties 200 12,0 ms (2 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 4 / 50 (1 ocioso, 0 na fila) (53 total de threads ativas) Consultas ativas: 0 (0 na fila)
[342fc8b5-6f10-4644-923b-c8fd04a42b1f] 2021-06-21T16:19:02-03:00 DEBUG metabase.server.middleware.log GET /api/database 200 11,1 ms (3 chamadas ao banco de dados) Conexões de banco de dados do aplicativo: 0 / 7 Threads do Jetty: 4 / 50 (1 ocioso, 0 na fila) (53 total de threads ativas) Consultas ativas: 0 (0 na fila)