Hack The Sec-Leading Resource Of Linux Tutorial

How to replace MySQL with MariaDB in cpanel

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: large;"><b><u>Replace MySQL with MariaDB in cpanel</u></b></span></div>
<div style="text-align: center;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: large;"><b><u><br /></u></b></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><b><a href="http://www.hackthesec.co.in/search/label/cPanel">cPanel</a> </b>is a Linux-based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site.</span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQywZi06TXKZwFsQs3sass_IJeTf3TED7JAhV-aVU3Nobbr9RBdFFwz2EXi8X0XmllWQiIZ88mA5Rg_Qubwf7LOxE2b9cFJQQxL6Uy4qW_ujuMRZHWGugVEnVFgzLK3IpMg-5GACfKw_D/s1600/MySQL-to-MariaDB.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="273" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgBQywZi06TXKZwFsQs3sass_IJeTf3TED7JAhV-aVU3Nobbr9RBdFFwz2EXi8X0XmllWQiIZ88mA5Rg_Qubwf7LOxE2b9cFJQQxL6Uy4qW_ujuMRZHWGugVEnVFgzLK3IpMg-5GACfKw_D/s400/MySQL-to-MariaDB.jpg" width="400" /></a></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><a href="http://www.hackthesec.co.in/search/label/MariaDB"><b>MariaDB</b> </a>is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. It is notable for being led by the original developers of <b><a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a></b>, who forked it due to concerns over its acquisition by Oracle.</span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Make sure to save all existing data just in case there are any issues.</span></span></div>
<div style="clear: both; margin: 10px 0;">
<center>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle" data-ad-client="ca-pub-5744890361111211" data-ad-slot="1658755283" style="display: inline-block; height: 15px; width: 728px;"></ins></center>
</div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">cp -Rf /var/lib/mysql /var/lib/mysql-old
mv /etc/my.cnf /etc/my.cnf-old</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><u>Disable the targets so cPanel no longer handles MySQL updates</u></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;">The following will mark the versions of MySQL we distribute as uninstalled so they are no longer maintained by cPanel/WHM</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">/scripts/update_local_rpm_versions –edit target_settings.MySQL50 uninstalled
/scripts/update_local_rpm_versions –edit target_settings.MySQL51 uninstalled
/scripts/update_local_rpm_versions –edit target_settings.MySQL55 uninstalled</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><u>Remove existing MySQL RPM’s so theres a clean slate for MariaDB</u></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;">The below command will uninstall the MySQL RPM’s!</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">/scripts/check_cpanel_rpms –fix –targets=MySQL50,MySQL51,MySQL55</span></span></pre>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Create a yum repository for MariaDB</span></span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">vi /etc/yum.repos.d/MariaDB.repo</span></span></pre>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Place the following inside of it depending on the DISTRO or you can download the repo details from this bellow link - </span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">(https://downloads.mariadb.org/mariadb/repositories/):</span></span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5.29/centos6-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1</span></span></pre>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Remove php from the /etc/yum.conf file then run the following commands</span></span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">yum install MariaDB-server MariaDB-client MariaDB-devel
/etc/init.d/mysql start
mysql_upgrade
/etc/init.d/mysql restart</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Add php back to the /etc/yum.conf file to ensure future php updates don't get clobbered</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;">Rebuild easyapache/php to ensure modules are intact/working</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">/scripts/easyapache –build</span></span></pre>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">#hackthesec,#cPanel</span></div>
</div>

How to replace MySQL with MariaDB in cpanel

Replace MySQL with MariaDB in cpanel cPanel is a Linux-based web hosting control panel that provides a graphical interface and automa...

How to Install cockpit on Ubuntu 16.04

<div dir="ltr" style="text-align: left;" trbidi="on">
<div style="text-align: center;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: large;"><u><b>Install cockpit on Ubuntu 16.04</b></u></span></div>
<div style="text-align: center;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: large;"><u><b><br /></b></u></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Cockpit. A remote manager for GNU/Linux servers. Cockpit is a server manager that makes it easy to administer your GNU/Linux servers via a web browser.</span></span></div>
<div style="text-align: left;">
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span></div>
<div style="text-align: left;">
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">Cockpit helps make linux system administrator, system maintainers and DevOps easy to manage their server and to perform simple tasks, such as administering storage, inspecting journals, starting and stopping services and more. </span></span></div>
<div style="text-align: left;">
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><br /></span></span></div>
<div style="text-align: left;">
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">You can monitor and administer several servers at the same time. Just add them with a single click and your machines will look after its buddies.</span></span></div>
<div style="text-align: left;">
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><br /></span></span></div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><b><u>MY LAB SETUP</u></b></span></span><br />
<div style="clear: both; margin: 10px 0;">
<center>
<script async="" src="//pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script>

<ins class="adsbygoogle" data-ad-client="ca-pub-5744890361111211" data-ad-slot="1658755283" style="display: inline-block; height: 15px; width: 728px;"></ins></center>
</div>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">operating system – Ubuntu 16.04 server</span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="background-color: white; font-size: 15px;"></span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">IP Address – 172.17.56.101/24 also i am using my aws live domain name</span></span><br />
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">sudo add-apt-repository ppa:cockpit-project/cockpit</span></span></pre>
<div style="text-align: left;">
<span style="background-color: white;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">After adding the repository execute the bellow command from your terminal</span></span></span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">sudo apt-get update</span></span></pre>
<div style="text-align: left;">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;">After completed the update process run the bellow command for install the cockpit</span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">sudo apt-get install cockpit</span></span></pre>
<div style="text-align: left;">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;">After complete installation just start and enable the service through bellow commands</span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif; font-size: 14px;">systemctl start cockpit.socket
systemctl enable cockpit.socket</span><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px; white-space: normal;">
</span></span></pre>
<div style="text-align: left;">
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">Cockpit by default runs on port 9090,therefore if firewall is enabled,allow the port by executing the following command:</span></span></div>
<pre style="background: rgb(68, 67, 65); border-radius: 6px; border: 1px solid rgb(227, 227, 227); box-sizing: border-box; clear: none !important; margin-bottom: 10px !important; margin-top: 10px !important; overflow: auto; padding: 10px !important; width: auto !important; word-break: break-all;"><span style="color: white; font-family: monospace , serif;"><span style="font-size: 14px;">ufw allow 9090/tcp</span></span></pre>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">Now go to your browser and log on using your hostname or IP address in the format similar to one below:</span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;"><br /></span></span>
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="background-color: white; font-size: 15px;"></span></span><br />
<span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;"><span style="font-size: 15px;">https://<ip address>:9090 or https://<hostname>:9090</span></span><br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDC498P18R1533axnTLmAa0J2pWTHVazF_cPrCr_jLdEeiNXZ07-WGNXiSV4DMSIz7-MZc0qs7na0qkeOfCD8JPz5QwfC08iWVfAlym2V37WyubSlhBRrY8zqislUd56zYhFBOuFm1ubm6/s1600/cockpit_login.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDC498P18R1533axnTLmAa0J2pWTHVazF_cPrCr_jLdEeiNXZ07-WGNXiSV4DMSIz7-MZc0qs7na0qkeOfCD8JPz5QwfC08iWVfAlym2V37WyubSlhBRrY8zqislUd56zYhFBOuFm1ubm6/s1600/cockpit_login.png" /></a></div>
<div style="text-align: left;">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;"><br /></span></div>
<div style="text-align: left;">
<span style="background-color: white; font-size: 15px;"><span style="color: #333333; font-family: "verdana" , "geneva" , sans-serif;">Now, we'll be asked to enter the login details in order to enter into the dashboard. Here, the username and password is the same as that of the login details we use to login to our linux server. After we enter the login details and click on Log In button, we will be welcomed into the Cockpit Dashboard.</span></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQvJUc8HFWApb6PyNDUy3-GnmULOEj-G9ovR-5eXqApzkBDsKoiyvUYHR-0n2ZcJ6lNeEAq0Z6FWc4Mci96wOqAXdjDyQuDyD9ByS-7RXhWFGtaUJYVDnHmszTGyS641dlJtUlZGEkFrE2/s1600/cockpit.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhQvJUc8HFWApb6PyNDUy3-GnmULOEj-G9ovR-5eXqApzkBDsKoiyvUYHR-0n2ZcJ6lNeEAq0Z6FWc4Mci96wOqAXdjDyQuDyD9ByS-7RXhWFGtaUJYVDnHmszTGyS641dlJtUlZGEkFrE2/s1600/cockpit.png" /></a></div>
<div style="text-align: left;">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;"><br /></span></div>
<div style="text-align: left;">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;"><br /></span></div>
<div style="text-align: left;">
<span style="background-color: white; color: #333333; font-family: "verdana" , "geneva" , sans-serif; font-size: 15px;">www.hackthesec.co.in</span></div>
<div style="text-align: left;">
<br /></div>
</div>