How To Connect MongoDB Using RoboMongo

1. Visit the RoboMongo, and download the RoboMongo.

2. After extracting the zip file, execute the RoboMongo.exe, and you will find the screen as below:

3. To connect a MongoDB, we need to provide connection string. For the same, we need to click on Create link and we get a screen as follows:

4. After providing Connection Name, Address and Port for a database as highlighted. We provide user name and password in Authentication tab, and test the connection. It will look as follows:

5. After selecting the connection string and click connect.

6. Once connected, we will see the DB listed in MongoDB, as follows:

The ICACLS Command

The icacls command enables a user to view and modify the ACLs(Access Control List) of a file. The icacls command is an external command and is available in the below Microsoft operating systems as icacls.exe.

Windows Vista

Windows 7

Windows 8

Windows 10

The Icacls command help can be found by using : icacls /?

ICACLS name /save aclfile [/T] [/C] [/L] [/Q]

    stores the DACLs for the files and folders that match the name

    into aclfile for later use with /restore. Note that SACLs,

    owner, or integrity labels are not saved.

ICACLS directory [/substitute SidOld SidNew [...]] /restore aclfile

                 [/C] [/L] [/Q]

    applies the stored DACLs to files in directory.

ICACLS name /setowner user [/T] [/C] [/L] [/Q]

    changes the owner of all matching names. This option does not

    force a change of ownership; use the takeown.exe utility for

    that purpose.

ICACLS name /findsid Sid [/T] [/C] [/L] [/Q]

    finds all matching names that contain an ACL

    explicitly mentioning Sid.

ICACLS name /verify [/T] [/C] [/L] [/Q]

    finds all files whose ACL is not in canonical form or whose

    lengths are inconsistent with ACE counts.

ICACLS name /reset [/T] [/C] [/L] [/Q]

    replaces ACLs with default inherited ACLs for all matching files.

ICACLS name [/grant[:r] Sid:perm[...]]

       [/deny Sid:perm [...]]

       [/remove[:g|:d]] Sid[...]] [/T] [/C] [/L] [/Q]

       [/setintegritylevel Level:policy[...]]

    /grant[:r] Sid:perm grants the specified user access rights. With :r,

        the permissions replace any previouly granted explicit permissions.

        Without :r, the permissions are added to any previously granted

        explicit permissions.

    /deny Sid:perm explicitly denies the specified user access rights.

        An explicit deny ACE is added for the stated permissions and

        the same permissions in any explicit grant are removed.

    /remove[:[g|d]] Sid removes all occurrences of Sid in the ACL. With

        :g, it removes all occurrences of granted rights to that Sid. With

        :d, it removes all occurrences of denied rights to that Sid.

    /setintegritylevel [(CI)(OI)]Level explicitly adds an integrity

        ACE to all matching files.  The level is to be specified as one

        of:

            L[ow]

            M[edium]

            H[igh]

        Inheritance options for the integrity ACE may precede the level

        and are applied only to directories.

    /inheritance:e|d|r

        e - enables inheritance

        d - disables inheritance and copy the ACEs

        r - remove all inherited ACEs

Note:

    Sids may be in either numerical or friendly name form. If a numerical

    form is given, affix a * to the start of the SID.

    /T indicates that this operation is performed on all matching

        files/directories below the directories specified in the name.

    /C indicates that this operation will continue on all file errors.

        Error messages will still be displayed.

    /L indicates that this operation is performed on a symbolic link

       itself versus its target.

    /Q indicates that icacls should supress success messages.

    ICACLS preserves the canonical ordering of ACE entries:

            Explicit denials

            Explicit grants

            Inherited denials

            Inherited grants

    perm is a permission mask and can be specified in one of two forms:

        a sequence of simple rights:

                N - no access

                F - full access

                M - modify access

                RX - read and execute access

                R - read-only access

                W - write-only access

                D - delete access

        a comma-separated list in parentheses of specific rights:

                DE - delete

                RC - read control

                WDAC - write DAC

                WO - write owner

                S - synchronize

                AS - access system security

                MA - maximum allowed

                GR - generic read

                GW - generic write

                GE - generic execute

                GA - generic all

                RD - read data/list directory

                WD - write data/add file

                AD - append data/add subdirectory

                REA - read extended attributes

                WEA - write extended attributes

                X - execute/traverse

                DC - delete child

                RA - read attributes

                WA - write attributes

        inheritance rights may precede either form and are applied

        only to directories:

                (OI) - object inherit

                (CI) - container inherit

                (IO) - inherit only

                (NP) - don't propagate inherit

                (I) - permission inherited from parent container

Examples:

        icacls c:\windows\* /save AclFile /T

        - Will save the ACLs for all files under c:\windows

          and its subdirectories to AclFile.

        icacls c:\windows\ /restore AclFile

        - Will restore the Acls for every file within

          AclFile that exists in c:\windows and its subdirectories.

        icacls file /grant Administrator:(D,WDAC)

        - Will grant the user Administrator Delete and Write DAC

          permissions to file.

        icacls file /grant *S-1-1-0:(D,WDAC)

        - Will grant the user defined by sid S-1-1-0 Delete and

          Write DAC permissions to file.

How To Control Running Services With The SC Command [Windows]

The "sc" command comes with numerous sub-commands. A list can be seen by entering "sc /?" into a command prompt. Altogether, 24 sub-commands are listed. Each sub-command in turn may have a subset of different commands. The table below shows a selection of the sub-commands and their functions that are of most relevance to a typical PC owner.

Command	Function
sc config	Configures service startup and login accounts
sc continue	Resumes a paused service
sc enumdepend	Lists the services that cannot run unless the specified service is running
sc failure	Specifies what action to take upon failure of the service
sc pause	Pauses a service
sc qc	Displays the configuration of a particular service
sc query	Displays information about the specified service, driver, type of service, or type of driver
sc start	Starts a service running
sc stop	Sends a STOP request to a service (not all will respond)

CRUD Operation in MongoDB

1. Open a Windows Command Prompt.

2. Write mongo in the console and hit <<enter>>.

3. You will see your console as below:

4. You see a test database connected.

5. Type “db” to find the current database, and it will be“test” database.

6. Use, “cls” or “ctrl-l” to clean the screen.

7. Switch from one database to another: “use <<dbname>>” command.

8. If we use a command “use avinash”, in the same console, then it will go to the “avinash” database.

9. To see the list of databases, write following command:

 “show databases”

10. In mongo db, data is stored in collection, in the format of document. To show the list of collections in a database, write the following command:

 “show collections”

11.To insert a document in a collection named: “avi”, write the following command:

"db.avi.insert({ name:”avinash”, location:”bangalore”})"

12. To find a document inserted into a collection, write the following command:
"db.avi.find()"

"db.avi.find({“_id :1”})"

13. To modify a document, write the following command:
"db.avi.save({“_id”:1, pincode: 844502})"

Note: If you use save , then it will modify the complete document with the new details provided by save command.

14. Hence, to update the document , use the following update command:
"db.avi.update{{_id:1}, { $set : { name: “avinash”}})"

15. To remove a document from a collection, write the following remove command:
"db.avi.remove({_id:1})"

16. To remove a collection from a db, write the following drop command:
"db.avi.drop()"

17. To drop a database, write the following drop-database command:
"db.dropdatabase()"

How to Install MongoDB like a Pro

1. Go to the URL : https://www.mongodb.com/download-center/community/releases/archive

2. Select  Software for your computer e.g: for Windows , shown below

 3. Select a binary in .zip format , from the link:

4. Download it into a repository, and extract it into an installation directory.

5. Create data directories for installation:

1. D:/Mongo/Data – for data files
2. D:/Mongo/Log – for log files
3. D:/Mongo/Config – for configuration files

6. Create a configuration file- [mongod.conf] and paste the content below:

storage:

   dbPath: "C:/Mongo/Data"

systemLog:

   destination: file

   path: "C:/Mongo/Log/mongod.log"

Note: it must be in YAML format that is 3 space from left end.

7. We need to give user(a service account) full access to this installation directory, form the same we will use this command:

Icacls d:\mongo /grant Avinash:(OI)(CI)F

8. Now, install mongo db as service on windows server , using command:

mongod --install --config d:\mongo\config\mongod.conf --serviceUser Avinash --servicePassword ******* 

9. Now, we will verify whether it is installed or not.

sc qc mongodb

10. We will start the mongodb service now, by running the command:

net start mongodb

11. Create a db:

 use my_test_db

12. Create a user:

db.createUser(

  {

    user: "avinashthakur",

    pwd: "Bangalore#12345",

    roles: [

       { role: "readWrite", db: "my_test_db" },

       { role: "readWrite", db: "test" },

       { role: "readWrite", db: "admin" }       

    ]

  }

)

13.It is ready to use. You may follow my other article for CRUD operation in Mongodb

JavaScript Full-Stack Development

JavaScript has come a long way since being released back in 1995. We've seen several major versions of the ECMAScript specification and the rise of single-page applications (SPAs), all powered by client side JavaScript frameworks. Initially, all JavaScript development and innovation was done in the browser because that was the only context that supported the language. As time passed, web developers started to realize that many of JavaScript's most useful features (non-blocking, event-driven) could be leveraged in environments other than the browser. This kick-started a second round of innovation in the JavaScript community that resulted in JavaScript running on servers and on databases.

In full-stack development, the developer needs to develop for every single layer of a software. Thus a full-stack developer is a person who is comfortable working with all the technologies required to get an idea to a finished product.

An Ideal full-stack developer has the capability to developing web application and websites on the front-end and at the same time is skilled to work with databases and servers on the back-end. Thus a full-stack developer designs and implements for all the layers in a given full-fledged application.

But full-stack is not only about knowing how to code in front-end and back-end. It also includes:

•  Project management and team leading.
• Creating and using APIs.
• Knowing how to properly document a project.
• Having experience in the industry and knowing its ins and outs.
• Knowing and understanding hardware and what works with what.
• Writing optimized code, and knowing when to sacrifice optimization for the sake of comprehensibility.
• Creating, manipulating and querying databases.

Knowing JavaScript doesn't automatically box you as a "front-end developer." If you know the language well, you can build servers and databases, in addition to front-end user experiences. Now, for the first time, developers can build an entire web application using only JavaScript. This trend is often called "full-stack JavaScript." 

Combining four popular JavaScript technologies: MongoDB, Express, AngularJS, and Node.js to create production-grade applications has become so popular that it’s been dubbed the “MEAN stack.”