Hack The Sec-Leading Resource Of Linux Tutorial

How to Install and Configure phpMyAdmin on Fedora 21

<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 Fedora</u></span></h1>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="color: #222222;"><b>phpMyAdmin </b>is a free and open source tool written in PHP intended to handle the administration of <span style="color: #999999;">MySQL</span> 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-size: 15px; line-height: 26px;">.</span></div>
<div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px; 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="color: #999999; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" style="border: 1px solid rgb(192, 192, 192); height: auto; max-width: 95%; padding: 4px; transition: all 0.4s ease-in-out;" /></a></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222; font-size: 15px; line-height: 26px;"><br /></span></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #0b5394; font-family: 'Trebuchet MS', sans-serif; font-size: medium;"><span style="line-height: 26px;"><b><u>Features</u></b></span></span></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<ul style="font-size: 12px;">
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Web interface</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">MySQL and MariaDB database management</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Import data from CSV and SQL</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Export data to various formats: CSV, <a href="http://www.hackthesec.co.in/search/label/sql" style="color: #999999; text-decoration: none;">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-size: 15px; line-height: 26px;">Administering multiple servers</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Creating PDF graphics of the database layout</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Creating complex queries using Query-by-Example (QBE)</span></li>
<li><span style="color: #222222; font-size: 15px; line-height: 26px;">Searching globally in a database or a subset of it</span></li>
<li><span style="color: #222222; 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-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-size: 15px; line-height: 26px;">Working with different operating systems</span></li>
</ul>
<div style="line-height: 19.2px;">
<span style="color: #0b5394; font-family: 'Trebuchet MS', sans-serif;"><span style="line-height: 26px;"><u><span style="font-size: large;">Install phpMyAdmin</span></u></span></span></div>
<div style="font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><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="line-height: 19.2px;">
<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; 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 style="font-size: 12px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">After That Run Following Command:-</span></span></div>
</div>
<div style="line-height: 19.2px;">
<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; 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="font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><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="line-height: 19.2px;">
<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; 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="font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><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>
</div>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><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; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Just Commit the following line </span></span><span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">"</span></span><span style="background-color: transparent; font-size: 15px; line-height: 26px;"><b><span style="color: red;">Deny from All</span></b><span style="color: #222222;">"</span></span></div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<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="line-height: 15.6px;"><span style="color: white;"> <span style="font-size: large;"><IfModule !mod_authz_core.c>
     # Apache 2.2
     Order Deny,Allow
</span></span><span style="font-size: large;"><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'; font-size: 12px;"><span style="white-space: normal;"></span></span></pre>
<div style="font-size: 12px;">
<span style="color: #222222; font-family: 'Trebuchet MS', sans-serif; font-size: medium;"><span style="line-height: 26px;"><b><u>Restart Apache:</u></b></span></span></div>
</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"><span style="font-size: large;">service httpd restart</span></span></span></pre>
<div>
<div>
<span style="color: #222222;"><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 style="font-size: 12px;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">For example: http://demo.hackthesec.co.in/phpmyadmin</span></span></div>
</div>
</div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
<span style="color: #222222; font-size: 15px; line-height: 26px;"><span style="color: #999999;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div>
</div>
</div>

How to Install and Configure phpMyAdmin on Fedora 21

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

How to Install XCache on CentOS 7

<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="color: #990000; font-size: large;"><u>Install XCache on CentOS 7</u></span></h1>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>XCache </b>is a fast, stable PHP opcode cacher that has been tested and is now running on production servers under high load. It is tested on Linux and FreeBSD and supported under Windows, for thread-safe and non-thread-safe versions of <a href="http://www.hackthesec.co.in/search/label/PHP">PHP</a>. </span></span></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgoaGzLVYtwGWCXkETZzrBFFUA0oQgo43s3rAGOnq0uCM9-kXZmyvCUzDN5qZxY8B5gzAS8J0nNb2fGvC1g8zPIX3mMba7D1HxBszQUj-WwPjlZMcmqHhPyeADRMmEeUgDvCs-uaOaaTbF7/s1600/xcache-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/AVvXsEgoaGzLVYtwGWCXkETZzrBFFUA0oQgo43s3rAGOnq0uCM9-kXZmyvCUzDN5qZxY8B5gzAS8J0nNb2fGvC1g8zPIX3mMba7D1HxBszQUj-WwPjlZMcmqHhPyeADRMmEeUgDvCs-uaOaaTbF7/s1600/xcache-www.hackthesec.co.in.jpg" /></a></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">This relatively new opcode caching software has been developed by mOo, one of the developers of Lighttpd, to overcome some of the limitations of the existing solutions at that time; such as being able to use it with new <a href="http://www.hackthesec.co.in/search/label/PHP">PHP </a>versions as they arrive.</span></span></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Step 1 : - Install the EPEL Repository</u></b></span></span></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">XCache </span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">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 RHEL distribution. First, we’ll install the EPEL repository:</span></span></div>
<div>
<a href="http://www.hackthesec.co.in/2016/01/how-to-install-epel-repo-on-centos-and.html" itemprop="url" style="background-color: white; display: block; font-family: 'Open Sans', serif, sans-serif; font-size: 18.6px; font-weight: 600; text-decoration: none;"></a><ul style="text-align: left;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-epel-repo-on-centos-and.html" itemprop="url" style="background-color: white; display: block; font-family: 'Open Sans', serif, sans-serif; font-size: 18.6px; font-weight: 600; text-decoration: none;"></a>
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-install-epel-repo-on-centos-and.html" itemprop="url" style="background-color: white; display: block; font-family: 'Open Sans', serif, sans-serif; font-size: 18.6px; font-weight: 600; text-decoration: none;"></a><a href="http://www.hackthesec.co.in/2016/01/how-to-install-epel-repo-on-centos-and.html" itemprop="url" style="display: inline !important; font-size: 18.6px; text-decoration: none;"><span style="color: red;">How To Install EPEL Repo on a CentOS and RHEL 7.x</span></a></li>
</ul>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: orange; font-size: large;"><span style="line-height: 15.6px;">sudo rpm -iUvh http://dl.fedoraproject.org/pub/epel/7/x86_64/e/epel-release-7-5.noarch.rpm</span></span></pre>
<div>
<div>
<span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Step 2 : - Install the XCache</u></b></span></span></div>
</div>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Before start the installation we just update our server through following command line</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">sudo yum -y update</span></span></pre>
<div>
</div>
</div>
<div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then let’s install XCache and any required packages:</span></span></div>
</div>
<div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="line-height: 15.6px;"><span style="color: white;">sudo yum -y install </span><span style="color: lime;">php-xcache xcache-admin</span></span></span></pre>
<div>
</div>
</div>
<div>
</div>
</div>
<div>
<span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Step 3 :- Verify the Extension is Available</u></b></span></span></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now verify that the extension is available by using the following command:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="line-height: 15.6px;"><span style="color: white;">php -m | </span><span style="color: lime;">grep XCache</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Your result should be:</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="font-size: 14px; line-height: 20px; white-space: pre-wrap;">XCache
XCache Cacher
XCache Coverager
XCache Optimizer
XCache
XCache Cacher
XCache Coverager
XCache Optimizer</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Listing the PHP version should now include information about XCache as well:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: lime; font-size: large;"><span style="line-height: 15.6px;">php -v</span></span></pre>
</div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="font-size: 14px; line-height: 20px; white-space: pre-wrap;">PHP 5.4.16 (cli) (built: Mar 9 2016 12:59:36)
Copyright (c) 1997-2013 The PHP Group
Zend Engine v2.4.0, Copyright (c) 1998-2013 Zend Technologies
with XCache v3.1.1, Copyright (c) 2005-2014, by mOo
with XCache Optimizer v3.1.1, Copyright (c) 2005-2014, by mOo
with XCache Cacher v3.1.1, Copyright (c) 2005-2014, by mOo
with XCache Coverager v3.1.1, Copyright (c) 2005-2014, by mOo
</span></span></pre>
</div>
<div>
<span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="font-size: 14px; line-height: 20px; white-space: pre-wrap;"><br /></span></span></div>
<div>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a><br /><a href="https://www.twitter.com/Hackthesecurity">Hack The Sec-Twitter</a></div>
</div>

How to Install XCache on CentOS 7

Install XCache on CentOS 7 XCache is a fast, stable PHP opcode cacher that has been tested and is now running on production servers unde...

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

Linux – Top memory usage by process

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; clear: both; color: #333333; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 40px; margin: 10px 0px; text-rendering: optimizeLegibility;">
<span style="font-size: x-large;"><u>Linux – Top memory usage by process</u></span></h1>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Here are a couple of commands to help find top memory wasters</span></span><span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_Ogf5PmKNi9d9wfqxdw6uOec_fxPD_AsnOZvk2aplKfm27QjBNpGmRUwliyQt0qN0rGSZbGwsQPI3m27mcWp7A9yoWoM7-fj2bmOuOYKSbhoJ2xevlF2Fp_PMzFxgA9GC1CPDKOgJRMDL/s1600/memory-utilization-monitoring-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/AVvXsEg_Ogf5PmKNi9d9wfqxdw6uOec_fxPD_AsnOZvk2aplKfm27QjBNpGmRUwliyQt0qN0rGSZbGwsQPI3m27mcWp7A9yoWoM7-fj2bmOuOYKSbhoJ2xevlF2Fp_PMzFxgA9GC1CPDKOgJRMDL/s1600/memory-utilization-monitoring-www.hackthesec.co.in.png" /></a></div>
<div>
<span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><br /></span></div>
<div>
<span style="background-color: white;"><div style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">
<b><u>Process – Sorted by occupied memory(2 column)1</u></b></div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">ps -e -orss=,pid=,args= | sort -nr | head|awk '{print $2"\t"$1/1024"\tMB\t"$3;}'</code></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;"><b><u>Method 2</u></b></span></div>
<div>
<div>
<pre style="background-color: whitesmoke; 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(204, 204, 204); box-sizing: border-box; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="font-size: 14px; line-height: 20px; white-space: pre-wrap;">cat /proc/meminfo |grep MemTotal
echo ' ' | awk '{ system("cat /proc/meminfo |grep MemTotal") }'</span></span></pre>
<pre style="background-color: whitesmoke; 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(204, 204, 204); box-sizing: border-box; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="font-size: 14px; line-height: 20px; white-space: pre-wrap;">totalmem=$(cat /proc/meminfo |grep MemTotal | awk '{print $2}');
 
ps -e -orss=,pid=,args= | sort -nr | head|awk '{print $2"\t"$1/1024"\t"$3"\t"$totalmem;}'</span></span></pre>
</div>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Disk Usage</u></b></span></span></div>
<div>
<div>
<pre style="background-color: whitesmoke; 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(204, 204, 204); box-sizing: border-box; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="font-size: 14px; line-height: 20px; white-space: pre-wrap;">sudo du -hx --max-depth=2 / |egrep "^[0-9\.]+G"
 
# show home directory
echo ' ' | awk '{ system("ls -la ~") }'</span></span></pre>
</div>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</span></div>
</div>

Linux – Top memory usage by process

Linux – Top memory usage by process Here are a couple of commands to help find top memory wasters . Process – Sorted by occupied ...

Remote Desktop to Linux Servers

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="single-title" style="background: rgb(255, 255, 255); border: 0px; clear: both; color: #4e4e4e; font-family: 'Myriad Pro', 'Trebuchet MS', Helvetica, Arial, sans-serif; font-size: 32px; margin: 0.5em 0px 0.3em; padding: 0px; vertical-align: baseline;">
<u>Remote Desktop to Linux Servers Ubuntu</u></h1>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Remote Desktop Services (RDS), known as Terminal Services. RDS is Microsoft's implementation of thin client, where Windows software and the entire desktop of the computer running RDS, are made accessible to a remote client machine that supports Remote Desktop Protocol (RDP). With RDS, only software user interfaces are </span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTAnp93KyzjRLj6YF_6flanORVzzlWAOEUSsu7-naJ2RL4ZSsoal_DO4A11B5AlOO4COfJqC6RSsp8SP8JruIutt3sGLzYJreo4pz5rh7Rbk2X3sXsoHwq3PAxHJB9qxac2-T8DAYP7zeX/s1600/rdp-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/AVvXsEgTAnp93KyzjRLj6YF_6flanORVzzlWAOEUSsu7-naJ2RL4ZSsoal_DO4A11B5AlOO4COfJqC6RSsp8SP8JruIutt3sGLzYJreo4pz5rh7Rbk2X3sXsoHwq3PAxHJB9qxac2-T8DAYP7zeX/s1600/rdp-www.hackthesec.co.in.png" /></a></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">transferred to the client system. All input from the client system is transmitted to the server, where software execution takes place</span></span><span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></div>
<div>
<span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><b><u>RUN THE FOLLOWING COMMAND</u></b></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: #333333; line-height: 19.2px; 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]# sudo </span><span style="line-height: 15.6px;"><span style="color: lime;">apt-get </span></span><span style="color: white; line-height: 15.6px;">update</span></span></pre>
</div>
<div>
<span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">After That</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large; line-height: 15.6px;">[root@hackthesec]#</span><span style="font-size: large;"><span style="color: #333333; line-height: 19.2px;"><span style="color: white; line-height: 15.6px;"> </span></span><span style="background-color: transparent; line-height: 15.6px;"><span style="color: white;">sudo apt-get install xrdp</span></span></span></pre>
</div>
<div>
<span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">After That</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">echo “gnome-session –session=gnome-classic” > .xsession</span></span></pre>
</div>
<div>
<span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">After That Restart The Demon through following command.</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">sudo /etc/init.d/xrdp restart</span></span></pre>
</div>
<div>
<div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">You can use a different session types for the gnome session:</span></span></div>
</div>
</div>
<div>
<ul style="text-align: left;">
<li><a href="http://www.hackthesec.co.in/search/label/Ubuntu">ubuntu</a></li>
<li>gnome-classic</li>
<li>gnome-fallback</li>
<li>ubuntu-2d</li>
</ul>
<div>
<span style="color: #0b5394; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>For different desktops </u></b></span></span></div>
</div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">To use GNOME Fallback ("GNOME Classic (no effects)"): </span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">echo gnome-session --session=gnome-fallback > ~/.xsession</span></span></pre>
</div>
<div>
<span style="background-color: white; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;">Or, to use Xfce ("Xubuntu Session"):</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">echo xfce4-session > ~/.xsession</span></span></pre>
</div>
<div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Or, to use LXDE ("Lubuntu Desktop"):</span></span></div>
<div>
</div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">echo lxsession -s Lubuntu -e LXDE > ~/.xsession

echo lxsession -s LXDE -e LXDE > ~/.xsession

/usr/bin/startkde  > .xsession  # for kde desktop

sample .xsession file ;

#gnome-session --session=gnome-classic
#lxsession  -s LXDE -e LXDE
#lightdm --session-child 12 25 
#xfce4-session
/usr/bin/startkde</span></span></pre>
</div>
<div>
<a href="http://www.hackthesec.co.in/">HackTheSec</a></div>
</div>

Remote Desktop to Linux Servers

Remote Desktop to Linux Servers Ubuntu Remote Desktop Services (RDS), known as Terminal Services. RDS is Microsoft's implementation ...

How To Install Rails and Nginx with Passenger on Ubuntu

How To Install Rails and Nginx with Passenger on Ubuntu

Rails and Nginx with Passenger on Ubuntu Ruby on Rails is an open source web application framework which runs on the Ruby programming l...

How To Deploy Django on Nginx, Gunicorn with Postgres

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline" style="background-color: #fdfdfd; box-sizing: border-box; color: #333333; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 1.1; margin: 21px 0px 0px;">
<span style="font-size: x-large;"><u>Deploy Django on Nginx, Gunicorn with Postgres</u></span></h1>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Django is a free and open source web application framework, written in Python, which follows the model–view–controller architectural pattern. It is maintained by the Django Software Foundation (DSF) and its primary goal is to ease the creation of complex, database-driven websites.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiMEGCyo9ljF0oPyw-VbCfDEHZ8qfwqo8gZu_qkOtzo7ic2pvoDaAY40thEUwjoSSB5f_THjDcq1cgFVapXjnWNhI6iOQLMzvgPepD_XpWJpZtPsORy6Luawzr8sZA21DmK-RxxC__7P85w/s1600/django_with_postgres_tw-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/AVvXsEiMEGCyo9ljF0oPyw-VbCfDEHZ8qfwqo8gZu_qkOtzo7ic2pvoDaAY40thEUwjoSSB5f_THjDcq1cgFVapXjnWNhI6iOQLMzvgPepD_XpWJpZtPsORy6Luawzr8sZA21DmK-RxxC__7P85w/s1600/django_with_postgres_tw-www.hackthesec.co.in.jpg" /></a></div>
<div>
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="font-size: large;"><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">This tutorial applies to <a href="http://www.hackthesec.co.in/search/label/Debian">Debian 7</a>. (but might work on the similar distributions). Before we start with the installation, we need to make sure that our system and our repositories are up to date and then we need to install and create <b>virtualenv</b></span></span><span style="background-color: white; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></span></div>
<div>
<span style="font-family: Courier New, Courier, monospace; font-size: large;"><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); line-height: 15.6px; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline; white-space: pre;"><span style="color: white;"># sudo apt-get update
# sudo apt-get upgrade
</span><span style="color: lime;"># sudo apt-get install python-virtualenv
# sudo virtualenv /opt/virtuale</span></pre>
</span></div>
<div>
<span style="font-size: large;"><div style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">
We have now created the directory which will be the home for <b>virtualenv</b>. Before we proceed with Python packages installation, we need to activate our virtualenv.</div>
<div style="font-family: Verdana, Geneva, sans-serif; line-height: 26px;">
<div style="font-family: 'Times New Roman'; line-height: normal;">
<span style="color: lime; font-family: Courier New, Courier, monospace; font-size: large;"><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); line-height: 15.6px; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># source /opt/virtualenv/bin/activate</pre>
</span></div>
<div style="color: black; font-family: 'Times New Roman'; line-height: normal;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: large;"></span></div>
</div>
<div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">We will now notice that see that (<b>virtualenv</b>) has been appended to the beginning of the terminal prompt. This will help us know when our virtualenv is active and which virtualenv is active Now it is time to install <b>Django</b>. To do this, we will use pip, a Python package manager much like easy_install:</span></div>
<div>
<div>
<div>
<span style="font-size: large;"><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="line-height: 15.6px;"><span style="color: white;"># pip </span><span style="color: lime;">install django</span></span></pre>
</span></div>
</div>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">We now have Django installed. The next step is the database. Most Django users prefer to use <u><a href="http://www.hackthesec.co.in/search/label/PostgreSQL">PostgreSQL</a></u> as their database server. It is much more robust than MySQL and the Django ORM works much better with PostgreSQL than <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>, MSSQL, or others. We don’t need Virtualenv active for PostgreSQL installation, so we can deactivate it:</span></div>
<div>
<div>
<span style="color: white; font-size: large;"><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="line-height: 15.6px;"># deactivate</span></pre>
<div style="color: black; font-family: 'Times New Roman'; font-size: large;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Then we need to install dependencies for PostgreSQL to work with Django and install PostgreSQL database service:</span></div>
</span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># sudo apt-get install libpq-dev python-dev
# sudo apt-get install </span><span style="color: lime;">postgresql postgresql-contrib</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/search/label/PostgreSQL">PostgreSQL </a>is now installed. Next thing to install is <a href="http://www.hackthesec.co.in/search/label/NGINX">nginx</a>. We will use nginx as web server, since it fast, light-weight server and compatible with Python. To install it, we simply execute:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># sudo </span><span style="color: orange;">apt-get install nginx</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Gunicorn is a very powerful Python WSGI HTTP Server. It is a Python package we need to first activate our virtualenv to install it. With our virtualenv active, we are going to run this command:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># source /opt/myenv/bin/activate
</span><span style="color: lime;"># pip install gunicorn</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Gunicorn is now installed in our virtualenv. At this point we have everything we need installed. Now, we need to proceed with the services configuration process. We will start our configuration with <b>PostgreSQL</b>. With PostgreSQL we need to create a database, create a user, and grant the user we created access to the database we created. Start off by running the following command:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># sudo su – </span><span style="color: lime;">postgres</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Then, we run this command to create your database and once we have now a database that is named newdb, we will create database user:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: lime;"># created newdb
</span><span style="color: white;"># createuser –P</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">We will get a series of 6 prompts during the process. The first one will ask you for the name of the new user. The next two prompts are for our password and confirmation of password for the new user. For the last 3 prompts just enter “n” and hit “enter”. This just ensures your new users only has access to what you give it access to and nothing else. Now we can start <b>PostgreSQL</b> console and set access for the new user that we just created:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: orange;"># psql
</span><span style="color: lime;"># GRANT ALL PRIVILEGES ON DATABASE newdb TO newuser;</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Now that we have database with user that is able to access it, we need to set those parameters in our Django project. We are going to create new Django project. In order to do that, we need to change to virtualenv directory, activate it and then create new project:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># cd /opt/myenv
</span><span style="color: lime;"># source /opt/myenv/bin/activate
</span><span style="color: white;"># django-admin.py startproject newproject</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">We should be able to see a new directory called “newproject” inside our virtualenv directory. This is where our new Django project files live. In order for our project to be able to talk to our database we need to install a additional packages with using pip (while virtualenv still active).</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># pip install </span><span style="color: lime;">psycopg2</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Now, we change into our new project’s directory and edit <b>settings.py</b> file using our favorite editor. The database settings in the file should look like:</span></div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">   DATABASES = {
        'default': {
            'ENGINE': 'django.db.backends.postgresql_psycopg2', # Add 'postgresql_psycopg2', 'mysql', 'sqlite3' or 'oracle'.
            'NAME': 'newdb',                      # Or path to database file if using sqlite3.
            # The following settings are not used with sqlite3:
            'USER': 'newuser',
            'PASSWORD': 'password',
            'HOST': 'localhost',                      # Empty for localhost through domain sockets or           '127.0.0.1' for localhost through TCP.
            'PORT': '',                      # Set to empty string for default.
        }</code></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Now, we should move to our main project directory and make sure virtualenv is activated. Once we make sure that virtualenv is active, we can run the following command so that Django can add its initial configuration and other tables to our database:</span></div>
<div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: orange;"># cd /opt/virtualenv/newproject
</span><span style="color: white;"># source /opt/myenv/bin/activate
</span><span style="color: lime;"># python manage.py syncdb</span></span></pre>
</div>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">We should get some output describing what tables were installed, followed by a prompt asking if you want to create a superuser. This is optional and depends on if we want to use Django’s authentication system or the Django admin.</span></div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;"><br /></span></div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Gunicorn configuration is very specific to our applications needs. First we will go over running Gunicorn with default settings. Here is the command to just run default Gunicorn:</span></div>
<div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># gunicorn_django --bind </span><span style="color: lime;">**your-fully-qualified-domain-name.com**:8001</span></span></pre>
<div style="color: black; font-family: 'Times New Roman';">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">If we now point our browser to our-fully-qualified-domain-name.com:8001, we should get the Django welcome screen. Using the command above, we started one worker process only. In production environment we will need more than one. We can control the number of processes from the command line, so if we want to start 5 worker processes, the command will be:</span></div>
</div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"># gunicorn_django –workers=5 --bind **your-fully-qualified-domain-name.com**:8001</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">If we want to rung Gunicorn and user other than root, then we have:</span></div>
<div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"># gunicorn_django -</span><span style="color: lime;">-workers=5 --user=nobody --bind **your-fully-</span><span style="color: white;">qualified-domain-name.com**:8001</span></span></pre>
</div>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Since we might end up having a lot of different input parameters, it is better if we just create configuration file and use that when starting Gunicorn. We can create our configuration file in virtualenv directory for example (<b>/opt/virtualenv/gunicorn_cfg.py</b>), and put the following configuration for the setting we used before:</span></div>
<div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;">command = '/opt/myenv/bin/gunicorn'
pythonpath = '/opt/myenv/myproject'
</span><span style="color: lime;">bind = '127.0.0.1:8001'
</span><span style="color: white;">workers = 5
user = 'nobody'</span></span></pre>
</div>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Now, if we want to run the server, we should execute the following command:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"># /opt/myenv/bin/gunicorn -c /opt/myenv/gunicorn_config.py myproject.wsgi</span><span style="color: black; font-family: Verdana, Geneva, sans-serif;"><span style="line-height: 15.6px;">
</span></span></span></pre>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">The “-c” flag, tells gunicorn that we have a config file we want to use, which we pass in just after the “-c” flag. We also pass in a Python dotted notation reference to our WSGI file so that Gunicorn knows where our WSGI file is. For further information about Gunicorn, please read the Gunicorn documentation found at gunicorn.org for more on this topic.</span></div>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;"><br /></span></div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">The last thing we need to do is to configure nginx. Since we are only setting <b><a href="http://www.hackthesec.co.in/search/label/NGINX">NGINX</a> </b>to handle static files we need to first decide where our static files will be stored. We should open our <b>settings.py</b> file for our <b>Django </b>project and edit the <b>STATIC_ROOT</b> line to look like this:</span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: orange;">STATIC_ROOT</span><span style="color: white;"> = "/opt/virtualenv/static/"</span></span></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Now that you’ve set up where your static files will be located, we need to configure NGINX to handle the static files and be able to connect to Gunicorn. We should create a new file named <b>/etc/nginx/sites-enabled/newproject</b> and put the following content inside:</span></div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;"><br /></span></div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;">server {
    server_name **your-fully-qualified-domain-name.com**;

access_log off;

location /static/ {
        alias /opt/virtualenv/static/;
    }

location / {
        proxy_pass http://127.0.0.1:8001;
        proxy_set_header X-Forwarded-Host $server_name;
        proxy_set_header X-Real-IP $remote_addr;
        add_header P3P 'CP="ALL DSP COR PSAa PSDa OUR NOR ONL UNI COM NAV"';
    }
}</code></pre>
</div>
<div style="color: #222222; font-family: Verdana, Geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">In order to apply settings, we need to restart Nginx and we are good to go:</span></div>
<div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: lime;"># sudo service nginx restart</span></span></pre>
<div style="color: black; font-family: 'Times New Roman';">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">We are done are ready to go now. We can repeated the procedure for creating new application, have another Gunicorn instance running on another port and have additional nginx configuration file</span></div>
</div>
</div>
</div>
</span></div>
<div>
<a href="http://www.hackthesec.co.in/">HackTheSec</a></div>
</div>

How To Deploy Django on Nginx, Gunicorn with Postgres

Deploy Django on Nginx, Gunicorn with Postgres Django is a free and open source web application framework, written in Python, which foll...

Five Penetration Testing Tools

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; font-family: Roboto, sans-serif; line-height: 50px; margin: 0px 0px 7px; word-wrap: break-word;">
<span style="color: red; font-size: x-large;"><u>Five Pentest Tools for you</u></span></h1>
<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;">
A pentest, short-name for <strong style="box-sizing: border-box;">penetration test</strong>, is a software attack which looks for security weaknesses in a system. Penetration tests are a component of a full security audit. For example, <strong style="box-sizing: border-box;">the Payment Card Industry Data Security Standard requires penetration testing on a regular schedule, and after system changes</strong>.</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;">
In this article, we will talk about five open source pentest tools, but remember that their use against systems not owned by you could <strong style="box-sizing: border-box;">lead to legal troubles</strong>. Keep it in mind!</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiHCMh0WeEAo-bkabVtyxDZC9TXH0YBqADtXH0OG_YQWcHzrv_m53R2GgNi9o8tL3nwdgD1Pz-ajNfWD9UvutWCWF0pPAaGA-27M92MpFuX69xahCwYPFk1nT_zhQUKdJEqBtXV8qmQsmir/s1600/penetration-testing-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/AVvXsEiHCMh0WeEAo-bkabVtyxDZC9TXH0YBqADtXH0OG_YQWcHzrv_m53R2GgNi9o8tL3nwdgD1Pz-ajNfWD9UvutWCWF0pPAaGA-27M92MpFuX69xahCwYPFk1nT_zhQUKdJEqBtXV8qmQsmir/s1600/penetration-testing-www.hackthesec.co.in.jpg" /></a></div>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
</h3>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
<strong style="box-sizing: border-box;">OSWAP ZAP</strong></h3>
<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;">
<strong style="box-sizing: border-box;"><a href="https://www.owasp.org/">OSWAP </a>ZAP</strong> can help a system administrator find malicious codes <strong style="box-sizing: border-box;">embedded in a Web application</strong>. This software lets an admin choose between automated and manual scanning. When starting the session for the first time, admin will be asked whether he wants the session to be persisted.</div>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
</h3>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
<strong style="box-sizing: border-box;">Zenmap</strong></h3>
<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;">
Maybe you already know Nmap, a security scanner used to discover hosts and services on a computer network. Commands given to this program are processed sequentially. This makes more difficult for the administrator to track which commands were erroneously entered in previous steps. <a href="https://nmap.org/zenmap/"><strong style="box-sizing: border-box;">Zenmap</strong> </a>tries to solve this problem, implementing a GUI, and an interface for saving profiles and creating sets of Nmap commands.</div>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
</h3>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
<strong style="box-sizing: border-box;">Scapy</strong></h3>
<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;">
<a href="http://www.secdev.org/projects/scapy/">Scapy </a>is a tool which permits to <strong style="box-sizing: border-box;">interactively decode and inject packets and get answers</strong>. Scapy module can also be imported inside a Python program. There are also optional packages for plotting, 3D graphics, WEP encryption and Web application fingerprinting.</div>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
</h3>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
<strong style="box-sizing: border-box;">BeEF</strong></h3>
</div>
<div>
<strong style="box-sizing: border-box;"><div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px; margin-bottom: 26px;">
<a href="http://beefproject.com/">BeEF </a>(Browser Exploitation Framework) it’s a GUI-based open source tool, which<strong style="box-sizing: border-box;">examines how someone could use the Web browser to exploit vulnerabilities</strong>. It can hook one or more Web browsers and use them as beachheads for launching further attacks against the system</div>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
</h3>
<h3 style="background-color: white; box-sizing: border-box; color: #111111; font-family: Roboto, sans-serif; font-size: 22px; font-weight: 400; line-height: 30px; margin: 27px 0px 17px;">
<strong style="box-sizing: border-box;">sqlmap</strong></h3>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px; margin-bottom: 26px;">
<a href="http://sqlmap.org/">sqlmap </a>is a CLI software designed for automating the process of detecting and exploiting SQL injection flaws and taking over of database servers. It as <strong style="box-sizing: border-box;">full support for MySQL, Oracle, PostgreSQL, Microsoft SQL Server, Microsoft Access, IBM DB2, SQLite, Firebird, Sybase, SAP MaxDB and HSQLDB database management systems</strong>.</div>
<div style="background-color: white; box-sizing: border-box; color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; font-weight: normal; line-height: 26px; margin-bottom: 26px;">
<a href="http://www.hackthesec.co.in/">HACKTHESEC.CO.IN</a></div>
</strong></div>
</div>

Five Penetration Testing Tools

Five Pentest Tools for you A pentest, short-name for penetration test , is a software attack which looks for security weaknesses in a ...

How To Setup SSH Keys

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 1.1; margin: 21px 0px 0px; text-align: center;">
<span style="color: red; font-size: x-large;"><u>Setup SSH Keys</u></span></h1>
<div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">SSH keys are by far the most secure way of logging into your cloud server via SSH. Passwords can be eventually cracked using brute-force attacks if they are too easy. If they are complex passwords, they become very hard to remember and writing them down defeats the purpose of a password.</span></span></div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>SSH </b>keys are nearly impossible to decipher using a brute force attack. If you generate an <a href="http://www.hackthesec.co.in/search/label/SSH">SSH key</a>, you will get a pair of two very long string of characters: a public and private key.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgB-K6lGsBayShpawfyJUyK-w_T51_O2aLcOec6JqeyVBVxXPjj0nI2Cip35_7ga-VRAx8sR10WxPBTb8_CEk1t46cedsUG3ZEc_I2G9EWYzmQ6TFMYjhoxyy9cXPxzdseba1rHUiD4DX9H/s1600/ssh_keys_setup-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/AVvXsEgB-K6lGsBayShpawfyJUyK-w_T51_O2aLcOec6JqeyVBVxXPjj0nI2Cip35_7ga-VRAx8sR10WxPBTb8_CEk1t46cedsUG3ZEc_I2G9EWYzmQ6TFMYjhoxyy9cXPxzdseba1rHUiD4DX9H/s1600/ssh_keys_setup-www.hackthesec.co.in.jpg" /></a></div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Public keys are stored on the server that you’re trying to login to, the only possible tool which could unlock this public key is the private key which will be stored with you. SSH uses this to verify your identity by making sure that your private key can unlock the public key installed on the server.</span></span></div>
</div>
<div style="text-align: justify;">
<span style="font-family: Verdana, Geneva, sans-serif;"><span style="line-height: 26px;"><div>
<b><u><span style="color: #0b5394; font-size: large;">Create the <a href="http://www.hackthesec.co.in/search/label/SSH">SSH</a> key pairs</span></u></b></div>
<div style="color: #222222; font-size: 15px;">
The first step is to generate the combination of the public and private key. This can easily be done by opening a terminal window on the machine you will be using to access the remote server (most likely your own workstation).</div>
<div style="color: #222222; font-size: 15px;">
<br /></div>
<div style="color: #222222; font-size: 15px;">
In this example, we will be using RSA keys. The default values should be the correct ones, so you can simply just press enter to accept the default values. However, you may choose to add a passphrase for additional protection.</div>
<div style="color: #222222; font-size: 15px;">
<br /></div>
<div style="color: #222222; font-size: 15px;">
The passphrase is a password which unlocks your private key, which means that in order for someone to gain access, they must have both the private key and your passphrase. You can opt to not using a passphrase if you do not want to type a password each time.</div>
</span></span></div>
<div style="text-align: justify;">
<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; text-align: left; vertical-align: baseline;"><div style="text-align: justify;">
<span style="color: lime; font-family: Courier New, Courier, monospace; font-size: large;"><span style="line-height: 15.6px;">[root@hackthesec]# ssh-keygen -t rsa</span></span></div>
<div style="text-align: justify;">
<span style="color: white; font-family: Courier New, Courier, monospace; font-size: large;"><span style="line-height: 15.6px;">Generating public/private rsa key pair.</span></span></div>
<div style="text-align: justify;">
<span style="color: white; font-family: Courier New, Courier, monospace; font-size: large;"><span style="line-height: 15.6px;">Enter file in which to save the key (/Users/user/.ssh/id_rsa): test</span></span></div>
<span style="color: white; font-family: Courier New, Courier, monospace; font-size: large;"><span style="line-height: 15.6px;">Enter passphrase (empty for no passphrase):
</span></span><div style="text-align: justify;">
<span style="color: white; font-family: Courier New, Courier, monospace; font-size: large;"><span style="line-height: 15.6px;">Your identification has been saved in /Users/user/.ssh/id_rsa.</span></span></div>
<span style="color: white; font-family: Courier New, Courier, monospace; font-size: large;"><span style="line-height: 15.6px;">Enter same passphrase again:
</span></span><div style="text-align: justify;">
<span style="color: lime; font-family: Courier New, Courier, monospace; font-size: large;"><span style="line-height: 15.6px;">Your public key has been saved in /Users/user/.ssh/id_rsa.pub.</span></span></div>
</pre>
<div style="background-color: white; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;">
</div>
</div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">As you see by the results of the command, we now have an <b>id_rsa</b> and <b>id_rsa.pub</b> file which contain your private and public key respectively. We can now distribute this public key to servers where we would like to use public key authentication.</span></span></div>
<div style="text-align: justify;">
<span style="font-family: Verdana, Geneva, sans-serif;"><span style="line-height: 26px;"><div>
<b><u><span style="color: #0b5394; font-size: large;">Installing Public Key</span></u></b></div>
<div style="color: #222222; font-size: 15px;">
The SSH software stack comes with a useful little program called ssh-copy-id which facilitates the installation of <b>SSH keys</b> on your target server. All you have to do is run the following, replacing user and host by the appropriate information for your remote host.</div>
</span></span></div>
<div style="text-align: justify;">
<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; text-align: left; vertical-align: baseline;"><div style="text-align: justify;">
<span style="font-size: large;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">[root@hackthesec]# </span></span><span style="line-height: 15.6px; text-align: left;"><span style="color: lime; font-family: Courier New, Courier, monospace;">ssh-copy-id</span><span style="color: white; font-family: Courier New, Courier, monospace;"> user@host</span></span></span></div>
</pre>
</div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If your operating system does not have that command included, you can run the following command instead. If you get an error about your<b> .ssh</b> folder not existing, you should login to your server and create that folder by running <b>mkdir ~/.ssh.</b></span></span></div>
<div style="text-align: justify;">
<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; text-align: left; vertical-align: baseline;"><div style="text-align: left;">
<span style="font-size: large;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="line-height: 15.6px;">[root@hackthesec]# </span></span><span style="line-height: 15.6px; text-align: left;"><span style="color: lime; font-family: Courier New, Courier, monospace;">cat /Users/user/.ssh/id_rsa.pub</span><span style="color: white; font-family: Courier New, Courier, monospace;"> | ssh user@host "cat >> ~/.ssh/authorized_keys"</span></span></span></div>
</pre>
</div>
</div>
<div style="text-align: justify;">
<span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">From now on, you can SSH to the server and you will note that your server will not ask for any passwords at all. The only thing it may ask for is your passphrase if you have configured one for your private key.</span></span></div>
<div style="text-align: justify;">
<a href="http://www.hackthesec.co.in/">hackthesec.co.in</a></div>
</div>

How To Setup SSH Keys

Setup SSH Keys SSH keys are by far the most secure way of logging into your cloud server via SSH. Passwords can be eventually cracked u...