Hi,
I am having problem in connecting to mongodb atlas cluster using metabase.
following is my error log
12-13 16:43:17 DEBUG middleware.log :: GET /api/database 200 3.4 ms (3 DB calls) Jetty threads: 4/50 (3 idle, 0 queued) (67 total active threads) Queries in flight: 0
12-13 16:46:39 ERROR driver.util :: Database connection error
java.util.concurrent.TimeoutException: Timed out after 5,000 milliseconds.
at metabase.util$deref_with_timeout.invokeStatic(util.clj:325)
at metabase.util$deref_with_timeout.invoke(util.clj:317)
at metabase.util$do_with_timeout.invokeStatic(util.clj:331)
at metabase.util$do_with_timeout.invoke(util.clj:328)
at metabase.driver.util$can_connect_with_details_QMARK_.invokeStatic(util.clj:30)
at metabase.driver.util$can_connect_with_details_QMARK_.doInvoke(util.clj:19)
at clojure.lang.RestFn.invoke(RestFn.java:442)
at metabase.api.database$test_database_connection.invokeStatic(database.clj:319)
at metabase.api.database$test_database_connection.doInvoke(database.clj:308)
at clojure.lang.RestFn.invoke(RestFn.java:425)
at metabase.api.database$fn__51671$test_connection_details__51676$fn__51677.invoke(database.clj:358)
at metabase.api.database$fn__51671$test_connection_details__51676.invoke(database.clj:346)
at metabase.api.database$fn__51727.invokeStatic(database.clj:393)
at metabase.api.database$fn__51727.invoke(database.clj:380)
at compojure.core$wrap_response$fn__1971.invoke(core.clj:160)
at compojure.core$wrap_route_middleware$fn__1955.invoke(core.clj:132)
at compojure.core$wrap_route_info$fn__1960.invoke(core.clj:139)
at compojure.core$wrap_route_matches$fn__1964.invoke(core.clj:151)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983.invoke(core.clj:200)
at metabase.middleware.auth$enforce_authentication$fn__64168.invoke(auth.clj:14)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983.invoke(core.clj:200)
at compojure.core$make_context$handler__2011.invoke(core.clj:287)
at compojure.core$make_context$fn__2013.invoke(core.clj:296)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$make_context$fn__2013.invoke(core.clj:297)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$make_context$fn__2013.invoke(core.clj:297)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$make_context$fn__2013.invoke(core.clj:297)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$make_context$fn__2013.invoke(core.clj:297)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$make_context$fn__2013.invoke(core.clj:297)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$make_context$fn__2013.invoke(core.clj:297)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983.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.routes$fn__65545$fn__65546.doInvoke(routes.clj:56)
at clojure.lang.RestFn.invoke(RestFn.java:436)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983.invoke(core.clj:200)
at compojure.core$make_context$handler__2011.invoke(core.clj:287)
at compojure.core$make_context$fn__2013.invoke(core.clj:296)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1964.invoke(core.clj:153)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1964.invoke(core.clj:153)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983$f__1984$respond_SINGLEQUOTE___1985.invoke(core.clj:197)
at compojure.core$wrap_route_matches$fn__1964.invoke(core.clj:153)
at compojure.core$routes$fn__1983$f__1984.invoke(core.clj:198)
at compojure.core$routes$fn__1983.invoke(core.clj:200)
at metabase.middleware.exceptions$catch_uncaught_exceptions$fn__64267.invoke(exceptions.clj:104)
at metabase.middleware.exceptions$catch_api_exceptions$fn__64264.invoke(exceptions.clj:92)
at metabase.middleware.log$log_api_call$fn__65919$fn__65920.invoke(log.clj:170)
at toucan.db$_do_with_call_counting.invokeStatic(db.clj:213)
at toucan.db$_do_with_call_counting.invoke(db.clj:206)
at metabase.middleware.log$log_api_call$fn__65919.invoke(log.clj:164)
at metabase.middleware.security$add_security_headers$fn__64230.invoke(security.clj:122)
at metabase.middleware.json$wrap_json_body$fn__65624.invoke(json.clj:61)
at metabase.middleware.json$wrap_streamed_json_response$fn__65642.invoke(json.clj:97)
at ring.middleware.keyword_params$wrap_keyword_params$fn__66152.invoke(keyword_params.clj:55)
at ring.middleware.params$wrap_params$fn__66200.invoke(params.clj:69)
at metabase.middleware.session$bind_current_user$fn__60792$fn__60793.invoke(session.clj:209)
at metabase.middleware.session$do_with_current_user.invokeStatic(session.clj:184)
at metabase.middleware.session$do_with_current_user.invoke(session.clj:177)
at metabase.middleware.session$bind_current_user$fn__60792.invoke(session.clj:208)
at metabase.middleware.session$wrap_current_user_id$fn__60777.invoke(session.clj:161)
at metabase.middleware.session$wrap_session_id$fn__60762.invoke(session.clj:123)
at metabase.middleware.auth$wrap_api_key$fn__64176.invoke(auth.clj:27)
at metabase.middleware.misc$maybe_set_site_url$fn__65946.invoke(misc.clj:56)
at metabase.middleware.misc$bind_user_locale$fn__65949.invoke(misc.clj:72)
at ring.middleware.cookies$wrap_cookies$fn__66072.invoke(cookies.clj:177)
at metabase.middleware.misc$add_content_type$fn__65934.invoke(misc.clj:28)
at metabase.middleware.misc$disable_streaming_buffering$fn__65957.invoke(misc.clj:87)
at ring.middleware.gzip$wrap_gzip$fn__66114.invoke(gzip.clj:86)
at ring.adapter.jetty$async_proxy_handler$fn__65720.invoke(jetty.clj:35)
at ring.adapter.jetty.proxy$org.eclipse.jetty.server.handler.AbstractHandler$ff19274a.handle(Unknown Source)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
at org.eclipse.jetty.server.Server.handle(Server.java:502)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:370)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:267)
at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:305)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:765)
at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:683)
at java.base/java.lang.Thread.run(Thread.java:834)
12-13 16:46:39 DEBUG middleware.log :: POST /api/database 400 5.0 s (0 DB calls)
{:valid false, :dbname “Timed out after 5,000 milliseconds.”, :message “Timed out after 5,000 milliseconds.”}
Also i am not able to connect to the cluster using mongo shell which is version 4.2 using the connecting string provided by the atlas cluster using the svr the error that shows there is
DNSHostNotFound: Failed to look up service “_mongodb._tcp.maximus-mkrmd.mongodb.net”: Connection timed out
but using the connection string provided for lower version of the shell i.e without svr i am able to connect to the cluster.
Please help me!!! If any information is missing please let me know I will provide it .
Also i am on linux machine using the jar locally
and metabase version