Hack The Sec-Leading Resource Of Linux Tutorial

Node.js with MySQL Examples

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000;"><i><u>Node.js with MySQL Examples</u></i></span></h2>
<div>
<br /></div>
<div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Node.js is an popular programming language like PHP & JAVA for web applications. Also MySQL is most popular database used for storing values. MySQL database driver for Node.js is available under NPM repository. In this tutorial you will learn to how to connect MySQL database using node.js and do INSERT, UDATE, SELECT and DELETE operations on MySQL database table.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTiGXAXsRvpsw8iYpufgMngnkmNxjVpPqzvIeBtCj25i1oc9vDHNczzfVtFvsCAUTpT4tkw4MQO4qxM3UqPg0z7Crmh2YoJcrM2vr6vexURbdaa27vO9nJ4FezEioaeXJ3LAAqsecSYHmA/s1600/node-with-mysql_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjTiGXAXsRvpsw8iYpufgMngnkmNxjVpPqzvIeBtCj25i1oc9vDHNczzfVtFvsCAUTpT4tkw4MQO4qxM3UqPg0z7Crmh2YoJcrM2vr6vexURbdaa27vO9nJ4FezEioaeXJ3LAAqsecSYHmA/s1600/node-with-mysql_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div>
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; font-stretch: normal; font-weight: normal; 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;">
<ul style="text-align: left;">
<li><a href="http://www.hackthesec.co.in/2016/01/how-to-connect-nodejs-with-mysql.html" target="_blank"><span style="color: red;">How to Connect Node.js with MySQL</span></a></li>
</ul>
</h2>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">1. Create MySQL Database and Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">First create a database and user in mysql for your applications. For testing purpose, we are creating mydb database and use it.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> CREATE DATABASE mydb;
mysql> USE mydb;<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now create a example tables for doing insert, update and delete operations.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> CREATE TABLE users ( 
  id int(11) NOT NULL AUTO_INCREMENT,
  firstname varchar(30),
  lastname varchar(30),
  email VARCHAR(50),
  creation_date TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<span style="font-size: 0.9em;">

</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Arial, Helvetica, sans-serif;">Also create a mysql user for accessing database from application.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> GRANT ALL on mydb.* to 'myusr'@'localhost' identified by '123456';
mysql> FLUSH PRIVILEGES;<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">2. Install Node.js MySQL Module</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">MySQL driver for node.js is available under node package manager (NPM). Use the following command to install it.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo npm install mysql
</pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">3. Simple App to Connect MySQL</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Below is sample node.js program which will connect node.js application with MySQL server. It will show success and error messages according to connections results and close the connection at the end of program. Create a JavaScript file <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">app.js</span>.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ cd myApp
$ vim app.js<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">and add the following content to above file.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">var mysql  = require('mysql');
var dbconn = mysql.createConnection({
  host     : 'localhost',
  user     : 'myusr',
  password : '123456',
  database : 'mydb'
});

dbconn.connect(function(err){
  if(err){
    console.log('Database connection error');
  }else{
    console.log('Database connection successful');
  }
});

dbconn.end(function(err) {
  // Function to close database connection
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now execute above script using nodejs and make sure that database is connecting properly or not.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ node app.js

Database connection successful<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">3. Insert Data in MySQL Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now add the code in above script to insert data in <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">users</span> table in <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">mydb</span> database.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">var mysql  = require('mysql');
var dbconn = mysql.createConnection({
  host     : 'localhost',
  user     : '<DB_USER>',
  password : '<DB_PASSWORD',
  database : '<DB_NAME>'
});

dbconn.connect(function(err){
  if(err){
    console.log('Database connection error');
  }else{
    console.log('Database connection successful');
  }
});

<span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">
var record= { firstname: 'hackthe', lastname: 'sec', email: 'abc@hackthesec' };

dbconn.query('INSERT INTO users SET ?', record, function(err,res){
  if(err) throw err;

console.log('Last record insert id:', res.insertId);
});
</span>
dbconn.end(function(err) {
  // Function to close database connection
}<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now execute app.js script using command line and make sure that data is properly inserted in database. Repeat this step few more times with updating values in above script.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ node app.js

Database connection successful
Last record insert id: 5<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Also check the record added in users table under mydb database using mysql command line.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> select * from users;

console.log('Data received from Db:\n');
  console.log(records);
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">or you can customize search by selection values basis of specific conditions.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">dbconn.query('SELECT * FROM users WHERE id = ?' [5] ,function(err, records){
  if(err) throw err;

console.log('Data received from Db:\n');
  console.log(records);
});<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">5. Update Data from MySQL Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now if you required to update existing data in mysql table, use following code.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">dbconn.query('SELECT users SET email = ? WHERE id = ?', ['new@hackthesec.co.in', 6], function(err, result){
  if(err) throw err;
  
  console.log('Record Updated ' + result.changedRows + ' rows');
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now check values in database table.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> select * from users;

+----+-----------+----------+----------------+---------------------+
| id | firstname | lastname | email          | creation_date       |
+----+-----------+----------+----------------+---------------------+
|  5 | hackthe   | sec      | abc@hackthesec | 2016-01-22 17:16:19 |
|  6 | payel     | sec      | new@<span style="line-height: 1.3em;">hackthesec</span><span style="line-height: 1.3em;"> | 2016-01-22 17:16:55 |</span>
+----+-----------+----------+----------------+---------------------+
2 row in set (0.01 sec)<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">6. Delete Data from MySQL Table</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now if you delete some record from table, add following code in your node.js application code.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;">dbconn.query('DELETE FROM users WHERE id = ?', [6], function(err, result){
  if(err) throw err;
  
  console.log('Record Updated ' + result.affectedRows + ' rows');
});<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Now check values in database table.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">mysql> select * from users;

Node.js with MySQL Examples

Node.js with MySQL Examples Node.js is an popular programming language like PHP & JAVA for web applications. Also MySQL is most popular database used for storing values. MySQL database driver for Nod…

26 Jan 2016

How To Install Memcached with PHP on Ubuntu 14.04 /12.04 LTS

<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;">
<i><span style="color: #cc0000;">How To Install Memcached with PHP on Ubuntu 14.04 /12.04 LTS</span></i></h2>
<div>
<a href="http://memcached.org/" style="background-color: white; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; outline: none; text-decoration: none; transition: all 0.25s linear;" target="_blank"><span style="color: red;">Memcached</span></a><span style="background-color: white; font-size: 16px; line-height: 28px;"><span style="color: red; font-family: "roboto slab";"> </span><span style="font-family: "arial" , "helvetica" , sans-serif;">is a distributed memory object caching system which stored data in memory on key-value basis. It is very useful for optimizing dynamic websites and enabled speed by caching objects in memory. This article will help you to install Memcached with PHP Memcache PECL extension on Ubuntu 14.10, 14.04 and 12.04 systems.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyPYyu0WTtiKaVH1LWipBc4rR3VCOjh7hOm_aC4IokvVnzO_H3f_4bZHILUzD-KEoSLNArKVE4CxJT82_DvZueY7j65NoS2G31tE5_zuGBqxKx4MbipdioW3OXEJXZXnxAD81Ss06fymRi/s1600/memcached_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiyPYyu0WTtiKaVH1LWipBc4rR3VCOjh7hOm_aC4IokvVnzO_H3f_4bZHILUzD-KEoSLNArKVE4CxJT82_DvZueY7j65NoS2G31tE5_zuGBqxKx4MbipdioW3OXEJXZXnxAD81Ss06fymRi/s1600/memcached_www.hackthesec.co.in.png" /></a></div>
<h2 class="heading1" style="background-color: white; border: 0px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<ul style="text-align: left;">
<li><span style="color: #0b5394; font-family: "roboto slab"; line-height: 34px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-memcached-with-php-on.html" target="_blank"><span style="font-size: large;">How To Install Memcached with PHP on CentOS/RHEL 7/6/5</span></a></span></li>
</ul>
<span style="color: #0b5394; font-family: "roboto slab"; font-weight: bolder; line-height: 34px;">Install Memcached Service</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">First we recommended to update your system with latest packages.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo apt-get update
</pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now use following command to install memcached service on your system.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo apt-get install memcached
</pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install PHP with Memcached Support</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now we are going to install php with few more required packages for setup. We also need to install Memcache module for php using below commands.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo apt-get install php5 php5-dev php-pear php5-memcached

$ sudo apt-get install libmemcached-dev build-essential<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install Memcache PHP Extension</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Finally install Memcache php extension using PECL to finish setup.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo pecl install memcache
</pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now enable memcache support in php. Before creating a new file just make sure there are no php memcache configuration file available. If file already exists just skip below command.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ echo "extension=memcache.so" > /etc/php5/apache2/conf.d/20-memcache.ini
</pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">After doing every think just restart your Apache service.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo service apache2 restart
</pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Verify Memcache Setup</span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Use following command to check and verify that memcached service is running fine.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">root@hackthesec:~$ echo "stats settings" | nc localhost 11211

STAT maxbytes 67108864
STAT maxconns 1024
STAT tcpport 11211
STAT udpport 11211
STAT inter 127.0.0.1
STAT verbosity 0
STAT oldest 0
STAT evictions on
STAT domain_socket NULL
STAT umask 700
STAT growth_factor 1.25
STAT chunk_size 48
STAT num_threads 4
STAT num_threads_per_udp 4
STAT stat_key_prefix :
STAT detail_enabled no
STAT reqs_per_event 20
STAT cas_enabled yes
STAT tcp_backlog 1024
STAT binding_protocol auto-negotiate
STAT auth_enabled_sasl no
STAT item_size_max 1048576
STAT maxconns_fast no
STAT hashpower_init 0
STAT slab_reassign no
STAT slab_automove 0
END
<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now check if Memcache php extension is enabled and working properly. Create a <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-size: inherit; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">info.php</span> file using following code</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><?php
  phpinfo();
?><span style="font-size: 0.9em;">
</span></pre>
<div class="separator" style="clear: both;">
</div>
<div style="background-color: white; border: 0px; color: #555555; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<a href="http://tecadmin.net/wp-content/uploads/2015/03/php-memcache.png" style="color: #ff8800; outline: none; text-decoration: none; transition: all 0.25s linear;"></a></div>
<br />
<div style="-webkit-text-stroke-width: 0px; background-color: white; border: 0px; font-size: 16px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 28px; margin: 0px 0px 20px; orphans: auto; outline: 0px; padding: 0px; text-align: start; text-indent: 0px; text-transform: none; vertical-align: baseline; white-space: normal; widows: 1; word-spacing: 0px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now access info.php on web interface and search for Memcache, You will get result like below.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGfkm2d1SWCGbNfq5Ms7-E2LJ5z1PSlunrzq-pkLnHgxnsjEJwVTsC3jCTofvaq89_U413TgG6-RR6UC04dexDbEJx-P3Ruz_rSaD3rLEJpi_MrC3_E-aK1W8Q75xMiC1QLqcOfCPccUdH/s1600/php-memcache_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGfkm2d1SWCGbNfq5Ms7-E2LJ5z1PSlunrzq-pkLnHgxnsjEJwVTsC3jCTofvaq89_U413TgG6-RR6UC04dexDbEJx-P3Ruz_rSaD3rLEJpi_MrC3_E-aK1W8Q75xMiC1QLqcOfCPccUdH/s640/php-memcache_www.hackthesec.co.in.png" width="640" /></a></div>
<div>
<span style="background-color: white; font-size: 16px; line-height: 28px;"><span style="font-family: "arial" , "helvetica" , sans-serif;"><a href="http://www.hackthesec.co.in/" style="font-family: 'roboto slab';" target="_blank">Hack The Security</a></span></span></div>
</div>

How To Install Memcached with PHP on Ubuntu 14.04 /12.04 LTS

How To Install Memcached with PHP on Ubuntu 14.04 /12.04 LTS Memcached is a distributed memory object caching system which stored data in memory on key-value basis. It is very useful for optimizing d…

26 Jan 2016

How To Install Memcached with PHP on CentOS/RHEL 7/6/5

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #cc0000;"><i><u>How To Install Memcached with PHP on CentOS/RHEL 7/6/5</u></i></span></h2>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<a href="http://memcached.org/" style="font-family: Arial, Helvetica, sans-serif; outline: none; text-decoration: none;" target="_blank"><span style="color: blue;">Memcached</span></a><span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="color: blue;"> </span>is a distributed memory object caching system which stored data in memory on key-value basis. It is very useful for optimizing dynamic websites and enabled speed by caching objects in memory. </span><a href="http://memcached.org/about" target="_blank">Read more</a><span style="font-family: "arial" , "helvetica" , sans-serif;"> about memcache.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_L0t796Hr2w9wlMN-LlqQTC7s0k3_GLTiVufILjs-NF9XDpXUpVMj2Puh7ujTzLU8lmkR81kbtM2fZzkAIqCiRqTRMZ7caAN-BvN8hdunZB2r0yFMJ-18XTnGuZMWmB1rxzAy91lJwIPj/s1600/memcached_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_L0t796Hr2w9wlMN-LlqQTC7s0k3_GLTiVufILjs-NF9XDpXUpVMj2Puh7ujTzLU8lmkR81kbtM2fZzkAIqCiRqTRMZ7caAN-BvN8hdunZB2r0yFMJ-18XTnGuZMWmB1rxzAy91lJwIPj/s1600/memcached_www.hackthesec.co.in.png" /></a></div>
<div>
<span style="color: black; font-family: "arial" , "helvetica" , sans-serif;"><span style="background-color: white; line-height: 28px;"><br /></span></span></div>
<div>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">This article will help you to install Memcached and PHP Memcache extension on CentOS/RHEL 7/6/5 systems.</span></div>
<div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-memcached-with-php-on_26.html" target="_blank"><span style="font-size: large;">How To Install Memcached with PHP on Ubuntu 14.04 /12.04 LTS</span></a></span></li>
</ul>
<br />
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #0b5394; font-family: "roboto slab"; font-size: 24px; font-weight: bolder; line-height: 34px;">Install Memcached Server</span></div>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">First we will install Memcached server on our system. Use following command to install memcached using yum package manager.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># yum install memcached </pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now start Memcached service using following commands.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><orange style="color: orange;">For CentOS/RHEL 7</orange>
# systemctl enable memcached
# systemctl start memcached

<orange style="color: orange;">For CentOS/RHEL 6/5</orange>
# service memcached start
# chkconfig memcached on<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install PHP with Memcache PHP Extension</span></h2>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now we have installed Memcached server on our system. But to use Memcached service using php scripts we need to install Memcache php extension. So first install php and other required php modules and then use PECL to install PHP Memcache extension using following commands.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># yum groupinstall "Development tools"
# yum install zlib zlib-devel
# yum install php php-devel php-pear<span style="font-size: 0.9em;">  </span></pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">After installing php-pear package install PECL extension using command below.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># pecl install memcache </pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now we need to enable memcache module in php. Add following line at end of </span><span style="border: 0px; font-family: "arial" , "helvetica" , sans-serif; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">php.ini</span><span style="font-family: "arial" , "helvetica" , sans-serif;"> file.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># echo "extension=memcache.so" >> /etc/php.d/memcache.ini
</pre>
<div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Restart Apache service to enable extension</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><orange style="color: orange;">For CentOS/RHEL 7</orange>
# systemctl restart httpd

<orange style="color: orange;">For CentOS/RHEL 6/5</orange>
# service httpd restart<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Verify Memcache Setup</span></h2>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Use following command to check and verify that memcached service is running fine.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">root@hackthesec:~$ echo "stats settings" | nc localhost 11211

</span></pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now check if memcache php extension is enabled and working properly. Create a <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">info.php</span> file using following code</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><?php
  phpinfo();
?><span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">Now access info.php on web interface and search for Memcache, You will get result like below.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixG5MZ0PNsX1qbW1XlKHl5kPNckcMdoGq-eHZHy3h91mJyrbfRDwjDAxRDRGSKEb9-x0jCDd9FZXCL3iJMKL_eHoX-lwc9kMFAngx5ZCmWG86yKYFL4OREsXNdygD06LBUkwgK3YZj4qW5/s1600/php-memcache_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="338" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEixG5MZ0PNsX1qbW1XlKHl5kPNckcMdoGq-eHZHy3h91mJyrbfRDwjDAxRDRGSKEb9-x0jCDd9FZXCL3iJMKL_eHoX-lwc9kMFAngx5ZCmWG86yKYFL4OREsXNdygD06LBUkwgK3YZj4qW5/s640/php-memcache_www.hackthesec.co.in.png" width="640" /></a></div>
<div style="background-color: white; border: 0px; color: #555555; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<a href="http://www.hackthesec.co.in/" target="_blank">Hack The Security</a></div>
</div>
</div>

How To Install Memcached with PHP on CentOS/RHEL 7/6/5

How To Install Memcached with PHP on CentOS/RHEL 7/6/5 Memcached is a distributed memory object caching system which stored data in memory on key-value basis. It is very useful for optimizing dynamic…

26 Jan 2016

How To Enable or Disable CGI Scripts in Apache 2.4

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000;">How To Enable or Disable CGI Scripts in Apache 2.4</span></h2>
<div>
<span style="font-family: Trebuchet MS, sans-serif;"><br /></span></div>
<div>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Apache Module <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"><span style="color: red;">mod_cgi/mod_cgid</span></span> is responsible for handling of CGI Scripts. for worker and event multi-threaded MPM uses cgi daemon “mod_cgid” module. This tutorial will help you to how to enable or disable CGI script in Apache 2.4 server on Linux operating systems.</span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJSx289rsWaKbl9eLzLdn0jS9Dd3D6bXJG3t7c8uTzma-fvhH-221mXOxra_YiUSI-ffzu3dVpXC2GIbNjeund-1DrhwmWjnO1VJ3I5j-c4sKRa3XQ90qLSuZ82STsngDBnIJRkaXFmviw/s1600/Apache_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJSx289rsWaKbl9eLzLdn0jS9Dd3D6bXJG3t7c8uTzma-fvhH-221mXOxra_YiUSI-ffzu3dVpXC2GIbNjeund-1DrhwmWjnO1VJ3I5j-c4sKRa3XQ90qLSuZ82STsngDBnIJRkaXFmviw/s1600/Apache_www.hackthesec.co.in.png" /></a></div>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="color: #0b5394; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px;">1. Enable CGI Module in Apache</span></div>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">To enable CGI in your Apache server. you need to Load module file <span style="color: red;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">mod_cgi.so</span> or <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">mod_cgid.so </span></span>in your Apache configuration file.</span></div>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">CentOS, RHEL & Fedora Users –</span></h3>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">On CentOS, Red Hat, Fedora and other rpm based distributions edit<span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">/etc/httpd/conf.modules.d/XX-cgi.conf</span> configuration file and make sure below showing lines are not commented.</span></div>
<pre class="pretty" style="background: none 0px 0px repeat scroll rgb(240, 240, 240); border-left-color: rgb(116, 183, 63); border-left-width: 3px; border-radius: 5px; border-style: none none none solid; line-height: 1.5em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 8px 20px 8px 18px; vertical-align: baseline;"><IfModule mpm_worker_module>
   LoadModule cgid_module modules/mod_cgid.so
</IfModule>
<IfModule mpm_event_module>
   LoadModule cgid_module modules/mod_cgid.so
</IfModule>
<IfModule mpm_prefork_module>
   LoadModule cgi_module modules/mod_cgi.so
</IfModule><span style="font-size: 0.9em;">

</span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Ubuntu, Debian & LinuxMint Users –</span></h3>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Ubuntu, Debian, LinuxMint and other Debian derivatives use following command to enable CGI module. This command creates a soft links of module configuration file to <b>/etc/apache2/mod-enabled/</b> directory.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ sudo a2enmod cgi
</pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">After enabling CGI modules in Apache configuration you need to restart Apache service on your system for changes take effect.</span></div>
<h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">2. Disable CGI Module in Apache</span></h2>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">We recommend to keep CGI disabled on your server until its recommended for your server. CGI scripts are are used by hackers to attack on servers. Use below options to disable cgi script on your Apache server.</span></div>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">CentOS, RHEL & Fedora Users –</span></h3>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">CentOS, Red Hat, Fedora and other rpm based distributions rename<span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-weight: 700; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">/etc/httpd/conf.modules.d/XX-cgi.conf</span> configuration file like below.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ mv /etc/httpd/conf.modules.d/XX-cgi.conf /etc/httpd/conf.modules.d/XX-cgi.conf.disable<span style="font-size: 0.9em;">
</span></pre>
<h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Ubuntu, Debian & LinuxMint Users –</span></h3>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">Ubuntu, Debian, LinuxMint and other Debian derivatives use following command to disable CGI module.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;">$ a2dismod cgi
</pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: Georgia, Times New Roman, serif;">After disabling CGI modules you need to restart Apache service on your system for changes take effect.</span></div>
<div style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
Reference:-<br /><span style="color: red;"><a href="http://httpd.apache.org/docs/2.4/howto/cgi.html">http://httpd.apache.org/docs/2.4/howto/cgi.html</a></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: #333333; font-size: 12px; line-height: 19.2px; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"><pre style="background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><a href="http://www.hackthesec.co.in/" target="_blank">http://www.hackthesec.co.in</a>
<a href="http://www.twitter.com/hackthesecurity" target="_blank">http://www.twitter.com/hackthesecurity</a>
<span style="color: #999999;"><a href="https://www.facebook.com/htsecu">https://www.facebook.com/htsecu</a></span></pre>
</span></span></pre>
</div>
</div>

How To Enable or Disable CGI Scripts in Apache 2.4

How To Enable or Disable CGI Scripts in Apache 2.4 Apache Module mod_cgi/mod_cgid is responsible for handling of CGI Scripts. for worker and event multi-threaded MPM uses cgi daemon “mod_cgid” module…

26 Jan 2016

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

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

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

Wordpress Booking Calendar Contact Form Plugin Unauthenticated SQL injection Author: i0akiN SEC-LABORATORY Download Exploit: Source …

26 Jan 2016

Install and Configure Caching-Only DNS Server in RHEL/CentOS 7

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-size: x-large;">Install and Configure Caching-Only DNS Server in RHEL/CentOS 7</span><br />
<span style="background-color: white; font-family: Verdana, sans-serif; line-height: 28.8px;">DNS servers comes in several types such as master, slave, forwarding and cache, to name a few examples, with cache-only DNS being the one that is easier to setup. Since DNS uses the UDP protocol, it improves the query time because it does not require an acknowledgement.</span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGmlA863bI-9bY9VrlFYVC-uB7nhDSRVe3oqRhIjT0ACX5k3aih65GwI1OegSFwsV_S82UZ8u84NNlNHPkgkfW_BTIbJ9xxAA2PCPELHRQNoIJwPBiCM7Jjj0SlsOzskdVbHOUOXHReufH/s1600/Setup-Cache-Only-DNS-in-CentOS-RHEL-7_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="306" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGmlA863bI-9bY9VrlFYVC-uB7nhDSRVe3oqRhIjT0ACX5k3aih65GwI1OegSFwsV_S82UZ8u84NNlNHPkgkfW_BTIbJ9xxAA2PCPELHRQNoIJwPBiCM7Jjj0SlsOzskdVbHOUOXHReufH/s640/Setup-Cache-Only-DNS-in-CentOS-RHEL-7_www.hackthesec.co.in.png" width="640" /></a></div>
<span style="background-color: white; font-family: "roboto condensed" , "arial" , sans-serif; font-size: 18px; line-height: 28.7999992370605px;"><br /></span>
<br />
<ul style="text-align: left;">
<li><span style="background-color: white; font-family: 'roboto condensed', arial, sans-serif; font-size: 18px; line-height: 28.8px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-setup-dns-bind-server-on.html" target="_blank"><span style="color: red;">How to Setup DNS (Bind) Server on CentOS/RHEL 7/6/5</span></a></span></li>
</ul>
<span style="background-color: white; font-family: Verdana, sans-serif; line-height: 28.8px;">The cache-only DNS server is also known as resolver, which will query DNS records and fetch all the DNS details from other servers, and keep each query request in its cache for later use so that when we perform the same request in the future, it will serve from its cache, thus reducing the response time even more.</span><br />
<u><span style="font-family: Arial, Helvetica, sans-serif;"><span style="background-color: white; line-height: 28.8px;"><br /></span>
</span></u><br />
<div style="background-color: white; margin-bottom: 10px;">
<span style="color: #0b5394; font-family: Arial, Helvetica, sans-serif; font-size: small;"><span style="font-family: Arial, Helvetica, sans-serif; font-size: large; line-height: 18px;"><u>My Testing Environment</u></span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">DNS server  : dns.hackthesec.co.in (Red Hat Enterprise Linux 7.1)
Server IP Address : 192.168.1.17
Client   : node1.</span></span><span style="color: white; font-size: 12px; line-height: 15.6000003814697px;">hackthesec.co.in</span><span style="color: white; font-size: 12px; line-height: 15.6000003814697px;"> (CentOS 7.1)</span>
<span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">Client IP Address : 192.168.1.35</span></span></pre>
<div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="color: #0b5394; font-family: "arial" , "helvetica" , sans-serif;"><span style="line-height: 18px;">Step 1: Installing Cache-Only DNS Server in RHEL/CentOS 7</span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="line-height: 28.7999992370605px;"><span style="font-family: "arial" , "helvetica" , sans-serif;">1.The Cache-Only DNS server, can be installed via the bind package. If you don’t remember the package name, you can do a quick search for the package name using the command below.</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># yum search bind</span></span></pre>
<div>
<span style="color: white;"><span style="line-height: 15.6000003814697px;"><br /></span></span></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">2.</span><span style="line-height: 28.7999992370605px;"> In the above result, you will see several packages. From those, we need to choose and install only</span><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">bind</span><span style="line-height: 28.7999992370605px;"> and </span><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">bind-utils</span><span style="line-height: 28.7999992370605px;"> packages using following yum command.</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># yum install bind bind-utils -y</span></span></pre>
<div>
<span style="color: white;"><span style="line-height: 15.6000003814697px;"><br /></span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="color: #0b5394; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 18px;">Step 2: Configure Cache-Only DNS in RHEL/CentOS 7</span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">3.</span><span style="line-height: 28.7999992370605px;"> Once DNS packages are installed we can go ahead and configure DNS. Open and edit</span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><code style="background: none 0px 0px repeat scroll rgb(246, 246, 248); border-radius: 3px; border: 1px solid rgb(158, 158, 159); font-stretch: inherit; font-weight: 600; line-height: 1.6; margin: 0px; max-width: 100%; overflow: auto; padding: 2px; vertical-align: baseline; white-space: pre;">/etc/named.conf</code><span style="line-height: 28.7999992370605px;"> using your preferred text editor. Make the changes suggested below (or you can use your settings as per your requirements).</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">listen-on port 53 { 127.0.0.1; any; };
allow-query     { localhost; any; };
allow-query-cache       { localhost; any; };</span></span></pre>
<div>
<div style="background-color: white; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin-bottom: 1em; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;">These directives instruct the DNS server to listen on <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">UDP</span> port <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">53</span>, and to allow queries and caches responses from <span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">localhost</span> and any other machine that reaches the server.</span></div>
<div style="background-color: white; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin-bottom: 1em; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">4.</span> It is important to note that the ownership of this file must be set to <code style="background-attachment: scroll; background-clip: initial; background-color: #f6f6f8; 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: 3px; border: 1px solid rgb(158, 158, 159); font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 600; line-height: 1.6; margin: 0px; max-width: 100%; overflow: auto; padding: 2px; vertical-align: baseline; white-space: pre;">root:named</code> and also if<span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">SELinux</span> is enabled, after editing the configuration file we need to make sure that its context is set to<code style="background-attachment: scroll; background-clip: initial; background-color: #f6f6f8; 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: 3px; border: 1px solid rgb(158, 158, 159); font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 600; line-height: 1.6; margin: 0px; max-width: 100%; overflow: auto; padding: 2px; vertical-align: baseline; white-space: pre;">named_conf_t</code> as shown in Fig. 4 (same thing for the auxiliary file <code style="background-attachment: scroll; background-clip: initial; background-color: #f6f6f8; 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: 3px; border: 1px solid rgb(158, 158, 159); font-stretch: inherit; font-style: inherit; font-variant: inherit; font-weight: 600; line-height: 1.6; margin: 0px; max-width: 100%; overflow: auto; padding: 2px; vertical-align: baseline; white-space: pre;">/etc/named.rfc1912.zones</code>):</span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># ls -lZ /etc/named.conf
# ls -lZ /etc/named.rfc1912.zones</span></span></pre>
</div>
<div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="line-height: 28.7999992370605px;"><span style="font-family: "arial" , "helvetica" , sans-serif;">Otherwise, configure the SELinux context before proceeding:</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># semanage fcontext -a -t named_conf_t /etc/named.conf
# semanage fcontext -a -t named_conf_t /etc/named.rfc1912.zones</span></span></pre>
</div>
<div>
<span style="color: white;"><span style="line-height: 15.6000003814697px;"><br /></span></span></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">5.</span><span style="line-height: 28.7999992370605px;"> Additionally, we need to test the DNS configuration now for some syntax error before starting the bind service:</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># named-checkconf /etc/named.conf</span></span></pre>
<div>
<span style="color: white;"><span style="line-height: 15.6000003814697px;"><br /></span></span></div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">6.</span><span style="line-height: 28.7999992370605px;"> After the syntax verification results seems perfect, restart the </span><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">named</span><span style="line-height: 28.7999992370605px;"> service to take new changes into effect and also make the service to auto start across system boots, and then check its status:</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># systemctl restart named
# systemctl enable named
# systemctl status named</span></span></pre>
<div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">7.</span><span style="line-height: 28.7999992370605px;"> Next, open the port 53 on the firewall.</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># firewall-cmd --add-port=53/udp
# firewall-cmd --add-port=53/udp --permanent</span></span></pre>
</div>
<div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="color: #0b5394; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 18px;">Step 3: Chroot Cache-Only DNS Server in RHEL and CentOS 7</span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">8.</span><span style="line-height: 28.7999992370605px;"> If you wish to deploy the Cache-only DNS server within </span><span style="border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">chroot</span><span style="line-height: 28.7999992370605px;"> environment, you need to have the package </span><span style="border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">chroot</span><span style="line-height: 28.7999992370605px;"> installed on the system and no further configuration is needed as it by default hard-link to chroot.</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># yum install bind-chroot -y</span></span></pre>
</div>
<div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="line-height: 28.7999992370605px;">Once </span><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">chroot</span><span style="line-height: 28.7999992370605px;"> package has been installed, you can restart named to take the new changes into effect:</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># systemctl restart named</span></span></pre>
</div>
<div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">9.</span><span style="line-height: 28.7999992370605px;"> Next, create a symbolic link (also named </span><code style="background-attachment: scroll; background-clip: initial; background-color: #f6f6f8; 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: 3px; border: 1px solid rgb(158, 158, 159); font-stretch: inherit; font-weight: 600; line-height: 1.6; margin: 0px; max-width: 100%; overflow: auto; padding: 2px; vertical-align: baseline; white-space: pre;">/etc/named.conf</code><span style="line-height: 28.7999992370605px;">) inside </span><code style="background-attachment: scroll; background-clip: initial; background-color: #f6f6f8; 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: 3px; border: 1px solid rgb(158, 158, 159); font-stretch: inherit; font-weight: 600; line-height: 1.6; margin: 0px; max-width: 100%; overflow: auto; padding: 2px; vertical-align: baseline; white-space: pre;">/var/named/chroot/etc/</code><span style="line-height: 28.7999992370605px;">:</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># ln -s /etc/named.conf /var/named/chroot/etc/named.conf</span></span></pre>
</div>
<div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="color: #0b5394; font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 18px;">Step 4: Configure DNS on Client Machine</span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">10.</span><span style="line-height: 28.7999992370605px;"> Add the DNS Cache servers </span><span style="border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">IP 192.168.0.18</span><span style="line-height: 28.7999992370605px;"> as resolver to the client machine. Edit</span><code style="background: none 0px 0px repeat scroll rgb(246, 246, 248); border-radius: 3px; border: 1px solid rgb(158, 158, 159); font-stretch: inherit; font-weight: 600; line-height: 1.6; margin: 0px; max-width: 100%; overflow: auto; padding: 2px; vertical-align: baseline; white-space: pre;">/etc/sysconfig/network-scripts/ifcfg-eth0</code><span style="line-height: 28.7999992370605px;"> as shown in the following figure:</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">DNS=192.168.1.17</span></span></pre>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">HWADDR=00:1A:4D:9A:F7:CE
TYPE=Ethernet
BOOTPROTO=static
IPADDR=192.168.1.35
NETMASK=255.255.255.0
GATEWAY=192.168.1.1
NM_CONTROLLED=no
DEFROUTE=yes
PEERDNS=yes
IPV4_FAILURE_FATAL=no
IPV6INIT=yes
IPV6_AUTOCONF=yes
IPV6_DEFFROUTE=yes
IPV6_PEERDNS=yes
IPV6_PEEROUTER=yes
IPV6_FAILURE_FATAL=no
NAME=eth0
DNS=192.168.1.17
ONBOOT=yes</span></span></pre>
</div>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 1.5em; margin-bottom: 10px;">
<span style="color: #272727; font-family: "roboto condensed" , "arial" , sans-serif; line-height: 28.7999992370605px;">And </span><span style="border: 0px; font-family: "roboto condensed" , "arial" , sans-serif; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">/etc/resolv.conf</span><span style="color: #272727; font-family: "roboto condensed" , "arial" , sans-serif; line-height: 28.7999992370605px;"> as follows:</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">nameserver 192.168.1.17</span></span></pre>
</div>
<div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin-bottom: 1em; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">11.</span> Finally it’s time to check our cache server. To do this, you can use dig utility or nslookup command.</span></div>
<div style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin-bottom: 1em; padding: 0px; vertical-align: baseline;">
<span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 28.7999992370605px;">Choose any website and query it twice (we will use</span><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 28.7999992370605px;"> </span><span style="border: 0px; font-family: "arial" , "helvetica" , sans-serif; font-stretch: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; margin: 0px; padding: 0px; vertical-align: baseline;">facebook.com</span><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 28.7999992370605px;"> </span><span style="font-family: "arial" , "helvetica" , sans-serif; line-height: 28.7999992370605px;">as an example). Note that with dig the second time the query is completed much faster because it is being served from the cache.</span></div>
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">root@hackthesec:/home/hackthesec# dig facebook.com

; <<>> DiG 9.9.5-9-Ubuntu <<>> facebook.com
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 50459
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1

;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 4096
;; QUESTION SECTION:
;facebook.com.   IN A

;; ANSWER SECTION:
facebook.com.  285 IN A 66.220.158.68

;; Query time: 65 msec
;; SERVER:192.168.1.17#53(</span></span><span style="color: white; font-size: 12px; line-height: 15.6000003814697px;">192.168.1.17</span><span style="color: white; font-size: 12px; line-height: 15.6000003814697px;">)</span>
<span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">;; WHEN: Mon Jan 25 16:59:32 IST 2016
;; MSG SIZE  rcvd: 57</span></span>
</pre>
</div>
<div>
<br /></div>
<div>
<div style="background-color: white; line-height: 1.5em; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="line-height: 28.7999992370605px;">You can also use </span><span style="border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border: 0px; font-stretch: inherit; line-height: 28.7999992370605px; margin: 0px; padding: 0px; vertical-align: baseline;">nslookup</span><span style="line-height: 28.7999992370605px;"> to verify that the DNS server is working as expected.</span></span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;">[root@node1 ~]# nslookup facebook.com
Server:         192.168.1.17
Address:        192.168.1.17#53

Non-authoritative answer:
Name:  facebook.com
Address: 66.220.158.68</span></span></pre>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"><pre style="background-attachment: scroll; background-clip: initial; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); font-size: 0.9em; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><a href="http://www.hackthesec.co.in/" target="_blank">http://www.hackthesec.co.in</a>
<a href="http://www.twitter.com/hackthesecurity" target="_blank">http://www.twitter.com/hackthesecurity</a>
<span style="color: #999999;"><a href="https://www.facebook.com/htsecu">https://www.facebook.com/htsecu</a></span></pre>
</span></span></pre>
</div>
<div>
<div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 1.5em; margin-bottom: 10px;">
<br /></div>
</div>
</div>

Install and Configure Caching-Only DNS Server in RHEL/CentOS 7

Install and Configure Caching-Only DNS Server in RHEL/CentOS 7 DNS servers comes in several types such as master, slave, forwarding and cache, to name a few examples, with cache-only DNS being the on…

26 Jan 2016

How do I Install and Use Iptables on CentOS/RHEL 7

<div dir="ltr" style="text-align: left;" trbidi="on">
<h2 class="title single-title title20" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #990000;">How do I Install and Use Iptables on CentOS/RHEL 7</span></h2>
<div>
<br /></div>
<div style="text-align: left;">
<span style="font-family: "verdana" , sans-serif;"><span style="background-color: white; line-height: 28px;">Latest Linux operating systems like CentOS/RedHat 7 and Fedora 21 has stop using iptables and start now using dynamic firewall daemon firewalld which provides a dynamically managed firewall. It supports for network and zones to assign a level of trust to a network, connections and interfaces. Firewalld also provides and interface for services or applications to add firewall rules directly. This article will help you to disable firewalld service and then install and use iptables on CentOS and Red Hat 7 Systems. </span><a href="https://fedoraproject.org/wiki/FirewallD" style="background-color: white; line-height: 28px; outline: none; text-decoration: none;" target="_blank">Visit here</a><span style="background-color: white; line-height: 28px;"> to read more about firewallD.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnwJqO5t-cjYlTKJwDUOWpBE6hpcStrXARypGodCji4qUFUgtg2ocsVUHZGm_VaZJARKMRjmnlgIDhOUHWEO5wTG0-oclNxRCZpvAiHMjuATmAULsaXKwqEUTKSxNrB7g385tyZmzbc_ZT/s1600/firewall_www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgnwJqO5t-cjYlTKJwDUOWpBE6hpcStrXARypGodCji4qUFUgtg2ocsVUHZGm_VaZJARKMRjmnlgIDhOUHWEO5wTG0-oclNxRCZpvAiHMjuATmAULsaXKwqEUTKSxNrB7g385tyZmzbc_ZT/s1600/firewall_www.hackthesec.co.in.jpg" /></a></div>
<div>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><span style="background-color: white; line-height: 28px;"><br /></span></span></div>
<div>
<h2 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Disable Firewalld Service</span></h2>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "verdana" , sans-serif;">Before installing and using iptables services on CentOS and Red Hat 7 systems, we need to disable firewalld service. To completely disable firewalld service use following commands.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># systemctl <orange style="color: orange;">stop</orange> firewalld
# systemctl <orange style="color: orange;">mask</orange> firewalld<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "verdana" , sans-serif;">Now check firewalld status</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># <orange style="color: orange;">systemctl status firewalld</orange>

firewalld.service
   Loaded: masked (/dev/null)
   Active: inactive (dead) since Fri 2015-02-27 11:09:37 EST; 56s ago
 Main PID: 7411 (code=exited, status=0/SUCCESS)

Feb 27 11:02:18 svr10 systemd[1]: Started firewalld - dynamic firewall daemon.
Feb 27 11:09:36 svr10 systemd[1]: Stopping firewalld - dynamic firewall daemon...
Feb 27 11:09:37 svr10 systemd[1]: Stopped firewalld - dynamic firewall daemon.<span style="font-size: 0.9em;">
</span></pre>
<h2 class="heading1" style="-webkit-transition: opacity 0.24s ease-in-out; background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;">
<span style="color: #0b5394;">Install Iptables Service in CentOS/RHEL 7</span></h2>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "verdana" , sans-serif;">Now install iptables service using yum package manager using following command.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># yum install iptables-services -y<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "verdana" , sans-serif;">After installing enable iptables service and start using below commands.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># systemctl <orange style="color: orange;">enable</orange> iptables
# systemctl <orange style="color: orange;">start</orange> iptables<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "verdana" , sans-serif;">Now check the iptables service status using below command.</span></div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"># <orange style="color: orange;">systemctl status iptables</orange>

iptables.service - IPv4 firewall with iptables
   Loaded: loaded (/usr/lib/systemd/system/iptables.service; enabled)
   Active: <green style="color: green;">active (exited)</green> since Fri 2015-02-27 11:14:12 EST; 14s ago
  Process: 7938 ExecStart=/usr/libexec/iptables/iptables.init start (code=exited, status=0/SUCCESS)
 Main PID: 7938 (code=exited, status=0/SUCCESS)

Feb 27 11:14:12 svr10 iptables.init[7938]: iptables: Applying firewall rules: [  OK  ]
Feb 27 11:14:12 svr10 systemd[1]: Started IPv4 firewall with iptables.<span style="font-size: 0.9em;">
</span></pre>
<div style="background-color: white; border: 0px; color: #555555; font-family: 'Roboto Slab'; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ2VipFy4QxSQUQ8Chyphenhyphenc_kXJDhqJ0gdaTbekB1BVNL7aDj-nzBVatnpVMwsEYzYU7Ws-tlMuavy5zeJaIQPpKuFWHpwhlP5-8YAG37KpxVpRwCckickkCcN0Hbdb5qpkpZWXHz0GN51ioZ/s1600/firewalld-vs-iptables_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZ2VipFy4QxSQUQ8Chyphenhyphenc_kXJDhqJ0gdaTbekB1BVNL7aDj-nzBVatnpVMwsEYzYU7Ws-tlMuavy5zeJaIQPpKuFWHpwhlP5-8YAG37KpxVpRwCckickkCcN0Hbdb5qpkpZWXHz0GN51ioZ/s640/firewalld-vs-iptables_www.hackthesec.co.in.png" width="640" /></a></div>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
<span style="font-family: "verdana" , sans-serif;">To list iptables rules use following command.</span></div>
<div style="background-color: white; border: 0px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<div style="border: 0px; color: #555555; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<div class="single-post-ad" style="border: 0px; clear: both; color: #555555; margin: 0px 0px 20px; outline: 0px; padding: 0px; vertical-align: baseline;">
</div>
<br />
<pre style="-webkit-text-stroke-width: 0px; background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.3em; margin: 0px 0px 20px; orphans: auto; outline: 0px; overflow: auto; padding: 20px; text-align: start; text-indent: 0px; text-transform: none; vertical-align: baseline; widows: 1; word-spacing: 0px;"># <orange style="color: orange;">iptables -L</orange>

Chain INPUT (policy ACCEPT)
target     prot opt source               destination
ACCEPT     all  --  anywhere             anywhere             state RELATED,ESTABLISHED
ACCEPT     icmp --  anywhere             anywhere
ACCEPT     all  --  anywhere             anywhere
ACCEPT     tcp  --  anywhere             anywhere             state NEW tcp dpt:ssh
REJECT     all  --  anywhere             anywhere             reject-with icmp-host-prohibited

Chain FORWARD (policy ACCEPT)
target     prot opt source               destination
REJECT     all  --  anywhere             anywhere             reject-with icmp-host-prohibited

Chain OUTPUT (policy ACCEPT)
target     prot opt source               destination<span style="font-size: 0.9em;">
</span></pre>
<pre style="-webkit-text-stroke-width: 0px; background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; font-size: 0.9em; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: 1.3em; margin: 0px 0px 20px; orphans: auto; outline: 0px; overflow: auto; padding: 20px; text-align: start; text-indent: 0px; text-transform: none; vertical-align: baseline; widows: 1; word-spacing: 0px;"><a href="http://www.hackthesec.co.in/">http://www.hackthesec.co.in</a>
<a href="http://www.twitter.com/hackthesecurity">http://www.twitter.com/hackthesecurity</a>
<a href="https://www.facebook.com/htsecu">https://www.facebook.com/htsecu</a>
</pre>
</div>
</div>

How do I Install and Use Iptables on CentOS/RHEL 7

How do I Install and Use Iptables on CentOS/RHEL 7 Latest Linux operating systems like CentOS/RedHat 7 and Fedora 21 has stop using iptables and start now using dynamic firewall daemon firewalld whic…

26 Jan 2016

MySQL Replication in 5 Minutes

<div dir="ltr" style="text-align: left;" trbidi="on">
<span style="color: #990000; font-family: "verdana" , sans-serif; font-size: x-large;">MySQL Replication in 5 Minutes</span><br />
<span style="font-family: "verdana" , sans-serif; font-size: x-large;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">Configure MySQL replication is extremely simple. This article demonstrates how to create a master in minutes replicating it for a slave. Replication is a native MySQL feature and has multiple uses, such as backup, high availability, redundancy and geographical data distribution, horizontal scalability, among others.</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s1600/mysq-linux-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s1600/mysq-linux-www.hackthesec.co.in.jpg" /></a></div>
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;"><br /></span></span>
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">For this simple test, we use Linux and configure replication in MySQL 5.6 between two instances: a master and a slave. We will create two instances MySQL from scratch, that is, without data. They will be on the same machine, but responding in different ports: 3310 and 3311.</span></span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;"><br /></span></span>
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">The only requirement is to have MySQL 5.6 installed.</span></span><br />
<br />
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium; line-height: 23.1000003814697px;">If you have it installed, simply use the path where resides bin/mysqld as basedir in the steps below. For example, in Oracle Linux 7 or RHEL 7 the binary is located in </span><b style="font-family: arial, helvetica, sans-serif; font-size: large; line-height: 23.1000003814697px;"><span style="color: red;">/usr/sbin/mysqld</span></b><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium; line-height: 23.1000003814697px;">, therefore</span><b style="font-family: arial, helvetica, sans-serif; font-size: large; line-height: 23.1000003814697px;"> <span style="color: red;">basedir=/usr;</span></b></li>
</ul>
<br />
<br />
<ul style="text-align: left;">
<li><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium; line-height: 23.1000003814697px;"> If you do not have MySQL 5.6 binaries, just download the tar file and unpack it in a convenient directory that will be your basedir, such as</span><b style="font-family: arial, helvetica, sans-serif; font-size: large; line-height: 23.1000003814697px;"> <span style="color: red;">/opt/mysql/mysql-5.6</span></b><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium; line-height: 23.1000003814697px;"><span style="color: red;">:</span></span></li>
</ul>
<br />
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># mkdir /opt/mysql
# cd /opt/mysql
# wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
# tar xvzf mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
# rm mysql-5.6.23-linux-glibc2.5-x86_64.tar.gz
# mv mysql-5.6.23-linux-glibc2.5-x86_64 mysql-5.6</span></span></pre>
<div style="background-color: white; margin-bottom: 10px;">
<span style="background-color: transparent; line-height: 18px;"><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;">Note: In this case, consider the steps below <b><span style="color: red;">basedir=/opt/mysql/mysql-5.6;</span></b> always try to work with the latest versions — replace 5.6.23 in the above commands if a brand new one is available in <b><span style="color: red;">http://dev.mysql.com/downloads/mysql.</span></b></span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="background-color: transparent;"></span><br />
<div style="font-family: arial, helvetica, sans-serif; font-size: large; font-weight: bold; line-height: 18px; margin-bottom: 10px;">
<span style="background-color: transparent;"><span style="color: #0b5394;"><u>Simple replication</u></span></span></div>
<span style="background-color: transparent;">
<div style="margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">Create an instance for the master:</span></span></div>
<div style="margin-bottom: 10px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6000003814697px;"># mkdir /opt/mysql/master /opt/mysql/master/data /opt/mysql/master/tmp
# cd /opt/mysql/master
# nano master.cnf
[client]
port=3310
socket=/opt/mysql/master/tmp/my-master.sock
[mysql]
prompt=master>\\_
[mysqld]
server-id=10
port=3310
basedir=/usr
datadir=/opt/mysql/master/data
socket=/opt/mysql/master/tmp/my-master.sock
log-bin=master-bin.log
innodb_flush_log_at_trx_commit=1
sync_binlog=1
# chown mysql:mysql *
# /usr/bin/mysql_install_db --defaults-file=/opt/mysql/master/master.cnf --user=mysql</span></span></pre>
</div>
</span></div>
<div style="background-color: white; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">Start and test the new instance:</span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
</div>
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># /usr/bin/mysqld_safe --defaults-file=/opt/mysql/master/master.cnf &
# mysql --defaults-file=/opt/mysql/master/master.cnf -uroot -p
master> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3310 |
+---------------+-------+</span></span></pre>
<div style="background-color: white; margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.0999984741211px;">Note: To stop the MySQL process when necessary, make a clean shutdown:</span></span></div>
<div style="background-color: white; margin-bottom: 10px;">
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 12px; line-height: 15.6000003814697px;"># mysqladmin --defaults-file=/opt/mysql/master/master.cnf -uroot –p shutdown</span></span></pre>
<div style="margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.0999984741211px;">Open another terminal and create another instance to be the Slave:</span></span></div>
<div style="margin-bottom: 10px;">
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 11.9999990463257px; line-height: 15.6000003814697px;"># mkdir /opt/mysql/slave /opt/mysql/slave/data /opt/mysql/slave/tmp
# cd /opt/mysql/slave
# nano slave.cnf
[client]
port=3311
socket=/opt/mysql/slave/tmp/my-slave.sock
[mysql]
prompt=slave>\\_
[mysqld]
server-id=11
port=3311
basedir=/usr
datadir=/opt/mysql/slave/data
socket=/opt/mysql/slave/tmp/my-slave.sock
log-bin=slave-bin.log
innodb_flush_log_at_trx_commit=1
sync_binlog=1
# chown mysql:mysql *
# /usr/bin/mysql_install_db --defaults-file=/opt/mysql/slave/slave.cnf --user=mysql
Start and test the new instance:
# /usr/bin/mysqld_safe --defaults-file=/opt/mysql/slave/slave.cnf &
# mysql --defaults-file=/opt/mysql/slave/slave.cnf -uroot -p
slave> SHOW VARIABLES LIKE 'port';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| port | 3311 |
+---------------+-------+</span></span></pre>
<div style="margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">Now that we have two instances with different server-ids and log-bin enabled, create a user in the master instance so the slave can connect to it:</span></span></div>
<div style="margin-bottom: 10px;">
<pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 11.9999990463257px; line-height: 15.6000003814697px;">master> CREATE USER repl_user@127.0.0.1;
master> GRANT REPLICATION SLAVE ON *.* TO repl_user@127.0.0.1 IDENTIFIED BY 'repl_user_password';</span></span></pre>
<div style="margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">Note: In an actual installation, the slave instance will probably be in another host — replace 127.0.0.1 with the host IP where your slave instance is.</span></span></div>
<div style="margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 23.1000003814697px;">Before starting replication, check the Master status:</span></span></div>
<div style="margin-bottom: 10px;">
<pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="font-size: 11.9999990463257px; line-height: 15.6000003814697px;">master> SHOW MASTER STATUS \G
*************************** 1. row ***************************
File: master-bin.000003
Position: 433</span></span></pre>
<div style="margin-bottom: 10px;">
<div style="margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 18px;">Use the data status above and initiates replication on the slave:</span></span></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: "verdana" , "geneva" , sans-serif;"><span style="font-size: 11.9999990463257px; line-height: 15.6000003814697px;">slave> CHANGE MASTER TO
MASTER_HOST=’127.0.0.1′,
MASTER_PORT=3310,
MASTER_USER=’repl_user’,
MASTER_PASSWORD=’repl_user_password’,
MASTER_LOG_FILE=’master-bin.000003′,
MASTER_LOG_POS=433;
slave> START SLAVE;</span></span></pre>
<div style="margin-bottom: 10px;">
<div style="margin-bottom: 10px;">
<span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium;"><span style="line-height: 18px;">Basic test</span></span><span style="font-family: "arial" , "helvetica" , sans-serif; font-size: medium; line-height: 1.5em;">:</span></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: "verdana" , "geneva" , sans-serif;"><span style="font-size: 11.9999990463257px; line-height: 15.6000003814697px;">master> CREATE DATABASE teste_repl;
master> CREATE TABLE teste_repl.simples (id INT NOT NULL PRIMARY KEY);
master> INSERT INTO teste_repl.simples VALUES (999),(1),(20),(5);
slave> SELECT * FROM teste_repl.simples;</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-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 11.9999990463257px; line-height: 15.6000003814697px;"><b>References:</b>
http://dev.mysql.com/doc/refman/5.6/en/binary-installation.html
http://dev.mysql.com/doc/refman/5.6/en/replication-howto.html

<a href="http://www.hackthesec.co.in/" target="_blank">HackTheSecurity</a>
<a href="https://www.twitter.com/hackthesecurity" target="_blank">HackTheSecurity Twitter</a>
<a href="https://www.facebook.com/htsecu/" target="_blank">HackTheSecurity Facebook</a></span></span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
</div>

MySQL Replication in 5 Minutes

MySQL Replication in 5 Minutes Configure MySQL replication is extremely simple. This article demonstrates how to create a master in minutes replicating it for a slave. Replication is a native MySQL f…

26 Jan 2016

Load more posts