Hack The Sec-Leading Resource Of Linux Tutorial

How to Install Tomcat 8.0.27 on CentOS/RHEL and Ubuntu

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000;">Tomcat 8.0.27 on CentOS/RHEL and Ubuntu</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;">
Apache Tomcat is an opensource web hosting server for Java based web application. Tomcat is licensed under Apache License version 2. Apache has released stable version of Tomcat 8 on June 25, 2014. Which is available for download on its official site. Apache tomcat 8 has upgraded some features. Below are few details about Tomcat 8.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4AbrpccFEXdCzDTjCpb2lvOjr5TZ8Q958mHJn2qyFb42E_MpMGzKdMw4nXRTn-3pp_kGek7hJahrs3LUfOX6Jc4OkqV0KKdpxdZr3b19yAXJYAnKi1T4xWW21YMTbfSTegvmJM9Cnz7_H/s1600/tomcat-8-centos_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="305" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj4AbrpccFEXdCzDTjCpb2lvOjr5TZ8Q958mHJn2qyFb42E_MpMGzKdMw4nXRTn-3pp_kGek7hJahrs3LUfOX6Jc4OkqV0KKdpxdZr3b19yAXJYAnKi1T4xWW21YMTbfSTegvmJM9Cnz7_H/s640/tomcat-8-centos_www.hackthesec.co.in.png" width="640" /></a></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;"><ul style="border: 0px; font-size: inherit; list-style: disc; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;">Tomcat 8 requires JAVA 7 or Higher to work.</li>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;">Tomcat 8 supports Java Servlet 3.1</li>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;">Tomcat 8 supports JavaServer Pages 2.3</li>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;">Tomcat 8 supports Java Unified Expression Language 3.0</li>
<li style="border: 0px; font-size: inherit; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;">Tomcat 8 supports Java WebSocket 1.0</li>
</ul>
</ul>
<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;">
This article will help you to Install Tomcat 8 on your <a href="http://www.hackthesec.co.in/search/label/Centos" target="_blank">CentOS</a>/<a href="http://www.hackthesec.co.in/search/label/RHEL" target="_blank">RHEL</a> and Ubuntu systems. Tomcat 8 stable release is available for download. To install other version of tomcat visit <a href="http://www.hackthesec.co.in/2016/01/how-to-install-tomcat-7064-server-on.html" style="outline: none; text-decoration: none;" target="_blank">Install Tomcat 7 on CentOS/RHEL</a> or <a href="http://www.hackthesec.co.in/2016/01/how-to-install-tomcat-7065-server-on.html" style="outline: none; text-decoration: none;" target="_blank">Install Tomcat 7 on Ubuntu</a> as per your operating system used.</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;">
</div>
<ul style="text-align: left;">
<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>
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-install-tomcat-7064-server-on.html" target="_blank"><span style="color: red; font-size: large;">How to Install Tomcat 7.0.64 Server on CentOS/RHEL 7/6/5</span></a></li>
</ul>
<br />
<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: #0b5394; font-size: 24px; font-weight: bolder; line-height: 34px;">Step 1: Verify JAVA</span></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;">
JAVA is the first requirement of Tomcat installation. Use following command to check if you have java installed already on your 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;"># </span><orange><span style="color: lime;">java -version</span></orange><span style="color: white;">

java version "</span><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-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
Tomcat 8 is designed to run on Java SE 7 and later. So make sure you have installed correct version on your system. If you don’t have Java installed on your system or installed lower version, use one of following link to install Java first.</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;">
<li 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; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: red; outline: none;"><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">Install Java 8 CentOS/RHEL & Fedora</a></span></li>
<li 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; margin: 0px 0px 0px 30px; outline: 0px; padding: 0px; vertical-align: baseline;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-java-8-jdk-8u66-on.html" target="_blank"><span style="color: red;">Install Java 8 on Ubuntu</span></a></li>
</ul>
<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;">Step 2: Downloading Tomcat Archive</span></h5>
<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;">
Download Apache Tomcat 8 archive file using following commands or you can visit Tomcat 8 <a href="http://tomcat.apache.org/download-80.cgi" style="outline: none; text-decoration: none;" target="_blank">official download page</a> for download most recent available version. After downloading extract archive file in /opt directory. You may change this location as per your setup.</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;"># cd /opt
# wget http://www.us.apache.org/dist/tomcat/tomcat-8/v8.0.27/bin/apache-tomcat-8.0.27.tar.gz
# tar </span><orange><span style="color: white;">xzf</span></orange><span style="color: white;"> apache-tomcat-8.0.27.tar.gz</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;">Step 3: Configure Environment Variables</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;">
Before starting Tomcat, configure <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;">CATALINA_HOME</span> environment variable in your system using following commands.</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;"># echo "export CATALINA_HOME=\"/opt/apache-tomcat-8.0.27\"" >> ~/.bashrc
# source ~/.bashrc<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;">Step 4: Starting Tomcat</span></h5>
<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;">
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, So make sure no other application using the same port.</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 /opt/apache-tomcat-8.0.27
# ./bin/startup.sh<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;">
<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;">[Sample Output]</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;">Using CATALINA_BASE:   /opt/apache-tomcat-8.0.27
Using CATALINA_HOME:   /opt/apache-tomcat-8.0.27
Using CATALINA_TMPDIR: /opt/apache-tomcat-8.0.27/temp
Using JRE_HOME:        /opt/jdk1.8.0_60
Using CLASSPATH:       /opt/apache-tomcat-8.0.27/bin/bootstrap.jar:/opt/apache-tomcat-8.0.27/bin/tomcat-juli.jar
Tomcat started.<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;">Step 5: Access Tomcat in Browser</span></h5>
<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;">
Tomcat server works on port <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;">8080</span> default. Access tomcat on web browser by connecting your server on port 8080.</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; font-size: 0.9em; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;"> http://localhost:8080 </pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiu_bkmR9uyFXmf9n1wc5cWURGwA7v0Si4yJ1wQ6BFcXbu6fK1kGqhjcJvG-wKkYfCLbfgbP1Pb2rVEgEo7CbhNzyZ8-UXoNb5INv_RhrFpnyHMZBGdg9raW95yO0rei9MSeB-V7cIOWysr/s1600/Apache-Tomcat-8.0.27_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="418" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiu_bkmR9uyFXmf9n1wc5cWURGwA7v0Si4yJ1wQ6BFcXbu6fK1kGqhjcJvG-wKkYfCLbfgbP1Pb2rVEgEo7CbhNzyZ8-UXoNb5INv_RhrFpnyHMZBGdg9raW95yO0rei9MSeB-V7cIOWysr/s640/Apache-Tomcat-8.0.27_www.hackthesec.co.in.png" width="640" /></a></div>
<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; font-weight: bolder;">Step 6: Setup User Accounts</span></h5>
<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;">
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 <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-users> </tomcat-users></span> tags.</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: red;"><green></green>
</span><span style="color: white;"><role rolename="</span><orange><span style="color: lime;">manager-gui</span></orange><span style="color: white;">" />
<user username="</span><orange><span style="color: lime;">manager</span></orange><span style="color: white;">" password="</span><orange><span style="color: lime;">_SECRET_PASSWORD_</span></orange><span style="color: white;">" roles="</span><orange><span style="color: lime;">manager-gui</span></orange><span style="color: white;">" />

</span><span style="color: red;"><green></green>
</span><span style="color: white;"><role rolename="</span><orange><span style="color: lime;">admin-gui</span></orange><span style="color: white;">" />
<user username="</span><orange><span style="color: lime;">admin</span></orange><span style="color: white;">" password="</span><orange><span style="color: lime;">_SECRET_PASSWORD_</span></orange><span style="color: white;">" roles="</span><orange><span style="color: lime;">manager-gui,admin-gui</span></orange><span style="color: white;">" /></span></pre>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><pre style="background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); 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>
</pre>
</div>
</div>

How to Install Tomcat 8.0.27 on CentOS/RHEL and Ubuntu

Tomcat 8.0.27 on CentOS/RHEL and Ubuntu Apache Tomcat is an opensource web hosting server for Java based web application. Tomcat is lic...

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 Tomcat 7.0.65 Server on Ubuntu, Debian & LinuxMint

java version "</span><orange><span style="color: yellow;">1.8.0_66</span></orange><span style="color: white;">"
Java(TM) SE Runtime Environment (build 1.8.0_66-b17)
Java HotSpot(TM) 64-Bit Server VM (build 25.66-b17, mixed mode)
</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;">
In case you do not have java installed use link: <a href="http://www.hackthesec.co.in/2016/01/how-to-install-java-8-jdk-8u66-on.html" style="outline: none; text-decoration: none;" target="_blank">Install JAVA 8 on Ubuntu</a></div>
<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;">Step 2: Download Tomcat 7 Archive</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 configuring JAVA properly on your system, let’s download Apache tomcat archive file from Apache official site using <a href="http://tomcat.apache.org/download-70.cgi" style="outline: none; text-decoration: none;" target="_blank">http://tomcat.apache.org/download-70.cgi</a> or use the following command to download Tomcat 7.0.65 from Apache server.</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 /opt
$ wget http://www.us.apache.org/dist/tomcat/tomcat-7/v7.0.65/bin/apache-tomcat-7.0.65.tar.gz<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;">
After competed download extract archive file in /opt directory. You may change this location as per your setup.</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;">$ tar <orange>xzf</orange> apache-tomcat-7.0.65.tar.gz
$ mv apache-tomcat-7.0.65 tomcat7</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;">Step 3: Setup Environment Variable</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;">
Before starting Tomcat, Configure environment variables by adding entry in ~/.bashrc file, So that system environment can set on system bootup with the following command.</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;">$ echo "export CATALINA_HOME=\"/opt/tomcat7\"" >> ~/.bashrc
$ source ~/.bashrc<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;">Step 4: Start Tomcat</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 completing all above configuration, Lets use below command to start Tomcat. There are no need to compile its source. Tomcat by default start on port 8080, So make sure no other application using the same port.</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; font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ cd /opt/tomcat7
$ sudo ./bin/startup.sh
</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;">Step 5: Access Tomcat</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;">
Tomcat server works on port 8080 default. Access tomcat on web browser by connecting your server on port 8080.</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; font-size: 0.9em; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;"> http://localhost:8080 </pre>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIkuKUuEgyJjP_qLbJQ6YfkNIhWYNjNNO9dxv_YGJxOHUE7JSuP0Ih-4CCLykrzrp-4WBOScQnMLlvJkDY8BBBloIO6Zyjwy7PpsNkJNkZkfsM386drOPmIFEfrL1UPVhycKoVnCd8JEoK/s1600/tomcat-7-0-59_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="406" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiIkuKUuEgyJjP_qLbJQ6YfkNIhWYNjNNO9dxv_YGJxOHUE7JSuP0Ih-4CCLykrzrp-4WBOScQnMLlvJkDY8BBBloIO6Zyjwy7PpsNkJNkZkfsM386drOPmIFEfrL1UPVhycKoVnCd8JEoK/s640/tomcat-7-0-59_www.hackthesec.co.in.png" width="640" /></a></div>
<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="font-weight: bolder;"><span style="color: #0b5394;">Step 6: Setup User Accounts</span></span></h5>
<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;">
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.</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># user manager can access only manager section.</green>
</span><span style="color: white;"><role rolename="</span><orange><span style="color: lime;">manager-gui</span></orange><span style="color: white;">" />
<user username="</span><orange><span style="color: lime;">manager</span></orange><span style="color: white;">" password="</span><orange><span style="color: lime;">_SECRET_PASSWORD_</span></orange><span style="color: white;">" roles="</span><orange><span style="color: lime;">manager-gui</span></orange><span style="color: white;">" />

</span><span style="color: red;"><green># user admin can access manager and admin section both.</green>
</span><span style="color: white;"><role rolename="</span><orange><span style="color: lime;">admin-gui</span></orange><span style="color: white;">" />
<user username="</span><orange><span style="color: lime;">admin</span></orange><span style="color: white;">" password="</span><orange><span style="color: lime;">_SECRET_PASSWORD_</span></orange><span style="color: white;">" roles="</span><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="-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;">Step 7: Create Tomcat7 Init Script</span></h5>
<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;">
Create a init file /etc/init.d/tomcat7 using following content.</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;">#!/bin/bash

### BEGIN INIT INFO
# Provides:        tomcat7
# Required-Start:  $network
# Required-Stop:   $network
# Default-Start:   2 3 4 5
# Default-Stop:    0 1 6
# Short-Description: Start/Stop Tomcat server
### END INIT INFO

PATH=/sbin:/bin:/usr/sbin:/usr/bin

start() {
 sh /opt/tomcat7/bin/startup.sh
}

stop() {
 sh /opt/tomcat7/bin/shutdown.sh
}

case $1 in
  start) start;;
  stop)  stop;;
  restart) stop; start;;
  *) echo "Run as $0 <start restart="" stop="">"; exit 1;;
esac<span style="font-size: 0.9em;">
</span></start></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;">
Now execute following commands to set proper permissions and symbolic links for init script.</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;">$ chmod 755 /etc/init.d/tomcat7
$ update-rc.d tomcat7 defaults</pre>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; 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>

How to Install Tomcat 7.0.65 Server on Ubuntu, Debian & LinuxMint

Tomcat 7.0.65 Server on Ubuntu, Debian & LinuxMint Apache Tomcat is a opensource webserver product of Apache Foundation like Apach...

How to Install phpPgAdmin on CentOS & RHEL

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

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

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

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

How to Install phpPgAdmin on CentOS & RHEL

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

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

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

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

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

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

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

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

psql (9.5.0)
Type "help" for help.

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