My MongoDB notes - Revision history

Paul: /* Create additional users (example) */

2019-08-12T00:10:28Z

Create additional users (example)

← Older revision		Revision as of 19:10, 11 August 2019
Line 170:		Line 170:
	]		]
	}</pre>		}</pre>

			== grant additional roles to user ==

			[https://docs.mongodb.com/manual/reference/method/db.grantRolesToUser/#db.grantRolesToUser db.grantRolesToUser(username, roles, writeConcern)]

	== Manual references ==		== Manual references ==

Paul: /* Create additional users (example) */

2019-08-11T22:34:26Z

Create additional users (example)

← Older revision		Revision as of 17:34, 11 August 2019
Line 170:		Line 170:
	]		]
	}</pre>		}</pre>

			== Manual references ==

			[https://docs.mongodb.com/manual/reference/connection-string/ connection string ] page describes the URI formats for defining connections between applications and MongoDB instances in the official MongoDB drivers

	== Windows 10 (dev environment) ==		== Windows 10 (dev environment) ==

Paul: added create user example

2019-08-11T21:43:02Z

added create user example

@@ Line 143: / Line 143: @@
 > use admin
 > db.auth("myUserAdmin", "abc123" )</pre>
 == Windows 10 (dev environment) ==

Paul: /* add MongoDB user and enable remote management access */

2019-08-11T21:31:44Z

add MongoDB user and enable remote management access

← Older revision		Revision as of 16:31, 11 August 2019
Line 73:		Line 73:
	bindIp: 127.0.0.1,192.168.1.109 <-- An IP address on your server that you want MongoDB to listen for TCP connections.</pre>		bindIp: 127.0.0.1,192.168.1.109 <-- An IP address on your server that you want MongoDB to listen for TCP connections.</pre>

			Shutdown instance within mongo shell <code>db.adminCommand( { shutdown: 1 } )</code>

	~~Shutdown~~ instance ~~within mongo shell <code>db~~.~~adminCommand( { shutdown: 1 } )</code>~~		'''After restart attempt MongoDB instance failed to start.'''

	~~After restart attempt MongoDB instance failed to start.~~ The MongoDB log had this:		The MongoDB log had this:
	<pre>$ sudo tail /var/log/mongodb/mongod.log		<pre>$ sudo tail /var/log/mongodb/mongod.log
	2019-08-11T15:41:04.940-0500 I CONTROL [initandlisten] distarch: x86_64		2019-08-11T15:41:04.940-0500 I CONTROL [initandlisten] distarch: x86_64
Line 94:		Line 95:
	The fix is to delete file so it can be recreated with correct permissions.		The fix is to delete file so it can be recreated with correct permissions.

	# $ sudo rm /tmp/mongodb-27017.sock		<code>$ sudo rm /tmp/mongodb-27017.sock</code>

	Verify that TCP socket is closed or you will get ''Failed to set up listener: SocketException: Address already in use'' upon start up		Verify that TCP socket is closed or you will get ''Failed to set up listener: SocketException: Address already in use'' upon start up
Line 132:		Line 133:
	unix 2 [ ACC ] STREAM LISTENING 13117024 /tmp/mongodb-27017.sock		unix 2 [ ACC ] STREAM LISTENING 13117024 /tmp/mongodb-27017.sock
	</pre>		</pre>

			=== Connect and authenticate as user administrator ===

			Authenticate during connection to mongo <code>mongo --port 27017 -u "myUserAdmin" --authenticationDatabase "admin" -p</code>

			or
			<pre>
			$ mongo --port 27017
			> use admin
			> db.auth("myUserAdmin", "abc123" )</pre>

	== Windows 10 (dev environment) ==		== Windows 10 (dev environment) ==

Paul: /* add MongoDB user */

2019-08-11T21:19:48Z

add MongoDB user

@@ Line 42: / Line 42: @@
 Display mongo shell help <code>> help</code>
-== add MongoDB user ==
+== add MongoDB user and enable remote management access ==
 [https://docs.mongodb.com/manual/core/security-users/ User documentation]
@@ Line 48: / Line 48: @@
 Steps to setup first user and enable access control [https://docs.mongodb.com/manual/tutorial/enable-authentication/ resource]
-create user administrator
+create user administrator (sample file, use your own user and pwd values)
 <pre>use admin
 db.createUser(
@@ Line 59: / Line 58: @@
 )</pre>
-Restart MongoDB instance with access control
+Enable MongoDB instance to start with access control enabled by editing MongoDB config <code>$ sudo vi /etc/mongod.conf</code>
 Shutdown instance within mongo shell <code>db.adminCommand( { shutdown: 1 } )</code>
 == Windows 10 (dev environment) ==

Paul: /* add MongoDB user */

2019-08-11T20:26:44Z

add MongoDB user

← Older revision		Revision as of 15:26, 11 August 2019
Line 45:		Line 45:

	[https://docs.mongodb.com/manual/core/security-users/ User documentation]		[https://docs.mongodb.com/manual/core/security-users/ User documentation]

			Steps to setup first user and enable access control [https://docs.mongodb.com/manual/tutorial/enable-authentication/ resource]

			create user administrator

			<pre>use admin
			db.createUser(
			{
			user: "myUserAdmin",
			pwd: "abc123",
			roles: [ { role: "userAdminAnyDatabase", db: "admin" }, "readWriteAnyDatabase" ]
			}
			)</pre>

			Restart MongoDB instance with access control

			Shutdown instance within mongo shell <code>db.adminCommand( { shutdown: 1 } )</code>

	== Windows 10 (dev environment) ==		== Windows 10 (dev environment) ==

Paul: added add MongoDB user section

2019-08-11T19:59:04Z

added add MongoDB user section

← Older revision		Revision as of 14:59, 11 August 2019
Line 41:		Line 41:

	Display mongo shell help <code>> help</code>		Display mongo shell help <code>> help</code>

			== add MongoDB user ==

			[https://docs.mongodb.com/manual/core/security-users/ User documentation]

	== Windows 10 (dev environment) ==		== Windows 10 (dev environment) ==

Paul: /* Run MongoDB Community Edition */

2019-08-11T19:50:26Z

Run MongoDB Community Edition

← Older revision		Revision as of 14:50, 11 August 2019
Line 31:		Line 31:
	Created symlink /etc/systemd/system/multi-user.target.wants/mongod.service → /lib/systemd/system/mongod.service.		Created symlink /etc/systemd/system/multi-user.target.wants/mongod.service → /lib/systemd/system/mongod.service.
	</pre>		</pre>

			== mongo shell ==

			[https://docs.mongodb.com/manual/mongo/ mongo shell manual]

	Running mongo at shell <code>$ mongo</code>		Running mongo at shell <code>$ mongo</code>

Paul: /* Run MongoDB Community Edition */

2019-08-11T19:44:50Z

Run MongoDB Community Edition

@@ Line 32: / Line 32: @@
 </pre>
-Running mongo shell for first time
+Running mongo at shell <code>$ mongo</code>
-<pre>$ mongo
+Exit mongo shell <code>> exit</code>
-The monitoring data will be available on a MongoDB website with a unique URL accessible to you
+Display mongo shell help <code>> help</code>
 == Windows 10 (dev environment) ==

Paul: added start info

2019-08-11T19:39:46Z

added start info

@@ Line 21: / Line 21: @@
 # Restart MongoDB with <code>sudo service mongod restart</code>
 # Begin using MongoDB shell with <code>mongo</code>
 Running mongo shell for first time