With-mongo-connection failed: bad connection details:

1

I get this error:

with-mongo-connection failed: bad connection details:

When I try to send my own query to the DB.

2

I have the same issue, adding screenshots to demonstrate problem further:

Screen Shot 2016-01-17 at 12.44.31.png1858×1822 121 KB

Any idea what we're doing wrong anyone?

Thanks!

3

What version of Metabase and Mongo are you using?

4

I’m using the latest and greatest everything.

5

Sorry I replied via email and apparently that doesn’t work!

Mongo: 3.0.8
Metabase: 0.13.2.0

6

It looks like the objectID + rows are rendering. Are you trying to run a SQL query against a mongo db? It might be an incorrect error message there.

7

Can you check the server logs for any error messages? Not seeing a ton of information that lets us debug this.

Also, can you confirm that the command-line mongo client with the same auth details works?

8

Not sure why you’re seeing that particular error message but MongoDB doesn’t support SQL

9

I am using the same mongo queries that I use in my application.

10

I have the same issue.
Mongo - 3.0.12
Metabase - 0.17.1

Pasted image625×627 16.1 KB

11

Trace:

22:28:26 DEBUG metabase.query-processor ::
QUERY: �
{:database 5, :type “native”, :native {:query “select 1,3”}, :constraints {:max-results 10000, :max-results-bare-rows 2000}}

22:28:26 ERROR metabase.query-processor :: {:status :failed,
:class java.lang.Exception,
:error “with-mongo-connection failed: bad connection details:”,
:stacktrace
[“driver.mongo.util$_with_mongo_connection.invokeStatic(util.clj:51)”
“driver.mongo.util$_with_mongo_connection.invoke(util.clj:42)”
“driver.mongo$process_query_in_context$fn__34317.invoke(mongo.clj:47)”
“query_processor$pre_expand_resolve$fn__21621.invoke(query_processor.clj:154)”
“query_processor$pre_expand_macros$fn__21616.invoke(query_processor.clj:141)”
“query_processor$pre_add_settings$fn__21612.invoke(query_processor.clj:126)”
“query_processor$wrap_catch_exceptions$fn__21606.invoke(query_processor.clj:104)”
“query_processor$process_query.invokeStatic(query_processor.clj:411)”
“query_processor$process_query.invoke(query_processor.clj:399)”
“query_processor$dataset_query.invokeStatic(query_processor.clj:468)”
“query_processor$dataset_query.invoke(query_processor.clj:434)”
“api.dataset$fn__23107$fn__23110.invoke(dataset.clj:32)”
“api.common.internal$wrap_catch_api_exceptions.invokeStatic(internal.clj:219)”
“api.common.internal$wrap_catch_api_exceptions.invoke(internal.clj:216)”
“api.dataset$fn__23107.invokeStatic(dataset.clj:26)”
“api.dataset$fn__23107.invoke(dataset.clj:26)”
“middleware$enforce_authentication$fn__25786.invoke(middleware.clj:80)”
“api.routes$fn__25892.invokeStatic(routes.clj:40)”
“api.routes$fn__25892.invoke(routes.clj:40)”
“routes$fn__30801.invokeStatic(routes.clj:24)”
“routes$fn__30801.invoke(routes.clj:24)”
“middleware$log_api_call$fn__25879.invoke(middleware.clj:260)”
“middleware$add_security_headers$fn__25839.invoke(middleware.clj:197)”
“middleware$bind_current_user$fn__25790.invoke(middleware.clj:93)”
“middleware$wrap_current_user_id$fn__25764.invoke(middleware.clj:62)”
“middleware$wrap_api_key$fn__25805.invoke(middleware.clj:104)”
“middleware$wrap_session_id$fn__25757.invoke(middleware.clj:53)”],
:query {:type “native”, :native {:query “select 1,3”}, :constraints {:max-results 10000, :max-results-bare-rows 2000}},
:expanded-query nil}

22:28:26 ERROR metabase.query-processor :: Query failure: with-mongo-connection failed: bad connection details: