Log file Viewer

[07:31:43] <Haris> hello all

[07:32:43] <Haris> I'm on 3.6.4. I created a test db. created a test collection in it. I created a user with password. didn't specify host. but added readWrite role and dbAdmin role. I am unable to connect to this db via mongo-express. I have nothing, no log or something to debug it with. how do I go about it ?

[10:16:08] <Haris> Is there a doc / article on how to install (1) legacy driver for php (2) non-legacy driver for php (3) user land driver for php on ubuntu 14.04, 16.04, centos 7 ?

[10:26:42] <Derick> for (2) and (3): http://php.net/manual/en/mongodb.installation.pecl.php & https://github.com/mongodb/mongo-php-library#installation

[10:26:52] <Derick> and for (1) I will say - don't install it anymore

[10:27:00] <Derick> it's unsupported and unmaintained

[11:28:50] <Haris> how to add clientSource host for an already created user ? I can't figure it out from https://docs.mongodb.com/manual/reference/method/db.updateUser/

[11:29:15] <Haris> (2) I created a user for test db. but this user, once it logs in, can see all DBs

[11:29:43] <Haris> In addition to creating users, do I need to explicitly enable auth ?

[13:35:49] <Derick> you do need to enable auth in the config file, yes

[14:28:42] <mamalos> @Derick: thanks for the link, it did the trick. I've installed mongodb-org-unstable (3.7) successfully on my debian 9 host

[14:29:03] <b44__> 3 models: page, page_type, field. A page hasOne page_type. A page_type hasMany fields. If a page has set a page_type, it has the same fields and can fill them with content.

[14:29:10] <b44__> Is this easy to structure in MongoDB ?

[14:29:54] <b44__> for relational databases like PostgreSQL this seems to be the EAV principle, and can be difficult

[14:30:17] <b44__> Should I use PostGreSQL + JSONB for this, or MongoDB?

[14:37:39] <Derick> mamalos: yay! — note: unstable, unreleased version, which might have problems.

[14:38:12] <Derick> b44__: JSONB is not a great way of doing things, unless you like messing around with JSON strings.

[14:38:37] <Derick> I would probably, depending on use case, also not bother with a page_type, but just embed it within a "page" document

[14:44:23] <mamalos> @Derick: I understand so, but based on your comment I assume that a stable binary is going to be provided there soon too, right?

[14:44:42] <Derick> yeah, in the next weeks or so, I think

[14:44:49] <Derick> let me see what the aimed-for date is

[14:46:45] <Derick> sorry, can't find it

[14:48:48] <mamalos> @Derick: don't worry man, you've helped enough already. Moreover, knowing that a stable release is due in the near future is enough for me.

[14:55:02] <mamalos> ah, and one more thing: is there a way to import the PGP key for the repo you pasted in order for apt not to complain?

[14:56:01] <mamalos> I mean, do we have the url to the isc file?

[14:56:12] <mamalos> sorry: isc = asc

[14:56:44] <Derick> hm

[14:56:47] <Derick> let me see

[14:56:57] <Derick> it's probably on a keyserver

[14:58:21] <mamalos> I tried the one for 3.6 but it didn't work

[14:59:06] <Derick> apt should tell you which key it misses

[14:59:14] <Derick> if you pass that to: sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv

[14:59:22] <Derick> it should work? (as extra bit behind recv)

[14:59:24] <mamalos> ah, ok, let me try it

[15:00:17] <mamalos> ha! You're right, it worked, thanks!

[15:00:33] <Derick> yay!

[15:01:59] <mamalos> thanks a lot again for all the help!

[15:02:26] <mamalos> I'll come again in a week or so to see what the status will be with 3.6.

[15:30:57] <b44__> Derick: Mmmm..... Ok. And there is a way to realise this in MongoDB? Maybe adding fields dynamically during runtime to the page schema?

[15:36:04] <Derick> the page schema? MongoDB doesn't have a schema like a RDBS has

[15:37:16] <b44__> the document schema, @Derick

[15:38:05] <b44__> So lets say, pages have field_1,...field_n. And now I'd like to add some new fields to this document schema

[15:38:17] <Derick> sorry, document schema?

[15:38:28] <b44__> ehmmm... model? :D

[15:38:29] <Derick> you just add an extra field in MongoDB to a document. THere is no schema.

[15:38:34] <Derick> or model...

[15:39:52] <b44__> Mmmm..... ok, this is a huge plus over PostGreSQL then... Because there I'd have to create something like EAV to allow adding fields a type, that is defined in runtime

[15:40:31] <b44__> *fields of a type*

[15:40:53] <b44__> thanks a lot Derick !

[15:41:13] <Derick> np :)