Hack The Sec-Leading Resource Of Linux Tutorial

How to Install Microsoft SQL Server (MS SQL) on RHEL (CentOS) / Ubuntu

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: large;"><b><u>Install Microsoft SQL Server (MS SQL) on RHEL (CentOS) / Ubuntu</u></b></span><br />
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: large;"><b><u><br /></u></b></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><a href="https://www.microsoft.com/en-us/sql-server/sql-server-vnext-including-Linux">Microsoft has released SQL Server for Redhat Enterprise Linux and Ubuntu</a>; you can now start testing this latest preview of SQL Server in your environment.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">This version is still in preview; it is meant for testing and development purpose only. Try it on your own.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZXXcInc-trK4J5NeqAuNa4Zp1jUKqAqbLYFWHmr_gRUuDM5GprjeDL01j0Z1dFRrohPR0IAWRGVZv1iwbZiYcC-1vy2zHboxhDLh95tJ2rgs_yCdwgYVcgrT3r2i7c-kkmws3xsDdKr_k/s1600/mssql_server_on_linux.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZXXcInc-trK4J5NeqAuNa4Zp1jUKqAqbLYFWHmr_gRUuDM5GprjeDL01j0Z1dFRrohPR0IAWRGVZv1iwbZiYcC-1vy2zHboxhDLh95tJ2rgs_yCdwgYVcgrT3r2i7c-kkmws3xsDdKr_k/s1600/mssql_server_on_linux.png" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><u>Supported Operating Systems:</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Redhat Enterprise Linux 7.2</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Ubuntu 16.04</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<br />
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><u>Setup Repository:</u></b></span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo apt-get install -y wget
$ wget https://packages.microsoft.com/keys/microsoft.asc
$ sudo apt-key add microsoft.asc
$ curl https://packages.microsoft.com/config/ubuntu/16.04/mssql-server.list | sudo tee /etc/apt/sources.list.d/mssql.list
$ curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list | sudo tee /etc/apt/sources.list.d/msprod.list

### CentOS 7 ###

# yum -y install wget
# wget https://packages.microsoft.com/config/rhel/7/mssql-server.repo
# wget https://packages.microsoft.com/config/rhel/7/prod.repo
# mv *.repo /etc/yum.repos.d/mssql.repo</pre>
<span style="background-color: white; font-size: 15px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Install MS SQL Server on Linux:</u></b></span></span><br />
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo apt-get update
$ sudo apt-get install -y mssql-server

### CentOS 7 ###

# yum install -y mssql-server</pre>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><b>Setup MS SQL server.</b></span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo /opt/mssql/bin/sqlservr-setup

### CentOS 7 ###

# /opt/mssql/bin/sqlservr-setup</pre>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; font-size: 15px;"><span style="color: red; font-family: verdana, geneva, sans-serif;"><b><u>Output:</u></b></span></span><br />
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">Microsoft(R) SQL Server(R) Setup

You can abort setup at anytime by pressing Ctrl-C. Start this program
with the --help option for information about running it in unattended
mode.

The license terms for this product can be downloaded from
http://go.microsoft.com/fwlink/?LinkId=746388 and found
in /usr/share/doc/mssql-server/LICENSE.TXT.

Do you accept the license terms? If so, please type "YES": YES

Please enter a password for the system administrator (SA) account: Enter Admin Password
Please confirm the password for the system administrator (SA) account: Re Enter Admin Password

Setting system administrator (SA) account password...

Do you wish to start the SQL Server service now? [y/n]: n

You can use sqlservr-setup --start-service to start SQL Server, and
sqlservr-setup --enable-service to enable SQL Server to start at boot.

Setup completed successfully.</pre>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Start the MS SQL Service.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo systemctl start mssql-server
$ sudo systemctl enable mssql-server

### CentOS 7 ###

# systemctl start mssql-server
# systemctl enable mssql-server</pre>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; font-size: 15px;"><span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><b><u>Install SQL Server tools on Linux:</u></b></span></span><br />
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">It provides command line tools (sqlcmd and bcp), ODBC drivers and their dependencies.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">### Ubuntu 16.04 ###

$ sudo apt-get install -y mssql-tools

### CentOS 7 ###

# yum install -y mssql-tools</pre>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Steps:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Accept License terms</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><b>Firewall (CentOS / RHEL):</b></span></span><br />
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><b><br /></b></span></span>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Configure the firewall to allow 1433 port so that we can access the SQL server from external machines.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"># firewall-cmd --permanent --zone=public --add-port=1433/tcp
# firewall-cmd --reload</pre>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Connect to MS SQL server:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="background-color: white; font-size: 15px;"></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Once the installation is complete, connect to MS SQL server using the following command.</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">sqlcmd -H 127.0.0.1 -U sa

Password: 
1></pre>
<br />
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-setup">Microsoft Official Document Here</a></span><br />
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span></div>

How to Install Microsoft SQL Server (MS SQL) on RHEL (CentOS) / Ubuntu

Install Microsoft SQL Server (MS SQL) on RHEL (CentOS) / Ubuntu Microsoft has released SQL Server for Redhat Enterprise Linux and Ubuntu ...

How to Install Taskwarrior (terminal based todo application) on Linux

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: large;"><b><u>Install Taskwarrior (terminal based todo application) on Ubuntu/Centos</u></b></span><div>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: large;"><b><u><br /></u></b></span><div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Taskwarrior is Free and Open Source Software that manages your TODO list from your command line. It is flexible, fast, efficient, and unobtrusive. It does its job then gets out of your way.</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">If you spend a lot of time on terminal (as a developer or system administrator) then constantly switching to a web app or another GUI based todo applicaations may not be a very productive thing to do. In that case, you may want to try a simple command line application instead.</span></span></div>
</div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><b><u>Ubuntu based distribution</u></b></span></span></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><b><u><br /></u></b></span></span></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">If you want to install Taskwarrior (terminal based todo application) on Ubuntu And Mint Linux enter following command:</span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">$ sudo apt-get install todo -y</pre>
</div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><b><u>Centos based distribution</u></b></span></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">To install taskwarrior on CentOS 6.x/7.x first enable epel repository and type following command:</span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace, serif;"><span style="font-size: 14px;">$ sudo yum install epel-release -y
$ sudo yum install task -y</span></span><span style="color: white; font-family: monospace, serif; font-size: 14px;">
</span></pre>
</div>
<div>
<br /></div>
<div>
<div>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><u>How to use taskwarior</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Taskwarrior has human-friendly natural command line syntax. You will also like its simplicity. I like how it doesn’t reinforce any particular methodology. Here is a simple command for adding a task:</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace, serif;"><span style="font-size: 14px;">$ task add Example task due:Tomorrow</span></span></pre>
</div>
<div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Example screen:</span></span></div>
</div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCWNNXj1AP77-8anlBbYrQOoVPg1Z9EJR3_imvnFmtTNN2QmC6bztskzpt_O-z_c5ojzjivl_sB6AMJqTyDDOqTlSYp28eYPwupdcfP7ABGDy_aY1Mhdff9_dUR_aao2vb9UwQmNtYyc7Z/s1600/command-line-todo-app.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhCWNNXj1AP77-8anlBbYrQOoVPg1Z9EJR3_imvnFmtTNN2QmC6bztskzpt_O-z_c5ojzjivl_sB6AMJqTyDDOqTlSYp28eYPwupdcfP7ABGDy_aY1Mhdff9_dUR_aao2vb9UwQmNtYyc7Z/s1600/command-line-todo-app.png" /></a></div>
<div>
<br /></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><div>
<u>Few important commands you should know</u></div>
<div>
<br /></div>
<div>
<ul style="text-align: left;">
<li>task add sample task (adding a task, you could specify other things like priority or due date etc)</li>
<li>task list (it lists all the pending task with their ids and other details)</li>
<li>task 5 done (marks the task with the id 5 completed)</li>
<li>task 4 delete (deletes the task with id 4)</li>
<li>task all (displays all the pending and completed tasks)</li>
</ul>
</div>
<div>
If you want to know more about the features read the man pages (man task) or read some tutorials <a href="http://taskwarrior.org/download/task-2.5.0.ref.pdf">on official website</a>.</div>
<div>
<br /></div>
<div>
www.hackthesec.co.in</div>
<div>
<a class="g-profile" href="https://plus.google.com/113492055880844042777" target="_blank">+Linux Tutorial</a> </div>
</span></span></div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">@<a href="https://www.twitter.com/Hackthesecurity">hackthesec</a></span></div>
</div>
</div>

How to Install Taskwarrior (terminal based todo application) on Linux

Install Taskwarrior (terminal based todo application) on Ubuntu/Centos Taskwarrior is Free and Open Source Software that manages your TO...

How to Install and use Log File Navigator – lnav in Ubuntu and CentOS linux

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="post-title entry-title" style="background-color: white; border: 0px; color: #155c8e; font-family: "Titillium Web", Arial, sans-serif; font-stretch: inherit; font-variant-numeric: inherit; font-weight: 400; letter-spacing: -1px; line-height: 1.3em; margin: 0px 0px 10px; padding: 0px; vertical-align: baseline; word-wrap: break-word;">
<span style="font-size: large;"><u>Install and use Log File Navigator – lnav in Ubuntu and CentOS</u></span></h1>
<div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">The Log File Navigator, lnav, is an enhanced log file viewer that takes advantage of any semantic information that can be gleaned from the files being viewed, such as timestamps and log levels. </span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Using this extra semantic information, lnav can do things like interleaving messages from different files, generate histograms of messages over time, and providing hotkeys for navigating through the file. It is hoped that these features will allow the user to quickly and efficiently zero in on problems.</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">In this article we will show you how to install and use The Log File Navigator, lnav, on <a href="http://www.hackthesec.co.in/search/label/Ubuntu">Ubuntu </a>15.04/15.10/ and <a href="http://www.hackthesec.co.in/search/label/Centos">CentOS 7</a>.x</span></span></div>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><div>
<b><u><span style="color: #0b5394;">lnav – Features</span></u></b></div>
<div style="color: #333333;">
<ul style="text-align: left;">
<li>Single log view: all log file contents are merged into a single view based on message timestamps. No need to manually correlate timestamps across multiple windows or figure out the order in which to view rotated log files.</li>
<li>Automatic format detection for several common log files. It also detects gzip/bzi2 files and decompress them automatically on the fly.</li>
<li>Filters: display only lines that match or do not match a set of regular expressions. Filter by error level.</li>
<li>Timeline view: shows a histogram of messages over time. The number of warnings and errors are highlighted in the display so that you can easily see where problems have occurred.</li>
<li>Query logs using SQL: log files are directly used as the backing for SQLite virtual tables.</li>
<li>Automatic data extraction: built-in log message parser can automatically discover and extract interesting data from plainly formatted log messages.</li>
<li>Live operation: Search as you type. New log lines are automatically loaded and searched as they are added; filters apply to lines as they are loaded; and, SQL queries are checked for correctness as you type.</li>
<li>Syntax highlighting with configurable colourizing</li>
<li>Tab completion</li>
<li>Sessions</li>
<li>Supports Linux and Mac</li>
</ul>
</div>
</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><u>Install lnav on Ubuntu 15.04/15.10 and Linux Mint 17.x</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><br /></b></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">To install lnav on Ubuntu 15.04/15.10 and Linux Mint 17.x and other Ubuntu based distribution, type following command in your terminal:</span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">$ sudo apt-get install lnav -y</pre>
</div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><div>
<b><u>Install lnav on CentOS 7</u></b></div>
<div>
<b><u><br /></u></b></div>
<div>
First, enable epel repository:</div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">$ sudo yum install epel-release -y</pre>
</div>
</span></span></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">Now, install lnav using yum command:</span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">$ sudo yum install lnav -y</pre>
</div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><div>
<b><u>Using lnav command</u></b></div>
<div>
If you want to view logs using lnav you can do using the following command by default it shows syslogs.</div>
</span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">$ lnav</pre>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQu5LEdC3IG2TW_rGdocj0NAYHpqQooYYJW8h-spbGA0Qdan60IFvgOfuni0OS2aZl_s0e-R4ezIT_7_iHTWwcwXxZg2dpQwvvZ3g6SH9jnjcg5fOrPQ1tAT5l2L21W7Khdy2_PUxBJKi3/s1600/Use-lnav-log-viewer.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQu5LEdC3IG2TW_rGdocj0NAYHpqQooYYJW8h-spbGA0Qdan60IFvgOfuni0OS2aZl_s0e-R4ezIT_7_iHTWwcwXxZg2dpQwvvZ3g6SH9jnjcg5fOrPQ1tAT5l2L21W7Khdy2_PUxBJKi3/s1600/Use-lnav-log-viewer.png" /></a></div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;">If you want to view specific logs provide the path. Example:</span></span></div>
<div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; color: white; font-family: monospace, serif; font-size: 14px; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;">$ lnav /var/log/clamav/</pre>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-sYeWh28aR19JJBG39T-MyV2YwlsN2DZ-uudRJBvKag3mgJ2EB5mYau4ImxK6wBhgCmmi6QI17VXiZSXgtQKIu0uWfPdoDF0gKWyrquxionTfTjDYiNsd__lQLiaEdJbSKiWPn55qlMBB/s1600/lnav-view-specific-logs.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-sYeWh28aR19JJBG39T-MyV2YwlsN2DZ-uudRJBvKag3mgJ2EB5mYau4ImxK6wBhgCmmi6QI17VXiZSXgtQKIu0uWfPdoDF0gKWyrquxionTfTjDYiNsd__lQLiaEdJbSKiWPn55qlMBB/s1600/lnav-view-specific-logs.png" /></a></div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span></div>
<div>
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><b><u>How to navigate in lnav</u></b></span></span></div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXmLlEjaj4f6ozCZaIHNnR8QHs2nehhcxyIlZatSI0lu9-R1xof12i1JacCfRYMFKL4LNFAKL5vvkrlvNHazZP_9Sq_9CDZtJZCbKsMDVUyJ9d3G1udhjiDjKClI3bvU8PpZNGi_MDABgx/s1600/how-to-use-lnav.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXmLlEjaj4f6ozCZaIHNnR8QHs2nehhcxyIlZatSI0lu9-R1xof12i1JacCfRYMFKL4LNFAKL5vvkrlvNHazZP_9Sq_9CDZtJZCbKsMDVUyJ9d3G1udhjiDjKClI3bvU8PpZNGi_MDABgx/s1600/how-to-use-lnav.png" /></a></div>
<div>
<span style="background-color: white; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;"><br /></span></div>
<div>
For more information visit <a href="http://lnav.org/">official lnav site.</a></div>
<div>
<br /></div>
</div>

How to Install and use Log File Navigator – lnav in Ubuntu and CentOS linux

Install and use Log File Navigator – lnav in Ubuntu and CentOS The Log File Navigator, lnav, is an enhanced log file viewer that takes ...

How to install Centos Web Panel(CWP)

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: large;"><u><b>Install Centos Web Panel(CWP)</b></u></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><a href="http://www.hackthesec.co.in/search/label/Centos">CentOS</a> Web Panel – a Free Web Hosting control panel designed for quick and easy management of (Dedicated & VPS) servers minus the chore and effort to use ssh console for every time you want to do something, offers a huge number of options and features for server management in its control panel package.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8p7vt6DmQ-Xjn6bu3wt_SITsKjoA8fjzTQEqIbJ-6LO1963pmWpQBZAMYmqPgu0IRiLaZlR-dSscr76avLic-Q81y9wm_FXWRqWAXGT5RdHUoV1Bwzvplwgoftde1D1kiHa1Q0voIGTol/s1600/cwp_logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj8p7vt6DmQ-Xjn6bu3wt_SITsKjoA8fjzTQEqIbJ-6LO1963pmWpQBZAMYmqPgu0IRiLaZlR-dSscr76avLic-Q81y9wm_FXWRqWAXGT5RdHUoV1Bwzvplwgoftde1D1kiHa1Q0voIGTol/s1600/cwp_logo.png" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><u>System Requirements</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Make sure that you complete the following tasks before you start the installation process:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">1. Setup Hostname</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">This hostname cannot be the same as any domain that is on your server (for example, if example.com is a domain on your server, use hostname.example.com as your fully qualified hostname).</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">You can use the following command for hostname setup eg. srv1.hackthesec.co.in</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">hostname srv1.example.com</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">2. Setup Server IP addresses</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Define additional IP address, subnet address, and default gateway IP address for your server — your service provider can provide you with this information.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">3. Software Requirements</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">You must have a clean/fresh installation of supported operating systems:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">CentOS 6, RedHat 6 or CloudLinux 6, MINIMAL installation and English version only!</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">CentOS 7 is NOT supported.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">4. Hardware Requirements</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">32 bit operating systems require a minimum of 512 MB RAM</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">64 bit operating systems require a minimum of 1024 MB RAM (recommended)</span></span><br />
<br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Recommended System: 4 GB+ RAM so you would have the full functionality such as Anti-virus scan of emails.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><u>FEATURES</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Here are our features and services at CentOS Web Panel:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">***currently including Admin and Client panel***</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">CWP automatically installs full <a href="http://www.hackthesec.co.in/search/label/LAMP">LAMP </a>on your desired server featuring:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">(apache,<a href="http://www.hackthesec.co.in/search/label/PHP">php</a>, phpmyadmin, webmail, mailserver…)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">What are the Installation and Configuration characteristics during Installation of CWP?</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- <a href="http://www.hackthesec.co.in/search/label/Apache">Apache </a>Web Server (Mod Security + OWASP rules optional)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- PHP 5.4 (suPHP, SuExec + PHP version switcher)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>/MariaDB + phpMyAdmin</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Postfix + Dovecot + roundcube webmail (Antivirus, Spamassassin optional)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- CSF Firewall</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- File System Lock (no more website hacking, all your files are locked from changes)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Backups (optional)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- AutoFixer for server configuration</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">3rd Party Aplications</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- CloudLinux + CageFS + PHP Selector</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Softaculous – Script Installer (Free and Premium)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">CentOS Web Panel (CWP)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Setups Server for Web Hosting (websites like WordPress…)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- API for easier account management, and whmcs billing api</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- NAT-ed version, support for NAT-ed IPs</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Free Hosting Module, account activation provisioning for sites that have a free hosting</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Web Server</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Varnish Cache server (improve your server performances up to three times)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Nginx Reverse Proxy (get you static files delivered in the fastest way)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Compiles Apache from source (improves performance up to 15%)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Apache reCompiler + Additional modules installation with one click</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Apache server status, configuration</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Apache Redirects Manager</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Edit apache vhosts, vhosts templates, include configuration</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Rebuild all apache Virtual hosts with one click</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- suPHP & suExec (improved security)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Mod Security + OWASP rules (one click install, easy management)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Tomcat 8 server management & install in one click</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- DoS protection from the Slow-Loris attacks</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Apache with spamhaus RBL protection (Protecting http PUT,POST,CONNECT)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Perl cgi script support</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">PHP</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Compiles PHP from source (improves up to 20% on performances)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- PHP Switcher (switch between PHP versions like: 5.2, 5.3, 5.4, 5.5, 5.6, 7.x)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- PHP Selector select PHP version per user or per folder (PHP 4.4, 5.2, 5.3, 5.4, 5.5, 5.6, 7.x)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Simple php editor</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Simple php.ini generator in the users panel</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- PHP addons with one click</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- PHP.ini editor & PHP info & List modules</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- php.ini per user account (you can add changes in /home/USER/php.ini)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- FFMPEG, For Video streaming websites)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- CloudLinux + PHP Selector</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- ioncube, php-imap …</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">User Management</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Add, List, Edit and Remove Users</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- User Monitoring (list users open files, listening sockets…)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Shell access management</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- User Limit Managment (Quota and Inodes)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Limit Processes: The maximum available number of processes per account.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Limit Open Files: The maximum available number of open files per account.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- User FTP & File Manager</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- CloudLinux + CageFS</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Dedicated IP per account</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">DNS</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- FreeDNS (Free DNS Server, no need for additional IPs)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Add, Edit, List and Remove DNS zones</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Edit nameserver IPs</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- DNS zone template editor</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- New Easy DNS Zone Manager (with ajax)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- New DNS Zone list with Additional resolving information using google (also checking rDNS, nameservers….)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Email</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- postfix & dovecot</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- MailBoxes, Alias</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Roundcube webmail</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Postfix Mail queue manager</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- rDNS Checker Module (check you rDNS records)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- AntiSPAM (Spamhaus cronjob)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- SpamAssassin, RBL checking, AmaViS, ClamAV, OpenDKIM</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- SPF & DKIM Integration</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Many More....</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">System</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Hardware Information (CPU core and clock info)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Memory Information (Memory usage info)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Disk Info (Detailed Disk status)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Software Info (kernel version, uptime…)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Services Status (Quick services restart eg. Apache, FTP,Mail…)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Many More...</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Monitoring</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Live Monitoring (Monitor services eg. top, apache stats, mysql…)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Use Java SSH Terminal/Console within panel</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Services Configuration (eg. Apache, PHP, MySQL…)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Run shell commands in screen/background</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Security</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- CSF Firewall (Best Linux Firewall)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- SSL generator</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- SSL Certificate Manager (quick and easy installation of SSL Certs)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Letsencrypt, Free SSL certificates for all your domains</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- CloudLinux + CageFS</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- CSF/LFD BruteForce protection</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- IP access control</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Mod Security + OWASP rules (one click install, easy management)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- DoS protection from the Slow-Loris attacks (for Apache)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- File System Lock (no more website hacking, all your files are locked from changes)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- PHP now shows the script name and path in top or process lists</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Apache is limiting number of php processes per user</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Automated Backups</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Hide system and other user processes</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- SFTP Security</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">SQL</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Additional options</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- TeamSpeak 3 Manager (Voice servers)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Shoutcast Manager (Shoutcast streaming servers)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Auto-update</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Backup manager</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- File Manager</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Scripts folder “/scripts” over 15+ scripts</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Virtual FTP users per domain</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- cPanel Account Migration (restores files, databases and database users)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Torrent SeedBox (one click install with Deluge WebGU)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- SSH key generator</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">and many many other options…</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">to do List </span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">We plan to improve & add following soon</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Server monitoring scripts (Load, Memory, Mail Queue, Security)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Live notifications (get notification in CWP about issues on the server)</span></span><br />
<br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">…and many others </span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><b><u>HOW TO INSTALL CWP</u></b></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Follow steps below to setup CentOS Web Panel on your server:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Step 1 – Login to your server as root or as user with sudo privilege:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Step 2 – Go to /usr/local/src directory and download CWP installer package there:</span></span><br />
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">cd /usr/local/src
wget http://centos-webpanel.com/cwp-latest</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHCumkp8N-EKNmJ431ei3V3clDBLB5dOiXGEkVukFp8AuA1DkTgPzgkXZu0eo02G_UWvJW2IqvQxdpaWEB_WC9xIoE6NbIIA8-Zk4Vxi1o0pZrdbG3Y3W9hzsvhmTQ_7cyN-eodwOzKZax/s1600/cwp_download.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHCumkp8N-EKNmJ431ei3V3clDBLB5dOiXGEkVukFp8AuA1DkTgPzgkXZu0eo02G_UWvJW2IqvQxdpaWEB_WC9xIoE6NbIIA8-Zk4Vxi1o0pZrdbG3Y3W9hzsvhmTQ_7cyN-eodwOzKZax/s1600/cwp_download.png" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Step 3 – Once downloaded, issue one simple command below to start the installer:</span></span><br />
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">sh cwp-latest</pre>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">The whole process is fully automatic.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSopw4SkzWe3Riuuzsz4sTRkinxzg3T2tQJHOss3rsWUG3oT5LWdHnoBx1yCMmgmt9eruHb3iFQ7nbCgv_j8iVsv1vTy0KbZfEg82frn6Rbs6sekewbh_4CQgOxRPaJRDr5LaIYF9p_-Ct/s1600/cwp-install-process.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgSopw4SkzWe3Riuuzsz4sTRkinxzg3T2tQJHOss3rsWUG3oT5LWdHnoBx1yCMmgmt9eruHb3iFQ7nbCgv_j8iVsv1vTy0KbZfEg82frn6Rbs6sekewbh_4CQgOxRPaJRDr5LaIYF9p_-Ct/s1600/cwp-install-process.jpg" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">The CWP installation progress will take some times because several software will be compiled from source (especially PHP) for improved performance, security and flexibility. In my case it is almost like installing WHM/cPanel.Once the process is done, you’ll see something like this:</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkppCekvY8ZZ1HJ79of1ohnaCKjLCcLOlyg0DvBBYrku-jq5nDkiw2HerQBKt4yWKg3FsdeQfdVztT3_DhfQLcF1vgZlGQS1zTYyrgiFSWtkZl9RkUA_kTbH5IkuWpuJcCDuhTCcZiC-nA/s1600/cwp-installed.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkppCekvY8ZZ1HJ79of1ohnaCKjLCcLOlyg0DvBBYrku-jq5nDkiw2HerQBKt4yWKg3FsdeQfdVztT3_DhfQLcF1vgZlGQS1zTYyrgiFSWtkZl9RkUA_kTbH5IkuWpuJcCDuhTCcZiC-nA/s1600/cwp-installed.jpg" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Step 4 – Now hit Enter on your keyboard and your server should reboot automatically. Next time you try to login to your server via SSH, the display will be different. You will now see CWP welcome message.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjasChe2omZRknNfe_J0yitTgF1TyuoL4Qu90yMEXGfUh1Sj76zAOeh9TKNBkibQymExrUNUXraoajGTKC6lMSqHnH_6UTiBzVrbXm3mAGZYBTfCisNy2p7vY6XgLZPHMSQHeYx69jOTiB5/s1600/cwp-ssh.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjasChe2omZRknNfe_J0yitTgF1TyuoL4Qu90yMEXGfUh1Sj76zAOeh9TKNBkibQymExrUNUXraoajGTKC6lMSqHnH_6UTiBzVrbXm3mAGZYBTfCisNy2p7vY6XgLZPHMSQHeYx69jOTiB5/s1600/cwp-ssh.jpg" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Step 5 – Open up your favorite web browser (Firefox, Chrome, etc) and open your newly installed CWP admin GUI at one of these URLs:</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Log in to your CWP server using the link provided by the installer on your server</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">CentOS WebPanel Admin GUI at http://SERVER-IP:2030/</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Username: root</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Password: your root password</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Setup nameservers</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Setup shared ip (must be your public IP address)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Setup at least one hosting package (or edit default package)</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">- Setup root email</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">& now you are ready to host domains…</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">For additional configuration instruction, please check our wiki/documentation site.</span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><a href="http://wiki.centos-webpanel.com/">http://wiki.centos-webpanel.com/</a></span></span><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyICwqS6FGNGMP9zqscuFGwh9yMFlQtUXWqs89yFShw_zEKV0tyvvqxnUVKFdWgLrl0YwgTu3Zcy8e7YZ1ZJTcUL9jQewDkQrfnq66pkgsytgTku7FCS7CBnQaJMgGMjydhTcJSbGw1ri-/s1600/cwp-login-page.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyICwqS6FGNGMP9zqscuFGwh9yMFlQtUXWqs89yFShw_zEKV0tyvvqxnUVKFdWgLrl0YwgTu3Zcy8e7YZ1ZJTcUL9jQewDkQrfnq66pkgsytgTku7FCS7CBnQaJMgGMjydhTcJSbGw1ri-/s1600/cwp-login-page.jpg" /></a></div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a><br />
<a class="g-profile" href="https://plus.google.com/113492055880844042777" target="_blank">+Linux Tutorial</a><br />
@<a href="https://www.twitter.com/Hackthesecurity">hackthesec</a><br />
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>

How to install Centos Web Panel(CWP)

Install Centos Web Panel(CWP) CentOS Web Panel – a Free Web Hosting control panel designed for quick and easy management of (Dedicated &...

How To Install Perl Modules Manually and Using CPAN command

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="headline" itemprop="name" style="background-color: white; font-family: Georgia, "Times New Roman", Times, serif; line-height: 39px; margin: 0px; padding: 0px; word-wrap: break-word;">
<span style="color: #0b5394; font-size: large;"><u>Install Perl Modules Manually and Using CPAN command</u></span></h1>
<div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;">The Comprehensive Perl Archive Network (CPAN) is a repository of over 250,000 software modules and accompanying documentation for 39,000 distributions, written in the Perl programming language by over 12,000 contributors.</span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;">The modules can be downloaded from metacpan.org as well as mirrored sites worldwide.CPAN can denote either the archive network itself, or the Perl program that acts as an interface to the network and as an automated software installer (somewhat like a package manager). Most software on CPAN is free and open source software.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2jv0ThM0mE4EVejeUNRcPyHQO20PrvzNoFYBO3BRdkuCmALPm_R5oYkQVh9JWu0QIUO8YkAVdNSmGkCvZH3fqFh2QjR1JeNmwsqB4deZAj-JFcybgBzhQhwGW_KC9bzXo3r7YKN0loF_f/s1600/perl-cpan_hackthesec.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2jv0ThM0mE4EVejeUNRcPyHQO20PrvzNoFYBO3BRdkuCmALPm_R5oYkQVh9JWu0QIUO8YkAVdNSmGkCvZH3fqFh2QjR1JeNmwsqB4deZAj-JFcybgBzhQhwGW_KC9bzXo3r7YKN0loF_f/s1600/perl-cpan_hackthesec.jpg" /></a></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;">Installing <b>Perl </b>modules using <b>CPAN </b>is a better solution, as it resolves all the dependencies automatically. In this article, let us review how to install Perl modules on Linux using both manual and CPAN method.</span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;">When a Perl module is not installed, application will display the following error message. In this example, XML::Parser Perl module is missing.</span></span></div>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;"><strong style="margin: 0px; padding: 0px; word-wrap: break-word;">Can't locate</strong> XML/parser.pm in @INC (@INC contains:
/usr/lib/perl5/5.10.0/i386-linux-thread-multi
/usr/lib/perl5/5.10.0
/usr/local/lib/perl5/site_perl/5.10.0/i386-linux-thread-multi
/usr/local/lib/perl5/site_perl/5.10.0
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.10.0 /usr/lib/perl5/vendor_perl
/usr/lib/perl5/site_perl/5.10.0 .)</pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><div>
Install Perl Modules Manually</div>
<div>
<br /></div>
<div>
<b><u>Download Perl module</u></b></div>
<div>
<br /></div>
<div>
Go to CPAN <a href="http://search.cpan.org/">Search website</a> and search for the module that you wish to download. In this example, let us search, download and install XML::Parser Perl module. I have downloaded the XML-Parser-2.36.tar.gz to /home/download</div>
<div>
<br /></div>
</span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;"># cd /home/download
# gzip -d XML-Parser-2.36.tar.gz
# tar xvf XML-Parser-2.36.tar
# cd XML-Parser-2.36</pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;">Build the perl module</span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;"># <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">perl Makefile.PL
</strong>Checking if your kit is complete...
Looks good
Writing Makefile for XML::Parser::Expat
Writing Makefile for XML::Parser
# <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">make</strong>
# <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">make test</strong></pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><b><u>Install the perl module</u></b></span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><div>
This is very simple for one module with no dependencies. Typically, Perl modules will be dependent on several other modules. Chasing all these dependencies one-by-one can be very painful and annoying task. I recommend the CPAN method of installation as shown below. Use the manual method only if the server is not connected to the Internet.</div>
<div>
<br /></div>
<div>
Install Perl Modules using CPAN automatically</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
Verify whether CPAN is already installed</div>
<div>
<br /></div>
<div>
To install Perl modules using CPAN, make sure the cpan command is working. You should have the CPAN perl module installed before you can install any other Perl modules using CPAN. In this example, CPAN module is not installed.</div>
<div>
<br /></div>
</span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;"># <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">cpan</strong>
-bash: cpan: command not found

# <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">perl -MCPAN -e shell</strong>
Can't locate CPAN.pm in @INC (@INC contains:
/usr/lib/perl5/5.10.0/i386-linux-thread-multi
/usr/lib/perl5/5.10.0
/usr/local/lib/perl5/site_perl/5.10.0/i386-linux-thread-multi
/usr/local/lib/perl5/site_perl/5.10.0
/usr/lib/perl5/vendor_perl/5.10.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.10.0
/usr/lib/perl5/vendor_perl /usr/lib/perl5/site_perl/5.10.0 .).
BEGIN failed--compilation aborted.</pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><div>
<b>Install the CPAN module using yum</b></div>
<div>
<br /></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;"># <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">yum install perl-CPAN</strong></pre>
</div>
<div>
Output of yum install perl-CPAN command:</div>
</span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;">Loaded plugins: refresh-packagekit
updates-newkey                       | 2.3 kB     00:00
primary.sqlite.bz2                   | 2.4 MB     00:00
Setting up Install Process
Parsing package install arguments

Resolving Dependencies
Transaction Summary
=============================================================================
Install      5 Package(s)
Update       0 Package(s)
Remove       0 Package(s)

Total download size: 1.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/5): perl-ExtUtils-ParseXS-2.18-31.fc9.i386.rpm     |  30 kB     00:00
(2/5): perl-Test-Harness-2.64-31.fc9.i386.rpm         |  70 kB     00:00
(3/5): perl-CPAN-1.9205-31.fc9.i386.rpm               | 217 kB     00:00
(4/5): perl-ExtUtils-MakeMaker-6.36-31.fc9.i386.rpm   | 284 kB     00:00
(5/5): perl-devel-5.10.0-31.fc9.i386.rpm              | 408 kB     00:00
<strong style="margin: 0px; padding: 0px; word-wrap: break-word;">
Installing     : perl-ExtUtils-ParseXS                             [1/5]
Installing     : perl-devel                                        [2/5]
Installing     : perl-Test-Harness                                 [3/5]
Installing     : perl-ExtUtils-MakeMaker                           [4/5]
Installing     : perl-CPAN                                         [5/5]

</strong>
<strong style="margin: 0px; padding: 0px; word-wrap: break-word;">Installed: perl-CPAN.i386 0:1.9205-31.fc9
</strong>Dependency Installed:
  perl-ExtUtils-MakeMaker.i386 0:6.36-31.fc9
  perl-ExtUtils-ParseXS.i386 1:2.18-31.fc9
  perl-Test-Harness.i386 0:2.64-31.fc9
  perl-devel.i386 4:5.10.0-31.fc9
<strong style="margin: 0px; padding: 0px; word-wrap: break-word;">Complete!</strong></pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><div>
<b><u>Configure cpan the first time</u></b></div>
<div>
<br /></div>
<div>
The first time when you execute cpan, you should set some configuration parameters as shown below. I have shown only the important configuration parameters below. Accept all the default values by pressing enter.</div>
<div>
<br /></div>
<div>
Note: Make sure to execute “<b>o conf commit</b>” in the cpan prompt after the configuration to save the settings.</div>
</span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;"># <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">cpan</strong>

Sorry, we have to rerun the configuration dialog for CPAN.pm due
to some missing parameters...

CPAN build and cache directory? <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">[/root/.cpan]
</strong>Download target directory? [/root/.cpan/sources]
Directory where the build process takes place? [/root/.cpan/build]

Always commit changes to config variables to disk? <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">[no]</strong>
Cache size for build directory (in MB)? [100]
Let the index expire after how many days? [1]

Perform cache scanning (atstart or never)? <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">[atstart]</strong>
Cache metadata (yes/no)? [yes]
Policy on building prerequisites (follow, ask or ignore)? [ask]

Parameters for the 'perl Makefile.PL' command? <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">[]</strong>
Parameters for the 'perl Build.PL' command? []

Your ftp_proxy? <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">[]</strong>
Your http_proxy? []
Your no_proxy? []
Is it OK to try to connect to the Internet? [yes]

First, pick a nearby continent and country by typing in the number(s)
(1) Africa
(2) Asia
(3) Central America
(4) Europe
(5) North America
(6) Oceania
(7) South America
<strong style="margin: 0px; padding: 0px; word-wrap: break-word;">Select your continent</strong> (or several nearby continents) [] 5

(1) Bahamas
(2) Canada
(3) Mexico
(4) United States
<strong style="margin: 0px; padding: 0px; word-wrap: break-word;">Select your country</strong> (or several nearby countries) [] 4

(2) ftp://carroll.cac.psu.edu/pub/CPAN/
(3) ftp://cpan-du.viaverio.com/pub/CPAN/
(4) ftp://cpan-sj.viaverio.com/pub/CPAN/
(5) ftp://cpan.calvin.edu/pub/CPAN
(6) ftp://cpan.cs.utah.edu/pub/CPAN/
e.g. '1 4 5' or '7 1-4 8' <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">[] 2-16</strong>

cpan[1]> <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">o conf commit</strong>
commit: wrote '/usr/lib/perl5/5.10.0/CPAN/Config.pm'

cpan[2]> <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">quit</strong>
No history written (no histfile specified).
Lockfile removed.</pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><div>
<b><u>Install Perl Modules using CPAN</u></b></div>
<div>
<br /></div>
<div>
You can use one of the following method to install a Perl module using cpan.</div>
</span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;"># <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">/usr/bin/perl -MCPAN -e 'install Email::Reply'

</strong>(or)

# <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">cpan</strong>
cpan shell -- CPAN exploration and modules installation (v1.9205)
ReadLine support available (maybe install Bundle::CPAN or Bundle::CPANxxl?)

cpan[1]> <strong style="margin: 0px; padding: 0px; word-wrap: break-word;">install "Email::Reply";</strong></pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;">Output of above perl install command:</span></span></div>
<div>
<pre style="background-color: #eeeeee; border: 1px solid rgb(221, 221, 221); clear: both; color: #111111; font-family: Consolas, Monaco, Menlo, Courier, Verdana, sans-serif; font-size: 13px; margin-bottom: 26px; overflow: auto; padding: 13px; tab-size: 4; word-wrap: normal;">CPAN: Storable loaded ok (v2.18)
Going to read /root/.cpan/Metadata
Database was generated on Mon, 15 Sep 2008 11:02:52 GMT

Running install for module 'Email::Reply'
Running make for R/RJ/RJBS/Email-Reply-1.202.tar.gz
CPAN: LWP::UserAgent loaded ok (v2.036)
CPAN: Time::HiRes loaded ok (v1.9711)
Fetching with LWP:
ftp://carroll.cac.psu.edu/pub/CPAN/authors/id/R/RJ/RJBS/Email-Reply-1.202.tar.gz

CPAN: checksum security checks disabled because Digest::SHA not installed.
Please consider installing the Digest::SHA module.

CPAN: Compress::Zlib loaded ok (v2.008)
Email-Reply-1.202/
Email-Reply-1.202/Changes
CPAN: File::Temp loaded ok (v0.18)
Warning: prerequisite Email::Abstract 2.01 not found.
Warning: prerequisite Email::MIME::Creator 1.41 not found.
Writing Makefile for Email::Reply
---- Unsatisfied dependencies detected during ----
----       RJBS/Email-Reply-1.202.tar.gz      ----
<strong style="margin: 0px; padding: 0px; word-wrap: break-word;">Email::Abstract [requires]
Email::MIME::Creator [requires]
</strong>Shall I follow them and prepend them to the queue

of modules we are processing right now? [yes]
<span style="color: red; margin: 0px; padding: 0px; word-wrap: break-word;">[Note: CPAN automatically detects that Email::Abstract
       and Email::MIME::Creator is required]</span>

Fetching with LWP:
ftp://server/pub/CPAN/authors/id/R/RJ/RJBS/Email-Abstract-2.134.tar.gz
make -- OK
make install  -- OK

Fetching with LWP:
ftp://server/pub/CPAN/authors/id/R/RJ/RJBS/Email-MIME-Creator-1.454.tar.gz
make -- OK
make install  -- OK

Warning: prerequisite Email::Simple::Creator 1.4 not found.
Writing Makefile for Email::MIME::Creator
<strong style="margin: 0px; padding: 0px; word-wrap: break-word;">Email::Simple::Creator [requires]
</strong>Shall I follow them and prepend them to the queue
of modules we are processing right now? [yes]
<span style="color: red; margin: 0px; padding: 0px; word-wrap: break-word;">[Note: CPAN automatically detects that Simple::Creator is required]</span>

Fetching with LWP:
ftp://carroll.cac.psu.edu/pub/CPAN/authors/id/R/RJ/RJBS/Simple-Creator.tar.gz
make -- OK
make install  -- OK

Fetching with LWP:
CPAN.pm: Going to build R/RJ/RJBS/Email-Reply-1.202.tar.gz

make -- OK
make install  -- OK</pre>
</div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;">In the example above, Email::Reply is dependent on the several other modules. CPAN automatically resolves the dependencies and installs Email::Reply and all the dependent Perl modules.</span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><br /></span></span></div>
<div>
<span style="font-family: Open Sans;"><span style="font-size: 14px;"><a href="http://www.hackthesec.co.in/">HackTh3Sec</a></span></span></div>
<div>
<br /></div>
</div>

How To Install Perl Modules Manually and Using CPAN command

Install Perl Modules Manually and Using CPAN command The Comprehensive Perl Archive Network (CPAN) is a repository of over 250,000 soft...

Upgrading to PostgreSQL 9.5 in Fedora 24

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

Upgrading to PostgreSQL 9.5 in Fedora 24

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

Executing MySQL Queries Directly From the Command Line

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; color: #1e73be; font-family: Cabin; line-height: 50px; margin: 0px 0px 7px; word-wrap: break-word;">
<span style="font-size: large;"><u>Executing MySQL Queries Directly From the Command Line</u></span></h1>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">MySQL is a central component of the LAMP open-source web application software stack (and other "AMP" stacks). <a href="http://www.hackthesec.co.in/search/label/LAMP">LAMP</a> is an acronym for "<a href="http://www.hackthesec.co.in/search/label/Linux%20Tutorial">Linux</a>, <a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a>, <a href="http://www.hackthesec.co.in/search/label/Mysql_Database">MySQL</a>, </span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;">Perl/PHP/Python". Applications that use the MySQL database include: TYPO3, MODx, Joomla, WordPress, phpBB, MyBB, and Drupal.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqb_IjkqiXKg6rDmYejq7XSHARNEO7FQeNRUS_wOIn21jrjNbbAU7E6G9eRLRdYqi_Rde4_MExFxTI7vEQLKUepAv77VJY1ZcxLbpmQ-UaCqNfiVGecOeUXAnJxJOQqO-mHBETDm6S0oRb/s1600/mysql-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhqb_IjkqiXKg6rDmYejq7XSHARNEO7FQeNRUS_wOIn21jrjNbbAU7E6G9eRLRdYqi_Rde4_MExFxTI7vEQLKUepAv77VJY1ZcxLbpmQ-UaCqNfiVGecOeUXAnJxJOQqO-mHBETDm6S0oRb/s1600/mysql-hackthesec.png" /></a></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br />MySQL is also used in many high-profile, large-scale websites, including Google(though not for searches), Facebook, Twitter,Flickr, and YouTube.</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<b><u>Viewing list of Databases in your System</u></b></div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "SHOW DATABASES;"</span></span></pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<b><u>To create Databases and start working with them</u></b></div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "CREATE DATABASE hackthesec;"</span></span></pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
Without output from MySQL, nothing will be returned after running a command like the command above.</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<br /></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<b><u>Create tables and view tables</u></b></div>
<div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "USE hackthesec; CREATE TABLE IF NOT EXISTS staffs ( ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR( 200 ) NOT NULL )"</span></span></pre>
</div>
</div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "USE hackthesec; SHOW TABLES;"</span></span></pre>
</div>
<div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;"><b><u>To Insert into the table</u></b></span></div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;"><span style="color: white;"><span style="font-size: 15px;">$ mysql -u root -p -e "USE hackthesec; INSERT INTO staffs ( name ) VALUES ( 'John' );"</span></span></pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;"><b><u>To view data in the table</u></b></span></div>
<div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;"><span style="color: white; font-family: Courier 10 Pitch, Courier, monospace;"><span style="font-size: 15px;">$ mysql -u root -p -e "USE hackthesec; SELECT * FROM staff;</span></span></pre>
</div>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;">Now we want to output the result to a file, the tee command comes in handy or output redirection by running</span></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ mysql -u root -p -e "USE hackthesec; SELECT * FROM staff;" | tee output.txt
</pre>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;">The output will be saved to output.txt of the working directory. Which can be viewed using cat command</span></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;"><br /></span></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px;">$ cat output.txt</span></div>
</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<br /></div>
<div class="separator" style="clear: both; color: #333333; font-family: verdana, geneva, sans-serif; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7t3elDc8es80uXNwtCgf2nBBTd0WazhP5jnJimKQo5hydVpKIR5WZ8FdVZD8tHYvnfaCwOXaPn1W8-OwFmXLGEuARtAej98plKSBAFJfGwz223-SsqjZsUvEU61vsQf9lx-HDCvnwCbgx/s1600/mysql_hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi7t3elDc8es80uXNwtCgf2nBBTd0WazhP5jnJimKQo5hydVpKIR5WZ8FdVZD8tHYvnfaCwOXaPn1W8-OwFmXLGEuARtAej98plKSBAFJfGwz223-SsqjZsUvEU61vsQf9lx-HDCvnwCbgx/s1600/mysql_hackthesec.png" /></a></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<br /></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>
</div>

Executing MySQL Queries Directly From the Command Line

Executing MySQL Queries Directly From the Command Line MySQL is a central component of the LAMP open-source web application software sta...