pierreabreup
I’m using a new version of mongodb lib in my project and when I try to execute a query (Mongo.find()) I get the error:
not authorized for query on mydb.mycollection 13. I’ve checked the user’s permissions and it seems ok:
root@5c32443b7a09:/# mongo -u root -p root
MongoDB shell version v4.2.1
connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb
Implicit session: session { "id" : UUID("7941b564-95e1-4f1f-b630-e08cea929a0b") }
MongoDB server version: 4.2.1
> use content_proxy
switched to db content_proxy
> show users
{
"_id" : "content_proxy.cacete",
"userId" : UUID("2a564c6c-3fc6-4185-9d76-6c6cc936f6c1"),
"user" : "cacete",
"db" : "content_proxy",
"roles" : [
{
"role" : "readWrite",
"db" : "content_proxy"
}
],
"mechanisms" : [
"SCRAM-SHA-1",
"SCRAM-SHA-256"
]
}
>
I’ve researched in too many mongo foruns, I tried many solutions but still not works. Is there anyone with the same problem?
My elixir version is Elixir 1.9.4 (compiled with Erlang/OTP 22) my application libs versions are:
- phoenix 1.4.11
- db_connection: 2.1.1
- mongodb: 0.5.1
My mongodb server 4.2.1 (docker version mongo - Official Image | Docker Hub)
At last, the mongodb log is bellow:
2019-12-03T20:49:58.404+0000 I ACCESS [conn59] Successfully authenticated as principal cacete on content_proxy from client 127.0.0.1:45974
2019-12-03T20:55:20.624+0000 I QUERY [conn58] assertion Unauthorized: not authorized for query on content_proxy.contents ns:content_proxy.contents query:{ $query: { typeOf: "Chapter" }, $orderby: { _id: 1 } }
2019-12-03T20:55:20.624+0000 I QUERY [conn58] ntoskip:0 ntoreturn:101
Obs: Hi @Ankhers, could you please help me with this issue too?
Trending in Questions
Hello!
Suppose you are building workflow (order / task / payment) processing system with the following requirements:
Each workflow con...
New
I’m aware of 2 such projects, are there others?
git: GitHub - team-alembic/realworld: A fullstack Phoenix LiveView application with back...
New
Hi all,
I’m working on a Phoenix project where I need to make external HTTP requests and I’m trying to choose between Req and HTTPoison....
New
How do I tell Hologram not to escape HTML when substituting into templates?
{Textile.render(@product.long_description)}
escapes the HTM...
New
Hi,
we run different LLM models across a cluster, with each node loading a configurable subset. Model-specific queues let nodes consume ...
New
Hello
I’ve been coding in Elixir for almost two years now because of my current job where we implemented Elixir in our application. But ...
New
Hi all, I’m new here and would like to hear peoples views on my Elixir/Phoenix based game-engine! :smiley:
Mutonex gamedesign was finish...
New
Other Trending Topics
Hey there,
I haven’t seen a list of useful Elixir specific skills for the popular AI tools yet so I’m starting one here with my first.
...
New
Hi everyone :waving_hand:
I wanted to share something I’ve been building — NowBlind, a random chat app designed to help people discover ...
New
I fully migrated to my own harness from Anthropic/Gemini and I think it’s time to share it. Welcome DSH, the DeepSeek Harness, fully writ...
New
Hey. Is there anyone here who creates agents in their apps? Not talking about using agents, but creating them. I’m finding it pretty diff...
New
Localize is the next generation localisation library for Elixir. Think of it as ex_cldr version 3.0. The first version will be released ...
New
(I just needed to vent somewhere and LinkedIn is full of hope, or hype, I’m not sure which exactly)
AI dream has many faces, but general...
New
Categories:
Sub Categories:
Forums
Popular Tags
- #ecto
- #liveview
- #troubleshooting
- #learning-elixir
- #library
- #deployment
- #erlang
- #testing
- #genserver
- #mix
- #absinthe
- #remote-other
- #otp
- #plug
- #how-to-question
- #macros
- #postgres
- #elixirconf
- #channels
- #exunit
- #code-sync
- #discussion
- #podcasts
- #javascript
- #onsite
- #dialyzer
- #docker
- #authentication
- #ai
- #umbrella
- #full-time-contract
- #podcasts-by-brainlid
- #blog-post
- #elixirconf-us
- #ecto-query
- #elixir-ls
- #phoenix_html
- #iex
- #graphql
- #genstage
- #websockets
- #supervisor
- #advent-of-code
- #distillery
- #processes
- #security
- #elixirconf-eu
- #api
- #forms
- #hex











Showing Posts 1 to 3- Show Best Posts
- Show All (oldest first)
- Show All (newest first)
pierreabreup
To solve this problem you have to:
1 - create a specific user in mongodb
connect into mongodb using mongo shell client with root password (
mongo -u root -p root) Ex.:After connect, enter into database (
use mydb) and create an user (db.createUser({user: 'myuser',pwd: 'mypassword',roles: [ { role: 'readWrite', db: 'mydb' } ]})) Ex.:2 - change mongodb configuration on elixir project
You have to connect into mongodb using url sintax with authSource params (
mongodb://myuser:mypassword@mongodbhost:27017/mydb?authSource=mydb) Ex.:I’ve tried the sintax
worker(Mongo, [[name: :mongo, database: "mydb", seeds: ["myuser:mypassword@mongodb:27017"], pool_size: 10]])but it didn’t work.Ankhers
It looks like you have figured it out yourself, but you can also just use the
:auth_sourcekey instead of switching to the URL format.pierreabreup
thank you so much!
