How to install ProjectSend on CentOS 6

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" style="background-color: white; box-sizing: border-box; font-family: Lato, sans-serif; line-height: 1.1; margin: 20px 0px 10px; text-align: center;"> <span style="color: #990000; font-size: large;"><u>Install ProjectSend on CentOS</u></span></h1> <div> <div style="background-color: white;"> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b>ProjectSend</b> is a self-hosted application that lets you upload files and assign them to specific clients that you create yourself! Secure, private and easy. No more depending on external services or e-mail to send those files!</span></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWhDS__nMR1yNkpjMOQQzmd-IJqEuxdLk-fgWZM9sCXQZea4dTXGj7mZJq-nnrTUJnsy-OPp9K5CYbGCWORdq9_rZBpRRCAzr1ZWtynBvg8hnG1aUXSiyBEt_hq-hwq_K_orc2tUPZbDoS/s1600/projectsend_logo_www.hackthesec.co.in.gif" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjWhDS__nMR1yNkpjMOQQzmd-IJqEuxdLk-fgWZM9sCXQZea4dTXGj7mZJq-nnrTUJnsy-OPp9K5CYbGCWORdq9_rZBpRRCAzr1ZWtynBvg8hnG1aUXSiyBEt_hq-hwq_K_orc2tUPZbDoS/s1600/projectsend_logo_www.hackthesec.co.in.gif" /></a></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">ProjectSend is made in php and uses a <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL database</a> to store the information. Please see that your server has at least <a href="http://www.hackthesec.co.in/search/label/PHP">php</a> 5.2 and MySQL 5 or better to run the software. Apache 2 is recommended but PS should also work on IIS.</span></span></div> <div> <div style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> <b><u><span style="color: #0b5394;">Installation instructions:</span></u></b></div> <div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> Login to your server via <a href="http://www.hackthesec.co.in/search/label/SSH">SSH</a>:</div> <div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: black; line-height: normal; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="line-height: 15.6px;">ssh root@server_ip</span></span></pre> </div> <div style="font-family: verdana, geneva, sans-serif;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Update the OS packages and install necessary packages:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">sudo yum -y upgrade </span><span style="color: lime;">sudo yum install unzip wget</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Download and extract the ProjectSend archive to a directory on your server:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">wget https://github.com/ignacionelson/ProjectSend/archive/master.zip unzip master.zip </span><span style="color: lime;">mv ProjectSend-master /var/www/html/projectsend</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a new MySQL database for ProjectSend on your server:</span></span></div> <div> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">mysql -u root -p mysql> CREATE DATABASE projectsenddb; mysql> GRANT ALL PRIVILEGES ON projectsenddb.* TO 'projectsenduser'@'localhost' IDENTIFIED BY 'your-password' WITH GRANT OPTION; mysql> FLUSH PRIVILEGES; mysql> quit</pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Rename the '<b>sys.config.sample.php</b>' file to '<b>sys.config.php</b>':</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">cd /var/www/html/projectsend/includes </span><span style="color: lime;">mv sys.config.sample.php sys.config.php</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;">Open the ProjectSend configuration file with your favorite text editor and change the MySQL database name, MySQL username and password with the ones you used at the time of the database creation:</span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: orange; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">nano sys.config.php</span></span></pre> </div> <div style="font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">/** MySQL database name */ define('DB_NAME', 'projectsenddb'); /** Database host (in most cases it's localhost) */ define('DB_HOST', 'localhost'); /** MySQL username (must be assigned to the database) */ define('DB_USER', 'projectsenduser'); /** MySQL password */ define('DB_PASSWORD', 'your-password');</pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Create a new virtual host directive in Apache. For example, edit your Apache configuration file (/etc/httpd/conf/httpd.conf by default) and uncomment the following line:</span></span></div> <div> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">#NameVirtualHost *:80</pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then, add the following lines at the end:</span></span></div> <div> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;"><VirtualHost *:80> ServerAdmin admin@yourdomain.com DocumentRoot /var/www/html/projectsend/ ServerName yourdomain.com ServerAlias www.yourdomain.com <Directory /var/www/html/projectsend/> Options Indexes FollowSymLinks MultiViews AllowOverride All Order allow,deny allow from all </Directory> ErrorLog logs/yourdomain.com-error_log CustomLog logs/yourdomain.com-access_log common </VirtualHost></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Restart the Apache web service for the changes to take effect.</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;"><span style="color: white;">service </span><span style="color: cyan;">httpd restart</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Open your favorite web browser, navigate to http://yourdomain.com/ and follow the easy instructions.You will be welcomed by the ProjectSend installation page like the one below:</span></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoP0g9A4Q9qy8TWxMeeog1xDbiyApP6p3SnWk7jeI9WXYGv2NVG9Z-KbIFqeKLTPuWBbQdEGc_1HbN0G8epsXilKdu2UUtgcIKdRTisznnySlJZuKaWRdQrYeXmFLObYAYy2XQ5QY4yjfn/s1600/projectsend_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjoP0g9A4Q9qy8TWxMeeog1xDbiyApP6p3SnWk7jeI9WXYGv2NVG9Z-KbIFqeKLTPuWBbQdEGc_1HbN0G8epsXilKdu2UUtgcIKdRTisznnySlJZuKaWRdQrYeXmFLObYAYy2XQ5QY4yjfn/s1600/projectsend_www.hackthesec.co.in.png" /></a></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Fill in the following details:</span></span></div> <div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> <pre style="background-color: whitesmoke; border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-sizing: border-box; color: #333333; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: 13px; line-height: 1.42857; margin-bottom: 10px; overflow: auto; padding: 9.5px; word-break: break-all; word-wrap: break-word;">Sitename: It can be anything.(myproject.com) ProjectSend URL: your domain name or IP address of the server.</pre> </div> <div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Then, enter your personal details and log in credentials: name, e-mail address, administrator username and password and click 'Install'.</span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">That is it. The ProjectSend installation is now complete. Now you can log in and create new users, create groups, upload files from the ProjectSend dashboard.</span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">For more information about ProjectSend, please refer to the <a href="http://www.projectsend.org/">ProjectSend </a>website.</span></span></div> </div> <div style="color: #222222; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"> <a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></div> </div> </div> </div> </div>

How to install ProjectSend on CentOS 6

Install ProjectSend on CentOS ProjectSend is a self-hosted application that lets you upload files and assign them to specific clients...

Read more »

How To Retrieve or Reset the Root MySQL Password

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="color: #990000; font-size: large;"><u>Retrieve or Reset the Root MySQL Password</u></span></h1> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">MySQL AB was a software company that was founded in 1995. It was acquired by Sun Microsystems in 2008; Sun was in turn acquired by Oracle Corporation in 2010.</span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">This is a quick tutorial how to reset your <a href="http://www.hackthesec.co.in/search/label/Mysql_Database">MySQL</a> root password. It does require root access on your server. </span></span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5sGSkdiY6rimv0IB8iREbyy1vyE5VOacsLnlh5LPLdoInHSPOaxVR6h0TApVBc3Zh5ovP0Cfr-XsJn1tFthuOYMnwyYupGoPn3zjvrfrowqAwqbs32Qj4qTAIiFnKjAM7v6E7TLETS7el/s1600/reset-mysql-root-password-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5sGSkdiY6rimv0IB8iREbyy1vyE5VOacsLnlh5LPLdoInHSPOaxVR6h0TApVBc3Zh5ovP0Cfr-XsJn1tFthuOYMnwyYupGoPn3zjvrfrowqAwqbs32Qj4qTAIiFnKjAM7v6E7TLETS7el/s1600/reset-mysql-root-password-www.hackthesec.co.in.jpg" /></a></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><br /></span></span></div> <div> <span style="color: #0b5394; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Step #1</u></b></span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Stop MySQL:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">service mysql stop</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #2</u></b></div> <div> <span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Start MySQL in single-user mode, bypassing password authorization, by pasting in the command below (the ampersand is required):</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">mysqld_safe --skip-grant-tables &</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #3</u></b></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now type "mysql" to connect:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">mysql</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #4</u></b></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">At the mysql prompt, change the root password using the following three commands:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">UPDATE mysql.user SET password=password("YourNewStrongPassword") WHERE user='root'; FLUSH PRIVILEGES; exit;</span></span></pre> </div> <div> <b style="color: #0b5394; font-family: verdana, geneva, sans-serif; font-size: 15px; line-height: 26px;"><u>Step #4</u></b></div> <div> <span style="font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Now stop MySQL and start it in normal mode:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">service mysql stop service mysql start</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div> <b style="color: #0b5394;"><u>Step #5</u></b></div> <div> Verify that you are able to connect to MySQL by entering "mysql".</div> </span></span><span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div> <b style="color: #0b5394;"><u>Step #6</u></b></div> <div> Finally, update the MySQL root password in<b> /etc/.my.cnf</b> to match the new value. You can use vi, vim or nano:</div> </span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">vi /root/.my.cnf</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><b><u>Recovering the Root MySQL Password on a cPanel server</u></b></span></span></div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">The root <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> credentials are stored locally in a file that only the root user can access. After you’ve connected to the server as root via <a href="http://www.hackthesec.co.in/search/label/SSH">SSH</a>, you can view the credentials by running the following command:</span></span></div> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-family: trebuchet ms, sans-serif;"><span style="font-size: 15px; line-height: 15.6px;">cat /root/.my.cnf</span></span></pre> </div> <div> <span style="color: #222222; font-family: verdana, geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">That should output a result containing the MySQL password, which will appear similar to the following:</span></span></div> <div> <pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; font-stretch: normal; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: menlo, monaco, consolas, courier new, monospace; font-size: large;"><span style="line-height: 18.5714px; white-space: pre-wrap;">[root@host ~]# cat /root/.my.cnf [client] password=#@hackthesec user=root</span></span></pre> <pre class="xtypo_info" style="background: url("assets/shadow.png") 50% 100% repeat-x rgb(245, 245, 245); border-radius: 4px; border: 1px solid rgb(204, 204, 204); box-shadow: rgb(204, 204, 204) 0px 0px 3px; box-sizing: border-box; font-stretch: normal; margin-bottom: 10px; overflow: auto; padding: 9.5px; tab-size: 4; text-shadow: rgb(255, 255, 255) 0px 1px 0px; word-break: break-all; word-wrap: break-word;"><span style="color: #333333; font-family: menlo, monaco, consolas, courier new, monospace;"><span style="font-size: 12px; line-height: 18.5714px; white-space: pre-wrap;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a> <a href="https://www.twitter.com/Hackthesecurity">https://www.twitter.com/Hackthesecurity</a> <a href="http://facebook.com/htsecu">http://facebook.com/htsecu</a> <a href="http://feeds.hackthesec.co.in/hackthesec">http://feeds.hackthesec.co.in/hackthesec</a></span></span></pre> </div> </div>

How To Retrieve or Reset the Root MySQL Password

Retrieve or Reset the Root MySQL Password MySQL AB was a software company that was founded in 1995. It was acquired by Sun Microsystems ...

Read more »

How to Install and Configure phpMyAdmin on Fedora 21

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-size: large;"><u>Install and Configure phpMyAdmin on Fedora</u></span></h1> <div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;"> <span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="color: #222222;"><b>phpMyAdmin </b>is a free and open source tool written in PHP intended to handle the administration of <span style="color: #999999;">MySQL</span> or <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB </a>with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions</span></span><span style="color: #222222; font-size: 15px; line-height: 26px;">.</span></div> <div class="separator" style="background-color: white; clear: both; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="color: #999999; margin-left: 1em; margin-right: 1em; text-decoration: none;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" style="border: 1px solid rgb(192, 192, 192); height: auto; max-width: 95%; padding: 4px; transition: all 0.4s ease-in-out;" /></a></div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;"> <span style="color: #222222; font-size: 15px; line-height: 26px;"><br /></span></div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;"> <span style="color: #0b5394; font-family: 'Trebuchet MS', sans-serif; font-size: medium;"><span style="line-height: 26px;"><b><u>Features</u></b></span></span></div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;"> <ul style="font-size: 12px;"> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Web interface</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">MySQL and MariaDB database management</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Import data from CSV and SQL</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Export data to various formats: CSV, <a href="http://www.hackthesec.co.in/search/label/sql" style="color: #999999; text-decoration: none;">SQL</a>, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Administering multiple servers</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Creating PDF graphics of the database layout</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Creating complex queries using Query-by-Example (QBE)</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Searching globally in a database or a subset of it</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.</span></li> <li><span style="color: #222222; font-size: 15px; line-height: 26px;">Working with different operating systems</span></li> </ul> <div style="line-height: 19.2px;"> <span style="color: #0b5394; font-family: 'Trebuchet MS', sans-serif;"><span style="line-height: 26px;"><u><span style="font-size: large;">Install phpMyAdmin</span></u></span></span></div> <div style="font-size: 12px; line-height: 19.2px;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.</span></span></div> <div style="line-height: 19.2px;"> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">yum -y update</span></span></span></pre> </div> <div style="font-size: 12px;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">After That Run Following Command:-</span></span></div> </div> <div style="line-height: 19.2px;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="line-height: 15.6px;"><span style="color: white;">yum -y install </span><span style="color: orange;">phpmyadmin</span></span></span></pre> </div> <div style="font-size: 12px; line-height: 19.2px;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">To secure <b>phpMyAdmin </b>we should lock down access to a specific IP address. When the phpMyAdmin package is installed, an Apache Virtual Host file is added to configure web access. Let’s edit that file:</span></span></div> <div style="line-height: 19.2px;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# vi </span><span style="line-height: 15.6px;"><span style="color: white;">/etc/httpd/conf.d/</span><span style="color: lime;">phpMyAdmin.conf</span></span></span></pre> </div> <div style="font-size: 12px; line-height: 19.2px;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">By default, the configuration for phpMyAdmin only allows access from the server on which it is installed. so you want to allow for all or you can only use your IP address for access..</span></span></div> </div> </div> <div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;"><div> Require ip 127.0.0.1</div> <div> <br /></div> <div> Allow from 127.0.0.1</div> <div> <br /></div> <div> Require ip 127.0.0.1</div> <div> <br /></div> <div> Allow from 127.0.0.1</div> <div> Allow from your IPadress ... </div> <div> Or </div> </span></span></div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Just Commit the following line </span></span><span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">"</span></span><span style="background-color: transparent; font-size: 15px; line-height: 26px;"><b><span style="color: red;">Deny from All</span></b><span style="color: #222222;">"</span></span></div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="line-height: 15.6px;"><span style="color: white;"> <span style="font-size: large;"><IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow </span></span><span style="font-size: large;"><span style="color: lime;"> #Deny from All </span><span style="color: white;"> Allow from 127.0.0.1 Allow from ::1 </IfModule></span></span></span><span style="font-family: 'Times New Roman'; font-size: 12px;"><span style="white-space: normal;"></span></span></pre> <div style="font-size: 12px;"> <span style="color: #222222; font-family: 'Trebuchet MS', sans-serif; font-size: medium;"><span style="line-height: 26px;"><b><u>Restart Apache:</u></b></span></span></div> </div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; line-height: 19.2px;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white;"><span style="line-height: 15.6px;"><span style="font-size: large;">service httpd restart</span></span></span></pre> <div> <div> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">Verify that phpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. </span></span></div> <div style="font-size: 12px;"> <span style="color: #222222;"><span style="font-size: 15px; line-height: 26px;">For example: http://demo.hackthesec.co.in/phpmyadmin</span></span></div> </div> </div> <div style="background-color: white; color: #333333; font-family: Verdana, Geneva, sans-serif; font-size: 12px; line-height: 19.2px;"> <span style="color: #222222; font-size: 15px; line-height: 26px;"><span style="color: #999999;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></span></div> </div> </div>

How to Install and Configure phpMyAdmin on Fedora 21

Install and Configure phpMyAdmin on Fedora phpMyAdmin  is a free and open source tool written in PHP intended to handle the administrat...

Read more »

How to Install and Configure phpMyAdmin on CentOS 6

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" style="background-color: white; border: 0px; box-sizing: inherit; font-family: proxima-nova, sans-serif; line-height: 3.4rem; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-size: large;"><u>Install and Configure phpMyAdmin on CentOS</u></span></h1> <div> <div style="background-color: white;"> <span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><b>phpMyAdmin </b>is a free and open source tool written in PHP intended to handle the administration of <a href="http://www.hackthesec.co.in/search/label/Mysql">MySQL</a> or <a href="http://www.hackthesec.co.in/search/label/MaraiDB">MariaDB </a>with the use of a web browser. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows; executing SQL statements; or managing users and permissions</span></span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">.</span></div> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNCpdbB4bEgUSF6aVH3Z9gWiTv9-Hq3fwF6NC8IVFj53JubxJK6MiF5hyphenhyphen7V9Ty5f3s8IUof1Rm0Xf2kp1feQ0P4TGrRcv1bl6tWXgMl5kFoTRwNYIs-OMsF4FaDZndJTeLyOtm2pGUba2f/s1600/login_phpmyadmin_www.hackthesec.co.in.png" /></a></div> <div style="background-color: white;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><br /></span></div> <div style="background-color: white;"> <span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Features</u></b></span></span></div> <div style="background-color: white;"> <ul style="text-align: left;"> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Web interface</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">MySQL and MariaDB database management</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Import data from CSV and SQL</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Export data to various formats: CSV, <a href="http://www.hackthesec.co.in/search/label/sql">SQL</a>, XML, PDF (via the TCPDF library), ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, Excel, LaTeX and others</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Administering multiple servers</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Creating PDF graphics of the database layout</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Creating complex queries using Query-by-Example (QBE)</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Searching globally in a database or a subset of it</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Live charts to monitor MySQL server activity like connections, processes, CPU/Memory usage, etc.</span></li> <li><span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;">Working with different operating systems</span></li> </ul> <div style="background-color: white;"> <span style="line-height: 26px;"><span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><b><u>Add the EPEL Repository</u></b></span></span></div> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/search/label/phpmyadmin">phpMyAdmin </a>is part of Extra Packages for Enterprise Linux (<a href="http://www.hackthesec.co.in/search/label/EPEL">EPEL</a>), which is a community repository of non-standard packages for the <a href="http://www.hackthesec.co.in/search/label/RHEL">RHEL</a> distribution. First, we’ll install the EPEL repository:</span></div> <div style="background-color: white;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">rpm -iUvh http://dl.fedoraproject.org/pub/epel/6/x86_64/epel-release-6-8.noarch.rpm</span></span></span></pre> </div> <div style="background-color: white;"> <span style="color: #0b5394; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><u>Install phpMyAdmin</u></span></span></div> <div style="background-color: white;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">First, you’ll follow a simple best practice: ensuring the list of available packages is up to date before installing anything new.</span></span></div> <div style="background-color: white;"> <div> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="color: white;"><span style="line-height: 15.6px;">yum -y update</span></span></span></pre> </div> <div> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">After That Run Following Command:-</span></span></div> </div> <div style="background-color: white;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# </span><span style="line-height: 15.6px;"><span style="color: white;">yum -y install </span><span style="color: orange;">phpmyadmin</span></span></span></pre> </div> <div style="background-color: white;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">To secure <b>phpMyAdmin </b>we should lock down access to a specific IP address. When the phpMyAdmin package is installed, an Apache Virtual Host file is added to configure web access. Let’s edit that file:</span></span></div> <div style="background-color: white;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white; line-height: 15.6px;">[root@hackthesec]# vi </span><span style="line-height: 15.6px;"><span style="color: white;">/etc/httpd/conf.d/</span><span style="color: lime;">phpMyAdmin.conf</span></span></span></pre> </div> <div style="background-color: white;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">By default, the configuration for phpMyAdmin only allows access from the server on which it is installed. so you want to allow for all or you can only use your IP address for access..</span></span></div> <div style="background-color: white;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;"><div> Require ip 127.0.0.1</div> <div> <br /></div> <div> Allow from 127.0.0.1</div> <div> <br /></div> <div> Require ip 127.0.0.1</div> <div> <br /></div> <div> Allow from 127.0.0.1</div> <div> Allow from your IPadress ... </div> <div> Or </div> </span></span></div> <div style="background-color: white;"> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Just Commit the following line </span></span><span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">"</span></span><span style="background-color: transparent; font-size: 15px; line-height: 26px;"><span style="font-family: Verdana, Geneva, sans-serif;"><b><span style="color: red;">Deny from All</span></b><span style="color: #222222;">"</span></span></span></div> <div style="background-color: white;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: medium;"><span style="line-height: 15.6px;"><span style="color: white;"> <IfModule !mod_authz_core.c> # Apache 2.2 Order Deny,Allow </span><span style="color: lime;"> #Deny from All </span><span style="color: white;"> Allow from 127.0.0.1 Allow from ::1 </IfModule></span></span></span><span style="font-family: Times New Roman;"><span style="white-space: normal;"> </span></span></pre> <div> <span style="color: #222222; font-family: Trebuchet MS, sans-serif; font-size: large;"><span style="line-height: 26px;"><b><u>Restart Apache:</u></b></span></span></div> </div> <div style="background-color: white;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="color: white; font-size: large;"><span style="line-height: 15.6px;">service httpd restart</span></span></pre> <div> <div> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">Verify that phpMyAdmin is working by visiting http://the_IP_of_your_server/phpmyadmin. </span></span></div> <div> <span style="color: #222222; font-family: Verdana, Geneva, sans-serif;"><span style="font-size: 15px; line-height: 26px;">For example: http://demo.hackthesec.co.in/phpmyadmin</span></span></div> </div> </div> <div> <span style="color: #222222; font-size: 15px; line-height: 26px;"><a href="http://www.hackthesec.co.in/">www.hackthesec.co.in</a></span></div> </div>

How to Install and Configure phpMyAdmin on CentOS 6

Install and Configure phpMyAdmin on CentOS phpMyAdmin is a free and open source tool written in PHP intended to handle the administrati...

Read more »

How To Install FreePBX on CentOS

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" itemprop="headline" style="background-color: #fdfdfd; box-sizing: border-box; font-family: proxima-nova, 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 39px; line-height: 1.1; margin: 21px 0px 0px;"> <u><span style="color: red;">Install FreePBX on CentOS</span></u></h1> <div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">PBX (stands for private branch exchange) is a private telephone network used that can be very easily connected to the public landline and mobile networks. The PBX network also provides audio, video and instant messaging communication through the TCP/IP protocol stack for its internal network and interconnects its internal network with the Public Switched Telephone Network (PSTN) for telephony communication.</span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggyfE0RGe3F6bNgKJwgmfEIGAcZp-aiPwwHnE7ozF_zlWvKp6oKjpXoSWvr5RXrWcAJ0XpN_TmttG36GOIdt3cSBN8CNZCjuQBl6Xmstji8pMAmlkpIxsB-Pgel9vbFNWYbrxi08fkUEOx/s1600/asterisk_centos_freepbx_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggyfE0RGe3F6bNgKJwgmfEIGAcZp-aiPwwHnE7ozF_zlWvKp6oKjpXoSWvr5RXrWcAJ0XpN_TmttG36GOIdt3cSBN8CNZCjuQBl6Xmstji8pMAmlkpIxsB-Pgel9vbFNWYbrxi08fkUEOx/s1600/asterisk_centos_freepbx_www.hackthesec.co.in.png" /></a></div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;"><br /></span></div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">A lot of successful businesses are aiming to have their own telephony system that will allow them to have many different features, lower their costs using VoIP, especially on international calls, but inside that company as well. Some of them are choosing hosted solution, some are having their own In-House solution. In this tutorial we are installing FreePBX & Asterisk VoIP on a base <a href="http://www.hackthesec.co.in/search/label/Centos" target="_blank">CentOS</a> 6.4 installation.</span></div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">Asterisk is an open source software implementation of a telephone private branch exchange (PBX); it was created in 1999. Like any PBX, it allows attached telephones to make calls to one another, and to connect to other telephone services, such as the public switched telephone network (PSTN) and Voice over Internet Protocol (VoIP) services. Its name comes from the asterisk symbol, *. Asterisk includes many features like Voice mail, conference calling, Interactive voice response, automatic call distribution, Fax to email services etc.</span></div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">In order to control Asterisk, we will use FreePBX. It is open source graphical user interface that makes asterisk management very easy. It is usually included in the asterisk distribution, but it can be installed manually if needed. FreePBX distribution is unified server distribution that includes all of the software packages and dependencies required for Asterisk VoIP server, such as:</span></div> <div style="background-color: #fdfdfd; box-sizing: border-box; margin-bottom: 10.5px;"> </div> <ul style="text-align: left;"> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;"><a href="http://www.hackthesec.co.in/search/label/Apache" target="_blank">Apache Web Server</a></span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Cyrus SASL (Simple Authentication Security Layer)</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Dnsmasq</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;"><a href="http://www.hackthesec.co.in/search/label/fail2ban" target="_blank">Fail2ban</a></span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;"><a href="http://www.hackthesec.co.in/search/label/Iptables" target="_blank">iptables</a></span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Mailx</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;"><a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL </a>Server</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Network Time Protocol</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;"><a href="http://www.hackthesec.co.in/search/label/VPN" target="_blank">OpenVPN </a>Server</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;"><a href="http://www.hackthesec.co.in/search/label/postfix" target="_blank">Postfix </a>MTA</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Prosody XMPP Server</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">TFTP Server</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Very Secure FTP Daemon (<a href="http://www.hackthesec.co.in/search/label/vsftp" target="_blank">vsftpd</a>)</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Vim text editor</span></li> </ul> <br /> <div style="background-color: #fdfdfd; box-sizing: border-box; margin-bottom: 10.5px;"> </div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">Before we start with the installation, we must make sure that the server has decent and stable internet connection and it should be in a geographical location near the place where the majority of our calls will come from. We also need to determine the size of our server. That will depends mostly on the number of the concurrent calls that we anticipate to have. It is not that bad even if we choose wrong, since we can resize our server at any time later, but some best practices showed that we should follow this calculations.</span></div> <div style="background-color: #fdfdfd; box-sizing: border-box; margin-bottom: 10.5px;"> </div> <ul style="text-align: left;"> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Server with 512 MB RAM can support approximately 5-15 concurrent calls</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Server with 1 GB can support approximately 15-25 concurrent calls</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Server with 2 GB can support approximately 25-50 concurrent calls</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Server with 4 GB can support approximately 50-100 concurrent calls</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Server with 8 GB can support approximately 100-175 concurrent calls</span></li> <li><span style="font-family: Georgia, 'Times New Roman', serif; font-size: 18px; line-height: 28px;">Server with 16 GB can support approximately 175+ concurrent calls</span></li> </ul> <br /> <div style="background-color: #fdfdfd; box-sizing: border-box; margin-bottom: 10.5px;"> </div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">Next, we must make sure that our fully qualified domain name is properly set in our hosts file and make sure that the server time setting match the appropriate time zone that server belongs to. The last step before we actually start with the installation is to update our currently installed packages from the standard <a href="http://www.hackthesec.co.in/search/label/Centos" target="_blank">CentOS </a>repositories:</span></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: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;"># yum update </code></pre> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">Now, we are ready to start the deployment. We will use installation script that we need to download. The script will download some file during the installation, so we will use <code style="background-color: #f9f2f4; border-radius: 4px; box-sizing: border-box; font-size: 16.2px; padding: 2px 4px;">/tmp</code> folder during the installations.</span></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: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;"># cd /tmp # wget http://upgrades.freepbxdistro.org/blank-centos-installer/5.211.65-track/5.211.65-1-Installer-Script.sh # /tmp/4.211.64-1-Installer-Script.sh </code></pre> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">Once it is finished, we will have fully functional IP-PBX server, based on the FreePBX Distribution. Now, we need to test if our GUI works. To do that, we will open our browser and point to the fully qualified name or the IP of our newly installed PBX, we will be presented with FreePBX administrator-account setup screen. We should setup our admin account using the GUI. That will be the information that we will use later for managing the server through the GUI.</span></div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">If we want to upgrade out FreePBX system later, we can search for available upgrades, download the upgrade script and execute it, similar to the installation process. First, we need to determine which our current version is:</span></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: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;"># cat /etc/schmooze/pbx-version </code></pre> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">Then, we can check the change list for the new version that is available and make decision whether we would like to upgrade or not. The upgrade process work same as the installation. The upgrade script might ask us for some additional information or confirmation. Once the upgrade is done we can check and confirm that our system is upgraded but executing:</span></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: 14px; line-height: 1.42857; margin-bottom: 10.5px; overflow: auto; padding: 10px; word-break: break-all; word-wrap: break-word;"><code style="background-color: transparent; border-radius: 0px; box-sizing: border-box; color: inherit; font-family: Menlo, Monaco, Consolas, 'Courier New', monospace; font-size: inherit; padding: 0px; white-space: pre-wrap;"># cat /etc/schmooze/pbx-version </code></pre> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;">If there is more than one upgrade script available, we should execute every upgrade script, one by one, is sequential order and save every script in the same folder. This Asterisk and OpenPBX server are part of a very wide field and there are a lot of additional things to be considered and explored. However, this tutorial underlines the very basic information and steps that are required in order to get our own PBX system up and running.</span></div> <div style="background-color: #fdfdfd; box-sizing: border-box; font-size: 18px; line-height: 28px; margin-bottom: 10.5px;"> <span style="font-family: Georgia, Times New Roman, serif;"><a href="http://hackthesec.co.in/" target="_blank">hackthesec.co.in</a><br /><a href="http://hackthesec.co.in/" target="_blank">hackthesec</a></span></div> </div> </div>

How To Install FreePBX on CentOS

Install FreePBX on CentOS PBX (stands for private branch exchange) is a private telephone network used that can be very easily connecte...

Read more »

How to Temporarily Disable Foreign Key Checks in MySQL

<div dir="ltr" style="text-align: left;" trbidi="on"> <h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <u><span style="color: red;"><i>Temporarily Disable Foreign Key Checks in MySQL</i></span></u></h2> <div> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: "georgia" , "times new roman" , serif;">You must have faced the foreign key constrains issues many times while working with <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL database</a>. Generally this issue occurred during delete, insert records, backup and restore database and drop database and drop tables. In this situation its hard to complete task. <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL </a>provides an option to disable foreign key checks during any operation on tables or databases. You can disable check and complete your task without any issues.</span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s1600/mysq-linux-www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="233" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjuoxi5s0F8G1O0EBBaQZsBkS53hGtJLk_5eq5KH15vOG2iLfA9nuLja5cUU2fWhS1X4g5P4ZlYYQqXwgEsl-yiFo4igoYjJqXmPJwPtqi0z2OfxgfDGLmW_NcgzWNb-Bd7hqB52-V5rAxI/s320/mysq-linux-www.hackthesec.co.in.jpg" width="320" /></a></div> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: "georgia" , "times new roman" , serif;"><br /></span></div> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: "georgia" , "times new roman" , serif;">This article will help you to how to enable or disable foreign key check in MySQL. Ever you faced foreign key error, Disable foreign key checks, do you work and enable it again.</span></div> <h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;"><u>Disable Foreign Key Checks</u></span></h3> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">SET </span><span style="color: lime;"><orange>FOREIGN_KEY_CHECKS</orange>=<orange>0</orange></span><span style="color: white;">; </span></span></pre> <h3 class="heading2" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;"><u>Enable Foreign Key Checks</u></span></h3> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: large;"><span style="color: white;">SET </span><span style="color: lime;"><orange>FOREIGN_KEY_CHECKS</orange>=<orange>1</orange></span><span style="color: white;">; </span></span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: "georgia" , "times new roman" , serif;">Remember that, do not forgot to re-enable foreign key checks again after doing your work.</span></div> <div style="background-color: white; border: 0px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: "georgia" , "times new roman" , serif;"><a href="http://www.hackthesec.co.in/" target="_blank">www.hackthesec.co.in</a><br /><span style="line-height: 28px;"><a href="http://www.hackthesec.co.in/search/label/Linux-Books">http://www.hackthesec.co.in/search/label/Linux-Books</a></span></span></div> </div> </div>

How to Temporarily Disable Foreign Key Checks in MySQL

Temporarily Disable Foreign Key Checks in MySQL You must have faced the foreign key constrains issues many times while working with MyS...

Read more »

Automated Linux Apache MySQL PHP or Nginx PHP-FPM MYSQL installation and configuration

<div dir="ltr" style="text-align: left;" trbidi="on"> <h1 class="entry-title" itemprop="headline" style="background-color: white; box-sizing: border-box; font-family: Oswald, Lato, Arial, sans-serif; line-height: 50px; margin: 0px 0px 5px; padding: 0px;"> <span style="color: red; font-size: large;"><u><i>Linux Apache MySQL PHP or Nginx PHP-FPM MYSQL </i></u></span></h1> <div> <div style="background-color: white; box-sizing: border-box; font-size: 16px; line-height: 1.8em; margin-bottom: 0.9em; margin-top: 0.9em;"> <span style="font-family: Georgia, Times New Roman, serif;">This is auto-installer for automatically install and configure apache or nginx with MySQL and <a href="http://www.hackthesec.co.in/search/label/PHP" target="_blank">PHP</a>. On install time Apache or nGinx script will ask about virtual host domain name. On install time for MySQL database script will ask questions about <a href="http://www.hackthesec.co.in/search/label/Mysql" target="_blank">MySQL </a>root pass, new database name, new username and password for the new user.</span></div> <div style="background-color: white; box-sizing: border-box; font-size: 16px; line-height: 1.8em; margin-bottom: 0.9em; margin-top: 0.9em;"> <span style="font-family: Georgia, Times New Roman, serif;">Main script is: <b><span style="color: red;">ap-ng-vhost.py</span></b></span></div> <div style="background-color: white; box-sizing: border-box; margin-bottom: 0.9em; margin-top: 0.9em;"> <div style="font-size: 16px; line-height: 1.8em;"> <span style="font-family: Georgia, Times New Roman, serif;">Requirements:</span></div> <ol style="box-sizing: border-box; font-size: 16px; line-height: 25.6px; margin: 0px 0px 15px 30px; padding: 0px;"> <li style="box-sizing: border-box;"><span style="font-family: Georgia, Times New Roman, serif;"><a href="http://www.hackthesec.co.in/search/label/Centos" target="_blank">CentOS</a> 6.7 or higher(or any yum based Linux).</span></li> <li style="box-sizing: border-box;"><span style="font-family: Georgia, Times New Roman, serif;"><b>Python2.7 </b>must be installed to your Linux server.</span></li> <li style="box-sizing: border-box;"><span style="font-family: Georgia, Times New Roman, serif;">Download all files to the Linux server and execute <b>ap-ng-vhost.py</b> script.<br /></span></li> </ol> <span style="font-family: Georgia, Times New Roman, serif;"><span style="font-size: 16px; line-height: 28.8px;">Just download all files from this </span><a href="http://www.mediafire.com/download/9nyzv6l6stjoy1u/engapng-mysql.zip" style="-webkit-tap-highlight-color: transparent; background-attachment: initial; background-clip: initial; background-image: initial; background-origin: initial; background-position: 0px 0px; background-repeat: initial; background-size: initial; box-sizing: border-box; font-size: 16px; line-height: 28.8px; text-decoration: none; transition: background 0.2s ease-out, color 0.2s ease-out;" target="_blank"><span style="color: #0b5394;">link</span></a><span style="font-size: 16px; line-height: 28.8px;"> to your Linux folder and execute </span><span style="box-sizing: border-box; font-size: 16px; font-weight: 700; line-height: 28.8px;">ap-ng-vhost.py</span><span style="font-size: 16px; line-height: 28.8px;"> script. For clean everything you must use</span><span style="box-sizing: border-box; color: red; font-size: 16px; line-height: 28.8px;"><span style="box-sizing: border-box; color: black; font-weight: 700;">./cleaner.sh</span></span><span style="line-height: 28.8px;"> script.<br /><br /><a href="http://www.mediafire.com/download/9nyzv6l6stjoy1u/engapng-mysql.zip" target="_blank"><span style="color: red; font-size: large;">Download Here</span></a></span></span></div> </div> <div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEial5ntIbqgcrwNb7jiagyV2aMhgXoZcfEwe4xsr0YSeWk6SpKOISPl1Nhc1I1qWdTwfUMushld9H3yuA0dD8oxgy4G8-ih0d5LDzndK-yW_zqiZFnt_g7WHJYsKNW3E6hu3F9bViVyr-Sn/s1600/Automatic_LAMP_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="332" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEial5ntIbqgcrwNb7jiagyV2aMhgXoZcfEwe4xsr0YSeWk6SpKOISPl1Nhc1I1qWdTwfUMushld9H3yuA0dD8oxgy4G8-ih0d5LDzndK-yW_zqiZFnt_g7WHJYsKNW3E6hu3F9bViVyr-Sn/s640/Automatic_LAMP_www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <span style="color: red; font-family: Georgia, Times New Roman, serif; font-size: large;">After that goto the unzipped folder and run this script : -</span><br /> <span style="color: red; font-family: Georgia, Times New Roman, serif; font-size: large;"></span><br /> <div style="background-color: white; color: #333333; line-height: 19.2px;"> </div> <br /> <div style="background-color: white; line-height: 19.2px;"> <pre style="background-attachment: scroll; background-clip: initial; background-color: #3c3c3c; background-image: none; background-origin: initial; background-position: 0px 0px; background-repeat: repeat; background-size: initial; border-image-outset: initial; border-image-repeat: initial; border-image-slice: initial; border-image-source: initial; border-image-width: initial; border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-size: medium;"><span style="color: white;">$ python </span><span style="color: lime;">ap-ng-vhost.py</span></span></pre> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXOY8NX86KaZTMC8oAG5h8c_fraeTp4JwvoxoeM_sGEZMX-KqMV3bUNXWD258YqAjj_m1qKHKlw-2IY_EHRuzPQ8bo5OTmN1HzY89os_HoxuehzzuUonlWPZhFSTMxepOeLcpYX9qh4HlA/s1600/LAMP_Select-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="150" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXOY8NX86KaZTMC8oAG5h8c_fraeTp4JwvoxoeM_sGEZMX-KqMV3bUNXWD258YqAjj_m1qKHKlw-2IY_EHRuzPQ8bo5OTmN1HzY89os_HoxuehzzuUonlWPZhFSTMxepOeLcpYX9qh4HlA/s640/LAMP_Select-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <span style="font-family: Georgia, Times New Roman, serif; font-size: large;">Write Virtual Domain Name </span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTJ2dWcpmr3QNn9AmM5H5W86TcVi_lBw9KMzQ1-jStTtF91Xz5ESoU8mqzk8v3sZ6u3DUQWVgKlDAsdbyU6Eae9DOW8NcxvK2u3hAxnHBMeJ6EAeFbIXn4gmogpO34DT6xDOfuWgFCbcgN/s1600/virtual_domain_selection-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="176" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTJ2dWcpmr3QNn9AmM5H5W86TcVi_lBw9KMzQ1-jStTtF91Xz5ESoU8mqzk8v3sZ6u3DUQWVgKlDAsdbyU6Eae9DOW8NcxvK2u3hAxnHBMeJ6EAeFbIXn4gmogpO34DT6xDOfuWgFCbcgN/s640/virtual_domain_selection-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />After that select </span><b><span style="font-family: Georgia, Times New Roman, serif; font-size: large;">PHP and Mysql Option 1</span></b></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhscq2jEYxsI9x5HiP4AX22tq9RrNm-9dbw9WKqsPPME-9HJf52Mx1q0o34BOTM6sjhOq1wWNvj-X5xylrmqk8FhI7HnYyIJ3r1lRckpeC3xIqWxXEZJBZzNlNg9NQrvlh-5p5GBKvmHIzQ/s1600/mysql_php_www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="94" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhscq2jEYxsI9x5HiP4AX22tq9RrNm-9dbw9WKqsPPME-9HJf52Mx1q0o34BOTM6sjhOq1wWNvj-X5xylrmqk8FhI7HnYyIJ3r1lRckpeC3xIqWxXEZJBZzNlNg9NQrvlh-5p5GBKvmHIzQ/s640/mysql_php_www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /></div> <div class="separator" style="clear: both; text-align: left;"> <span style="font-family: Georgia, Times New Roman, serif; font-size: large;">Set a MySql Server Password</span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbaXVElP48FDzSm7WbLLhEXlOFFDSfXGsQmJsIe1MDISBoCVDc0pn-GjvWKtwOjl8TUQqgbzxEACUurwJdCFe8J2FlVh8bq05T9OtcV0ilglTrgp9ndYZkv4Yzf4JrppSD0UUjjUuRTtD1/s1600/mysql_password-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="348" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhbaXVElP48FDzSm7WbLLhEXlOFFDSfXGsQmJsIe1MDISBoCVDc0pn-GjvWKtwOjl8TUQqgbzxEACUurwJdCFe8J2FlVh8bq05T9OtcV0ilglTrgp9ndYZkv4Yzf4JrppSD0UUjjUuRTtD1/s640/mysql_password-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx56eT5ULu7k9l2ryzkzBrz8ibHHMw3Slk6YgUEh0fZ91IsWGrx0X3PioYO8ETkIwQ2hKc8S0-fhmsnNAPkdc5WP0Qo8Vn_TmAB478Lu7claCIizyN0hYws2j3XAxRL5x7iPZXmX70yPfL/s1600/apache_installation-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="324" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhx56eT5ULu7k9l2ryzkzBrz8ibHHMw3Slk6YgUEh0fZ91IsWGrx0X3PioYO8ETkIwQ2hKc8S0-fhmsnNAPkdc5WP0Qo8Vn_TmAB478Lu7claCIizyN0hYws2j3XAxRL5x7iPZXmX70yPfL/s640/apache_installation-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: left;"> <br /><span style="font-family: Georgia, Times New Roman, serif; font-size: large;"><br />After That Done Now Select 2nd Option</span></div> <div class="separator" style="clear: both; text-align: center;"> </div> <br /> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM8FpyiNffOKM00q_ktbHbo0UyOckpE79LQDo_RtpQMfAM3nxHzD-vWE7NkAjGKssrGUe_t_0cfcpc7A97g67-I6IDVNBtnKJYvybwQAzeCt9RVa6RSESPczvIDYPgvEuE5q-4cQEErCoA/s1600/nginx_installation-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="122" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhM8FpyiNffOKM00q_ktbHbo0UyOckpE79LQDo_RtpQMfAM3nxHzD-vWE7NkAjGKssrGUe_t_0cfcpc7A97g67-I6IDVNBtnKJYvybwQAzeCt9RVa6RSESPczvIDYPgvEuE5q-4cQEErCoA/s640/nginx_installation-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <span style="font-family: Georgia, 'Times New Roman', serif; font-size: large; text-align: left;">Write Virtual Domain Name </span></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1ALZKaFro1Y6c2LMQj3_BxhVvuemY9jZcGfjjO_XC4qB1LkfDS_jCmzxV2MwwWY4PjJ3nSoGqTE2uHyCwDzHNDqzLqPF6wApiRsKeVQmu3ZqNlJuKv-0IgPYUsTeIj4kX_7H-3EwPgtei/s1600/nginx_virtual_domain-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="100" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1ALZKaFro1Y6c2LMQj3_BxhVvuemY9jZcGfjjO_XC4qB1LkfDS_jCmzxV2MwwWY4PjJ3nSoGqTE2uHyCwDzHNDqzLqPF6wApiRsKeVQmu3ZqNlJuKv-0IgPYUsTeIj4kX_7H-3EwPgtei/s640/nginx_virtual_domain-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <span style="font-family: Georgia, 'Times New Roman', serif; font-size: large; text-align: left;"><br /></span></div> <div class="separator" style="clear: both; text-align: center;"> <span style="font-family: Georgia, Times New Roman, serif; font-size: large; text-align: left;">After that select </span><b style="text-align: left;"><span style="font-family: Georgia, Times New Roman, serif; font-size: large;">PHP and Mysql Option 1</span></b></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifvR8o4zPofAy4kOKig5RqLiZ5IsJkuBvJqy9mKfWCnflmbsl_lCT2YlqB1U0gAyqCCWtYUXsB9H6P7PEES7u3WV4KP8ZlS7t6jXn3QU2pb8PV0nrC4Y0C2ZlKuDa3dIhxGdKNeZ-0MrdG/s1600/PHP-FPM_nginx-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="124" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEifvR8o4zPofAy4kOKig5RqLiZ5IsJkuBvJqy9mKfWCnflmbsl_lCT2YlqB1U0gAyqCCWtYUXsB9H6P7PEES7u3WV4KP8ZlS7t6jXn3QU2pb8PV0nrC4Y0C2ZlKuDa3dIhxGdKNeZ-0MrdG/s640/PHP-FPM_nginx-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <span style="font-family: Georgia, Times New Roman, serif; font-size: large;">Installation Done</span></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYDf5OSuAQrg4Uo__selyxgu50MCgoIajx2OqhjCOn5ogz692jkEmLg6FpFY0T5ZT1YXoFnjf6bjN6vd_ikdplHDEo9XCbsi7kePQnlUROoCPlQbasD-ZPIfFMoz0xO0mDB0-gNeG4UgpX/s1600/nginx_done-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="160" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgYDf5OSuAQrg4Uo__selyxgu50MCgoIajx2OqhjCOn5ogz692jkEmLg6FpFY0T5ZT1YXoFnjf6bjN6vd_ikdplHDEo9XCbsi7kePQnlUROoCPlQbasD-ZPIfFMoz0xO0mDB0-gNeG4UgpX/s640/nginx_done-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <br /></div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhubVfjXXXvWd_FHMReQIl1uBWmiwJpb-3DYoYpqUfhnahcDOQFC99adQ38CmUJzVnIrC5glvMVuqAjr76oGAhCbNkgkKyobp6GqZ_zeeX5nrelKD8ijvcxMmXGYNMbWTAAhSo32jsUtW3l/s1600/nginx-installation-www.hackthesec.co.in.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhubVfjXXXvWd_FHMReQIl1uBWmiwJpb-3DYoYpqUfhnahcDOQFC99adQ38CmUJzVnIrC5glvMVuqAjr76oGAhCbNkgkKyobp6GqZ_zeeX5nrelKD8ijvcxMmXGYNMbWTAAhSo32jsUtW3l/s640/nginx-installation-www.hackthesec.co.in.png" width="640" /></a></div> <div class="separator" style="clear: both; text-align: center;"> <a href="http://www.hackthesec.co.in/" target="_blank">www.hackthesec.co.in</a><br /><a href="http://www.twitter.com/hackthesec.co.in">www.twitter.com/hackthesec.co.in</a><br /><a href="http://www.hackthesec.co.in/p/about-us.html" target="_blank">http://www.hackthesec.co.in/p/about-us.html</a></div> </div> </div>

Automated Linux Apache MySQL PHP or Nginx PHP-FPM MYSQL installation and configuration

Linux Apache MySQL PHP or Nginx PHP-FPM MYSQL  This is auto-installer for automatically install and configure apache or nginx with MySQ...

Read more »

How to Install PHP 7.0 Apache 2.4, and MySQL 5.6 on CentOS / RHEL 7.1 and 6.7

<div dir="ltr" style="text-align: left;" trbidi="on"> <h2 class="title single-title title20" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 28px; line-height: 38px; margin: 0px 0px 5px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #cc0000;"><u><i>Install PHP 7.0, Apache 2.4, & MySQL 5.6 on CentOS / RHEL 7.1 & 6.7</i></u></span></h2> <div> <span style="font-family: Georgia, Times New Roman, serif;"><span style="background-color: white; font-size: 16px; line-height: 28px;">Few days ago most awaited PHP version 7.0 has been released. which has many number of changes and improvements than over version 5.X. This article will help you to install PHP 7 Apache 2.4 and MySQL 5.6 on CentOS / RHEL 7.1 & 6.7 operating systems. This tutorial has been tested with CentOS 7.1, so all the services command are used with systemctl, For CentOS 6 users change all </span><span style="background-color: white; border: 0px; font-size: 16px; font-weight: 700; line-height: 28px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">systemctl</span><span style="background-color: white; font-size: 16px; line-height: 28px;"> command correspondence </span><span style="background-color: white; border: 0px; font-size: 16px; font-weight: 700; line-height: 28px; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;">service</span><span style="background-color: white; font-size: 16px; line-height: 28px;"> command.</span></span></div> <div> <ul style="text-align: left;"> <li><span style="color: red; font-family: Georgia, Times New Roman, serif; font-size: large;"><span style="line-height: 28px;"><a href="http://www.hackthesec.co.in/2016/01/how-to-install-epel-repo-on-centos-and.html" target="_blank">How To Install EPEL REPO On CENTOS/RHEL7</a></span></span></li> </ul> </div> <div class="separator" style="clear: both; text-align: center;"> <a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJoeYZS4TciTZ5h8zPyk6yAgWN1nXSqVQg7-7vOdGXLov424LOczDnrhYh50_DIAVe7jh361YvtW5siZOLgvU5h2dah0smgKJrtxEDc3_Iz04dCEBe20YO0HUlFeXOZrNNMaAvzH27V7Bv/s1600/LAMP_CENTOS_www.hackthesec.co.in.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="204" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjJoeYZS4TciTZ5h8zPyk6yAgWN1nXSqVQg7-7vOdGXLov424LOczDnrhYh50_DIAVe7jh361YvtW5siZOLgvU5h2dah0smgKJrtxEDc3_Iz04dCEBe20YO0HUlFeXOZrNNMaAvzH27V7Bv/s320/LAMP_CENTOS_www.hackthesec.co.in.jpg" width="320" /></a></div> <div> <h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;">1. Setup Yum Repository</span></h2> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">In the first step install all the required yum repositories in your system used in remaining tutorial for various installations. You are adding REMI, <a href="http://www.hackthesec.co.in/2016/01/how-to-install-epel-repo-on-centos-and.html" target="_blank">EPEL</a>, Webtatic & MySQL community server repositories in your system.</span></div> <h3 class="heading2" style="background-color: white; border: 0px; color: #0379bf; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> CentOS / RHEL 7</h3> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># yum </span><span style="color: lime;">install epel-release</span><span style="color: white;"> # rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-7.rpm </span><span style="color: lime;"># rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm </span><span style="color: white;"># rpm -Uvh http://repo.mysql.com/mysql-community-release-el7-5.noarch.rpm</span></span><span style="color: white; font-size: 0.9em;"> </span></pre> <h3 class="heading2" style="background-color: white; border: 0px; color: #0379bf; font-family: 'Roboto Slab'; font-size: 20px; font-weight: bolder; line-height: 30px; margin: 0px 0px 8px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> CentOS / RHEL 6</h3> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># yum install epel-release </span><span style="color: lime;"># rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm </span><span style="color: white;"># rpm -Uvh https://mirror.webtatic.com/yum/el6/latest.rpm # rpm -Uvh http://repo.mysql.com/mysql-community-release-el6-5.noarch.rpm</span></span><span style="color: white; font-size: 0.9em;"> </span></pre> <h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;">2. Install PHP 7</span></h2> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Now install php 7 packages from webtatic rpm repository using following command.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># yum </span><span style="color: lime;">install php70w</span><span style="color: white;"> </span></span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Now install required php modules. Use following command to list available modules in yum repositories.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># yum search </span><span style="color: lime;">php70w</span><span style="color: white;"> </span></span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Now check all listed modules in above command and install required modules like below.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># yum install </span><span style="color: lime;">php70w-mysql php70w-xml php70w-soap php70w-xmlrpc </span><span style="color: white;"> # yum install php70w-mbstring php70w-json php70w-gd </span><span style="color: lime;">php70w-mcrypt</span></span><span style="color: white; font-size: 0.9em;"> </span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">After installing php and other php modules restart Apache service.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># systemctl </span><span style="color: lime;"><orange>restart</orange> httpd.service</span><span style="color: white;"> </span></span></pre> <h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;">3. Install Apache 2.4</span></h2> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Apache (HTTPD) is the most popular web server used on Linux systems. Let’s install Apache web server using following command with enabling epel and remi yum repositories.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># yum --enablerepo=</span><span style="color: lime;"><orange>epel,remi</orange> install httpd</span><span style="color: white;"> </span></span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Now start httpd service and enable to start on boot using below commands.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># </span><span style="color: lime;">systemctl <orange>start</orange></span><span style="color: white;"> httpd.service # systemctl </span><orange style="color: orange;">enabel</orange><span style="color: white;"> httpd.service</span></span><span style="color: white; font-size: 0.9em;"> </span></pre> <h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;">4. Install MySQL 5.6</span></h2> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">In step 1 we already have installed required yum repository in your system. Lets use following command to install MySQL server on your system.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"><span style="color: white;"># yum </span><span style="color: lime;"><orange>install</orange> mysql-server</span><span style="color: white;"> </span></span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Apply security on mysql and also set root user password.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"># systemctl <orange style="color: orange;">start</orange> mysqld.service # mysql_secure_installation</span><span style="font-size: 0.9em;"> </span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Now restart MySQL service and enable to start on system boot.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"># systemctl <orange style="color: orange;">restart</orange> mysqld.service # systemctl <orange style="color: orange;">enable</orange> mysqld.service</span><span style="font-size: 0.9em;"> </span></pre> <h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;">5. Open Port in Firewall</span></h2> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Finally open firewall ports for http (80) and https (443) services using following command.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"># firewall-cmd --permanent --zone=public --add-service=<orange style="color: orange;">http</orange> # firewall-cmd --permanent --zone=public --add-service=<orange style="color: orange;">https</orange> # firewall-cmd --reload</span><span style="font-size: 0.9em;"> </span></pre> <h2 class="heading1" style="background-color: white; border: 0px; font-family: 'Roboto Slab'; font-size: 24px; font-weight: bolder; line-height: 34px; margin: 45px 0px 12px; opacity: 1; outline: 0px; padding: 0px; transition: opacity 0.24s ease-in-out; vertical-align: baseline; visibility: visible;"> <span style="color: #0b5394;">6. Check Installed Version</span></h2> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Let’s check the installed versions of packages on system using following commands one by one.</span></div> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"># <orange style="color: orange;">php -v</orange> <orange style="color: orange;">PHP 7.0.0</orange> (cli) (built: Feb 2 2016 20:42:32) ( NTS ) Copyright (c) 1997-2015 The PHP Group Zend Engine v3.0.0, Copyright (c) 1998-2015 Zend Technologies </span><span style="font-size: 0.9em;"> </span></pre> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"># <orange style="color: orange;">httpd -v</orange> Server version: <orange style="color: orange;">Apache/2.4.6</orange> (CentOS) </span><span style="font-size: 0.9em;"> </span></pre> <pre style="background: none 0px 0px repeat scroll rgb(60, 60, 60); border-radius: 4px; border: 1px solid rgb(229, 229, 229); color: white; line-height: 1.3em; margin-bottom: 20px; outline: 0px; overflow: auto; padding: 20px; vertical-align: baseline;"><span style="font-family: Courier New, Courier, monospace; font-size: large;"># <orange style="color: orange;">mysql -V</orange> mysql Ver 14.14 Distrib <orange style="color: orange;">5.6.28</orange>, for Linux (x86_64) using EditLine wrapper</span><span style="font-size: 0.9em;"> </span></pre> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;">Now you have successfully configured LAMP setup on your CentOS / RHEL 7.1 & 6.7 system.</span></div> <div style="background-color: white; border: 0px; font-size: 16px; line-height: 28px; margin-bottom: 20px; outline: 0px; padding: 0px; vertical-align: baseline;"> <span style="font-family: Georgia, Times New Roman, serif;"><a href="http://www.hackthesec.co.in/" target="_blank">www.hackthesec.co.in</a><br /><a href="http://www.twitter.com/hackthesecurity">www.twitter.com/hackthesecurity</a></span></div> </div> </div>

How to Install PHP 7.0 Apache 2.4, and MySQL 5.6 on CentOS / RHEL 7.1 and 6.7

Install PHP 7.0, Apache 2.4, & MySQL 5.6 on CentOS / RHEL 7.1 & 6.7 Few days ago most awaited PHP version 7.0 has been released....

Read more »