Hack The Sec-Leading Resource Of Linux Tutorial

How to install Centos Web Panel(CWP)

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

How to install Centos Web Panel(CWP)

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

How To Install Perl Modules Manually and Using CPAN command

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

</strong>(or)

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

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

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

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

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

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

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

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

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

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

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

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

How To Install Perl Modules Manually and Using CPAN command

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

Upgrading to PostgreSQL 9.5 in Fedora 24

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

Upgrading to PostgreSQL 9.5 in Fedora 24

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

Executing MySQL Queries Directly From the Command Line

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

Executing MySQL Queries Directly From the Command Line

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

How to install and configure AutoMySQLBackup

<div dir="ltr" style="text-align: left;" trbidi="on">
<h1 class="entry-title" style="background-color: white; box-sizing: border-box; color: #333333; font-family: Lato, sans-serif; font-size: 36px; font-weight: 500; line-height: 1.1; margin: 20px 0px 10px;">
Install and configure AutoMySQLBackup</h1>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">AutoMySQLBackup is very useful utility for creating daily, weekly or monthly backups of one or more MySQL databases from one of more <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL </a>servers. It dumps the databases and compress them in to archives.</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><div style="font-size: 15px; line-height: 26px;">
it comes with many features such as:</div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOcRzNn6j_dutRU2TreKpBtsovpEF5kSOBkQM9_Nd44C3u4Nm_JmkrnDuUnn2zRVJYLuGKWeO6H1M_CRA9UCd5s4MfGqR-wf7NfdntcmY5pCGo3316kpVimXkp3PEbq0wkdZU4TIOrmH60/s1600/mysql.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="284" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhOcRzNn6j_dutRU2TreKpBtsovpEF5kSOBkQM9_Nd44C3u4Nm_JmkrnDuUnn2zRVJYLuGKWeO6H1M_CRA9UCd5s4MfGqR-wf7NfdntcmY5pCGo3316kpVimXkp3PEbq0wkdZU4TIOrmH60/s640/mysql.jpg" width="640" /></a></div>
<div style="font-size: 15px; line-height: 26px;">
<br /></div>
<div>
<ul style="font-size: 15px; line-height: 26px; text-align: left;">
<li>Email notification of backups</li>
<li>Backup Compression and Encryption</li>
<li>Configurable backup rotation</li>
<li>Incremental database backups</li>
</ul>
<div>
<span style="font-size: 15px; line-height: 26px;">For Debian based systems execute</span></div>
</div>
<div>
<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;">apt-get update && apt-get upgrade</pre>
</div>
</span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">For RPM based systems execute</span></span></div>
<div>
<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;">yum -y update</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you are running Debian based distro <a href="http://www.hackthesec.co.in/search/label/Mysql">AutoMySQLBackup</a> is available in the repositories and you can easily install it by executing the following</span></span></div>
<div>
<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;">apt-get install automysqlbackup</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you have a RPM based distro you will have to download AutoMySQLBackup’s installation scripts</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, "Courier New", monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">wget http://downloads.sourceforge.net/project/automysqlbackup/AutoMySQLBackup/AutoMySQLBackup%20VER%203.0/automysqlbackup-v3.0_rc6.tar.gz</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a directory for Automysqlbackup's scripts and unpack the downloaded tar archive</span></span></div>
<div>
<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;">mkdir /opt/automysqlbackup
tar zxvf automysqlbackup-v3.0_rc6.tar.gz -C /opt/automysqlbackup</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Once the archive is unpacked run the Automysqlbackup installation script</span></span></div>
<div>
<pre style="background: rgb(68, 68, 68); border-radius: 3px; border: 1px solid rgb(221, 221, 221); color: white; font-family: "Courier 10 Pitch", Courier, monospace; font-size: 15px; font-stretch: inherit; line-height: 19px; margin-bottom: 30px; margin-top: 30px; max-width: 100%; overflow-x: auto; overflow-y: hidden; padding: 18px 20px; vertical-align: baseline; word-wrap: normal;">cd /opt/automysqlbackup
./install.sh

### Checking archive files for existence, readability and integrity.

automysqlbackup ... exists and is readable ... md5sum okay :)
automysqlbackup.conf ... exists and is readable ... md5sum okay :)
README ... exists and is readable ... md5sum okay :)
LICENSE ... exists and is readable ... md5sum okay :)

Select the global configuration directory [/etc/automysqlbackup]:
Select directory for the executable [/usr/local/bin]:
### Creating global configuration directory /etc/automysqlbackup:

success</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
You can use the default paths for the global configuration directory and the directory for the executable. You just have to press Enter when the paths are required.</div>
<div>
<br /></div>
<div>
Next, we have to configure AutoMySQLBackup. Open its configuration file located in the directory we set when we ran the installation script.</div>
<div>
<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-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 /etc/automysqlbackup/automysqlbackup.conf</pre>
</div>
</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">And uncommend and set the following confituration directives</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, "Courier New", monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">CONFIG_mysql_dump_username='root'
CONFIG_mysql_dump_password='YourPassword'
CONFIG_mysql_dump_host='localhost'
CONFIG_backup_dir='/var/backup/db'
CONFIG_do_monthly="01"
CONFIG_do_weekly="5"
CONFIG_rotation_daily=6
CONFIG_rotation_weekly=35
CONFIG_rotation_monthly=150
CONFIG_mysql_dump_port=3306
CONFIG_mysql_dump_compression='gzip'</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div>
Once you are done with editing, save the configuration file. All settings are optional and there is description for all of them, so it is best to check the configuration file for more information about the settings of AutoMySQLBackup.</div>
<div>
<br /></div>
<div>
Create a directory for the MySQL backups. This is the directory we set as ‘backup_dir’ in the configuration file.</div>
<div>
<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-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;">mkdir /var/backup</pre>
</div>
</span></span></div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">If you want to create a backup of your MySQL databases, run AutoMySQLBackup by executing the following</span></span></div>
<div>
<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;">automysqlbackup</pre>
</div>
<div>
<span style="color: #333333; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">You can also create a crontab entry to run AutoMySQLBackup at a specific time or you can use bellow script</span></span></div>
<div>
<pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: Menlo, Monaco, Consolas, Courier New, monospace;"><span style="line-height: 18.5714px;">#!/bin/sh

/usr/local/bin/automysqlbackup /etc/automysqlbackup/automysqlbackup.conf

chown root.root /var/backup/db* -R
sudo chmod -R a-x+X /var/backup/db</span></span><span style="color: #333333; font-family: Menlo, Monaco, Consolas, "Courier New", monospace; font-size: 13px; line-height: 1.42857;">
</span></pre>
</div>
<div>
<br /></div>
<div>
<a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div>
</div>

How to install and configure AutoMySQLBackup

Install and configure AutoMySQLBackup AutoMySQLBackup is very useful utility for creating daily, weekly or monthly backups of one or mor...

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>