Hack The Sec-Leading Resource Of Linux Tutorial

How to Install phpPgAdmin on CentOS & RHEL

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000; font-family: "roboto slab";"><span style="font-size: 28px; line-height: 38px;"><u>phpPgAdmin on CentOS & RHEL</u></span></span></h2>
<div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="font-family: 'roboto slab'; font-size: 16px; line-height: 28px;">
<br /></div>
<span style="font-size: 15px; line-height: 26px; text-align: justify;"><span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><b>phpPgAdmin </b>is web-based client written in php for accessing and managing PostgreSQL databases. It provides very efficient way to work with databases on <a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html">PostgreSQL like</a>, create database, table, alter database, export/import database etc.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjubzL5qW053K-gze_-nRvH_EzuFcyPbPzRey0yqJ6JwUgXQdyfRwnMFYsmPmNb4DCIQ2qRaUdk_6VltmVGLt1JOXj_vm1Oo5pHz-AUByWI_SVPrJU4ZRrzIwN9xYHqBKo6xMa3cKDKFEEI/s1600/pg9_pgadmin_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="401" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjubzL5qW053K-gze_-nRvH_EzuFcyPbPzRey0yqJ6JwUgXQdyfRwnMFYsmPmNb4DCIQ2qRaUdk_6VltmVGLt1JOXj_vm1Oo5pHz-AUByWI_SVPrJU4ZRrzIwN9xYHqBKo6xMa3cKDKFEEI/s640/pg9_pgadmin_www.hackthesec.co.in.png" width="640" /></a></div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">This article will help you to install phpPgAdmin on <a href="http://www.hackthesec.co.in/search/label/Centos">CentOS</a> and <a href="http://www.hackthesec.co.in/search/label/RHEL">RedHat</a> Systems. Before installing it make sure you have <a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a> and PostgreSQL installed on server. </span></span></div>
</div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul style="text-align: left;">
<li><span style="font-family: "roboto slab"; line-height: 28px;"><span style="color: red; font-size: large;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" target="_blank">How to Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22</a></span></span></li>
<li><span style="font-family: "roboto slab"; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-phpmyadmin-on-centos-7.html" target="_blank"><span style="color: red; font-size: large;">How to install phpmyadmin on centos 7</span></a></span></li>
</ul>
<br />
<h2 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><u>Step 1: Add PostgreSQL Repository</u></span></h2>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Install postgres repository in your system, Download repository rpm using one of below urls.</span></span><span style="font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px; text-align: justify;"> </span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: lime;">CentOS/RHEL 5, 32-Bit:</span><span style="color: white;">
# wget http://yum.postgresql.org/9.1/redhat/rhel-5-i386/pgdg-centos91-9.1-4.noarch.rpm

</span><span style="color: lime;">CentOS/RHEL 6, 32-Bit:</span><span style="color: white;">
# wget http://yum.postgresql.org/9.1/redhat/rhel-6-i386/pgdg-centos91-9.1-4.noarch.rpm

</span><span style="color: lime;">CentOS/RHEL 5, 64-Bit:</span><span style="color: white;">
# wget http://yum.postgresql.org/9.1/redhat/rhel-5.0-x86_64//pgdg-centos91-9.1-4.noarch.rpm

</span><span style="color: lime;">CentOS/RHEL 6, 64-Bit:</span><span style="color: white;">
# wget http://yum.postgresql.org/9.1/redhat/rhel-6.3-x86_64/pgdg-centos91-9.1-4.noarch.rpm</span><span style="color: white; font-size: 0.9em;">
</span></pre>
<h5 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><u>Step 2: Install phpPgAdmin using Yum</u></span></h5>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Install phpPgAdmin package using yum command line tool.</span></span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 15.21px;">yum install phpPgAdmin httpd</span><span style="line-height: 1.3em;">
</span></span></pre>
<h5 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><u>Step 3: Configure phpPgAdmin to Access Remotly.</u></span></h5>
<div>
<span style="color: #0b5394;"></span><br />
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
<span style="color: #0b5394;"><strong style="box-sizing: border-box;">Note:</strong> phpPgAdmin is case sensitive. Use upper and lower cases properly as shown in the above command.</span></div>
<span style="color: #0b5394;">
</span>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
<span style="color: #0b5394;">By default, you can access phppgadmin using <strong style="box-sizing: border-box;">http://localhost/phpPgAdmin</strong> from your local system only. To access remote systems, do the following.</span></div>
<span style="color: #0b5394;">
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Edit file <strong style="box-sizing: border-box;">/etc/httpd/conf.d/phpPgAdmin.conf</strong>:</div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;"><span style="line-height: 15.21px;">vi /etc/httpd/conf.d/phpPgAdmin.conf</span></span><span style="line-height: 1.3em;"> </span></span></pre>
</span></div>
<h5 class="heading1" style="background-color: white; border: 0px; font-family: 'roboto slab'; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; font-weight: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">[...]
Alias /phpPgAdmin /usr/share/phpPgAdmin
<Location /phpPgAdmin>
    <IfModule mod_authz_core.c>
        # Apache 2.4
        Require all granted
        #Require host example.com
    </IfModule>
    <IfModule !mod_authz_core.c>
        # Apache 2.2
        Order deny,allow
        Allow from all
        # Allow from .example.com
    </IfModule>
</Location></pre>
</span></h5>
<h5 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><u>Step 4: Restart Apache Service</u></span></h5>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Restart Apache service to reload new settings.</span></span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;"># service </span><span style="color: lime;">httpd</span><span style="color: white;"> restart
</span></span></pre>
<h5 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"></span></h5>
<h2 style="box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 38px; margin: 30px 0px 20px; text-align: justify;">
<span style="color: #0b5394; font-size: x-large;"><u>Step 5 : Configure phpPgAdmin</u></span></h2>
<h2 style="box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 38px; margin: 30px 0px 20px; text-align: justify;">
<span style="background-color: white; color: #222222; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">Edit file </span><strong style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">/etc/phpPgAdmin/config.inc.php</strong><span style="background-color: white; color: #222222; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">, and do the following changes. Most of these options are self-explanatory. Read them carefully to know why do you change these values.</span></h2>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">vi /etc/phpPgAdmin/config.inc.php</span></span></pre>
</div>
<div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Find the following line:</div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">$conf['servers'][0]['host'] = '';</pre>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Change it as shown below:</div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">$conf['servers'][0]['host'] = 'localhost';</pre>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
And find the line:</div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">$conf['extra_login_security'] = true;</pre>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Change the value to <strong style="box-sizing: border-box;">false</strong>:</div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">$conf['extra_login_security'] = false;</pre>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Find the line:</div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">$conf['owned_only'] = false;</pre>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Set the value as <strong style="box-sizing: border-box;">true</strong>.ru</div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">$conf['owned_only'] = true;</pre>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
<b>Save and close the file. Restart postgresql service and Apache services.</b></div>
<h5 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 17px; font-weight: 400; line-height: 25px; margin: 21px 0px 11px; text-align: justify;">
On CentOS 6.x systems:</h5>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">service postgresql-9.5 restart
service httpd restart</span></span></pre>
</div>
<h5 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 17px; font-weight: 400; line-height: 25px; margin: 21px 0px 11px; text-align: justify;">
On CentOS 7 systems:</h5>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">systemctl restart postgresql-9.5
systemctl restart httpd</span></span></pre>
</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Now open your browser and navigate to <strong style="box-sizing: border-box;">http://ip-address/phpPgAdmin</strong>. </div>
</div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>
</div>
</div>

How to Install phpPgAdmin on CentOS & RHEL

phpPgAdmin on CentOS & RHEL phpPgAdmin is web-based client written in php for accessing and managing PostgreSQL databases. It pro...

How to Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000; font-family: roboto slab;"><span style="line-height: 38px;">Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22</span></span></h2>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>PostgreSQL 9.5</b> Released. <b>PostgreSQL </b>is an open source object-relational, highly scalable, SQL compliant database management system. PostgreSQL is developed at the University of California at Berkeley Computer Science Department. This article will help you for installing PostgreSQL on <a href="http://www.hackthesec.co.in/search/label/Centos">CentOS</a>, <a href="http://www.hackthesec.co.in/search/label/RHEL">RHEL</a> and <a href="http://www.hackthesec.co.in/search/label/Fedora">Fedora</a> Systems.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-JpbfplbC6uMpPvfV0gewSyc7HNkMy8MAvzobA58RZt-2vsfLk8TLLiptFVBQJjheb0pUkhWPe7iqyEHCZI35rABX7ZsqfCWFL1M9pQkbMk5vj3uoSAFcRrncH6Lf54wMlKUtgzlByhae/s1600/postgresql_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-JpbfplbC6uMpPvfV0gewSyc7HNkMy8MAvzobA58RZt-2vsfLk8TLLiptFVBQJjheb0pUkhWPe7iqyEHCZI35rABX7ZsqfCWFL1M9pQkbMk5vj3uoSAFcRrncH6Lf54wMlKUtgzlByhae/s1600/postgresql_www.hackthesec.co.in.png" /></a></div>
<h2 class="title single-title title20" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="font-size: 24px; font-weight: bolder; line-height: 34px;"><span style="color: #0b5394;"><u>Adding PostgreSQL Yum Repository</u></span></span></h2>
<div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">First step is to install PostgreSQL repository in your system, Use one of below commands as per your system architecture and operating system.</span></span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><orange><span style="color: lime;">CentOS/RHEL 7</span></orange><span style="color: white;">
# rpm -Uvh http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm

</span><orange><span style="color: lime;">CentOS/RHEL 6</span></orange><span style="color: white;">
# rpm -Uvh http://yum.postgresql.org/9.5/redhat/rhel-6-x86_64/pgdg-redhat95-9.5-2.noarch.rpm

</span><orange><span style="color: lime;">CentOS/RHEL 5</span></orange><span style="color: white;">
# rpm -Uvh http://yum.postgresql.org/9.5/redhat/rhel-5-x86_64/pgdg-redhat95-9.5-2.noarch.rpm

</span><orange><span style="color: lime;">Fedora 23:</span></orange><span style="color: white;">
# rpm -Uvh http://yum.postgresql.org/9.5/fedora/fedora-23-x86_64/pgdg-fedora95-9.5-3.noarch.rpm

</span><orange><span style="color: lime;">Fedora 22</span></orange><span style="color: white;">
# rpm -Uvh http://yum.postgresql.org/9.5/fedora/fedora-22-x86_64/pgdg-fedora95-9.5-3.noarch.rpm

</span><orange><span style="color: lime;">Fedora 21</span></orange><span style="color: white;">
# rpm -Uvh http://yum.postgresql.org/9.5/fedora/fedora-21-x86_64/pgdg-fedora95-9.5-2.noarch.rpm</span></pre>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">For more details visit <a href="http://yum.postgresql.org/repopackages.php">PostgreSQL repositories link</a> page where you can get repository package rpm for various operating systems.</span></span></div>
</div>
<div style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-size: 24px; font-weight: bolder; line-height: 34px;"><span style="color: #0b5394;"><u>Installing PostgreSQL Server</u></span></span></div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After enabling PostgreSQL yum repository in your system use following command to install PostgreSQL 9.5 on your system with yum package manager.</span></span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;"># yum </span><orange><span style="color: lime;">install</span></orange><span style="color: white;"> postgresql95-server postgresql95
</span></span></pre>
<h5 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><u>Initializing PGDATA</u></span></h5>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After installing PostgreSQL server, It’s required to initialize it before using first time. To initialize database use below command.</span></span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 1.3em;"># /usr/pgsql-9.5/bin/postgresql95-setup </span><orange style="line-height: 1.3em;"><span style="color: lime;">initdb</span></orange><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; line-height: 26px; white-space: normal;">
</span></span></pre>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Above command will take some time to initialize PostgreSQL first time. PGDATA environment variable contains the path of data directory.</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="color: #222222;">PostgreSQL data directory Path: </span><b><span style="color: #990000;">/var/lib/pgsql/9.5/data/</span></b></span></span></div>
</div>
<h5 class="heading1" style="background-color: white; border: 0px; font-family: 'roboto slab'; font-size: 24px; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><u>Start PostgreSQL Server</u></span></h5>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">To start PostgreSQL service using following command as per your operating systems. Also enable PostgreSQL service to auto start on system boot.</span></span></div>
</div>
<div style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">For CentOS/RHEL 7 and Fedora 23</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;"># systemctl start </span><span style="color: lime;">postgresql</span><span style="color: white;">-9.5
# systemctl enable </span><span style="color: lime;">postgresql</span><span style="color: white;">-9.5</span></span><span style="color: white; font-size: 0.9em;">
</span></pre>
<div style="border: 0px; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="background-color: white; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">For CentOS/RHEL 6/5 and Fedora 22/21</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"># service  postgresql-9.5 start
# chkconfig postgresql-9.5 on</span><span style="font-size: 0.9em;">
</span></pre>
<h5 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;"><u>Verify PostgreSQL Installation</u></span></h5>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After completing above steps, you have installed PostgreSQL 9.5 on your server, Let’s login to postfix to verify that installation completed successfully.</span></span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"># su - postgres</span></pre>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Use psql command to access PostgreSQL prompt with admin privileges.</span></span></div>
</div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">$ </span><orange><span style="color: lime;">psql</span></orange><span style="color: white;">

psql (9.5.0)
Type "help" for help.

postgres=#</span></span></pre>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">You may create password for user postgres for security purpose</span></span><span style="color: #111111; font-family: Roboto, sans-serif; font-size: 17px; line-height: 25px; text-align: justify;">:</span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">postgres=# </span><orange><span style="color: lime;">\password postgres</span></orange></span></pre>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">You have successfully installed PostgreSQL Server</span></span><span style="color: #111111; font-family: Roboto, sans-serif; font-size: 17px; line-height: 25px; text-align: justify;">:</span></div>
<span style="color: #0b5394; font-family: roboto slab; font-size: large;"><span style="line-height: 28px;"><u><b>Adjust Iptables/Firewall</b></u></span></span><br />
<span style="text-align: justify;"><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Next, adjust iptables to access postgresql from remote systems.</span></span></span><span style="color: #111111; font-family: Roboto, sans-serif; font-size: 17px; line-height: 25px; text-align: justify;">On CentOS 6.x systems:</span><br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">vi /etc/sysconfig/iptables</span></span></pre>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">Add the following line:</span><br />
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">-A INPUT -m state --state NEW -m tcp -p tcp --dport 5432 -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 80 -j ACCEPT</pre>
<div style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px; text-align: justify;">
Save and exit the file. Restart iptables service.</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">service iptables restart</span></span></pre>
<h5 style="box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 17px; font-weight: 400; line-height: 25px; margin: 21px 0px 11px; text-align: justify;">
On CentOS 7 systems:</h5>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">firewall-cmd --permanent --add-port=5432/tcp
firewall-cmd --permanent --add-port=80/tcp
firewall-cmd --reload</span></span></pre>
<h2 style="box-sizing: border-box; margin: 30px 0px 20px; text-align: justify;">
<span style="color: #0b5394; font-family: Roboto, sans-serif; font-size: large;"><span style="line-height: 38px;"><u>Adjust SELinux</u></span></span></h2>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Run the following command to make PostgreSQL work if SELinux enabled on your system.</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">setsebool -P httpd_can_network_connect_db 1</span></span></pre>
</div>
<div style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; margin-bottom: 26px;">
You may not login to PostegreSQL if you didn’t run the above command.</div>
<h2 style="box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 38px; margin: 30px 0px 20px; text-align: justify;">
<span style="color: #0b5394; font-size: large;"><u>Create New User and Database</u></span><br /><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">For example, let us create a new user called </span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">"payel</span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">"</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;"> with password </span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">"centos"</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">, and database called </span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">"sitedb"</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">.</span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">Switch to postgres user:</span></h2>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">su - postgres</span></span></pre>
</div>
<h2 style="box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 38px; margin: 30px 0px 20px; text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">Create user </span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">payel</span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px;">.</span></h2>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">createuser payel</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">Create database:</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">createdb sitedb</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">Now, login to the psql prompt, and set password and Grant access to the database </span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">sitedb</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;"> for </span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">payel</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">:</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">psql</span></span></pre>
</div>
<div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">psql (9.5.0)
Type "help" for help.
postgres=# alter user payel with encrypted password 'centos';
ALTER ROLE
postgres=# grant all privileges on database sitedb to payel;
GRANT
postgres=#</pre>
</div>
<div>
<h2 style="box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 38px; margin: 30px 0px 20px; text-align: justify;">
<span style="color: #0b5394; font-size: large;"><u>Delete Users and Databases</u></span></h2>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">To delete the database, switch to postgres user:</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">su - postgres</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">Enter command:</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">$ dropdb <database-name></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">To delete a user, enter the following command:</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">$ dropuser <user-name></span></span></pre>
</div>
<div>
<h2 style="box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 38px; margin: 30px 0px 20px; text-align: justify;">
<span style="color: #0b5394; font-size: large;"><u>Configure PostgreSQL-MD5 Authentication</u></span></h2>
</div>
<div>
<strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">MD5 authentication</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;"> requires the client to supply an MD5-encrypted password for authentication. To do that, edit </span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">/var/lib/pgsql/9.5/data/pg_hba.conf</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;"> file:</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">vi /var/lib/pgsql/9.5/data/pg_hba.conf</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">Add or Modify the lines as shown below</span></div>
<div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;"><pre style="background-color: #f1f1f1; border-radius: 0px; border: none; box-sizing: border-box; color: #222222; font-family: monospace, monospace; font-size: 15px; line-height: 26px; margin-top: 24px; overflow: auto; padding: 4px 10px;">[...]
# TYPE  DATABASE        USER            ADDRESS                 METHOD
# "local" is for Unix domain socket connections only
local   all             all                                     md5
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
host    all             all             192.168.1.0/24          md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
[...]</pre>
</pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;"><b>Restart postgresql service to apply the changes:</b></span></div>
<div>
<h5 style="box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 17px; font-weight: 400; line-height: 25px; margin: 21px 0px 11px; text-align: justify;">
On CentOS 6.x systems:</h5>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">service postgresql-9.5 restart</span></span></pre>
</div>
<div>
<h5 style="box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 17px; font-weight: 400; line-height: 25px; margin: 21px 0px 11px; text-align: justify;">
On CentOS 7 systems:</h5>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">systemctl restart postgresql-9.5</span></span></pre>
</div>
<div>
<h2 style="box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 38px; margin: 30px 0px 20px; text-align: justify;">
<span style="color: #0b5394; font-size: large;"><u>Configure PostgreSQL-Configure TCP/IP</u></span></h2>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">By default, TCP/IP connection is disabled, so that the users from another computers can’t access postgresql. To allow to connect users from another computers, Edit file</span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">/var/lib/pgsql/9.5/data/postgresql.conf</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">:</span></div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">vi /var/lib/pgsql/9.5/data/postgresql.conf</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">Find the lines:</span></div>
<div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">[...]
#listen_addresses = 'localhost'
[...]
#port = 5432
[...]</pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">Uncomment both lines, and set the IP address of your postgresql server or set </span><strong style="box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;">‘*’</strong><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;"> to listen from all clients as shown below:</span></div>
<div>
<pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; font-stretch: normal; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; white-space: pre-wrap; word-break: break-all; word-wrap: break-word;">listen_addresses = '*'
port = 5432</pre>
</div>
<div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: justify;"><b>Restart postgresql service to apply the changes:</b></span></div>
<div>
<h5 style="box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 17px; font-weight: 400; line-height: 25px; margin: 21px 0px 11px; text-align: justify;">
On CentOS 6.x systems:</h5>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">service postgresql-9.5 restart</span></span></pre>
</div>
<div>
<h5 style="box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 17px; font-weight: 400; line-height: 25px; margin: 21px 0px 11px; text-align: justify;">
On CentOS 7 systems:</h5>
</div>
<div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 16.9px;">systemctl restart postgresql-9.5</span></span></pre>
</div>
</div>
<div>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>
<div style="background-color: white; border: 0px; font-family: 'roboto slab'; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul style="text-align: left;">
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-install-phppgadmin-on-centos-rhel.html" style="-webkit-transition: all 0.25s linear; outline: none; text-decoration: none; transition: all 0.25s linear;" target="_blank"><span style="color: red; font-size: large;">How to Install phpPgAdmin on CentOS using Yum</span></a></li>
</ul>
</div>
</div>

How to Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22

Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22 PostgreSQL 9.5 Released. PostgreSQL is an open source object-relational, h...

How to Install MongoDB on CentOS 7

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="border: 0px; font-family: Verdana, Geneva, sans-serif; line-height: 19.2000007629395px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h1 class="entry-title" style="background-color: white; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; box-sizing: inherit; color: black; font-family: proxima-nova, sans-serif; font-weight: 400; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<b style="background-color: transparent; font-family: Georgia, 'Times New Roman', serif; font-size: large; line-height: 28px;">MongoDB</b><span style="background-color: transparent; color: #333333; font-family: Georgia, 'Times New Roman', serif; font-size: medium; line-height: 28px;"> is a <b>NoSQL database</b> intended for storing large amounts of data in document-oriented storage with dynamic schemas. NoSQL refers to a database with a data model other than the tabular format used in relational databases such as MySQL, PostgreSQL, and Microsoft SQL. MongoDB features include: full index support, replication, high availability, and auto-sharding.</span></h1>
<div>
<ul style="background-color: white; font-size: 12px; line-height: 19.2000007629395px;">
<li><span style="font-family: georgia, 'times new roman', serif; line-height: 28px;"><span style="font-size: medium; text-decoration: none;"><a href="http://www.hackthesec.co.in/2016/01/install-mongodb-244-on-fedora-1817.html" style="text-decoration: none;" target="_blank"><span style="color: red;">Install MongoDB 2.4.4 on Fedora 18/17, CentOS/Red Hat (RHEL) 6.4/5.9</span></a></span></span></li>
<li style="color: #333333;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-mongodb-32-on-ubuntu.html" style="color: #999999; line-height: 28px; text-decoration: none;" target="_blank"><span style="color: red; font-size: medium;">How to Install MongoDB 3.2 on Ubuntu 14.04, 12.04 and Debian 7</span></a></li>
</ul>
</div>
<div class="separator" style="clear: both; color: #333333; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7gaIANrdIvsqhNht8owz9p7Tbv2eM-xWNyg2KPWD-fXYRIeEMelqUQziD1iA1IQmM7y3BCabz7bWFDIDbES-9PRTZNv26jUa1HN27CROEmLDgW7DNRdPlTGqx-LiWub58g-Hh-69YSyo8/s1600/mongoDB_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7gaIANrdIvsqhNht8owz9p7Tbv2eM-xWNyg2KPWD-fXYRIeEMelqUQziD1iA1IQmM7y3BCabz7bWFDIDbES-9PRTZNv26jUa1HN27CROEmLDgW7DNRdPlTGqx-LiWub58g-Hh-69YSyo8/s1600/mongoDB_www.hackthesec.co.in.png" /></a></div>
<div style="color: #333333;">
<span style="background-color: transparent; color: #333333; font-family: Georgia, 'Times New Roman', serif; font-size: medium; line-height: 28px;"><br /></span></div>
</div>
<div style="border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h1 class="entry-title" style="background-color: white; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; box-sizing: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<b style="background-color: transparent;"><span style="color: #0b5394; font-family: Roboto Slab;"><span style="font-size: 24px; line-height: 34px;">Step 1: Add the MongoDB Repository</span></span></b></h1>
<div>
<span style="background-color: white;"><span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Nano Editor is the best for editing i think so i always use nano editor so you can use any kind of editor does not matter.</span></span></span></div>
</div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">[root@hackthesec]# touch /etc/yum.repos.d/mongodb.repo
[root@hackthesec]# nano /etc/yum.repos.d/mongodb.repo</span></span></pre>
<br />
<div style="border: 0px; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2000007629395px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<br />
<div style="border: 0px; margin-bottom: 20px; orphans: auto; outline: 0px; padding: 0px; text-align: left; text-indent: 0px; vertical-align: baseline; widows: 1;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">If you are running a 64-bit system, add the following information to the file you’ve created, using i to insert:</span></span></div>
<div style="border: 0px; margin-bottom: 20px; orphans: auto; outline: 0px; padding: 0px; text-align: left; text-indent: 0px; vertical-align: baseline; widows: 1;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">[mongodb]
name=MongoDB Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64/
gpgcheck=0
enabled=1</span></span></pre>
<div style="border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Then exit and save the file with the command :</span></span><span style="color: #333333; font-family: Georgia, 'Times New Roman', serif; font-size: medium; line-height: 19.2000007629395px;"><span style="line-height: 28px;">Ctrl+X after that Y after that Enter Button</span></span></div>
<div style="border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">If you are running a 32-bit system, add the following information to the file you’ve created, using i to insert:</span></span></div>
<div style="border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">[mongodb]
name=MongoDB Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/i686/
gpgcheck=0
enabled=1</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Then exit and save the file with the command :</span></span><span style="color: #333333; font-family: Georgia, 'Times New Roman', serif; font-size: medium; line-height: 19.2000007629395px;"><span style="line-height: 28px;">Ctrl+X after that Y after that Enter Button</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h1 class="entry-title" style="background-color: white; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; box-sizing: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #0b5394; font-family: Roboto Slab;"><span style="font-size: 24px; line-height: 34px;">Step 2: Install MongoDB</span></span></h1>
<div>
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">As a matter of best practice we’ll update our packages:</span></span></div>
</div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">[root@hackthesec]# yum -y update</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">At this point, installing MongoDB is as simple as running just one command:</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">[root@hackthesec.co.in]# yum -y install mongodb-org mongodb-org-serve</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<h1 class="entry-title" style="background-color: white; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; box-sizing: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #0b5394; font-family: Roboto Slab;"><span style="font-size: 24px; line-height: 34px;">Step 3: Get MongoDB Running</span></span></h1>
</div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Start-Up MongoDB</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">systemctl start mongod</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Check MongoDB Service Status</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">systemctl status mongod</span></span></pre>
<div>
<span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;"><br /></span></span></div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Summary List of Status Statistics (Continuous)</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">mongostat</span></span></pre>
</div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Summary List of Status Statistics (5 Rows, Summarized Every 2 Seconds)</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">mongostat --rowcount 5 2</span></span></pre>
</div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Enter the MongoDB Command Line</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">mongo</span></span></pre>
</div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">By default, running this command will look for a MongoDB server listening on port 27017 on the localhost interface.</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">If you’d like to connect to a MongoDB server running on a different port, then use the –port option. For example, if you wanted to connect to a local MongoDB server listening on port 22222, then you’d issue the following command:</span></span></div>
</div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">mongo --port 22222</span></span></pre>
</div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: Georgia, Times New Roman, serif; font-size: medium;"><span style="line-height: 28px;">Shutdown MongoDB</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">systemctl stop mongod</span></span></pre>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;"><a href="http://www.hackthesec.co.in/" target="_blank">Hack The Security</a>
<a href="https://www.twitter.com/hackthesecurity" target="_blank">Hack The Security Twitter</a></span></span></pre>
</div>
<div>
<span style="color: white; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;"><br /></span></span></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

How to Install MongoDB on CentOS 7

MongoDB is a NoSQL database intended for storing large amounts of data in document-oriented storage with dynamic schemas. NoSQL refers ...

Install MongoDB 2.4.4 on Fedora 18/17, CentOS/Red Hat (RHEL) 6.4/5.9

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: initial; background-repeat: initial; background-size: initial; border: 0px; color: #333333; font-family: Roboto, cursive; font-size: 26px; line-height: 1em; margin: 0px; outline: 0px; padding: 0px 0px 10px; vertical-align: baseline;">
<b style="background-color: white; color: #0b5394; font-family: 'Roboto Slab'; font-size: 24px; line-height: 34px;">What is MongoDB?</b></h1>
<div>
<div style="background-color: white;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
MongoDB (from “humongous”) is a scalable, high-performance, open source, schema-free, document-oriented database. Written in C++. MongoDB bridges the gap between key-value stores (which are fast and highly scalable) and traditional RDBMS systems (which provide structured schemas and powerful queries).</div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<ul style="text-align: left;">
<li><span style="color: red; font-family: verdana, geneva, sans-serif; font-size: large; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-mongodb-on-centos-7.html" target="_blank">How to Install MongoDB On Centos 7</a></span></li>
<li><span style="font-family: "verdana" , "geneva" , sans-serif; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-mongodb-32-on-ubuntu.html" target="_blank"><span style="color: red; font-size: large;">How to Install MongoDB 3.2 on Ubuntu 14.04, 12.04 and Debian 7</span></a></span><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7gaIANrdIvsqhNht8owz9p7Tbv2eM-xWNyg2KPWD-fXYRIeEMelqUQziD1iA1IQmM7y3BCabz7bWFDIDbES-9PRTZNv26jUa1HN27CROEmLDgW7DNRdPlTGqx-LiWub58g-Hh-69YSyo8/s1600/mongoDB_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7gaIANrdIvsqhNht8owz9p7Tbv2eM-xWNyg2KPWD-fXYRIeEMelqUQziD1iA1IQmM7y3BCabz7bWFDIDbES-9PRTZNv26jUa1HN27CROEmLDgW7DNRdPlTGqx-LiWub58g-Hh-69YSyo8/s1600/mongoDB_www.hackthesec.co.in.png" /></a></li>
</ul>
</div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
MongoDB is very interesting document-oriented database, because it has really awesome features:</div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<ul style="text-align: left;">
<li>Document-oriented storage (the simplicity and power of JSON-like data schemas)</li>
<li>Dynamic queries</li>
<li>Full index support, extending to inner-objects and embedded arrays</li>
<li>Query profiling</li>
<li>Fast, in-place updates</li>
<li>Efficient storage of binary data large objects (e.g. photos and videos)</li>
<li>Replication and fail-over support</li>
<li>Auto-sharding for cloud-level scalability</li>
<li>MapReduce for complex aggregation</li>
<li>Commercial Support, Training, and Consulting</li>
</ul>
</div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
This guide shows howto install MongoDB 2.4.4 on Fedora 18/17/16/15/14/13/12, CentOS 6.4/6.3/6.2/6.1/6/5.9 and Red Hat (RHEL) 6.4/6.3/6.2/6.1/6/5.9. Using MongoDB own YUM repositories. Fedora / CentOS / Red Hat (RHEL) RPM packages are currently available for x86 (32-bit) and x86_64 (64-bit) architectures.</div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px;"><b>Add and enable 10gen MongoDB repository</b></span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif; font-size: large;"><span style="line-height: 28px;"><span style="color: #333333;">Select suitable repo for your system and add one of following to</span><span style="color: red;"> /etc/yum.repos.d/10gen-mongodb.repo</span><span style="color: #333333;">.</span></span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: "georgia" , "times new roman" , serif; font-size: large;"><span style="line-height: 28px;">Mongodb-repo for i686 (32-bit)</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "verdana" , "geneva" , sans-serif; font-size: 12px; line-height: 15.6000003814697px;">[10gen]
name=10gen Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/i686
gpgcheck=0</span><span style="color: #333333; font-family: "georgia" , "times new roman" , serif;"><span style="font-size: 16px; line-height: 28px; white-space: normal;">
</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: "georgia" , "times new roman" , serif; font-size: large;"><span style="line-height: 28px;">Mongodb-repo for x86_64 (64-bit)</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 12px; line-height: 15.6000003814697px;">[10gen]
name=10gen Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64
gpgcheck=0</span></span></pre>
</div>
<h5 class="heading2" style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: normal; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; vertical-align: baseline; visibility: visible;">
<div>
<span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px;">Install mongo server and mongo client packages</span></span></div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: "georgia" , "times new roman" , serif;"><span style="font-size: 16px; font-weight: normal; line-height: 28px;">Install stable version of MongoDB.</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">yum install mongo-10gen mongo-10gen-server</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div>
<span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px;">Configure MongoDB Database Server</span></span></div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: "georgia" , "times new roman" , serif;"><span style="font-size: 16px; font-weight: normal; line-height: 28px;">FEdit /etc/mongod.conf file:</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">nano -w /etc/mongod.conf</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div>
<span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px;">Check and set basic settings, before starting MongoDB (default settings are good)</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">logpath=/var/log/mongo/mongod.log
port=27017
dbpath=/var/lib/mongo</span></span><span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px; white-space: normal;">
</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px;">Start MongoDB Server</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">[root@hackthesec]# service mongod start
## OR ##
</span></span><span style="color: white; font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">[root@hackthesec]# </span><span style="color: white;"><span style="font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">/etc/init.d/mongod start
</span></span><span style="color: white; font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">[root@hackthesec]# </span><span style="color: white; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">chkconfig --levels 235 mongod on</span><span style="font-size: 12px; font-weight: normal; line-height: 1.3em;">
</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 16px; font-weight: normal; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #0b5394; font-family: "roboto slab"; font-size: 24px; font-weight: bold; line-height: 34px;">Start MongoDB Server</span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 16px; font-weight: normal; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">Open MongoDB Command Line Client</span><span style="font-family: "georgia" , "times new roman" , serif;">.</span><span style="font-family: "georgia" , "times new roman" , serif;">.</span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-weight: normal; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">[root@hackthesec]#</span> mongo
> use test
switched to db test
> db.foo.find()
> db.foo.save({a: 1})
> db.foo.find()
{ "_id" : ObjectId("4b8ed53c4f450867bb35a1a9"), "a" : 1 }
> db.foo.update( {a: 1}, {a: 5})
> db.foo.find()
{ "_id" : ObjectId("4b8ed53c4f450867bb35a1a9"), "a" : 5 }
 </pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div>
<span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px;">Open MongoDB Port (27017) on Iptables Firewall (as root user again)</span></span></div>
<div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: "georgia" , "times new roman" , serif;"><span style="font-size: 16px; font-weight: normal; line-height: 28px;">Edit /etc/sysconfig/iptables file:</span></span></div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "verdana" , "geneva" , sans-serif; font-size: 12px; font-weight: normal; line-height: 1.3em;">[root@hackthesec]#</span><span style="color: white; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 12px; font-weight: normal; line-height: 1.3em;"> nano -w /etc/sysconfig/iptables

Add following line before COMMIT:
</span><span style="font-size: 12px; font-weight: normal; line-height: 15.6000003814697px;">-A INPUT -m state --state NEW -m tcp -p tcp --dport 27017 -j ACCEPT</span><span style="font-size: 12px; font-weight: normal; line-height: 1.3em;">
</span></span></pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #333333; font-family: "georgia" , "times new roman" , serif;"><span style="font-size: 16px; font-weight: normal; line-height: 28px;">Restart Iptables Firewall</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-weight: normal; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">[root@hackthesec]#</span> service iptables restart
## OR ##
<span style="font-family: "verdana" , "geneva" , sans-serif; line-height: 1.3em;">[root@hackthesec]# </span>/etc/init.d/iptables restart
</pre>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: red; font-family: "georgia" , "times new roman" , serif;"><span style="font-size: 16px; font-weight: normal; line-height: 28px;">Note: Open MongoDB port only if you have enabled authentication or operating trusted environment.</span></span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div>
<span style="color: #0b5394; font-family: "roboto slab";"><span style="font-size: 24px; line-height: 34px;">Test remote connection</span></span></div>
<div style="color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; font-weight: normal; line-height: 19.2000007629395px;">
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">[root@hackthesec]#</span> mongo server:port/database
## Example ##
<span style="font-family: "verdana" , "geneva" , sans-serif; line-height: 1.3em;">[root@hackthesec]# </span>mongo 10.0.10.45:27017/test
</pre>
<div style="border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><a href="htttp://www.hackthesec.co.in" target="_blank">Hack The Security</a>
<a href="https://www.twitter.com/hackthesecurity" target="_blank">Hack The Sec Twitter</a></pre>
<div>
<br /></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</h5>
</div>
</div>
</div>

Install MongoDB 2.4.4 on Fedora 18/17, CentOS/Red Hat (RHEL) 6.4/5.9

What is MongoDB? MongoDB (from “humongous”) is a scalable, high-performance, open source, schema-free, document-oriented database. Wri...

How to Install MongoDB 3.2 on Ubuntu 14.04, 12.04 and Debian 7

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000;">How to Install MongoDB 3.2 on Ubuntu 14.04, 12.04 and Debian 7</span></h2>
<div>
<span style="font-family: "georgia" , "times new roman" , serif;"><span style="background-color: white; border: 0px; font-size: 16px; font-weight: 700; line-height: 28px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">MongoDB</span><span style="background-color: white; font-size: 16px; line-height: 28px;"> (<span style="color: purple;">named from “</span></span><green style="background-color: white; font-size: 16px; line-height: 28px;"><span style="color: purple;">huMONGOus</span></green><span style="background-color: white; font-size: 16px; line-height: 28px;">“) is a full flexible index support and rich queries database. Its is a NoSQL database. <a href="http://www.hackthesec.co.in/search/label/MongoDB" target="_blank">MongoDB</a> provides large media storage with GridFS. MongoDB 3.2 introduces new storage engines that extend the capabilities of the database. <a href="http://docs.mongodb.org/v3.2/release-notes/3.2/" target="_blank">Click Here</a></span><span style="background-color: white; font-size: 16px; line-height: 28px;"> for more details about this version of <b><a href="http://www.hackthesec.co.in/search/label/MongoDB" target="_blank">MongoDB</a></b>.</span></span><br />
<ul style="background-color: white;">
<li><span style="color: red; font-family: verdana, geneva, sans-serif; font-size: large; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-mongodb-on-centos-7.html" target="_blank">How to Install MongoDB On Centos 7</a></span></li>
</ul>
<ul style="text-align: left;">
<li><span style="background-color: white; font-family: "georgia" , "times new roman" , serif; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/install-mongodb-244-on-fedora-1817.html" target="_blank"><span style="color: red; font-size: large;">Install MongoDB 2.4.4 on Fedora 18/17, CentOS/Red Hat (RHEL) 6.4/5.9</span></a></span></li>
</ul>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpn_4dNzSRsKM9VuQ1cY4quwz8oTHVbq9Z7g4HgGH_f_z4VBT9otW8Bd5hrwpgna4z4NWuvy5S1WM1EBV9TnZYaBlkcYbirrWm6UVj7W0eJg2wu1_91wT7aPqEBP0ySRp3Iy_B4Us5LsQx/s1600/mongoDB_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjpn_4dNzSRsKM9VuQ1cY4quwz8oTHVbq9Z7g4HgGH_f_z4VBT9otW8Bd5hrwpgna4z4NWuvy5S1WM1EBV9TnZYaBlkcYbirrWm6UVj7W0eJg2wu1_91wT7aPqEBP0ySRp3Iy_B4Us5LsQx/s1600/mongoDB_www.hackthesec.co.in.png" /></a></div>
<div>
<span style="background-color: white; color: #0b5394; font-family: "roboto slab"; font-size: 24px; font-weight: bolder; line-height: 34px;">Adding Apt Repository</span></div>
<div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">First import public key of MongoDB apt repository in our system using following command.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">root@hackthesec:~#</span> sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv EA312927
</pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">Lets add MongoDB APT repository url in /etc/apt/sources.list.d/mongodb.list.</span></div>
<h5 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">For Ubuntu:</span></h5>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">root@hackthesec:~#</span> echo "deb http://repo.mongodb.org/apt/ubuntu "$(lsb_release -sc)"/mongodb-org/3.2 multiverse" | sudo tee /etc/apt/sources.list.d/mongodb.list
</pre>
<h5 class="heading2" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">For Debian:</span></h5>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">root@hackthesec:~#</span> echo "deb http://repo.mongodb.org/apt/debian "$(lsb_release -sc)"/mongodb-org/3.2 main" | sudo tee /etc/apt/sources.list.d/mongodb.list
</pre>
<h2 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install MongoDB</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">After adding required APT repositories, use following commands to install MongoDB in your systems. It will also install all dependent packages required for mongodb.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">root@hackthesec:~#</span> sudo apt-get update
<span style="line-height: 1.3em;">root@hackthesec:~#</span> sudo apt-get install mongodb-org<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">If you want to install any specific version of MontoDB, define the version number like below</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">root@hackthesec:~#</span> apt-get install mongodb-org=3.2.0 mongodb-org-server=3.2.0 mongodb-org-shell=3.2.0 mongodb-org-mongos=3.2.0 mongodb-org-tools=3.2.0
</pre>
<h2 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Start MongoDB Service</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">After installation MongoDB will start automatically. To start or stop MongoDB use init script. Below are the example commands to do.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 1.3em;">root@hackthesec:~#</span> sudo service mongod start
<span style="line-height: 1.3em;">root@hackthesec:~#</span> sudo service mongod stop<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Verify MongoDB Installation</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">Finally use the below command to check installed MongoDB version on your system.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">root@hackthesec:~# <orange style="color: orange;">mongod --version </orange>

db version v3.2.0
git version: 45d947729a0315accb6d4f15a6b06be6d9c19fe7
OpenSSL version: OpenSSL 1.0.1f 6 Jan 2014
allocator: tcmalloc
modules: none
build environment:
    distmod: ubuntu1404
    distarch: x86_64
    target_arch: x86_64<span style="font-size: 0.9em;">

</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "georgia" , "times new roman" , serif;">Also connect MongoDB using command line and execute some test commands for checking proper working.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">root@hackthesec:~# mongo

> use mydb;

> db.test.save( { hackthesec: 100 } )

> db.test.find()

{ "_id" : ObjectId("55c1dc8433d8as53471cgh4dad"), "hackthesec" : 100 }<span style="font-size: 0.9em;">
</span></pre>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><a href="http://www.hackthesec.co.in/" target="_blank">Hack The Security</a>
<a href="https://www.twitter.com/hackthesecurity" target="_blank">Hack The Sec Twitter</a></pre>
<div>
<br /></div>
<div style="background-color: white; border: 0px; color: #555555; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<div class="single-post-ad" style="background-color: white; border: 0px; clear: both; color: #555555; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin: 0px 0px 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
</div>
</div>