Log file Viewer

[01:49:17] <bonhoeffer> hey -- i'm trying to get a basic build in mongodb want to connect with compass -- but i get "An error occurred while loading navigation: there are no users authenticated

[01:49:46] <bonhoeffer> i set authorization: disabled

[08:35:28] <temhaa> hello

[08:35:33] <temhaa> I use mongodb server for db

[08:35:47] <temhaa> I have java client.. and has credentials to connection it..

[08:35:56] <temhaa> my password contains "+" (plus) char

[08:36:37] <temhaa> when I use "user:pass+word@......."

[08:36:52] <temhaa> I can not connect... I get authentication failed..

[08:37:00] <temhaa> how can I encode "+" character

[08:41:42] <lqez> temhaa: How about to use MongoCredential?

[08:41:43] <lqez> http://mongodb.github.io/mongo-java-driver/3.9/driver/tutorials/authentication/

[08:42:36] <lqez> Or you have to escape characters before using it

[08:44:08] <temhaa> yes. we use mongoclienturi

[08:44:17] <temhaa> how can I escape it?

[08:48:57] <lqez> I'm not an expert on Java but you may encode it with java.net.URLEncoder

[08:54:37] <temhaa> lqez: thanks

[08:54:40] <temhaa> I'll try it

[13:25:16] <akkonrad> hey, I have a query that takes quite a lot of time to execute (1.5 sec). data structure looks like this, every squere is a separate collection: https://imgur.com/wcbhXF7

[13:26:08] <akkonrad> and this is the query: https://www.pastery.net/wdkntp/

[13:27:02] <akkonrad> why it takes so much time to execute? I've already added indexes on each relation field and it significantly speed up the query (it was ~7 sec. before).

[13:35:48] <akkonrad> it even takes a lot of time if I remove "$group" section

[14:00:46] <Derick> akkonrad: you're using mongodb as a relational database, please don't do that

[14:02:32] <akkonrad> I know, but at this point it's impossible to change the db design. is there a way to avoid slow queyr in this example?

[14:08:47] <Derick> try explain, and see what it does.

[14:08:57] <Derick> do you have indexes on all the required fields?

[14:40:04] <akkonrad> Derick, yes I have indexes. Here is explain: https://www.pastery.net/whmdcn/

[15:42:41] <pandaadb> akkonrad, you have 5 joins in there

[15:43:34] <pandaadb> from the mongo events: When you find yourself using "lookup" in aggregation queries a lot, you need to think about changing your data structure to enable the queries you like to do

[15:45:06] <pandaadb> (paraphrasing :) )

[15:45:35] <Derick> pandaadb: it's what I said immediately too, really.

[15:45:58] <pandaadb> yes :)

[15:46:46] <pandaadb> sorry - i read from the top and answer to quickly - my apologies :)

[15:47:07] <pandaadb> I get excited when I think I can help

[21:14:14] <jeffreylevesque_> Hello world!

[21:14:23] <jeffreylevesque> Anyone here deploy a shard with version 4?