Hack The Sec-Leading Resource Of Linux Tutorial: phpPgAdmin

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