Hack The Sec-Leading Resource Of Linux Tutorial

How to Disable MySQL Strict Mode

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline">
<u><span style="color: red;">How to Disable MySQL Strict Mode</span></u><span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /><a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a>'s, and <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB</a>'s, strict mode controls how invalid or missing values in data changing queries are handled; this includes INSERT, UPDATE, and CREATE TABLE statements. With strict mode enabled, which is the default state, invalid or missing data may cause warnings or errors when attempting to process the query.</span></span></span></h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk_GBnDAlvdhClBCGn5NtcSwdsMn5A1x2i8f5oTuZxiuKjHCzo_hAGQjp6a4qijIkrZP1hprkgjGxIN_HHx6yIN-CcLPMMGAHksZxBQ_g3eQwIF5Me92JDdOfyRSj2TD_-7r-HbpwB9r7e/s1600/mysql-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjk_GBnDAlvdhClBCGn5NtcSwdsMn5A1x2i8f5oTuZxiuKjHCzo_hAGQjp6a4qijIkrZP1hprkgjGxIN_HHx6yIN-CcLPMMGAHksZxBQ_g3eQwIF5Me92JDdOfyRSj2TD_-7r-HbpwB9r7e/s1600/mysql-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">When strict mode is disabled the same query would have its invalid, or missing, values adjusted and would produce a simple warning. This may seem like the preferred result, however with strict mode disabled certain actions may cause unexpected results; for instance, if the value being inserted exceeds the maximum character limit, then it will be truncated to fit the limit.<br /><span style="color: #0b5394;"><u><b>Make Backups, Always!</b></u></span><br />Whenever modifying files on a server it’s always best practice to take some form of a backup beforehand. This ensures you have a way to revert changes if something goes awry; it’s also beneficial because it helps track when and what changes were made.<br /><br />While logged into SSH with the root user, do the following:</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">cp -a /usr/my.cnf{,.strict.bak}
cp -a /etc/my.cnf{,.strict.bak}</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;">Note: The above command uses <span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>BASH brace expansion<span style="font-family: "verdana" , "geneva" , sans-serif;">'</span> in order to make a backup copy of the file in its original directory.<br /><span style="color: #0b5394;"><u><b>Edit the Configuration Files</b></u></span><br />Depending on the server and the current configurations you may need to edit one, or both, of the following files on the server. Generally, the relevant configuration lines are only in one of them, however, it could be in either one without causing issues; so generally it’s best to check both.<br /><br />To edit the files, you will open the file with your favorite command line editor. In this example, we use <span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>vim<span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>.</span></span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">vim /usr/my.cnf
vim /etc/my.cnf</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;">Within each file above you will be looking for a line with the following content:</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES</pre>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3idFl4fPIUSFLmSTgboyPHtduc7tRU8cGfGlJ9TqV6hYt86Wi_p2XC0jz_DrTkVfFnr0Qy98kEyhac-pkT1kgclbo3H_KzUYG0UqEiV97z6HrbyN3PLM-azS2AJIlW7fDLXgYfZp6rZVJ/s1600/sql_mode-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3idFl4fPIUSFLmSTgboyPHtduc7tRU8cGfGlJ9TqV6hYt86Wi_p2XC0jz_DrTkVfFnr0Qy98kEyhac-pkT1kgclbo3H_KzUYG0UqEiV97z6HrbyN3PLM-azS2AJIlW7fDLXgYfZp6rZVJ/s1600/sql_mode-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;">If you find a line similar to the above that is setting the <span style="font-family: "verdana" , "geneva" , sans-serif;">"</span>sql_mode<span style="font-family: "verdana" , "geneva" , sans-serif;">"</span> variable then you will need to replace it with the following line to disable MySQL strict mode.</span></span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">sql_mode=""</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">Once this adjustment has been made, or you<span style="font-family: "verdana" , "geneva" , sans-serif;">'</span>ve confirmed the file does not need to be adjusted you will then save and close the file.<br /><span style="color: #0b5394;"><u><b>Restart the MySQL Service</b></u></span><br />Finally, to make these changes effective you will need to restart the MySQL service as it will only read the configuration files when it initially loads up. In order to force MySQL to use the new configuration files you will do the following:</span></span></span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">systemctl restart mysql

/etc/init.d/mysql restart</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">After issuing this command on the server the MySQL service will be restarted and will load the changes made. If all the directions were followed and completed, then MySQL strict mode should now be disabled.<br /><br />To verify that the process was completed properly you can run the following:</span></span></span></span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">mysql -e "SELECT @@sql_mode;"</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">The output may look similar to the following:</span></span></span></span></span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">+--------------------------------------------+
| @@sql_mode
+--------------------------------------------+
| NO_AUTO_CREATE_USER
+--------------------------------------------+</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;"><span style="font-family: "verdana" , "geneva" , sans-serif;">If you have any questions or are not comfortable making these changes yourself, please feel free to contact admin@hackthesec.co.in<br /><br /><span style="font-family: "verdana" , "geneva" , sans-serif;">Thanks & Regards</span><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></span></span></span></span></span></span></h1>
</div>

How to Disable MySQL Strict Mode

How to Disable MySQL Strict Mode MySQL 's, and MariaDB 's, strict mode controls how invalid or missing values in data changing que...

How To setup Cassandra and run a Single-Node Cluster on Ubuntu 16.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" itemprop="headline">
<span style="color: red;"><span style="font-size: large;"><u>Setup Cassandra and run a Single-Node Cluster</u></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Apache Cassandra is an open source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Cassandra offers capabilities that relational databases and other <a href="http://www.hackthesec.co.in/search/label/nosql_database">NoSQL</a> databases simply cannot match such as: continuous availability, linear scale performance, operational simplicity and easy data distribution across multiple data centers and cloud availability zones. Cassandra’s architecture is responsible for its ability to scale, perform, and offer continuous uptime. Rather than using a legacy master-slave or a manual and difficult-to-maintain shared architecture, Cassandra has a masterless "ring" design that is elegant, easy to setup, and easy to maintain.</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuVjo0yCqyiJYDZ7C3zEZhBre8U3ebJTdOMaEGkTPY8xT6Kv8b8yjWHHvT9JFO58TbS-NVd4V1cVXIWBfAhCUktnTwoJ8ZD3sMobafW29y5msMnar5jum7doypNYRuQd7e590BQgujc_g/s1600/UBUNTU-Cassandra-hackthesec.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGuVjo0yCqyiJYDZ7C3zEZhBre8U3ebJTdOMaEGkTPY8xT6Kv8b8yjWHHvT9JFO58TbS-NVd4V1cVXIWBfAhCUktnTwoJ8ZD3sMobafW29y5msMnar5jum7doypNYRuQd7e590BQgujc_g/s1600/UBUNTU-Cassandra-hackthesec.jpg" /></a><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span><br /><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Let’s see how we are going to install and use it to run a single-node cluster on Ubuntu 16.04.</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>System Update:</b></u><br />Update our system to latest updates and security patches available before installing other prerequisites and Cassandra, . You can run the command below to get the latest updates.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get update</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>Installing JDK 8:</b></u><br />Apache Cassandra is run on top of Java Virtual Machine (JVM). We’ll install Oracle JDK 8 on the system before we install Apache Cassandra. Apache Cassandra can also run on OpenJDK, IBM JVM and Azul Zing JVM.<br /><br />We will install Oracle JDK using the Webupd8 team team PPA repository. First step is to add the webupd8team ppa repository using below command.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo add-apt-repository ppa:webupd8team/java</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>Press [ENTER] to continue or ctrl-c to cancel adding it.</b><br />You need to press enter to continue adding the webupd8team PPA repository. Then update the package database and install JDK 8 by flowing below command.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get update</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5502r8sc_O6VBb4Mtn3ZJ4I7p4QLPUtAK0vhyphenhyphenywdwpXSRUDRZX6S7IG90GWnOyR37hadpD8PRv_BHgRSrVYaFDKG2LF1kiMn20smV2Cm8Sjx4hmW-eAA1XToEV03zS5XA5cEjI6y84hyphenhyphenw/s1600/1_jdk_hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5502r8sc_O6VBb4Mtn3ZJ4I7p4QLPUtAK0vhyphenhyphenywdwpXSRUDRZX6S7IG90GWnOyR37hadpD8PRv_BHgRSrVYaFDKG2LF1kiMn20smV2Cm8Sjx4hmW-eAA1XToEV03zS5XA5cEjI6y84hyphenhyphenw/s1600/1_jdk_hackthesec.co.in.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now install the Oracle JRE package, this will not only installs but also makes it the default JRE.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get -y install oracle-java8-installer</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Accept the license agreement when prompted.</span></span></span></h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN7qlJXe6WeThTLSMyp_s0DgN78ESHdOlqtpyO638GzbscgfvXPUZmHOqcpiiHwckmsY0dZc8H-IG64QkCcVxA9S3Ug7tXP74cksS6lY_urHDsJ1Rj6fgZud7uc1EkyTVDQz5F5Bv6AXPB/s1600/2_oracle-java_hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiN7qlJXe6WeThTLSMyp_s0DgN78ESHdOlqtpyO638GzbscgfvXPUZmHOqcpiiHwckmsY0dZc8H-IG64QkCcVxA9S3Ug7tXP74cksS6lY_urHDsJ1Rj6fgZud7uc1EkyTVDQz5F5Bv6AXPB/s1600/2_oracle-java_hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then accepting the Oracle Binary Code License Terms by Choosing <b>'Yes'</b> option</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaYmwVfnAewIyX5CCV0ULA9BAACrKvtgxC_n05K2kdfbUfY0c7UAR2eND-kRh3j16Ud_ymOS3y_F8UNPO1I6gqspazdKclDn1owd5uOBuGCtT8s1kJf2jZzfkOD1L-Lo4RNpLFTqmvhYTB/s1600/3_oracle-java-license-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhaYmwVfnAewIyX5CCV0ULA9BAACrKvtgxC_n05K2kdfbUfY0c7UAR2eND-kRh3j16Ud_ymOS3y_F8UNPO1I6gqspazdKclDn1owd5uOBuGCtT8s1kJf2jZzfkOD1L-Lo4RNpLFTqmvhYTB/s1600/3_oracle-java-license-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once installation of Java 8 complete, you can check the current java version by running command below.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;"><span style="color: #333333; font-family: menlo,monaco,consolas,courier new,monospace;"><span style="line-height: 25.7143px;">ubuntu@ubuntu-16:~$ java -version
java version "1.8.0_91"
Java(TM) SE Runtime Environment (build 1.8.0_91-b14)
Java HotSpot(TM) 64-Bit Server VM (build 25.91-b14, mixed mode)</span></span></span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="color: #0b5394;"><u><b>Installing Apache Cassandra:</b></u></span><br />No we can start installing Apache Cassandra ,from the official Apache Software Foundation repositories, so start by adding the repo so that the packages are available to the system by adding the repo's source.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ echo "deb-src http://www.apache.org/dist/cassandra/debian 37x main" | sudo tee -a /etc/apt/sources.list.d/cassandra.sources.list</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then add the following three public keys from the Apache Software Foundation associated with the package repositories to avoid package signature warnings.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;"><span style="color: #333333; font-family: menlo,monaco,consolas,courier new,monospace;"><span style="line-height: 25.7143px;">$ gpg --keyserver pgp.mit.edu --recv-keys F758CE318D77295D
$ gpg --export --armor F758CE318D77295D | sudo apt-key add -</span></span></span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"> Add the second key using below commands.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;">$ gpg --keyserver pgp.mit.edu --recv-keys 2B5C1B00
$ gpg --export --armor 2B5C1B00 | sudo apt-key add -</span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"> To add third keys run the below commands.</span></span></span></h1>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="font-size: large;">$ gpg --keyserver pgp.mit.edu --recv-keys 0353B12C
$ gpg --export --armor 0353B12C | sudo apt-key add -</span></pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After this once again update your system, so that ‘apt-get’ can read the metadata of Cassandra repository.</span></span></span></h1>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3hGspjUd9Xri5z63A2QubM_mUWwD6gnGDTL-OQBxqRbCdl5tQfedCQNAzSuFZqbLqrM1lN62IxrvN5fxmGBz2wO3R-22zbELDuXWC6P8cElYkNAY0wPWz_RKyZTKi0LKt-IzubCPUN5KO/s1600/4_cassandra-key-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg3hGspjUd9Xri5z63A2QubM_mUWwD6gnGDTL-OQBxqRbCdl5tQfedCQNAzSuFZqbLqrM1lN62IxrvN5fxmGBz2wO3R-22zbELDuXWC6P8cElYkNAY0wPWz_RKyZTKi0LKt-IzubCPUN5KO/s1600/4_cassandra-key-hackthesec.png" /></a></div>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After system updates, now let's install Cassandra 37x on your Ubuntu 14 LTS. This is the latest stable version of Cassandra.<br /><br />Run the below command to install Cassandra on your Ubuntu system and pres 'y' key to continue.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo apt-get install cassandra</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi0u8pMOf6hmOgE2WGHQ09aTnRiSLztt8YNodwAqHcEXSeowXYxx0Yziimtx1eCU_Tslhgeom1ab_ahyphenhyphen51FVo_ISZ4qqSExnISiSHrKFocUUrnJdse3Leg5G5e6iKF1khWOt65CuBEeVrL/s1600/5_intall-casandra-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhi0u8pMOf6hmOgE2WGHQ09aTnRiSLztt8YNodwAqHcEXSeowXYxx0Yziimtx1eCU_Tslhgeom1ab_ahyphenhyphen51FVo_ISZ4qqSExnISiSHrKFocUUrnJdse3Leg5G5e6iKF1khWOt65CuBEeVrL/s1600/5_intall-casandra-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>Starting Cassandra service:</b></u><br />Now Cassandra service should be up and running on your system.<br />To confirm that it’s not running, use below command to check its status.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo service cassandra status </pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you did not get the running status, then flow the command below in your command line terminal to start its service.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo service cassandra start</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><u><b>Connecting to the Cluster:</b></u><br />Once your Cassandra service is up and running , check the status of the cluster using below command.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ sudo nodetool status</pre>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">Datacenter: datacenter1
=======================
Status=Up/Down
|/ State=Normal/Leaving/Joining/Moving
--  Address    Load       Tokens       Owns (effective)  Host ID                               Rack
UN  127.0.0.1  103.01 KiB  256          100.0%            da43244b-b1f1-4426-9b24-9ea3cb31ecb4  rack1</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">In the output, UN means it’s Up and Normal. Then connect to it using its interactive command line interface 'cqlsh'. </span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">$ cqlsh</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimN4Xz-Zb5Dbe50ZVifnbY23F33OcRr4wVloCvsro6dEfJ_wVDjkC-nEhto86B9zDXWljsreAYaH6oa0uOUF4eyM5RvYzYQq86cS7YY1W50iYsXCJhJ_-eOw0osXlQtyZidnVe8HVSoD-n/s1600/6_connecting-cluster-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimN4Xz-Zb5Dbe50ZVifnbY23F33OcRr4wVloCvsro6dEfJ_wVDjkC-nEhto86B9zDXWljsreAYaH6oa0uOUF4eyM5RvYzYQq86cS7YY1W50iYsXCJhJ_-eOw0osXlQtyZidnVe8HVSoD-n/s1600/6_connecting-cluster-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><span style="color: #0b5394;"><u><b>Using Apache Cassandra:</b></u></span><br />Let’s try our Cassandra installation by creating a test database. First of all let’s create a keyspace, this is a namespace for tables. The keyspace name below is 'mydb'.</span></span></span></h1>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">cqlsh> CREATE KEYSPACE mydb WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }; 
cqlsh> use mydb;
cqlsh:moviedb> CREATE TABLE books (id int PRIMARY KEY, title text, year text);
cqlsh:mydb> DESC books;</pre>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgecD3JL1s54qhL49It7Y5ReBs5D2Qc8wHnx1x56buaavMfHFVIUutV1sWv72w3AlFlmhNcV_7KDODBkKy_6cyybwUSYcd3oaUSgeKmllVPJ5TqB62tMTlbcz-2_89xbbHOyVU2KsHhi5XO/s1600/7_using-cassandra-hackthesec.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgecD3JL1s54qhL49It7Y5ReBs5D2Qc8wHnx1x56buaavMfHFVIUutV1sWv72w3AlFlmhNcV_7KDODBkKy_6cyybwUSYcd3oaUSgeKmllVPJ5TqB62tMTlbcz-2_89xbbHOyVU2KsHhi5XO/s1600/7_using-cassandra-hackthesec.png" /></a></div>
</span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">The table is ready, now you can to add some data in it. </span></span></span></h1>
<h1 class="entry-title" itemprop="headline">
<span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Thanks & Regards<a href="http://www.hackthesec.co.in/"><br />www.hackthesec.co.in</a></span></span></span><br /><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span><span style="font-weight: normal;"></span><span style="font-weight: normal;"><span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"></span></span></span></h1>
</div>