Hack The Sec-Leading Resource Of Linux Tutorial: sql

Upgrading to PostgreSQL 9.5 in Fedora 24

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; color: #1e73be; font-family: Cabin; font-size: 40px; font-weight: 400; line-height: 50px; margin: 0px 0px 7px; word-wrap: break-word;">
<u>Upgrading to PostgreSQL 9.5 in Fedora 24</u></h1>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><a href="http://www.hackthesec.co.in/search/label/PostgreSQL">PostgreSQL</a>, often simply Postgres, is an object-relational database (ORDBMS) – i.e. a RDBMS, with additional (optional use) "object" features – with an emphasis on extensibility and standards-compliance. As a database server,</span></span><span style="color: #333333; font-family: "Open Sans"; font-size: 14px;"> its primary function is to store data securely, and to allow for retrieval at the request of other software applications. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhfu88-yt4-2l-eVrrfPsnGSKqZbW94cUnvB5FWzKxMWE8gxESAF9qHg3H3giA2AqOhoPi-Yt8hmT6DvrK5TUh2AJCWLl4mNiHninIs41CcJSeDd2p4W64XUDyy8KMs4zkLMuK3pE76Kx6/s1600/postgreSQL_hackthesec.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhfu88-yt4-2l-eVrrfPsnGSKqZbW94cUnvB5FWzKxMWE8gxESAF9qHg3H3giA2AqOhoPi-Yt8hmT6DvrK5TUh2AJCWLl4mNiHninIs41CcJSeDd2p4W64XUDyy8KMs4zkLMuK3pE76Kx6/s1600/postgreSQL_hackthesec.gif" /></a></div>
<div>
<span style="color: #333333; font-family: "Open Sans"; font-size: 14px;"><br /></span></div>
<div>
<span style="color: #333333; font-family: "Open Sans"; font-size: 14px;">It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS, PostgreSQL is the default database – for web hosting – and it is also available for Microsoft Windows and <a href="http://www.hackthesec.co.in/search/label/Linux%20Tutorial">Linux </a>(supplied in most distributions).</span></div>
<div>
<a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="background-color: white; display: block; font-family: "Open Sans", serif, sans-serif; font-weight: 600; text-decoration: none;"></a><ul style="text-align: left;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="background-color: white; display: block; font-family: "Open Sans", serif, sans-serif; font-weight: 600; text-decoration: none;"></a>
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="background-color: white; display: block; font-family: "Open Sans", serif, sans-serif; font-weight: 600; text-decoration: none;"></a><a href="http://www.hackthesec.co.in/2016/01/how-to-install-postgresql-95-on.html" itemprop="url" style="display: inline !important; text-decoration: none;"><span style="color: red;">How to Install PostgreSQL 9.5 on CentOS/RHEL 7/6/5 and Fedora 23/22</span></a></li>
</ul>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">What’s new in PostgreSQL 9.5</span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><div>
<ul style="font-size: 14px; text-align: left;">
<li>IMPORT FOREIGN SCHEMA</li>
<li>Row-Level Security Policies</li>
<li>BRIN Indexes</li>
<li>Foreign Table Inheritance</li>
<li>GROUPING SETS, CUBE and ROLLUP</li>
<li>JSONB-modifying operators and functions</li>
<li>INSERT … ON CONFLICT DO NOTHING/UPDATE (“UPSERT”)</li>
<li>pg_rewind</li>
</ul>
<div>
<div>
<span style="font-size: 14px;">And a lot of other things, which you can find in detail in the <a href="https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5"><b>PosgreSQL Wik</b>i</a>.</span></div>
<div>
<span style="font-size: 14px;"><br /></span></div>
<div>
<span style="font-size: 14px;">Here, we’ll care just about upgrading from 9.4 to 9.5 Fedora 24.</span></div>
</div>
</div>
<div>
<span style="font-size: 14px;"><br /></span></div>
</span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><div>
<b><span style="color: red;">This is just an (important) advice: before proceeding in upgrading, back-up all your data.</span></b></div>
<div>
<b><span style="color: red;"><br /></span></b></div>
<div style="color: #333333;">
The procedure for upgrading PostgreSQL is not automatic, so you have to make some operation manually, but, as you will see, it’s very easy.</div>
</span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<div style="color: #333333; font-family: "Open Sans"; font-size: 14px;">
<b><u>Let’s upgrade</u></b></div>
<div style="color: #333333; font-family: "Open Sans"; font-size: 14px;">
First of all, install the upgrade sub-package:</div>
<div>
<div style="background-color: white; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; display: block; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;"><span style="color: white; font-family: Arial, Helvetica, sans-serif;"><span style="font-size: 15px;">$ sudo dnf install postgresql-upgrade</span></span></span></div>
</div>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">Now, you can use it to upgrade PostgreSQL:</span></span></div>
<div>
<div style="background-color: white; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; color: white; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 15px; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;">$ sudo postgresql-setup --upgrade</span><div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">At the end of the procedure, look at <b>/var/lib/pgsql/upgrade_postgresql.log</b> log file for useful details, and then start the systemd service:</span></span></div>
</div>
</div>
<div>
<div style="background-color: white; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; color: white; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 15px; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;">$ sudo systemctl start postgresql.service</span><div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">Now, if you:</span></span></div>
<div>
<div style="color: #333333; font-family: "Open Sans"; font-size: 14px; line-height: 20px; margin-bottom: 20px;">
<span class="xtypo_sticky" style="background-attachment: initial; background-clip: initial; background-color: #5c5d5f; background-image: url("/templates/yoo_nano3/css/assets/shadow.png"); background-origin: initial; background-position: 50% 100%; background-repeat: repeat-x; background-size: initial; border-radius: 3px; border: 1px solid rgb(92, 93, 95); box-shadow: rgb(204, 204, 204) 0px 0px 3px; color: white; display: block; font-family: Arial, Helvetica, sans-serif; font-size: 15px; margin: 5px 0px; padding: 5px 15px; text-shadow: rgb(102, 102, 102) 0px -1px 0px;">$ sudo systemctl status postgresql.service</span></div>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">you should see it started and ready.</span></span></div>
</div>
</div>
</div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;">That’s all, your PostgreSQL is at 9.5 version, with all its new features available.</span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: Open Sans;"><span style="font-size: 14px;"><a href="http://www.hackthesec.co.in/">HackTh3Sec</a></span></span></div>
</div>

Upgrading to PostgreSQL 9.5 in Fedora 24

Upgrading to PostgreSQL 9.5 in Fedora 24 PostgreSQL , often simply Postgres, is an object-relational database (ORDBMS) – i.e. a RDBMS, w...

How to Install and Configure phpMyAdmin on CentOS 6

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-size: large;"><u>Install and Configure phpMyAdmin on CentOS</u></span></h1>
<div>
<div style="background-color: white;">
<span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><b>phpMyAdmin </b>is a free and open source tool written in PHP intended to handle the administration of <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> or <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB </a>with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions</span></span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_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/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><br /></span></div>
<div style="background-color: white;">
<span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Features</u></b></span></span></div>
<div style="background-color: white;">
<ul style="text-align: left;">
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Web interface</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">MySQL and MariaDB database management</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Import data from CSV and SQL</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Export data to various formats: CSV, <a href="http://www.hackthesec.co.in/search/label/sql">SQL</a>, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Administering multiple servers</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Creating PDF graphics of the database layout</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Creating complex queries using Query-by-Example (QBE)</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Searching globally in a database or a subset of it</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.</span></li>
<li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Working with different operating systems</span></li>
</ul>
<div style="background-color: white;">
<span style="line-height: 26px;"><span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><b><u>Add the EPEL Repository</u></b></span></span></div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/search/label/phpmyadmin">phpMyAdmin </a>is part of Extra Packages for Enterprise Linux (<a href="http://www.hackthesec.co.in/search/label/EPEL">EPEL</a>), which is a community repository of non-standard packages for the <a href="http://www.hackthesec.co.in/search/label/RHEL">RHEL</a> distribution. First, we’ll install the EPEL repository:</span></div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">rpm -iUvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm</span></span></span></pre>
</div>
<div style="background-color: white;">
<span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><u>Install phpMyAdmin</u></span></span></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.</span></span></div>
<div style="background-color: white;">
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">yum -y update</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After That Run Following Command:-</span></span></div>
</div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="line-height: 15.6px;"><span style="color: white;">yum -y install </span><span style="color: orange;">phpmyadmin</span></span></span></pre>
</div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">To secure <b>phpMyAdmin </b>we should lock down access to a specific IP address. When the phpMyAdmin package is installed, an Apache Virtual Host file is added to configure web access. Let’s edit that file:</span></span></div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# vi </span><span style="line-height: 15.6px;"><span style="color: white;">/etc/httpd/conf.d/</span><span style="color: lime;">phpMyAdmin.conf</span></span></span></pre>
</div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">By default, the configuration for phpMyAdmin only allows access from the server on which it is installed. so you want to allow for all or you can only use your IP address for access..</span></span></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
Require ip 127.0.0.1</div>
<div>
<br /></div>
<div>
Allow from 127.0.0.1</div>
<div>
<br /></div>
<div>
Require ip 127.0.0.1</div>
<div>
<br /></div>
<div>
Allow from 127.0.0.1</div>
<div>
Allow from your IPadress ... </div>
<div>
Or </div>
</span></span></div>
<div style="background-color: white;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Just Commit the following line </span></span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">"</span></span><span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="font-family: Verdana, Geneva, sans-serif;"><b><span style="color: red;">Deny from All</span></b><span style="color: #222222;">"</span></span></span></div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: medium;"><span style="line-height: 15.6px;"><span style="color: white;"> <IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
</span><span style="color: lime;">     #Deny from All
</span><span style="color: white;">     Allow from 127.0.0.1
     Allow from ::1
   </IfModule></span></span></span><span style="font-family: Times New Roman;"><span style="white-space: normal;">
</span></span></pre>
<div>
<span style="color: #222222; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Restart Apache:</u></b></span></span></div>
</div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">service httpd restart</span></span></pre>
<div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Verify that phpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. </span></span></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">For example: http://demo.hackthesec.co.in/phpmyadmin</span></span></div>
</div>
</div>
<div>
<span style="color: #222222; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></div>
</div>

How to Install and Configure phpMyAdmin on CentOS 6

Install and Configure phpMyAdmin on CentOS phpMyAdmin is a free and open source tool written in PHP intended to handle the administrati...

How to Backup and Restore a MySQL Database

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="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;"><u><i>Backup and Restore a MySQL Database</i></u></span></h2>
<div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><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;">MySQL</span> is a database server for storing data permanently. If you are using <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL </a>server for an production use, then its necessary to create dataase backup for recovering from any crash. <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL </a>provides an utility <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><a href="http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html" style="outline: none; text-decoration: none; transition: all 0.25s linear;" target="_blank">mysqldump</a> </span>for taking backups. In this article you will learn, to taken databases backup in<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;">.sql</span> format for archive format. Also we will explain various options for it.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s1600/mysq-linux-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="145" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s200/mysq-linux-www.hackthesec.co.in.jpg" width="200" /></a></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="color: #0b5394; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px;">Options for Creating <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL </a>Databases Backup</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: Georgia, Times New Roman, serif;">You have many options for creating databases backups. read few options below. For this example we have using databse name “<b>mydb</b>”.</span></div>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">1. Full Database Backup in Plain .sql File</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"> # mysqldump -u root -p </span><span style="color: lime;">mydb > mydb.sql</span><span style="color: white;">
</span></span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">2. Full Database Backup in Archive</span><span style="color: red;"> .sql.gz File</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"> # mysqldump -u root -p mydb | </span><span style="color: lime;"><orange>gzip</orange> </span><span style="color: white;">> mydb.sql.gz
</span></span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">3. Backup Single Table Only</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"> # mysqldump -u root -p </span><span style="color: lime;">mydb <orange>tbl_student</orange></span><span style="color: white;"> > tbl_student.sql
</span></span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">4. Backup Multiple Databases</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># mysqldump -u root -p </span><orange><span style="color: lime;">--databases mydb1 mydb2 mydb3</span></orange><span style="color: white;"> > mydb1-mydb2-mydb3.sql
</span></span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">5. Backup All Databases</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"> # mysqldump -u root -p </span><orange><span style="color: lime;">--all-databases</span></orange><span style="color: white;"> > all-db-backup.sql
</span></span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">6. Backup Database Structure Only (no data)</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"> # mysqldump -u root -p </span><span style="color: lime;"><orange>--no-data</orange> mydb > mydb.sql</span><span style="color: white;">
</span></span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">7. Backup Database Data Only (no table structure)</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"> # mysqldump -u </span><span style="color: lime;">root -p <orange>--no-create-info</orange></span><span style="color: white;"> mydb > mydb.sql
</span></span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">8. Backup MySQL Database in XML Format</span></h3>
<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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"> # </span><span style="color: lime;">mysqldump -u root -p <orange>--xml</orange></span><span style="color: white;"> mydb > mydb.xml
</span></span></pre>
<h2 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;">How to Restore MySQL Backup</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">For restoring databases from backup is quite simple. We use mysql command for it. For example following command will restore all backup from <b>mydb.sql</b> to <b>mydb database</b>.</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-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># mysql</span><span style="color: lime;"> -u root -p mydb</span><span style="color: white;"> < mydb.sql

HackTheSec
<a href="https://www.twitter.com/hackthesecurity" target="_blank">Hack The Sec Twitter</a>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></pre>
</div>
</div>

How to Backup and Restore a MySQL Database

Backup and Restore a MySQL Database MySQL is a database server for storing data permanently. If you are using MySQL server for an prod...

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

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

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

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

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

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

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

psql (9.5.0)
Type "help" for help.

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

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

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

Wordpress Booking Calendar Contact Form Plugin <=1.1.23 - Unauthenticated SQL injection

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 style="background-color: white; box-sizing: border-box; color: #555555; font-family: 'Noto Sans', sans-serif; font-size: 38px; font-stretch: normal; font-weight: 300; line-height: 1.4; margin: 0px; text-align: center;">
Wordpress Booking Calendar Contact Form Plugin <=1.1.23 - Unauthenticated SQL injection</h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtXZg-SlA0i8XUvoSaEyFAvo9IFtcMjxKsekfQZwn3xwDtpxtbMlp5MZSrJqv2xNJlN21JaBsVP4caF9aLRrXH4UJ64Z6reVGA2fAokl_s_D3gwvnY8OksYCQZqGHdFvHvJ_KWxPfuD9N5/s1600/sql-injection_www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjtXZg-SlA0i8XUvoSaEyFAvo9IFtcMjxKsekfQZwn3xwDtpxtbMlp5MZSrJqv2xNJlN21JaBsVP4caF9aLRrXH4UJ64Z6reVGA2fAokl_s_D3gwvnY8OksYCQZqGHdFvHvJ_KWxPfuD9N5/s1600/sql-injection_www.hackthesec.co.in.jpg" /></a></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<table class="exploit_list" style="background-color: rgb(239, 239, 239) !important; border-radius: 3px !important; border-spacing: 1px; border: 1px solid rgb(221, 221, 221) !important; box-sizing: border-box; color: #666666; font-family: 'Open Sans', sans-serif; font-size: 14px; line-height: 24px; margin-bottom: 10px; margin-top: 10px; padding: 1px !important; width: 675px;"><tbody style="box-sizing: border-box;">
<tr style="background-color: rgb(248, 248, 248) !important; box-sizing: border-box;"><td style="box-sizing: border-box; padding: 5px 10px;">Unauthenticated SQL injection</td><td style="box-sizing: border-box; padding: 5px 10px;"><br /></td><td style="box-sizing: border-box; padding: 5px 10px;"><br /></td></tr>
<tr style="background-color: rgb(248, 248, 248) !important; box-sizing: border-box;"><td style="box-sizing: border-box; padding: 5px 10px;"><br /><table class="exploit_list" style="background-color: rgb(239, 239, 239) !important; border-radius: 3px !important; border-spacing: 1px; border: 1px solid rgb(221, 221, 221) !important; box-sizing: border-box; color: #666666; font-size: 14px; line-height: 24px; margin-bottom: 10px; margin-top: 10px; padding: 1px !important; width: 675px;"><tbody style="box-sizing: border-box;">
<tr style="background-color: rgb(248, 248, 248) !important; box-sizing: border-box;"><td style="box-sizing: border-box; padding: 5px 10px;"><strong style="box-sizing: border-box;">Author:</strong> i0akiN SEC-LABORATORY</td></tr>
</tbody></table>
</td><td style="box-sizing: border-box; padding: 5px 10px;"><br /></td><td style="box-sizing: border-box; padding: 5px 10px;"><br /></td></tr>
<tr style="background-color: rgb(248, 248, 248) !important; box-sizing: border-box;"><td style="box-sizing: border-box; padding: 5px 10px;"><strong style="box-sizing: border-box;">Download Exploit:</strong> <a href="https://www.exploit-db.com/download/39309" style="background-color: transparent; box-sizing: border-box; color: #337ab7; outline: 0px; text-decoration: none; transition-duration: 0.3s; transition-property: background-color, box-shadow, border, color, opacity;"><span class="fa fa-file-code-o" style="-webkit-font-smoothing: antialiased; box-sizing: border-box; display: inline-block; font-family: FontAwesome; font-size: inherit; font-stretch: normal; line-height: 1; text-rendering: auto;"></span> Source</a> </td><td colspan="2" style="box-sizing: border-box; padding: 5px 10px;"><br /></td></tr>
</tbody></table>
</div>
</div>

Wordpress Booking Calendar Contact Form Plugin <=1.1.23 - Unauthenticated SQL injection

Wordpress Booking Calendar Contact Form Plugin <=1.1.23 - Unauthenticated SQL injection Unauthenticated SQL injection Author...

How to Install MariaDB 10 on CentOS 7 / RHEL 7

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-size: large;">Installing MariaDB 10 on CentOS 7 / RHEL 7</span><br />
<span style="color: #990000; font-size: large;"><br /></span>
<br />
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
Installing MariaDB became very easy on the latest CentOS /RHEL Linux version 7. During initial setup MariaDB has a tick in the graphical setup environment which enables MariaDB and replaces MySQL.</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgwMo7BsU9vXIg51zHiq2lMsv2y7hRKUvaoj7vkZSOz8WWkOumvYMDMA7fZ5G7JT5EMKGHuXZiahQ3Y1KaeePAz68lb_7x-Fchyphenhyphen_GulaqeLuyepipFNiGPIFPPEy1WAazZkeHY4_Nmag9k/s1600/MariaDB_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/AVvXsEgwMo7BsU9vXIg51zHiq2lMsv2y7hRKUvaoj7vkZSOz8WWkOumvYMDMA7fZ5G7JT5EMKGHuXZiahQ3Y1KaeePAz68lb_7x-Fchyphenhyphen_GulaqeLuyepipFNiGPIFPPEy1WAazZkeHY4_Nmag9k/s1600/MariaDB_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
<br /></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
During installation the section</div>
<div style="background-color: white; color: #333333; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
<img alt="" src="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos3.png" style="border: 0px; height: 21px; margin: 10px; max-width: 100%; vertical-align: middle; width: 203px;" /></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
allows enabling a MariaDB server.</div>
<div style="background-color: white; color: #333333; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 1.1em; line-height: 1.5em; margin-bottom: 10px;">
<img alt="" src="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos2.png" style="border: 0px; height: 56px; margin: 10px; max-width: 100%; vertical-align: middle; width: 300px;" /></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<br class="Apple-interchange-newline" />
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">If you prefer the command line the installation can be performed with:</span></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;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># yum install mariadb-server</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">MariaDB is shipped untuned and not protected with MariaDB version 5.5.35. </span></span><br />
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">No basic optimizations in the configuration file have been set and the root user has no password. </span></span><br />
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">An update will install the version 5.5.37. (The latest version of MariaDB October 2014 is Version 5.5.39).</span></span></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;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">yum update</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">It is important to secure the server. MariaDB is shipped with a script to harden the system accordingly using a user dialog. </span></span><br />
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">It is highly recommended to use this script before creating and populating the databases.</span></span></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;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">mysql_secure_installation</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">Install the latest Version 10 is an easy step since MariaDB's repository configuration wizard <a href="https://downloads.mariadb.org/mariadb/repositories" style="text-decoration: none;"><span style="color: red;">https://downloads.mariadb.org/mariadb/repositories</span></a> has now the latest CentOS/RHEL version available.</span></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">Before installing 10.0 it is important to perform a backup and remove the existing 5.5 version</span></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">if you have.</span></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;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">yum remove mariadb-server mariadb-libs</span></span></pre>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-size: large; line-height: 23.0999984741211px;">Create the repository settings using the link and follow the steps <a href="https://downloads.mariadb.org/mariadb/repositories"><span style="color: red;">MariaDB</span></a></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="480" src="https://mariadb.com/sites/default/files/elfinder/94/Blog/centos.png" width="640" /></a></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<br /></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: large; line-height: 18px;">Here is your custom MariaDB YUM repository entry for CentOS. Copy and paste it into a file</span></div>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "helvetica neue" , "helvetica" , "arial" , sans-serif; font-size: large; line-height: 18px;">under /etc/yum.repos.d/ (we suggest naming the file MariaDB.repo or something similar).</span></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;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># MariaDB 10.0 CentOS repository list - created 2016-01-25 08:01 UTC
# http://mariadb.org/mariadb/repositories/
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1</span></span></pre>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 18px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">After the file is in place, install MariaDB with:</span></span></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;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">sudo yum install MariaDB-server MariaDB-client</span></span></pre>
<div style="background-color: white; font-family: HelveticaNeue-Light, 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; line-height: 1.5em; margin-bottom: 10px;">
</div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 23.0999984741211px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: large;">You are now running the latest 10.0 version!</span></span></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;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">/etc/init.d/mysql start
# </span></span><span style="background-color: transparent; font-size: 12px; line-height: 15.6000003814697px;"><span style="color: white;">mysql_upgrade</span></span></pre>
<ul style="text-align: left;">
<li><span style="font-size: large; line-height: 1.5em;"><a href="http://www.hackthesec.co.in/2016/01/install-mariadb-on-centos-6.html"><span style="color: red;">Install MariaDB On Centos 6</span></a></span></li>
</ul>
</div>

How to Install MariaDB 10 on CentOS 7 / RHEL 7

Installing MariaDB 10 on CentOS 7 / RHEL 7 Installing MariaDB became very easy on the latest CentOS /RHEL Linux version 7. During initi...