centos 8 ffmpeg

How to Install and Use FFmpeg on CentOS 8 Latest 2021

Installing FFmpeg on CentOS 8FFmpeg is not available in the default CentOS 8 repositories. You can choose to build the FFmpeg tools from the source or to install it using dnf from the Negativo17 repository. We’ll go with the second option. Complete the following steps to install FFmpeg on CentOS 8: The Negativo17 repository depends […]

Continue Reading
ffmpeg

How to Install and Use FFmpeg on CentOS 7 Working php video preview*

FFmpeg is not available in CentOS 7 core repositories. You can choose to build the FFmpeg tools from the source or to install it via yum from a third-party Yum repository. We’ll go with the second option and install from the RPM Fusion repository: The RPM Fusion repository depends on the EPEL software repository. If […]

Continue Reading

PostgreSQL Installation or Upgrade and restore previous version in cpanel

PostgreSQL Installation or Upgrade If you wish the installation, upgrade, and configuration of the PostgreSQL on your server, then follow the given steps. Use /usr/local/cpanel/scripts/installpostgres commandTh This command upgrades or installs PostgreSQL. ConfigurePostgreSQL interface of WHM must be accessed through WHM >> Home >> SQL Services >> Configure PostgreSQL In case PostgreSQL does not exist […]

Continue Reading
install cpanel centos 7

How to install cPanel/WHM on CentOS 7 and Configuration Guide

How to install cPanel/WHM on CentOS 7 Installation Requirements A clean fresh minimal installation of CentOS 7 server. Minimum of 1 GB RAM (but 2 GB recommended). At least 20GB of free disk space (but 40 GB recommended). A valid cPanel license. Standard hostname (FQDN or Fully Qualified Domain Name) Perl Before we proceed to the […]

Continue Reading

How to resolve “ORDER BY clause is not in SELECT list” caused MySQL 5.7 with SELECT DISTINCT and ORDER BY

If you have control of the server and you are running legacy code you can’t easily change, you can adjust the SQL mode of the server and remove “only_full_group_by” either for the duration of boot, by running the query SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,’ONLY_FULL_GROUP_BY’,”));’ or by adding sql_mode=” to your my.cnf file. Obviously its better to change your code if […]

Continue Reading

change Apache Port Number on a cPanel Server

Apache is a widely-used web server that is distributed under “open source” license. By default, Apache uses port 80 and secure port 443. You can change the port through WHM or from the cli. Follow the below Steps to change Apache port number through WHM. 1) Login to WHM through https://yourserverIP:2087 2) Go to ‘Tweak Settings’. […]

Continue Reading

Mysql Consume High Server resource Then Optimization of MySQL settings

Why does MySQL consume high memory? Application software like Python, PHP, JAVA threads utilize more memory when configured improperly or un-optimized queries, complex coding, etc. Due to improper configuration of MySQL, it leads to inefficient memory or wastage of memory. If the memory is lower than, required by the processes on the server. Resolutions to […]

Continue Reading