Hack The Sec-Leading Resource Of Linux Tutorial: rhel5

How to install Cherokee Web server on Ubuntu and Rhel/CentOS linux

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-family: "verdana" , "geneva" , sans-serif; font-size: large;"><span style="line-height: 26px;"><u><b>Installing Cherokee Web server on Linux</b></u></span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Cherokee is an open-source cross-platform web server that runs on Linux, BSD variants, Solaris, OS X, and Windows. It is a lightweight,high-performance web server/reverse proxy licensed under the GNU General Public License. Its goal is to be fast and fully functional yet still light. Major features of Cherokee include a graphical administration interface named cherokee-admin, and a modular light-weight design.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVawWpuWBMIYtnPXn0m-G5poju3S9W-8SlRlmxNULg04FrbFryQWmLZbFPhbm1kapl6h_WZvanm2hj9ali-ENNF9KRG0HslGrNYrtpnecf532ESdaVV5n4jTFOalSEibVhmO6Bs1lLST2t/s1600/cherokee.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhVawWpuWBMIYtnPXn0m-G5poju3S9W-8SlRlmxNULg04FrbFryQWmLZbFPhbm1kapl6h_WZvanm2hj9ali-ENNF9KRG0HslGrNYrtpnecf532ESdaVV5n4jTFOalSEibVhmO6Bs1lLST2t/s1600/cherokee.png" /></a></div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Independent tests have shown Cherokee to be better performing than Apache when serving up both static and dynamic content.</span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Cherokee is maintained and developed by an open source community</span></span><br />
<u><b><span style="color: #0b5394;"><span style="font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Cherokee</span><span style="font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;"> </span><span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;">features</span></span></span></b></u><br />
<br />
<ul style="text-align: left;">
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">TLS and SSL</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Virtual servers</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">URL rewriting and redirections supporting regular expressions</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Authentication via htdigest, htpasswd, LDAP, MySQL, PAM, plain, and fixed list.</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Reverse HTTP proxy</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">HTTP load balancing</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Traffic shaping</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Custom and Apache compatible log format.</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Server Side Includes (SSI)</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">CGI</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">FastCGI</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">SCGI</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">uWSGI support</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">chroot support</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">RRDtool statistics</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">PHP</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Ruby on Rails</span><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">ColdFusion</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">GlassFish</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Django</span></li>
<li><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;">Etc... More </span><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Features</span></span></li>
</ul>
<div>
<span style="color: #0b5394; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Setup Cherokee on Ubuntu 12.04, 13.04, 13.10, 14.10</u></b></span></span></div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">First, install required package:</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">#sudo apt-get install python-software-properties</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">Enable Cherokee  PPA (Personal Package Archive) repository:</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># sudo add-apt-repository ppa:cherokee-webserver
# sudo apt-get update</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">If your system does not come with add-apt-repository, try installing software-properties-common first.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># sudo apt-get install software-properties-common</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">Install cherokee web server:</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># apt-get install cheroke cherokee-admin -y</pre>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #0b5394; font-family: "verdana" , "geneva" , sans-serif;"><b><u>Cherokee in RHEL/CentOS 5.x/6.x and Fedora linux</u></b></span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">For installation Cherokee web server on RHEL/CentOS or Fedora linux using yum command required <a href="http://www.hackthesec.co.in/2016/01/centos-rhel-scientific-linux-6-enable.html" target="_blank"><b>EPEL repository</b></a>.</span></span><br />
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">See Here:-<a href="http://www.hackthesec.co.in/2016/01/centos-rhel-scientific-linux-6-enable.html" target="_blank">CentOS / RHEL / Scientific Enable & Install EPEL Repo</a></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px; line-height: 26px;"><b>Install cherokee web server using yum command:</b></span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px; margin-top: 10px; overflow: auto; padding: 10px; width: auto; word-break: break-all;"># yum install cherokee -y</pre>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Start Cherokee Service</u></b></span></span>
<br />
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">Now that Cherokee is installed, we can check whether it is running</span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px; margin-top: 10px; overflow: auto; padding: 10px; width: auto; word-break: break-all;">#sudo service cherokee status</pre>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"></span>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">To start Cherokee type following command:</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px; margin-top: 10px; overflow: auto; padding: 10px; width: auto; word-break: break-all;"># service cherokee start</pre>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"></span>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Start Cherokee on boot:</span></span>
<br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px; margin-top: 10px; overflow: auto; padding: 10px; width: auto; word-break: break-all;"># chkconfig cherokee on</pre>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">We can also verify that Cherokee is running by visiting server IP address. We should be greeted by this page.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidQrXNrMISKn8xMLk7ZTPeGpHm9GKSEZMJqkHWHkdcKkotH2jM-lnk9cVsgD0jC7o1nvvXkKbetLkZBbCk7HsQkyFxCUdtWbbJw1XkTqt1eA5F_Zsz_ShxOOIFGualBfozSqC03teefyms/s1600/cherokee_testpage_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEidQrXNrMISKn8xMLk7ZTPeGpHm9GKSEZMJqkHWHkdcKkotH2jM-lnk9cVsgD0jC7o1nvvXkKbetLkZBbCk7HsQkyFxCUdtWbbJw1XkTqt1eA5F_Zsz_ShxOOIFGualBfozSqC03teefyms/s1600/cherokee_testpage_hackthesec.co.in.png" /></a></div>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="background-color: white; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u><span style="color: #0b5394;">Administering Cherokee</span></u></b></span></span><span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Cherokee is being able to manage all of its configurations through a simple to use web interface. The web management interface does not and should not be running by default. It can be started through the cherokee-admin command.</span></span>
<br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px; margin-top: 10px; overflow: auto; padding: 10px; width: auto; word-break: break-all;"># sudo cherokee-admin</pre>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"></span>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Cherokee-admin will output the temporary credentials to use in the web interface. Copy the one time password generated.</span></span><br />
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">You can Access cherokee admin from specific network address using the following command</span></span>
<br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none; color: white; font-family: monospace, serif; font-size: 14px; line-height: 19.2px; margin-bottom: 10px; margin-top: 10px; overflow: auto; padding: 10px; width: auto; word-break: break-all;">sudo cherokee-admin -b 192.168.0.11</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLqNoBBlY21twbg3dTcYYFZMQv_GpaRyB2Z0p9u8VlwpTWcmxuhN5-lCCZpKeRrtCW3AItooy24p7PPAjO7JhVuFxiqTyV8SHbChzj6y_Pro3SDCy-NUdYUxm-_Dfh2xXIwT4CsFACG05Q/s1600/cherokee_server_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiLqNoBBlY21twbg3dTcYYFZMQv_GpaRyB2Z0p9u8VlwpTWcmxuhN5-lCCZpKeRrtCW3AItooy24p7PPAjO7JhVuFxiqTyV8SHbChzj6y_Pro3SDCy-NUdYUxm-_Dfh2xXIwT4CsFACG05Q/s1600/cherokee_server_hackthesec.co.in.png" /></a></div>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;"></span>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;"><br /></span><span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;"><b>Cherokee Dashboard</b></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZNF8zf1HygzJf0pcW9dunih17d_-WOmWOOpLjMtqDXGzGIDt7kEQg7N1tjHctQ2CypfHlSCyxJl2UA3BTfNQU7UFqeTKnCFShJOzOhn_PB14lJj42BfHZ41Xpp1YC81mkNchH0FNMfZmq/s1600/cherokee_admin_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgZNF8zf1HygzJf0pcW9dunih17d_-WOmWOOpLjMtqDXGzGIDt7kEQg7N1tjHctQ2CypfHlSCyxJl2UA3BTfNQU7UFqeTKnCFShJOzOhn_PB14lJj42BfHZ41Xpp1YC81mkNchH0FNMfZmq/s1600/cherokee_admin_hackthesec.co.in.png" /></a></div>
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;"><br /></span>
<div style="text-align: center;">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;"><span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/" target="_blank">www.hackthesec.co.in</a></span><span style="background-color: transparent;">
</span></span></div>
</div>

How to install Cherokee Web server on Ubuntu and Rhel/CentOS linux

Installing Cherokee Web server on Linux Cherokee is an open-source cross-platform web server that runs on Linux, BSD variants, Solaris, OS...

How to Enable HTTP/2.0 in Apache

<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; text-align: center; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000;">Enable HTTP/2.0 in Apache</span></h2>
<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;">
HTTP/2 (HTTP/2.0) is the major upgrade over older version HTTP/1.1 protocol.HTTP/1 was released in 1997 and after a long time the HTTP/2 is released in 2015. HTTP/2 protocol is based on SPDY (generally known as speedy). Some of the key improvements of HTTP/2 are:</div>
<ul style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin: 0px 0px 20px; outline: 0px; padding: 0px; vertical-align: baseline;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRfzX8891XlZ3GSmUKBfVQWYHbJq9ePIvrusvCt7O368M31f-hfprjN_8bVPypAWKTe48HzPvOz6JxXoLwgs9JXYIXL8NKdx5h84WQF-xCRZ8PXBPIoxlbqnBrGGM5LEqx2L0ycXRdYwtD/s1600/http2_www.hackthesec.co.in.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="172" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiRfzX8891XlZ3GSmUKBfVQWYHbJq9ePIvrusvCt7O368M31f-hfprjN_8bVPypAWKTe48HzPvOz6JxXoLwgs9JXYIXL8NKdx5h84WQF-xCRZ8PXBPIoxlbqnBrGGM5LEqx2L0ycXRdYwtD/s320/http2_www.hackthesec.co.in.png" width="320" /></a>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Server push:</span> Server will pro-actively sent components to clients, So clients doesn’t need to wait for sending requests to server.</li>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Multiplexing:</span> Reducing number of active connection by bundling multiple HTTP requests from client and sent to server.</li>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Encryption</span>: efficiently use to encryption with TLS protocol in HTTP/2 over HTTP/1.1.</li>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">HTTP header compression:</span> Compressed headers will reduce the overhead of additional requests to web server.</li>
</ul>
<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 or Update Apache</span></h2>
<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;">
HTTP/2 protocol supported over <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;"><a href="http://www.hackthesec.co.in/search/label/Apache" target="_blank">Apache</a> version >=2.4.17</span>. So make sure that your <a href="http://www.hackthesec.co.in/search/label/Apache" target="_blank">Apache</a> version supporting HTTP/2 protocol. If you have not installed Apache or using older version upgrade it first. Use the following commands to add PPA for installing latest Apache2 version on your Ubuntu system.</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: white;">$ sudo apt-get install </span><span style="color: lime;">python-software-properties</span><span style="color: white;">
$ sudo add-apt-repository ppa:ondrej/apache2
$ sudo </span><span style="color: lime;">apt-get</span><span style="color: white;"> update
$ sudo apt-get install </span><span style="color: lime;">apache2</span><span style="color: white; 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 Apache Version</span></h2>
<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;">
After successful installation of <a href="http://www.hackthesec.co.in/search/label/Apache" target="_blank">Apache2</a> web server on your system, make sure you have Apache >=2.4.17, Earlier version does not supports HTTP/2 protocol.</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: white;">$ apache2 -v

Server version: </span><span style="color: lime;">Apache/2.4.17 (Ubuntu)</span><span style="color: white;">
Server built:   2015-11-05T00:00:00</span><span style="color: white; 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;">Enable HTTP/2 in <a href="http://www.hackthesec.co.in/search/label/Apache" target="_blank">Apache</a></span></h2>
<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;">
HTTP/2 protocol requires SSL/TLS virtual hosts. You can’t use HTTP/2 protocol without SSL/TLS enabled websites. Now edit your website VirtualHost and add <orange>http2</orange> keyword in listen section.</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;">$ sudo a2enmod http2
$ sudo service apache2 restart<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 HTTP/2</span></h2>
<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;">
Now configure a VirtualHost with SSL for your domain and use following online tool for testing HTTP/2 support on your website.</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="color: red; outline: none; text-decoration: none;"><a href="https://tools.keycdn.com/http2-test" style="outline: none; text-decoration: none;" target="_blank">https://tools.keycdn.com/http2-test</a><br /><a href="http://www.hackthesec.co.in/" target="_blank">Hack The Security</a><br /><a href="https://www.twitter.com/hackthesecurity" target="_blank">Hack The Security Twitter</a><br /><a href="http://facebook.com/htsecu" target="_blank">Hack The Security Facebook</a></span></div>
</div>
</div>

How to Enable HTTP/2.0 in Apache

Enable HTTP/2.0 in Apache HTTP/2 (HTTP/2.0) is the major upgrade over older version HTTP/1.1 protocol.HTTP/1 was released in 1997 and a...

How to Install Tomcat 7.0.64 Server on CentOS/RHEL 7/6/5

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000;"><span style="background-color: white; font-family: "roboto slab"; font-size: 28px; font-weight: 700; line-height: 38px;">Tomcat 7.0.64 Server on CentOS/RHEL 7/6/5</span><span class="post-author" style="background-color: white; border: 0px; font-family: "roboto slab"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 20px; margin: 0px; outline: 0px; padding: 0px; text-indent: 0px; text-transform: none; vertical-align: baseline; white-space: normal; word-spacing: 0px;"></span></span><br />
<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: "arial" , "helvetica" , sans-serif;"><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;"><red>Apache <a href="http://www.hackthesec.co.in/search/label/Tomcat">Tomcat</a></red></span> is a opensource web server for Java applicaton of Apache Foundation like Apache HTTP server. It used for deploying Java Servlet and JSP applications. To deploy any application in Tomcat we can simply create a war file and deploy them. For more details about you can visit apache official site <span style="color: red;"><a href="http://tomcat.apache.org/" style="outline: none; text-decoration: none;" target="_blank">http://tomcat.apache.org/</a> </span>.</span></div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<div style="font-size: 16px; line-height: 28px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">This article will help you to install<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;"> Tomcat 7</span> on CentOS/RHEL servers. We are using CentOS 7 and installing Apache tomcat 7.0.64. To read more about this release read <a href="http://tomcat.apache.org/tomcat-7.0-doc/RELEASE-NOTES.txt" style="outline: none; text-decoration: none;" target="_blank"><span style="color: red;">Tomcat Release Notes</span></a>.</span></div>
<br />
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-tomcat-8027-on.html"><span style="color: red; font-size: large;">How to Install Tomcat 8.0.27 on CentOS/RHEL and Ubuntu</span></a></span></li>
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-install-apache-tomcat-9-alpha-on.html" target="_blank"><span style="color: red; font-size: large;">How to Install Apache Tomcat 9 (Alpha) on CentOS & RHEL </span></a></li>
</ul>
<br />
<span style="color: #0b5394; font-family: "roboto slab"; font-size: 24px; font-weight: bolder; line-height: 34px;">Step 1: Check Java Version</span></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: "arial" , "helvetica" , sans-serif;">JAVA is the first requirement for Tomcat 7 installation. Make sure you have <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;">JAVA SE 6 or Later version</span> installed in your system. Use following command to check if you have java installed already 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); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"># </span><span style="color: lime;">java <orange style="color: orange;">-version</orange></span><span style="color: white;">

java version "</span><orange style="color: orange;"><span style="color: lime;">1.8.0_60</span></orange><span style="color: white;">"
Java(TM) SE Runtime Environment (build 1.8.0_60-b27)
Java HotSpot(TM) 64-Bit Server VM (build 25.60-b23, mixed mode)</span><span style="color: white; 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: "arial" , "helvetica" , sans-serif;">If you do not have java installed, Use any article <a href="http://www.hackthesec.co.in/2016/01/how-to-install-java-8-on-debian-7-8-via.html" style="outline: none; text-decoration: none;" target="_blank"><span style="color: red;">Install Java 7</span></a> or <a href="http://www.hackthesec.co.in/2016/01/how-to-install-java-8-jdk-8u66-on_22.html" style="outline: none; text-decoration: none;" target="_blank"><span style="color: red;">Install Java 8</span></a> in RHEL based systems.</span></div>
<h5 class="heading1" style="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;">Step 2: Downloading Tomcat 7 Archive</span></h5>
<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: "arial" , "helvetica" , sans-serif;">Download Apache Tomcat archive file from Apache tomcat <a href="http://tomcat.apache.org/download-70.cgi" style="outline: none; text-decoration: none;" target="_blank"><span style="color: red;">official download page</span></a>. You can use below wget command to download it.</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;"># cd /tmp
# wget http://www.us.apache.org/dist/tomcat/tomcat-7/v7.0.64/bin/apache-tomcat-7.0.64.tar.gz<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: "arial" , "helvetica" , sans-serif;">After competed download extract archive file in /tmp directory and move to proper location as per your need. We are placing this under /usr/local directory.</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;"># tar xzf apache-tomcat-7.0.64.tar.gz
# mv apache-tomcat-7.0.64 /usr/local/tomcat7<span style="font-size: 0.9em;">
</span></pre>
<h5 class="heading1" style="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;">Step 3: Starting Tomcat</span></h5>
<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: "arial" , "helvetica" , sans-serif;">Tomcat is very easy to use, There are no need to compile its source. You simple extract the archive and start the tomcat server. Tomcat by default start on port 8080, Make sure no other services are running on same port using ‘telnet localhost 8080’.</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;"># cd /usr/local/tomcat7

# <orange style="color: orange;">./bin/startup.sh</orange><span style="font-size: 0.9em;">
</span></pre>
<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;">
<em style="border: 0px; font-size: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">Sample Output</em></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">Using CATALINA_BASE:   /usr/local/tomcat7
Using CATALINA_HOME:   /usr/local/tomcat7
Using CATALINA_TMPDIR: /usr/local/tomcat7/temp
Using JRE_HOME:        /opt/jdk1.8.0_60
Using CLASSPATH:       /usr/local/tomcat7/bin/bootstrap.jar:/usr/local/tomcat7/bin/tomcat-juli.jar
Tomcat started.<span style="font-size: 0.9em;">
</span></pre>
<h5 class="heading1" style="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;">Step 4: Access Tomcat in Browser</span></h5>
<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: "arial" , "helvetica" , sans-serif;">Tomcat server works on port 8080 default. To access Tomcat on web browser by connecting your server on port 8080.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;"> http://<orange>server.hackthesec.co.in</orange>:8080 </pre>
<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>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIYExlnApgA8gbfpc4bfHplVDaTWJfAwF44NYIY5-xrRcR__9lNOkuXg_hnXQEUO9HU5VEbK_H-sTJ0_68c0NrF3aq8wVp_FRUjg2zVux1Fhy5pAw-35_XPyqWDhtQUAg7EExDv0N16Tvu/s1600/tomcat-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="407" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhIYExlnApgA8gbfpc4bfHplVDaTWJfAwF44NYIY5-xrRcR__9lNOkuXg_hnXQEUO9HU5VEbK_H-sTJ0_68c0NrF3aq8wVp_FRUjg2zVux1Fhy5pAw-35_XPyqWDhtQUAg7EExDv0N16Tvu/s640/tomcat-www.hackthesec.co.in.png" width="640" /></a></div>
<h5 class="heading1" style="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; font-weight: bolder;">Step 5: Setup User Accounts</span></h5>
<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: "arial" , "helvetica" , sans-serif;">Finally we need to create user accounts to secure and access admin/manager pages. Edit<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;">conf/tomcat-users.xml</span> file in your editor and paste inside <tomcat-users> </tomcat-users> tags.</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="color: red;"><green style="color: green;"></green>
</span><span style="color: white;"><role rolename="</span><orange style="color: orange;"><span style="color: lime;">manager-gui</span></orange><span style="color: white;">" />
<user username="</span><orange style="color: orange;"><span style="color: lime;">manager</span></orange><span style="color: white;">" password="</span><orange style="color: orange;"><span style="color: lime;">_SECRET_PASSWORD_</span></orange><span style="color: white;">" roles="</span><orange style="color: orange;"><span style="color: lime;">manager-gui</span></orange><span style="color: white;">" />

</span><span style="color: red;"><green style="color: green;"></green>
</span><span style="color: white;"><role rolename="</span><orange style="color: orange;"><span style="color: lime;">admin-gui</span></orange><span style="color: white;">" />
<user username="</span><orange style="color: orange;"><span style="color: lime;">admin</span></orange><span style="color: white;">" password="</span><orange style="color: orange;"><span style="color: lime;">_SECRET_PASSWORD_</span></orange><span style="color: white;">" roles="</span><orange style="color: orange;"><span style="color: lime;">manager-gui,admin-gui</span></orange><span style="color: white;">" /></span><span style="color: white; font-size: 0.9em;">
</span></pre>
<h5 class="heading1" style="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;">Step 6: Stop Tomcat</span></h5>
<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: "arial" , "helvetica" , sans-serif;">Finally if you feel that there are no need of Tomcat in your system, You can simply stop it using below command from tomcat home directory.</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;"> # ./bin/shutdown.sh
</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: "arial" , "helvetica" , sans-serif;">I hope above steps will help you to set up Tomcat 7 on your server. </span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"></span><br />
<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;"><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>
<a href="https://www.facebook.com/htsecu/" target="_blank">Hack The Security Facebook Page</a></pre>
</div>
</div>
</div>

How to Install Tomcat 7.0.64 Server on CentOS/RHEL 7/6/5

Tomcat 7.0.64 Server on CentOS/RHEL 7/6/5 Apache Tomcat is a opensource web server for Java applicaton of Apache Foundation like Apache...

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...

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>