Log file Viewer

[02:06:52] <philosonerd_____> Can someone tell me how I can access my local database without getting: "login failed". Why do I get this? I thought it was default with local access no matter of authentication. I also tried with my username and password that I previously set, but it seems to have forgotten about that....

[05:05:58] <zachcowell> can anyone tell me of a simple way of setting field types to ints? it looks like after i did a mongoimport it set everything to string

[10:22:58] <ron> tychoish: ping

[10:57:43] <anthony_> what is the difference between a 2d index and a 2dsphere index?

[11:21:27] <HieHieNoMi> Hello, I have one question on Mongodb. How to search " ô " by " o "

[11:21:30] <HieHieNoMi> i use mongoose .

[11:24:59] <megawolt> @HieHieNoMi you can search via regex...

[11:55:59] <farrukhayub> hello all

[11:56:09] <megawolt> hey bro

[11:56:24] <farrukhayub> is there any way that I can automate mongodb config via some bash script

[11:56:45] <megawolt> what kind of automate?

[11:57:03] <farrukhayub> i mean i am doing fabric script with install mongodb and other things, I want to be able to setup auth options via that script too

[11:57:15] <farrukhayub> instead of using mongo shell

[11:58:05] <farrukhayub> *which

[11:59:09] <megawolt> i think that's little bit harder if you don't want to use mongo shell

[11:59:19] <farrukhayub> hmm ic

[11:59:44] <megawolt> but you can write a console app reach mongoshell

[12:00:08] <megawolt> so you can call with parameters.

[12:00:35] <megawolt> i guess that's little bit safer than non-shell action

[12:01:05] <farrukhayub> are there any example out about

[12:03:12] <megawolt> what is your deveoplment platform?

[12:03:33] <farrukhayub> linux

[12:04:06] <megawolt> so i can't help with that... I'm running on windows

[12:05:57] <farrukhayub> no problem thank for your help I will do bit of search

[12:06:11] <megawolt> your welcome

[13:04:39] <asido> "If the document

[13:04:39] <asido> size exceeds the allocated space for that document, MongoDB relocates the document on disk.

[13:05:26] <asido> ". why is relocation necessary? I somewhat find it hard to understand as space on disk is not something like a space returned by malloc(). shouldn't filesystem handle that?

[13:06:16] <megawolt> yes you're right

[13:06:34] <megawolt> but allocated space can be not enough for the document

[13:06:47] <megawolt> recollation should be for that

[13:07:08] <megawolt> ... tecnical disabilities... :(

[13:07:41] <asido> megawolt, you mean it's in case the current filesystem doesn't have enough space to increase document size?

[13:08:46] <megawolt> for allocated db sizes, yes...

[13:09:53] <megawolt> so relocated new db file allocated space name like, DBNAME.2

[13:10:09] <asido> oh I see. when creating a new collection, I noticed it's initial size was collect.0 - 64MB, collect.1 128MB

[13:10:18] <asido> so it means this pre-allocated space?

[13:10:36] <megawolt> yep i think so...

[13:11:45] <megawolt> i'm just a MongoDB Admin not o MongoDB officer...

[13:50:32] <siaw> Hi, I'm trying to convert a project of mine from mysql to mongodb. In mysql i had two tables: Games and Players, where each game could have many Players. Now in mongodb should I use one collection of Games with an array of Players?

[13:50:36] <siaw> ~

[13:51:00] <siaw> ups :)

[13:51:03] <megawolt> depends on max size of array

[13:51:23] <megawolt> array queries can be fatal in mongodb..

[13:52:22] <siaw> oh, in mysql i do a lot of group by's on the Players table to get stats/player

[13:52:37] <siaw> well its max 16 players/game

[13:53:27] <megawolt> array will be great

[13:54:03] <siaw> ok, nice

[13:54:05] <megawolt> at the anotharnd don't forget that; array queries will you give document not the parent of array

[13:55:35] <siaw> ehm, can you dumb that down a bit? :)

[13:57:41] <megawolt> ehhmm...you have a documenyt like; {name:"foo",game:{name:"foogame",Players : [1000,2000]]}}

[13:58:35] <megawolt> query result will gave that document

[13:59:21] <megawolt> not exact Player[int] element

[13:59:51] <siaw> yeah ok, but that shouldn't be a problem?

[14:02:15] <megawolt> sometimes yes, but nothing impossible in application level :)

[14:02:40] <megawolt> we have stacked a little about that...

[14:13:02] <siaw> ok another question, if a document in my collection for example { gameid:1, players:[ { player:1, kills:2 }, { player:2, kills:3 } ] } How would I get the average kills/game for each player?

[14:14:44] <megawolt> that's a little complicated but you'll have your answer in aggregated framework :)

[14:15:19] <megawolt> you can really get result faster and have math. functions live sum(), avg()

[14:16:40] <siaw> is that soo :o

[14:30:16] <siaw> little more complicated than mysql's group by

[14:35:33] <megawolt> yeaahh. but if you completely learn fundamentals you sql tables will be great.

[14:35:50] <megawolt> NoSQL another era of Db :)

[14:42:24] <iTrojan> can I give up RDBMS for mongod / nosql?

[14:42:59] <ron> that's... a meaningless question.

[14:43:56] <iTrojan> oh

[14:45:05] <hummus3> anyone every seen mongod(2.4.3) crashes related to 'src/third_party/s2/s2loop.cc:288: Check failed: IsNormalized()'

[14:47:28] <iTrojan> hummus3: not me

[14:52:09] <farkore_> Hi all! I'm a newbie in mongodb,and I have a question that google has not responded me correctly, probably because I don't know how to ask him. I am here because is my last chance. My Question is: I have many report documents that are hierarchically structured and exists a "principal document" called "Reporte" (Report), the others documents are embeded on it. So why MongoU (Client for mongo db) shows me all documents (that are embedded in Reporte) as "p

[14:52:09] <farkore_> rincipal documents"?

[14:52:51] <farkore_> http://postimg.org/image/575sqwzwl/

[14:53:07] <farkore_> That is an screenshot

[14:53:24] <farkore_> (Sorry for my english)

[14:58:21] <hummus3> 1. afaik ive only seen the crash during large-ish(2k+) cursor iterations over $geoWithin Polygon queries. 2. the mongod instance being queried will continue to crash on some* successive large $geoWithin queries 3. reIndex()-ing the collection stops the crashing for a prolonged period of time, even rerunning the same queries

[15:05:56] <hummus3> after a few crashes i ran db.setProfilingLevel(0,-1) to see the last few queries, but this only shows completed queries. That hex dump at the beginning of the backtrace isnt the crashing query or something _extra_usefuls_ is it?

[15:13:12] <farkore_> Anybody may help me?

[15:14:32] <Goopyo> farkore_: always ask

[15:14:36] <Goopyo> if someone's here they'll help you

[15:14:56] <Goopyo> Unless you asked and I missed it since I just came in

[15:15:17] <farkore_> i will copy the question

[15:15:25] <farkore_> Thanks Goopyo

[15:15:29] <farkore_> Hi all! I'm a newbie in mongodb,and I have a question that google has not responded me correctly, probably because I don't know how to ask him. I am here because is my last chance. My Question is: I have many report documents that are hierarchically structured and exists a "principal document" called "Reporte" (Report), the others documents are embeded on it. So why MongoU (Client for mongo db) shows me all documents (that are embedded in Reporte) as "p

[15:15:29] <farkore_> rincipal documents"?

[15:15:35] <farkore_> http://postimg.org/image/575sqwzwl/

[15:15:35] <farkore_> That is an screenshot

[15:15:35] <farkore_> (Sorry for my english)

[15:15:37] <hummus3> farkore_ im downloading that ui ive never used it. but it almost seems like it could just be the output formatting? are there other problems?

[15:18:43] <Goopyo> principal document = 'collection' ?

[15:19:12] <farkore_> No, There is not more problems than that. The weird is this: In mongoid I have a Campaign class that embbeds_many CampaignSubscription, if I create that in MongoU appers only "campaigns" and the campaigns subscriptions are embbeded on it. But that not ocurrs with my reports

[15:19:24] <farkore_> Gopyo, how can I specify that?

[15:20:54] <Goopyo> are you using dbrefs? If so UMongo is probably preloading them,

[15:21:54] <Goopyo> both these problems seem like they are with the app umongo but not mongodb, correct? If so try a different gui from here: http://docs.mongodb.org/ecosystem/tools/administration-interfaces/

[15:22:51] <farkore_> no, I'm using "embeds_many" or "embeds_one" relations types. For dbrefs MongoId specify "has_many" and "has_one" I think.

[15:27:41] <farkore_> I will try with another UI

[15:27:51] <farkore_> thanks guys!

[16:22:42] <hummus3> Goopyo im not sure if you're still around, but before I mentioned mongod(2.4.3) crash related to 'src/third_party/s2/s2loop.cc:288: Check failed: IsNormalized()'. I was wondering if anyone had ever seen such a crash, and i mentioned it possibly seemed related to $geoWithin Polygon queries and a large cursor result. I know it seems pretty obscure but i figured id ask again as I try collecting more info.

[16:25:03] <Goopyo> sorry never heard of it

[16:32:15] <hummus3> yea i havent seen many crashes... maybe im ignoring other factors though. dmesg shows status 14 (which i think is io related?). so i checked the disks, but they seem ok. the mongod log itself shows "Got signal 6 (aborted)" but that seems to just shows an immediate exit?

[20:26:10] <langemann> Hey, I use mongoose and want to get 3 values distinct from some documents. I started using the distinct() command, but I need another key - the "_id" key because some distinct values will have multiple distinct subvalues. These subvalues has the same _id as their parent.

[20:26:33] <langemann> Eh, *mongoose in nodejs that is. I'm just trying to find a query I could use for the problem above.

[21:08:25] <LoneSoldier728> hey so http://stackoverflow.com/questions/21222643/most-efficient-way-to-filter-a-search

[21:08:35] <LoneSoldier728> anyone know how to deal with that?

[22:07:46] <imm6> anyone here familiar with mongoose ?

[22:10:13] <LoneSoldier728> ya

[22:10:20] <cheeser> not me. not a js guy.

[22:10:34] <LoneSoldier728> all about js guy here