Hack The Sec-Leading Resource Of Linux Tutorial

How to Install Sitemagic CMS with Nginx on CentOS 7

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; font-family: Lato, sans-serif; line-height: 1.1; margin: 20px 0px 10px;">
<span style="color: #990000; font-size: large;"><u>Install Sitemagic CMS with Nginx on CentOS 7</u></span></h1>
<div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Sitemagic CMS powers thousands of the most beautiful websites on the internet.</span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">That's because creative professionals choose Sitemagic CMS as their platform.</span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">But don't let the beauty fool you.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZNP5h7dgRIO2nr3tLtdeWNGwRSETIQlf64JW4tzOxoqQHk6YtJwnyRBLelLmDd9_EbqsbfD4fS6vDETuofZErC1johH-4YbzQrh9qhPOvHkwTyTzDe8N-YuMjCfTe_bgiskj7YWYaskIq/s1600/Logo.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjZNP5h7dgRIO2nr3tLtdeWNGwRSETIQlf64JW4tzOxoqQHk6YtJwnyRBLelLmDd9_EbqsbfD4fS6vDETuofZErC1johH-4YbzQrh9qhPOvHkwTyTzDe8N-YuMjCfTe_bgiskj7YWYaskIq/s1600/Logo.png" /></a></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Underneath Sitemagic CMS runs a highly capable framework that allow developers to extend and customize everything.</span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Despite all that power, Sitemagic CMS is a super userfriendly Content Management System.</span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Anyone who knows how to use a browser, can create stunning websites with Sitemagic CMS.</span></span></div>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Installation Requirements:</u></b></span></span></div>
<div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif;">
<ul style="font-size: 15px; line-height: 26px; text-align: left;">
<li><a href="http://www.hackthesec.co.in/search/label/PHP">PHP</a> 5.2 or higher with the following PHP extensions enabled: GD, mbstring and SimpleXML;</li>
<li><a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a> or <a href="http://www.hackthesec.co.in/search/label/NGINX">Nginx</a> web server installed on you system</li>
<li><a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> or <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB</a> – optional.</li>
</ul>
<div>
<span style="font-size: 15px; line-height: 26px;">So, let's start with the installation. Make sure that all OS packages are up to date by running the following commands:</span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">yum clean all
yum update</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Stop and remove Apache if it is installed and running on your server:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">systemctl stop httpd
systemctl disable httpd
yum remove httpd</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Install required packages:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">yum install nginx mariadb mariadb-server php php-fpm php-cli php-curl php-gd php-mbstring php-mysql php-xml</span></span><span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px; white-space: normal;">
</span></span></pre>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Edit the<b> /etc/php-fpm.d/www.conf</b> configuration file and change:</span></span></div>
</div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">user = apache
group = apache</pre>
</div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
To:</div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">user = nginx
group = nginx</pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Run the following command:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">chown nginx: -R /var/lib/php/session</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Start the PHP-FPM, Nginx and MariaDB services and enable them to start on boot:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: orange;">systemctl start php-fpm
</span><span style="color: white;">systemctl start nginx
systemctl start mariadb</span></span></span></pre>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">systemctl enable php-fpm
</span><span style="color: orange;">systemctl enable nginx
</span><span style="color: white;">systemctl enable mariadb</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Download the latest stable version of <b>Sitemagic</b> at http://sitemagic.org/Download.html to the '/opt' directory on the server. Then, extract it and move the Sitemagic files and directories to the '<b>/var/www/html/sitemagic</b>' directory. At the time of writing this tutorial, the latest stable version of Sitemagic is 4.1.2.</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">cd /opt/
unzip -d /var/www/html/ SitemagicCMS412.zip
mv /var/www/html/Sitemagic/ /var/www/html/sitemagic/</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a new Nginx configuration file for your website:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">vi /etc/nginx/conf.d/</span><span style="color: lime;">yourdomain.com.conf</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Add the following content:</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">server {
    server_name www.yourdomain.com yourdomain.com;
    listen 80;
    root /var/www/html/sitemagic;
    access_log /var/log/nginx/yourdomain.com-access.log;
    error_log /var/log/nginx/yourdomain.com-error.log;
    index index.php;
 
    location / {
        try_files  $uri $uri/ /index.php?$args;
    }

location ~* \.(jpg|jpeg|gif|css|png|js|ico|html)$ {
        access_log off;
        expires max;
    }

location ~ \.php$ {
        try_files $uri = 404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_pass 127.0.0.1:9000;
        fastcgi_index index.php;
        include /etc/nginx/fastcgi_params;
        fastcgi_param SCRIPT_FILENAME $document_root$fastcgi_script_name;
    }

location ~ /\.ht {
        deny all;
    }

}</pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Replace all of 'yourdomain.com' with your own domain name. Also, the web server user (nginx) needs to be able to write to 'data', 'files' and 'templates' directories and <b>config.xml.php</b> file. It can easily be accomplished by executing the following command:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: orange; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">chown -R nginx:nginx /var/www/html/sitemagic/</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Test the Nginx configuration:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">nginx -t</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">It the test is successful, restart the Nginx service:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: Courier New, Courier, monospace;"><span style="font-size: 15px; line-height: 15.6px;">systemctl restart nginx</span></span></pre>
</div>
<div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Sitemagic CMS stores data as XML files in the '/var/www/html/sitemagic/data' directory on the server by default, so there is no need to create and use a database.</span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Open http://yourdomain.com with your favorite web browser and log in using 'admin' as username and 'admin' as password. Then, go to the administrator menu and click 'Settings', change the administrator username and password and click 'Save'.</span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiDnx72ormGQT1fMaN-jTJqTyZGZxAwxn3AV3Ow1cmMplwhePpyW3DcE3F91CRtyVTC97rOCla1q4kNTWbtgqDjlRDnmwA27_mqMKbadifH9wRwSUXMsOvb1TxrjFGG5gHfLsdd4vyQLJE/s1600/sitemagic-back-end_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiiDnx72ormGQT1fMaN-jTJqTyZGZxAwxn3AV3Ow1cmMplwhePpyW3DcE3F91CRtyVTC97rOCla1q4kNTWbtgqDjlRDnmwA27_mqMKbadifH9wRwSUXMsOvb1TxrjFGG5gHfLsdd4vyQLJE/s1600/sitemagic-back-end_hackthesec.co.in.png" /></a></div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<br /></div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>
</div>

How to Install Sitemagic CMS with Nginx on CentOS 7

Install Sitemagic CMS with Nginx on CentOS 7 Sitemagic CMS powers thousands of the most beautiful websites on the internet. That'...

How to install Logaholic on CentOS

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; font-family: Lato, sans-serif; line-height: 1.1; margin: 20px 0px 10px;">
<span style="color: #990000; font-size: large;"><u>Install Logaholic on CentOS</u></span></h1>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Logaholic is a Web Analytics provider with solutions for individual websites, hosting providers and agencies. Self hosted or in the cloud, you own the data.</span></span></div>
<div>
<div style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<b><u><span style="color: #0b5394;">Logaholic is 6.0 and it requires:</span></u></b></div>
<div>
<ul style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: left;">
<li><a href="http://www.hackthesec.co.in/search/label/PHP">PHP</a> 5 or higher with cURL and Zip extensions enabled. The output_buffering setting should be disabled and allow_url_fopen and display_errors settings should be enabled in php.ini</li>
<li><a href="http://www.hackthesec.co.in/search/label/Apache">Apache</a> or <a href="http://www.hackthesec.co.in/search/label/NGINX">Nginx</a> Web Server</li>
<li><a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> 5.0 or higher</li>
</ul>
<div style="font-family: verdana, geneva, sans-serif;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Download the latest version of Logaholic available at http://www.logaholic.com/download/ to the server and extract it using the following commands:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">cd /opt/
wget -O logaholic.tar.gz http://www.logaholic.com/download.php?file=logaholic_she_600.tar.gz
tar -xvzf logaholic.tar.gz
</span><span style="color: lime;">mkdir -p /var/www/html/logaholic
</span><span style="color: white;">mv logaholic_she_600/logaholic /var/www/html</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Download GeoLite Legacy Database at http://www.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz , then extract and copy this file to the '<b>/var/www/html/logaholic/components/geoip/</b>' directory on your server:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">wget http://www.maxmind.com/download/geoip/database/GeoLiteCity.dat.gz
</span><span style="color: lime;">gunzip GeoLiteCity.dat.gz
</span><span style="color: white;">mv GeoLiteCity.dat /var/www/html/logaholic/components/geoip/</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Change the file permissions so your web server can write to the '<b>/var/www/html/logaholic</b>' directory and sub directories:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: orange; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">chown apache:apache -R /var/www/html/logaholic/</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Edit the Apache configuration file (by default ‘/etc/httpd/conf/httpd.conf’) and define the Apache log file in the following format:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">CustomLog /your_path/access_log "%h %l %u %t \"%r\" %s %b \"%{Referer}i\"
\"%{User-Agent}i\""</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">In general, this seems to be enough:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">CustomLog /your_path/access_log "</span><span style="color: orange;">combined</span><span style="color: white;">"</span></span></span></pre>
</div>
<div style="font-family: verdana, geneva, sans-serif;">
<span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;"><div>
Please note that each Apache virtual host should have it’s own log file.</div>
<div>
Locate the php configuration file using the following command:</div>
</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">#php -i | grep php.ini
Configuration File (php.ini) Path => /etc
</span><span style="color: orange;">Loaded Configuration File => /etc/php.ini</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Edit the '<b>php.ini</b>' file and add/modify the following lines:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">allow_url_fopen = On 
</span><span style="color: orange;">display_errors = On 
</span><span style="color: lime;">output_buffering = off</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a new virtual host directive in Apache. For example, edit your Apache configuration file ('<b>/etc/httpd/conf/httpd.conf</b>' by default) and un-comment the following line:</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">#NameVirtualHost *:80</pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then, add the following lines at the end:</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><VirtualHost *:80>
ServerAdmin admin@yourdomain.com
DocumentRoot /var/www/html/logaholic/
ServerName yourdomain.com
ServerAlias www.yourdomain.com
<Directory /var/www/html/logaholic/>
    Options FollowSymLinks
    AllowOverride All
</Directory>
    ErrorLog logs/yourdomain.com-error_log
    CustomLog logs/yourdomain.com-access_log combined
</VirtualHost></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Restart the Apache web server for the changes to take effect:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">service </span><span style="color: orange;">httpd </span><span style="color: white;">restart</span></span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a new MySQL database for Logaholic on your server:</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">mysql -u root -p
mysql> CREATE DATABASE logaholicdb;
mysql> GRANT ALL PRIVILEGES ON logaholicdb.* TO 'logaholicuser'@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> quit</pre>
</div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="line-height: 26px;"><div style="font-size: 15px;">
Do not forget to replace 'your-password' with a strong password.</div>
<div style="font-size: 15px;">
Set the MySQL server time zone:</div>
<div>
<pre style="background-color: whitesmoke; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">mysql -u root -p
mysql> SET GLOBAL time_zone = '-06:00';
mysql> FLUSH PRIVILEGES;
mysql> quit</pre>
</div>
</span></span></div>
<div>
<span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Populate the time zone tables using the following command:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">mysql_tzinfo_to_sql </span><span style="color: orange;">/usr/share/zoneinfo</span><span style="color: white;"> | mysql -u root mysql</span></span></span></pre>
</div>
<div>
<span style="font-family: verdana, geneva, sans-serif;"><div style="color: #222222; font-size: 15px; line-height: 26px;">
Open http://yourdomain.com/install.php in your popular web browser and follow the easy instructions: enter the database settings and admin login credentials, then click 'Save'. If all settings in ‘Database Settings , 'Mysql Settings' , 'File Access Check' and 'PHP Settings' sections are green, click 'Continue'.</div>
<div style="color: #222222; font-size: 15px; line-height: 26px;">
<br /></div>
<div style="color: #222222; font-size: 15px; line-height: 26px;">
That is it. The Logaholic installation is now complete. Log in to the Admin area at http://yourdomain.com/login.php and click the 'Global Settings' tab for more post-installation tasks like adding a password etc.</div>
<div class="separator" style="clear: both; color: #222222; font-size: 15px; line-height: 26px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIfoJ4QMvgzOGI5s8v-1FJoWxd0W8GPi8kneKc2UqEcJdT4hn4ZGPxIB_HkOysAQr9wVUow80NqV7BP2hYD1ADzD_6W7KX6ZrQSqVseyAOLO18hd2M-NLUdGZwrjg5chIFhLA7Sg2wMSt8/s1600/logaholic-back-end_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgIfoJ4QMvgzOGI5s8v-1FJoWxd0W8GPi8kneKc2UqEcJdT4hn4ZGPxIB_HkOysAQr9wVUow80NqV7BP2hYD1ADzD_6W7KX6ZrQSqVseyAOLO18hd2M-NLUdGZwrjg5chIFhLA7Sg2wMSt8/s1600/logaholic-back-end_hackthesec.co.in.png" /></a></div>
<div style="color: #222222; font-size: 15px; line-height: 26px;">
<br /></div>
<div style="text-align: center;">
<span style="font-size: 15px; line-height: 26px;"><b><u><span style="color: #990000;">Install Logaholic using your cPanel account</span></u></b></span></div>
<div class="separator" style="clear: both; text-align: center;">
<iframe width="320" height="266" class="YOUTUBE-iframe-video" data-thumbnail-src="https://i.ytimg.com/vi/lPXYejXsx6o/0.jpg" src="https://www.youtube.com/embed/lPXYejXsx6o?feature=player_embedded" frameborder="0" allowfullscreen></iframe></div>
<div style="color: #222222; font-size: 15px; line-height: 26px;">
<br /></div>
<div style="color: #222222; font-size: 15px; line-height: 26px;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</span></div>
</div>
</div>
</div>

How to install Logaholic on CentOS

Install Logaholic on CentOS Logaholic is a Web Analytics provider with solutions for individual websites, hosting providers and agencies...

How to install and configure Tinyproxy on Ubuntu 14.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; font-family: Lato, sans-serif; line-height: 1.1; margin: 20px 0px 10px;">
<span style="color: #990000; font-size: large;"><u>Install and configure Tinyproxy on Ubuntu 14.04</u></span></h1>
<div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>Tinyproxy </b>is a HTTP <b><a href="http://www.hackthesec.co.in/search/label/proxy">proxy</a> </b>server daemon for POSIX operating systems. Designed to be fast and small, it is useful when an HTTP/HTTPS <a href="http://www.hackthesec.co.in/search/label/proxy">proxy </a>is required, but the system resources for a larger proxy are unavailable. Because of this it has been put to uses such as a tether on the iPhone, and on the OpenWrt.</span></span></div>
<div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdPo2ovKOZSguZewmZtbrjS66xCPAOih2Dg_d9hOokOELBMyLoPFG8q8Hf9qeTnd-NKrOdbs8G81X5e3ZklP2wzWuGhfAawOfSskuCMS8w15Y1MRYYCKmX8ZM1pStNc1VudsfKzr7VQgWd/s1600/tinyproxy_block.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhdPo2ovKOZSguZewmZtbrjS66xCPAOih2Dg_d9hOokOELBMyLoPFG8q8Hf9qeTnd-NKrOdbs8G81X5e3ZklP2wzWuGhfAawOfSskuCMS8w15Y1MRYYCKmX8ZM1pStNc1VudsfKzr7VQgWd/s1600/tinyproxy_block.jpg" /></a></div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Tinyproxy is primarily designed to run on Unix-like systems. Released under the GNU General Public License, Tinyproxy is free software and has been developed for a number of years. It is currently being maintained on GitHub as a publicly accessible project. Ohloh analyses it to be a project with "mature, well-established codebase and increasing year-over-year development activity."</span></span></div>
</div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Features</u></b></span></span></div>
<div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif;">
<ul style="font-size: 15px; line-height: 26px; text-align: left;">
<li><b>Anonymous mode:</b> Allows specification of individual HTTP headers that should be allowed through, and which should be blocked.</li>
<li><b>HTTPS support:</b> Tinyproxy allows forwarding of HTTPS connections without modifying traffic in any way.</li>
<li><b>Remote monitoring:</b> Tinyproxy can be monitored remotely to view logs and access details.</li>
<li><b>Load average monitoring:</b> Tinyproxy can be configured to refuse connections after the server load reaches a certain point.</li>
<li><b>Access control:</b> Tinyproxy can be configured to only allow connections from certain subnets or IP addresses.</li>
<li><b>Secure: </b>With some configuration, Tinyproxy can be made to run without any special privileges, thus minimizing the chance of system compromise. Furthermore, it was designed with an eye towards preventing buffer overflows.</li>
<li><b>Small footprint:</b> Tinyproxy requires very little in the way of system resources - the memory footprint tends to be around 2MB with glibc, and the CPU load increases linearly with the number of simultaneous connections (depending on the speed of the connection). Therefore, Tinyproxy can be run on a spare, older machine without any impact on performance.</li>
<li><b>URL based filtering:</b> Tinyproxy allows domain and URL-based black- and whitelisting.</li>
<li><b>Transparent proxying:</b> Tinyproxy supports being configured as a transparent proxy, so that a proxy can be used without requiring any client-side configuration.</li>
<li><b>Proxy chaining:</b> Tinyproxy can use an upstream proxy server for outbound connections, instead of direct connections to the target server, creating a so-called proxy chain.</li>
</ul>
<div>
<span style="font-size: 15px; line-height: 26px;">It’s always recommended to update your package repository cache before installing new packages.</span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">sudo apt-get update</span></span></pre>
</div>
<div>
<div>
<span style="color: #0b5394; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Install and Configure Tinyproxy</u></b></span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Tinyproxy can be installed from the default Ubuntu repositories with:</span></span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">sudo apt-get install tinyproxy</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once the installation is complete, open the Tinyproxy configuration file with your editor of choice:</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">sudo nano /etc/tinyproxy.conf</span></span></pre>
</div>
<div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">The default port number is set to 8888, but you can change it to whatever you like. In most cases, the default port number does not need to be changed. Please note that if you want to run your Tinyproxy server on a port lower than 1024 you will need to start Tinyproxy using root.</span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">By default Tinyproxy will only accept connections from 127.0.0.1. Scroll down to the authorization controls section and add your local computer’s IP address to the allow list:</span></span></div>
</div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;">Allow 127.0.0.1
Allow your.local.ip.address</span></pre>
</div>
<div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you do not know your computer's IP address, open your web browser and navigate to http://ipinfo.io/ip. Copy and paste the IP address shown at this site into the Tinyproxy configuration file.</span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">All other default settings should be fine.</span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Save the configuration and restart the service.</span></span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">sudo /etc/init.d/tinyproxy restart</span></span></pre>
</div>
<div>
<div>
<span style="color: #0b5394; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Setup a cron job</u></b></span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Setting up a daily cron job will prevent memory leaks.</span></span></div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Use the command <b>crontab -e</b> to edit the crontab file and add the following line:</span></span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: "trebuchet ms" , sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">0 2 * * * /etc/init.d/tinyproxy restart</span></span></pre>
</div>
<div>
<span style="color: #222222; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">That's it. You have successfully installed Tinyproxy on your Ubuntu 14.04.</span></span></div>
<div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>
</div>

How to install and configure Tinyproxy on Ubuntu 14.04

Install and configure Tinyproxy on Ubuntu 14.04 Tinyproxy is a HTTP proxy server daemon for POSIX operating systems. Designed to be fa...

How to install Zabbix 3.0 (Monitoring Server) on CentOS 7.x / RHEL 7.x

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="post-title" style="background-color: white; border: 0px; font-family: 'PT Serif', serif; font-stretch: inherit; letter-spacing: -1px; line-height: 1.3em; margin: 0px 0px 10px; padding: 0px; vertical-align: baseline; word-wrap: break-word;">
<span style="color: #990000; font-size: large;"><u>Install Zabbix 3.0 (Monitoring Server) on CentOS 7.x / RHEL 7.x</u></span></h1>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Zabbix is a mature and effortless enterprise-class open source monitoring solution for network monitoring and application monitoring of millions of metrics.</span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Zabbix uses database like <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>, <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB</a>, Oracle and IBM DB2 to store its data. Zabbix web interface is written in <a href="http://www.hackthesec.co.in/search/label/PHP">PHP</a>.</span></span></div>
<div>
<div style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<b><u><span style="color: #0b5394;">Some of its key features are listed below :</span></u></b></div>
<div>
<ul style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: left;">
<li>Monitor everything which is on network like Servers, applications, database instance and network devices.</li>
<li>Zabbix provides Web based administration interface.</li>
<li>Monitoring CPU utilization of a particular process or a group of process ( proc.cpu.util)</li>
<li>Using low-level discovery rules, zabbix can discover Vmware hypervisor ( ESXI ) and Virtual machines.</li>
<li>Zabbix also supports agentless monitoring</li>
<li>Monitoring of database servers like MySQL, <a href="http://www.hackthesec.co.in/search/label/PostgreSQL">PostgreSQL</a>, Oracle and Microsoft SQL Server.</li>
<li>Zabbix can also perform the task of capacity planning for your environment.</li>
<li>Zabbix is Open Source so no cost involved and can be deployed on small and large environment.</li>
<li>Hardware Monitoring using Zabbix via IPMI credentials.</li>
<li>Network Device monitoring using snmp agents.</li>
</ul>
<div style="font-family: verdana, geneva, sans-serif;">
<div>
<span style="color: #333333;"><span style="font-size: 15px; line-height: 26px;"><b>Below are the details of my server on which i will install Zabbix.</b></span></span></div>
<div>
<span style="color: #333333;"><span style="font-size: 15px; line-height: 26px;">Hostname = zabbix.hackthesec.co.in</span></span></div>
<div>
<span style="color: #333333;"><span style="font-size: 15px; line-height: 26px;">IP Address = 192.168.2.2</span></span></div>
<div>
<span style="color: #333333;"><span style="font-size: 15px; line-height: 26px;">OS = <a href="http://www.hackthesec.co.in/search/label/Centos">CentOS</a> 7.x / <a href="http://www.hackthesec.co.in/search/label/RHEL">RHEL </a>7.x</span></span></div>
</div>
<div style="font-family: verdana, geneva, sans-serif;">
<span style="color: #333333;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step:1 Enable EPEL and Zabbix Repository</u></b></span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[hackthesec@zabbix ~]# yum install epel-release
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# rpm -ivh http://repo.zabbix.com/zabbix/3.0/rhel/7/x86_64/zabbix-release-3.0-1.el7.noarch.rpm</span></pre>
</div>
<div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step:2 Install Zabbix Server, Database, Web Server and PHP packages</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Use the below command to install rpm package of Zabbix server, Database Sever (MariaDB) , Web Server ( http) and PHP.</span></span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# yum -y install zabbix-server-mysql zabbix-web-mysql mysql mariadb-server httpd php</span></pre>
</div>
<div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step:3 Configure Zabbix Database.</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Start the Database (MariaDB) service</span></span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# systemctl start mariadb</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# systemctl enable mariadb</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">ln -s '/usr/lib/systemd/system/mariadb.service' '/etc/systemd/system/multi-user.target.wants/mariadb.service'
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]#</span></pre>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Use ‘mysql_secure_installation‘ command to set the root password of mariadb database and configure other parameters like ‘Remove anonymous users‘, ‘Disallow root login remotely‘ and ‘Remove test database and access to it‘</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# mysql_secure_installation</span></pre>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now create the Zabbix Database (zabbix_db) and database user (zabbix_user) and grant all privileges to the user on the Zabbix database.</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium; line-height: 20.8px;">[hackthesec</span><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">@zabbix ~]# mysql -u root -p
Enter password: 
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 10
Server version: 5.5.47-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> create database zabbix_db;
Query OK, 1 row affected (0.00 sec)

MariaDB [(none)]> grant all privileges on zabbix_db.* to zabbix_user@localhost identified by <new_password>;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> flush privileges;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]#</span></pre>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now import the database Schema using below commands,</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# cd /usr/share/doc/zabbix-server-mysql-3.0.1</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix zabbix-server-mysql-3.0.1]# gunzip create.sql.gz</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix zabbix-server-mysql-3.0.1]# mysql -u root -p zabbix_db < create.sql</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">Enter password:
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix zabbix-server-mysql-3.0.1]#</span></pre>
</div>
<div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step:4 Edit Zabbix Server Configuration file</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Edit the Zabbix Server’s config file (/etc/zabbix/zabbix_server.conf) and specify the database name for zabbix , database user name & its password.</span></span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# vi /etc/zabbix/zabbix_server.conf</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">...................................
DBHost=localhost
DBName=zabbix_db
DBUser=zabbix_user
DBPassword=XXXXXXX
...................................</span></span></pre>
</div>
<div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Save & exit the file.</span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Configure PHP Setting</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Set the below parameters in the PHP config file (/etc/php.ini )</span></span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# vi /etc/php.ini</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">................................
max_execution_time = 600
max_input_time = 600
memory_limit = 256M
post_max_size = 32M
upload_max_filesize = 16M
date.timezone = Asia/Kolkata
...............................</span></span></pre>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Allow the ports in the Firewall</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# firewall-cmd --permanent --add-port=10050/tcp</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">success
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# firewall-cmd --permanent --add-port=10051/tcp</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">success
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# firewall-cmd --permanent --add-port=80/tcp</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">success
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# firewall-cmd --reload </span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">success
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# systemctl restart firewalld</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]#</span></pre>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Set the below Selinux rule.</span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# setsebool -P httpd_can_connect_zabbix=1</span></pre>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Start the Zabbix and Web Server Service and make sure it is enable across the reboot.</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# systemctl start zabbix-server</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# systemctl enable zabbix-server</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">ln -s '/usr/lib/systemd/system/zabbix-server.service' '/etc/systemd/system/multi-user.target.wants/zabbix-server.service'
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# </span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# systemctl start httpd</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]# systemctl enable httpd</span>
<span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">ln -s '/usr/lib/systemd/system/httpd.service' '/etc/systemd/system/multi-user.target.wants/httpd.service'
[</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium; line-height: 20.8px;">@zabbix ~]#</span></pre>
</div>
<div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step:5 Browse the Zabbix Web interface using below URL</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">http://192.168.2.2/zabbix/ </span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">or </span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">http://zabbix.hackthesec.co.in./zabbix</span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Replace the IP address or hostname as per your setup.</span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv-NnYNwyFqaf3BgJ3R06S7KWKsrXXCx2pkdhYYF4ET7g93wrHMX7zx8UT_FU7y0V29VoDYAY3p8-v8IVeuk-KvKLdrZtOGUqAVm5W0c4qbUg0PgKbyuc8gJ9PK5lXwoh6KtgvOQo85ybh/s1600/Zabbix-Server-Installation.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjv-NnYNwyFqaf3BgJ3R06S7KWKsrXXCx2pkdhYYF4ET7g93wrHMX7zx8UT_FU7y0V29VoDYAY3p8-v8IVeuk-KvKLdrZtOGUqAVm5W0c4qbUg0PgKbyuc8gJ9PK5lXwoh6KtgvOQo85ybh/s1600/Zabbix-Server-Installation.jpg" /></a></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"></span><br />
<div style="font-size: 15px; line-height: 26px;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">Click on 'Next step'</span></div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">
<div style="font-size: 15px; line-height: 26px;">
On this Step Zabbix Pre-requisites are checked and verified</div>
<div class="separator" style="clear: both; font-size: 15px; line-height: 26px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTx3IlYSEzPiLth6Pe7_8UpMr_93bKNUNnrIVCnNOfwoGp0Ruhn3QfRTZXJLfJLLojrRIfuRg_izgGiZox7AP9GXfwNVyPdRjy0y9yudEc212jzRyVV78t3E-KbqFuLpL5jsJeqDUjV4OA/s1600/Zabbix-pr-requisites_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiTx3IlYSEzPiLth6Pe7_8UpMr_93bKNUNnrIVCnNOfwoGp0Ruhn3QfRTZXJLfJLLojrRIfuRg_izgGiZox7AP9GXfwNVyPdRjy0y9yudEc212jzRyVV78t3E-KbqFuLpL5jsJeqDUjV4OA/s1600/Zabbix-pr-requisites_hackthesec.co.in.jpg" /></a></div>
<div>
<div>
<span style="font-size: 15px; line-height: 26px;">Click on 'Next step'</span></div>
<div>
<span style="font-size: 15px; line-height: 26px;">Specify the Zabbix Database name, database user and its password.</span></div>
</div>
</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxYKMLKW7WSiLbrL8ixUHzO0e8kn7ujO_g_TanyvMN1I-7soWyRmYv4VG_nQEJSwF4Yqpl3c2wue-bOFMtnGeZIkR9JvbK0s2U8mQCof50mCeMwQd1wDmNtNJ8l2bEMOMvAuIasJ2BfTc6/s1600/Zabbix-installation-DB-connection_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxYKMLKW7WSiLbrL8ixUHzO0e8kn7ujO_g_TanyvMN1I-7soWyRmYv4VG_nQEJSwF4Yqpl3c2wue-bOFMtnGeZIkR9JvbK0s2U8mQCof50mCeMwQd1wDmNtNJ8l2bEMOMvAuIasJ2BfTc6/s1600/Zabbix-installation-DB-connection_hackthesec.co.in.jpg" /></a></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<br /></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Specify the Zabbix Server details and Port number.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs9-pc36bI6_sur3OHUCvyf942GkU7qRQJPsuX4_BiYIFi6_KY31R4xtaG4LA0Xl5W3BnOSjW3JwgemIR8uQH9nE-Luh5id4YQfVU9sfLdiKc9DZUpdpF73XQFfklPk4GPXGdW5HV_2bjY/s1600/Zabbix-Server-Details_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjs9-pc36bI6_sur3OHUCvyf942GkU7qRQJPsuX4_BiYIFi6_KY31R4xtaG4LA0Xl5W3BnOSjW3JwgemIR8uQH9nE-Luh5id4YQfVU9sfLdiKc9DZUpdpF73XQFfklPk4GPXGdW5HV_2bjY/s1600/Zabbix-Server-Details_hackthesec.co.in.jpg" /></a></div>
<div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
Click on 'Next step' to continue.</div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
Pre-installation summary of Zabbix Servers, click on 'Next step' to continue.</div>
<div class="separator" style="clear: both; color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtUGBItJuBWBnOSqCpDuyckgTjB7ZrkyP1oC9s-3w_V_LZPaI8T8hUgKWJPIJ_HJXvYSVy8UxlaXVzaXBid9l8Z619GpGzLWdT1GObJTCLZgRTe-AlBLqXXjHumcxinEXEx56rxTA0BRB6/s1600/Pre-installation-summary-zabbix-server-hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhtUGBItJuBWBnOSqCpDuyckgTjB7ZrkyP1oC9s-3w_V_LZPaI8T8hUgKWJPIJ_HJXvYSVy8UxlaXVzaXBid9l8Z619GpGzLWdT1GObJTCLZgRTe-AlBLqXXjHumcxinEXEx56rxTA0BRB6/s1600/Pre-installation-summary-zabbix-server-hackthesec.co.in.jpg" /></a></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">As we can see that Zabbix installation is completed successfully</span></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/AVvXsEhoobstwlhxO05XJxY3Is0QgpkjglYH0tVEQGXjQDCD_mebFZnP7wZJYRX8jkw4w5JzrPXzYS6gQDOo_BPGlnNLJuVt4Tg7i9FKLvvU-VtgR80FPSIWB5MFgce0p6BBhD5hfbsuClUPWvcD/s1600/zabbix-installation-successfully_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhoobstwlhxO05XJxY3Is0QgpkjglYH0tVEQGXjQDCD_mebFZnP7wZJYRX8jkw4w5JzrPXzYS6gQDOo_BPGlnNLJuVt4Tg7i9FKLvvU-VtgR80FPSIWB5MFgce0p6BBhD5hfbsuClUPWvcD/s1600/zabbix-installation-successfully_hackthesec.co.in.jpg" /></a></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<div>
<span style="font-size: 15px; line-height: 26px;">When we click on 'finish' , it will re-direct us to the Zabbix web interface Console.</span></div>
<div>
<span style="font-size: 15px; line-height: 26px;">Use user name as 'admin' and password 'zabbix'</span></div>
</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/AVvXsEgxQUlDWbIQtV5UQ9MTQXFhcWfKVMH-fKve3j903edxeh65tagSHWKmm1o0-09cuY-TR_-6jqHngcusu-4YD9FI_dsPFXNdw3EQ9rU99tZjbFZ2cR75cYMOtbitx60ShRxNRKVQw5G1awDY/s1600/Zabbix-Web-Console_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgxQUlDWbIQtV5UQ9MTQXFhcWfKVMH-fKve3j903edxeh65tagSHWKmm1o0-09cuY-TR_-6jqHngcusu-4YD9FI_dsPFXNdw3EQ9rU99tZjbFZ2cR75cYMOtbitx60ShRxNRKVQw5G1awDY/s1600/Zabbix-Web-Console_hackthesec.co.in.jpg" /></a></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif;">
<span style="font-size: 15px; line-height: 26px;">Zabbix Server Dashboard :</span></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/AVvXsEhA0nAfl74ye3WGXTlKEYcS9FjZns-mtn6_xM_IeEjFoAJBPMWJWv9U4icvWdMa65VP8sYLms1JwJ8w9J2ZStmnqOxYADpXorml4vDA3b4190XCRUtAJ7TUiZf5OGyQ0A4V6Jz5GaRsUQ1Q/s1600/Zabbix-Monitoring-Server-Dashboard_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhA0nAfl74ye3WGXTlKEYcS9FjZns-mtn6_xM_IeEjFoAJBPMWJWv9U4icvWdMa65VP8sYLms1JwJ8w9J2ZStmnqOxYADpXorml4vDA3b4190XCRUtAJ7TUiZf5OGyQ0A4V6Jz5GaRsUQ1Q/s1600/Zabbix-Monitoring-Server-Dashboard_hackthesec.co.in.jpg" /></a></div>
<div style="font-family: verdana, geneva, sans-serif;">
<div>
<span style="font-size: 15px; line-height: 26px;"><b><u><span style="color: #0b5394;">Step:6 Add a node to Zabbix Server for Monitoring.</span></u></b></span></div>
<div style="color: #333333;">
<span style="font-size: 15px; line-height: 26px;">Let’s assume i want to add my Ubuntu 16.04 Machine to Zabbix Server for monitoring. Login to the machine and perform the following tasks .</span></div>
</div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">hackthesec@aws:~$ sudo apt-get install zabbix-agent</span></span></pre>
</div>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Edit the Agent file and specify the Zabbix Server address.</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">@aws:~$ sudo vi /etc/zabbix/zabbix_agentd.conf
..................................
Server=192.168.2.2
ServerActive=192.168.2.2
Hostname=aws.hackthesec.co.in
..................................</span></span></pre>
</div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Start Zabbix Agent Service</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">@aws:~$ sudo systemctl start zabbix-agent
</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">@aws:~$ sudo systemctl enable zabbix-agent
Synchronizing state of zabbix-agent.service with SysV init with /lib/systemd/systemd-sysv-install...
Executing /lib/systemd/systemd-sysv-install enable zabbix-agent
</span></span><span style="color: white; font-size: medium; line-height: 20.8px;">hackthesec</span><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">@aws:~$</span></span></pre>
</div>
<div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now Go to the Zabbix Web Interface .</span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Click on Configuration —> Hosts –> Create Host</span></span></div>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2IikxX2zAAzzhWgsLRXHeKaxL9Re7iaZilmb0-lhqeyLkekVLv8nUq-GrJDwYuFWQpTjrZF9v2wZ_gLZ1fAJYoNXcXym7Ef7E0eNztRbMqa8OCjiqhnXqkYVUikIo_tC7hRZMhyphenhyphenkogJdD/s1600/Zabbix-Configuration-hosts_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh2IikxX2zAAzzhWgsLRXHeKaxL9Re7iaZilmb0-lhqeyLkekVLv8nUq-GrJDwYuFWQpTjrZF9v2wZ_gLZ1fAJYoNXcXym7Ef7E0eNztRbMqa8OCjiqhnXqkYVUikIo_tC7hRZMhyphenhyphenkogJdD/s1600/Zabbix-Configuration-hosts_hackthesec.co.in.jpg" /></a></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Specify the Host name, IP address and Group names. In Templates Tab, search appropriate templates and click on Add.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjXvH4Tr0LH9qsDtEWbBhx0RDGY1wtfZ_SmHRFyl3MLbefXH2dA4XlPOSIFidfVqDaj0QvJu9Jo7ZQ6iA1Jj0JAAceQsqSBVuXzV2VYrOzbFhh-NEXFLVev3kHevmf5i5L9_jIY_Y3u_Zy/s1600/Zabbix-OS-Templates_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjXvH4Tr0LH9qsDtEWbBhx0RDGY1wtfZ_SmHRFyl3MLbefXH2dA4XlPOSIFidfVqDaj0QvJu9Jo7ZQ6iA1Jj0JAAceQsqSBVuXzV2VYrOzbFhh-NEXFLVev3kHevmf5i5L9_jIY_Y3u_Zy/s1600/Zabbix-OS-Templates_hackthesec.co.in.jpg" /></a></div>
<div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">To View the events for all the hosts or a particular host, Click on Monitoring —> Triggers</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfaVX9JLC9eKKBNcIfK22cWHLzuGJCPwUdMtkeQIvcPyu0gq5GilQmxjNK4HCcCu8tE4fMYLfU-DSEX6fn29ImPhx3Yn5ZLOCp0RfA6ztmuvXVVBnBwhY8n1ABz-k5leiVin0aqNjLsZpN/s1600/Zabbix-Server-Status-triggers_hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjfaVX9JLC9eKKBNcIfK22cWHLzuGJCPwUdMtkeQIvcPyu0gq5GilQmxjNK4HCcCu8tE4fMYLfU-DSEX6fn29ImPhx3Yn5ZLOCp0RfA6ztmuvXVVBnBwhY8n1ABz-k5leiVin0aqNjLsZpN/s1600/Zabbix-Server-Status-triggers_hackthesec.co.in.jpg" /></a></div>
<div>
<br />
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Zabbix Email-Notification Setting</u></b></span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>E-mail settings</b></span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Initially there are several predefined notification <b>delivery methods</b> in Zabbix. <b>E-mail</b> is one of those.</span></span><br />
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">To configure e-mail settings, go to <b>Administration → Media types</b> and click on <b>Email </b>in the list of pre-defined media types.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/media_types.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/media_types.png" /></a></div>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u><br /></u></b></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">This will present us with the e-mail settings definition form.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/media_type_email.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/media_type_email.png" /></a></div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Set the values of SMTP server, SMTP helo and SMTP e-mail to the appropriate for your environment.<b>Press Update when ready.</b></span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now you have configured 'Email' as a working media type. A media type must be linked to users by defining specific delivery addresses (like we did when configuring a new user), otherwise it will not be used.</span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>New action</b></span></span><br />
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Delivering notifications is one of the things actions do in Zabbix. Therefore, to set up a notification, go to <b>Configuration → Actions</b> and click on Create action.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/new_action.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/new_action.png" /></a></div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">In this form, enter a name for the action.</span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">{TRIGGER.STATUS} and {TRIGGER.NAME} macros (or variables), visible in the Default subject and Default message fields, will be replaced with the actual trigger status and trigger name values.</span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">In the most simple case, if we do not add any more specific conditions, the action will be taken upon any trigger change from 'Ok' to 'Problem'.</span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">We still should define what the action should do - and that is done in the Operations tab. Click on New in there, which opens a new operation form.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/new_operation.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://www.zabbix.com/documentation/3.0/_media/manual/quickstart/new_operation.png" /></a></div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Here, click on Add in the Send to Users block and select the user ('user') we have defined. Select 'Email' as the value of Send only to. When done with this, click on Add in the operation detail block.</span></span><br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span>
<br />
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">That is all for a simple action configuration, so click Add in the action form.</span></span><br />
<br /></div>
</div>
</div>
<div>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>

How to install Zabbix 3.0 (Monitoring Server) on CentOS 7.x / RHEL 7.x

Install Zabbix 3.0 (Monitoring Server) on CentOS 7.x / RHEL 7.x Zabbix is a mature and effortless enterprise-class open source monitorin...

How to Install Notepadqq Text Editor on Ubuntu

How to Install Notepadqq Text Editor on Ubuntu

Install Notepadqq Text Editor on Ubuntu Notepadqq is a Notepad++-like editor for the Linux desktop. It helps developers by providing ...

How to Create, List or Drop Indexes on MySQL Table

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<u><span style="color: #990000;">Create, List or Drop Indexes on MySQL Table</span></u></h2>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/search/label/Mysql_Database">MySQL </a>is an open-source relational database management system (RDBMS); in July 2013, it was the world's second most widely used RDBMS, and the most widely used open-source client–server model RDBMS.It is named after Michael Widenius' (who is a co-founder of <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>) daughter, while "SQL" stands as the abbreviation for Structured Query Language. </span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglu6BHfIUQ1AeBTzwlsKiSNhaOqYuocrXR44DVliL0FgZSkJCAMrliMI-GKV_mNDYKbTqCkPXivMsMMn6tr2Isb_RqaVSQ-laoP5agXcTDjkayCuJXQgiZiDvAHJB4MimneZ_d3aYZ9nD9/s1600/mysq-linux-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEglu6BHfIUQ1AeBTzwlsKiSNhaOqYuocrXR44DVliL0FgZSkJCAMrliMI-GKV_mNDYKbTqCkPXivMsMMn6tr2Isb_RqaVSQ-laoP5agXcTDjkayCuJXQgiZiDvAHJB4MimneZ_d3aYZ9nD9/s320/mysq-linux-www.hackthesec.co.in.jpg" width="320" /></a></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation. For proprietary use, several paid editions are available, and offer additional functionality.</span></span></div>
<div>
<div style="background-color: white;">
<div>
<span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>CREATE INDEX:-</u></b></span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">This will creates index on mysql table. This will allow duplicate values also.</span></span></div>
</div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">CREATE INDEX index_name ON table_name (COLUMN_NAME1, COLUMN_NAME2, ...)</span></span></pre>
</div>
</div>
<div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
<b><u><span style="color: #0b5394;">CREATE UNIQUE INDEX:-</span></u></b></div>
<div style="color: #333333;">
This will creates index on mysql table. With uses of UNIQUE keyword this will not allow duplicate values.</div>
</span></span></div>
<div>
<div>
<div style="background-color: white;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">CREATE UNIQUE INDEX index_name ON table_name (COLUMN_NAME1, COLUMN_NAME2, ...)</span></span></pre>
</div>
</div>
</div>
<div>
<div style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
<b><u><span style="color: #0b5394;">1. CREATE INDEX Examples:-</span></u></b></div>
<div style="color: #333333; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">
For this example I have a table named Users with thousands of records in mysql database. The table structure is as following in screenshot.</div>
<div class="separator" style="clear: both; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3z2qQOnt4I3LKrqoI_EozExpVygth-cm1ix67-oPGafGtvzuOPi4bhw34QPRhDrky4PBw0me1PMR4EvN3Ya-D90I7PJewb3gs75DprQqbNjeQvgj-B-nTUFjsddzj0EAv2eB6zhKJGpTb/s1600/mysql-index-hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3z2qQOnt4I3LKrqoI_EozExpVygth-cm1ix67-oPGafGtvzuOPi4bhw34QPRhDrky4PBw0me1PMR4EvN3Ya-D90I7PJewb3gs75DprQqbNjeQvgj-B-nTUFjsddzj0EAv2eB6zhKJGpTb/s1600/mysql-index-hackthesec.co.in.png" /></a></div>
<div style="font-family: verdana, geneva, sans-serif;">
<span style="color: #333333;"><span style="font-size: 15px; line-height: 26px;">Now use following command to create index named Users_Idx1 on table Users based on column username.</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">mysql> CREATE INDEX Users_Idx1 ON Users (username);</span></span></pre>
</div>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Use UNIQUE keyword with the query to create index with unique records.</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">mysql> CREATE UNIQUE INDEX Users_Idx1 ON Users (username);</span></span></pre>
</div>
<div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
<b><span style="color: #0b5394;"><u>2. SHOW INDEX Examples:-</u></span></b></div>
<div style="color: #333333;">
Use following sql command to list all indexes for a mysql table. The below query will delete Users_Idx1 index from Users table in current database.</div>
</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">mysql> SHOW INDEX FROM Users;</span></span></pre>
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDYacfjmKXhzjowDlol4bz38hgMHGasimYiSfGQH9qubNrw8FR3xCKJLO27uVZu1cuC-qxlmMQpTA_VOXbih3VO5ztw4sMc7VmsqpUzfoQMx_J5JgmL4_Dz6ArVx37e7Mf9B27ypYr99pr/s1600/mysql-index2-hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiDYacfjmKXhzjowDlol4bz38hgMHGasimYiSfGQH9qubNrw8FR3xCKJLO27uVZu1cuC-qxlmMQpTA_VOXbih3VO5ztw4sMc7VmsqpUzfoQMx_J5JgmL4_Dz6ArVx37e7Mf9B27ypYr99pr/s1600/mysql-index2-hackthesec.co.in.png" /></a></div>
<div>
<br /></div>
<div>
<span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
<b><u><span style="color: #0b5394;">3. DELETE INDEX Examples:-</span></u></b></div>
<div style="color: #333333;">
Use following sql command to delete index on mysql table.</div>
</span></span></div>
<div>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;">mysql>  ALTER TABLE Users DROP INDEX Users_Idx1;</span></span></pre>
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: medium;"><span style="line-height: 20.8px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></pre>
</div>
</div>

How to Create, List or Drop Indexes on MySQL Table

Create, List or Drop Indexes on MySQL Table MySQL is an open-source relational database management system (RDBMS); in July 2013, it was ...