CentOS

Fix SQL Error: GROUP BY incompatible with sql_mode=only_full_group_by

MySQL 5.7.5+ changed the GROUP BY behavior. So in this and future versions GROUP BY would not work in same way as it used to be before.

So to make GROUP BY feature working like before follow these details:

Note: First of all to follow these steps you must need to have root access to your server.

If you want to disable error sql_mode=only_full_group_by  […]

PHP: How to run / execute a script in the background forever through SSH ?

You can execute a php script in the background forever by using SSH through PHP but for that you have to make sure first that SSH2 extension is available.

PHP DOCS: http://www.php.net/manual/en/function.ssh2-exec.php

If you want to do same thing through SSH Terminal (PuTTY) then follow this tutorial:
SSH: how to run a PHP script in background forever in Linux (CentOS) ? […]

SSH: how to run a PHP script in background forever in Linux (CentOS) ?

If you want to run a PHP script in the background forever through SSH then follow these steps:

If you are using a SSH terminal (PuTTY) then directly run following command:

Now your script is running in background and will keep running indefinitely even after closing terminal.

To check if your script is running or not You can run following command:

If you want to […]

CentOS: how to execute a php file with different php version than the php version of OS

To execute a php file with different php version than the version installed on the main php of your Server follow this:

You should know that where is that php version located so that you can add the path.

In my case I want to use PHP 7 that is installed in the plesk hosting panel folder so I’ll run following command:

 /opt/plesk/php/7.0/bin/php server.php

In […]

How to install Plesk on Linux CentOS?

Download the autoinstaller from our website:

Add execute permissions to the autoinstaller:

Launch the autoinstaller:

If upgrading Plesk from a lower version:
Command line:

GUI (Graphical user interface):

For more information, please refer to Plesk Installation guide.

Tested on CentOS 6.7 x64

Source: https://kb.plesk.com/en/119521 […]

How to install Node.js on Linux CentOS from the EPEL Repository?

An alternative installation method uses the EPEL (Extra Packages for Enterprise Linux) repository that is available for CentOS and related distributions.

To gain access to the EPEL repo, you must modify the repo-list of your installation. Fortunately, we can reconfigure access to this repository by installing a package available in our current repos called epel-release.

sudo yum install epel-release
Now that you have access to the […]